Welcome to the fictional town of Sandyhaig where the residents are desperately seeking to hire a data scientist to help with their Campaign for Better Buses. Students will take on the role of a data scientist learning: about Sandyhaig town along with the current bus routes and the data obtained on buses and passengers how to find the data they need for the campaign how to present the data in a meaningful easily understood way. To deliver this unit of work the following student files are included in the download: A 30 page, student booklet including tasks, examples and final projects of varying difficulty An appendix booklet with 10 appendices that cover skills like filtering, creating charts and creating a dashboard A large map of Sandyhaig town In addition, the following have been supplied for teaching staff: Advice on delivering the unit Answers to the tasks Advice on how each project can be completed Files used to create the appendices including the completed Excel files and dashboards This unit has been trialled in several schools with excellent feedback. Have fun.

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

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

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

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.

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.

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.

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

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.

An 11 mark database homework/revision question covering: Field Types Input Validation (including Restricted Choice) Primary and Foreign keys Modification Errors Sorting on Two Fields Written for the Scottish National 5 course but valid for all introductory Database units. My students found this very useful. Question 3 of 6.

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