Practical Exercise

Learners have learned how to:

• understand the spreadsheet interface
• enter and correct data
• use formulas and functions such as SUM, AVERAGE, MIN, MAX, and MEDIAN
• edit and format worksheets
• create charts

Create a worksheet named Student Scores with the following data:

Tasks

1. Enter the data into the worksheet.

2. Add a new column called Average.

3. Use a formula to calculate the average score for each student.

4. At the bottom, calculate:

• minimum average
• maximum average
• median average
• overall class average

5. Format the table neatly 

• Using your own creativity - Interesting and yet professional

6. Create a chart that is relevant and explain why you use this type of chart