A group to discuss, share and develop the new Higher Computing Science course.
SDD Question (5) - Data Flow Errors, Linear Search, Logic Errors, Efficiency (20.1k)
Question 5 in this series. This focuses mainly on reading design/code and finding errors. There are a few A marks in this one I think.
SDD Question (4) - Array of Records, Data Flow, Function Call, Modulus (337.2k)
The 4th in this series of re-purposed questions. Again no marking instructions so you'll have to make them up.
There's a mark for the last question that may be beyond higher (how do you deal with an odd number in the order and how does that affect the waste) but it's good to push your potential AH students.
SDD Question (4) - Array of Records, Data Flow, Function Call, Modulus (337.2k)
The 4th in this series of re-purposed questions. Again no marking instructions so you'll have to make them up.
There's a mark for the last question that may be beyond higher (how do you deal with an odd number in the order and how does that affect the waste) but it's good to push your potential AH students.
SDD Question (3) - Floating Point, Logic Error, Variables (28.5k)
Number 3 in this series. If anyone finds any errors let me know and I'll fix them.
Like the others, there's no marking instructions. I may do them sometime later.
SDD Question (2) - Usability, Write-to-File, Persona (183.4k)
Number two in this series of re-purposed Hodder questions.
SDD Question (1) - Variables, Trace Tables and Execution Error (19.2k)
About 10 years ago I wrote my first book, a set of three Higher papers, for the first version of CfE Higher.
As this book has been out of print for a while I'm re-purposing some of the question scenarios to create questions for tutoring.
No marking instructions btw, as just churning these out quickly. If anyone fancies writing any feel free to upload them.
Higher Database Questions (3.5m)
I started this last year and uploaded the first three tasks here. These were originally written as homework/assessment exercises but I've now created a sample database should you wish to use them for implementation.
There are now:
- 8 tasks covering Analysis, Design and Higher SQL (alias, wildcards, aggregate functions, group and two queries)
- marking instructions
- Datafiles (Access, csv and txt files with SQL)
- Excel files and two Python programs. One to create the Result and Membership tables and another to convert csv files to the text files (instructions on their use is included). These can be used to add more data should you wish.
Python Standard Algorithm Reference Files (13.3k)
I created these files for tutoring.
Using the 2022 assignment file (animal sightings) I've written examples of Reading from File, Find Max, Find Min, Linear Search and Count Occurrences.
There are six files in total:
Standard Algorithms as Procedures
Standard Algorithms as Functions
Standard Algorithms with some variations (returning an index rather than a value, writing to file etc)
The above three have both Parallel Array and Array of Record versions.
SQL Tasks - Double Query Questions (440.8k)
Additional SQL double query (or sub-query) questions (practical or theory, its up to you) based on the 2020 assignment "Car Services" database. Marking Instructions and the original Access file (with and without answers) are included.
SQL Tasks - Calculations and Wildcards (161.5k)
Additional questions (practical or theory, its up to you) based on the 2019 assignment "Flights" database. Marking Instructions and the original Access file (with and without answers) are included.
SQL Aggregate Tasks (WestFifeWalkers database 2022) (370.1k)
Created as another tutoring task, I've written some SQL tasks to accompany the 2022 assignment database, WestFifeWalkers.
This set of questions all require one of the aggregate functions (MIN, MAX, AVG, SUM & COUNT) to be used.
Higher Assignment Python Solutions (22k)
Finally got round to completing this. Solutions for every assignment from the specimen(2018) to 2022 using both parallel arrays and arrays of records (dataclass).
Note that 2020 does not have a dataclass equivalent because I felt the data flow of the task isn't easily converted to an array of records.
Refinement Tasks (297.5k)
Three refinement tasks that continue the scenarios in the previous data flow tasks. The refinements focus on the standard algorithms with the occasional twist to provide some A type marks.
Data Flow Questions (141.7k)
Two assessment/homework/class exercises covering data flow in the top level of an algorithm. This is a topic that historically isn't done as well as it could be in the assignment and exam paper.
Floating-point Representation Questions (138.9k)
A couple of homework/class test exercises for binary to floating-point conversion and back. Started tutoring again so other tasks for Higher may follow.
Higher exam style qs (21.1m)
Higher exam style qs
Higher SDD revision and PPTs for booklet (30.1m)
I couldn't find ppts fopr the Higher SDD booklet so I made some and have a past paper ppt based on SDD
SDD Exam Style Questions all based around implementing Standard Algorithm VB code (45.5k)
Same tasks as posted by Greig earlier with some more corrections to the MI, and exemplar code in Visual Basic!
Higher programming practice (2.1m)
Hi guys,
I've created this resource based off of one of the recent SDD coursework assignments. Feel free to modify it or make suggestions on it.
Cheers
Stuart
Software Exam Style Questions all based around writing Standard Algorithm code (103k)
Software questions based around writing code questions. I've included the Python file that I wrote to produce the screenshots in the marking instructions. The code starts by generating data for the four arrays in the questions. For other languages you'd have to write code to replace the Python in the MIs. The questions can be used with any language. The questions could easily be reworded to become design questions.