NCEA Level 3 Computer Science Information 301

CSI301
Course Description

Teacher in Charge: G. Hall

CSI301 - 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 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 concepts in Computer Science.

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

OPTIONAL

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

  • 3.4_(91903)_Web
  • 3.8_(91907)_Develop included in both courses.

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

OPTIONS (Only for students who are not taking 13DIT):
- Complete an assessment, Assessment Standard 3.4_(91903)_Web
- Complete an assessment, Assessment Standard 3.8_(91907)_Develop a digital technologies outcome Oct 2018

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 assessment, Assessment Standard 3.9_(91908)_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.
Students can also take the option DIT201


Recommended Prior Learning

Students need to have studied CSI201 

Two Achieved in the following Achievement Standards: 

Completed Codeavengers ‘Python Level 2



Credit Information

This course is eligible for subject endorsement.

This course is approved for University Entrance.

Assessment
Level
Internal or
External
Credits
L1 Literacy Credits UE Literacy Credits Numeracy Credits
A.S. 91900 v1 Digital Technologies and Hangarau Matihiko 3.1 - Conduct a critical inquiry to propose a digital technologies outcome
Assessments:
Term: , Week:
3
I
6
Y
A.S. 91902 v1 Digital Technologies and Hangarau Matihiko 3.3 - Use complex techniques to develop a database
Assessments:
Term: , Week:
3
I
4
A.S. 91906 v1 Digital Technologies and Hangarau Matihiko 3.7 - Use complex programming techniques to develop a computer program
3
I
6
A.S. 91908 v1 Digital Technologies and Hangarau Matihiko 3.9 - Analyse an area of computer science
Assessments:
Term: , Week:
3
E
3
Y
3w
Total Credits

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