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
Fully differentiated Unit 1 and Unit 2 “Research and Revise” Work Books to enable all your students to prepare for the OCR GCSE Unit 1 and Unit 2 Computer Science Exam.
These workbooks focus on the keywords used and tested in each of the sub topics of Unit 1 and Unit 2 (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.
Unit 1 workbook consists of 36-pages and Unit 2 workbook consists of 26-pages. Worksheets can be used as part of starters, main lesson tasks or homework.
These workbooks are perfect for students to work through up until the start of their GCSE exams.
They are also the perfect way to introduce each topic in Unit 1 and Unit 2.
**The following topics are covered: **
1.1 – System Architecture
1.2 – Computer Memory
1.3 – Computer Storage
1.4 – Wired & Wireless Networks
1.5 – Network Topologies, Protocols and Layers
1.6 – System Security
1.7 – Systems Software
1.8 – Legal, Ethical & Environmental Considerations
2.1 – Algorithms
2.2 – Programming Techniques
2.3 – Producing Robust Programs
2.4 – Computational Logic
2.5 – Translators & Facilities of Languages
2.6 – Data Representation
Fully differentiated Unit 2 “Research and Revise” Work Book to enable all your students to prepare for the OCR GCSE Unit 2 Computer Science Exam.
These worksheets focus on the keywords used and tested in each of the sub topics of Unit 2 (an important element for the exam). Being able to know and accurately define keywords enables students to achieve some of the vital marks in the exam.
No teacher input is required with this resource unless students struggle to research.
These worksheets come in a 26-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 Unit 2.
The following topics are covered:
2.1 – Algorithms
2.2 – Programming Techniques
2.3 – Producing Robust Programs
2.4 – Boolean Logic
2.5 – Programming Languages & Integrated Development Environment
Please note, this work book is not created or endorsed by OCR.
Unit 1 “Research and Revise” Work Book to enable all your students to prepare for the OCR GCSE Unit 1 Computer Science Exam.
These worksheets focus on the keywords used and tested in each of the sub topics of Unit 1 (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 40-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 Unit 1.
The following topics are covered:
1.1 – System Architecture
1.2 – Memory & Storage
1.3 – Computer Networks, Connections & Protocols
1.4 – Network Security
1.5 – Systems Software
1.6 – Ethical, Legal, Cultural & Environmental Impact
Please note, this work book is not created or endorsed by OCR.
This set of lessons teaches students how to create HTML Websites starting with the very basics moving onto advanced concepts. Students are taught how the basic structure of HTML generates an actual webpage using the software Notepad++
Students are able to engage in independent learning using the HTML Help Cards provided once they are shown how to set up their very notepad++ file and save it with the .html extension.
The following HTML skills are covered in this resource:
Adding Headings
Adding Background colors
HTML Color Codes
Adding Text
Formatting Text – Bold, Italic, Underline and color
Inserting Images
Altering image size and position
Adding Tables
External Hyperlinks
Internal Hyperlinks
Graphical Links
Books
Cascading Style Sheets
<Div></DIV> tags
<Style></Style> tags
tag
ID tags #
Class tags
This resource comes complete with:
Colorful lesson powerpoints which includes explanations and student tasks (editable and PDF format)
Detailed lesson directions
I Can Statements.
In Class HTML Project Challenge
Web Authoring Homework Project
HTML Code file
Assessment Rubric/Teacher Assessment Guide for both the class project and the homework project
HTML Help Cards
Depending on the ability level of your students and their pace to pick up new coding concepts, this resource is 9 weeks’ worth of teaching material. Students really enjoy making website in HTML especially when they are able to see a visual output.
Please email me on balborde@gmail.com if you would like a more detailed preview of the resources.
A Microsoft Excel worksheet activity which tests students’ knowledge on the following skills:
Cell referencing
Use of formulae/calculations such as subtraction and multiplication.
Making predictions by changing data
Use of Sum() function
What if questions
Use this superb resource as a simple warm up exercise or to teach new skills.
Answer Key included.
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 formulae.
Formatting spreadsheets
Creating graphs and charts
A Microsoft Excel worksheet activity which tests students’ knowledge on the following skills:
Cell referencing
Use of simple formulae/calculations such as addition, subtraction, multiplication and division.
Use of Sum() function
Making predictions by changing data
This activity is ideal to teach students about the insides of the computer. Students are expected to build the inside of the computer as well as learn about each component.
The following key terms are covered:
Motherboard
Power Supply
Heat Sink
CPU
RAM Chip
Network Interface Card
Hard Disk Drive
Motherboard
This resource comes in 2 formats:
Paper based (PDF)
Digital Interactive format which opens in Google Slides. Students can type and drag and drop answers onto the worksheets.
Thanks to Open Clip Art for illustrations and KindergartenWorks (LesliesHand) for the Font Style
An excellent lesson which covers slightly over 2 hours of classwork time. Students learn to use the very basics of Python to create simple shapes and as well as use different programming concepts.
In this lesson, students will understand and use the following concepts based on the progress they make::
Variables
print()
Input()
loops
If Statements
Python turtle commands
I Can Statements, Starter, Main Activities, End of lesson Review, Homework and Answer Key included.
This lesson moves students on from the basics of coding and using variables in Python and begins to introduce them to LIST data structure. 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. slicing 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
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 a weeks worth of teaching material (1 hour per day).
Teach your students how to encrypt and decrypt binary messages as well as understand binary code. This resource includes a hidden February themed message which students need to decrypt using the key (ASCII Table). Students are also given the option to write their own encrypted binary message.
This is a perfect CS unplugged activity and can be used as an introduction to a lesson, for homework, for early finishers or even when you have no access to computers in the computer lab.
A set of 48 question cards which allow students to think about how to achieve a number of different skills in Slides, Docs, Sheets and Drawings. Perfect to use as bell work or even review activities as these cards do generate a discussion amongst your students.
This file contains 4 question cards per page (12 pages in total). Question cards can be printed in color, cut out, laminated and then given to students to use.
Question cards for Docs, Drawings, Sheets & Slides can also be purchased separately from my store if you do not want to buy the bundle.
This bundle includes the following Question Cards:
12 Google Slides Question Cards:
• Google slides features
• Tools in Google Slides
• Insert Images
• Insert shapes
• Insert word art
• Difference between animations and transitions
• Animations in slides
• Creating tables
• Shading table
• Google Slides interface
• Downloading Slides to PowerPoint
• Google Slides definitions
12 Google Sheets Question Cards:
• Formatting Google Sheets
• Deleting Columns
• Spreadsheet Features
• Cell References in Google Sheets
• Pie Charts
• Formulae
• Google Sheet Keywords
• Difference between Formulae and Formula
• Creating Charts
• Chart Items
• Adding fill color to Google Sheets
• Customizing pie charts
12 Google Drawings Question Cards:
• Inserting images
• Inserting Word Art
• Duplicating Shapes
• Drawings Tools
• Formatting Shapes
• Features of Google Drawings
• Google Docs Interface
• Changing Shapes
• Rotating Shapes
• Downloading Drawings
• Google Drawings definitions
12 Google Docs Question Cards:
• Creating Tables
• Page Numbers
• Insert Images
• Formatting Text
• Formatting Tables
• Features of Google Docs
• Google Docs Interface
• Paragraph alignment
• Line spacing
• Bullet Points
• Downloading Docs to Word
• Google Docs definitions
12 different internet safety & digital citizenship task cards which can be used in lesson for either starter activities or review activities.
Print, cut and distribute to students.
Following topics are covered:
-Passwords
-Phishing
-Virus
-Antivirus software
-Spyware
-Scam
-Identity theft
llow students to gain a greater understanding databases. Sheets include topics about the following:
• 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 without the need for a computer.
Let your students become familiar with Scratch Programming before they even use the software. Students are given a maze with symbols on them. They have to choose the correct Scratch blocks to guide the cat sprite to the end of the maze. Each maze gets progressively harder.
Let your students become familiar with very basic Python Programming before they even use the programming language. Students are given a maze with symbols on them. They have to choose the correct python code to guide the python to the end of the maze. Each maze gets progressively harder.
Teach your students how to encrypt and decrypt binary messages as well as understand binary code. This resource includes a hidden seasonal themed message for each month of the year which students need to decrypt using the key (ASCII Table). Students are also given the option to write their own encrypted binary message.
This is a perfect CS unplugged activity and can be used as an introduction to a lesson, for homework, for early finishers or even when you have no access to computers in the computer lab.
This is an ideal activity for the ISTE Standard of Computational Thinking/
Students will need to use the “FILL TOOL” to color certain cells in the spreadsheet to reveal a hidden Valentines Day picture.
This resource is for both students beginning to learn Microsoft Excel and for experienced users.
This resource includes 6 excel files – hidden mystery pictures with instructions on how the image can be revealed.
Save £21 by purchasing this bundle
Students will need to use the “FILL TOOL” to color certain cells in the spreadsheet to reveal a hidden seasonal picture.
This resource is for both students beginning to learn Microsoft Excel and for experienced users.
This resource includes 34 hidden mystery pictures (excel files) – with instructions on how the image can be revealed.
This bundle contains the following hidden pictures:
• 4 Presidents Day Mystery Pictures
• 6 St. Patricks Day Mystery Pictures
• 6 Valentine’s Day Mystery Pictures
• 6 Halloween Mystery Pictures
• 12 Christmas Mystery Pictures
• 6 Easter Mystery Pictures
Answer Key included
These I Can statements are perfect to guide your students to develop the necessary skills when learning to code/program using Python.
The teacher or the student can tick off each I Can statement once they have demonstrated evidence for them.
I Can statements fall under the following 4 categories:
• Criteria 1: Planning
• Criteria 2: Skills Development
• Criteria 3: Explanation of Code
• Criteria 4: Efficiency of Code