Page 6 - iPrime_V2.2_class5
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
                                                          use conditional formatting to highlight any expenses that exceed your   GLOSSARY  Subject Enrichment
                                                                   skills.
                         quick recapitulation.            budget limits. Analyse the results to see how managing your finances can      Algorithm: An algorithm is the sequence of steps or computer operations which collectively
                                                          lead to better economic stability.
                                                                                              solve a given problem.
                                                                                                 Cell reference: A cell reference is a cell address that can be used in a formula to denote a
                                                                                              specific cell.
                                                                            Interdisciplinary     Class: A class can be defined as a user defined blueprint or prototype that is used to create
                                                                                              objects.
                                                            Create a similar invoice in Excel.      E-commerce: E-commerce means to buy or sell products on an online service over the Internet.
                                                               Fill-up  details  of  the  five  items,  their
                                                                                                 Functions: Functions are predefined formulas in Excel to perform both simple and complex
                                                           quantities, and unit prices.       calculations.
                                                               Using the Product  function,  calculate  the      Gateway: A gateway is a network device that allows data to flow between two different
                                                           total amount for each item.        networks which may use different protocols.
                                                               Using the SUM function, calculate the total      Intranet: A computer  network  that  is used for sharing  information,  devices, and  other
                                                           amount.                            computing services only within an organisation.
                                                              Using a formula, calculate the GST according to the given rate.
                                                                                                 Legend: Legend is a key which shows the meanings of symbols and colours used in a chart.
                                                              Calculate the invoice amount payable.

                                                            Create an Excel worksheet and enter the following data:     Networking: The process of connecting computers and peripheral devices with each other,
                                                                                              so that they can exchange data is called computer networking.
                                                                                                 Operating System: An operating  system  is a system  software  that works as a mediator
                                                                                              between a user and computer hardware.
                                                                                                 Operator: An operator is a symbol that tells the compiler to perform specific mathematical
                                                                                              or logical operations.
                                                                                                Protocol: A protocol is set of standard rules used for communication.
                                                            Create a column chart based on the
                                                           above data. Title of the chart should be      User Interface: A User Interface (UI) refers to a part of an operating system that allows a user
                                                           ‘Yearly Sales  Chart’. The chart should   to interact with a computer.
                                                           look like this:                       Web app: A Web app is an application  program that  is stored on a remote server and
                                                                                              accessed over the Internet through a Web browser interface.
                                                                                                 Web Portal: A website that is specifically designed to provide a single point of access for
                                                                                              information is called Web portal.
                                                                                              152  iPRIME (Ver. 2.2)–VIII
                                                         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