Other slides in this set

Slide 2

Preview of page 2

Here's a taster:

Choosing between word processing or DTP
When mostly text and few graphics,
Create a range of documents e.g. leaflets, newsletters,
Layout can be changed more easily
Used when lots of text and graphics need o be layered or
Mail Merge: combining information from a data source with a standard document to allow the user to create and
send a personalised version of the same document to many different recipients.
Process of Mail Merge:
1. Data source is created,
2. Standard Document is created,
3. The two are then linked and merged by selecting fields
4. Mail merge completed.
Advantages of Mail Merge:
Documents can be produced very quickly,
Only one copy needs to be proofread,
The same data source can be used for many different mail merges,
The standard letter can be saved and reused.…read more

Slide 3

Preview of page 3

Here's a taster:

Word Fields- to customise mail merge e.g. only send to those who line in London.
ASK- used to prompt the user for information that was no included in the data source.
FILL IN- used to prompt the user for information that was no included in the data source.
IF...THEN...ELSE- sets conditions to limit which records are printed e.g. all males only
NEXT RECORD- used to merge the next data record into the current merged document rather
than creating a new one.
SKIP RECORD IF- used to miss a record if it meets the conditions, 2 conditions are compared
and if the comparison is true it will skip the next record in the data source and start a new merge.…read more

Slide 4

Preview of page 4

Here's a taster:

Two types of modelling:
Modelling of objects- virtual representation within PC, e.g. buildings under earthquake
You have the ability to ask questions of the model, change the components and see how they
Mathematics modelling-
Using spreadsheets to represent mathematical elements.
Can use functions and formulas, so numbers can be automatically recalculated,
You can ask "What IF?" questions so that the scenarios change and you can see the result,
Based on a layout of rows and columns,…read more

Slide 5

Preview of page 5

Here's a taster:

Why use models?
Safer to test on screen than in reality and also cheaper if anything goes
Only one model needs to be made,
Models can be backed up and shared, as it is electronic they can be
emailed and sent to a third party for improvements.
Can speed up and slow down the effects
4 features of models:
· Variables- an identifier. Variable can be a cell reference or name
· Formulae- is a mathematical expression in a spreadsheet cell that is
automatically calculated. It is the way that the calculation is
represented in a spreadsheet e.g. B12+B24
· Function- predefined formula that can be entered into a cell to carry
out a calculation. It is used to represent a formula that is too
complex or long e.g. SUM, LOOKUP
· Rules- sets of procedures that must be followed, e.g. school report…read more

Slide 6

Preview of page 6

Here's a taster:

CELL: a single addressable location on a spreadsheet. The address of the cell is given
by the labels of the column and row it is in. Every cell can be uniquely identified and
cells can also be formatted and protected.
RANGE: a group of cells, the group can be given a name or cell reference e.g. A4:B6
ROWS AND COLUMNS: used to organise data. A row goes across, columns go down
WORKSHEET: a large range of cells. Used to hold data on a single area of a business
e.g. sales for each month.
WORKBOOK: a set of linked worksheets in a spreadsheet.
Advantages- data changed in one worksheet will automatically change in all worksheets.
Access rights can be given to different worksheets.
Relative and Absolute cell referencing:
Relative- when the cell referenced in a spreadsheet formula changes when the formula is copied to
other cells.
Absolute- when the cell referenced in a spreadsheet formula remains exactly the same when the
formula is copied to other cells. E.g. adding VAT to the cells.…read more

Slide 7

Preview of page 7
Preview of page 7

Slide 8

Preview of page 8
Preview of page 8

Slide 9

Preview of page 9
Preview of page 9

Slide 10

Preview of page 10
Preview of page 10


No comments have yet been made

Similar ICT resources:

See all ICT resources »See all resources »