Skip to content ↓

KS4 E.C.D.L. Core ICT

Curriculum information for 'Core ICT E.C.D.L.'

Year 9
                         Topic           Skills
Autumn 1


 
Application Software.
Desktop Publishing basics.
Desktop Publishing advanced skills.
Linking application software together.
  • Being able to use basic Desktop Publishing software - insert pages, headers/footers, text, images.
  • Being able to use more advanced features - linking text boxes, changing margins and page sizes, etc.
Autumn 2



 
PowerPoint.
PowerPoint basics.
PowerPoint advanced skills.
Practice test.
 
  • PowerPoint basics - adding text, adding a template, animation and transitions.
  • PowerPoint advanced - slide master, slide numbers, changing an image size, inserting charts/graphs.
  • Completing a practice E.C.D.L. test.
Spring 1



 
Excel.
Excel basics.
Excel advanced skills.
Practice test.
 
  • Excel basics - basic formula and functions, creating a chart/graph, header/footer.
  • Excel advanced - advanced functions (countif, absolute cell reference, macros, etc.).
  • Completing a practice E.C.D.L. test.
Spring 2


 
Word.
Word basics.
Word advanced skills.
Practice test.
  • Word basics - font, paragraph alignment, margins, page size.
  • Word advanced - mail merge, hyphenation, etc.
  • Complete a practice E.C.D.L. test.
Summer

 
Summer Term Project.
Improving productivity.
 
  • Mail merging a spreadsheet with a word document, export the results into PowerPoint.
  • Completing a practice E.C.D.L. test.
Year 10
                         Topic           Skills
Autumn 1


 
Application Software.
Desktop Publishing basics.
Desktop Publishing advanced skills.
Linking application software together.
  • Being able to use basic Desktop Publishing software - insert pages, headers/footers, text, images.
  • Being able to use more advanced features - linking text boxes, changing margins and page sizes, etc.
Autumn 2



 
PowerPoint.
PowerPoint basics.
PowerPoint advanced skills.
Practice test.
 
  • PowerPoint basics - adding text, adding a template, animation and transitions.
  • PowerPoint advanced - slide master, slide numbers, changing an image size, inserting charts/graphs.
  • Completing a practice E.C.D.L. test.
Spring 1



 
Excel.
Excel basics.
Excel advanced skills.
Practice test.
 
  • Excel basics - basic formula and functions, creating a chart/graph, header/footer.
  • Excel advanced - advanced functions (countif, absolute cell reference, macros, etc.).
  • Completing a practice E.C.D.L. test.
Spring 2


 
Word.
Word basics.
Word advanced skills.
Practice test.
  • Word basics - font, paragraph alignment, margins, page size.
  • Word advanced - mail merge, hyphenation, etc.
  • Complete a practice E.C.D.L. test.
Summer

 
Summer Term Project.
Improving productivity.
 
  • Mail merging a spreadsheet with a word document, export the results into PowerPoint.
  • Completing a practice E.C.D.L. test.