How to Make a Grade Sheet in Microsoft Excel


Microsoft Excel is a versatile program that can be used to organize all types of data. An Excel spreadsheet can be used to perform calculations with a large data set or simply to bring together diverse information. It is especially useful for creating grade databases; you can create a grade sheet that brings together a large amount of information about your students, and you can search and calculate within Excel itself.

Things You'll Need

  • Computer
  • Microsoft Excel

Creating a Grade Sheet

  • Open Microsoft Excel and begin a new spreadsheet.

  • Enter "Last Name" in the first column, second row. Format this cell in bold so that it is easily distinguishable from the actual names.

  • Enter "First Name" in the second column, second row. Make this bold as well.

  • Enter the last names of your students underneath the "Last Name" column, beginning on the third row.

  • Enter the first names of your students underneath the "First Name" column, beginning on the third row.

  • Select the first two cells in the first row. In the formatting toolbar, select 'Merge Cells.' This will create one large cell in the place of the original two. Enter "Assignment:" in the new cell. If you would rather grade by date, enter "Date:" in this cell. Make this text bold.

  • Enter relevant assignments or dates in the first row. If you wish to create any sort of break, signaling the end of a semester or other such landmark, select an entire column, and change the color of the cells so that they stand out.

  • Experiment with other formatting choices. Design a grade sheet that suits your particular class and informational needs.

  • Enter grades for students by finding their last name on the far left of the spreadsheet and the applicable assignment at the top of the spreadsheet. Within a spreadsheet, you can search for a specific term or number (a name, a grade, an assignment). A more advanced proficiency with Excel can allow you to run more complex searches and perform calculations.

Tips & Warnings

  • If you want to keep track of multiple grades (tests, minor assignments, attendance) for a single class, use multiple sheets within one file. You can accomplish this by using the tabs at the lower left-hand corner of a document (labeled Sheet1, Sheet2, etc.).

Related Searches


  • Photo Credit BananaStock/BananaStock/Getty Images
Promoted By Zergnet



You May Also Like

  • How to Create Excel Worksheets

    If you’re new to Excel, you’ll find it easy to learn and work with. You can complete most of the tasks by...

  • How to Grade Bed Sheets

    Finding the perfect bed sheet set might be a never-ending quest, especially when you are your partner have different tastes. Research sheet...

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!