# Free Financial Spreadsheets - PowerPoint by nicknameD

VIEWS: 198 PAGES: 12

• pg 1
```									The Information Age Needs
Tools for Managing Numbers in the
Information Age

v   People used a pencil, eraser, and paper to
arrange their numerical data into rows and
columns.
v   Problems:
– Lack of flexibility
– Slow in calculation
– Incapable of sophisticated modeling
v   Single-Purpose Software
– VisiCalc
– EXCEL
v   Integrated Software
– LOTUS 1-2-3: combines spreadsheet with compatible graphics
and data base programs;
– Microsoft Works: combines spreadsheet with word processing,
data base, communication, and graphic capabilities.
v   Learner Programs
– The Cruncher (Davidson, Grades 5 up)

v   Quickly performs calculations
v   Storage capability
v   Ease of the change of data
v   Accept formulas and functions as values
v   Neatness
v   Sophisticated numerical and financial
modeling

– Budgeting
– Modeling Economic Trends
– Managing Resources
v   Schools
– Teachers
– Students
What Can Students Learn?
v   Organization of Numeric Data
– Spreadsheet grids provide students with an organizational
pattern which helps them categorize data and arrange it into
labeled, ordered rows and columns.
v   Practical Work With Formulas, Functions
– Spreadsheets provide an ideal environment to apply
mathematical concepts to “real-world” situations
v   Projection, “What-if” Thinking
– Spreadsheets facilitate hypothesis testing and modeling in
different subject areas
– Spreadsheets encourage number play which can build
estimation, problem-solving, concept development, and
intuitive mathematical skills

– Create templates according to personal needs & style
– Ease and efficiency of calculation and data revision
– Convenience in saving student data
v   Class/Club Records
– Track financial transactions
– Model a projected situation
– Make and keep performance records
Benefits for Students

Mathematical Self-
Confidence
Flexibility
Versatility
v   Cell:
– each of the possible locations on a spreadsheet, specified by
its row and column.
v   Label:
– a collection of alpha-numeric characters used to identify
v   Value:
– numerical data.
v   Formula:
– a function that describes the relationship between various
v   Template:
– the design for a particular spreadsheet which contains all the
labels and formulas. A data-free spreadsheet design.

=C5+D5

Labels             Cost      Tax     Total

Values              \$35.99   \$2.79   \$38.78
Cell

Formula