Tawa College Tawa College

NCEA Level 3 Computer Science Information 301

CSI301
Course Description

Teacher in Charge: Mr D. Foulds.

Recommended Prior Learning

This course is open entry to new students, however it is an academic course and students should preferably have studied CSI201. 

Students who have not had prior experience are expected to discuss their suitability for the course with the HOD (Head of Department) Mr Foulds and show commitment to completing online programming courses in preparation for February 2026.




Computer Science and Information 301

This academic course builds on the CSI201 course; 

It continues to extend both Programming and Database skills and the understanding of complex concepts in Computer Science.

This year the course:

  • Extends the programming language Python by exploring Graphic User Interfaces (GUI), grid and coordinates for app layout, writing to a file for end user login and importing an external text file into the program for reading and using list.
  • Builds on how database tables in a SQL database can be linked by a Many to Many relationship to output in a website. Learn how data in a database can be added, updated and removed via forms in the website all using PHP code, HTML and CSS.
  • Further exploration of complex concepts in Computer Science.
  • Students will also learn about Computer Graphics or Big Data which are the main topics for their end of year External Exam.
  • The Two major Assessments will be:
    • Programming a Math App for Y9 students.
    • Coding a Music Database with Admin vs Non-Admin Login rights.

Students can also take the option DIT301 as this course compliments CSI301.

Assessment                                                                                                                                  

Gain up to 17 Achievement standard credits at Level 3. This will help students towards the 60 credits needed to pass their NCEA Level 3.

University Entrance Approved Subject. 

IMPORTANT NOTE: CSI301 and DIT301 are counted as 1 approved University Subject. You can do both courses and get the full number of credits on each course for your Level 3 NCEA. Yet University Entrance recognizes Digital Technologies as 1 subject.



Course Overview

Term 1
PROGRAMMING - PYTHON
Practice for and complete an assessment, Assessment Standard 3.7_(91906)_Program

Term 2
PROGRAMMING - PYTHON
Practice for and complete an assessment, Assessment Standard 3.7_(91906)_Program.

DATABASE - MySQL
Practice for and start an assessment, Assessment Standard 3.3_(91902)_Databases.
Start an assessment, Assessment Standard 3.4_(91903)_Practical with Database.

Term 3
DATABASE - MySQL
Complete an assessment, Assessment Standard 3.3_(91902)_Databases.
Complete an assessment, Assessment Standard 3.4_(91903)_Practical with Database.

DGA Derived Grade Exam for External: 3.9_(91908)_Computer Science Concepts.

Term 4
DATABASE - MySQL
Complete an assessment, Assessment Standard 3.3_(91902)_Databases.
Complete an assessment, Assessment Standard 3.4_(91903)_Practical with Database.
Sit the External Exam Assessment Standard 3.9_(91908)_Computer Science Concepts.

Learning Areas:

Digital Technologies




			
					
					Contributions and Equipment/Stationery
										

A4 Exercise Book 8mm ruled lines. For learning the Computer Languages.
A set of headphones (ear plugs).
Have credit on their Papercut account for printing of some assessments.