ECDL at Newhaven School
Year 9 Computing (ECDL IT)
| Term | Unit | Assessment Pieces | Speaking & Listening | Literacy/Numeracy foci | Outcomes for students | Achievement and Enjoyment (Growth) | Opportunities for differentiation | Opportunities to apply and enrich learning |
|---|---|---|---|---|---|---|---|---|
| Autumn 1 | Presentations (PowerPoint) | 5 L1 Practise Tests, 5 L2 Practise Tests | Speaking and listening (Pair work for skills audit) | Literacy (Using key words when describing work) Numeracy (Charts and figures in presentation) | Working with Presentations Enhancing Productivity Presentation Views Master Slide Handling Text Formatting Lists Tables Using Charts | Complimenting (peer assessment of PowerPoints) Asking for help (from teacher or peers) Waiting (for help if class busy) | Work will be assessed at either Level 1 or Level 2 proficiency and the final level for entry will be decided after Spring 2. | Students can produce Powerpoints on a range of subjects to fit in with other subjects. |
| Autumn 2 | Word Processing (Word) | 5 L1 Practise Tests, 5 L2 Practise Tests | Group work (Class opinion / discussion on tasks and how to achieve the objectives) | Literacy (Using key words in Word Processing Tasks) Numeracy (Further use of charts and figures in documents) | Working with Documents Enhancing Productivity Document Creation Formatting Paragraphs Prepare Outputs | Working in a group (group task set) Responding (to changes/improvements suggested by teacher) | Work will be assessed at either Level 1 or Level 2 proficiency and the final level for entry will be decided after Spring 2. | Students could word-process and assignments for English / Business / Arts Award. |
| Spring 1 | Spreadsheets (Excel) | 5 L1 Practise Tests, 5 L2 Practise Tests | To take turns (waiting turn before demonstrating to class an aspect of Excel) | Literacy (Understanding the phraseology of Spreadsheets – formulas, functions, cells, etc) Numeracy (Heavy emphasis on charts and figures in this section) | Working with Spreadsheets Enhancing Productivity Insert, Select Copy, Move, Delete Formulas and Functions Alignment, Border Effects Charts Prepare Outputs | To take turns (waiting turn before demonstrating to class an aspect of Excel) | Work will be assessed at either Level 1 or Level 2 proficiency and the final level for entry will be decided after Spring 2. | Students could create a spreadsheet with statistical data for Science or Maths purposes. |
| Spring 2 | Improving Productivity Using I.T. | 5 L1 Practise Tests, 5 L2 Practise Tests | Speaking and listening (Pupil led presentations on exam techniques / tips) | Literacy (Decoding the assessment brief, picking out the key terms and requests) Numeracy (Creation and manipulation of numerical data) | Real – Life IT Scenarios | Working in a team/pairs (group tasks set) Waiting and responding | Work will be assessed at either Level 1 or Level 2 proficiency and the final level for entry will be decided after Spring 2. | Project scenarios can be tailored to individual or subject need. |
| Summer 1 | Exam Practise | 20 L1 Practise Tests 20 L2 Practise Tests | Speaking and listening (Pupil led presentations on exam techniques / tips) | Literacy (Understanding the key parts of the questions) Numeracy (carrying out the data tasks as required) | ECDL online Diagnostic Exams with full feedback. | To accept the success of others (public displays of mock exam marks) | Students will be entered either for the Level 1 or Level 2 certification. | N/A |
| Summer 2 | Exams | 4 x 45minute online exams | Speaking and listening (Pupil led presentations on exam techniques / tips). | Speaking and listening (Pupil led presentations on exam techniques / tips) | ECDL online certification. | Complimenting (results) | Students working on BTEC Science papers. | N/A |
