Student evidence record with Google Spreadsheet

Before you read onwards, you should probably read my other post about the different strategies for assessment (since I think it's more important than this sheet, because it's just a tool), as well as what I did before with excel.

I have to first thank @newmanmath for setting this up with me initially a year or two ago - that I've been using and modifying ever since.

Also if you're interested, @MathletePearce, @MrOrr_geek, and @alicekeeler have recently been working on something similar with Google Spreadsheet.  You can start reading about some of them through this post.

They have done thing slightly differently, but it's really cool to see that we have converged on similar ideas for student access.

But in any case this post is strictly technical.

First I should show the different features of what it looks like.

This is what students see

On the left side it indicates the major strands of the course, and then it is subdivided by expectations.

At one point I also had a "feedback" tab on the bottom

But the main idea is that I would have a master sheet where I load everything: scores for each assessment, feedback...etc...

So the first important thing is the setup of the mastersheet, where I call the tab "evidence"

Note how it is set up, down to the number of rows on the top.

All of the work is actually done on the second sheet.  And then you would need to set up a second sheet - where we will be using Doctopus to create duplicates with.  I won't get into the Doctopus part of things because I think that would take bit longer, but the Doctopus Add on has pretty good tutorials for it.  It's a convenient way to make duplicates for each student.

Okay so onto this second sheet I was talking about.  I will try to break it down to steps.  But first, you can take a look at this dummy sheet.  It has a lot of reference errors (since I removed the sheet that it was referring to), but all the major codes are there (minus the feedback tab)

1. On the second sheet you begin with this code on the top left:

What this is doing is calling the information from the master spreadsheet, and then using what I indicated in the "Gears" tab to call up each student's information.  Note that this calls info from "gears" which is a new tab you would have to create on the bottom.  This helps differentiate between different students for each one of those sheets.

2. The Gears tab has several elements to it

The first one is just the Google code that I placed, and the rest you can find the codes in the dummy file that I attached.

So once you navigate through all the codes, it will transport all the info from the master sheet to each individual one.

I was a bit more ambitious when I started typing this out... but then realized that it would actually take significantly longer to explain each of the codes.  However, with the dummy spreadsheet, it should help those of you who are comfortable with Google Spreadsheet to begin with!  Let me know if you need elaborations.