Page 32 - Trackpad_V4.0_c7_Flpbook
P. 32

SDG Activity


                 Use Excel 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.





                       Explore in the Lab                                         21 st  Century   #Technology Literacy
                                                                                     Skills
                To
                Subject  Data in an Excel sheet
                 Enter the following data in an Excel sheet and perform the actions given below:

                  Name      Location   Product Purchased    Purchase Amount      Loyalty Program Status

                  Sameer    Delhi      Electronics          500                  Member
                  Emily     Mumbai     Clothing             150                  Non-Member

                  Neha      Kolkata    Electronics          700                  Member
                  Sarah     Kerala     Electronics          450                  Non-Member
                  Chirag    Delhi      Books                80                   Member

                  Divya     Lucknow    Electronics          600                  Non-Member
                  Amit      Mumbai     Electronics          800                  Member

                  Komal     Miami      Clothing             120                  Non-Member

                    Sort the data based on 'Purchase Amount' in descending order.
                    Filter the data to show only customers who are members of the loyalty program.

                    Apply conditional formatting to highlight purchases made in Mumbai.



              For The Teacher
                  Demonstrate to the students the concepts of Excel discussed in the chapter.
                  Make the students understand differences between filtering and sorting features.






















                        Premium Edition-VII
                 30
   27   28   29   30   31   32   33   34   35   36   37