By Colette Frechette at August 17 2019 14:46:39
Linking by creating a formula. With this method you can create an inter_active link between worksheets or workbooks. The linked cells do not need to be in the same location on all worksheets. You can perform any math operation while creating the link. For example, you could take a figure from one worksheet, multiply it times a figure form another worksheet and then subtract a number from a third worksheet. You can use this method to link cells across worksheets or workbooks. One disadvantage of this method is that it is time consuming because you are working with one cell at a time. Using named ranges can assist with this method of linking and make it easier to read your formulas once they are created.
Problems should use the Courier font. Why? Every Courier font character uses the same amount of space. A comma is the same width as the number 5. This means that all of the numbers line up perfectly for carrying during addition and bringing the zero down in division. Are the problems too close together? Make sure you can distinguish between the problem number and the actual problems. The problem numbers should be less obtrusive. Students with and without ADD and ADHD can become distracted by too many distractions!? Are there too many problems on the page? Some authors attempt to pack in the problems, leaving little room for students to show their work. The opposite can also be the case. Maybe there are not enough problems to accurately assess student knowledge.