2TCOM

NCEA Level 2 Computer Applications

Course Description

Head of Faculty - Kaihautuu: Mr S. Qureshi.

Computer Applications

Students will develop employment entry level computing skills in a range of applications.  These skills will be valuable for school, further education, employment and leisure activities.

Microsoft Word (word processing)
Microsoft Excel (spreadsheets)
Microsoft Access (databases)
draw.io (flow charts and schematic diagrams)


Students work at their own pace and level of expertise through online workbooks and assessments.



Course Overview

Term 1
Learning and assessments in:
Microsoft Word (word processing)
File Management
Schematic diagrams/Flow charts using draw.io /

Term 2
Learning and assessments in:
Digital images using gimp / inkscape / photoshop
Spreadsheets using Microsoft Excel (spreadsheets)

Term 3
Learning and assessment in:
Databases using Microsoft Access (databases)

Term 4
Completion of all course assessments

Recommended Prior Learning

Students will be keen computer users and want to learn skills in a range of applications to make them efficient users of various programs which can assist us in our everyday and employment lives.

Pathway

This leads to... employment in administrative areas across a range of job and industry settings.

Assessment Information

Skills are assessed through Unit Standards. Students should complete two (2) assessments per term if they are working to potential. This course does not lead to University Entrance, but does contribute towards NCEA certificates.

Credit Information

You will be assessed in this course through all or a selection of the standards listed below.

Total Credits Available: 18
Internal Assessed Credits: 18
External Assessed Credits: 0
Assessment
Description
Level
Internal or
External
Credits
L1 Literacy Credits
UE Literacy Credits
Numeracy Credits
U.S. 12885 v9
NZQA Info

Create and enhance electronic documents combining text and images for generic text and information management


Level: 2
Internal or External: Internal
Credits: 4
Level 1 Literacy Credits: 0
University Entrance Literacy Credits: 0
Numeracy Credits: 0
U.S. 29770 v2
NZQA Info

Use the main features and functions of a spreadsheet application for a purpose


Level: 2
Internal or External: Internal
Credits: 4
Level 1 Literacy Credits: 0
University Entrance Literacy Credits: 0
Numeracy Credits: 0
U.S. 29772 v2
NZQA Info

Manage files and folders using digital devices


Level: 2
Internal or External: Internal
Credits: 2
Level 1 Literacy Credits: 0
University Entrance Literacy Credits: 0
Numeracy Credits: 0
U.S. 29773 v2
NZQA Info

Produce digital images for a range of digital media


Level: 2
Internal or External: Internal
Credits: 3
Level 1 Literacy Credits: 0
University Entrance Literacy Credits: 0
Numeracy Credits: 0
U.S. 29777 v2
NZQA Info

Use the main features and functions of a database application to create and test a database


Level: 2
Internal or External: Internal
Credits: 3
Level 1 Literacy Credits: 0
University Entrance Literacy Credits: 0
Numeracy Credits: 0
U.S. 29778 v2
NZQA Info

Use the main features and functions of a schematic diagram application to create diagrams


Level: 2
Internal or External: Internal
Credits: 2
Level 1 Literacy Credits: 0
University Entrance Literacy Credits: 0
Numeracy Credits: 0
Credit Summary
Total Credits: 18
Total Level 1 Literacy Credits: 0
Total University Entrance Literacy Credits: 0
Total Numeracy Credits: 0