Slide 1

Understanding
Computer
Systems

SILENCE

1. Find a seat
2. Get out a pen
3. Get out your pre-release
4. Get out your revision plan
5. Do

NOT TOUCH

anything!

6. Sit in

SILENCE

21-12-28

Understanding
Computer
Systems

Learning Outcomes

• ALL students will be able to explain(C) what

the exam pre-release scenario is about.

• MOST students will be able to compare(B) and

contrast(A) pre-release scenarios to the
revision topics and annotate the scenario with
page references so they know what to revise.

• SOME ALL students will be able to reflect(A) &

consider(A*) their own needs revision needs
against the scenario and plan out a detailed
and structure revision planner to follow.

21-12-28

Understanding
Computer
Systems

Activity 2 – A/A* Grade

“Learn about back-up and recovery systems.”

ALL students will be able to

reflect(A) & consider(A*) their own

needs revision needs against the

scenario and plan out a detailed and

structure revision planner to follow.

• Talk through your

revision plan with your
partner.

• 2 mins

Understanding
Computer
Systems

Activity 2 – A/A* Grade

“Learn about back-up and recovery systems.”

ALL students will be able to reflect(A) &

consider(A*) their own needs revision needs
against the scenario and plan out a detailed

and structure revision planner to follow.

• Look at my copy of the marked up pre-

release.

• Compare it with yours.

• Modify your revision plan to make sure

you have not missed anything

• 5 mins

• Discuss with partner

• 2 mins

Understanding
Computer
Systems

Learning Outcomes

• All students will be able to explain(C)

what types of application, utility and
systems software might be used by
staff and students at Austin School.

• Most students should be able to

Analyse(B) and Link(A) this
knowledge and suggest why the staff
and students will use these pieces of
software, for what jobs and reasons?
To produce what?

21-12-28

Understanding
Computer
Systems

Types of Software

•All computer software falls

into one of 3 categories.

•Can you remember what they

are and what they are for?

“Understand what systems software is and why it

is important.”

Understanding
Computer
Systems

Utility Software

• Virus Checkers, firewalls, computer

security.

• Keeps your computer safe!

“Understand what systems software is and why it

is important.”

Understanding
Computer
Systems

Task

• List

all the software you think staff

and students might use at Austin
School.

• For each piece of software

explain

– Which

Scenario it relates to (1/2)

– Who

will be using it (staff/data team/students)

– What

type

of software is it?

– What's

the

purpose

of the software, what's it for?

– Some examples of the software that are on the

market (e.g. Spreadsheet = Excel)

“Understand what assistive technologies are and

what affects they choice of a system.”

Understanding
Computer
Systems

Learning Outcomes

• ALL students WILL be able to explain(C)

what a database is and why it is a powerful
piece of application software for the Austin
School Information System to plug into.

• MOST students WILL appreciate(B) and

Link(A) a range of different “types of data”
that the Austin School database will need to
store on its pupils and why they are needed
in a database.

• SOME students WILL consider(A*) how the

database will be used in the day to day
running of the school at its Data Team.

21-12-28

Understanding
Computer
Systems

What is a database?

• What is a

database

• Any ideas?

• Hands up!

“Learn what a database is, what data types are and learn

why databases are useful and powerful tools”.

Understanding
Computer
Systems

What is a database?

• Definition:

“A database is a

collection

data

information

which is stored in a

logical

and

structured

way”

“Learn what a database is, what data types are and learn

why databases are useful and powerful tools”.

Understanding
Computer
Systems

Isn’t this just Excel?

• What makes a

database

different from

spreadsheet

• Isn’t this just

Excel

? NO!

P26 – 3 mins.

Going to ask you the

DIFFERENCE

between a spreadsheet and a database.

“Learn what a database is, what data types are and learn

why databases are useful and powerful tools”.

Understanding
Computer
Systems

Advantages

of computer-based

databases?

• Can easily make back-up copies
• Can easily make changes
• Can easily sort data into order e.g.

Alphabetic

• Can search for particular records

very quickly

• Can import or export data to/from

other programs

“Learn what a database is, what data types are and learn

why databases are useful and powerful tools”.

Understanding
Computer
Systems

Disadvantages

of computer-based

databases?

• Can be expensive to set up if you

have to get a professional to make it

• If there is a power-cut, you can’t use

• You need to have a computer
• Cannot carry it around with you
• You often need training to learn how

to use them

“Learn what a database is, what data types are and learn

why databases are useful and powerful tools”.

Understanding
Computer
Systems

Database Terms

• Austin school will keep a lot of

information

about

each of its students.

• Think of some of the

information

it might keep

about them?

“Learn what a database is, what data types are and learn

why databases are useful and powerful tools”.

d.o.b.

Address

Allergies

Parent’s

names

Phone number

Illnesses

Doctor’s

name

Name

Understanding
Computer
Systems

Field

• Each of these is

one

piece of

information

about

you.

• Each of these

different types of

information

called a “

Field

”.

“Learn what a database is, what data types are and learn

why databases are useful and powerful tools”.

d.o.b.

Address

Allergies

Parent’s

names

Phone number

Illnesses

Doctor’s

name

Name

Understanding
Computer
Systems

Field

• A shop selling DVD’s has a

database

• What would be some of the

field

names in

their

database

“Learn what a database is, what data types are and learn

why databases are useful and powerful tools”.

Price.

Actors

Running

time

Genre

How many in stock

Title

of D

Understanding
Computer
Systems

Record

• All of the ‘

fields

’ are put together to

make a ‘

record

’.

• A ‘

record

’ is all of the

data

about one

person

thing

“Learn what a database is, what data types are and learn

why databases are useful and powerful tools”.

Understanding
Computer
Systems

File

“Learn what a database is, what data types are and learn

why databases are useful and powerful tools”.

All of the “

records

” are stored

together as a “

file

”.

Understanding
Computer
Systems

Database Terms Recap

‘database’

is a

collection

data

information

which is stored in a

logical

and

structured

way.

‘field’

one

type or piece of

information

‘record’

all

of the

information

about one person

or one thing.

‘file’

is the

collection

all

the

database

records

on one topic or subject.

“Learn what a database is, what data types are and learn

why databases are useful and powerful tools”.

Understanding
Computer
Systems

Database Worksheet

• Let’s see what you can remember.

• Complete the “

Database Questions

”

worksheet.

• You have 5 mins. Go!

“Learn what a database is, what data types are and learn

why databases are useful and powerful tools”.

Understanding
Computer
Systems

Database Games

•Time to place a

database

game, where

YOU

get to act

as the

database

“Learn what a database is, what data types are and learn

why databases are useful and powerful tools”.

Understanding
Computer
Systems

Data Types

• All

information

or “

Data

” in a

database

has a “

Data Type

”.

“Learn what a database is, what data types are and learn

why databases are useful and powerful tools”.

Curren

Image

Text

Logical / Boolean

Date / Time

Auto Number

Numb

Understanding
Computer
Systems

Data Type: Text

The

Text

data type

can be used to store?

• Used for fields which contain

a mixture of letters and
numbers

e.g. names, postcodes

“Learn what a database is, what data types are and learn

why databases are useful and powerful tools”.

Stroud

GL5 4AX

Sally

rose

Spiderman

butte

rfly

Relate it to
Austin School.

Understanding
Computer
Systems

Data Type: Number

“Learn what a database is, what data types are and learn

why databases are useful and powerful tools”.

The

Number

data type

can be used to store?

• Can contain whole numbers
• Can contain decimals
• Can be negative

e.g shoe size, height, exam
mark

-3.75

76598

81.64

3.14

-145

Relate it to
Austin School.

Understanding
Computer
Systems

Data Type: Date / Time

“Learn what a database is, what data types are and learn

why databases are useful

and powerful tools”.

The

Date / Time

data

type can be used to
store?

• Many different date and time

formats allowed

e.g. Date of birth, date you
started school, time of an exam

23:45

June 2009

9:05am

14/03/12

17:55:32

15-02

-1979

Relate it to
Austin School.

Understanding
Computer
Systems

Data Type: Currency

“Learn what a database is, what data types are and learn

why databases are useful and powerful tools”.

The

Currency

data

type can be used to
store?

• Used to store any data about

money.

• Many different currencies

allowed

€500

£9.99

£0.55

37p

£1995

$57

Relate it to
Austin School.

Understanding
Computer
Systems

Data Type: Logical / Boolean

“Learn what a database is, what data types are and learn

why databases are useful and powerful tools”.

The

Logical / Boolean

data type can be used
to store?

• Only 2 options allowed

true/fa

lse

on/off

m/f

in/out

night/day

yes/n

Relate it to
Austin School.

Understanding
Computer
Systems

Data Type: Image

“Learn what a database is, what data types are and learn

why databases are useful and powerful tools”.

The

Image

data type

can be used to store?

• Stores images / photos

Relate it to
Austin School.

Understanding
Computer
Systems

Data Type: Auto Number

“Learn what a database is, what data types are and learn

why databases are useful and powerful tools”.

The

Auto Number

data type can be used
to store?

• Every

record

in a database

has to be

unique

• The

Auto Number

data type

can add a “

unique

” number

to each

record

Auto

Number

Relate it to
Austin School.

Understanding
Computer
Systems

Database Worksheet

• Let’s see what you can remember.

• Complete the “

Data Types

”

worksheet.

• You have 5 mins. Go!

“Learn what a database is, what data types are and learn

why databases are useful and powerful tools”.

Relate it to
Austin School.

Understanding
Computer
Systems

Recap

• Let’s see what you can remember

from todays lesson.

• Terms are going to appear on the

board. Hands up if you can tell me
what they mean!

“Learn what a database is, what data types are and learn

why databases are useful and powerful tools”.

Understanding
Computer
Systems

Recap

Data

Type

“Learn what a database is, what data types are and learn

why databases are useful and powerful tools”.

Relate it to
Austin School.

Document Outline