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
Zipped file containing:
Booklet 3 - Testing and Evaluation
Booklet 3B - Collated Analysis and Designs for the Student Cooking Website for use during testing and evaluation.
Teacher Notes - Notes on errors that were introduced into the testing version of the Student Cooking website (it's a kind of marking scheme for the tasks)
Testing Template - A printable testing template file
Testing Version of the Completed Student Cooking Website with errors introduced to give testers something to find.
I have written a solution to the beaches program (using Python 3.6) as specified in the SDD specimen coursework task. I have added a count for the number of beaches in any category although it is not asked for. I have rounded the average to 1 decimal place, although it doesn't ask for this. I have not included input validation because it is not asked for. I have used the 'split' feature to select only that part of a string up to the first space in the name of beach. The zipped file includes my own code and the csv file that has be read in. I have tried to follow the specified algorithm as closely as possible. I have not included internal documentation as it's not my strong point! I hope this is useful.
This is a PowerPoint I made to help the class (and me) understand a bit more clearly about the ideas behind public and private keys, signatures and certificates.
I have removed all the marking and gubbins that went with these and just left the task on it's own. I plan to use them with supported study and as practice tasks. I haven't worked through them all in the context of the new higher but I think it's a worthwhile resource.
A cheat sheet covering most of the concepts at Higher using Python. Feel free to use
A quick reference guide that should cover all of the concepts needed at higher. Feel free to use.
Using the old Coral Shields Unit assessment I have amended it to suit the new SDD coursework layout.