CSI201

NCEA Level 2 Computer Science Information 201

Course Description

Teacher in Charge: Mr G. Hall

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 advanced 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 and some students may start to learn and use Graphic User Interfaces (GUIs).
  • Introduces how database tables in a SQL database can be linked and how data in the database can be output in a simple website using PHP language, HTML and CSS. 
  • Further exploration of advanced concepts in Computer Science.


Students can also take the option DIT201 as this course compliments CSI101.


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

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

Recommended Prior Learning

This course is open entry to students however it is an academic course and students should preferably have studied in 11CSI and passed the following criteria. Students who have not should contact Mr Hall the TIC or Mr Foulds HOD who will advise of some online courses to complete.

Two Achieved in the following Achievement Standards: 

  • 1.3_(91879)_Databases
  • 1.7_(91883)_Programming 
  • 1.9_(91885)_Searching and Sort
  • 1.11_(91887)_Data Compression

Contributions and Equipment/Stationery

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

Pathway

Credit Information

This course is eligible for subject endorsement.

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. 91890 v1
NZQA Info
Digital Technologies and Hangarau Matihiko 2.1 - Conduct an inquiry to propose a digital technologies outcome
6
6
6
6
6
6
Level: 2
Internal or External: Internal
Credits: 6
Level 1 Literacy Credits: Y
University Entrance Literacy Credits: 0
Numeracy Credits: 0

Assessments:
Term: 3, Week: 8

A.S. 91892 v1
NZQA Info
Digital Technologies and Hangarau Matihiko 2.3 - Use advanced techniques to develop a database
4
4
4
4
Level: 2
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. 91896 v1
NZQA Info
Digital Technologies and Hangarau Matihiko 2.7 - Use advanced programming techniques to develop a computer program
6
6
6
Level: 2
Internal or External: Internal
Credits: 6
Level 1 Literacy Credits: 0
University Entrance Literacy Credits: 0
Numeracy Credits: 0

Assessments:
Term: 1, Week: 10

A.S. 91898 v1
NZQA Info
Digital Technologies and Hangarau Matihiko 2.9 - Demonstrate understanding of a computer science concept
3
3
3
Level: 2
Internal or External: External
Credits: 3
Level 1 Literacy Credits: Y
University Entrance Literacy Credits: 0
Numeracy Credits: 0

Assessments:
Term: 4, Week: 2

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