GCSE ICT Scheme of Work

Year 10

Autumn Term
Week Theory Practical Homework
1 Hardware Tools: CD Rider, Audacity. DVD Topic 1
2 Hardware. DVD Word processing. DVD Topics 2, 3, 4, 5
3 Hardware. DVD Word processing. Word processing tasks 1-4
4 Software. DVD Bitmap Graphics - Photoshop. DVD Topics 1-4
5 Software DTP: MS Publisher. DVD Topics 5-6
6 Software DTP: MS Publisher.  
7 Software DTP: MS Publisher.  
8-9 Gathering data    
10-13 Data validation Web Design, Flash  

 

Week 1: 5th September
References
Hardware video, worksheet 1
Doyle chapter 1.
Lessons:

1  
2  
3 Hardware video.
4 Homework: Hardware part 1

Week 2: 11th September
References
Hardware video, worksheets 2-5
Doyle chapter 1.
Lessons:

1 Review Hardware part 1. Homework: Hardware parts 2,3. Word processing: Headers.
2 Review Hardware part 1. Word processing: Styles, Outlines, Objects.
3 Word processing: Tables, Templates. Project 1. Homework: Hardware parts 4,5.
4 Review Hardware parts 4,5. Peripherals. Word processing Project 1.

Week 3: 18th September
References
Word processing projects
Doyle chapter 1.
Lessons:

1 Word processing Project 2. Homework: complete to end of Input peripherals
2 Word processing Project 2.
3 Word processing Project 2. Homework: complete document with critical review.
4 Word processing Project 3.

Week 4: 25th September
References

Lessons:

1 Word processing Project 3. Homework: complete templates exercise (3).
2 Bitmap Graphics - Photoshop.
3 Bitmap Graphics - Photoshop. Homework: complete page 27.
4 Bitmap Graphics - Photoshop.

Week 5: 2nd October
References

Lessons:

1 Bitmap Graphics - Photoshop.
2 Bitmap Graphics - Photoshop.
3 DTP: MS Publisher. Project 2: booklet on PC components
4 DTP: MS Publisher. Project 2: booklet on PC components

Week 6: 9th October
References

Lessons:

1 DTP: MS Publisher. Project 1: flyer on storage devices
2 DTP: MS Publisher. Project 1: flyer on storage devices
3 DTP: MS Publisher. Project 1: flyer on storage devices
4 DTP: MS Publisher. Project 3: booklet on PC components

Week 7: 16th October
References
Doyle chapter 2
Lessons:

1 EFTPOS document.
2 EFTPOS document. Homework: Software Questions Part 1.
3 Review homework. EFTPOS document
4 Open Morning Booklets. Homework: Software Questions Part 2.

Week 10: 6th November
References
Software video, worksheets 2-5
Lessons:

1 Software DVD. OS, application, licence. Application examples. Homework: software question sets 1-3
2 Review software homework. OS: Control panel, memory, peripherals, drivers, open source, folders, task manager. Software development, failure, upgrades.
3 HTML & web pages. Homework: software question sets 4-6
4 HTML & web pages.

Week 11: 13th November
References
Doyle chapter 3
Lessons:

1 HTML & web pages.  Homework: Data Gathering Questions Part 1.
2 HTML & web pages.
3 HTML & web pages.
4 Homework: Data Gathering Questions Part 2.

Week 12: 20th November
References
Doyle chapter 3
Lessons:

1 HTML & web pages. Homework: Data Gathering Questions Part 3.
2 HTML & web pages.
3 HTML & web pages.
4 HTML & web pages.

Week 13: 27th November
References
Doyle chapter 3
Lessons:

1 CSS: Anchors. Dreamweaver: Image Maps.
2 Fireworks
3  
4 Fireworks/Dreamweaver

Week 14: 4th December
References
Doyle chapter 4
Lessons:

1 Flash.
2 Practical web design project
3 Practical web design project
4 Course work preparation.

Week 15: 11th December
References
Doyle chapter 4
Lessons:

1 Course work preparation.
2 Course work preparation.
3 Course work preparation.
4 Course work preparation.
Easter Term

Week 1: 10th January
References
 Doyle chapter 3
Lessons:

1 Course Work. Homework: Data Gathering Questions Part 4.
2 Course Work
3 Course Work
4 Course Work

Week 2: 15th January
References
 Doyle chapter 3
Lessons:

1 Course Work. Homework: Data Gathering Questions Part 5.
2 Course Work
3 Course Work
4 Course Work

Week 3: 22nd January
References
 Doyle chapter 4
Lessons:

1 Course Work. Homework: Data Validation Questions Part 1.
2 Course Work
3 Course Work
4 Course Work

Week 4: 29th January
References
 Doyle chapter 4 (Data Validation)
Lessons:

1 Course Work. Homework: Data Validation Questions Part 2.
2 Course Work
3 Course Work
4 Course Work

Week 5: 5th February
References
 Doyle chapter 4 (Data Validation)
Lessons:

1 Spreadsheets: charts - XY, line/column. Homework: Data Validation Questions Part 3.
2 Spreadsheets: formatting - planets; formulas - Fibonacci, Wages
3 Spreadsheets: functions - SUM, AVERAGE, MEDIAN, MODE, TRUNC, ROUND, INT, MOD, POWER, COMBIN
4 Spreadsheets: Examples: seating plans, Sudoku

Week 6: 12th February
References
 Doyle chapter 12 (Spreadsheets)
Lessons:

1 Spreadsheets: interface
2 Spreadsheets: IF - examinations,
3 Spreadsheets: COUNTIF, SUMIF - seating plans
4 Spreadsheets: LOOKUP - cafe

Week 7: 19th February
Half Term

Week 8: 26th February
References
 Doyle chapter 5 (Doing Things With Data)
Lessons:

1 Spreadsheets: Databases - questionnaires
2 Spreadsheets: Pivot tables - questionnaire
3 Spreadsheets: Pivot tables - climate
4 Spreadsheets: Goal seek - tax

Week 9: 5th March
References
 Doyle chapter 5 (Doing Things With Data)
Lessons:

1 Spreadsheets: Examples - Hotel
2 Spreadsheets: Examples - Payroll
3 Spreadsheets: Examples - Cafe
4 Field Day

Week 10: 12th March
References
Doyle chapter 11 (Modelling)
Lessons:

1 Modelling: Magic Squares
2 Modelling: Monkeys, Multiplication
3 Modelling: RAND, simulations, lemonade, electricity
4 Modelling: RAND, simulations, dice games

Week 11: 19th March
References
 Doyle chapter 11 (Modelling)
Lessons:

1 Database management
2 Database management
3 Database management
4 Database management

Week 12: 26th March
References
 Doyle chapter 6 (Security)
Lessons:

1 Database management
2 Database management
3 Database management
4 Database management
Summer Term
Weeks Theory Practical
1-2 Trial exams  
3-6 u Databases, Mail Merge, Catalogue Merge
7-10   Second project (spreadsheet or database)
11-12   Control, measurement

Year 11

Autumn Term
Weeks Theory Practical
1- Systems  
2-3 Systems  
4-7    
8-10    
11-13    

Weeks 8-13: Project 2

Spring Term
Weeks Theory Practical
1-2   Exam
3-5   Project
6-7   Project
8-10   Project
Summer Term
Weeks Theory Practical
1    
2-3    
4-5    

Weeks 1-5: Theory & Revision

Specification Topics

Year 1
Software Tools  
Word processing Spreadsheets & Charts, Modelling, Simulation
Database management Desk top publishing
Drawing Graphics
Web Pages, CSS Flash
Techniques & Systems  
General structure of information systems Difference between information and data
Hardware components Input peripherals
Output peripherals Storage devices and media
Data transfer Applications software
Function of applications software Types of applications software
Evaluation of hardware and software Development of applications software
Gathering data Methods of data capture
Data logging Data validation
Storing data Data structures
Data security Processing data
Searching and matching Sorting
Merging Control
Presenting information Modelling and Simulation
Information Systems in Society  
Communications Data Protection Act
Data misuse Growth of information and effects
Health and safety  
Full Course/Year 2
Software Tools  
Mail Merge Web design
Flash Graphics Delphi programming
Techniques & Systems  
System flowcharts Operating environment
Role of operating systems Types of operating system
User interface Networks and communications
E-mail Evaluation of hardware & software components
File size and data storage Data processing
System life cycle  
Information Systems in Society  
Copyright and computer misuse  

Publicity Summary

GCSE Home Page