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

