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
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
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).
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/
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
This is the complete bundle for Turtle Academy including Lesson Booklets, Homework Booklets, Worksheets and PowerPoint Materials. Use this material with your students to teach programming and cover the following topics:
Using instructions to draw simple shapes
Using instructions to draw complex shapes
Change the line and fill colour
Interior and exterior angles
Turtle Academy is a free online 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 into the curriculum.
Suitable for Maths as it also teaches about shapes and regular polygons.
Turtle Academy software can be accessed and used for free from http://turtleacademy.com/playground/en
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
These lessons are not just step by step tutorials, but cover programming concepts in details such as IF statements, loops etc…. Questions in the worksheet also expect students to look at their created scratch blocks and explain how and why they work as well as how and why they can be modified. (answer key included for questions).
My students have truly enjoyed the lessons in this bundle and have become independent learners of Scratch 3.0.
This bundle covers the basics (and much more) of Scratch 3.0 by teaching the following topics:
• Lesson 1 – introduction to Scratch 3.0
• Lesson 2 – Animations & Costumes
• Lesson 3 – Loops & Motions
• Lesson 4 – Coordinates & Sensing
• Lesson 5 – Drawing with Sprites
• Lesson 6 – Using Variables
• Lesson 7 – Changing Backdrops
• Lesson 8 – Making Music
• Lesson 9 – Scratch Games
• Lesson 10 – Animated Stories
• Lesson 11 – Scratch Assessment
Each lesson contains the following:
• Detailed lesson directions
• Starter activities
• Review activities
• Main lessons activities with accompanying worksheets
• Homework sheets
• Answer keys for Class sheets and Homework Sheets
• Animated & editable PowerPoint presentations to aid teacher delivery
• Pdf versions of lesson PowerPoint presentations
• Scratch Keywords
• I Can Statements for Scratch
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.
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.
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.