51ºÚÁÏ

This resource is suitable for Key Stage 3 Year 7 as part of the Computing curriculum (using software to analyse and solve problems etc) and the Functional Skills L1/L2 ICT specifications for processing numerical data and creating charts and graphs. The resources contain the following: 1. Lesson plan 2. Starter activities/lessons/worksheets - 11 pages containing explanations, practical 'how to do it' help sheets (in Excel 2010), questions (with answers) and practical exercises covering data entry, formatting, using formulas and functions, create a pie chart, create a column chart 3. Build-up exercise for the teacher to work through with the learners. The data for this exercise is generated by the learners (their hobbies) which enables each learner to be involved in the data and provides a sense of 'ownership'. This covers data entry, variables and rules, relative and absolute cell referencing, using SUM, MIN, MAX functions and arithmetical formulas, adding and deleting rows/columns and noting changes in formula cells, formatting cells and creating charts/graphs. There is a worked copy included. There is a worksheet included for Variables and Rules 4. An extension activity with a data file and worked copy based on a helicopter tour business which covers using arithmetical formulas and functions to calculate revenue, discounts and expenditure , editing and formatting and creating graphs

This guide covers 20 A4 pages (single-sided) printed in colour using a visual style with images and callouts. The guide is designed to cover the most useful and popular operations within the Access 2013 software application that a user might need to know and is presented in 10 steps per operation (e.g. Basic operations, Formatting, Editing etc). The guide is useful for anyone wanting to get their heads around using Access 2013 and as a handy reference guide for ICT programmes of study (e.g. ECDL and other L1/L2 ICT qualifications). The guide covers basic operations (openng, creatng a new database/table, closing, printing etc), editing a database, working with tables, relationships, queries, wildcards, forms and reports.

This activity and revision resource covers Functional Skills ICT Level 1 and Level 2 Databases and contains 26 pages of theory, activities, help sheets and practical exercises. Comprehensively covering the FS specifications at both L1 and 2, the resource covers: Designing and creating database - data types/field names Field properties Primary keys Importing text Validation rules Queries and filters Comparison and logical operators Sorting Reports

This 7 page activity resource is suitable for Functional Skills ICT: Presentations and contains theory sheets providing explanations and examples, questions (with answers) to test knowledge and understanding, handy 'how to do it' worksheets and practical hands on exercises covering slides, master slides, editing, inserting images, movies and sound, transitions and animations and timings.

This 13 page worksheet/lesson/activity is an extract from Functional Skills ICT Level 2 Activity Workbook (by the same author) which covers the Internet, the WWW, Search Engines and URLs, Boolean Oerators and other search techniques, currency, relvance, bias, copyright. The worksheets/activity can be used for a whole lesso and consists of theory, activities to test knowledge (matchmaker and multi-choice) and also 6 practical exercises to test skill. Answers are included.

A step-by-step guide to Entry Level Functional Skils ICT in Office 2010 and Windows 7 with handy training notes, help sheets and revision tips, and activities. This guide has 63 single side A4 pages and comprehensively covers the Functional Skills ICT specifications for Entry 1, 2 and 3.

This guide covers 28 A4 pages (single-sided) printed in colour using a visual style with images and callouts. The guide is designed to cover the most useful and popular operations within the Word 2013 software application that a user might need to know and is presented in 10 steps per operation (e.g. Basic operations, Formatting, Editing etc). The guide is useful for anyone wanting to get their heads around using Word 2013 and as a handy reference guide for ICT programmes of study (e.g. ECDL and other L1/L2 ICT qualifications).

This guide covers 16 A4 pages (single-sided) printed in colour using a visual style with images and callouts. The guide is designed to cover the most useful and popular operations within the Outlook 2013 software application that a user might need to know and is presented in 10 steps per operation (e.g. Basic operations, Formatting, Editing etc). The guide is useful for anyone wanting to get their heads around using Outlook 2013 and as a handy reference guide for ICT programmes of study (e.g. ECDL, Functional Skills and other L1/L2 ICT qualifications). The guide covers basic operations, (opening, creating a new message, forward, reply, cc and bcc, sending, closing etc), editing folders and emails, work with email messages (attachments, priority, flag, signatures,), work withcontacts, appointments and meetings and calendars.

This guide covers 20 A4 pages (single-sided) printed in colour using a visual style with images and callouts. The guide is designed to cover the most useful and popular operations within the PowerPoint2013 software application that a user might need to know and is presented in 10 steps per operation (e.g. Basic operations, Formatting, Editing etc). The guide is useful for anyone wanting to get their heads around using PowerPoint 2013 and as a handy reference guide for ICT programmes of study (e.g. ECDL, Functional Skills and other L1/L2 ICT qualifications). The guide covers the basics (opening, closing, create a new presentation, saving printing etc), editing a presentation and using a master slide, formatting slides, slide setup, inserting images, tables and charts.

This guide covers 28 A4 pages (single-sided) printed in colour using a visual style with images and callouts. The guide is designed to cover the most useful and popular operations within the Excel spreadsheets 2013 software application that a user might need to know and is presented in 10 steps per operation (e.g. Basic operations, Formatting, Editing, formulaes etc). The guide is useful for anyone wanting to get their heads around using Excel 2013 and as a handy reference guide for ICT programmes of study (e.g. ECDL and other L1/L2 ICT qualifications). The guide covers: BASIC OPERATIONS (opening, closing, saving, printing etc) EDITING (insert and edit data, undo/redo, search/replace, selecting, switching between worksheets) FORMATTING (fonts, sizes, colours, alignment, borders/shading, number/date formats, AutoFill, sorting, cell orientation and wrapping) MANAGE WORKSHEETS (working with rows and columns, managing worksheets) USING FORMULAS AND FUNCTIONS (BODMAS, arithmetic operators, cell references, ranges and functions) PAGE LAYOUT (margins, orientation,, headers/footers, paper size, row/column headers, gridelines, title rows, preview etc) CREATING CHARTS (pie, line, column, editing and formatting etc)

This 23 page resource of three practice papers is written to match the style of the AQA Level 1 assessment and covers: Creating a leaflet/advert/letter Creating a logo Using spreadsheets and charts Using presentations Editing databases Email Safety and security Evaluation questions There are data files and worked copies/solution for each paper

These practice papers (43 pages) are written to follow the style of the AQA Functional Skills ICT Entry Level assessment and are split into Entry 1, Entry 2 and Entry 3 papers (so they get progressively harder). There are 2 papers per entry stage (6 overall). There is an assessor checklist and also an independent paper so you can decide which to use with the candidate subject their competence and skill level. The papers cover the following: ENTRY 1 Reply to an email Make changes to a document (e.g. advert/poster) ENTRY 2 Email reply Format a document and insert an image ENTRY 3 Email reply and new email Create a poster and a flyer work with presentations Internet search and downloading There are data files and solutions/worked answers for each of the papers

These practice papers (29 pages) are written to follow the style of the Edexcel Functional Skills ICT Level 2 assessment and cover the following: Use the internet and download information Use a spreadsheet and charts Create a newsletter Create a leaflet Create a presentation Use email Use compression Evaluation questions There are data files and worked answers for each of the papers

This 11 page resource is an extract from a Functional Skills ICT Level 2 Training Guide and is based on the Using ICT, Plannng Solutions to Complex Tasks By Analysing the Necessary Stages part of the Functional Skills ICT specifications. The resource consists of the theory behind planning complex tasks and the types of planning techniques available, such as schedules, timetables, Gannt charts, heirarchical charts, storyboards, spreadsheets, websites and mind maps. The theory section is followed by activities and multi-choice revision questions. Answers are included. This resource would be useful for a range of programmes which require the learner to understnd planning techniques.

These worksheets/activities are an extract from a Functional Skills ICT Level 2 Activity Workbook (by the same author) and cover file storage, file extensions, file compression, recycle bin, file and folder sizes, file properties, types of storage media, The resource can be used for a whole lesson and contains theory, activities to test knowledge (mix and match/multi-choice) and also 'how to' help sheets for saving, compressing, renaming, deleting and restoring files, plus creating folders, view properties, copy and move files. There are also 4 Practical Exercises for learners to attempt to test their skills. Answers are included.

This 18 page resource is an extract from a Functioal Skills ICT Level 2 Activity Workbook (by the same author) and covers software applications, using nterface features and adjusting system settings. The activity resource contains theory for each of the subjects, followed by multi-chioce and matchmaker activities to test knowedge. Also included are 'how to' help sheets for opening an aplication, installing and uninstalling software and managing unresponding applications. This worksheet/activity includes answers.

This 30 page worksheet/activity is an extract fom a Functional Skills ICT Level 1 and Level 2 Activity Wrkbook (by te same author) which can be used fo a whole lesson or broken into 3 sessions. The activity comprises clear explanations and examples of formatting, editing and layout and 'how to' Help Sheets with training instructions on how to apply techniques using Office 2010. The resource also contains activities to test knowledge (match makers and multichoice) and 7 practical exercises to test the learner's skill in applying editing, formatting and layout techniques. The resource covers editing and formatting and document layout such as tables, templates, columns.

This 17 page worksheet/activity is an extract from the Functional Skills ICT Level 1 and Level 2 Activity Workbook (by the same author) and is suitable for use as a class activity to cover a whole lesson or broken into two sessions (e.g. Images and Drawing Shapes). The worksheet/activity contains clear explanations of image resolution, resizing, cropping, creating and formatting shapes, ordering, grouping, positioning, wrapping etc and also provides 'how to' Help Sheets in Office 2010. There are activities to test knowledge in the form of matchmaker and multiichoice questions and practical exercises to test skill. Answers to multi-choice questions are included.

This is a handy reference guide for students following a Level 2 Functional Skills ICT course. It covers 42 A4 pages and consists of 'how to' help sheets ro cover the Functional Skills ICT specification at level 2. The guide covers planning and timetabling, software, interface features, responding to IT probems, managing system settings, viruses, manageinformation storage, the Internet, select infomation, editing, fomatting and layout techniques, graphics, drawing tools, presentations, numerical data, graphs and charts, databases, search and sort data, email, stay safe and respect others, online security, combine and pesent, checking and evaluation techniques.

This is a handy reference guide for students following a Level 1 Functional Skills ICT course. It covers 28 A4 pages and consists of 'how to' help sheets ro cover the Functional Skills ICT specification at level 1. The guide covers planning and timetabling, managing system settings, data storage, computer security, finding and selecting information, editing, fomatting and layout techniques, graphics, drawing tools, presentations, numerical data, graphs and charts, databases, email, stay safe and respect others, output, checking and evaluation techniques.