| Unit 9 - Week by Week Notes and Tutorials |
Back
to Bolgers Web Home Page |
|
| |
| Back
to Bolgers Web Home Page |
| Student Contract - Essential Requirements and Resources List 2007/08 |
| Why
not visit the MS
ACCESS LIBRARY if you get stuck |
| |
Week
01 - ( w/b 3rd Sept) Induction Week |
| |
| see induction activities |
| |
Week
02 - ( w/b 10th Sept) Unit 5 / Course
Overview |
| Lesson
Plan: |
Week
02 - Lesson Plan |
| Lesson
Aims: |
Week
02 - Aims |
| Class
Materials Used: |
Overview
of the Course / Unit
9 - programme of study |
| |
Unit 9 - Syllabus |
| |
Ice Breaker - Card Trick 01 |
| |
Ice Breaker - Card Trick 02 Part 1 |
| |
Ice Breaker - Card Trick 02 Part 2 |
| |
Class Notes - Databases and Fields |
| |
Activity 01 - Simple Database |
| Recap
/ Assessment: |
Week
02 - Lesson Recap Assessment |
| |
|
| More
Background / Reading: |
Additional Task - Card Trick 03 |
Week
03 - ( w/b 17th Sept) - Databases Jargon & Concepts |
| Lesson
Plan: |
Week
03 - Plan |
| Lesson
Aims: |
Week
03 Aims |
| Class
Materials Used: |
Class Lecture - What is a Database (ppt) |
| |
Class Lecture Databases overview (ppt) |
| |
Class Notes
- Database
Jargon and Concepts 1 |
| |
Class Notes
- Database
Jargon and Concepts 2 |
| |
script - Databases week 03 |
| |
On-Line
Notes - Databases
Quiz |
| |
On-Line
Notes - Quiz
on databases |
| |
On-Line Notes - Data
Types |
| |
On-Line
Notes - Relational
Databases |
| |
On-Line
Notes - Data
Validation |
| |
On-Line
Notes - Databases |
| |
Class Notes
- What
is a Relational Database ? |
| |
Class Notes
- What
are Key Fields ? |
| |
Additional Activity 01 - Creating Databases |
| |
Additional Activity 02 - Database
Activities |
| |
Download
- Databases
needed for Database Activities 01 and 02 |
| Recap
/ Assessment: |
Week
03 - Lesson Recap Assessment (submit for next week) |
| More
Background / Reading: |
Additional Tasks - Beginners Access Exercises |
| |
PowerPoint - database
00 database jargon |
| |
PowerPoint - database
00 Introduction to databases |
| |
Additional Class Notes
- Key
fields and Relationships |
| |
Powerpoint
'Introduction
to Database' |
| |
On-Line Resources - BBC Databases |
| |
On-Line Resources - Databases & Spreadsheets |
| |
Additional Class Notes
- Primary
and Foreign Keys |
| |
Quiz - Quiz
on database principles |
| |
Notes
- Key
fields and Relationships |
| |
Notes
- Drawing
Relationship Diagrams |
| |
Additional
Notes - Primary
and Foreign Keys |
| |
Notes
- What
are Key Fields ? |
| |
Notes
- Relationships
between tables |
| |
Activity
- Database
principles – activity 1 ( tennis club records exercises
) |
| |
Solution
- Tennis
Club exercise |
| |
Worksheet
- Database
Jargon 2 |
| |
Worksheet
- Database
Jargon 1 |
Week
04 - ( w/b 24th Sept) - Creating Tables , Forms & Relationships, Look up Fields |
| Lesson
Plan: |
Week
04 - Plan |
| Lesson
Aims: |
Week
04 Aims |
| Class
Materials Used: |
script - Databases week 04 creating tables, forms, command buttons, insertig lookup fields |
| |
Creating tables: selection of fields; choice of data types e.g. text, numeric, date/time; field properties e.g. field length, format, default value, fieldname; validation; modifying field characteristics |
| |
Powerpoint - Creating
tables |
| |
Notes - Explanation
of Creating tables powerpoint show |
| |
Download - Table Planning Template |
| |
Micro Teach 01 - Worksheet
- How to Create a Table |
| |
Micro Teach 02 - Mobile
Phone Database |
| |
Micro
Teach 01 - create
a college grading database |
| |
Micro
Teach 02 - simple
database exercise |
| Recap
/ Assessment: |
Week
03 - Lesson Recap Assessment |
| More
Background / Reading: |
Workbooks - Databases Library or Notes & Exercises |
Week
05 - ( w/b 1st Oct) - Creating Forms & Relationships, Look up Fields |
| Lesson
Plan: |
Week
05 - Plan |
| Lesson
Aims: |
Week
05 - Aims |
| Class
Materials Used: |
script - Databases week 05 |
| |
Forms: automatic creation of forms e.g. wizards; formatting forms e.g. titles, labels, arranging data entry order |
| |
download - last weeks database (doctors surgery) |
| |
Powerpoint
- Forms
- presentation |
| |
Tutor
Notes - Explanation
of Forms presentation |
| |
Micro
Teach 01 - Creating
forms |
| |
Micro
Teach 02 - Editing
forms (Part 1) |
| |
Micro Teach 03 - Editing forms (Part 2) |
| |
Micro Teach 04 - Quiz on database tables |
| Recap
/ Assessment: |
Week
05 - Lesson Recap Assessment |
| |
|
| More
Background / Reading: |
Workbooks - Databases Library or Notes & Exercises |
| |
|
Week
06 - ( w/b 8th Oct) - Creating Queries & Reports |
| Lesson
Plan: |
Week
06 - Plan |
| Lesson
Aims: |
Week
06 - Aims |
| Class
Materials Used: |
powerpoint - week 06 lesson |
| |
Queries: create queries sorting results e.g. date, numeric, alphabetical order
Reports: use of tables and queries as basis for reports |
| |
Micro Teach 01 - Airline Booking Database |
| |
Micro Teach 02 - Football Ticket Bookings |
| Recap
/ Assessment: |
Week
06 - Lesson Recap Assessment |
| |
|
| More
Background / Reading: |
Workbooks - Databases Library or Notes & Exercises |
| |
|
Week
07 - ( w/b 15th Oct) |
| Lesson
Plan: |
Week
07 - Plan |
| Lesson
Aims: |
Week
07 - Aims |
| Class
Materials Used: |
Issued - Assessment 9.0 |
| |
-
Discussed (give at least two examples) of the purpose of Database Software
- Explained positive concepts such as
a) efficiency of storage of information with
b) a minimum of data redundancy
- Explained the ease by which information can be extracted from the database as required.
- Explained Advantages storing data electronically in a database system
- Explained the Disadvantages storing data electronically in a database system
- Explained methods that can be used to promote data integrity
- Showed examples of database objects that could be created to assist the input, storage, processing and reporting of the shop’s pre-orders
- Showed an outline of possible data structures ( design view of a table ) that could be created (including identification of any primary key) to record the pre orders at Dream Factory.
- Explained what is Referential integrity;
- Explained the importance of data integrity and how it can be implemented and maintained with reference to a particular database (i.e. show examples)
- Explained the purpose of primary keys in building the relationships between tables.
- Explained the purpose of auto incremented Keys
- Explained how records and related records can be updated or deleted to ensure the integrity and consistency of the database is maintained;
|
| Recap
/ Assessment: |
Week
07 - Lesson Recap Assessment |
| More
Background / Reading: |
Workbooks - Databases Library or Notes & Exercises |
Autumn Half Term |
Week
08 - ( w/b 29th Oct) Queries: create queries using multiple criteria, use of AND, OR in criteria; selecting fields for display; sorting results e.g. date, numeric, alphabetical order |
| Lesson
Plan: |
Week
08 - Plan |
| Lesson
Aims: |
Week
08 - Aims |
| Class
Materials Used: |
Powerpoint
- Queries
- presentation |
| |
Notes
- Explanation
of Queries presentation |
| |
Micro
Teach - 01 - Queries
01 (Easy) |
| |
Micro
Teach - 02 - Queries
02 (Easy) |
| |
Micro
Teach - 03 - Queries
03 (Harder) |
| |
Consolidation catch up with Assessment 9.0
1 to 1 tutorials and time to complete any assessment of unit required |
| Recap
/ Assessment: |
Week
08 - Lesson Recap Assessment |
| |
|
| More
Background / Reading: |
Workbooks - Databases Library or Notes & Exercises |
| |
|
Week
09 - ( w/b 5th Nov) - Reports: use of tables and queries as basis for reports; automatic creation of reports e.g. wizards; selection of appropriate layouts; adding or editing appropriate labels and titles; special fields e.g. date/time; multiple criteria. |
| Lesson
Plan: |
Week
09 - Plan |
| Lesson
Aims: |
Week
09 - Aims |
| Class
Materials Used: |
Micro
Teach - 01 - Assessment
exercise 01 - Powerpoint Presentation |
| |
Micro
Teach - 02 - Assessment
exercise 02 - tables |
| |
Assessment
Activity 9.1 ( P1, P2, P3, P4 ) |
| |
Notes - Tips for writing up Assessment 9.1 |
| Recap
/ Assessment: |
Week
09 - Lesson Recap Assessment |
| More
Background / Reading: |
Workbooks - Databases Library or Notes & Exercises |
Week
10 - ( w/b 12th Nov) Assessment 9.1 – Presentation /Exhibition |
| Lesson
Plan: |
Week
10 - Plan |
| Lesson
Aims: |
Week
10 - Aims |
| Class
Materials Used: |
Deadline - Assessment 9.0 (P1, M2) |
| Recap
/ Assessment: |
Week
10 - Lesson Recap Assessment |
| More
Background / Reading: |
Workbooks - Databases Library or Notes & Exercises |
Week
11 - ( w/b 19th Nov) - Database basics: example uses of databases; advantages and disadvantages of computerised databases; database objects (tables, queries, reports, forms); data types; estimation of size of database) |
| Lesson
Plan: |
Week
11 - Plan |
| Lesson
Aims: |
Week
11 - Aims |
| Class
Materials Used: |
|
| |
|
| Recap
/ Assessment: |
Week
11 - Lesson Recap Assessment |
| |
|
| More
Background / Reading: |
Workbooks - Databases Library or Notes & Exercises |
| |
|
Week
12 - ( w/b 26th Nov) Issue Assessment 9.2 – Document a Database |
| Lesson
Plan: |
Week
12 - Plan |
| Lesson
Aims: |
Week
12 - Aims |
| Class
Materials Used: |
Assessment - Assessment
Activity 9.2 ( P5, M1, M2, D1 ) |
| |
|
| Recap
/ Assessment: |
Week
12 - Lesson Recap Assessment |
| |
|
| More
Background / Reading: |
Workbooks - Databases Library or Notes & Exercises |
| |
|
Week
13 - ( w/b 3rd Dec) Data integrity: data accuracy; consistency of data; validation rules eg lookup lists, default values, upper or lower limits |
| Lesson
Plan: |
Week
13 - Plan |
| Lesson
Aims: |
Week
13 - Aims |
| Class
Materials Used: |
|
| |
|
| Recap
/ Assessment: |
Week
13 - Lesson Recap Assessment |
| |
|
| More
Background / Reading: |
Workbooks - Databases Library or Notes & Exercises |
| |
|
Week
14 - ( w/b 10th Dec) - Technical documentation: fieldnames; field descriptions; field properties; primary keys, descriptions of forms, queries and reports; validation techniques used |
| Lesson
Plan: |
Week
14 - Plan |
| Lesson
Aims: |
Week
14 - Aims |
| Class
Materials Used: |
|
| |
|
| Recap
/ Assessment: |
Week
14 - Lesson Recap Assessment |
| |
|
| More
Background / Reading: |
Workbooks - Databases Library or Notes & Exercises |
| |
|
Week
15 - ( w/b 17th Dec) - Improving efficiency: shortcuts |
| Lesson
Plan: |
Week
15 - Plan |
| Lesson
Aims: |
Week
15 - Aims |
| Class
Materials Used: |
Reading Week / Consolidation catch up with Assessment
1 to 1 tutorials and time to complete any assessment of unit required
Deadline - Assessment 9.1 (P2, P3, P4) |
| |
|
| Recap
/ Assessment: |
Week
15 - Lesson Recap Assessment |
| |
|
| More
Background / Reading: |
Workbooks - Databases Library or Notes & Exercises |
Christmas Holiday Break |
Week
16 - ( w/b 7th Jan) - Undertake Pass Criteria |
| Lesson
Plan: |
Week
16 - Plan |
| Lesson
Aims: |
Week
16 - Aims |
| Class
Materials Used: |
Assessment 9.1 - Check List what to hand in - Tips |
| |
Hints - How to Write Up Ass 9.1 |
| |
Assessment 9.1 - Front Cover Sheet |
| Recap
/ Assessment: |
Week
16 - Lesson Recap Assessment |
| |
|
| More
Background / Reading: |
sample approach database |
| |
Workbooks - Databases Library or Notes & Exercises |
Week
17 - ( w/b 14th Jan) - Undertake Merit and Distinction Tasks |
| Lesson
Plan: |
Week
17 - Plan |
| Lesson
Aims: |
Week
17 - Aims |
| Class
Materials Used: |
Assessment 9.2 - Check List what to hand in - Tips |
| |
Hints - How to Write Up Ass 9.2 |
| |
Assessment 9.2 - Front Cover Sheet |
| Recap
/ Assessment: |
Week
17 - Lesson Recap Assessment |
| |
|
| More
Background / Reading: |
Workbooks - Databases Library or Notes & Exercises |
Week
18 - ( w/b 21st Jan - Submit and Mark Assessment 9.1 & 9.2) |
| Lesson
Plan: |
Week
18 - Plan |
| Lesson
Aims: |
Week
18 - Aims |
| Class
Materials Used: |
1 to 1 tutorials and time to complete any assessment of unit required |
| |
Deadline - Assessment 9.1 Front Cover Sheet (P1, P2, P3, P4) |
| |
Deadline - Assessment 9.2 F ront Cover Sheet (P5, M1, M2, D1) |
| Recap
/ Assessment: |
Week
18 - Lesson Recap Assessment |
| |
|
| More
Background / Reading: |
Workbooks - Databases Library or Notes & Exercises |
| |
|
| |
|