NCEA Level 2 Computer Science Information 201

CSI201
Course Description

Teacher in Charge: G. Hall

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

Pathway

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

Contributions and Equipment/Stationery

- Students need to contribute $10 towards access to a range of online coding courses on Codeavengers.
- 1E4 - 7mm Quad Book 28 pages, pen, pencil, eraser, ruler.
- A set of headphones (ear plugs).
- It is optional for students to make a contribution $5-10 for their CodeAvengers Python course, this can be paid at the school office early in Term 1.
- Have credit on their Papercut account for printing of some assessments.


Recommended Prior Learning

Two Achieved in the following Achievement Standards: 

Completion of Codeavengers ‘Python Level 1’.


Credit Information

This course is eligible for subject endorsement.

Assessment
Level
Internal or
External
Credits
L1 Literacy Credits UE Literacy Credits Numeracy Credits
A.S. 91890 v1 Digital Technologies and Hangarau Matihiko 2.1 - Conduct an inquiry to propose a digital technologies outcome
Assessments:
Term: , Week:
2
I
6
Y
A.S. 91892 v1 Digital Technologies and Hangarau Matihiko 2.3 - Use advanced techniques to develop a database
Assessments:
Term: , Week:
2
I
4
A.S. 91893 v1 Digital Technologies and Hangarau Matihiko 2.4 - Use advanced techniques to develop a digital media outcome
2
I
4
A.S. 91896 v1 Digital Technologies and Hangarau Matihiko 2.7 - Use advanced programming techniques to develop a computer program
Assessments:
Term: , Week:
2
I
6
A.S. 91897 v1 Digital Technologies and Hangarau Matihiko 2.8 - Use advanced processes to develop a digital technologies outcome
2
I
6
A.S. 91898 v1 Digital Technologies and Hangarau Matihiko 2.9 - Demonstrate understanding of a computer science concept
Assessments:
Term: , Week:
2
E
3
Y
Total Credits

Total Credits Available: 29 credits.
Externally Assessed Credits: 3 credits.
Internally Assessed Credits: 26 credits.

Pathway Tags

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