Documents List

  • National 5 Web Implementation/Testing Task (506.7k)  
    In category: Web Design.
    Uploaded by Greg Reid on 18/03/2021. 211 downloads since then.

    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)  
    In category: Assessment/Exam, Databases.
    Uploaded by Greg Reid on 30/07/2020. 260 downloads since then.

    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)  
    In category: Assessment/Exam, Software Design and Development, Web Design.
    Uploaded by Mr David Alford on 16/03/2020. 538 downloads since then.

    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)  
    In category: Assessment/Exam, Classroom, Homework, Web Design.
    Uploaded by Greg Reid on 28/02/2020. 270 downloads since then.

    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)  
    In category: Assessment/Exam, Classroom, Homework.
    Uploaded by Greg Reid on 21/02/2020. 483 downloads since then.

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

  • Old Coursework Tasks (918.8k)  
    In category: Software Design and Development.
    Uploaded by Sean Stratton on 13/11/2018. 178 downloads since then.

    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.

  • CS N5 V2.1 Check List (39.2k)  
    In category: resources.
    Uploaded by Sean Stratton on 27/09/2018. 289 downloads since then.

    I have changed the format a little to better fit in with Python, HTML and CSS

  • Computational Thinking and Design Notations (2.3m)  
    In category: resources, Software Design and Development.
    Uploaded by gordonrae on 04/07/2018. 572 downloads since then.

    Good morning,

    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!

    Gordon

  • Data Structures for Kids and Other Normal People (2.8m)  
    In category: Data Structures, Other, Programming.
    Uploaded by Alison Cowie on 28/06/2018. 273 downloads since then.
  • Updated for 2018/2019 National 4/5 Python Resource (DJack) (2.5m)  
    In category: Programming, resources.
    Uploaded by David Jack on 26/06/2018. 487 downloads since then.

    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 🙂

  • 2018 N5 Paper (5.2m)  
    Uploaded by Alasdair Sharp on 25/05/2018. 179 downloads since then.

    Scan of the 2018 National 5 Computing Science paper

  • amazon-4.zip (8.4m)  
    Uploaded by smcalpine on 22/05/2018. 118 downloads since then.
    Amazon Part 2/2 - Was asked to share this slightly random set of lessons I have been doing with S3. Not exactly National 5 but allows reflection on topics and the wider issues. Feel free to use and edit as you wish, just created to challenge a the stronger students. Looking at Amazon as a whole company and some of the AI/CDP/Automation they are doing. Our pupils enjoyed it and had lots of discussions around privacy and ethics.
  • amazon-1-3.zip (8.4m)  
    Uploaded by smcalpine on 22/05/2018. 129 downloads since then.
    Amazon Part 1/2 - Was asked to share this slightly random set of lessons I have been doing with S3. Not exactly National 5 but allows reflection on topics and the wider issues. Feel free to use and edit as you wish, just created to challenge a the stronger students. Looking at Amazon as a whole company and some of the AI/CDP/Automation they are doing. Our pupils enjoyed it and had lots of discussions around privacy and ethics.
  • SQL (0b)  
    In category: Databases.
    Uploaded by Frank Lagan on 30/04/2018. 69 downloads since then.

    This is SQL stuff for higher and nat 5 and has the requisite databases.

  • National 5 prelim paper 2018 (MS) (0b)  
    In category: Assessment/Exam, resources.
    Uploaded by James Brennan on 23/04/2018. 200 downloads since then.

    A marking scheme for the 2018 Prelim paper for the revised National 5 course.

  • National 5 prelim paper 2018 (0b)  
    In category: Assessment/Exam, resources.
    Uploaded by James Brennan on 23/04/2018. 232 downloads since then.

    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.

  • N5 - Revision Paper 2 (0b)  
    In category: Assessment/Exam, Databases, Homework, Programming, Web Design.
    Uploaded by Eoin Neil on 16/04/2018. 230 downloads since then.

    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:
    https://www.compednet.com/?get_group_doc=41/1515767610-N5_RevisionPaper1.zip

  • Homeworks N5 Databases (263.9k)  
    In category: Databases, Homework.
    Uploaded by Darren Brown on 21/01/2018. 516 downloads since then.

    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.

  • N5 Database exam questions (922.6k)  
    In category: Assessment/Exam, Databases, resources.
    Uploaded by James Brennan on 14/01/2018. 535 downloads since then.

    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.

  • N5 - Summary Course Notes (206k)  
    In category: Classroom, Other, Programming, Web Design.
    Uploaded by Eoin Neil on 14/01/2018. 667 downloads since then.

    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.