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 games programmers. Pygame is a fabulous addition to the extremely popular programming language Python. It is used to write professional looking computer games. This tutorial was originally written as part of a training day I led for staff interested in using Pygame as part of their teaching or as part of a games programming club. The training day was very well received so I have adapted the materials to allow self tuition by staff. If you have an interest in Python programming you'll love this extension to your own skills and knowledge. Although written for staff, pupils could easily follow the tutorial themselves. The knowledge acquired in this tutorial would allow you to deliver my PyGame student course: https://www.tes.com/teaching-resource/games-programming-using-pygame-project-1-balloon-burst-11303976 https://www.tes.com/teaching-resource/games-programming-using-pygame-project-2-tile-match-11303996 I love teaching with PyGame. Have fun!

A 14 mark database homework/revision question covering: Entity Relationship Diagrams Data Dictionaries Compound and Surrogate keys Use of Forms and Reports Note that two versions of the question have been uploaded. One contains a simple ERD (entities and relationship) and the other contains a more complex ERD (also including attributes) Written for the Scottish Higher course but valid for all intermediate level Database units. My students found this very useful. Question 4 of 6.

Written to provide appropriate written homework for classes involved in the practical activity of website design and implementation this 14 mark homework covers: Design: Consistency, Readability and Navigation Purpose of Javascript Use of Body and Image tags External Hyperlinks Domain Names Properties of png and gif Standard File Types Testing (links and layout) Worked very well in class as both a homework and revision task.

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 7 of 10 includes questions on: - Functions - Procedures - Parameter Passing - Reading Data From a Text File - Algorithm – Linear Search - 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.

A generic programming question for use with any programming language. Suitable as classwork or as a homework exercise to accompany a practical programming course. Students are given a scenario and required to write code on paper (using pseudocode or a programming language of their choice). The program requires use of: Functions Procedures Parameter Passing (value and reference) Writing Data to a Text File Algorithm – Count Occurences Required Variables and Arrays Two marking schemes give answers in: 1. Pseudocode 2. Python 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. This is homework 8 of 10. Questions 1 to 5 are now available as a bundle at half price.

Written to provide appropriate written homework for classes involved in the practical activity of website design and implementation this 10 mark homework covers: User-Interface: Visual Layout, Selection, Consistency Standard File Types: Video Javascript Mouse Event: Rollover Domain Names URL Title and Head Tags Worked very well in class as both a homework and revision task.

This is a short written task is designed to following an introductory few lesson on HTML. The 15 minute, 15 mark homework sheet has four pages which use basic HTML tags to encourage students to learn the skill of finding errors in code. Question 1 shows a html file containing 10 deliberate errors. Students have to identify the position of each error and write in a correction. Question 2 consists of five similar problems. Students are shown a web page in a browser, each of which are not displaying as intended. Students told how the web page should have looked and have to identify what error may have been made in the code that would cause each page to display as shown. Question 2 may be used to generate lots of good discussion as often there may be several possible answers. This could easily be used as class written work or for staff absence cover. The download includes the original HTML files created while writing the questions. These may be used for demonstration, discussion or as part of your HTML course.

This is a short written task is designed to following an introductory lesson on HTML. The 10 to 15 minute, 18 mark homework sheet has two pages which cover the basic structure and tags of an HTML file. Question 1 shows a html file with most of the elements names removed from the tags. Students have to correctly complete the start and end tags for head, title, body, h1 and p. Question 2 shows a web page in a browser along with the HTML file. Students have to identify eight pieces of code that have been removed from the file, writing in the missing code. This could easily be used as class written work or for staff absence cover.

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

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.

(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!

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

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

This unit was written for the Scottish, Computing - National 4/5 - Information Systems Design &; Development Unit. It covers what info systems are, their purpose, the data types they contain and an examination of user interface design. The unit is mainly theory work but has a variety of tasks built in. Send me a message with your e-mail address if you wish the files that accompany the unit. Please give feedback. G Reid

Created as an A5 booklet to sit next to pupils as they code in Python. In my teaching I constantly reinforce the importance of looking at examples of code when learning to program. Although this was created for the new Scottish National 4/5 courses the reference guide could be used by anyone learning to code using Python 3. Please leave feedback G Reid

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)