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

Create a version of the popular phone app Flappy Bird and then add Percy the Parrot of Doom, Invincibility and Increasing Difficulty to enhance the game. This colorful, exciting workbook introduces programming skills and develops problem solving skills while using proper computing terminology. Unlike a lot of programming resources this workbook has been targeted specifically at able Elementary School or Middle School students. During a series of increasingly challenging tasks students will create a version of the popular mobile phone app Flappy Bird. They then go on to enhance the game by adding another character, increasing levels of difficulty (using variables) and invincibility mode (using the timer). Students will be expected to think like real programmers solving problems and testing their solutions. The 52 page workbook contains detailed solutions to each task for both staff (who may lack programming confidence themselves) and students. A glossary of Computing terms is included at the back of the workbook. Once students have completed the tasks (either on their own or with some help) they should be well equipped to write computer programs of their own.

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

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.

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

A getting to know you activity for new Computing Science classes. Pupils have to circulate and find the names of pupils who... "own an 8Gb Flash Drive" "can say who their ISP is" and so on. There are 19 Computing related facts or questions on the sheet. Once completed the class can discuss what they have learned about each other (and about Computing). Works really well in class. Have fun!

A 15 mark database homework/revision question covering: Update Errors Field Types Primary and Foreign Keys to Link Tables Presence Check Searching Written for the Scottish National 5 course but valid for all introductory Database units. My students found this very useful. Question 2 of 6.

A 19 mark database homework/revision question covering: Relationships Between Tables Compound and Surrogate keys Input Validation Problems A Report and its Underlying Query Sum Function in Report Footer Form Design Written for the Scottish Higher course but valid for all intermediate level Database units. My students found this very useful. Question 5 of 6.

These exercises were written to solve that familiar problem of; “what homework do I give during practical lessons like programming?”. In this series of questions students are asked to consider small programming problems and design solutions using pseudocode or a programming language of their choice. Homework 6 of 10 includes questions on: - Functions - Procedures - Parameter Passing - Opening a Link to a Text File - Algorithm – Find Maximum - Logic Error - Array of Records Three marking schemes give answers in: 1. Pseudocode 2. Python 3. Visual Basic Python and Visual Basic Solutions are also supplied to use when demonstrating/discussing solutions. My students found this a very helpful aid to their understanding of program structures and problem solving. Questions 1-5 are available to purchase as a bundle.

These worksheets were written for my Scottish, Curriculum for Excellence S2 course. The worksheets cover the basics of editing digital photographs (eg. terms like resolution) to complex techniques like cloning and colour selection. The unit is based around Serif's PhotoPlus X4 application which is a superb, easy to use, yet powerful, bit-mapped editing program. The files that go with the unit are too large to upload so please contact me for a copy. G Reid Principal Teacher of Computing

These 7 lessons were written to be delivered as part of a Scottish Qualifications Authority workshop to discuss with Computing Science teachers alternative ways to deliver web coding. They are designed to introduce fun problem solving exercises (some paper-based, some practical) and are intended to be used as lessons starters or simply to break up longer coding exercises. The lessons cover: 1. Basic Tags/Elements (h1, h2, p, title) Pupils are given cut out pieces of web content and code and must arrange the pieces on a blank A3 HTML template printout. 2. Coding Basic Tags (h1, h2, p, title) Pupils are given an HTML file with page content (as a single paragraph of text) but no elements. They must separate the text out and add tags to format the content. They are also asked to research how to create the bullet point list required by the task. 3. Division Tags (div) Similar to lesson 1 but introducing the concept of sectioning off a page using division tags. 4. Adding In-line Styles (text colour, text size, background colour, fonts) Pupils are given an HTML file, printed on A3 paper, with spaces for styles to be added. They must arrange a number of cut-out styles on the HTML file to match a screenshot of a finished page. 5. Adding In-line Styles Pupils are given an screenshot of a finished page with annotations showing colours, fonts and text-sizes used. They must edit the styles in a given file to match the finished page. 6. External Style Sheets Pupils are shown the same site implemented using in-line and then an external stylesheet. This is used to discuss the advantages of external styles. Their task this time is to edit, delete and add to the stylesheet to alter the look of the website to match a fnished example. 7. Cascading Order Pupils are given 5 A3 sheets each which shows an HTML file, a CSS file and a screenshot of the page when shown in a browser. These examples must be examined carefully and used to research the precedence order used when a browser interprets styles (i.e. In-line over-rules external, ID overrules external). This a a difficult task requiring a lot of code reading and problem solving. Level: (Beginner / Intermediate) Duration: (Around 3 to 4 hours in Total) Teaches: (See above)

This unit was written to improve pupils understanding of the hardware and software components which are required to build a computer system. By learning how to understand specifications pupils should be able to make informed choices when they choose components. Geeky but great fun and engaging. The unit covers the Scottish Curriculum for Excellence, Es & Os 3-08c and 4-08d. Have fun Greg P.S. Please leave feedback.

In this enterprise task, pupils create a website for a client (another member of staff, local group, charity or company). Pupils are expected to work in groups, identifying their own skills, sharing workload, communicating with their client and meeting deadlines. This is the next step after my Basic Web Design unit where pupils learn how to use web editing software. Greg Reid Please review for future updates.

This unit covers Data Representation & Computer Architecture for N4 é N5. It covers: Binary Units Bin to Den and Den to Bin conversion ASCII Bit-Map Storage and Calculations of File Size Vector Graphic Storage Machine Code Computer Architecture (memory, processor components, buses, addressibility) é Interfaces Three calculation sheets accompany the unit. For access to all the files send me a message with your e-mail address and I’ll register you for the Dropbox they’re stored in. Please leave feedback. G Reid

These were written as part of my new Curriculum for Excellence course for S1 pupils. Pupils are not forced to work through the help sheets but use them when required. All pupils then work through the Comic Life Projects sheets to a level of their own choosing. Each new project is more challenging. If you definitely wish to use this unit, please e-mail me for a copy of the files as there are too many to upload. Thanks Greg Reid