Excel MarkBook
 
Contents:
    Introduction ...................................... 1
        Autofill  ......................................... 2
    AutoFilters ....................................... 5
    Conditional formatting ............................ 7
    Customising toolbars .............................. 10
    The VLOOKUP function .............................. 12
Introduction:
 
These notes provide details of using Microsoft Excel as an electronic markbook. As a teacher it will be essential that you keep accurate and up-to-date records of your students marks.  I have produced these notes to assist you in using Microsoft Excel as a markbook.  
 
Microsoft Excel is perhaps the worlds best known spreadsheet. The first electronic spreadsheet was a program called VisiCalc developed in 1978.  Since the 1980ís the business community has made extensive use of electronic spreadsheets.
Use auto fill to create Numbered list. pg. 2
Use  conditional formatting to highlight blank cells. pg. 7
Use conditional formatting to highlight grades.
pg. 7
Create a test user to ensure that marks add up to 100%.
Use AutoFilters to show all students in tute A, B or C pg. 5