You are missing some Flash content that should appear here! Perhaps your browser cannot display it, or maybe it did not initialize correctly.
Notes
Here's the formula used in column B of the video. This would go in cell B2 and get indexed down the column.
=if(MATCH("N",D2:2,0),INDEX(D$1:$1,1,MATCH("N",D2:2,0)),"n/a")
Note, I found a formula error as I was recording at 5:20 and made edits to correct to what you see above. Pardon the choppiness. I'm much smoother in person;)
Push my thinking
How could you tweak this spreadsheet to track standards progress as well as assignment completion?
Useful files
Useful links
Comments
Use Google spreadsheets to visualize student progress in a self-paced course
Problem of practice
Most traditional online gradebooks operate from the assumption of whole-class-identical due dates and are no good for self-paced courses. What alternatives exist for giving students real-time awareness of their progress and next actions in a course that allows for differentiated pacing?
Solution
Screencast shows how to use Google Docs spreadsheet to create a color-coded self-pacing progress chart that counts the number of missing assignments and outputs a column that shows the next assignment owed, by student. It is recommended to publish t
Cast your vote
Tweet this
Post to TwitterBrowse other items with similar tags
Written by an educator for educators, the free doctopus script gives teachers the ability to auto-generate, pre-share, and manage grading and feedback on templated Docs for group and individual projects.
Recommended by 99 educator(s).
With a Bamboo tablet, Windows 7 Math Input Panel, and MathType you can hand write all your equations directly into typeset, insert then in Word, and use your clipboard to copy them into Google Docs and most HTML editors.
Recommended by 9 educator(s).
Flubaroo is a free Google Apps script that you can install on the backend spreadsheet to your Google Forms that will auto-grade multiple choice and fill-in responses, allow you to perform item analysis, and email students their results!
Recommended by 7 educator(s).
We tried a lesson-by-lesson, pre-learning diagnostic and question bank tool to determine mastery and assign self-teaching tasks or cluster group mini-lessons, with practice-set generating question bank and Google Spreadsheet as visualization tool.
Recommended by 6 educator(s).
Google Docs video can be unblocked in the firewall and used to host "safe" video content on your sites. This hack shows how to request an unblock for Google Video, rip YouTube content to an MP4, upload to Google Docs, and embed in Sites!
Recommended by 7 educator(s).
Any Google Doc can be published as a "template" into your schools Google Apps for EDU domain. Once there, the you can grab a direct URL to the template and post it in your online assignment. Students then create their document from your template!
Recommended by 8 educator(s).
I describe the rationale and some effective methods for a unique collaboration between EBA and the iSchool, where we ran several AP classes using a shared teacher, online collaboration and learning tools, and videoconferencing technology.
Recommended by 6 educator(s).
powered by educators
empowered by
automating grading process
thanks for helping, I am going to try and automate the process a little more. If I get it to work, I will share how I did it.
one more question and a comment
the "n/a" in the formula spits outs that value when all assignments are complete
as teachers, do you enter the scores for each assignment? or is that process automated. In other words, are the scores on the sheet somehting you graded and typed in, or are those values automatically generated when a student completes an assignment.
Yes, the n/a get spit out
Yes, the n/a get spit out when there are no "N's". I suppose it could be changed to say something like "See me".
I enter scores for each assignment. There is nothing automatically generated. But if you look closely, not every lesson is on the spreadsheet.
Great idea
Do you have a link to a site that is using this with students right now?
Using Google spreadsheets to visualize student progress
Hi,
I'm using Andrew's script on my site. You can go to http://science.newdesignhigh.com/life-studies-deborah to see it. However, since we are beginning a new semester, I'm going to archive this sheet and start a new one. I also created hyperlinks in the field that grabbed the "N" for next lesson, so when a kid looked at the spreadsheet, s/he can click on the link next to his/her name and find the lesson they were to do.
Feel free to email me with questions.
Maria
maria@newdesignhigh.com
Great spreadsheet!
Hi Andrew,
Thanks for this idea; I've implemented it and so far it's working quite well. I made the "N" conditional formatting color a neutral color and when asked what it means, I tell kids "Next assignment". So the "N" is not a punative thing, nor does it mean they got a zero on the assignment; it simply tells students where to start for the day.
I also don't enter "N"s where they are not needed and only add assignments that I absolutely want students to complete. I've built in "Flex Friday" and game days to allow those students with poor attendance or who work slower to make the choice to catch up on those days.
This pacing tool has really gotten me to think about my practice in new and exciting ways.
Maria