Excel Grade Book

Topics to be covered:

1.      Cells, rows, columns

2.      Populating  rows and columns with consecutive data (numeric, text)

3.      Formatting Cells
·        Number
·        Text alignment (horizontal/ vertical or different angles) and wrapping
·        Altering row or column pattern
·        Merging /unmerging cells
·        Fonts (size, type, weight)
·        Borders

4.      Inserting/Deleting rows and columns

5.      Built-in functions
·        Calculating “Average”
·        Maximum or  minimum values
·        Ranking
·        Automatic letter grading

6.      Page setup
·        Page orientation
·        Margins
·        Header/footer
·        Gridlines

7.      Protecting the grade book