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!

OS!!!!

Operating System
The OS is running constantly in the computer system

Jobs of an OS (Mummy Operating System!)

+ Controls Security
+ memory management
+ file management
+ error reporting
+ schedules tasks (updates etc)
+ provides the HCI
+ controls the input and output devices

GPPS!

GPPS - General Purpose Package
* General Purpose because we can do more than one task with it (Word Processing - type letters, make posters, charts, graphics!)

- Presentation
- Desktop Publishing (DTP)
- Word Processing
- Database
- Graphics
- Spreadsheets

HOw do we communicate with the computer system!
Using a what!? - HCI (Human computer interface)

we use a WIMP! - Windows Icons Menu Pointer

Spell Checker!

Spell Checker has a built in dictionary
Puts a red line under misspelled words
It checks if each word is in the dictionary and if not puts a red line

1. you can ignore the spelling
2. add it to the dictionary
3. can choose from the words the dictionary has

are they always correct???

NO!!!! they are not great with names! surnames! Sheikh, Giblin, Farquharson ...

Word Processing

There are four types of Text Alignment (also sometimes called Justification)

1) Center
2) Left
3) Right
4) Fully Justified

Three ways to format text

1) Underline
2) Italic
3) Bold

Sequential Vs Direct Access

Sequential Access

* Sequential you cannot skip, must go through every memory location in turn to get to the one you need
* magnetic tape (My britney spears tape!)

Direct/Random Access
* you can skip directly to the location you reqiure
* CDs, external hard drives

The Processor -

The Processor!
The Brain of the Computer Systems

Input Devices
*Keyboard
*Mouse
*Webcam
*Scanner
*Touch Screen

Main Memory
*RAM - Random Access memory (Temporary) erased when the power is turned off
*ROm - Read Only memory (Permanent)

Output Devices
*Monitor
*Printer
*headphones
*speakers
*Projector

Backing Storage Devices
*Floppy Disks
*USB Pens
*CD-ROMS, RWs, R
*Magnetic Tapes
*External Hard Drives

Welcome to 3F 2011 Blog

Hi everyone in this class! Looking forward to the next two years together in class and we have a lot of hard work ahead of us!

Add a comment here for your first peice of homework!