Scheme of Work (word) - Pearson qualifications



This scheme of work comes with 22 lesson plans and accompanying digital resources. They have developed to be used in conjunction with free Functional Skills Study Modules as part of a programme of study for ICT.

The Study Modules aim to help learners acquire the skills that are outlined in the Edexcel specification for Functional Skills ICT, Levels 1 & 2.

The structure of Study Modules and lessons

Topics have been organised in a logical order, which does not always reflect the sequence in which they appear in the specification. The standards covered are given at the start of each Study Module and lesson.

It is expected that teachers will organise their teaching sessions according to the needs, level of experience and interest of their learners, and the contexts in which they are working.

These materials work in conjunction with the Complete Delivery Guide to the Edexcel specification.

|Module No |Module Title |Number of Lessons |

|1 |Making the most of your computer |1 |

|2 |Managing information |2 |

|3 |Finding and selecting information |2 |

|4 |Working with structured data |3 |

|5 |Working with numbers and charts |3 |

|6 |Working with text and images |3 |

|7 |Combining and presenting information |6 |

|8 |Using ICT to communicate |2 |

| |Total: |22 |

Level differentiation

These materials are for learners working at Levels 1 and 2.

The basis of the design of the materials is that, as in the specification, differentiation will be as much by outcome as by activity. The other key level differentiators – complexity, familiarity, technical demand and independence – are reflected in the tasks, which are designed to show the progression that is a feature of the standards:

| |At Level 1, learners would be expected to: |At Level 2, learners would be expected to: | |

| |identify the ICT requirements needed to solve a straightforward task and apply their |analyse multi-step tasks and separate the components, identifying the relevant ICT | |

| |knowledge and understanding to produce an appropriate solution (complexity) |requirements and applying their knowledge and understanding to produce an appropriate | |

| |apply their knowledge and skills within a non-routine but familiar context |solution (complexity) | |

| |(familiarity) |apply their knowledge, skills and understanding within non-routine and non-familiar | |

| |apply a range of techniques in a number of applications to produce an appropriate |contexts (familiarity) | |

| |outcome (technical demand) |demonstrate the application of a wide range of techniques across several applications | |

| |solve problems that are essentially instructor/ tutor guided, demonstrating the |to produce an appropriate outcome (technical demand) • solve problems independently, | |

| |confidence to make informed choices and knowing when to seek guidance (independence) |overcoming challenges to produce successful outcomes (independence) | |

A note on resources and providing a safe working environment for learners

Any suggestion for software to be used with activities is not meant to be exclusive. It is understood that different centres will have different resources.

Teachers can adapt activities so that they can be used with the resources that are available to them.

Assumptions

• Students have some experience of using ICT, in particular word processing, spreadsheets and presentation software.

• Lessons are 60 minutes long

• Students have access to computers outside timetabled lessons

• Students have access to the internet.

|Lesson |Objectives |Activities and Outcomes |Resources |Specification |

| |In this lesson students will learn how to: |At the end of the lesson students will be able to: | |Coverage |

|1 |customise computer settings to increase their own |personalise the desktop |Study Module 1: Making the most of your |Level 1: |Level 2: |

| |efficiency |adjust system settings |computer |2.1 – 2.3 |2.1 – 2.4 |

| | |resolve straightforward problems |SAM and Mark Scheme | | |

| | | |Digital images: | | |

| | | |L1.1-PC-in-the-box | | |

| | | |L1.2-PC-out-of-the-box | | |

| | | |L1.3-PC-effective-settings | | |

| | | |L1.4-Mark-Scheme-Lesson1 | | |

| | | |Key vocabulary | | |

| | | |see Lesson Plan 1 | | |

|2 |manage information storage |create and work with files and folders |Study Module 2: Managing Information |Level 1: |Level 2: |

| | |build appropriate folder structures |SAM and Mark Scheme |3.1 |3.1 |

| | |control access to files |Digital images: |4.1 – 4.2 |5.2 |

| | | |L2.1-Filing-systems | | |

| | | |L2.2-Files-in-folders | | |

| | | |L2.3-File-security | | |

| | | |L2.4-Mark-Scheme-Lesson2 | | |

| | | |L2.5-Storage-uncompressed | | |

| | | |Key vocabulary | | |

| | | |see Lesson Plan 2 | | |

|3 |manage storage areas |select appropriate storage areas |Study Module 2: Managing Information |Level 1: |Level 2: |

| |work safely and securely |check available free storage space |SAM and Mark Scheme |3.1 |3.1 |

| | |compress files into a folder |Memory Stick |4.1, 4.2 |5.2 |

| | |take action against loss of information in files and |Digital images: | | |

| | |folders |L3.1-Storage-outdoor-indoor | | |

| | | |L3.2-Storage-different-kinds | | |

| | | |L3.3-Storage-full | | |

| | | |L3.4-Storage-uncompressed | | |

| | | |L3.5-Storage-compressed | | |

| | | |L3.6- Storage-external-insecure- | | |

| | | |Key vocabulary | | |

| | | |see Lesson Plan 3 | | |

|4 |find and select reliable information appropriate for |identify the information requirements and audience of |Study Module 3: Finding and selecting information |Level 1: |Level 2: |

| |purpose and audience |a task |SAM and Mark scheme |2.1 |2.1 |

| | |construct efficient searches |Digital images: |5.1 |4.1 |

| | |evaluate websites |L4.1-Road-layout |6.1 |5.1 – 5.2 |

| | | |L4.2-Real-road-junction | | |

| | | |L4.3-Rail-crossing-audio | | |

| | | |L4.4-Give-Way-text | | |

| | | |L4.5-Give-Way-sign | | |

| | | |L4.6-Lesson4-Objectives | | |

| | | |L4.7-Fit-for-purpose | | |

| | | |L4.8-Copyright-not-right-to-copy | | |

| | | |Key vocabulary | | |

| | | |see Lesson Plan 4 | | |

|5 |manage and acknowledge information selected for use |save information appropriately |Study Module 3: Finding and selecting |Level 1: |Level 2: |

| |in own work |acknowledge sources and information they use |information |2.1 |2.1 |

| | |evidence how they manage information saved from the |SAM and Mark scheme |5.1 |4.1 |

| | |internet |Digital images: |6.1 |5.1 – 5.2 |

| | | |L4.8-Copyright-not-right-to-copy | | |

| | | |L5.1-Copyright-protected | | |

| | | |L5.2-Task1-Task3 | | |

| | | |Key vocabulary | | |

| | | |see Lesson Plan 5 | | |

|6 |structure and present data in a table |build a data table |Study Module 4: Working with structured data |Level 1: |Level 2: |

| | |enter meaningful field names |SAM and Mark Scheme |2.1 |2.1 |

| | |work with different types of data |Key vocabulary |5.1 |4.1 |

| | |format data |see Lesson Plan |7.1 |6.1 |

| | |sort data in different ways | |8.3 - 8.4 |7.3 - 7.4 |

|7 |search structured data |use Find to locate data |Study Module 4: Working with structured data |Level 1: |Level 2: |

| | |set and customise Filters (AutoFilter) |SAM and Mark Scheme |2.1 |2.1 |

| | |use Filters on single and multiple columns |Key vocabulary |5.1 |4.1 |

| | | |see Lesson Plan 7 |7.1 |6.1 |

| | | | |8.3 - 8.4 |7.3 - 7.4 |

|8 |present information to meet requirements |enter and format numeric data |Study Module 4: Working with structured data |Level 1: |Level 2: |

| |validate data |perform calculations using data in two fields |SAM and Mark Scheme |2.1 |2.1 |

| | |use a drop-down list for data-entry |Key vocabulary |5.1 |4.1 |

| | |produce print-outs to meet requirements |see Lesson Plan 8 |7.1 |6.1 |

| | | | |8.3 - 8.4 |7.3 - 7.4 |

|9 |select and apply appropriate formats |display numbers and text in appropriate formats |Study Module 5: Working with numbers and charts |Level 1: |Level 2: |

| |carry out calculations with relative and absolute |enter formulas using (+, -, *, /) |SAM and Mark Scheme |2.1 |2.1 |

| |references |use functions SUM, AVERAGE, COUNT, MAX and MIN |Digital images: |7.1 |6.1 |

| | |use absolute cell references |L9.1-100-Display |8.1 - 8.2 |7.1 - 7.2 |

| | | |L9.2-100-Display-Format | | |

| | | |L9.3-100-DataEntry-Display-Format | | |

| | | |L9.4-10x10-text-number | | |

| | | |L9.5-10x10-results | | |

| | | |L9.6-10x10-warning | | |

| | | |L9.7-10x10-comment | | |

| | | |Key vocabulary | | |

| | | |see Lesson Plan 9 | | |

|10 |work with conditions |use the IF Function |Study Module 5: Working with numbers and charts |Level 1: |Level 2: |

| | |apply conditional formatting |SAM and Mark Scheme |2.1 |2.1 |

| | | |Key vocabulary |7.1 |6.1 |

| | | |see Lesson Plan 10 |8.1 - 8.2 |7.1 - 7.2 |

|11 |display numerical data in graphical form |select and create appropriate charts and graphs |Study Module 5: Working with numbers and charts |Level 1: |Level 2: |

| | |label graphs / charts to aid understanding |SAM and Mark Scheme |2.1 |2.1 |

| | |produce print-outs to meet requirements |Digital images: |7.1 |6.1 |

| | | |L11.1-Bar-Chart-no-info |8.1 - 8.2 |7.1 - 7.2 |

| | | |Key vocabulary | | |

| | | |see Lesson Plan 11 | | |

|12 |select and format text to meet requirements |select and prepare text for publications |Study Module 6: Working with text and images |Level 1: |Level 2: |

| | |apply appropriate formatting |SAM and Mark Scheme |2.1 |2.1 |

| | |apply bullets and numbering to lists |Digital images: |7.1 |6.1 |

| | |produce print-outs to meet requirements |L4.7-Fit-for-purpose | | |

| | | |L12.1-Bullets-Numbering | | |

| | | |Key vocabulary | | |

| | | |see Lesson Plan 12 | | |

|13 |display information in a table |create a table in a text document |Study Module 6: Working with text and images |Level 1: |Level 2: |

| | |format it to aid understanding |SAM and Mark Scheme |2.1 |2.1 |

| | |produce print-outs to meet requirements |Digital images: |7.1 |6.1 |

| | | |L13.1-Tables-previous | | |

| | | |L13.2-Table-menu | | |

| | | |L13.3-Table-properties | | |

| | | |Text file: | | |

| | | |Lesson 13 Homework text for table | | |

| | | |Key vocabulary | | |

| | | |see Lesson Plan 13 | | |

|14 |format and integrate images to meet requirements |select appropriate formatting tools to edit images |Study Module 6: Working with text and images |Level 1: |Level 2: |

| | |add features to images |SAM and Mark Scheme |2.1 |2.1 |

| | |combine text and images to produce print-outs that |Digital images: |7.1 |6.1 |

| | |meet requirements |L3.5-Storage-compressed | | |

| | | |L14.1-Picture-4-versions | | |

| | | |L14.2-Picture-version4 | | |

| | | |L14.3-Text-images | | |

| | | |L14.4-Which-software | | |

| | | |L14.5-View-Toolbars-Picture | | |

| | | |L14.6-Picture-icons | | |

| | | |L14.7-Image-plus | | |

| | | |Text file: | | |

| | | |San-Francisco-Diary | | |

| | | |Key vocabulary | | |

| | | |see Lesson Plan 14 | | |

|15 |identify features of effective publications |identify purposes, target audiences and features of |Study Module 7: Combining and |Level 1: |Level 2: |

| | |type of publications |presenting information |1.1 |1.1 |

| | |map out page layouts |SAM and Mark Scheme |2.1 |2.1 |

| | |describe text styles |Key vocabulary |10.1 |9.1 |

| | | |see Lesson Plan 15 |10.2 |9.2 |

| | | | |11.1 |10.1 |

|16 |plan a publication |analyse requirements |Study Module 7: Combining and |Level 1: |Level 2: |

| | |match types of publications to requirements |presenting information |1.1 |1.1 |

| | |rank information for specific publications |SAM and Mark Scheme |2.1 |2.1 |

| | |set success criteria for publications |Key vocabulary |10.1 |9.1 |

| | |review effectiveness of layouts |see Lesson Plan |10.2 |9.2 |

| | | | |11.1 |10.1 |

|DoubleLesson |plan and carry out the production of a paper-based |optimise computer settings and interface features for |Study Module 7: Combining and |Level 1: |Level 2: |

|17-18 |publication |the task in-hand |presenting information |1.1 |1.1 |

| |apply a mark scheme |manage the storage of information needed for a |SAM and Mark Scheme |2.1 |2.1 |

| | |publication |Digital images: |10.1 |9.1 |

| | |select and combine appropriate types of information |L18.1-Mark-Scheme-Categories1 |10.2 |9.2 |

| | |select page designs and layouts that are fit for |L18.2-Mark-Scheme-Categories2 |11.1 |10.1 |

| | |purpose and audience |L18.3-Bear1-for-your-text | | |

| | |select and use appropriate language and formatting |L18.4-Bear2-for-your-text | | |

| | |review own work and ways of working |L18.5-Bear3-for-your-text | | |

| | |check for accuracy, meaning and fitness for purpose |L18.6-group-of-bears | | |

| | |minimise risks of losing the publication |L18.7-2bears-standing | | |

| | |use a mark scheme to assess own and somebody else’s |L18.8-2bears-sitting1 | | |

| | |work |L18.9-2bears-sitting2 | | |

| | |draw up a personal improvement plan |L18.10-bear1 | | |

| | | |L18.11-bear2 | | |

| | | |L18.12-bear3 | | |

| | | |L18.13-bear4 | | |

| | | |Text file: | | |

| | | |L18-Mark-Scheme-poster | | |

| | | |Key vocabulary | | |

| | | |see Lesson Plans 17 - 18 | | |

|DoubleLesson |plan and carry out the production of a screen-based |optimise computer settings and interface features for |Study Module 7: Combining and |Level 1: |Level 2: |

|19-20 |publication |the task in-hand |presenting information |1.1 |1.1 |

| |apply a mark scheme |mange the storage of information needed for a |SAM and Mark Scheme |2.1 |2.1 |

| | |publication |Digital images: |10.1 |9.1 |

| | |select and combine appropriate types of information |L19.1-5slides |10.2 |9.2 |

| | |select slide designs and layouts fit for purpose and |Key vocabulary |11.1 |10.1 |

| | |audience |see Lesson Plan | | |

| | |select and use appropriate language and formatting | | | |

| | |apply suitable actions, animations and transitions | | | |

| | |review own work and ways of working | | | |

| | |check for accuracy, meaning and fitness for purpose | | | |

| | |minimise risks of losing the publication | | | |

| | |use a mark scheme to assess own and somebody else’s | | | |

| | |work | | | |

| | |draw up a personal improvement plan | | | |

| | |time permitting: | | | |

| | |give a presentation | | | |

|21 |use email effectively and appropriately |send emails fir for purpose and audience |Study Module 8: Using ICT to communicate |Level 1: |Level 2: |

| | |follow email etiquette to respect others |SAM and Mark Scheme |2.1 |2.1 |

| | |stay safe online |Key vocabulary |9.1 |8.1 |

| | |carry out email housekeeping |see Lesson Plan 21 |9.2 |8.2 |

|22 |use ICT to collaborate |select ICT tools to collaborate with people in |Study Module 8: Using ICT to communicate |Level 1: |Level 2: |

| | |different locations |SAM and Mark Scheme |2.1 |2.1 |

| | |minimise risks to information in online environments |Key vocabulary |9.1 |8.1 |

| | |take appropriate steps to stay safe |see Lesson Plan 22 |9.2 |8.2 |

-----------------------

[pic]

[pic]

[pic]

[pic]

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download