I have over 20 years experience as a lecturer/teacher and also assessor and internal verifier. I currently moderate and test assessments for an awarding body and am a member of SET (Society for Education and Training). I write English, Maths, Food Hygiene and Safety, Food Technology, Online Safety and ICT resources and also computing resources for key stages 2, 3 and 4, GCSE and adults (ECDL etc). I also write and teach botany and ecology courses.
I have over 20 years experience as a lecturer/teacher and also assessor and internal verifier. I currently moderate and test assessments for an awarding body and am a member of SET (Society for Education and Training). I write English, Maths, Food Hygiene and Safety, Food Technology, Online Safety and ICT resources and also computing resources for key stages 2, 3 and 4, GCSE and adults (ECDL etc). I also write and teach botany and ecology courses.
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 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.
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)
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 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 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.
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 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 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
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
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 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.
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
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.
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.