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 credits.
Internally Assessed Credits: 18 credits.

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
3
3
3
3
3
3
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
2
2
2
2
2
2
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
3
3
3
3
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
3
3
3
3
3
3
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
2
2
2
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