Create Grade book:

  1. Click in cell A1 and type: Grade book
  2. Hit enter
  3. Highlight the range A1 to Q1
  4. On the formatting toolbar, click the following buttons:
    1. Merge and Center
    2. Bold
    3. Fill cells with color (paint bucket)
    4. Font color (Letter with color)
  5. Double-click the sheet tab and type: Grade Book
  6. Hit enter
  7. In cell A3 type: 1
  8. In cell A4 type the formula: =A3+1
  9. Hit enter
  10. Highlight cell A4
  11. Point to the fill handle
  12. When your curser turns to a cross hair, click and copy the formula down to cell A27
  13. In B2 type “Names”
  14. Click in cell C2 and type “HW 1,” then copy the contents of C2 across to G2
  15. Click in cell H2 and type “Quiz 1,” then copy the contents of H2 across to L2
  16. In cell M2 type “Midterm”
  17. In cell N2 type “Final”
  18. In cell O2 type “Totals”
  19. In cell P2 type “% Grade”
  20. In cell O2 type “Grade”
  21. In cell B3 type: Max Scores
  22. Type names in the range B4 to B27
  23. On the menu bar, point to File, then point to “Save As”
    1. Save in: Desktop (or other disc or drive)
    2. File name: “Your Name Grade Book”
    3. File type: .xls
  24. Using the control key selection trick: Highlight the ranges B2:B27 & C2:Q2
  25. Click the bold button
  26. On the standard toolbar, click the Save button
  27. Highlight A3:Q3
  28. Click the “Paint Bucket” button and select yellow
  29. Click the Font Color button and select Automatic
  30. In the range C3:N3 create your max scores for each item
  31. For the first two students create scores
  32. Click in cell O3 and use the AutoSum button to create a SUM function
  33. Copy the formula down and use the smart tag to avoid copying the yellow cell color
  34. In cell P3 use relative cell references and absolute cell references, create the following formula (be sure to type your equal sign first):
  35. Copy the formula down and use the smart tag to avoid copying the yellow cell color
  36. Highlight the range A1:Q27 and then click the All Borders button
  37. Wow, we are done (with the beginning of infinity)!
  38. File, Page Setup:
    1. Page Tab: Landscape, Fit to 1 by 1 page
    2. Margins: Center on page Horizontally
    3. Headers/Footers: Custom Header, add code for workbook name