Page 40 - iprime_V2.2_class8
P. 40

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.




                                                                                                        Interdisciplinary




                        Create a similar invoice in Excel.
                        Fill-up  details  of  the  five  items,  their
                          quantities, and unit prices.
                        Using the Product  function,  calculate  the
                          total amount for each item.
                        Using the SUM function, calculate the total
                          amount.
                       Using a formula, calculate the GST according to the given rate.
                       Calculate the invoice amount payable.


                        Create an Excel worksheet and enter the following data:










                        Create a column chart based on the
                        above data. Title of the chart should be
                        ‘Yearly  Sales Chart’.  The  chart  should
                        look like this:










                   Teacher's Corner

                  1.  Do a walk-through of all the Excel topics in detail on the computer screen.
                  2.  Explain how Excel is used at home, in shops, businesses, industries, and so on.
                  3.  Describe the different types of charts provided by Excel.
                  4.  Talk about the different styles that can be applied to a chart.


                  38     iPRIME (Ver. 2.2)–VIII
   35   36   37   38   39   40   41   42   43   44   45