Diane 93 90 80 88 90 100 85 80 85 81 85
Create a spreadsheet for these class grades. The class has 8 students; John, Frank, Michael, Joseph, Nancy, Jayne, Mary and Diane. Five tests account for 60% of the grade, 5 homework assignments account for 25% of the grade and a project accounts for the other 15% of the grade. The spreadsheet should show a number average and a letter grade for the term. Also have the spreadsheet give an "ALERT" if anyone is failing. Create a chart/graph that visually represents the student names and final number grades. Format the work to be visually appealing. * Create a Header and Footer that identifies you, the date and the document.