If you do not see the tabs, maximize the file. Keyboard shortcut to maximize Ctrl F10. See also: 12-16 Help
Worksheets 1-12 receives information from INFO. The words that you typed into INFO are picked up in each of the 1-12 worksheets. Do not type anything in row 1 of the 1-12 worksheets.
In rows 26, 51, 79, & 104 there is a place for a quarterly Opt: Project. This Opt: Project can be an extra assignment such as a project or it can be used for a quarterly test.
Optional: This feature is completely optional! If you do not have a quarterly test or a project that is so important that it would count as part of the quarterly grade, then Leave the Score Cell Blank. The score cells are C26, C51, C79, & C104.
Pictured above: The score field is empty.
Pictured above: The score field has 87%.
Weight of Opt: Project: If you decide to use the quarterly Opt: Project you should decide what percentage of the quarterly score that the project/test grade will take from the quarterly average. The weight of the project/test is changed in cells B26, B51, B79, & B104. They are currently set at 20%.
The semester test score fields are optional. If you do not give a semester test, then leave the test score fields blank. If you do give a test, decide what percentage that the semester test will take from the semester average. Enter the number next to the Semester Exam % cells. It is currently set at 30%. The semester grades will automatically appear if you use the semester exam option. You will see both semester scores, the one with the exam factored in and the score without the semester score.
I recommend that if you need to unprotect the worksheets, that you protect them again as soon as you are finished with what you needed to do. For instance, to add an image to a worksheet, the worksheet must be unprotected. Be particular when the worksheets are unprotected. Removing data from some of the cells renders the grade keeper useless. Please keep the worksheets protected!