Step 1: Create a MS EXCEL spreadsheet of grades for three students as shown below.

MS Excel Spreadsheet SPECS:

This is to be three test scores for three students.

Your name is to be student 1, make up names for the other two students.

Use the FUNCTION that will total the scores for each student.

Use the FUNCTION that will create an average of the test scores. (by row)

Use the FUNCTION that will total all the tests scores for the individual tests.

Use the FUNCTION that will create an average of those test scores. (by column)

Use the FUNCTION to produce the MEDIAN of Individual Test Averages.

Include a graph for Test Averages.

Include a graph for the Individual Test Scores by Test.

Step 2: Create a MS PowerPoint Presentation of the above MS Excel Spreadsheet and as shown below.

MS PowerPoint Presentation SPECS:

This presentation will have five slides.

1. A Cover Slide

2. The cells holding JUST the student grades from your EXCEL Spreadsheet

3. The graph of the Test Averages

4. The graph of the Individual Student Grades

5. A Joke (with an animation!)

Floppy disk/CD-ROM with XLS and PPT files.

Printed Spreadsheet and Presentation.