NCEA Level 3 Computer Science Information 301
Course Description
Teacher in Charge: Mr D. Foulds.
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) and Classes which allow the use of Objects to be utilized in the code.
- Builds on how database tables in a SQL database can be linked by a Many to Many relationship to output in a website and looks at 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.
Students can also take the option DIT301 as this course compliments CSI301.
University Entrance Approved 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
Term 3
DATABASE - MySQL
Complete an assessment, Assessment Standard 3.3_(91902)_Databases
INQUIRY
Practice for and complete an assessment, Assessment Standard 3.1_(91900)_Digital Technologies Inquiry
This scaffolds students learning towards 3.9_(91908)_Computer Science Concepts
Term 4
Sit the External Exam Assessment Standard 3.9_(91908)_Computer Science_Concepts
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 2025.
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.
Credit Information
You will be assessed in this course through all or a selection of the standards listed below.
This course is eligible for subject endorsement.
This course is approved for University Entrance.
External
NZQA Info
Digital Technologies and Hangarau Matihiko 3.1 - Conduct a critical inquiry to propose a digital technologies outcome
Assessments:
Term: 3, Week: 2
NZQA Info
Digital Technologies and Hangarau Matihiko 3.3 - Use complex techniques to develop a database
Assessments:
Term: 2, Week: 9
NZQA Info
Digital Technologies and Hangarau Matihiko 3.7 - Use complex programming techniques to develop a computer program
Assessments:
Term: 1, Week: 7
NZQA Info
Digital Technologies and Hangarau Matihiko 3.9 - Analyse an area of computer science
Assessments:
Term: 4, Week: 2
Pathway Tags
Animator/Digital Artist, Administration Officer, Finance Manager, Software Developer, Electronics Engineer, Information Technology Helpdesk/Support Technician, Information Technology Manager, Technical Writer, Systems Administrator, Information Technology Architect, Game Developer, User Experience Designer, Test Analyst, Network Administrator, Geospatial Specialist, Security Analyst, Data Analyst, Scrum Master,