National 5 Computing Science course. A group to discuss, share and develop the new National 5 Computing Science course.
N5 Database Unit (1.2m)
The attached are updates to N5 Database Resources (Scottish Golfers) I wrote last year. I've been redrafting them to sell and of course post free for Scottish teachers.
Task 1 - Analysis & Design
Task 2 - Select, Where
Task 3 - Select, Where, Order By
Task 4 - Insert, Update, Delete
Task 5 - Evaluation
Over the last week I've spent a few evenings building a database of sample data (Access, csv files, txt files with SQL and the Excel files I used to build the data are included should you wish to add more data). I've since gone back through the tasks to ensure they could be used as implementation tasks with the sample database. They can, of course, still be used for their original purpose of homeworks/assessments.
A number of the questions in tasks 2, 3 & 4 required re-writing so they won't match the original copies from last year if you downloaded those.
I'll be working on doing the same with the Higher version of this (now at 7 tasks with one or two more ideas for others) over the next few weeks.
Nat 5 DDD exam style questions (1.9m)
Nat 5 DDD exam style questions
Nat 5 SDD exam style questions (1.1m)
Nat 5 SDD exam style questions
Nat 5 DDD exam style questions (1.1m)
Nat 5 DDD exam style questions
SDD and Systems exam style qs (5.7m)
SDD and Systems exam style qs
Nat 5 WDD exam style qs (92.4m)
Exam style qs for Nat 5 WDD
Nat 5 exam style qs videos (26.2m)
Practise eaxn qs
Kristen Davies (691.6k)
This is a class activity to introduce Structure Diagrams. I'm trying to make a bunch of real life examples to introduce topics before moving into computing specific examples. Hopefully this will make concepts easier to learn and more accessible for lower ability kids.
Kristen Davies (691.6k)
This is a class activity to introduce Structure Diagrams. I'm trying to make a bunch of real life examples to introduce topics before moving into computing specific examples. Hopefully this will make concepts easier to learn and more accessible for lower ability kids.
SQA N5 Study Guide (360k)
Database Task 5 - Evaluation (224.6k)
Just a few questions this time as its difficult to write lots for evaluation. Note that question 2 is unlikely to be seen in Nat 5 but I personally think that understanding that having lots of repeating data in a database is a bad thing. It's probably a bit of a cross-over question into Higher.
Database Task 4 - INSERT, UPDATE and DELETE (46.8k)
Another 10 questions to be used for homework and revision. There is also a question on the effect of referential integrity which students answer poorly in the exam.
Database Task 3 - SELECT with ORDER BY (93.6k)
More SELECT statements but with single and double sorts this time. The questions are switched slightly to show the output. Students have to work out the SQL that would produce the output shown.
Database Task 2 - SELECT, WHERE (one and two tables) (72.3k)
Another tutoring task covering SELECT statements with simple/multiple conditions and joins.
Could be used for homework or revision.
Database Task 1 - Analysis & Design Task (218.3k)
Another task created for tutoring. Could be used as homework or revision.
Students are asked to identify entities and attributes similar to an assignment task. These are then used to produce an ERD and Data Dictionaries.
Could be given as a single task or split into two as some may need answers from first page to complete the second.
National 5 Web Implementation/Testing Task (506.7k)
Another tutoring task. National 5 Web this time. Wireframe designs, the necessary graphics and text are all supplied for a four page website on Origami.
The task is to implement and then test the website (a couple of the hyperlinks are deliberately the same colour as the background btw).
This could be used as an assessment in the future if someone fancies writing marking instructions for it.
Generate MySQL statements from csv file (version 2) (2.3k)
Note - Updated the program as it was missing the last line of the csv file (silly mistake with loop!) and have added SQL comments with code for PK, FK, validations so it can be easily copied and pasted witin the text file.
This program analyses a csv file (exported from Access), determines field datatypes and generates a txt file with a single basic CREATE statement and an INSERT statement for each row of data.
The txt file can then be used as a starting point to create and populate a table in a MySQL database.
Please read the notes at the top of program.
WDD SDD Revision or Assessment (418.7k)
A couple of tests i used in the past. You might want to edit the last question in the web one as it is a bit big.
N5 - Wireframe to Page Structure and Style Practise Tasks (879.8k)
Another couple of task created for tutoring tonight. This one focuses on the problem solving required to take an anotated wireframe, identify the HTML elements and then write the CSS required to implment the annotations.
This could be adapted into coding tasks fairly easily by supplying the content of the pages.
Suitable for revision, assessment or homework.
I've included the wireframe graphics should you wish to use them in other tasks you create.
SQL Revision Questions (68.2k)
Create this as part of tutoring last night. 16 writing SQL questions based on the database used in the 2019 N5 assignment. Could be used as revision, class assessment or homework.
I also created a "cheat sheet" outlining the structure of SELECT, INSERT, UPDATE and DELETE statements to use as reference.
MIs are included in the last few pages (hurridly typed so apologies for any errors).