Higher exam style qs
I couldn't find ppts fopr the Higher SDD booklet so I made some and have a past paper ppt based on SDD
Same tasks as posted by Greig earlier with some more corrections to the MI, and exemplar code in Visual Basic!
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.
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.
Six more questions this time using alias, wildcards and calculations. Note that you'll need the data sheet from task 2 to complete this.
SELECT with multiple tables
This task revisits N5 output but with the complexity of more tables (and joins).
As there is a large amount of sample table data I've separated this out into a single sheet that should be used for tasks 2 to 6.
Note that dates on the sample data are in SQL format. These should be changed if you use MS Access or similar.
Students are told of further analysis of the problem and flaws with the original design (from the N5 tasks). They are required to draw a new ERD to correct the flaws.
This is quite an involved task. If anyone spots a flaw in the marking instructions and solutions I'd appreciate if you let me know.
The attached zip file contains the database for the Higher specimen courswork task in SQLite format and all the .SQL commands and CSVs to recreate it, if necessary.
Tutoring Task 3 - This is a bit a repeat of number 2 but using dataclass to simulate an array of records as required by the Higher course. The zipped file includes an example of dataclass and the task files. The titanic file has been fixed if you wish to use it in Tutoring Task 2.
Tutoring task number 2 - Three tasks (with lots of sub standard algorithm tasks) around file handling using parallel arrays (lists).
Some of the sub-tasks are straight forward standard algorithm tasks, some are more complex twists on the standard algorithms that would usually end up being A marks in the assignment.
I've started tutoring again. Doing some Python with the son of a previous colleague of my wife's. As such I'll probably produce a few daft wee tasks. This one reads in details about powerplants into four parallel arrays. The task is to use the four parallel arrays (lists), used to store the file data, to produce a variety of output.
Details are in the Python file as comments.
Rename this file to tree.py and import it into a Repl.it HTML project. It will let you create a clickable list of all the files in the current project. It backs up the existing index.html (to index.safe) and creates a new one. Run the repl again or open it in a new tab to see the effect.
Run the program from the shell tab with 'python tree.py'.
Use with care, but if you do accidentally delete the original index.html you can recover it from the 'repl history'.
This is a work in progress so let me know if it helps and any suggestions for improvement.
Greg Reid's recently upload Gym Classes database converted from Access to a couple of MySQL .sql files. One file creates and populates the database tables. The other has all the sample queries converted to MySQL format. The database conversion was mainly done using "MS Access to MySQL" from http://www.bullzip.com with the Foreign Key relationships added by hand. Access SQL queries to MySQL mainly copied and pasted with a bit of editing (wildcards, dates, times and aliases handled differently).
This is the Gym database that I created when writing the database chapters of the HtP book for Hodder.
A word of caution:
- The data set is limited as I added just enough to test everything works.
- The saved queries are the ones from the book and some others I was experimenting with but they are not numbered to match the book.
- I'm not sure I added any validation as this was initially just for me to test with.
If anyone fancies populating the tables with more data (particularly classes and attendance) I would be delighted. Please post it back here if you do.
DDD from National Glow Site
Uploaded on behalf of Alex McNeice