ICT revison notes for spreadsheets

HideShow resource information
Preview of ICT revison notes for spreadsheets

First 354 words of the document:

IT chapter 4 spreadsheet revision
Modelling
Object modelling Financial modelling
Allow a virtual representation to be Often done with spreadsheets
created
Model is interactive: it can be rotated, Easy layout in rows and columns so
zoomed in and out, and different layers everything is logical and easy to follow.
(external or internal view) can be seen
Allows components to be changed and Easy replication of formulas and
see how it effects the overall model functions, and cell contents both
horizontally and vertically.
The model can be tested without using Formulas can perform calculations on
the real thing so no lives are put at risk data and automatically update when
data is changed.
Only one model has to be made, if Functions can create complex formulas
changes are made there is no need to to work out more complicated
build a new model each time something calculations
is changed like the real thing, this saves
time and money
They can be speeded up or slowed down Variables can hold key data about the
model
A lot of testing is needed to create a They can be used by different people
good model in different locations due to the use of
email
Expensive computer software may be They can be backed up one more than
needed to create a good model one computer
Some things are hard to model as they Values in spreadsheets can be turned
have lots of variables e.g. human into a graph automatically which offers
behaviour easy layout of data and a chance to see
any trends in the data clearly.
They can perform `what if' analysis.
Values can be changed by the user to
see what effect that would have on end
results.
Variables, formulas, functions and rules
Variables
An identifier associated with a particular cell, in the cell there is a value.
Is could be a cell reference e.g. D4

Other pages in this set

Page 2

Preview of page 2

Here's a taster:

Or it could be a cell name e.g. VAT_RATE
Formulas
An instruction to the computer to process data held in specific cells
He way the calculation is represented on the spreadsheet
Formulas use addresses of cells (cell references or names) and mathematical
operators such as * or /
Example of a formula can be: A12 +(A12*VAT_RATE)
Rules
A set of procedures that must be followed
E.g.…read more

Page 3

Preview of page 3

Here's a taster:

It can be shared with different people Some things have lots of variables and
via email are hard to model like human behaviour
No additional software is needed as
spreadsheets are standard business
software, most people know how to use
them so no training is needed
Quicker and cheaper to build a
computer model than the real thing
Only one model needs to be built which
can be changed, a physical model would
need to be rebuilt each time a change is
made.…read more

Page 4

Preview of page 4

Here's a taster:

Columns
A range of cells that run vertically down the page
They are identified by letters
If a column is deleted then they are renumbered automatically
A column can be hidden from the user
Cell
A data store that holds a piece of data
They are identified by their row and column they are in e.g. S6
Each cell has a unique address and they can be given names to identify them.
Each cell can be formatted individually e.g.…read more

Comments

Mr A Gibson

A decent set of notes which covers the basics and some more complex facts such as examples of some functions. Gives a good in depth coverage of the basics which will help with exam questions.

Similar ICT resources:

See all ICT resources »See all resources »