Set Up a Page

Now that the framework is done, it’s time to add the details.  For each subject, I decide what categories of grades I’ll need.  In this example, art, I have weekly projects, and three term exams.  At the bottom I have a grade calculator, but more on that later.

I then make a place to record each grade.  For a subject that had a workbook, I would label each grade by worksheet number instead of weekly assignment.  However the entries are named, it’s very useful to have each identified.  I have two columns that follow the name of the assignment; the points given, and the total possible points.  Since exams will only be one grade per term, I didn’t give them their own block as I did for the projects, though I could have if I had felt they needed it, or I had more tests.

Once all the grades have a place and a name, it’s time to finish the formatting.  I love adding borders to cells to keep everything clear and organized looking.

Step 3 – Adding it Up >