I have been teaching for over 15 years and have seen the changes which have been made to the Technology curriculum. I have successfully embedded computer science into many schools' curriculums to help deliver the new computer science standards
I have been teaching for over 15 years and have seen the changes which have been made to the Technology curriculum. I have successfully embedded computer science into many schools' curriculums to help deliver the new computer science standards
Are you looking for fun Google Spreadsheets activities for students to practice their skills in Google Sheets? This is the perfect set of activities to use! Students will need to have some prior knowledge in using Sheets, thus these prove to be excellent resources for consolidation work or even mini tests. This bundle includes the following products as well as many more scenarios…
At the Movies Spreadsheet Activity
A Google Sheets activity which tests student’s knowledge on the following skills:
Cell referencing
Use of Sum() function
Making predictions by changing data
Creating graphs from data
Students are then expected to complete the associated worksheet which accompanies the spreadsheet.
Million Dollars Spreadsheet Activity
Students use this resource to understand how altering data in Google Sheets allow graphs to change. They understand such concepts by trying to spend a Million Dollars in a minute.
This resource allows students to understand the following:
How graphs change when data in Google Sheets is altered
Use of SUM() functions
How graphs are made
Components of a graph
Advantages of spreadsheets over pen and paper methods
Students are then expected to complete the associated worksheet which accompanies the spreadsheet.
Google Sheets & Graphs Skills: Chocolates Scenario
Students have to read through the tasks on the worksheet to insert data into the Chocolates Google Sheet and to create pie charts. Students will also learn how to analyze data held in Google Sheets and charts. They will also learn to change Google Sheets.
This resource teaches the following skills in detail:
Creating Pie Charts
Analyzing Google Sheets Data
Inserting spreadsheet rows
Using =sum() function
Compare Supermarkets Spreadsheet Activity
A Google Sheets activity which tests student’s knowledge on the following skills:
Cell referencing
Use of simple formula/calculations such as addition, subtraction and multiplication.
Use of Sum() function
Use of min(), max() and mean() functions
Making predictions by changing data
Creating graphs from data
Students are then expected to complete the associated worksheet which accompanies the spreadsheet.
My Pocket Money Spreadsheet Activity
A Google Sheets activity which tests student’s knowledge on the following skills:
Cell referencing
Use of simple formula/calculations such as addition, subtraction, multiplication and division.
Use of Sum() function
Making predictions by changing data
Students are then expected to complete the associated worksheet which accompanies the spreadsheet.
End of Year Awards Spreadsheet Activity
This resource encourages students to interpret data in tally chart to then enter into a Excel Spreadsheet. Students are then expected to read the instructions on their worksheet to either add to or modify their spreadsheet.
This resource covers the following skills:
Entering data
Writing and entering formula.
Formatting spreadsheets
Creating graphs and charts
A nice little activity which introduces students to famous people who have contributed towards the development of Technology and Computer Science over time.
How to Complete the Activity:
Students will need to research their answers to the questions on each character profile and insert their answers into the relevant spaces.
Outcome of Activity:
On completion of this activity, students will have created a timeline of people’s profiles who created or invented something that contributed towards computer science.
This is a digital activity which is completed in Google Slides.
Answer Key included
This digital test consists of 30 multiple choice questions which cover questions on programming in Python as well as programming keywords
Resources included:
• Self Marking Assessment – opens in Google Forms™
• PDF version of assessment
• Answer Key
The benefit of assessments in Google Forms™:
• Students and teachers are able to receive instant feedback.
• Teachers can collate students answers to questions (and their marks) in a Google Sheets spreadsheet to help with data analysis.
When this resource is purchased, along with 2 PDF files, you will also be provided with a link to the assessment in Google Forms™. Once the link is clicked, you will be asked to request permission to access the assessment, once this is received it will prompt you to make a copy of the file to share with your students.
This digital test consists of 30 multiple choice questions which cover questions on Computer Hardware, Memory, Storage and Networks.
Resources included:
• Multiple Choice Assessment – opens in Google Forms™ (Instant Feedback provided)
• PDF version of assessment
• Answer Key
The benefit of assessments in Google Forms™:
• Students and teachers are able to receive instant feedback.
• Teachers can collate students answers to questions (and their marks) in a Google Sheets spreadsheet to help with data analysis.
When this resource is purchased, along with 2 PDF files, you will also be provided with a link to the assessment in Google Forms™. Once the link is clicked, you will be asked to request permission to access the assessment, once this is received it will prompt you to make a copy of the file to share with your students.
This digital test consists of 27 multiple choice questions which cover questions on programming in Scratch 3.0 as well as programming keywords
Resources included:
• Self Marking Assessment – opens in Google Forms™
• PDF version of assessment
• Answer Key
The benefit of assessments in Google Forms™:
• Students and teachers are able to receive instant feedback.
• Teachers can collate students answers to questions (and their marks) in a Google Sheets spreadsheet to help with data analysis.
When this resource is purchased, along with 2 PDF files, you will also be provided with a link to the assessment in Google Forms™. Once the link is clicked, you will be asked to request permission to access the assessment, once this is received it will prompt you to make a copy of the file to share with your students.
This bundle covers all you will need to teach your students how to learn and use Python Programming. This bundle is suitable for beginners as well as those who are more experienced with programming.
It includes all of the following Python resources available on my store, as follows:
Python Coding (Making Shapes) - Introduction to Python
Python Coding (Making Shapes) - Introduction to Loops
Python Coding (Making Shapes) - Getting User Input
Python Coding (Making Shapes) - Conditional Statements
Python Coding (Making Shapes) - Data Types
Python Coding (Making Shapes) - Independent Assessment
Python Programming Coding - Introduction to Python
Python Programming Coding - Creating Calculations
Python Programming Coding - Data Types & If Statements
Python Programming Coding - Creating & Using Functions
Python Programming Coding - Creating Loops
Spot the Error Task Cards - can be used at the end of delivering the above lessons as a form of assessment
Jumbled Task Cards - can be used at the end of delivering the above lessons as a form of assessment
I Can Statements - These should be used throughout the delivery of the lessons. Students and teachers can use these as a tick sheet for skills developed
Python Coding Mazes - this resource can be used as the very first introduction to coding, before the teacher introduces Python to students.
Python Programming – Creating a Login System and Storing and Reading data from a file.
Python Programming – Working with one-dimensional arrays.
Python Programming – Working with two-dimensional arrays.
Python is a free downloadable software and very easy to use. As students work through this material they build up their skills in programming. Get ahead with developing your own and your students skills to learn programming. This is an ideal resource for the introduction of Computer Science and Computational Thinking into the curriculum.
This lesson moves students on from the basics of coding in Scratch and begins to introduce students to create more efficient code through the use of cloning as well as making use of less lines of code (by removing repeated code). In this lesson, students will learn a better way to code.
Students are expected to have some prior knowledge of Scratch and should be comfortable with the following concepts:
Creating and using variables
If statements
Loops
Scratch blocks
This is a fun and engaging manner to teach students the concept of the list data structure in Scratch.
This resource comes complete with:
Colorful lesson powerpoint which includes explanations and student tasks (editable and PDF format)
Detailed lesson directions
Student worksheet
Answer Key
I Can Statements.
Depending on the ability level of your students and their pace to pick up new coding concepts, this resource is a weeks worth of teaching material (1 hour per day).
This lesson moves students on from the basics of coding and using variables in Scratch and begins to introduce them to LIST data structures. With this lesson, students will learn a better way to store data, what lists are, why they are used as well as their benefits i.e. inserting data, adding data, finding and deleting data etc…
Students are expected to have some prior knowledge of Scratch and should be comfortable with the following concepts:
Creating and using variables
If statements
Loops
Sensing and Motion Blocks
This is a fun and engaging manner to teach students the concept of the list data structure in Scratch.
This resource comes complete with:
Colorful lesson powerpoint which includes explanations and student tasks (editable and PDF format)
Detailed lesson directions
Student worksheet
Answer Key
I Can Statements.
Depending on the ability level of your students and their pace to pick up new coding concepts, this resource is a weeks worth of teaching material (1 hour per day).
These computer worksheets introduce students to different computer hardware.
Topics include:
Name the Hardware
Classify Hardware into Input/Output devices
Research Hardware
The following file formats are provided:
Google Slides™ - suitable for distance learning
PDF – suitable for CS unplugged activities
Answer keys are included in this resource.
Worksheets open in Google Slides™ so that resources can be shared with students in Google Drive or Google Classroom. This resource is suitable for Distance Learning.
These worksheets cover some of the main health and safety issues which can occur when using technology.
Topics covered include:
Health & Safety problems linked to using prolonged use of Technology
Solutions to Health and Safety issues
Worksheets range from:
Drag & Drop activities
Fill in the gaps
Agony Aunt scenarios
True or false activities
This resource comes in the following formats:
Google Slides™ version: the resource can be shared with students via Google Classroom and are suitable for distance learning
Printable Worksheets (PDF files)
Answer keys are included in this resource
Get ahead in teaching your students about computer hardware. This resources enables your students to learn about the components inside their PC as well as the components inside the Central Processing Unit (CPU) in great detail.
The following topics are covered in this resource:
Components inside my computer i.e. RAM, Hard Disk Drive, CPU, Fan etc…
Inside my CPU i.e. CPU Registers (Memory Data Register, Memory Address Register) and the 3 data transfer channel
How the CPU carries out its job and interacts with RAM
How the Fetch, Decode & Execute cycle impacts the different registers inside the CPU.
The following items are included in this resource:
Editable teacher powerpoint
PDF teacher powerpoint
Student worksheets
Inside my Computer - A Build & Learn Activity
Basic worksheet outline - delivery guidance for the teacher
Using this resource will also provide the foundations in understanding the workings of the CPU in detail.
Allow students to gain a greater understanding of databases using these Digital worksheets which open in Google Slides™. These worksheets can be shared in Google Drive or Google Classroom. This resource is suitable for Distance Learning and comes complete with an answer key.
This resource includes the following worksheets:
Database Keywords
Sorting databases
Filtering databases
Creating Data Capture Forms
Databases in organisations
Sorting Data Types
Finding Data Length
This is the perfect way to introduce students to Databases.
A fantastic technology activity which will keep your students occupied for hours. Students need to follow the supplied instructions to create their own smartphone using the resources provided. A color, cut and glue activity.
**Students will create the following:
**
Home Screen with Apps
Inner Screen with Apps
Inside the Smartphone
These are constructed together to create their own smartphone.
A fantastic technology activity which will keep your students occupied for hours. Students need to follow the supplied instructions to create their own smartwatch using the resources provided. A color, cut and glue activity.
Students will create the following:
Home Screen with Apps
Inner Screen with Apps
These are constructed together to create their own smartwatch. Take a look at the Preview for a more in-depth look.
This bundle of resources is a huge time saver if you have a supply teacher taking your classes or you have students working from home. It consists of 9 different technology and computer science topics each containing their own activities. You do not need to use a computer for the majority of these activities so you can literally just print and go.
A set of 45 Python Keywords which can be used to display around the computer room or even printed out for students as revision cards.
These are perfect to refer to when when highlighting certain programming keywords or constructs to your students.
This lesson moves students on from the basics of coding and using variables in Python and begins to introduce them to string manipulation. With this lesson, students will learn how to access each element in a string via its index as well as how to iterate through each element. Numerous string manipulation methods are covered in this lesson, some of which include .upper(), isupper(), .count() etc……
Students are expected to have some prior knowledge of Python and should be comfortable with the following concepts:
• Creating and using variables
• If statements
• Loops
• Print and input functions
• Lists
This is a fun and engaging manner to teach students how to manipulate strings in Python as well as the functions associated with string manipulation.
This resource comes complete with:
Colourful lesson powerpoint which includes explanations and student tasks (editable and PDF format)
Detailed lesson directions
Student worksheet
Answer Key
I Can Statements.
Depending on the ability level of your students and their pace to pick up new coding concepts, this resource is 1 weeks worth of teaching material (1 hour per day).
This resource consists of 50 pages and includes Python code files.
Python Programming – Creating a Login System with File Reading & Writing
This lesson moves students on from the basics of coding and encourages students to begin to store data to a file as well as search for specific data from the file.
Students learn to create a login system which requires them to entire their username and password. Correct details will need to be inserted or else the system alerts the user to an errors. Students then move forward to code a login system from which different options can be selected to write data from a file and to search for specific data from a file.
Students are expected to have some prior knowledge of Python and should be comfortable with the following concepts:
• Creating and using variables
• If statements
• Loops
• Print and input functions
This resource comes complete with:
Colourful lesson powerpoint which includes explanations and student tasks (editable and PDF format)
Detailed lesson directions
Student worksheets
Answers to worksheets.
Depending on the ability level of your students and their pace to pick up new coding concepts, this resource is 3 lessons worth of teaching material (1 hour per day).
This lesson moves students on from the basics of coding and using variables in Python and begins to introduce them to 2D LISTS data structure. With this lesson, students will learn a better way to store data, what 2D lists are, why they are used as well as their benefits i.e. slicing 2D lists, inserting data, sorting etc…
Students are expected to have some prior knowledge of Python and should be comfortable with the following concepts:
• Creating and using variables
• If statements
• Loops
• Print and input functions
• 1D list data structures
This is a fun and engaging manner to teach students the concept of the list data structure in Python.
This resource comes complete with:
Colorful lesson powerpoint which includes explanations and student tasks (editable and PDF format)
Detailed lesson directions
Student worksheet
Answer Key
I Can Statements.
Depending on the ability level of your students and their pace to pick up new coding concepts, this resource is 2 weeks worth of teaching material (1 hour per day).
This resource consists of 106 pages and includes Python code files.
Fully differentiated Paper 1 “Research and Revise” Work Book to enable all your students to prepare for the AQA GCSE Paper 1 Computer Science Exam.
The worksheets in this 50-page workbook focuses on the keywords used and tested in each of the sub topics of the Paper 1 specification (an important element for the exam). Being able to know and accurately define keywords enables students to achieve some of the vital key marks.
No teacher input is required with this resource unless students struggle to research.
These worksheets come in a 50-page booklet and can even be used as part of starters, main lesson tasks or homework.
They are the perfect way to introduce each topic in Paper 1 of the AQA Syllabus.
The following topics are covered:
• Fundamentals of Algorithms
• Programming – Data Types
• Programming – Programming Concepts
• Programming – Arithmetic Operations
• Programming – Relational Operations
• Programming – Boolean Operations
• Programming – Data Structures
• Programming: Input, Output & File Handling
• Programming: String Handling
• Programming: Subroutines
• Programming: Structured Programming
• Programming: Robust & Secure Programming
• Programming: Classification of Programming Languages
• Fundamentals of Data Representation: Number Bases
• Fundamentals of Data Representation: Converting Between Number Bases
• Fundamentals of Data Representation: Units of Information
• Fundamentals of Data Representation: Binary Arithmetic
• Fundamentals of Data Representation: Character Encoding
• Fundamentals of Data Representation: Representing Images
• Fundamentals of Data Representation: Representing Sound
• Fundamentals of Data Representation: Data Compression
• Computer Systems: Hardware & Software
• Computer Systems: Boolean Logic
• Computer Systems: Software Classification
• Computer Systems: Systems Architecture
• Computer Systems: Fundamentals of Computer Networks