A group to discuss, share and develop the new Higher Computing Science course.
Higher Python File Handling using Dataclass (19.7k)
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.
Higher File Handing Tasks using Parallel Arrays (Python) (19.7k)
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.
Higher Python Standard Algorithms Task (117.3k)
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.
tree.py for Repl.it HTML projects (768b)
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.
Paul Gardner
Gym Database in MySQL (4.9k)
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).
Gym Database for HtP Book (88.6k)
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 (41.1m)
DDD from National Glow Site
DDD resources from National Glow Site (41.1m)
DDD resources from National Glow Site (41.1m)
James Young High School Web Design & Develoment Notes (110.2m)
Uploaded on behalf of Alex McNeice
WDD - Booklet 3 (Testing & Evaluation) (8.1m)
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.
beaches (7.6k)
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.
Encryption (3.2m)
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.
Old Higher Coursework Tasks - cut down (728.4k)
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.
practical-assessment-higher-software-design-and-development.zip (173.2k)
Hi guys, I have been working on an end of unit practical progress check for my higher class. I want to know how far along the road, in terms of skills, they are for software design. I have put together a full assessment based on the software task from the sample assignment and some extras from the arrangements added in. In have zipped it but what I am looking for is someone to vet or quality assure it. I am aware it will not be perfect (probably far from it) but I thought it might come in handy and others may appreciate it.
test1.txt (19.7k)
Hello,
I though people might be interested to see this response to the Choral Shield coursework task in JavaScript. You will need to rename the file from 'Choral Shield.txt' to 'Choral Shield.html' as CompEdNet would not allow an html file to be attached. I have also included one of the data files (these were easy to convert to JSON from CSV using a web service).
Rich
choral-shield.txt (3.5k)
Hello,
I though people might be interested to see this response to the Choral Shield coursework task in JavaScript. You will need to rename the file from 'Choral Shield.txt' to 'Choral Shield.html' as CompEdNet would not allow an html file to be attached. I have also included one of the data files (these were easy to convert to JSON from CSV using a web service).
Rich
Higher Python Cheat Sheet (265.5k)
A cheat sheet covering most of the concepts at Higher using Python. Feel free to use
Higher Python Cheat Sheet (265.5k)
A quick reference guide that should cover all of the concepts needed at higher. Feel free to use.
Coral Sheilds NEW higher coursework Practice (132.2k)
Using the old Coral Shields Unit assessment I have amended it to suit the new SDD coursework layout.