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.


Notable Points

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.

Help Pages

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

Hello Visitor!

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

Donna Young

Lesson Planner with a Calendar

what color is my crayon?

Targeted Manuscript Handwriting Lessons

You are at DonnaYoung.org, online since 1998. Thank you for visiting my website. Donna Young

Back to Top