---

Key stage 3 - year 7 and 8

 

(Details about key stage 3 ICT can be found in the following documents - Year 7, Year 8, Year 9)

 

Schemes of work

 

Year 7 online  | Year 8 on line | The game assessment topic

---

Year 9

Controlled assessment - practice tasks (2011->)

 

The following are mad available for your to practice the skills required to complete the controlled assessment task for thre GCSE course:

• Task help sheet (PDF)

• Perfomers.xls

• Bookings.xls

• Costs.xls

• Movies showing how to.............

  • Create a database and import data

  • Add a record

  • Create a form

  • Create better forms

  • Delete records

  • Report

  • Create a mail merge template (badge)

  • Complete the mail merge

---

 

GCSE short and full course (CCEA)

 

Main course materials

Year 10 mock exam revision sheet - those NOT taking full course

The GCSE ICT short course exam  (21st June 2010) revision help

(The short course exam is taken by everyone in year 11 including those on the full course)  

   Short course revision summary (simplified checklist of what to learn)

   Short course revision booklet

   Short course revision schedule (if using CGP book)

   Short course revision questions - 1 | 2 | 3 | 4

   Short course past papers

     (2007) - Higher | Marks    

     (2006) - Higher | Marks

     (2005) - Higher | Marks

     (2004) - Higher | Marks

     (2003) - Foundation | Higher | Marks

 

The GCSE ICT full course exam (24th June 2010) revision help

   Full course revision summary (simplified checklist of what to learn - combines full and short course lists)  

   Full course revision booklet (extended content to revise for paper 2)

   Full course revision schedule (if using CGP book)

   Full course past paper 2's - taken as well as short course paper

     (2007) - Foundation | Higher | Marks   

     (2006) - Foundation | Higher | Marks

     (2004) - Higher | Marks

     (2003) - Higher | Marks

 

General revision help

 

   Main exam pages (questions, notes, movies, quizzes)

   Video revision - Eden Project (control, databases)| ICT and business (stock control, using the web, communication)

   MP3 'podcast' - revision for your MP3 player or IPod (will also play on most computers)

 

---

 CEA Applied ICT (year 12 and 13)

   GCE in Applied ICT on line (password required)

• Unit 1 - Main page

• Unit 2 - Main page | Pre-release files (11th Jan 2010)

• Unit 3 - Main page | Plan for unit | Pre-release (Lloyd's Garden Centre 2009-10)

• Unit 7 - Main page | SOW | Case study (Tip Top Toes 14th Jan 2010) | Revision notes

  • CCEA past papers and mark schemes (http://tinyurl.com/unit7papers)

  • Tutorials - http://www.freetutes.com/systemanalysis/#contents

  • Syllabus (page 90->) - http://tinyurl.com/ceaunit7

  • Teach ICT - http://tinyurl.com/teachict-systemsanalysis

  • Context diagrams - http://www.getahead-direct.com/gwba03-context-diagram.htm

  • Data flow diagrams - http://www.getahead-direct.com/gwbadfd.htm

  • ERDs - http://www.getahead-direct.com/gw-er-diagram-tutorial.htm

  • Pert/network diagrams - http://www.getahead-direct.com/gw-pert-charts.htm

  • Gantt charts - http://www.getahead-direct.com/gw-gantt-charts.htm

• Unit 9 - web design | checklist

• Unit 10- multimedia

---

The following software is freely available for download and may be used to help you with your ICT work:

• Freemind - mind mapping software

• Ganttproject - for creating Gantt charts

• Gliffy - free on line flow chart maker

• Openoffice - free word [processor, database, presentation packages

• Photofiltre - graphics editing and creation software

• Nvu – web site creator

  NVU resources (download this free package here)

  • www.designyourownweb.com - video tutorials (tables, links, images)

  • www.nvudev.com - build a web site from scratch

  • nvu.wikispaces.com user manual

  • nvu.kellertechnologies.com - beginners tutorial

• Audacity – sound recording and editing software

• Flash slide show maker