Page 46 - Touchpad_Plus_V3.2_Class 7
P. 46
SDG Activity
Use Calc to create a budget tracker where you input your weekly savings and
expenses. Apply sorting to organise your expenses by amount, and use conditional
formatting to highlight any expenses that exceed your budget limits. Analyse the
results to see how managing your finances can lead to better economic stability.
21 st #Critical Thinking
Century
Lab Session Skills #Technology Literacy
Make a list of 12 different products in LibreOffice Calc, including columns for their price, quantity
sold, and total sales. Use sorting to arrange the products by their total sales in descending order.
Highlight the cells where the total sales exceed 500 units using Conditional Formatting.
Create a worksheet listing 8 different types of loans in LibreOffice Calc, with columns for loan
amount, interest rate, and loan term (in years). Use Goal Seek to find out how much loan amount
is required to achieve a monthly payment (INR) of for each based on the given loan amount, and
interest rates.
Teacher's Note
1. Illustrate the concepts discussed in the chapter to the students.
2. Help students understand the difference between
a. Auto Filter and Standard Filter b. Sorting and Filtering
44 Plus (Ver. 3.2)-VII

