
This Technology "Tuesday" tutorial comes from one of the winners of my 500 follower giveaway, Katie. She requested that I blog about how to use technology to efficiently manage grades, anecdotal records, assessments, etc.! I personally don't do anecdotes digitially anymore. I did one year, and I had some issues with it, as one set of parents felt that the fact that the digital anecdotes could have been typed/retyped/embellished at any point without any difficulty. It really made me think, and now I do it all handwritten! Anyway, I'm going to blog about how to technology to manage grades/assessments via a digital gradebook!
First things first, I uploaded the digital gradebook onto TPT. There are two options for download, one is color coded, while the other is black and white. They're both available by clicking the picture below:
Personally, I use the color coded option, because I like to see the "bell curve" of my classroom. However, if you have to print your grade book out regularly (to give to your administrator) or if you prefer the black/white, you can use that one as well!
Now... onto some info about how to use the document!


You can download this tutorial as a PDF by clicking this picture!
Note: This tutorial is hosted on Google Docs. To save it from there, just
open the file and click File > Download to save onto your computer!



This is so clever! We use both- digital and paper/pencil. I'm your newest follower :)
ReplyDeleteKimberly
The Learning Tree
Thanks! I really like the color coding! I used to manually color code my grade book, so I love that Excel does all the work for me!
DeleteI do all of my scores digitally! Being a Title 1 teacher it's easier to have it all in 1 place. We also keep a paper trail as well!
ReplyDeleteIt really is! It's so convenient to have it all in one place and be able to access it everywhere!
DeleteI always learn so much from your tutorials. You especially helped me with the white border on the PDF file. I thank you for all your help on that one. I awarded you the Versatile Blogger and One Lovely Blog awards. Hoping you will visit my blog to pick up your well deserved awards!
ReplyDeleteMichelle
http://owlsareahoot.blogspot.com/
Thank you so much!
DeleteThese are awesome! :) Thank you for sharing them! :)
ReplyDelete:) Ashley
The Real Teachr: Tips, Tricks, Freebies and Everyday Ideas for Real Teachers
No problem!
DeleteAwesome! Do you think this will import correctly into Google Docs? I can't take my work computer home (ugh!), so only having the files on that computer or my home computer isn't super practical. I guess I could also use Dropbox or something...
ReplyDeleteI'm guessing that it won't because of the detailed coding to fill in the boxes with the colors, but it will work perfect over Dropbox... I actually meant to mention that in the post. I always keep my digital gradebook in Dropbox so I can always access the most recent version of it. I'll have to update my post for that!
DeleteToo cool! I will have to do this! If you have time stop by my blog and join my "Classroom Tours Linky Party"! I would love to see your classroom!! If you aren't ready just quite yet, share a before pic and then go back and share an after pic! :)
ReplyDeleteBrigid
Brigid's Daily Lesson Log
Thanks for the heads up! I'm going to come link up right now!
DeleteI love it!! I've been using excel for big assessments but not a grade book. I like it! At the endof last year I got an iPad and a grade book app. I think it will really hel this year! If not.. I'm going back to excel! Thanks!
ReplyDeleteHttp://Fourthgradefeedingfrenzy.blogspot.com
Very interesting... A grade book app. I'll have to look that one up! Let me know how you like it!
DeleteI love your idea and have been wanting something like this for a while. Unfortunately, the color coding is not supported on Excel for Mac 2008. Do I need a later version? Or do have to use Windows Excel? (I hope not, I prefer Mac)
ReplyDeleteOh no! I'm not entirely positive. My school Mac has Excel 2008, but unfortunately I won't have access to that computer until mid-September so I won't be able to play around with it until then! Sorry I can't be of more help in the meantime. You may have to use Windows Excel, but I will definitely try to figure it out on Excel for Mac when I get my computer back!!!
DeleteI really needed to get working on egrades and here is your post! I had just signed up for Sugarsync though. I was going back and forth between Google docs and Dropbox and decided on Dropbox until I got to my last geek review and it said Sugarsync was the closest to Dropbox but the difference was that Sugarsync offered 5G for free, you can upload multiple files at a time and you have the option to password protect your work.
ReplyDeleteAfter seeing that Google docs has problems with the file and Dropbox didn't I'm really hoping Sugarsync doesn't either or I'll have to delete the account and head to Dropbox.
Very informative post! Thank you so much!
Michelle
Thank you very much. I will definitely use this! I love the frozen lines - so clever!
ReplyDelete