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.

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.

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 3 includes an explanation of the uses of DISTINCT, COUNT, AS & GROUP functions to produce formatted output, followed by 3 pages of questions. This style of learning is very well received by students who "love solving the problems".

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 2 includes an explanation of the uses of INSERT, UPDATE & DELETE functions followed by 5 pages of questions. This style of learning is very well received by students who "love solving the problems".

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".

Ever wished you could write resources that looked like they could have been professionally written? This staff tutorial teaches the skills and techniques required to create colourful, professional looking resources quickly. If you'd like to sell resources yourself or simply improve your own classroom resources this download is a great place to start. Today’s pupils live in a world where they are surrounded by colourful, interactive content which is literally at their fingertips. It should come as no surprise then that when presented with a white worksheet covered with black text and a couple of Googled graphics many pupils instinctively respond negatively. A modern teacher has a responsibility to improve their own skills in order to create engaging resources Note that this version of the tutorial contains instructions to create resources using Serif PagePlus, a very popular desktop publishing application. PagePlus is used in many schools due to its fun interface, ease of use and fantastic facilities. I highly recommend it to colleagues when delivering training on this topic. This staff tutorial could possibly be used with older students to teach the skills required to write professional looking reports.

(Hi there. I am an experienced writer of resources who has written two Computing text books for the Scottish education system. My resources are always designed to be engaging and exciting. As a result they are used in thousands of schools all over the world.) Six worksheets that teach the basics of computer drawing using shapes (known as vectors). The worksheets cover creating shapes, adding colour, adding text, using brush strokes, grouping and layering. These colourful, professional resources have already been downloaded thousands of times receiving an average rating of 5 out of 5. Previous comments for these worksheets are shown below: Thank you for sharing these fab resources! Thanks for sharing - these are ideal! :) 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! Intermediate and Advanced worksheets are 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.) 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.

(Greg Reid has written two Computing text books for the Scottish education system. His resources are used in thousands of schools.) Previously selected by TES to appear on their Twitter feed, this resource was created to help younger students understand the basics of good PowerPoint design. It covers the correct use of colour themes, text content and animation, often indicating that less is more. The resource may also be used as a poster when printed in A3. This resource was previously rated 5 out of 5 and included comments such as: Brilliant well done. Often the children are tempted to add every possible text, colour, image and animation possible. This guide helps to show them how to keep their presentation looking snazzy without looking a mess! Thank you! This is an excellent resource has been selected to feature on the @TESPrimary twitter feed over the next week. Thank you so much for sharing, you are helping to inspire teachers and students all over the world!

(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.) 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"

(Hi there. I am an experienced writer of resources who has written two Computing text books for the Scottish education system. My resources are always designed to be engaging and exciting. As a result they are used in thousands of schools all over the world.) Previously downloaded over 27,000 times, this worksheet is an excellent introduction to Scratch. Scratch is a fantastic free program developed by MIT to teach programming concepts to young children. The worksheet is very visual, providing a clear set of instruction on how to create a basic 'shark chasing fish' game with movement, control and scoring. Royalty free images are supplied for use with the worksheet. 7 Extension Sheets are also available to download. This resource was previously rated 5 from 29 ratings. "The teaching resources are fun, and task sheets clearly explain all aspects of Scratch and the game elements."

(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.) Previously downloaded over 27,000 times, these 7 extension sheets continue the basic game created in "Creating a Computer Game using Scratch"(please download first). The sheets are designed to encourage and develop problem solving skills (solutions are supplied on the back of each worksheet) by adding new features to the basic game (sound, more fish, speech, game over screen, bonus items etc) This resource was previously rated 5.0 from 28 ratings. Comments are shown below: "These are amazing. I find it really hard to get from following every instruction to breaking it down so that they can adapt things to their own ideas. this does the job brilliantly." "Thanks so much, the resource is perfect for my new programmers."

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."

(My resources are used in thousands of schools all over the world. I hope you enjoy this one.) At the end of my App Inventor unit I asked my students to create a phone app of their own. While most coped well others required a bit more help. These three worksheets provide worked examples to be used for inspiration. The worksheets may also be used by staff who wish to see working examples of apps as part of their own learning. Screenshots and images from App Inventor for Android are created and shared by Google and used according to terms described in the Creative Commons 3.0 Attribution License located at http://creativecommons.org/licenses/by/3.0 Have fun. My students loved these! Previously downloaded 40,000 times on a few websites comments have included: “Brilliant resources! Thank you for sharing.” “Would love to introduce this into my school ICT curriculum.” “Fantastic resource.

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.

This is a simple homework that may be used with a variety of ages that covers: Spell Checking Search & Replace 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. Screenshots used from Microsoft Word are used with permission of Microsoft and are trademarked Microsoft® software. Permission of use is granted under the End User Licence Agreement.

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)

(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 (20 pages)< 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” “Simply great” 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!

App Inventor was developed by MIT to teach students programming in a fun context that every modern student understands, mobile phones! My students love this unit. It allows them to move at their own pace, be creative and solve problems. For many of them it is their first introduction to the world of programming. I first created this resource in 2012 but have recently updated it for App Inventor 2. The original free version was downloaded over 30,000 times with consistently exceptional feedback so I have written this new version as a commercial product. The unit contains: 8 pdf copies of the workbooks Teaching notes Pupil files required for each workbook An app design sheet Have fun!! snegreid (The Android Robot, screenshots and images from App Inventor for Android are created and shared by Google and used according to terms described in the Creative Commons 3.0 Attribution License located at http://creativecommons.org/licenses/by/3.0/.)