Wednesday, September 21, 2011

Google Assessments Class and Student Progress Dashboard

I've wanted to be able to do this for a long time. Finally figuring out a way around the Google limitation on 50 importrange functions (if you have no idea what I'm talking about, stick with me), I can now look at assessment data from Google forms pulled from an entire unit of study (up to 6 tests) instead of just one assessment at a time.
The initial setup isn't too bad (5 minutes)--just add in the test keys for each individual assessment, which if you are already using my individual assessment templates you are familiar with this term.

Once the keys have been entered, the data will start showing up in the dashboard as you make your selections in the yellow validated cells using the drop-down menu's. You may have to be patient as the data loads in the system. 
At the top of the dashboard will be links to assessments shown, generated automatically by the keys you entered in on the setup tab.

Displays will look like this:
Class Data in Table Form

Class Data in Graphic Form 
(clicking on individual lines says who the student is and their score).

Individual Student Data across all Assessments

Visual assessment average dials

Flags students significantly above/below class average for growth

Get the template from the gallery in the Google Template Gallery (click here)

No comments:

Post a Comment