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

