COM301

Level 3 Computer Science

Course Description

Teacher in Charge: J. Gottschalk.

This course is for students who want to study computing at tertiary level. It will develop their skills in creating a MySQL database that is accessed via a web interface coded in PHP, HTML & CSS. Students will have the opportunity to implement complex procedures in this project.

You can take both COM301 and DTI301.  For COM301, the database standard is optional (ie: our priority is to complete the programming standards and the external).  For students who don't take DTI301, completing the database standard is a great way to earn an additional four credits.  The database standard is offered as part of DTI301

For the programming assessment, students will have the opportunity to create a program in Python which includes a graphical user interface. The unit will cover complex programming concepts such as indexed data structures and object orientation.

For the external assessment students learn about two areas in Computer Science. These change from year to year but are always fascinating.

This course is on the approved University Entrance list and the standards are also included in Auckland University’s ‘Table B’.

METHODS OF ASSESSMENT
This course is solely Achievement Standards which includes one external assessment.

Recommended Prior Learning

A minimum of 12 credits in COM201 plus a pass in Level 2 literacy or with agreement of the HOD.  If you have not done COM201 but have very strong Mathematics skills / prior programming experience, please talk to us!


Contributions and Equipment/Stationery

Headphones which plug into a standard headphone jack (not Apple) for accessing sound in tutorial videos.

Pathway

Students with a background in Computer Science / Programming are well placed to continue on to University or to find work in the well-paying IT industry (which currently has a worldwide shortage of trained professionals).

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.

This course is approved for University Entrance.

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. 91902 v1
NZQA Info
Digital Technologies and Hangarau Matihiko 3.3 - Use complex techniques to develop a database
4
4
4
4
Level: 3
Internal or External: Internal
Credits: 4
Level 1 Literacy Credits: 0
University Entrance Literacy Credits: 0
Numeracy Credits: 0
A.S. 91906 v1
NZQA Info
Digital Technologies and Hangarau Matihiko 3.7 - Use complex programming techniques to develop a computer program
6
6
6
Level: 3
Internal or External: Internal
Credits: 6
Level 1 Literacy Credits: 0
University Entrance Literacy Credits: 0
Numeracy Credits: 0
A.S. 91907 v1
NZQA Info
Digital Technologies and Hangarau Matihiko 3.8 - Use complex processes to develop a digital technologies outcome
6
6
6
6
6
6
Level: 3
Internal or External: Internal
Credits: 6
Level 1 Literacy Credits: 0
University Entrance Literacy Credits: 0
Numeracy Credits: 0
A.S. 91908 v1
NZQA Info
Digital Technologies and Hangarau Matihiko 3.9 - Analyse an area of computer science
3
3
3
Level: 3
Internal or External: External
Credits: 3
Level 1 Literacy Credits: 0
University Entrance Literacy Credits: 3w
Numeracy Credits: 0
Credit Summary
Total Credits: 19
Total Level 1 Literacy Credits: 0
Total University Entrance Literacy Credits: 3
Total Numeracy Credits: 0