ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

How to Create and Maintain a Grade Book

Updated on November 30, 2017
StephanieBCrosby profile image

Stephanie Bradberry is an herbalist, naturopath, and energy healer. Her academic career includes teaching, tutoring, writing and editing.

Me taking notes, but not about grade books
Me taking notes, but not about grade books | Source

Whether you are teaching a class online or in-person, the information below will be helpful. Over the years I have developed a system for keeping records for my classes. When I taught at the high school level, student grades needed to be kept in a traditional grade book, and I learned a lot from my mistakes made being a new and eager teacher. Then software programs for keeping records gained in popularity and lessons were learned about how to maintain an electronic grade book. Now, I instruct at places where I use a "grade book" that is nothing more than a series of rows and columns created using a Word document.

Seek Out Free Grading Tools

It is always great to do some field research. Know what types of products are out there to help you. And get to know how others are creating and maintaining their grade and roll books.

Here are some helpful links for grading systems and software:

Free template

Article that catalogs and discusses different grade keeping programs

Do Not Use the Real Book at First

Often I do not use the physical grade book, if required to use the traditional kind, until week two. At the beginning of the term, semester, school year, etc. there is a lot of shifting taking place. So what I do is one of two things:

  • Print out the class list and keep the attendance on that sheet until the end of the second week of class.
  • Use a Word document and use the import function to copy student names in and use that until the class list is steady. Then I print out the copy that has the official list of students after two weeks.

Have a Back-up

While you can never save your work enough, it is wise to at least copy your work in a different location every two weeks. Sometimes I transfer my grade book to a flash drive if I am using a system like GradeKeeper, which is a flat file. If I am using a traditional grade book or Word document, I just photocopy the pages.

The point is, you never know when your computer might crash, the online system you are using in inaccessible, or a gust of wind will come by and blow your folder with your grade sheet across the parking lot. A bit dramatic, but do not forget Murphy's Law.

You Need White Space

I always like to leave one row blank at the top of the grade book for any new student that might be transferred in and has a name at the beginning of the alphabet.

Try to leave 2 to 3 blanks slots at the end of the page if using a traditional grade book. This allows room for if I add an extra assignment and there is no room to write the name and points in the vertical or slanted slots up top. These spaces can also be used for students added to your roster whose names are towards the end of the alphabet.

I also like to leave 2 to 3 columns at the end of the grade sheet or book page. This allows me to put a tally at the end of the row for grade's to date or the end of the year/semester calculations like one column for the points earned, the final percentage, and the letter grade.

If I am using a Word document as my grade book, I like to leave open space at the bottom after my table. This way I can add notes to myself and important information. Then I will not have tons of scraps of paper that have notes about whose work will be late and messages from e-mail communications.

Aim for Clarity

Since your grade book has to be turned in at the end of the school year, semester, term, what have you, make things easier on yourself and administrators. If someone has a question about a grade, you want them to be able to answer it for themselves to avoid getting a call while you are on vacation or not near your book. Here are three basic tips to avoid confusion:

  1. Place the name of school, name of course/class, and semester and/or year at the top of the page, especially when using something as simple as a Word document or Excel spreadsheet. This obviously makes for easy identification when a copy is requested. The same steps should be taken when naming your file or electronic grade book. I usually use the construction of my first initial, last name, semester and year. I normally do not add the name of the institution because the file is house in a folder with the name of the school already.
  2. Always put the name of the assignment in the grading block. This sounds simple, but sometimes educators just put "Assignment 1" or something like that. This could work if you make the designation of "Quiz 1," "Essay 1," etc. But if you are not, then you need a brief description so you remember what the assignment was. This helps when recapping grades with parents and students. I also like doing this so I can tell students, "Your grade to date includes..." and have the specific name for assignments in short form that were used at the top of the prompt sheet.
  3. Put the total possible points or percentage for each assignment next to the name of the assignment. This way, if a discrepancy arises, you can see if it was a point error or transcription error.

Keep It Safe

There are many laws about protecting privacy. The most important for educators, especially in higher education are FERPA laws. Of importance for grades is keeping them confidential, even from parents who might be paying for their child's education. Here are some main ways to make sure you are keeping records safe and secure:

  1. Never put a name along with a personal identification number that is based on their SSI number or phone number.
  2. Shred all your records with names on them after the designated time to keep student records. Usually the time frame is a year, but there are institutions like colleges that require you only keep the records for one semester after the end of the course.
  3. Try to make your grade book, if using a Word document or online source, password protected.
  4. Do not put text that would identify your students as special needs or receiving certain accommodations and the like (see below for how I handle this).

Additional Tips

  • Start by using a pencil or erasable pen. There will be many times that grades need to change or student names might change. For example, in one of my courses this semester, a student was on my list one day and was gone the next. However, I had gained a student in her place. This was an online class, so I did not think much about it. But it was a college that is not known for shifting students around after the official start date. Students might be removed from the list, but rarely added. The first assignment was already downloaded. But when I went to open the assignment from the "new" student, it was the same assignment as the student who dropped, the only difference was the last name. It turns out my student got married and moved from the end of my roster to the top alphabetically. This created a gap near the end of my grade book, and I did not plan a space at the top that I normally might since this school is not know for adding students to classes after they begin.
  • If a student has an IEP, 504, or other special accommodations or needs, I use a highlighter to identify them. You will know what it means, but you are not broadcasting to the world the status of your students. Imagine if a student or stranger got a hold of your grade book the damage that could be done. So this ensures I maintain privacy. I might also color code things. For example a yellow highlight is for students with special accommodations and a pink highlight is for students that have been granted extensions for the course.
  • It is always helpful to come up with a key for markings/notations you make in your grade book. For example, I use an asterisk to note students I need to contact, an "NL" to note that a student contacted me in advance that there work will be late, so the "NL" is "Not Late" and it reminds me days later when their work comes in to not take the standard deduction, a circle around a grade if it has been updated or changed, and so on. This can be helpful for times when a student claims he or she received a certain grade and your book says different. You can tell whomever (administrator, student, parent) about the change based on your notation style.



    0 of 8192 characters used
    Post Comment

    • StephanieBCrosby profile image

      Stephanie Bradberry 4 years ago from New Jersey

      Hi CraftytotheCore,

      I am so glad you found this useful and you like tutorials. I hope we can continue reading each other's works.

    • CraftytotheCore profile image

      CraftytotheCore 4 years ago

      I love tutorials on creating our own stuff. This one is excellent! Thank you for sharing your ideas.

    • StephanieBCrosby profile image

      Stephanie Bradberry 5 years ago from New Jersey

      Anil and Honey. Thank you for the lovely words. And thanks for reading and commenting.

    • Anil and Honey profile image

      Anil 5 years ago from Kerala

      very nice hub. I am glad to meet you. because you are a grate hubber and a grate person in the society. self employment is a very important thing.

    • StephanieBCrosby profile image

      Stephanie Bradberry 5 years ago from New Jersey

      Hello ComfortB. I could not agree more. Often we need a backup for our backup. I too have experienced systems that may have lost school wide data for a day or more. I do hope my information is indeed useful to others. Thanks for reading!

    • ComfortB profile image

      Comfort Babatola 5 years ago from Bonaire, GA, USA

      You sure will be helping somebody with these grade keeping book tips.

      A while ago when I was an adjunct at a technical school, I developed an excel database to keep records of my student in addition to the schools DB systems because there had been issues with power outage and missing records. It's always good to have a backup system that works. My Excel DB was that backup system.

      Great hub. Voted up and useful.

    • StephanieBCrosby profile image

      Stephanie Bradberry 5 years ago from New Jersey

      Hello tillsontitan. I really hope I can be a source of guidance for someone. I know I struggled to find someone who truly wanted to help me as a beginning teacher. All I can do now if provide the information I wish I knew when I first got started. Thanks for reading!

    • tillsontitan profile image

      Mary Craig 5 years ago from New York

      Lots of good information for teachers. Sometimes new teachers don't have the guidance they need and can benefit from your knowledge and experience.

      Voted up and useful.

    • StephanieBCrosby profile image

      Stephanie Bradberry 5 years ago from New Jersey

      Hi billybuc. Wow, that's awesome. That means I did something right. Maybe I convinced you to teach again too :)

      I just realized you are in WA. I actually grew up in Tacoma for 10 years. Very beautiful state, at least when I was there. I still here there are remnants of the "Tacoma Aroma."

    • billybuc profile image

      Bill Holland 5 years ago from Olympia, WA

      You get this ex-teacher's seal of approval on this hub; nice job!


    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: ""

    Show Details
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the or domains, for performance and efficiency reasons. (Privacy Policy)
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)