Timing and Placing the Scores
Timing grades with the year.
Should I put grades in specific cells?
Yes, the image below shows where to add grades that were earned during certain periods in the school year. If image is small, click on it to see full-sized image.
There are 180 cells for daily grades and 36 cells for tests/special grades.
Enter the grades in sequence without spaces or by some sort of date system (the fifth column could represent Friday for instance). A comment regarding a particular grade entry can be added to any of the cells.
In the far right side of each subject worksheet, the grades will average in several ways, plain averages for the daily and test column, quarterly averages and 6-week averages.
You can add more rows if you need them. The formulas will adjust
automatically as long as the sheet is unprotected when you add the rows.
To add a row, 1. Unprotect the sheet, right-click in the row numbers on the far-left hand side of the sheet in the area where you need a new row. 2. Choose Insert.
If inserting rows, be sure to insert the row where you need it, not necessarily at the bottom, but where you need to add more cells for grades for the certain term in the school year. As always, when making changes to G&A, check the formula to make certain that it changed to reflect the new rows.
Set Up: Quick Start Guide - Information Tab |
Subject Tabs - Adjusting the Grade Weight |
Subject Tabs - Credits |
Set up Your Grade Scale |
Enter Attendance - Calendar Tab |
How to Change the Date on the G&A Calendar |
FAQs: FAQs - Frequently Asked Questions | I can't see the Tabs: Minimized vs Maximized | Print Preview and Printing | Timing and Placing the Scores | How to Unprotect and Protect a Sheet | Not Using the Grade Weight | Year-Round Schooling Changes - Change number of months in school year. | Year-Round Schooling Changes - Changing the Semester in Print
I am currently working on this website to add to its ginormousness. Thank you for visiting, and please subscribe yearly to access my many printable files! Donna Young
May 13, 2021