A TECHTORIAL

STEP THREE: FORMAT AND PRINT THE GRADE BOOK

To format the grade book:

  • Click the letter A to highlight column A.
  • Click the "B" in the "B, I, U" icon in the formatting toolbar to bold everything in column A. (Don't see these letters? Click View > Toolbars > Formatting.)
  • Click cell B1 and drag the mouse across the row to highlight the name of each assignment. Click the "B" in the formatting toolbar to bold those words as well.
  • The grey lines you see in the Excel window do not actually print. To make the grades easier to read when printed, click cell A1 and drag the mouse across and down to highlight every cell with text in it. Then right-click, select Format Cells, click the Borders tab, click the Outline and Inside icons and click OK.
  • What about all the decimal places behind the averages? To standardize the grade format, click cell B2 and drag the mouse across and down to highlight all cells with grades in them. Right-click, select Format Cells, choose the Number tab, click the word "Number" in the Category field, and choose 2 decimal places. Click OK.

Excel sometimes prints lots of extra pages, so you have to be careful to choose exactly what you want printed. To do that:

  • Click cell A1 and drag the mouse across and down to highlight every cell with information in it.
  • Click File > Print Area > Set Print Area.
  • Click File > Print Preview to see what your page will look like.
  • The spreadsheet should look something like this:

Next: Tips and Tricks.

 
Close window