This guide covers 3 A4 pages (single-sided) printed in colour using a visual style with images and callouts. The guide is designed to cover advanced text wrapping techniques in Word 2013 and is presented in 6 steps. The guide is useful for anyone wanting to get their heads around using text wrapping options in Word 2013 and as a handy reference guide for ICT programmes of study (e.g. ECDL Advanced and other L2/L3 ICT qualifications). The guide covers: Quick Text Wrapping Options Using the Ribbon to Wrap Text Positioning Edit Wrapping Points Text Wrapping for Drawn Objects and Charts Text Wrapping and Positioning for Tables

This 2 page resource explains computational thinking, abstraction, decomposing and generalisation. An example is provided of a step-by-step process with unnecessary detail filtered out. Two activities follow the explanation and examples. This resource is suitable for Key Stage 2 or 3 Computer Science.

This 2 page resource is suitable for Key Stage 2/3 Computer Science and comprises a guide and activity for algorithms. This resource provides explanations of algorithms with examples of pseudocode and flowcharts and also provides 2 actvities for learners to test knwledge (answers included).

This 2 page resource provides a brief guide to operators: Comparison, Arithmetical and Boolean Operators along with Conditions (True and False) and the principles of BODMAS (wih examples). There are two test questions (comparison operator type and conditions). This worksheet is suitable for learners studying Computer Science at KS2/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 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)

The training guides are supplied in colour for the user to print on A4 paper and are created using a visual style with images and callouts. The resources can be used as a handy reference guide for ECDL and ICT programmes, including Functional Skills L1/L2. The Office 2013 Quick Step Guides cover - Word Processing, Spreadsheets, PowerPoint Presentations, Access Databases and Outlook email. The guides are designed to cover the most useful and popular operations for each software application that a user might need to know and are presented in 10 steps per operation. The set of guides costs £10. The full guide (WP, SS, DB, PP and Email) contains 56 pages if printed double-sided.

These practice papers (41 pages) are written to follow the style of the OCR 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. The papers cover the following: ENTRY 1 Reply to an email Make changes to a document (e.g. information sheet/poster)/label an image ENTRY 2 Email reply Create, edit and format a document and insert an image ENTRY 3 Email reply Create a poster/flyer and edit and format it Internet search and downloading Evaluation questions (safety and security) There are data files and solutions/worked answers for each of the papers

This 23 page resource of three practice papers is written to match the style of the Edexcel Level 1 assessment and covers: Use the Internet Creating a leaflet/letter and combining information Using spreadsheets and charts Password protection and Read Only Use Email with attachments Using presentations Editing databases 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 (16 pages) are written to follow the style of the OCR Functional Skills ICT Level 2 assessment and cover the following: Use the internet and download information Use a spreadsheet and charts Use a database Create a newsletter Create a letter Use email Evaluation questions There are data files and worked answers for each of the papers

There are 3 specimen practice papers written to match the AQA Functional Skills assessment style papers and these are suitable for Functional Skills ICT at Level 2. There are data files and worked copies (answers). The papers cover the following: Email Creating logos and presentations Creating leaflets Creating letters Creating newsletters Using databases Using spreadsheets and graphs

This 14 page spreadsheet activity resource is suitable for Functional Skills ICT - Numerical Data and Graphs and covers: Theory sheets providing explanations and examples of arithmetical formulas, referencing and BODMAS and also functions such as SUM and also IF and VLookup/HLookup statements, along with creating comparison bar charts. Handy 'how to do it' sheets giving practical help for Excel 2010 - formulas, functions, headers & footers, layout, editing, importing and also creating charts and graphs from two data sets Questions (with answers) to test knowledge and understanding Practical 'hands on' exercises using formulas and functions and creating comparison bar charts, line graphs and scatter graphs

These exercises comprehensively cover the Functional Skills level 2 ICT specifications. This resource helps to bridge the gap between initial learning and final assessment and covers all aspect of the level 2 ICT specifications. The first build-up exercise includes handy tips to guide the learner through the exercises. The second build-up exercise is designed to test the learner's skills and knowledge without any tips/hints. You will also need to download the data files and worked copies. The build-up exercises cover 36 single-sided A4 pages and cover the following: Files and folders Internet Planning Creating a logo Spreadsheets Creating a newsletter Creating a leaflet Creating an invoice (tables) Compare documents Presentations Databases File compression Email and organise messages Evaluation questions

This 16 page resource of three practice papers is written to match the style of the OCR Functional Skills Level 1 assessment and covers: Using the Internet Creating presentations Creating a flyer Creating a letter Using email Evaluation questions (security) Using spreadsheets Password protection Read Only File management There are data files and worked copies/solution for each paper

This resource helps to bridge the gap between initial learning and final assessment and cvers all aspect of the Entry level ICT specifications. The first build-up exercise includes handy tips to guide the learner through the exercises and each question is labelled with the Entry level. The second build-up exercise is designed to test the learner's skills and knowledge without any tips/hints. There are separate tasks designed for each Entry level (stage 1, 2 or 3). You will also need to download the data files and worked copies. The build-up exercises cover 23 single-sided A4 pages and cover the following: Keeping safe and secure Working with files Creating a poster Spreadsheets Combining information Find and select information Label an image Search a list of information Email Contacts Presentations

These practice papers (23 pages) are written to follow the style of the Edexcel 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). The papers cover the following: ENTRY 1 Open an email Make changes to a document (e.g. flyer/poster) Label an image ENTRY 2 Email reply Edit, format a document and insert an image ENTRY 3 Email reply and new email Create a poster and a newsletter work with spreadsheets Internet search and downloading There are data files and solutions/worked answers for each of the papers