An Introduction to Database Design & Creation

An Introduction to Database Design & Creation

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)
snegreid
54 Generic Programming Challenges

54 Generic Programming Challenges

This booklet was written for my Scottish National 4/5 course but could be easily be used with any beginners programming course. The problems were deliberately designed to be achievable in any programming language. The booklet provides 54 increasingly difficult programming problems categorised into: - Input/Output - Selection (IF) - Iteration (Unconditional loops) - Iteration (Conditional loops) - Arrays - Functions Please leave feedback.
snegreid
Designing and Creating Websites using WebPlus X5

Designing and Creating Websites using WebPlus X5

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.
snegreid
Web Coding Problem Solving Homework 1

Web Coding Problem Solving Homework 1

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.
snegreid
Web Coding Problem Solving Homework 2

Web Coding Problem Solving Homework 2

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.
snegreid
Creating Fun Apps with MIT App Inventor 2

Creating Fun Apps with MIT App Inventor 2

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/.)
snegreid
Scratch Homeworks

Scratch Homeworks

A collection of 6 Scratch homeworks written to improve problem solving skills and understanding of Scratch program code.
snegreid
Scratch Programming - Computational Thinking Homework 6

Scratch Programming - Computational Thinking Homework 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!
snegreid
Scratch Programming - Computational Thinking Homework 4

Scratch Programming - Computational Thinking Homework 4

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.
snegreid
Scratch Programming - Computational Thinking Homework 5

Scratch Programming - Computational Thinking Homework 5

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!
snegreid
Networks, Security, Legality and the Environment

Networks, Security, Legality and the Environment

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
snegreid
Web Development Homework/Assessment Question 1

Web Development Homework/Assessment Question 1

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.
snegreid
Web Development Homework/Assessment Question 2

Web Development Homework/Assessment Question 2

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.
snegreid
Programming Practise Questions (Homework 8)

Programming Practise Questions (Homework 8)

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.
snegreid
Database Revision/Homework Question 1

Database Revision/Homework Question 1

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.
snegreid
Programming Homework/Assessment Practise Questions (Set 6)

Programming Homework/Assessment Practise Questions (Set 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.
snegreid
Database Revision/Homework Question 5

Database Revision/Homework Question 5

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.
snegreid
Programming Homework/Assessment Practise Questions (Set 7)

Programming Homework/Assessment Practise Questions (Set 7)

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