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