This online course will enable you to manipulate and integrate data across applications.
-
Level3
-
Credits10
-
Cost$0 NZ Domestic$528 NZ International
-
EFTS0.0833
-
Delivery typeOnline only
-
Teaching weeks 16 weeks
-
Workload Approximately 7 hours per week
-
Prerequisites Check entry and other requirements under the qualification you are studying
Learners who successfully complete this online course will be able to:
- Use a spreadsheet and database to organise, combine, manipulate, store, and share data to meet specific purposes
- Plan, consult, design and develop spreadsheets and databases to provide a solution for organisational use
What you will learn
In this course, you will learn about:
- What a spreadsheet is
- How to create a spreadsheet workbook
- How to plan and evaluate spreadsheets
- How to create a spreadsheet template
- How to create and use formulas
- How and when to use absolute and relative referencing
- How to sort and filter spreadsheet data
- How to create spreadsheet charts and macros
- What a database is and the difference between flat and relational databases
- Create and perform queries on a database
- Share data between word processors, spreadsheets, and databases
- Create a mail merge
Assessment
100% internal assessment
Textbooks
No textbooks are required for this course
Computer and internet requirements
The programme is specifically designed for a Windows / Microsoft environment. You will not be able to complete this qualification using a tablet, Chromebook, or Apple Mac computer.
This programme is delivered online. To complete this programme you will need access to a laptop or desktop computer, reliable broadband internet connection and a data plan able to support online learning such as streaming of videos (including YouTube), downloading content, and writing and submitting online assessments.
If you are unsure if your current computer or internet access allows you to complete your online learning with us, please contact us before applying to enrol.
Learn more about our online learning and study tools.
Work towards
Course availability over the next 12 months
Oct
|
Nov
|
Dec
|
2025
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|