NCEA Level 2 Computer Science Information 201

CSI201
Course Description

Teacher in Charge: Mr G. Hall

Recommended Prior Learning

Two Achieved in the following Achievement Standards: 

CSI201 - Computer Science and Information 201

This academic course builds on the CSI101 course; 

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

This year the course:

  • Extends the programming language Python by extending on the modular programming to include parameters and indexed structures.
  • Introduces how database tables in a SQL database can be linked to output in a simple website using PHP language, HTML and CSS. 
  • Further exploration of concepts in Computer Science.

OPTIONAL

The following two Assessment Standards can be taken as an option by students who are not sitting DIT201.

  • 2.4_(91903) Use advanced techniques to develop a digital media outcome
  • 2.8_(91907) Use advanced processes to develop a digital technologies outcome

Students can also take the option DIT201 as this course does compliment DIT.


Course Overview

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

Term 2
DATABASE _ MySQL
Practice for and start an assessment, Assessment Standard 2.3_(91892)_Databases

Term 3
DATABASE _ MySQL
Complete an assessment, Assessment Standard 2.3_(91892)_Databases

OPTIONS (Only for students who are not taking DIT201):
- Complete an assessment, Assessment Standard 2.4_(91893)_Web
- Complete an assessment, Assessment Standard 2.8_(91897)_Develop a digital technologies outcome

INQUIRY
Practice for and complete an assessment, Assessment Standard 2.1_(91890)_Inquiry into a proposed digital technologies outcome
This scaffolds students learning towards 2.9_(91898)_Computer Science Concepts

Term 4
CONCEPTS OF COMPUTER SCIENCE
Practice for the external assessment, Assessment Standard 2.9_(91898)_Computer Science_Concepts
Sit the external assessment, Assessment Standard 2.9_(91898)_Computer Science_Concepts

Learning Areas:

Digital Information Technologies


Assessment Policy & Procedures
Pathway

NCEA Level 3 Computer Science Information 301, NCEA Level 3 Design Information Technology 301

Career Pathways

Office Manager, Test Analyst, Network Administrator, Geospatial Specialist, Security Analyst, Industrial Designer, Information Technology Helpdesk/Support Technician, Information Technology Manager, Systems Administrator, Survey Technician, Software Developer, Electronics Engineer, Game Developer

Contributions and Equipment/Stationery

A set of headphones (ear plugs).
Have credit on their Papercut account for printing of some assessments.

Pathway Tags

CSI301 - NCEA Level 3 Computer Science Information 301 and/or 13DIT - NCEA Level 3 Digital Information Technologies 301, Game Developer, Geospatial Specialist