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.
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.
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.
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.
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).
This is a just the tasks from the old Int2 course and also the previous N5 tasks. I have not worked through them all yet as I am planning to use this with supported study sections.
I have changed the format a little to better fit in with Python, HTML and CSS
I've attached a booklet we have produced and used this year at the start of our N5 course, in the hope it may be useful to some.
The booklet comes in 3 sections:
1. A set of computational thinking puzzles. We got the pupils to try these in groups - really got them thinking.
2. Lots (and lots) of exercises on Structure Diagrams and Flowcharts going through sequences, then selection, then repetition. Finally, some Pseudocode! This section also introduces the concept of dry runs, so that thinking can be visibly demonstrated.
3. User interface design - focusing on wireframing and Low-fidelity prototypes.
There is also an answer book (with explanations).
We are considering introducing this to our S3 course, so that pupils come into N5 with some of these ways of thinking already embedded./
Hope it proves useful to someone
Happy holidays when they get here!
An update of a previously uploaded resource to tie in with the new arrangements.
Fully open to feedback in order to continually approve.
If you plan to use this resource, please keep my name on it 🙂
Scan of the 2018 National 5 Computing Science paper
This is SQL stuff for higher and nat 5 and has the requisite databases.
A marking scheme for the 2018 Prelim paper for the revised National 5 course.
A 2018 Prelim paper for the revised National 5 course. Contains a collection of questions adapted from previous past papers as well as the SQA specimen paper. Marking scheme will also be uploaded.
A 2nd Revision Paper for the revised National 5.
Based on questions from various courses. By my calculations covers most of the course.
Enclosed in the Zip
- Question Paper - not write on
- Marking Scheme
Revision Paper 1 - Available here:
A few homework sheets/revision questions for Database Design and Development. I'd also like to thank colleagues in Highland as well as folks across the country for all the materials shared on here/Glow page to help me pull together an N5 course and teach myself how to do a lot of it.
Database questions taken from exam and specimen papers that are suitable for the new National 5 course. Questions have been sourced in accordance to the SQA list of recommended questions that suit the new course.
The order of questions hasn't been sorted correctly and anything prior to the 2015 paper isn't included. Please let me know of any issues and feel free to modify and adapt as you see fit.
I have taken the SQA Specification, and added notes to it.
Notes aren't very detailed.
My class will be instructed that if they look at the summary notes and it doesn't make sense then they need to review in more detail.
If you spot any mistakes let me know.