Page 6 - iPrime_V2.2_class7
P. 6

INSIDE THE SERIES



                  The key features of the series have been designed to ensure better learning, assessment
                  and evaluation.



                                                   Learning Resources








                                                          Tech Funda: This section
                         Chapter Profile: This
                                                       provides a practical information
                         section describes the                                              Clickipedia: This section
                                                           or tip to the students.
                       objective of the chapter.                                              provides interesting
                                                                                                computer facts.















                       Hands-On: This section contains an                         Higher Order Thinking Skills: This
                          activity for Home assignment.                          section focusses on fostering higher
                                                                                   order thinking skills in students.














                                                                                         Glossary: This section contains
                                                                                         definition of important IT terms.
                     Reboot: This section provides        Fun in Lab: This is a lab
                                                           SDG Activity
                     a summary of the chapter for        activity to develop practical
                                                          Use Excel to create a budget tracker where you input your weekly savings
                                                          and expenses.  Apply sorting to organise your expenses by amount, and
                                                                   skills.
                                                          use conditional formatting to highlight any expenses that exceed your
                         quick recapitulation.            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  Touchpad iPRIME (Ver. 2.2)–VIII
   1   2   3   4   5   6   7   8   9   10   11