From FatMax and Smokin'
Dog
| AS Term 1 Scheme of Work |
|
|
|
From FatMax and Smokin'
Dog |
|
 |
AS Module 1 - Information: Nature, Role and Context |
 |
AS Module 3 - Minor Project: Generic Software Solution |
Autumn Term: Suggested outline for AS term 1 based on 6 x 50 minutes per week.
Click on the orange headings for links to resources, reading and practice questions.
The
FatMax2 ICT3 option
is based on database projects - for alternative schemes of work using
spreadsheets or web design for ICT3 click
here.
Download these first! Checklists for the AQA
specification from Kesgrave High.
 |
AS Module 1 specification (115 Kb) |
|
AS Module 3 specification (71 Kb) |
Note for teachers:
You're welcome to download and edit the FatMax2 scheme of work to suit
your own course but please leave references to Psionica, the KJS etc. intact. You are also welcome to host it on a school
network or give students copies on CD .
Steve Longley's
Psionica notes (highly recommended) are available to supplement ICT1
content each week. The books referred to in this scheme are:
| Heathcote (ICT1) | Mott and Rendell (ICT3) | Heathcote (ICT3) |
|
|
|
|
|
Core text ICT1 |
Core text ICT3. Referred to below as ICT3 M & R |
Extra reading for ICT3 |
At least two copies of each coursework book should be available in the Library Resource Centre. You can buy personal
copies using the links above (or ask your teacher, (s)he can probably get them
cheaper directly from the publishers!!)
| AS Term 1 - Scheme of Work | Access Option |
| Wk. |
|
ICT3 |
Notes/Reading |
|
| 1 |
Introduction to ICT 1 |
Introduction to ICT 3 Coursework requirements. Create coursework web page using sources from Links |
Specification ICT1 |
|
| 2 |
Knowledge, Information & Data |
Database crash
course Table design. Introduction to validation. Why data type & field size matter. ICT3 Heathcote Chs.1 - 2 |
ICT 3 M & R Chs.3 - 4 |
|
| 3 |
Control of
Information Concept of personal info (who holds what info?) Rights of the individual. Access levels. |
Normalisation What is normalisation? Worked examples. How to resolve many-to-many relationships. ICT 3 Heathcote Ch.2 |
ICT3 M & R
Ch.5 Psionica notes ICT1 ICT1 Heathcote Ch.9 |
|
| 4 |
Value and Importance of Information Information as a commodity. Why is information valuable? What makes information valuable? |
Introduction to queries Single table queries. Operators. Multiple table queries. Calculated fields. ICT 3 Heathcote Ch.4 |
ICT3 M & R
Chs.6 - 7 Psionica notes ICT1 ICT1 Heathcote Ch.9 |
|
| 5 |
ICT - Capabilities &
Limitations What ICT is good at. Limitations of ICT. ICT & the Professional Qualities of the ICT professional. |
Forms Data entry. Controls - command buttons, combo boxes etc. Form level validation. ICT 3 Heathcote Ch.3 |
ICT3 M & R Chs.9
- 11 Psionica notes ICT1 Psionica notes ICT1 ICT1 Heathcote Ch. 1 - 7 |
|
| 6 |
ICT in Business and Commerce ICT in Manufacturing The social & economic impact of ICT. |
Choosing a project Ideas for database projects More ideas - The KJS. 'Candy floss' - The KJS (& FatMax) ICT3 Heathcote Ch.12 |
Psionica notes ICT1 ICT1 Heathcote Ch.2 ICT1 Heatccote Ch.3 ICT3 M & R pgs.ix-xiii |
|
| 7 |
ICT in a Caring Society ICT in Education The social & economic impact of ICT. |
Design
questionnaire or interview pro forma. Start project log. |
ICT1 test
weeks 1 -6 FatMax Guide ICT3 Appendices (for use with the above). ICT1 Heathcote Ch.4 ICT1 Heathcote Ch.5 |
|
|
Half Term - Project research: Read FatMax project guide and carry out initial research at chosen organisation. |
||||
| 8 |
The Legal Framework Data Protection Act. Computer Misuse Act. Copyright issues. Review of test in week 7. |
Start ICT 3
practical List objectives and performance criteria. List and define properties of entities. |
Psionica notes ICT1 ICT1 Heathcote Chs.10-12 FatMax1 tutorials ICT3 |
|
| 9 |
Computer Crime Weak points in IT systems. Hackers and hacking. Protecting IT systems. Malpractice vs. crime. |
Tables Design table structure. Create prototype table structure. Test referential integrity. Add/test validation rules. |
Psionica notes ICT1 ICT1 Heathcote Chs.11-12 FatMax1 tutorials ICT3 |
|
| 10 |
Health and Safety Health and safety guidelines. Software and hardware ergonomics. |
Queries Create select queries. Create action queries (e.g. archive data). |
Psionica notes ICT1 ICT1 Heathcote Ch.13 FatMax1 tutorials ICT3 |
|
| 11 |
Role of Communication Systems The Internet - introduction. Merits of various communication facilities. |
Input Create input forms. Add controls. Macros/VBA. Refine queries |
Psionica notes
ICT1 ICT1 Heathcote Ch.6 FatMax1 tutorials ICT3 |
|
| 12 | Review of ICT1 | Output Create queries (multiple tables) for output. Design and create output reports and/or mail merge. Macros/VBA. |
ICT3 M & R Chs.12 and 13 Psionica notes ICT1 KJS Revision Guide FatMax1 tutorials ICT3 |
|
| 13 | Revision Annotated specification for ICT1 from AGS |
User interface Switchboard. Security and access levels. Backup options. |
Mock exam ICT1 Greenwood past papers Psionica past papers FatMax1 tutorials ICT3 |
|
| 14 | Revision Review of mock exam. Identify weaknesses. |
Finish ICT3 practical Submit database in zip format. Complete project log. Chill out! |
FatMax2 ICT1 pages FatMax2 Links page |
|
|
Xmas holidays: Revise for ICT1 exam in January!! Practice answering questions using Psionica past paper database. |
||||
| AS Modules | A2 Modules | Links | Top | Home | FatMax1 |
Copyright/Disclaimer - I think everyone whose work appears on this site has been properly attributed and credited. If not, get in touch and I'll make the necessary amendments. If you'd like to write/donate a scheme of work for any of the other modules or suggest improvements to these modules I'm all ears.
