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

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 5 of 10 includes questions on: - Input - Output - Conditional (if) Statement - Conditional Loop - Fixed Loop - Arrays - Len (length) Function Four additional theory questions cover Test Data, Reasons for Variable Use and Logic Problems with the Design. Two marking schemes give answers in: 1. Pseudocode and Python 2. Pseudocode and Visual Basic 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. https://www.tes.com/teaching-resource/practise-programming-questions-1-to-5-bundle-11543151

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

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

Please note this download is only useable if you already have a copy of Serif WebPlus. The application has been discontinued. In this practical unit pupils create a website on the London 2012 Olympics while learning how to use Serif’s excellent WebPlus X5 software. This is intended as an introductory unit to web design and creation. All the text and graphics are supplied to the pupils. Following this unit, my pupils work in groups of four to design and implement a website for a client. The files are saved in a Dropbox folder. Send me your e-mail if you wish to use the files. Please leave feedback.

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 4 of 10 includes questions on: - Input - Output - Calculation (power ^, Int Function) - Fixed Loop - Arrays Two additional theory questions cover Data Types and Order of Code. Two marking schemes give answers in: 1. Pseudocode and Python 2. Pseudocode and Visual Basic 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. https://www.tes.com/teaching-resource/practise-programming-questions-1-to-5-bundle-11543151

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 3 of 10 includes questions on: - Input - Output - Calculation (power ^, Int Function) - Conditional (If) Statement - Conditional Loop One additional theory question covers Test Data (normal, extreme and exceptional). Two marking schemes give answers in: 1. Pseudocode and Python 2. Pseudocode and Visual Basic 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. https://www.tes.com/teaching-resource/practise-programming-questions-1-to-5-bundle-11543151

A colourful, helpful information document for anyone learning how to use Microsoft Word. Each page contains detailed instructions and lots of screenshots showing how to create and modify bullet point lists in Word. The document has two uses as page 1 could also be printed on its own as an A3 poster for IT rooms. Content Page 1 When to use bullet points How to use bullet points Page 2 How to position bullet points How to start a new line within a single bullet point Page 3 How to change the space between bullet points Page 4 How to change the shape of the bullets How to create your own bullets by uploading a picture A GReat resource for young learners.

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.

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.

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 27,000 times, these 7 extension sheets continue the basic game created in "Creating a Fun 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."

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

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 years ago 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 The unit will last for between 20 and 30 hours. 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/.)

Many students these days wish to games programmers. Pygame is a fabulous addition to the programming language Python 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/us/teacher-lessons/games-programming-using-pygame-project-1-balloon-burst-11310169 https://www.tes.com/us/teacher-lessons/games-programming-using-pygame-project-2-tile-match-11310173 I love teaching with PyGame. Have fun!

A colorful, helpful information document for anyone learning how to use Microsoft Word. Each page contains detailed instructions and lots of screenshots showing how to create and modify bullet point lists in Word. The document has two uses as page 1 could also be printed on its own as an A3 poster for IT rooms. Content Page 1 When to use bullet points How to use bullet points Page 2 How to position bullet points How to start a new line within a single bullet point Page 3 How to change the space between bullet points Page 4 How to change the shape of the bullets How to create your own bullets by uploading a picture A GReat resource for young learners.

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!