By Colette Frechette at May 04 2019 13:55:59
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.
Engagement entails much more than rote repetition of a procedure. Math worksheets tend to present very similar problem types over and over, leading to mundane practice of disassociated skills. For students who understand the material and successfully complete an assignment, another worksheet becomes meaningless. On the other hand, for the students who don't understand the material, an alternative method of instruction is what's needed. Another worksheet simply adds to the student's frustration, or worse, contributes to a belief that "I'll never understand math." A cute image or a "fill_in_the_blanks" riddle does nothing to increase engagement or learning (and let's face it, those riddles are not funny!). Instead, teachers need to increase engagement by providing students with exercises in which they discover patterns and relationships, solve problems, or think creatively about math relationships.