Understanding
Computer
Systems
Exam
Scenario
Recap
Understanding
Computer
Systems
IN
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
LO
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
LO
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
Software
packages used by
Staff & Students
at Austin School
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
LO
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.”
LO
Understanding
Computer
Systems
Systems Software
• Operating systems
• Make your computer work!
“Understand what systems software is and why it
is important.”
LO
Understanding
Computer
Systems
Utility Software
• Virus Checkers, firewalls, computer
security.
• Keeps your computer safe!
“Understand what systems software is and why it
is important.”
LO
Understanding
Computer
Systems
Application Software
• Music software, MS Office, Games
• So your computer can do cools stuff!
“Understand what systems software is and why it
is important.”
LO
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
The Database used
by the Information
Management
System at Austin
School
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
LO
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”.
LO
Understanding
Computer
Systems
What is a database?
• Definition:
“A database is a
collection
of
data
or
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”.
LO
Understanding
Computer
Systems
Isn’t this just Excel?
• What makes a
database
different from
a
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”.
LO
Understanding
Computer
Systems
Computer-based databases
“Learn what a database is, what data types are and learn
why databases are useful and powerful tools”.
LO
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”.
LO
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
it
• 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”.
LO
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
LO
Understanding
Computer
Systems
Field
• Each of these is
one
piece of
information
about
you.
• Each of these
different types of
information
is
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
LO
Understanding
Computer
Systems
Field
“Learn what a database is, what data types are and learn
why databases are useful and powerful tools”.
LO
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
VD
LO
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
or
thing
.
“Learn what a database is, what data types are and learn
why databases are useful and powerful tools”.
LO
Understanding
Computer
Systems
Record
“Learn what a database is, what data types are and learn
why databases are useful and powerful tools”.
LO
Understanding
Computer
Systems
Fields and Records
“Learn what a database is, what data types are and learn
why databases are useful and powerful tools”.
LO
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
”.
LO
Understanding
Computer
Systems
Database Terms Recap
A
‘database’
is a
collection
of
data
or
information
which is stored in a
logical
and
structured
way.
A
‘field’
is
one
type or piece of
information
.
A
‘record’
is
all
of the
information
about one person
or one thing.
A
‘file’
is the
collection
of
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”.
LO
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”.
LO
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”.
LO
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
cy
Image
Text
Logical / Boolean
Date / Time
Auto Number
Numb
er
LO
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.
LO
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
25
81.64
3.14
-145
Relate it to
Austin School.
LO
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
15
th
June 2009
9:05am
14/03/12
17:55:32
15-02
-1979
Relate it to
Austin School.
LO
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.
LO
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
o
Relate it to
Austin School.
LO
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.
LO
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.
LO
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.
LO
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”.
LO
Understanding
Computer
Systems
Recap
Database
“Learn what a database is, what data types are and learn
why databases are useful and powerful tools”.
Relate it to
Austin School.
LO
Understanding
Computer
Systems
Recap
Query
“Learn what a database is, what data types are and learn
why databases are useful and powerful tools”.
Relate it to
Austin School.
LO
Understanding
Computer
Systems
Recap
Field
“Learn what a database is, what data types are and learn
why databases are useful and powerful tools”.
Relate it to
Austin School.
LO
Understanding
Computer
Systems
Recap
Record
“Learn what a database is, what data types are and learn
why databases are useful and powerful tools”.
Relate it to
Austin School.
LO
Understanding
Computer
Systems
Recap
File
“Learn what a database is, what data types are and learn
why databases are useful and powerful tools”.
Relate it to
Austin School.
LO
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.
LO
Understanding
Computer
Systems
Recap
Text
“Learn what a database is, what data types are and learn
why databases are useful and powerful tools”.
Relate it to
Austin School.
LO
Understanding
Computer
Systems
Recap
Number
“Learn what a database is, what data types are and learn
why databases are useful and powerful tools”.
Relate it to
Austin School.
LO
Understanding
Computer
Systems
Recap
Currency
“Learn what a database is, what data types are and learn
why databases are useful and powerful tools”.
Relate it to
Austin School.
LO
Understanding
Computer
Systems
Recap
Boolean
“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
- Slide 1
- IN SILENCE!
- Learning Outcomes
- Activity 2 – A/A* Grade
- Activity 2 – A/A* Grade
- Slide 6
- Learning Outcomes
- Types of Software
- Systems Software
- Utility Software
- Application Software
- Task
- Slide 13
- Learning Outcomes
- What is a database?
- What is a database?
- Isn’t this just Excel?
- Computer-based databases
- Advantages of computer-based databases?
- Disadvantages of computer-based databases?
- Database Terms
- Field
- Field
- Field
- Record
- Record
- Fields and Records
- File
- Database Terms Recap
- Database Worksheet
- Database Games
- Data Types
- Data Type: Text
- Data Type: Number
- Data Type: Date / Time
- Data Type: Currency
- Data Type: Logical / Boolean
- Data Type: Image
- Data Type: Auto Number
- Database Worksheet
- Recap
- Recap
- Recap
- Recap
- Recap
- Recap
- Recap
- Recap
- Recap
- Recap
- Recap
Wyszukiwarka
Podobne podstrony:
PREZENTACJA HOSPICJUM 15,11,13
Ćw nr 15, Niepewność Pomiarowa, 11,13-11,23
2 11 Nowe technologie i cyfryzacja 15 05 13
akumulator do smart car forfour 11 13 15
akumulator do mitsubishi colt vi 11 13 15
akumulator do mazda 323 ii hatchback bd 11 13 15
akumulator do peugeot 205 i 741ac 09 11 13 14 15
akumulator do fiat fiorino 147 10 11 13 15
akumulator do mazda 323 iii hatchback bf 11 13 15
11 13
15 11 201 WYKŁAD VI
06 11 13 tabelka
153 USTAWA rozdz 1 4, 7, 9, 11, 13 o ochronie zabytków i opiece nad zabytkami {D
Odpowiedzi 1 3 5 8 9 11 13 id 3 Nieznany
Psychologia zachowań intepresonalnych 15.11, notatki, psychologia
plan 15.11-26.11, plany, scenariusze, Plany
15. Rozdzial 13
Podstawy Marketingu 15.11.2009
więcej podobnych podstron