|
WEEK |
ICT1 |
ICT3 |
|
1
|
Introduction to ICT1
-Specification
-Expectations
-Organisational/study skills
-Useful sites
|
Introduction to ICT 3
-Coursework requirements.
-Mark scheme
-Create coursework web page using sources from
Links
-Review sample database
|
|
|
|
|
|
2
|
Knowledge, Information & Data
-Define (with examples) data, information and knowledge in an
ICT context.
-Data sources.
-Coding data (benefits & drawbacks)
-Coding value judgements
|
Introduction to databases crash course
-Table design - Key concepts/terms
-Naming conventions
-Primary/foreign keys
-Why data type & field size matter.
|
|
|
|
|
|
3
|
Control of Information
-Concept of personal info (who holds what info?)
-Rights of the individual.
-Access levels.
|
Introduction to validation
-Purpose
-Validation rules
-Validation text
-Uses/limitations of input masks
|
|
|
|
 |
Mott & Rendell
pages 31-34 |
|
|
McW RDBMS Design
pages 38-42 |
 |
Validation tutorial |
| |
|
|
|
4
|
Value and Importance of Information
-Info as a commodity. Uses of info
-Why is info valuable?
-What makes info valuable?
-Cost of ensuring info is up-to-date
|
The Relational Database Approach I
-Rationale
-Entity-relationships
-Resolving many-to-many relationships
-Referential integrity
-Cascading updates/deletes
|
|
|
|
|
|
5
|
ICT - Capabilities & Limitations
-What ICT is good at.
-Characteristics of ICT systems
-Limitations of ICT.
-Feedback
ICT & the Professional
Qualities of the ICT professional.
|
The Relational Database Approach II
-Practice
-Practise
-How the hell do you spell practice/practise?
|
|
|
|
|
|
6
|
The Social & Economic Impact of ICT
-ICT in Business and Commerce
-ICT in Manufacturing
-Employment issues
-ICT in a Caring Society
Test: Weeks 1 - 5
|
Introduction to queries
-Single table select queries
-Operators
-Multiple table select queries - which fields?
-Calculated/concatenated fields
-Parameter queries
|
|
|
|
|
|
Half-term - lounge about until the last minute and then try to
look busy ;-)
|
|
|
|
WEEK |
ICT1 |
ICT3 |
|
7
|
Role of Communication Systems
-The Internet - introduction
-Merits of various communication facilities
-Recent developments
-Mobile bloody phones
Review of test in week 6
|
Choosing a project
-Ideas for database projects
-Find/interview end-user
-Project proposal
|
|
|
|
|
|
8
|
The Legal Framework
-Data Protection Act
-Computer Misuse Act
-Copyright issues
|
Forms
-Setting form properties
-Controls - command buttons, combo boxes etc.
-Bound vs. unbound controls
-Wizards, macros and VBA
-Form level validation
|
|
|
|
|
|
9
|
Computer Crime
-Weak points in IT systems
-Hackers and hacking
-Protecting IT systems
-Malpractice vs. crime
|
Reports
-Anatomy of a report
-Sorting and grouping
-Functions
|
| |
|
|
|
10
|
Health and Safety
-Health and safety guidelines.
-Software and hardware ergonomics.
|
Start ICT3 practical
-List objectives and performance criteria
-Determine:
-Input (forms)
-Output (reports)
-Stored data (tables)
-Processing (queries, macros, VBA)
|
| |
|
|
|
11
|
Revision
-Review of ICT1 content
-Revision plan
-Past paper questions/answers
Mock exam
|
Coursework - Tables
-Set up tables/relationships
-Create validation rules/input masks
-Add test data
-Test referential integrity
-Test cascading updates/deletes
|
| |
|
|
|
Mott & Rendell
chapters 3-5 |
|
|
McW RDBMS Design
pages 44-53 |
| |
|
|
|
12
|
Revision
-Review of mock exam
-Identify weaknesses
-Past paper questions/answers
|
Coursework - Queries
-Create select queries
-Test queries
|
| |
|
|
|
Mott & Rendell
chapters 6-8 |
|
|
McW RDBMS Design
pages 93-99 |
| |
|
|
| |
|
ICT3 Coursework
continues in term 2 >>>
|
|
Xmas holidays - revising for ICT1 exam is probably a pretty good
idea if there's nothing on the telly??
|
| |
All page references above are to McWeeney - A-Level Notes for AQA Version 3.0; Mott & Leeming
- ICT for AS Level 2nd Edition; McWeeney - Relational Database Design &
Implementation (Access 2003 version); Mott & Rendell -
Database Projects in Access 1st Edition.
If you're using inferior textbooks by <deleted on advice
of lawyers> just cross out the page numbers above and
add your own with a big crayon.
|
 |
|
