CSI201

NCEA Level 2 Computer Science Information 201

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

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: 

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

Completion of Codeavengers ‘Python Level 1’.

Pathway

Credit Information

This course is eligible for subject endorsement.

Total Credits Available: 29 credits.
Externally Assessed Credits: 3 credits.
Internally Assessed Credits: 26 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: 2, Week: 1

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. 91893 v1
NZQA Info
Digital Technologies and Hangarau Matihiko 2.4 - Use advanced techniques to develop a digital media outcome

Further assessment opportunities will not be offered for this standard inline with NZQA guidelines

4
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
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. 91897 v1
NZQA Info
Digital Technologies and Hangarau Matihiko 2.8 - Use advanced processes to develop a digital technologies outcome

Further assessment opportunities will not be offered for this standard inline with NZQA guidelines

6
6
6
6
6
6
Level: 2
Internal or External: Internal
Credits: 6
Level 1 Literacy Credits: 0
University Entrance Literacy Credits: 0
Numeracy Credits: 0
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: 29
Total Level 1 Literacy Credits: 9
Total University Entrance Literacy Credits: 0
TotalNumeracy Credits: 0

SchoolPoint by Inbox Design SCHOOLPOINT129, Rendered 1.22MB in 0.0903 seconds with 14 queries.