CSI301

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 which is the main topic 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
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

Students need to have studied CSI201 

Two Achieved in the following Achievement Standards: 

  • 2.7_(91896)_Program
  • 2.1_(91890)_Inquiry into a proposed digital technologies outcome
  • 2.3_(91892)_Databases
  • 2.9_(91898)_Computer Science Concepts



Contributions and Equipment/Stationery

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.

Total Credits Available: 19 credits.
Externally Assessed Credits: 3 credits.
Internally Assessed Credits: 16 credits.

Assessment
Description
Level
Internal or
External
Credits
L1 Literacy Credits
UE Literacy Credits
Numeracy Credits
A.S. 91900 v1
NZQA Info
Digital Technologies and Hangarau Matihiko 3.1 - Conduct a critical inquiry to propose a digital technologies outcome
6
6
6
6
6
6
Level: 3
Internal or External: Internal
Credits: 6
Level 1 Literacy Credits: 0
University Entrance Literacy Credits: 0
Numeracy Credits: 0

Assessments:
Term: 3, Week: 2

A.S. 91902 v1
NZQA Info
Digital Technologies and Hangarau Matihiko 3.3 - Use complex techniques to develop a database
4
4
4
4
Level: 3
Internal or External: Internal
Credits: 4
Level 1 Literacy Credits: 0
University Entrance Literacy Credits: 0
Numeracy Credits: 0

Assessments:
Term: 2, Week: 9

A.S. 91906 v1
NZQA Info
Digital Technologies and Hangarau Matihiko 3.7 - Use complex programming techniques to develop a computer program
6
6
6
Level: 3
Internal or External: Internal
Credits: 6
Level 1 Literacy Credits: 0
University Entrance Literacy Credits: 0
Numeracy Credits: 0

Assessments:
Term: 1, Week: 7

A.S. 91908 v1
NZQA Info
Digital Technologies and Hangarau Matihiko 3.9 - Analyse an area of computer science
3
3
3
Level: 3
Internal or External: External
Credits: 3
Level 1 Literacy Credits: 0
University Entrance Literacy Credits: 3w
Numeracy Credits: 0

Assessments:
Term: 4, Week: 2

Credit Summary
Total Credits: 19
Total Level 1 Literacy Credits: 0
Total University Entrance Literacy Credits: 3
Total Numeracy Credits: 0