Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 32 - 2610_Springdales_C-7
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 |