St John’s College (Hillcrest) St John’s College (Hillcrest)

Level 3 Digital Technologies

13DIG
Course Description

Teacher in Charge: Ms H. Chileshe.

Recommended Prior Learning

Level 2 Digital Technology or discretion of Teacher in Charge.


Year 13 Digital Technology


In Year 13, the emphasis in digital technology is on programming. Through programming, students will enhance their problem-solving skills, project management abilities, critical thinking, and interpersonal skills—all key competencies required by the New Zealand curriculum. Additionally, some students may have the opportunity to undertake COMP 101, a first-year paper from Waikato University.

Students will be working with text-based programming languages such as Python and JavaScript. They will develop a working prototype, using project management tools to ensure the project is delivered on time and meets its intended purpose. Students will create a program to solve a given problem, and a comprehensive portfolio of their work will be developed during Terms 2 and 3.

Databases

Using MySQL or SQLite, students will create a relational database that can be accessed through a website using PHP. This will help them understand the practical applications of databases and how they interact with web technologies.

Integrated Project

Students have the option to undertake a large practical project that incorporates programming, databases, and web development using Python, Flask, and SQL. This project will be created and completed by the end of Term 3. Alternatively, students can choose to undertake three standalone assessments, focusing individually on programming, databases, and web development.

Creative choices

Students that prefer the creative side of Digital Technology can do a project based on the software of their choice. Previously this has included animation, 3D modelling, video production and magazine design. This is undertaken in an independent fashion and is best suited to those who are well-organised and have the motivation to do a lot of individual learning.

External Exam

For the external exam, students will delve into a specific area of computer science, which will be determined by NZQA later in the year. This exam will test their understanding and application of advanced computer science concepts.


By the end of the year, students will have a solid foundation in programming, database management, and web development, preparing them for further studies or a career in digital technologies.


Course Overview

Term 1
Student prepare for the project management and programming assessment learning how a graphical user interface is constructed using python TKinter. When ready students undertake a programming task using project management tools to ensure that the outcome is developed on time and is fit for purpose. Students will build, debug and test their program throughout the project.
Those using Flask and Python to create a website will begin learning how the different software interfaces interact and work together. By the end of term one they will have completed a practice website with Flask, Python and HTML/CSS.

Term 2
See the completion of the main programming assessment and the practice website.
Students will start looking at relational databases. Web students will integrate SQLite into their Flask projects.
Other students will undertake a separate Database assessment.

Term 3
Students complete their final project whether it is the database, Flask website or other media choices.
They will begin preparing for the external which is held in Week two of Term four.

Term 4
Level 3 digital technology external exam on computer science.

Faculties:

Technology


Career Pathways

Software Developer, Electronics Engineer, Information Technology Helpdesk/Support Technician, Information Technology Architect, Game Developer, Recreation Co-ordinator, User Experience Designer, Network Administrator, Geospatial Specialist, Penetration Tester, Scrum Master



			
					
					Contributions and Equipment/Stationery
										

$10 Software Licences