1. Introduction to Spreadsheet

The below quiz on the spreadsheet is for self-assessment. You can try it again and again until you get 100 out of 100.

2. Cell Reference

The below quiz on the Cell Reference is for self-assessment. You can try it again and again until you get 100 out of 100.

Activity 2.2: Cell Reference (Absolute reference)

Copy the table in the spreadsheet and use the absolute reference to calculate the percentage obtained by students in English.

Activity 2.3: Cell Reference (Mixed reference)

Copy the table in the spreadsheet and use the mixed reference to calculate the percentage obtained in different subject during the class test by a student.

3. Basic Calculation and Functions

Click Here to Access the activity on basic functions and calculations

Project Work 

Create a monthly income and expenditure account for your family. List the sources of income (salary, bonus, allowance, etc.) and expenditures (rent, food, education, clothing, etc.) to calculate and analyse the family budget for the year. 

Identify whether your family has a healthy or unhealthy budget.

 Marking Criteria

Artefact: Activity on Functions

Enter functions (sum(), average(), max(), min(), rank(), count(), if(), and countif() in the cells missing below.

Click here to DOWNLOAD the spread to enter the missing data in the cell using the basic calculations and entering the functions.

4. Introduction to Google Sheet

Questions: Check Your Progress 

1. As a student, where will you apply the data analysis skills using Excel?

2.  What are the differences and similarities between charts you draw in Mathematics and MS Excel?