An experienced writer of Computing/ICT resources (and four text books) my free products have been downloaded over a million times all over the world.<br>
Following years of regular 5 star ratings and very positive feedback I made the decision to start writing commercially. My commercial resources continue to be praised for their professional look and imaginative content.
Please download and enjoy!
Greg (Computing Science teacher for 23 years and now a national computing education adviser)
An experienced writer of Computing/ICT resources (and four text books) my free products have been downloaded over a million times all over the world.<br>
Following years of regular 5 star ratings and very positive feedback I made the decision to start writing commercially. My commercial resources continue to be praised for their professional look and imaginative content.
Please download and enjoy!
Greg (Computing Science teacher for 23 years and now a national computing education adviser)
This detailed database resource is an excellent introduction for students learning database theory and practical work.
The resource focuses of improving problem solving skills, encouraging students to consider field design, validation, searching and sorting. The final few pages introduce relational databases.
This self-contained resource contains:
- Workbook (34 pages)
- Task Sheets (6 task sheets to complete)
- Marking Schemes (9 answer sheets)
Teaching time (~20 hours)
This is a fun unit which has received very positive feedback.
“Wonderful resource”
“Fantastic”
“A great introduction to databases”
All graphics have been purchased and are licensed for use and distribution is this resource.
(Note that TES does not allow database files to be uploaded. For a copy of the two database files please email me at gregreid935@btinternet.com)
Make your lessons fun with Computational Thinking!
Structured Query Language is a programming language used to manipulate information stored in databases. As with all programming languages the best way to learn its functions is through solving problems.
In this series of fun worksheets (or possible homework sheets) are sets of problems that are solved by writing or interpreting SQL instructions. Students must either predict the output of SQL instructions or calculate the SQL that must have been used to produce some given output from a database.
Set 1 includes an explanation of the uses of SEARCH, FROM and WHERE functions followed by 5 pages of questions.
This style of learning is very well received by students who "love solving the problems".
Previously downloaded over 13,000 times, these four worksheets are an excellent introduction to Audacity. Audacity is a free program used to edit sounds for use as: ring tones, sound effects, backing tracks or spoken text.
Each worksheet is very visual, providing a clear set of instruction on how to import, cut, mix and add effects to sound files. Some copyright free sounds are supplied for use with the unit of work.
This resource was previously rated 4.9 from 20 ratings. Comments are shown below:
"Brilliant set of materials, great design, so useful. Excellent, thank you."
"How good does it feel when you find the PERFECT resource for what you want to do?! I'm doing Entry Pathway ICT with SEN pupils, we're going to make podcasts, but first I need to teach them how to use Audacity. This is wonderful, thanks"
(Greg Reid has written two Computing text books for the Scottish education system. His resources are used in thousands of schools all over the world.)
This 16 page booklet is the first of three written to cover the process of creating a website from analysis to coding to final evaluation.
Booklet 1 (analysis and design) covers:
client - developer discussions
requirements (user and functional)
wireframe designs
form designs
website structure diagrams (navigation)
prototypes
5 tasks have been written to accompany the booklet. These come with marking instructions and may be used in class, as homework exercises or even as assessments.
Booklet 2 (implementation examples and task) covering HTML5, CSS and JavaScript coding is also available.
(Greg Reid has written two Computing text books for the Scottish education system. His resources are used in thousands of schools all over the world.)
Computational Thinking (learning to think in a logical/problem solving way) is the buzz word in the teaching of programming. By teaching students to predict the outcome of small pieces of code they naturally become better at building their own programs.
Although this homework uses Scratch program code, the code is simply a vehicle to ask the questions and the homework may be used with students who have never seen Scratch.
Permission has been granted by the Scratch team to uses images of Scratch code.
Have fun. My students loved these!
Previously downloaded 30,000 times on a few websites comments have included:
“Thanks, these look like really good examples and introduce code in a fun and engaging way.”
“Very useful. I’ll use for a Maths class as well.”
“Great examples to understand code. Thank you for sharing it.”
Welcome to the fictional town of Sandyhaig where the residents are desperately seeking to hire a data scientist to help with their Campaign for Better Buses.
Students will take on the role of a data scientist learning:
about Sandyhaig town along with the current bus routes and the data obtained on buses and passengers
how to find the data they need for the campaign
how to present the data in a meaningful easily understood way.
To deliver this unit of work the following student files are included in the download:
A 30 page, student booklet including tasks, examples and final projects of varying difficulty
An appendix booklet with 10 appendices that cover skills like filtering, creating charts and creating a dashboard
A large map of Sandyhaig town
In addition, the following have been supplied for teaching staff:
Advice on delivering the unit
Answers to the tasks
Advice on how each project can be completed
Files used to create the appendices including the completed Excel files and dashboards
This unit has been trialled in several schools with excellent feedback. Have fun.
Many students these days wish to be games programmers. This booklet is the first in a series of four that teaches students the tool and techniques of object orientated programming required to become a beginner games programmer.
In Project 1 students will use the programming language Python, along with its add-on Pygame, to write an object orientated game called Balloon Burst. The booklet covers:
. object orientated programming theory
. coding Balloon Burst (with full instructions)
. extension tasks
. ways to improve your coding
This could be your first step to becoming a games programmer!
This booklet was co-written with my colleague David Stott for the Scottish Advanced Higher Computer Science course but could be used as part of any advanced programming course or games programming club.
Project 2 is also available.
This unit was written to provide homework, class assessments or additional tasks to complement your own database teaching. The theme of the five table relational database provided is Scottish golf club members and their competition results.
There are eight task sheets included as MS Word files:
Task 1 – Analysis & Design – students must identify how problems identified from the beginner design can be solved through the introduction of more tables.
Tasks 2,3 – Query design questions where the columns, tables, criteria and required functions are identified.
Task 4 to 8 – SQL question sets covering: SELECT from multiple tables, alias, calculations, wildcards, aggregate functions (COUNT, MIN, MAX, AVG) and sub-queries. Two versions of task 8 are included showing solution as two separate queries (MS Access) and using a single query with a sub-query.
All marking instructions are provided.
The above tasks were initially written as homework/assessment style questions (I spent 20 years writing questions for the Scottish exam system) but I have since created database files should you wish your students to code the SQL.
The database files are provided in three formats for different environments:
Access files (a student version and others with the completed SQL tasks 2 to 8 queries)
CSV files that you can use to import the table data and build the database
Text files that contain SQL CREATE and INSERT statements which you could use to create the database on a database server
Excel files, Python programs and explanations that can be used to add more of your own data.
Computational Thinking (learning to think in a logical/problem solving way) is the buzz word in the teaching of programming. By teaching students to predict the outcome of small pieces of code they naturally become better at building their own programs.
Although this homework uses Scratch program code, the code is simply a vehicle to ask the questions and the homework may be used with students who have never seen Scratch.
Permission has been granted by the Scratch team to uses images of Scratch code.
Have fun. My students loved these!
Previously downloaded 30,000 times on a few websites comments have included:
"Thanks, these look like really good examples and introduce code in a fun and engaging way."
"Very useful. I'll use for a Maths class as well."
"Great examples to understand code. Thank you for sharing it."
Many students these days wish to be games programmers. This booklet is the second in a series of four that teaches students the tool and techniques of object orientated programming required to become a beginner games programmer.
In Project 2 students will use the programming language Python, along with its add-ons Pygame and NumPy, to write an object orientated game called Tile Match. The booklet covers:
. object orientated programming theory (inheritance, lists vs arrays, stacks, queues and insertion sort)
. coding Tile Match (with full instructions)
. extension tasks
. ways to improve your coding
This course could be your first step to becoming a games programmer!
This booklet was co-written with my colleague David Stott for the Scottish Advanced Higher Computer Science course but could be used as part of any advanced programming course or games programming club.
Project 3 is currently being written and is due for release in Sept 2017.
This is a simple homework that may be used with a variety of ages that covers:
Cut, Copy Paste
Bullet Points
Text Wrap
Clip Art
Inserting Graphics
The 2 page homework is entirely self contained providing the theory notes on one side and questions on the other. This would also make the homework a perfect resources for cover work when staff are absent.
All graphics used in the homework are copyright free clipart or produced by myself.
(Greg Reid has written two Computing text books for the Scottish education system. His resources are used in thousands of schools all over the world.)
Five intermediate level worksheets that teach the specialist skills of computer drawing using shapes (known as vectors).
These colourful, professional resources cover cutting shapes in two, adding effects like transparency, shadows or filters and how to add clip art from Serif's built in gallery. Worksheet II introduces students to nodes, allowing them to potentially create as complicated a shape or drawing as they wish.
Previously these resources had an average rating of 5.
Previous comments are shown below:
"Thank you for sharing these fab resources!"
"Just what I needed to introduce Serif Drawplus to my students, thank you!"
"Great resource, thank you :)"
"Fantastic resource - thank you so much for sharing!"
Basic and Advanced worksheets are also available.
(Hi there. I am an experienced writer of resources whose resources are always designed to be engaging and exciting. As a result they are used all over the world.)
This detailed database resource is an excellent introduction for students learning database theory and practical work.
The resource focuses of improving problem solving skills, encouraging students to consider field design, validation, searching, sorting and relational databases.
This self-contained resource contains:
- Workbook (34 pages)<
- Task Sheets (6 task sheets to complete)
- Marking Schemes (9 answer sheets)
TES does not allow uploads of .css files. Please email me (gregreid935@btinternet.com) for a copy of the required files.
This is a fun unit which has received very positive feedback.
“Wonderful resource”
“Fantastic”
“A great introduction to databases”
The graphics used throughout the unit have been purchased and are licensed for use and distribution.
(Greg Reid has written two Computing text books for the Scottish education system. His resources are used in thousands of schools all over the world.)
Computational Thinking (learning to think in a logical/problem solving way) is the buzz word in the teaching of programming. By teaching students to predict the outcome of small pieces of code they naturally become better at building their own programs.
Although this homework uses Scratch program code, the code is simply a vehicle to ask the questions and the homework may be used with students who have never seen Scratch.
This homework focuses on move and rotate.
Permission has been granted by the Scratch team to uses images of Scratch code.
Have fun. My students loved these!
There are several skills required to be a good programmer. One of these is being able to modularise programs by identifying blocks of code.
This Scratch homework is based around the “broadcast” block which can be used to modularise programs allowing greater control over order, reuse of code and gives sprites the ability to communicate with each other. The homework starts with a worked example.
There are four questions making this homework about a 10-15 minute task.
Note that question 4 will be out of reach of most younger pupils and should possibly set as a challenge (possibly with a certificate or prize for those who successfully solve it)
Students love this style of problem solving homework.
Have fun!
Make your lesson fun by introducing Computational Thinking!
Structured Query Language is a programming language used to manipulate and extract information stored in databases. As with all programming languages the best way to learn its functions is through solving problems.
In this series of fun worksheets (or possible homework sheets) are sets of problems that are solved by writing or interpreting SQL instructions. Students must either predict the output of SQL instructions or calculate the SQL that must have been used to produce some given output from a database.
Set 3 includes an explanation of the uses of DISTINCT, GROUP, AS and ORDER functions followed by 3 pages of questions.
This style of learning is very well received by students who "love solving the problems".
This 72 page booklet is the second of three written to cover the process of creating a website from analysis to coding to evaluation.
Booklet 2 is split into two parts and should take between 20 and 40 hours to complete depending on the coding proficiency of your students.
2A - Implementation Examples: This 48 page booklet gives worked examples of HTML, CSS and JavaScript code using a cycling website as a scenario.
2B - Implementation Tasks: This 24 page booklet contains 13 tasks by the end of which students will have coded a 13 page “student cooking” website.
The content covered can be briefly summarised as:
Building a template page
HTML 5 page structure (header, nav, main and footer)
Positioning content (margins, padding, display & float)
Building a navigation bar using lists and CSS
HTML 5 forms (text, number, radio button, text area and select input)
Interactivity using JavaScript mouse events (roll-over images, changing page styles, showing/hiding content)
Please note that students should have a basic knowledge of HTML (head, body, links, headings, paragraphs and images) and a very basic understanding of CSS (changing text size, font, colour) before starting this course.
The download comes with four additional sets of files:
The complete cycling website created during booklet 2A.
The complete cooking website created by students during the task booklet 2B.
The student files required to get started.
Additional content that can be dropped into blank pages to save student spending hours typing in content.
Booklet 3 (testing and evaluation) will be coming soon.
This booklet was written for the Scottish National 4/5 courses but could be used as part of any programming course for beginners.
The booklet covers the following topics
- What is a program?
- Design Methodologies
- Programming Construct Definitions
- Program Constucts exemplified in Pseudocode (with several tasks to teach pupils design & pseudocode at the same time)
- Readability
- Types of Errors
- Interpreters vs Compilers
Please leave feedback
Thanks
This theory unit was written by my colleague Arthur Kerr and edited by myselfIt was written for the Scottish National 4/5 Computing course but could easily be used with other exam systems.
It covers:
- Networking
- Security
- Legality
- Environment
Please leave feedback
This resource was created to accompany my school's Internet Safety Unit.
The resource can be used to instigate class discussion regarding the accuracy of Internet information, as an information sheet or maybe as a homework exercise (you'd have to write the questions though).
Please leave feedback.
Thanks.