Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 56 - CodePilot V5.0 C7
P. 56

    Use Excel to  create  a budget  tracker  where you  input  your
                                           weekly  savings  and  expenses.  Apply  sorting  to  organise
                        SDG ACTIVITY  lead to better economic stability.
                                           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

                                        CODE CHECK                                                   Century   #Critical Thinking
                                                                                                      21 st
                                                                                                      Skills

                         1.                            ?

                                  (i)                     (ii)                    (iii)                   (iv)

                         2.  Find the missing number.

                              5   7   6
                              4   4   4
                              8   2   ?

                           SOCIAL SIGHT                                                             21 st
                                                                                                   Century   #Communication
                                                                                                   Skills  #Social Interaction
                        Conduct a survey on how Excel is used in different careers, then discuss the results and share real-life
                        applications across various industries.

                                                                                                     21 st   #Communication
                                                                                                    Century
                                                                                                     Skills  #Collaboration
                                Divide the class into two groups and ask them to discuss how Excel can help in managing their
                                schoolwork and daily tasks.

                           JOB JUNCTION
                              After mastering Excel, students can become Data Analysts, interpreting data to help businesses
                             make informed decisions.

                       PEDAGOGY PATHWAYS

                        «   Explain how to use basic formulas and functions.
                        «   Help students understand how to sort, filter and visualise data using charts.

                       54
                            CodePilot (V5.0)-VII

| 51 52 53 54 55 56 57 58 59 60 61 |