As the first day back at school drew to a close I found myself at my desk confronted by the reality of all the paper around me. I try to use technology to reduce the amount of paper I use but there’s still all this…. paper.

So I was rethinking the learning skills tracker. There had to be a better way. I want to be able to quickly track a student’s learning skills on a mobile device like my iPhone. So to make a long story short, I fiddled with the tracking sheet in the previous post and made a Google form that I could call up and fill out on any given date for all my students.

It basically looks like this, but instead of “Student Name” I have my actual students’ individual names and then a little tracking sheet with space for comments.

 Each time I fill out this form it will send the information to one spreadsheet. So I should, in theory, be able to select the data in the sheet and then at midterm make a more accurate assessment of their most consistent achievement in each area.

I just don’t know how. Any spread sheet wizards know how I could do this?