AS Term 1 Scheme of Work |
|
|
From FatMax and Steve
Longley |
|
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 ICT3 option is based on Excel projects - for alternative schemes of work using
websites or databases 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 | Excel 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 |
Anatomy of a workbook Define key components. Formatting cells. Absolute and relative cell references. Naming ranges. ICT3 Heathcote |
ICT 3 M & R |
|
3 |
Control of
Information Concept of personal info (who holds what info?) Rights of the individual. Access levels. |
Formulae & functions Simple formulae and functions. Conditional formatting. Replication. Linked worksheets. Charting. ICT 3 Heathcote |
ICT3 M & R 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? |
More advanced functions. VLOOKUP - Psionica Tutorial HLOOKUP IF ICT3 Heathcote |
ICT3 M & R 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. |
Macros Recording macros Visual Basic editor Psionica Tutorials ICT in a Nutshell notes ICT3 Heathcote |
ICT3 M & R 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. |
Advanced features Pivot tables - Psionica Tutorial Protecting cells - Psionica Tutorial Custom views. Validation. ICT 3 Heathcote |
Psionica notes ICT1 ICT1 Heathcote Ch.2 ICT1 Heatccote Ch.3 ICT3 M & R |
|
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 Project Guide ICT3 ICT1 Heathcote Ch.4 ICT1 Heathcote Ch.5 |
|
Half Term - Project research: Read 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. |
Psionica notes ICT1 ICT1 Heathcote Chs.10-12 FatMax1 tutorials ICT3 KJS Excel resources |
|
9 |
Computer Crime Weak points in IT systems. Hackers and hacking. Protecting IT systems. Malpractice vs. crime. |
Prototype Structure Create and format worksheets. Add 'simple' formulae/functions. Enter data. |
Psionica notes ICT1 ICT1 Heathcote Chs.11-12 FatMax1 tutorials ICT3 KJS Excel resources |
|
10 |
Health and Safety Health and safety guidelines. Software and hardware ergonomics. |
Final
Structure Add any 'advanced' functions - VLOOKUP etc. Test all formulae/functions. Filter/sort data. Create and format charts. |
Psionica notes ICT1 ICT1 Heathcote Ch.13 FatMax1 tutorials ICT3 KJS Excel resources |
|
11 |
Role of Communication Systems The Internet - introduction. Merits of various communication facilities. |
Advanced features I Create pivot tables. Add conditional formatting. |
Psionica notes
ICT1 ICT1 Heathcote Ch.6 FatMax1 tutorials ICT3 KJS Excel resources |
|
12 | Review of ICT1 |
User Interface Create custom views. Add 'navigation' controls to workbook. Protect cells/worksheets. |
ICT3 M & R Chs.12 and 13 Psionica notes ICT1 KJS Revision Guide FatMax1 tutorials ICT3 KJS Excel resources |
|
13 | Revision Annotated specification for ICT1 from AGS |
'Advanced' features II Create/edit macros. Add validation rules to cells. Test macros and validation. |
Mock exam ICT1 Greenwood past papers Psionica past papers FatMax1 tutorials ICT3 KJS Excel resources |
|
14 | Revision Review of mock exam. Identify weaknesses. |
Finish ICT3 practical Submit spreadsheet 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.