Spreadsheets 2!

What is meant by Replication? - Copying a formula

Two types of Referencing are ...

Absolute ($$$$$$)
When you copy a formula and it doesnt change to suit the new cells

Relative
the formula does change/adapt to the new cells

Spreadsheets

Spreadsheets are made up of CELLS!! ( and they can contain TEXT, NUMBERS OR FORMULAE)

A number of cells vertically (up and down) is called a COLUMN

A number of cells horizontally (left to right) is called a ROW


We use Spreadsheets for calculations using formula and can make charts

Four Labels a Fully Labelled Chart should have are ...

X Axis
Y Axis
Title
Key (Legend)

A lot of stuff ...

Search and Replacelets you change all the occurrences of one word to another by "searching" for a word and telling it what to "replace" it with

Online Helpwritten instructions that you have to read and follow, better for experienced users

Online Tutorialvideo demonstrations or guided lessons that show you what to do, better for beginners

Templatepre-made blank documents with placeholders that let you insert text, images, videos, sounds, charts ...


Wizarda walk through guide that takes you through the steps to create documents, install programs etc

Dynamic V Static

Data Linkage!

Dynamic Data Linkage -
When you create an original document (spreadsheet) and copy the spreadsheet to another document. If you make changes to the original the dynamic link will mean that the copy is changed as well. It changes to the same as the original

Static Data Linkage -
There is no link and when the original is changed, nothing happens to the copy!

A lot of stuff ...

When a word processor automagically takes a new line its called ...

Word Wrap

Integrated Packages

two or more gpps in the one package

+ cheaper, than buying all the gpp's seperately
+ HCI (menus etc) are all the same
+ can link all the data between the seperate parts of the package

- some of the features (grammar checker!) are left out!

Standard Paragraph
pre-written piece of text (already spell checked) that you can insert into documents

saves you time retyping etc
*permission slips, season tickets, letters from the bank

Computing Acts

Copyright, Designs and Patents Act
+ download music, movies, images, software without permission or without paying out

Computer Misuse Act
+ Hacking (breaking into personal files, accounts without permission)
+ Creating and Sending Viruses

Data Protection Act
Data Subjects - are the people that information is held on and we HAVE RIGHTS!!!!
+ to change wrong information
+ compensation if the act is broken
+ allowed to see the information held on you (for a fee!) but not always ...
- not if its a matter of national security
- if its to prevent or detect crime

Data Controller - person who is responsible for looking after the information
their responsibilites are ...
+ keep it up to data and accurate
+ not keep it for longer than necessary
+ take security measures to prevent it being deleted or altered
+ only show it to the data subject
+ not transfer to companies outside the EU

Inkjet Vs Laser

Resolution - measured in DPI
Dots Per Inch

Features to Compare printers

Price
Resolution
PPM (pages per minute) speed of printing
Size
Running costs (ink vs toner, maintenance, paper, electricity)
Noise!

Inkjet V Laser (fight)
inkjets are higher quality prints but slower PPM
laser are faster at printing but are lower quality
costs - inkjet more expensive long term because of ink!