NCEA Level 2 Computer Science Information 201
Course Description
Teacher in Charge: Ms C. Stevens.
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 will also learn about Computer Security which is the main topic for their end of year External Exam.
Students can also take the option DIT201 as this course compliments CSI201.
Assessment
Gain up to 19 Achievement standard credits at Level 2. This will help students towards the 60 credits needed to pass their NCEA Level 2.
Course Overview
Term 1
DATABASE _ MySQL
Practice for and start an assessment, Assessment Standard 2.3_(91892)_Databases
Term 2
DATABASE _ MySQL
Complete an assessment, Assessment Standard 2.3_(91892)_Databases
PROGRAMMING - PYTHON
Practice for and complete an assessment, Assessment Standard 2.7_(91896)_Program
Term 3
PROGRAMMING - PYTHON
Practice for and complete an assessment, Assessment Standard 2.7_(91896)_Program
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 new students, however it is an academic course and students should preferably have studied CSI101.
Students who have not had prior experience are expected to discuss their suitability for the course with the HOD (Head of Department) Mr Foulds and show commitment to completing online programming courses in preparation for February 2025.
Contributions and Equipment/Stationery
A4 Exercise Book 8mm ruled lines. For learning the Computer Languages.
A set of headphones (ear plugs).
Have credit on their Papercut account for printing of some assessments.
Pathway
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.
External
NZQA Info
Digital Technologies and Hangarau Matihiko 2.1 - Conduct an inquiry to propose a digital technologies outcome
Assessments:
Term: 3, Week: 8
NZQA Info
Digital Technologies and Hangarau Matihiko 2.3 - Use advanced techniques to develop a database
Assessments:
Term: 2, Week: 9
NZQA Info
Digital Technologies and Hangarau Matihiko 2.7 - Use advanced programming techniques to develop a computer program
Assessments:
Term: 1, Week: 10
NZQA Info
Digital Technologies and Hangarau Matihiko 2.9 - Demonstrate understanding of a computer science concept
Assessments:
Term: 4, Week: 2
Pathway Tags
CSI301 - NCEA Level 3 Computer Science Information 301 and/or 13DIT - NCEA Level 3 Digital Information Technologies 301. Game Developer, Geospatial Specialist, Office Manager, Test Analyst, Network Administrator, Security Analyst, Industrial Designer, Information Technology Helpdesk/Support Technician, Information Technology Manager, Systems Administrator, Survey Technician, Software Developer, Electronics Engineer,