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 11 page resource is an extract from Functional Skills ICT Level 2 and covers Online Security, Viruses, Staying Safe and Respecting Others, Responding to ICT Problems. Each subject starts with a page on theory, folllowed by an activity to test knowledge (in the frm of multi-choice questions and mix and match activity.
Answers are included.
This FREE one page worksheet/activity is an extract from a Functional Skills Entry 1 Maths Workbook(by the same author) and covers Hundreds , Tens and Units , adding 3 digit numbers and taking numbers over to the next column. The one page activity provides a clear explanation and example and then an activity for the learner to try. The answers to the activities are at the bottom of the page.
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 5 page guide covers HACCP and its importance in food safety. It teaches learners the difference between hazard and risk and helps them understand physical and chemical hazards. Learners will learn about critical control points and the importance of keeping records. They will also learn about due diligence and the legal requirements of caterers regarding food hygiene and safety. Learners will understand how to put HACCP procedures in place and know what is critical and non-critical. learners are assessed through multi-choice questions (answers are provided).
This guide is useful for programmes of study in food preparation and safety and ideal for anyone working with food (school canteen staff, teachers, apprentices, teaching assistants) or anyone who is interested in working within catering.
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)
This activity is part of the Functional Skills Maths at Entry Stage 1 or can be used for early Years maths. Suitable for the complete beginner and for learners who struggle with numeracy. The resource contains explanations and an activity with examples on how to do it to test the learner's skill and knowledge. The resource has 2 pages and covers Size (smallest/largest). This has a wide age range as it covers early years through to Functional Skills
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 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
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 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 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
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