Page 6 - iPrime_V2.2_class1
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
                                                         Use Excel to create a budget tracker where you input your weekly savings
                     a summary of the chapter for        activity to develop practical
                                                         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.
                                                                                                 E-commerce: E-commerce means to buy or sell products on an online service over the Internet.
                                                           Create a similar invoice in Excel.
                                                                                                 Functions: Functions are predefined formulas in Excel to perform both simple and complex
                                                              Fill-up  details  of  the  five  items,  their   calculations.
                                                          quantities, and unit prices.
                                                                                                 Gateway: A gateway is a network device that allows data to flow between two different
                                                              Using the Product  function,  calculate  the   networks which may use different protocols.
                                                          total amount for each item.            Intranet: A computer  network  that  is used for sharing  information,  devices, and  other
                                                                                              computing services only within an organisation.
                                                              Using the SUM function, calculate the total      Legend: Legend is a key which shows the meanings of symbols and colours used in a chart.
                                                          amount.
                                                             Using a formula, calculate the GST according to the given rate.     Networking: The process of connecting computers and peripheral devices with each other,
                                                             Calculate the invoice amount payable.  so that they can exchange data is called computer networking.
                                                                                                 Operating System: An operating  system  is a system  software  that works as a mediator

                                                           Create an Excel worksheet and enter the following data:  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.
                                                                                                 User Interface: A User Interface (UI) refers to a part of an operating system that allows a user
                                                                                              to interact with a computer.
                                                                                                 Web app: A Web app is an application  program that  is stored on a remote server and
                                                           Create a column chart based on the   accessed over the Internet through a Web browser interface.
                                                         above data. Title of the chart should be      Web Portal: A website that is specifically designed to provide a single point of access for
                                                         ‘Yearly Sales  Chart’. The chart should   information is called Web portal.
                                                         look like this:
                                                                                              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