Page 6 - iPrime_V2.2_class4
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 provides
                      Chapter Profile: This section     a practical information or tip to
                      describes the objective of the           the students.                Clickipedia: This section
                               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 a       Fun in Lab: This is a lab
                                                           SDG Activity
                    summary of the chapter for quick     activity to develop practical        GLOSSARY    Subject Enrichment
                                                          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.
                            recapitulation.               use conditional formatting to highlight any expenses that exceed your      Algorithm: An algorithm is the sequence of steps or computer operations which collectively
                                                          budget limits. Analyse the results to see how managing your finances can
                                                          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