Page 6 - iPrime_V2.2_class7
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
skills.
use conditional formatting to highlight any expenses that exceed your
quick recapitulation. budget limits. Analyse the results to see how managing your finances can
lead to better economic stability.
Interdisciplinary
Create a similar invoice in Excel.
Fill-up details of the five items, their
quantities, and unit prices.
Using the Product function, calculate the
total amount for each item.
Using the SUM function, calculate the total
amount.
Using a formula, calculate the GST according to the given rate.
Calculate the invoice amount payable.
Create an Excel worksheet and enter the following data:
Create a column chart based on the
above data. Title of the chart should be
‘Yearly Sales Chart’. The chart should
look like this:
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

