Practical Google Sheets classroom tasks

Task 1: Student Mark Sheet (Beginner)

Objective

Create a mark sheet and calculate the total and average.

Instructions

Create the following table:

Roll No	Name	English	Maths	Science	Total	Average	Grade

Requirements

• Enter details of 10 students.

• Calculate Total using the SUM() function.

• Calculate Average using the AVERAGE() function.

• Apply Bold to the headings.

• Center-align the headings.

• Add borders to the table.

• Use Conditional Formatting:

  • Average above 80 → Green

  • Average below 40 → Red

---

Task 2: Monthly Expense Tracker

Create the following table:

Date	Description	Category	Amount (₹)

Requirements

• Enter 15 expenses.

• Calculate the total using SUM().

• Format the Amount column as Currency.

• Create a Pie Chart showing expenses by category.

---

Task 3: Employee Salary Sheet

Employee Name	Basic Salary	Allowance	Deduction	Net Salary

Formula

Net Salary = Basic Salary + Allowance − Deduction

Use formulas for all calculations.

---

Task 4: Attendance Register

Roll No	Student Name	Attendance (%)	Status

Requirements

Use the IF() function:

• Attendance ≥ 75 → Present

• Attendance < 75 → Shortage

Apply Conditional Formatting:

• Green = Present

• Red = Shortage

---

Task 5: Sales Report

Product	Quantity	Unit Price	Total Price

Formula:

Total Price = Quantity × Unit Price

Sort the products from highest total price to lowest.

---

Task 6: Personal Monthly Budget

Students should prepare their own monthly budget.

Include:

• Food

• Travel

• Mobile Recharge

• Entertainment

• Study Materials

• Savings

Calculate:

• Total Income

• Total Expense

• Remaining Balance

---

Task 7: Google Sheets Collaboration (Group Activity)

Group Size

3 Students

Task

Create a class picnic planning sheet.

Columns:

• Item

• Quantity

• Estimated Cost

• Person Responsible

• Status

Each student should:

• Edit the same spreadsheet.

• Add comments.

• Share the sheet with the teacher using Editor permission.

---

Final Assessment Task (Recommended)

School Library Management Sheet

Create a spreadsheet with the following columns:

Book ID	Book Name	Author	Student Name	Date Issued	Return Date	Status

Requirements

Students must:

✅ Enter at least 20 book records.

✅ Use:

• TODAY()

• IF()

• COUNT()

• SUM() (if applicable)

✅ Apply:

• Bold headings

• Borders

• Alternate row colors

• Filter

• Sort by Book Name

✅ Freeze the first row.

✅ Share the completed sheet with the teacher.

---

Evaluation Rubric (100 Marks)

Criteria	Marks
Data Entry Accuracy	20
Formula Usage	20
Formatting	15
Conditional Formatting	10
Sorting & Filtering	10
Chart (if required)	10
Sharing & Collaboration	5
Overall Presentation	10
Total	100

This final task gives students hands-on experience with the most commonly used Google Sheets features in schools and offices.