Everything!!

To print certain things - set print area

To stop cells changing - cell protection

To find the highest

= max(b2:b4)

to find the lowest

= min (b2:b4)

to find the average

= average (b2:b4)

to find the total

= sum (b2:b4)

to subtract

= b2 - b4

to add

= b2+b4

to divide
=b2/b4


Four Labels of a fully labelled chart

x axis
y axis
title
key / legend

IF STATEMENTS!!!

= if (b2>b3, "True", "False")

= if(age >=18, "DRINK!!!!", "No drinking")

=if(age <=16, "No Lottery", if(age >=65, "BINGO!", "Play the lottery!"))

Spreadsheets!

What does Replication mean!?
Copying! (when you copy a formula!)

There are two types of replication (two ways we can copy a formula)

Relative Referencing
* When you copy a formula, the formula will change to suit the new cells it is copied into

Absolute Referencing
Absolute means the formula will not change when replicated and it uses the $$$$$$ to show it is absolute!

Intro To 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)

Some Important Stuff!

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

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

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

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

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

Static V Dynamic

Data Linkage

Static - when you create a document (eg spreadsheet) and copy into another document (eg a word processing) and you change the original the copy is unaffected.


Dynamic - in this case, when you change the original the copy changes to the exact same as the original!

Standard Paragraph

Pre typed saved paragraphs that you can INSERT! into documents saves time re-typing as its already made, spell checked, formatted etc!

Integrated Packages

Integrated Packages

A package with more than 2 GPPS (General Purpose Packages) combined in the one package


Advantages

+ cost less than buying all the individual GPPS
+ the interface (HCI) will be the same in each part of the package
+ you can transfer data between the seperate parts of the package

Disadvantages

- some of the features are removed(like Grammar Checker)

The Computer Acts

Data Protection Act
*Data Subjects - the person who the data is about!
+ I have the right to see my personal information (not always!)
- not allowed to see it if its connected to crime, national secirity or collection of taxes
+ ask to have incorrect info changed
+ compensation if the act is broken

*Data Controller - the person who holds the information and are responsible for it!
+ to keep it up to date, accurate
+ only show it to the person who its about
+ dont keep it longer than necessary
+ not to transfer the info outside of the EU
+ take measures to keep it safe and secure
Copyright, Designs and Patents Act
* illegally copying (movies, images, songs) downloading without paying for it

Computer Misuse Act
* Hacking (accessing accounts without permission)
* Creating and distributing viruses

Laser Vs Inkjet

Resolution measured in DPI (Dots per Inch)

Features to Compare printers on are ...

PPM - pages per minute,how quick it prints
Quality of prints - resolution in DPI
Physical size
Price
Long Term costs (ink is more expensive than toner)
Extra Features


Inkjets - Slower PPM but have higher resolution but better quality prints

Lazer - faster PPM but less quality print outs

The OS!

OS - operating system

it starts running when the power is turned on and stops when it is turned off. So it is running constantly.

Jobs of the OS?

- Reporting Errors
- Schedules Tasks
- File management and memory management
- Provides the HCI
- Controls the input and output devices
- Controls security

GPPS!

Gpp - General Purpose Package

General purpose because you can do more than one task with it (type letters, make charts, create posters ....)

* Spreadsheets
* Desktop Publishing (DTP)
* Presentation
* Databases
* Graphics
* Word Processing

WIMP (is the interface we use!)
- Windows
- Icons
- Menus
- Pointer


HCI

Human Computer Interface, how you communicate with the computer to give instructions and recieve information

Ma Shpellin iz rubbesh!

How does a Word Document become so well spelled!?

Spell Check!

*It checks each word with a dictionary (it's own built in dictionary)

* puts a red line under words it thinks are spelled incorrectly

* You can ignore it, add this word to the dictionary, change it to a word from the options given

:( - it's not great with peoples names (msotly surnames!)

Two Types of memory 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 5 box Processor Diagram

THE PROCESSOR
* The Brain of the Computer System

BACKING STORAGE DEVICES
* Floppy Disk
* USB pen drive
* External Hard Drive
* DVD

INPUT DEVICES
* mouse
* keyboard
* touch screen monitor
* scanner

OUTPUT DEVICES
* speakers
* printer
* projector
* monitor

MAIN MEMORY
* Random access memory - RAM - deleted when the power is turned off (TEMPORARY)
* Read Only memory - ROM - permanent

Welcome to 3H 2011 Blog

Hello 3H! Looking forward to two years of hard work at standard grade with you guys!

Post a comment on here for your first piece of homework!