Creating a markbook using Google Sheets

Last week, my colleague and I were honoured to once again lead a 3-day workshop for educators through ETFO.  There were many wonderful, yet nervous peers, but once we got going, they really owned their learning.

As per usual, we over-planned, and alluded to many other things we would have liked to teach, and one of the topics that was broached numerous times was, "How do I set up my online markbook?"

This was a great question because there are a few tricks and tips that educators should follow in order to save themselves some time.

I will outline the steps, as well as provide a Youtube video below.  Hope this helps.

Step 1:
Create a folder in your drive titled "Marking <year> <grade level>"  (Example: Marking 2015-16)

Step 2:
Create a sheet called "Master Class List"


Once in the sheet:

Step 3:
Label the first 2 columns - Last Name   - First Name

Step 4:
View>  Freeze  (here you will freeze 1 Row and 2 Columns) - You will have to do each one separately.

Step 5:
Input the student names in columns A and B
The row 1 will be where you put the assessment titles throughout the year

Step 6:
Rename your sheet to "Term 1"

Step 7:
Conditionally Format your cells

Step 8:
Duplicate your Sheet and rename it "Term 2"

Step 9:
Make copies of your Master List for each subject/strand that you teach and rename them

Step 10: (Optional)
Make folders within your marking folder and organize them by subject

Contact me at: parkerri@hdsb.ca if you have any questions, or follow me on Twitter @TeacherParker