A Turn to Learn

Ed Tech Integration in the Elementary Classroom

  • Technology Tutorials
    • Chromebooks
    • PowerPoint
    • Photo Editing
  • Teacher Tips
    • Classroom Organization
    • Classroom Management
    • Techie Tricks
  • Classroom Activities
    • Smartboard Games
    • Teachers Pay Teachers
  • About Me

How To Organize Your Assessment Scores Digitally!

08.01.2012 by Jessica Kings //

So many of us are used to our spiral grade books, but have you considered using a digital gradebook?  I personally love my having all of my test scores saved digitally so much that I’ll never go back to a paper and pencil grade book!

How to Organize Your Assessment Scores Digitally

This Technology “Tuesday” tutorial idea 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 digitally 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!

 

Thanks, Katie, for the fabulous idea to blog about!  I hope you’re able to use this digital gradebook in your classroom!

Share this:

  • Facebook
  • Pinterest
  • Twitter

Categories // Classroom Organization, Teacher Tips, Technology Tutorials

Comments

  1. Kimberly Santana says

    August 1, 2012 at 11:11 pm

    This is so clever! We use both- digital and paper/pencil. I'm your newest follower 🙂

    Kimberly
    The Learning Tree

    • TurntoLearn says

      August 4, 2012 at 2:51 am

      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!

  2. Cindy Lusk says

    August 2, 2012 at 12:31 am

    I 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!

    • TurntoLearn says

      August 4, 2012 at 2:52 am

      It really is! It's so convenient to have it all in one place and be able to access it everywhere!

  3. Michelle at Owls are a Hoot! says

    August 2, 2012 at 3:09 am

    I 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!

    Michelle
    http://owlsareahoot.blogspot.com/

    • TurntoLearn says

      August 4, 2012 at 2:53 am

      Thank you so much!

  4. Mrs. Stout says

    August 2, 2012 at 12:21 pm

    These are awesome! 🙂 Thank you for sharing them! 🙂

    🙂 Ashley
    The Real Teachr: Tips, Tricks, Freebies and Everyday Ideas for Real Teachers

    • TurntoLearn says

      August 4, 2012 at 2:58 am

      No problem!

  5. Bee Isme says

    August 2, 2012 at 11:26 pm

    Awesome! 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…

    • TurntoLearn says

      August 4, 2012 at 3:02 am

      I'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!

  6. Brigid says

    August 3, 2012 at 12:54 pm

    Too 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! 🙂

    Brigid

    Brigid's Daily Lesson Log

    • TurntoLearn says

      August 4, 2012 at 3:02 am

      Thanks for the heads up! I'm going to come link up right now!

  7. S. Webb says

    August 4, 2012 at 3:46 am

    I 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!

    http://Fourthgradefeedingfrenzy.blogspot.com

    • TurntoLearn says

      August 5, 2012 at 5:07 am

      Very interesting… A grade book app. I'll have to look that one up! Let me know how you like it!

  8. Cerina says

    August 12, 2012 at 6:03 pm

    I 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)

    • TurntoLearn says

      August 13, 2012 at 1:11 am

      Oh 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!!!

  9. Michelle says

    August 21, 2012 at 3:03 am

    I 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.
    After 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

  10. sallytomato says

    August 28, 2012 at 12:18 am

    Thank you very much. I will definitely use this! I love the frozen lines – so clever!

  11. George Mousavi says

    March 13, 2014 at 6:37 pm

    Excel training Long Island will provide you free crash courses to learn more about the Ms Excel individually and make yourself capable of managing accounts and other work on Ms Excel.

Connect

  • Bloglovin
  • Facebook
  • Pinterest
  • YouTube

Search

Categories

Products

Certifications


Tynker Blue Ribbon Educator

Nearpod Certified Educator

Certified Brain Pop Educator

Try This Tutorial

Chromebook Help - Fix a Gigantic Mouse

Help! Fix My Chromebook… My Mouse is Gigantic!

Try This Activity

Chromebook Help - Fix Video Pop Ups in Chrome

Help! Fix My Chromebook… I’m Getting Video Pop Ups!

Popular Posts

  • Help! Fix My Chromebook… My Mouse is Gigantic!
    Help! Fix My Chromebook… My Mouse is Gigantic!
  • Help! Fix My Chromebook… I'm Getting Video Pop Ups!
    Help! Fix My Chromebook… I'm Getting Video Pop Ups!
  • Help! Fix My Chromebook… My Screen Looks Like a Negative Image!
    Help! Fix My Chromebook… My Screen Looks Like a Negative Image!
  • Help! Fix My Chromebook… My Keyboard is Typing the Wrong Letters!
    Help! Fix My Chromebook… My Keyboard is Typing the Wrong Letters!
  • Help! Fix My Chromebook… My Screen is Sideways!
    Help! Fix My Chromebook… My Screen is Sideways!

Copyright © 2025 · Modern Studio Pro on Genesis Framework · WordPress