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
   41   42   43   44   45   46   47   48   49   50   51