Access Databases 2013 Quick Steps Training Guide

Access Databases 2013 Quick Steps Training Guide

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.
Qualiteach_Education
Functional Skills ICT Level 1 Build-Up Exercises Office 2010

Functional Skills ICT Level 1 Build-Up Exercises Office 2010

These exercises bridge the gap between initial learning and assessment. There are two exercises covering 32 pages - the first exercise guides the learner through the tasks and provides handy tips, using Office 2010, on how to do each of the tasks and the second exercise allows the learner to attempt the tasks without tips or help. There are data files and worked answers for each exercise. The exercises comprehensively cover the Functional Skills ICT specifications at Level 1 and include the following Files & folders Using the Internet Using email Creating a logo Create a leaflet Create a newsletter Create a letter Create a presentation Spreadsheets Databases Combing information Evaluation questions
Qualiteach_Education
Functional Skills ICT Level 1 & 2:  Database Activities & Revision

Functional Skills ICT Level 1 & 2: Database Activities & Revision

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
Qualiteach_Education
Functional Skills ICT Entry Level:  Specimen Practice Papers (for OCR)

Functional Skills ICT Entry Level: Specimen Practice Papers (for OCR)

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
Qualiteach_Education
Functional Skills ICT Level 2:  Specimen Practice Papers (for Edexcel)

Functional Skills ICT Level 2: Specimen Practice Papers (for Edexcel)

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
Qualiteach_Education
Functional Skills ICT Entry Level:  Specimen Practice Papers (for Edexcel)

Functional Skills ICT Entry Level: Specimen Practice Papers (for Edexcel)

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
Qualiteach_Education
Functional Skills ICT Spreadsheets and Graphs

Functional Skills ICT 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
Qualiteach_Education
Key Stage 3/Functional Skills ICT Spreadsheets

Key Stage 3/Functional Skills ICT Spreadsheets

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
Qualiteach_Education
Functional Skills ICT Level 2:  Practice Papers (AQA)

Functional Skills ICT Level 2: Practice Papers (AQA)

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
Qualiteach_Education
Functional Skills ICT Level 1:  Specimen Practice Papers (for Edexcel)

Functional Skills ICT Level 1: Specimen Practice Papers (for Edexcel)

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
Qualiteach_Education
Functional Skills ICT Level 1:  Specimen Practice Papers (for OCR)

Functional Skills ICT Level 1: Specimen Practice Papers (for OCR)

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
Qualiteach_Education
Functional Skills Level 2 ICT:  PowerPoint Presentations 2010

Functional Skills Level 2 ICT: PowerPoint Presentations 2010

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.
Qualiteach_Education
Functional Skils ICT Level 2:  Specimen Practice Papers (for OCR)

Functional Skils ICT Level 2: Specimen Practice Papers (for OCR)

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
Qualiteach_Education
Functional Skills ICT Entry Level Specimen Practice Papers (for AQA)

Functional Skills ICT Entry Level Specimen Practice Papers (for AQA)

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
Qualiteach_Education
Functional Skills ICT Level 1:  Specimen Practice Papers (for AQA)

Functional Skills ICT Level 1: Specimen Practice Papers (for AQA)

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
Qualiteach_Education
Functional Skills ICT Entry Level Build-up exercises Office 2010

Functional Skills ICT Entry Level Build-up exercises Office 2010

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
Qualiteach_Education
Excel Spreadsheets 2013 Quick Steps Training Guide

Excel Spreadsheets 2013 Quick Steps Training Guide

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)
Qualiteach_Education
Computational Thinking

Computational Thinking

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.
Qualiteach_Education
Functional Skills Level 2 Build Up Exercises Office 2010

Functional Skills Level 2 Build Up Exercises Office 2010

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
Qualiteach_Education
The Internet and Search Techniques

The Internet and Search Techniques

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.
Qualiteach_Education
Manage File Storage

Manage File Storage

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.
Qualiteach_Education