By Arnoldus Hoefnagel at May 08 2019 04:35:31
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.
Math worksheets don't provide immediate feedback _ Most teachers are familiar with the long delay between when students complete a worksheet, and when they get their correct page. Most don't get anything back until the next day or the next week. In the meantime, the students continue to practice incorrectly. It's no surprise that immediate feedback has been shown to increase student performance and diligence. Unfortunately, math worksheets have no mechanism for keeping a student from moving to the next problem until after they demonstrate understanding.