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.

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

This unit was written to provide homework, class assessments or additional tasks to complement your own database teaching. The theme of the two table database provided is Scottish golf club members and their competition results. There are five task sheets included as MS Word files: Task 1 – Analysis & Design – students must identify the information to be stored and then construct an entity relationship diagram and a data dictionary. Task 2 – SQL - 8 questions of varying difficulty based on SELECT, FROM, WHERE and AND Task 3 – SQL - a further 8 questions continuing from task 2 but adding ORDER BY Task 4 – SQL - 10 more SQL questions that require INSERT, DELETE and UPDATE Task 5 – Evaluation - compare the Scottish Golfers database against a set of requirements 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: An Access file (two versions, a student version and one with the completed task 2 and 3 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

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

There are several skills required to be a good programmer. One of these is being able to debug programs by identifying errors in code. In this Scratch homework students are given a description of a short animation and are required to find the errors in the code. The homework starts with a worked example. There are three questions making this homework about a 10-15 minute task. Students love this style of problem solving homework. Have fun!

A 25 mark database homework/revision question covering: Field Types Input Validation Primary and Foreign keys Reasons for Using Relational Database Searching Sorting Written for the Scottish National 5 course but valid for all introductory Database units. My students found this very useful. Question 1 of 6.

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!

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

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.

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 2 includes an explanation of the uses of INSERT, UPDATE and 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 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 18 page booklet is the third of three written to cover the process of creating a website from analysis to coding to evaluation. Booklet 3 takes students through how to comprehensively test a website for: Usability Navigation Media Forms A specially created “testing” version of the completed student cooking website is supplied for the tasks. This website has deliberately introduced errors which students are challenged to find in the tasks. Teacher notes are included listing the errors that were introduced. Booklet 3 also discusses how to evaluate a website by comparing the finished product to the original analysis. The tasks in Booklet 3 should take around 6 hours to complete. An accompanying booklet 3B contains collated analysis and designs for the Student Cooking website created in booklet 2B. This may be used as a reference when designing testing strategies.

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.

There are several skills required to be a good programmer. One of these is being able to identify the order of code. In this Scratch homework students are given a description of a short animation and the blocks required to build it, Their task is identify the correct order of the blocks. The homework starts with a worked example. There are three questions making this homework about a 10-15 minute task. Students love this style of problem solving homework.

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

Students are provided a scenario with four parallel arrays where each array stores the air pressure of a car tyre (front left, back right etc). Each question asks students to write code to solve a stated problem. Answers require that students write: find maximum - code that finds the largest value in an array find minimum - code that finds the smallest value in an array linear search - code that traverses an array looking for values count occurrence - code that count the number of times values are found in an array. The questions get progressively harder. Although many programming languages contain functions to carry out some or all of the above, knowing how to code these algorithms aids code understanding and gives students the ability to write alternative versions of each algorithm. Marking Instructions and a completed Python program with the solutions are supplied. The questions are suitable for any programming language your students may be familiar with. The marking instructions could be adapted for solutions in different languages. These could also be turned into practical tasks by providing a partial program that sets up the data in the arrays.

These sheets are part of a Curriculum for Excellence course for S1 pupils. The format of these sheets was an attempt to get away from workbooks where pupils work from step 1 through to step 50 without thinking. Pupil are taught skills and encouraged to try things (in other words problem solve). An assessment at the end requires pupils to demonstrate that they understand where to use each Word facility appropriately. This style of teaching takes a bit of getting used to and is definitely harder work. The benefits outweigh this though. Good luck! Greg