Sample Spreadsheet:

Don't forget: write formulas for the totals and averages.

Sample Charts