By Gaspar Desnoyers at July 21 2019 07:48:12
Creating a Sum across worksheets. This is also an inter_active link. If a number changes on one worksheet, the sheet with the summary formula will also be updated. If a worksheet is inserted between worksheets in the sum, the sum will automatically be updated. Some of the disadvantages of this method are that all of the linked cells must be in the same location on all worksheets. Also, you can only sum one cell at a time (although you can copy the formula to other cells in the summary worksheet.) Using group mode to create identical spreadsheets will help when using the sum function across worksheets. This method is also limited to within a workbook and cannot be done across workbooks.
If you are fortunate enough to have an interactive whiteboard in your classroom, using it with interactive math software creates many opportunities for group discussion and student participation. Teachers can can begin by posing problems and modeling approaches, and then ask students to work together to find solutions. Then have them come to the board to demonstrate their solutions in front of the class. These days, many examples of how to teach math concepts on an interactive whiteboard can be found online in the various whiteboard community sites, educational sites, YouTube, etc.