Spreadsheets
An electronic spreadsheet package is
an application package that enables you
to carry out numerical work easily and
flexibly. It enables you to store not
only numerical data but also formulae
to carry out operations on the
numerical data.
Relative Advantage
Saves Time
Manage data in various formats
Complete essential calculations quickly
Automatic recalculation
Relative Advantage
Creates Charts
A way to view data in various formats (enable
students to make important visual discoveries
about their data.)
Relative Advantage
“What-if” Questions
Visualize the impact of changes in numbers.
Lets you create a plan, plug in different
assumptions and immediately see the impact
on the bottom line.
Relative Advantage
Motivational
Make working with numbers more fun
Graphical representation of data
Spreadsheets in the
Classroom
• Teacher Productivity
Grade keeping
Cheque books
Budgets
Attendance charts
Performance assessment checklists
Spreadsheets in the
Classroom
Instructional Activities
Demonstrations (concepts such as
multiplication and percentages)
Student Products (charts and graphs)
Support for Problem Solving (Allow
students to focus on higher level concepts)
Storing & Analyzing Data
Projecting grades
Features of Excel Equivalent or
Similar to Word
In Excel, all the basic commands such as Open,
New, Close, Save and Save As, work in the same
way as they do in Word. The only difference to
note is that when you save an Excel file it is given
the file extension .xls
Other features which are similar are Spell Check,
Find and Replace, Page Setup for margins, Page
Orientation, and many of the formatting features.
Spreadsheets
Features
Formulae
Functions
Absolute cell references
Filtering records
IF function
Vlookup
Formulae
A formula is an instruction to perform operations
on values. Depending on the package you are
using, a formula must start with one of the
following a special symbols (e.g. +, –, @, =) to
identify it as a formula. All formulas in excel
start with an equal sign (=).
Functions