A 22 page pdf revision booklet for Unit 2 of the Level 3 Cambridge Technicals IT course. This is aimed at sixth form students to aid with revision for the examination, encouraging a variety of techniques, including self-testing and mind mapping. Intended as a starting point for revision or to check knowledge and understanding of different topics within the unit.
Are you ready for an exhilarating and festive end of term Christmas activity? Look no further than our electrifying Christmas Computing Quizzes. This bundle includes 5 quizzes: one for year 7, 8, 9, 10 and even year 11 meaning you are reuse them year after year without fear that your students will have done them before.
Prepare to be dazzled with these fun digital student-led quizzes specially crafted for each year group studying computing or computer science. Help Santa fix his sleigh, decorate a Christmas tree, solve a mystery, decode the secret Christmas message or break Santa out of prison by answering computing and Christmas related questions correctly that will leave both your SLT and your Computing and Computer Science pupils in high spirits as the term concludes.
HOW DO THE CHRISTMAS COMPUTING QUIZZES WORK?
Once you’ve purchased the resource you get a PDF file for each quiz which contains a link. Share the provided link with your students and watch as it whisks them away to an enchanting digital realm filled with engaging questions and a different, fun Christmas theme for each quiz.
Your students can embark on this journey of knowledge and fun on their own, or, for an added dose of excitement, encourage pairs of students to team up and tackle the quiz together. The joy multiplies as collaboration ignites their enthusiasm.
And the best part? The quiz is a self-guided adventure. As your students conquer each stage, the next one automatically beckons, providing you with invaluable time to support those in need or attend to the myriad of other holiday season tasks tugging at your attention.
Fear not, for we’ve thought of everything. All the answers are readily available in the comprehensive teacher’s guides, ensuring you can rescue any students who find themselves in a puzzling predicament.
These captivating experiences are designed to last most of the lesson but you may need to provide a second activity for early finishers.
WHAT IS INCLUDED?
You get five PDF files, one for each quiz, which contains the link to the activity and includes the answers.
Don’t miss out on this fantastic opportunity! Grab your copy of this great value KS3 Computing and GCSE Computer Science Christmas Quiz bundle – a timeless gem that you can deploy year after year with each new wave of students. Let the festivities begin!
IMPORTANT NOTE:
In order to run the quizzes there are a few activities which require links to external websites. Here are the external sites that you will need to have unblocked on your school network.
view . genial . ly
jigsawexplorer . com
what3words . com
PLEASE NOTE:
This game is intended to be used on a desktop or laptop computer and some of the features will not be available on an iPad or mobile device.
Everything in this bundle should allow for varied revision encompassing the entire of the J277 specifications for GCSE OCR Computer Science.
Recently remade and updated resources! More being updated shortly!
Enjoy!
This is an extensive document (353 slides) Covering all parts of the specification with information and then activities designed to help student to access learn and retain the information.
DOES NOT COME WITH AN ANSWER KEY. I WILL SUPPLY THAT AT A LATER DATE
These resources have been created for those delivering the Digital Functional Skills Qualification at Entry Level which replaces the current Functional Skills ICT Qualification from 31st of July 2023.The DFS qualification’s main purpose is to provide reliable evidence of a learner’s achievements against content that is relevant to the workplace and real life.
These resources provide a structured assessment in workbook form to evidence learner’s knowledge and skills as well as their ability to apply these in different contexts and demonstrate that all learning outcomes have been met.
The qualification itself is made up of many 5 main skill areas (Modules) each with its own series of units.
The unit workbooks include various challenges, activities and tasks to prove learners understanding. Each page has a header that includes the individual outcomes covered and can be assessed easily and signed off.
This resource covers:
Module 2 - Creating and Editing - 2.1 - Use a suitable application to enter, edit and format text
This resource includes:
Task 1 - Learners to identify 3 of the main Word processing software applications and then give 3 examples of editing and 3 examples of formatting text. This will confirm they know the difference.
They will then move into an activity that requires them to label the basic formatting tools found in Microsoft WORD (The application that will be used throughout this unit)
Task 2 - Using their existing knowledge coupled with some online research, learners will complete a table that showcases the functionality and application of the previously identified formatting tools.(Tutor Guided Answers are included)
Task 3 (a) – Learners will open an email and download the attached document (This is included and will have been sent prior by the tutor). Learners will then format the text by following a series of instructions. They will then save the new version ready for the next task. (Guided Tutor example included)
Task 3 (b) – This is a continuation of Task 3(a) with 8 more instructions, some of which will stretch and challenge. Learners will save and print work as evidence. (Guided Tutor example included)
Task 4 – Learners will take part in a ‘true’ & ‘false’ quiz based on the dos and don’ts of formatting text. Tutors can then recap on the unit, encourage discussion and go through answers as a group (Guided Answers included)
Also included in this resource is a Skills and Knowledge checklist to be completed before and after delivery of this unit. It also includes a glossary with key words associated with this module to be completed by the learner in their own time.
Other Workbooks in this DFSQ series are available on TES. Many are still being created and will all be available soon.
This resource is currently in a PDF file format. Word versions are available for free upon purchase of the PDF, please message me directly for these at SmartbooksEd@outlook.com.
IT Microsoft Office Skills Project for KS3/KS4. Students will learn Word, PowerPoint, Excel & Publisher skills by creating a mini project.
7 Lessons covering:
Lesson 1 - Introduction of Project (Student Music Festival Brief), Logo creation PowerPoint & Word Skills)
Lesson 2 - Promotional Material (Word & Publisher Skills)
Lesson 3 - Ticket creation (Word & Publisher Skills) and QR codes
Lesson 4 - Formula (+ - * /), Functions (SUM, MIN, MAX, AVERAGE), Data Types & Conditional Formatting (Excel Spreadsheet Skills)
Lesson 5 - Excel Formatting Techniques, Apply skills from Lesson 4 to create Project Spreadsheet (Excel Skills)
Lesson 6 - Mail Merge, Personalised ticket creation (Word, Publisher & Excel Skills)
Lesson 7 - Evaluation of project & skills (Deciding what level you have worked at), Project presentation (demonstrating all work produced) (Word & PowerPoint Skills)
Lessons include:
Teacher Slides PowerPoint
Student Activity Worksheets (Word Documents, PowerPoints, Excel Spreadsheets)
Starter & Plenary Activities (Word Documents)
Help Sheets (Word Documents & PDF)
These resources have been created for those delivering the Digital Functional Skills Qualification at Entry Level which replaced the current Functional Skills ICT Qualification from 31st of July 2023. The DFSQ’S main purpose is to provide reliable evidence of a learner’s achievements against content that is relevant to the workplace and real life.
These resources provide a structured assessment in workbook form to evidence learner’s knowledge and skills as well as their ability to apply these in different contexts and demonstrate that all learning outcomes have been met.
The qualification is made up of 5 Module and broken down into a series of units.
The unit workbooks include various challenges, activities and tasks to prove learners understanding. Each page has a header that includes the individual outcomes covered which can be signed off. he individual outcomes covered and can be assessed easily and signed off.
This workbook covers:
Module 1 - Using devices and handling information
Unit - 1.1 Know the main features and uses of different types of device.
This resource includes:
Task 1 - Learners to identify 9 key digital devices using images.
Task 2 - Using their existing knowledge coupled with some online research, learners will record below 3 key features for each digital device.
Task 3 – Learner will then collate data on how much each device is used by themselves and their peers.
Task 4 – Using questioning, learners will identify pros and cons of each device and their overall popularity. They will investigate other devices available on the market and give their opinions of the future of technology as a whole.
Also included in this resource is a Skills and Knowledge checklist to be completed before and after delivery of this unit. It also includes a glossary with key words associated with this module to be completed by the learner in their own time. Guided answers when appropriate are also included.
Other Workbooks in this DFSQ series are available on TES. Many are still being created and will all be available soon.
This resource is currently in a PDF file format. Word versions are available for free upon purchase of the PDF, please message me directly for these at SmartbooksEd@outlook.com.
Feedback is Key and we value your positive comments and constructive criticism. Post a review and we will send you another singular resource of your choice for FREE! Just contact us at SmartbooksEd@outlook.com.
These resources have been created for those delivering the Digital Functional Skills Qualification at Entry Level which replaces the current Functional Skills ICT Qualification from 31st of July 2023.
The DFS qualification’s main purpose is to provide reliable evidence of a learner’s achievements against content that is relevant to the workplace and real life.
These resources provide a structured assessment in workbook form to evidence learner’s knowledge and skills as well as their ability to apply these in different contexts and demonstrate that all learning outcomes have been met.
The qualification itself is made up of many 5 main skill areas (Modules) each with its own series of units.
Each workbook includes various challenges, activities and tasks to prove learners understanding. Each page has a header that includes the individual outcomes covered and can be assessed easily and signed off.
This Bundle of resource covers:
Module 1 - Using devices and handling information
1.1 Know the main features and uses of different types of device.
This resource includes:
Task 1 - Learners to identify 9 key digital devices using images.
Task 2 - Using their existing knowledge coupled with some online research, learners will record below 5 key features for each digital device.
Task 3 – Learner will then collate data on how much each device is used by themselves and their peers.
Task 4 – Using questioning, learners will identify pros and cons of each device and their overall popularity. They will investigate other devices available on the market and give their opinions of the future of technology as a whole.
Also included in this resource is a Skills and Knowledge checklist to be completed before and after delivery of this unit. It also includes a glossary with key words associated with this module to be completed by the learner in their own time.
Module 1 - Using devices and handling information
1.2 Know what an application is and the main types of application software
Task 1 - Demonstrate knowledge on the difference between Hardware and Software and give examples for both.
Task 2 - Understand the function of an operating system and know where to find details of an OS on various devices.
Task 3 - Become familiar with the different types of applications available and how they all have a different purpose.
Task 4 - Know how to locate ‘screen time’ on mobile devices and analyse application usage and trends. Discuss the pro and cons and how screen time could be limited.
Task 5 – Write a review for a favourite application using the template provided or leave an actual review on your mobile phone.
Also included in this resource is a Skills and Knowledge checklist to be completed before and after delivery of this unit. It also includes a glossary with key words associated with this module to be completed by the learner in their own time.
Module 1 - Using devices and handling information
1.3 Apply system settings (including display, sound, Wi-Fi, time, language, accessibility).
Task 1 – Learners to become familiar with the system settings menu using Microsoft windows and identify specific settings found in each category i.e. Personalisation, Network etc.
Task 2 – Learners will navigate System settings, locate particular icons and give reasons why they may need to be accessed and applied.
Task 3 – Learners to read 3 scenarios and find a solution for each. They will also show clearly where to locate the setting required.
Task 4 – Learners to create 2 of their own scenarios and challenge their peers to fins a solution using an appropriate system setting.
Task 5 – Includes a selection of Flashcards that can be cut out, printed on cardboard or laminated and used to reinforce knowledge of system settings.
Learners can also be given a card randomly and then demonstrate, using a device, how to apply that particular system setting.
Also included in this resource is a Skills and Knowledge checklist to be completed before and after delivery of this unit. It also includes a glossary with key words associated with this module to be completed by the learner in their own time.
Module 1 - Using devices and handling information.
1.4 Navigate online content to locate required information.
Task 1 - Learners will correctly type 2 URL examples into a browser and record details about the different websites. Learner can continue this task by entering their own URLs to help familiarise themselves further with this practice.
Task 2 - Learners will understand the difference between a browser and a search engine and show this by ticking the correct box next to each example logo.
Task 3 - Learners to unscramble some of the various reasons why we all use the internet. They will also give some examples of their own.
Task 4 - Learners will give examples of effective keywords to use when searching for relevant information online.
Task 5 - Learners will show an understanding of how to check the validity of information found online and will choose 6 example websites to demonstrate this.
Task 6 - Learners will follow step by step instructions on how to save websites into a browser and then bookmark 3 of their own for easier access.
Task 7 - Learners to become familiar with the navigation tools found in browser (chrome) and match the correct name and function of 14 examples.
Module 1 - Using devices and handling information - 1.5 Carry Out Searches online
Task 1 - Learners are required to find the answers to find the answers to 18 general knowledge questions using the World Wide Web. This can be an individual or group timed challenge. All answers will be officially checked with any incorrect answers incurring a 10 second penalty.
Task 2 - Learners will become familiar with the most commonly asked online questions. They will guess using ‘first word’ criteria and then carry out a search to find the ‘most popular’ based on the most current data.
Task 3 - Learners will learn how to take a screenshot using different digital devices, put this into practice and attach the evidence.
Task 4 - Learners will demonstrate how to carry out a variety of searches online. They are required to plan a fictional holiday following specific guidelines and meeting certain criteria.
Extension Activity – Learners to continue with Task 4 and carry out two further searches based around the weather and reviews of their chosen destination and accommodation.
Also included in this resource is a Skills and Knowledge checklist to be completed before and after delivery of this unit. It also includes a glossary with key words associated with this module to be completed by the learner in their own time.
Other Workbooks in this DFSQ series are available on TES. Many are still being created and will all be available soon.
This resource is currently in a PDF file format. Word versions are available for free upon purchase of the PDF, please message me directly for these at SmartbooksEd@outlook.com.
Feedback is Key and we value your positive comments and constructive criticism. Post a review and we will send you another singular resource of your choice for FREE! Just contact us at SmartbooksEd@outlook.com.
A retrieval practice booklet for BTEC Tech Award Digital Information Technology (DIT).
24 High Quality Worksheets:
Ad-hoc Networks: Lists
Features of Cloud Storage: Tell me 5
Features of Cloud Computing: Retrieval Grid
Platforms and The Cloud: Picture Prompt
Choosing Cloud Storage for Business: Cops & Robbers
Managing Teams: Brain Dump
Communicating with Stakeholders: Picture Prompt
How Modern Technology Impacts Business: Challenge Grid
Why Systems are Attacked: Mind Map
External Threats: Tell me 5
Internal Threats: Picture Prompt
Impact of a Security Breach: Brain Dump
User Access Restrictions: Cops & Robbers
Data Level Protection: Brain Dump
Security Policy: Blockbusters
Disaster Recovery: Mind Map
Actions to take after an Attack: Lists
Responsible Use of Data: Retrieval Grid
Environmental Impact: Knowledge Tree
Net Neutrality: Brain Dump
Intellectual Property: Tell me 5
Computer Crimes: Challenge Grid
Legislation (Data Protection Act & GDPR): Picture Prompt
Standards & Guidelines: Tell me 4
Forms of Notation: Brain Dump
Booklet provided as high quality PDF for printing.
Teach your students how to use Excel through Dino Park!
Students have been given a budget of £100,000,000 to build their park. They need to consider what dinosaurs they want to buy, how much space they will need, what facilities they require, staffing costs and ticket price.
Excel Dino Park teaches you how to use functions and formulas through a series of engaging and interactive tasks which are differentiated to support a range of abilities.
Skill that you will learn include:
Add Raw data
Create a graph
Title a graph
Formatting data
Make arithmetic calculations using Excel
Data validation (Drop down menus)
Lookup formulas
Use cell referencing in formulas
Format graphs
Cross worksheet referencing
Advanced arithmetic calculations (nested)
Use absolutely relative cell referencing
Adding messages to data validation
Efficient calculations (autosum)
Conditional formatting
Advanced graph formatting
IF formulas
Linking IF formulas and conditional formatting
The clear explanations and step by step nature make it ideal for KS3 classes, but it is also suitable for ECDL, GCSE and beyond!
Use alongside RobbotResources’ How2Excel’ workbook for a comprehensive understanding of how confidently use Excel!
************************Please leave a review!*************************
More resources coming soon
Cambridge Nationals Information Technologies J836
Unit R050 - IT in the Digital World
Topic Area 1 (Design tools) - (Pages: 2)
Topic Area 2 (HCI in everyday life) - (Pages: 2)
Topic Area 3 (Data and testing) - (Pages: 4)
Topic Area 4 (Cyber-security and legislation) - (Pages: 3)
Topic Area 5 (Digital communications) - (Pages: 2)
Topic Area 6 (Internet of Everything - IoE) - (Pages: 2)
Knowledge Organisers (Blank vs.): Knowledge organisers with blank spaces for pupils to fill in key revision notes.
These can be used by pupils to write the key information for revision.
Knowledge Organisers (Completed vs.): Knowledge organisers with completed revision notes.
These can be used as an answer sheet to the “Blank vs.” or as revision reference materials.
10 Lessons on Microsoft Excel skills.
Lesson 1 - Intro to Excel, Simple Formula & Formatting Techniques
Lesson 2 - Simple Functions (SUM, MAX, MIN, AVERAGE) & Data Types
Lesson 3 - Functions (Count, CountA, Countblank, Round, IF) & Graph Types
Lesson 4 - Functions (IF, SUMIF, COUNTIF) & Intro to Conditional Formatting
Lesson 5 - Recap Functions (IF, SUMIF, COUNTIF) & Using Conditional Formatting
Lesson 6 - Functions (Concatenate, Now, Today, Vlookup)
Lesson 7 - Data Validation Techniques, Sorting Data & Filtering Data
Lesson 8 - Recap Sorting & Filtering Data, Functions (LEFT & RIGHT)
Lesson 9 - Protecting a Sheet, Protecting a Workbook, Encrypt a Workbook with Password, Protect a Workbook using Read Only
Lesson 10 - Creating Macros to link sheets & Creating Pivot Charts
Each lesson includes:
Teacher Slides Powerpoint
Starter/Do Now Tasks (Word Documents or Excel Spreadsheets)
3 - 5 Student Lesson Tasks (Excel Spreadsheets)
Extension Tasks (Excel Spreadsheets, Word Documents or PDF Documents)
Plenary/Exit Tasks (Included in the Teacher Slides Powerpoint)
I have gone over all the criteria for theBTEC TECH AWARD LEVEL 1/2 January 2024 - Component 2: Collecting, Presenting and Interpreting Data Pearson Set Assignment.
I have covered how to complete EVERY task 1-3 BUT I have used a completely different data set as to not break the rules of the exam board.
You can use these resources to PRACTICE the controlled assessment.
I also have a cheaper bundle of resources for Comp1, Comp2 & Comp3.
https://www.tes.com/teaching-resource/btec-tech-award-l1-2-component-1-2-and-3-12943995
This includes all the resources I have created for the Pearson BTEC Level1/Level 2 course.
Are you ready for an exhilarating and festive end of term Christmas activity? Look no further than our electrifying Christmas Computing Quizzes. This bundle includes 2 quizzes: one for year 10 and one for year 11 meaning you are reuse them year after year without fear that your students will have done them before.
Prepare to be dazzled with these fun digital student-led quizzes specially crafted for each year group studying GCSE Computer Science. Decode the secret Christmas message or break Santa out of prison by answering computing questions correctly with a Christmas theme that will leave both your SLT and your GCSE Computer Science pupils in high spirits as the term concludes.
HOW DO THE CHRISTMAS COMPUTING QUIZZES WORK?
Once you’ve purchased the resource you get a PDF file for each quiz which contains a link. Share the provided link with your students and watch as it whisks them away to an enchanting digital realm filled with engaging questions and a different, fun Christmas theme for each quiz.
Your students can embark on this journey of knowledge and fun on their own, or, for an added dose of excitement, encourage pairs of students to team up and tackle the quiz together. The joy multiplies as collaboration ignites their enthusiasm.
And the best part? The quiz is a self-guided adventure. As your students conquer each stage, the next one automatically beckons, providing you with invaluable time to support those in need or attend to the myriad of other holiday season tasks tugging at your attention.
Fear not, for we’ve thought of everything. All the answers are readily available in the comprehensive teacher’s guides, ensuring you can rescue any students who find themselves in a puzzling predicament.
These captivating experiences are designed to last around 60 minutes but you may need to provide a second activity for particularly speedy early finishers.
WHAT IS INCLUDED?
You get two PDF files, one for each quiz, which contains the link to the activity and includes the answers.
Don’t miss out on this fantastic opportunity! Grab your copy of this great value GCSE Computer Science Christmas Quiz bundle – a timeless gem that you can deploy year after year with each new wave of GCSE Computer Science students. Let the festivities begin!
Click here to check out this amazing bundle to get all 5 Key Stage 3 Computing and GCSE Computer Science quizzes at a knock down price.
IMPORTANT NOTE:
In order to run the quizzes there are a few activities which require links to external websites. Here are the external sites that you will need to have unblocked on your school network.
view . genial . ly
jigsawexplorer . com
what3words . com
PLEASE NOTE:
This game is intended to be used on a desktop or laptop computer and some of the features will not be available on an iPad or mobile device.
Are you ready for an exhilarating and festive end of term Christmas activity? Look no further than our electrifying Christmas Computing Quizzes. This bundle includes 3 quizzes: one for year 7, one for year 8 and another for year 9 meaning you are reuse them year after year without fear that your students will have done them before.
Prepare to be dazzled with these fun digital student-led quizzes specially crafted for each year group in key stage 3. Help Santa fix his sleigh, decorate a Christmas tree or solve the mystery by answering computing questions correctly with a Christmas theme that will leave both your SLT and your key stage 3 computing pupils in high spirits as the term concludes.
HOW DO THE CHRISTMAS COMPUTING QUIZZES WORK?
Once you’ve purchased the resource you get a PDF file for each quiz which contains a link. Share the provided link with your students and watch as it whisks them away to an enchanting digital realm filled with engaging questions and a different, fun Christmas theme for each quiz.
Your students can embark on this journey of knowledge and fun on their own, or, for an added dose of excitement, encourage pairs of students to team up and tackle the quiz together. The joy multiplies as collaboration ignites their enthusiasm.
And the best part? The quiz is a self-guided adventure. As your students conquer each stage, the next one automatically beckons, providing you with invaluable time to support those in need or attend to the myriad of other holiday season tasks tugging at your attention.
Fear not, for we’ve thought of everything. All the answers are readily available in the comprehensive teacher’s guides, ensuring you can rescue any students who find themselves in a puzzling predicament.
These captivating experiences are designed to last between 30 to 40 minutes so you may need to provide a second activity for particularly speedy early finishers.
WHAT IS INCLUDED?
You get three PDF files, one for each quiz, which contains the link to the activity and includes the answers.
Don’t miss out on this fantastic opportunity! Grab your copy of this great value Key Stage 3 Christmas Quiz bundle – a timeless gem that you can deploy year after year with each new wave of Key Stage 3 computing students. Let the festivities begin!
Click here to check out this amazing bundle to get all 5 Key Stage 3 Computing and GCSE Computer Science quizzes at a knock down price.
IMPORTANT NOTE:
In order to run the quizzes there are a few activities which require links to external websites. Here are the external sites that you will need to have unblocked on your school network.
view . genial . ly
jigsawexplorer . com
PLEASE NOTE:
This game is intended to be used on a desktop or laptop computer and some of the features will not be available on an iPad or other mobile device.
This could be used as a revision guide for year 11, assessment points throughout the year, or a weekly homework booklet for the duration of the course.
64 page booklet with contents page, sets of exam style questions for each unit (1.1 to 2.6, in order) for OCR GCSE Computer Science. Created in a style so that students can spend around 10 minutes on a particular unit of questions then mark their own work using the internet/revision guides for help.
Each unit has a revise/re-read/expert box at the end so students can log how they feel for each unit and revise those that are priority to them.
Throughout are small, inspirational quotes to help motivate students.
Absolutely brilliant resources, particularly for those students who “don’t know how to revise” or “don’t know what to revise” or “don’t know what to do to revise”. This has been great for those “hard to engage” students.
Relatively cheap to print (cost me £1.08 per booklet to print - this will depend on your own school’s printing costs).
This advice sheet brings together cyberbullying advice and how to be safe online. The factsheet highlights some of the resources available for teachers and schools.
This PowerPoint Presentation is about learning the different types of databases. This PowerPoint also talks about the Relational database mainly as these are more commonly used.
This resource is mainly used for GCSE ICT.
An interactive quiz for the whole class through an IWB, which can be used as a starter or plenary. Covers cyber bullying, using social media responsibly, copying information from the internet and avoiding infecting your PC with viruses.
This python workbook starts with the very basics and guides the students in developing their skills. It hasd multiple tasks throughout the booklet and covers topics such as:
Print
Data Types
Operands
Variables
Loops
Indexing
Quick View
