How to Create a Gradebook on Microsoft Excel

Name the Grade-book sheet Double click on "Sheet1" at the bottom of the Excel window, "Sheet1" is now highlighted Type a name for the sheet, for example: First Hour Grades Press Enter , Insert Class Information Click cell A1 to select it Type...

4 Steps 1 min read Easy

Step-by-Step Guide

  1. Step 1: Name the Grade-book sheet Double click on "Sheet1" at the bottom of the Excel window

    Press the down key to select cell A2 Type the class name, for example:
    Social Science Class Press the down key to select cell A3 Type class meeting times Press the down key to select A4 Enter the term, for example:
    Fall 2012 Press "Enter" twice to go to cell A6 The "name box" at the top of the sheet shows what cell is selected.
  2. Step 2: "Sheet1" is now highlighted Type a name for the sheet

  3. Step 3: for example: First Hour Grades Press Enter

  4. Step 4: Insert Class Information Click cell A1 to select it Type teacher’s name.

Detailed Guide

Press the down key to select cell A2 Type the class name, for example:
Social Science Class Press the down key to select cell A3 Type class meeting times Press the down key to select A4 Enter the term, for example:
Fall 2012 Press "Enter" twice to go to cell A6 The "name box" at the top of the sheet shows what cell is selected.

About the Author

P

Patricia Murray

Creates helpful guides on cooking to inspire and educate readers.

106 articles
View all articles

Rate This Guide

--
Loading...
5
0
4
0
3
0
2
0
1
0

How helpful was this guide? Click to rate: