Course Length: Approximately 8 weeks.

AS92005- Develop a digital technologies outcome. 

This course can be completed as a standalone course but it is HIGHLY RECOMMENDED that students have completed the Python Unit and passed the assessment first. The suggested learning is by no means comprehensive and you should feel free to replace or add additional resources as part of your teaching and learning program.

Software requirements:

Visual Studio Code: https://code.visualstudio.com/

Python: https://www.python.org/downloads/ 

Git: https://git-scm.com/downloads 

SQlite Studio:  https://sqlitestudio.pl/ 

Suggested Timetable: 

2 weeks to gain foundational knowledge of SQL and Database Design in the "Understand" section. It's best you set checkpoints of learning for each of the sections to help keep your students on track. You could ask them to submit screenshots of their progress or their test scores. All sections have OPTIONS! So either let the kids choose or choose for them but you do not need to expect them to do them all (unless they are superhuman)

2 weeks on the Apply completing the scaffolded project. This includes completeing Task#4, Task#5 and Task#6. By then they should have made a very basic SQL/Python program with the help of the videos and you and the internet. This is the minimum they should have completed before attempting the Assesment Episode.

4 weeks to complete the "Do" assessment with minimal help from you, the teacher.

Special Note for Extension Kids:

The extension exercise for this is to use HTML/CSS as the front end for a basic database using the Flask Framework. If you have a superstar, point them at the bottom of the page after they can demonstrate an understanding of SQL and see if the can turn their basic Python Application into a Web Application.