To average each student's grades:

• Click File in the Excel menu bar and choose Save. Open the folder in which you want to save your file. Type a name for the file in the File Name blank. Click Save.
• Click in cell D1 and type Current Average. (Don't worry if the words "bleed" into cell E1; just double click the line between the letter D and the letter E at the top of the spreadsheet and the column will automatically resize!)
• Click in cell D2 and type =(B2+C2)/2. Hit Enter. The first student's average grade will appear in cell D2. (Why? The formula =(B2+C2)/2 told Excel to add the numbers in cells B2 and C2 and then divide the sum by 2.)
• Click in cell D2. Hold down the mouse button to highlight the rest of the students' grades. Release the mouse button.
• Click Edit and choose Fill and Fill Down. (You don't have to retype the formula.) An average of each student's grades now should appear.

Next: Charting their progress.