Spreadsheets - Marks Sheet

Objectives :

To be able to

1. Use formulas to solve simple arithmetic problems (Reinforcement).
2. Format a sheet to increase its readability.

Task 1:

1. Download the activity file from HERE.
2. Enter missing data in the file. 
3. Use excel formulas where required.

Task 2:

1.  Format the file to look like a Marks Sheet of a student.

Extended Task:

1. Think about some additional information that you see on a Report Card and add in the activity file.

Very Important:

Save the activity file in your folder.

Spreadsheets - Multilevel Sorting Continued and Paste Link

Multilevel Sorting ( ..... Continued)

1. Open Activity 3 Excel Workbook (Last weeks Activity File saved in your folder)
2. Add a field to enter Address (Emirate Name)
3. Sort the data (must be your class only) according to Address and then Name.
4. Examine the sorted data. Discuss the outcome.