By Riley Scaddan at April 09 2019 09:00:26
How do you copy a worksheet with a master format such as a quarterly or monthly layout? Please don't say copy and paste! This choice does not give you an exact copy and you'll waste tons of time trying to re_format columns and re_create other formatting. Although the worksheet tab shortcut menu is one way to copy, especially across workbooks (the Move or Copy option), a fast and easy approach is to hold [Ctrl] while dragging a worksheet tab to a new location in the workbook. Your mouse pointer will look like a page with a plus (+) sign. Release the mouse first and then [Ctrl] to see the new worksheet. Finish by renaming the copy.
Are the digits on the printed page large or small? In my opinion and within reason, the numbers can never be too large. Exhibiting stress at an early age on elementary studentsí eyes from staring at small print can lead to stronger prescription lenses. Whereís the answer sheet? Are the answers correct? Are the answers listed in a column that you have to match with the student worksheets or on a replica of the student page laced with answers? Last thing you need is to be in a hurry and red mark student worksheets...when their answers were correct all along.
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.
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.