Spreadsheets and Databases

CCIU302

This online course will enable you to manipulate and integrate data across applications.

  •  
    Level
    3
  •  
    Credits
    10
  •  
    Cost
    2025
    2024
    $47 NZ Domestic
    $528 NZ International
  •  
    EFTS
    0.0833
  • Delivery type
    Online 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.

Work towards

You can do this course as part of these qualifications:

Certificate

Course availability over the next 12 months

May

May enrolment dates

Enrol by -
Course starts -
Course ends -
7 May 2024
20 May 2024
6 Oct 2024
Jun

June enrolment dates

Enrol by -
Course starts -
Course ends -
11 Jun 2024
24 Jun 2024
10 Nov 2024
Jul

July enrolment dates

Enrol by -
Course starts -
Course ends -
9 Jul 2024
22 Jul 2024
8 Dec 2024
Aug

August enrolment dates

Enrol by -
Course starts -
Course ends -
6 Aug 2024
19 Aug 2024
5 Jan 2025
Sep

September enrolment dates

Enrol by -
Course starts -
Course ends -
3 Sep 2024
16 Sep 2024
2 Feb 2025
Oct

October enrolment dates

Enrol by -
Course starts -
Course ends -
8 Oct 2024
21 Oct 2024
9 Mar 2025
Nov

November enrolment dates

Enrol by -
Course starts -
Course ends -
5 Nov 2024
18 Nov 2024
6 Apr 2025
Dec

December enrolment dates

Enrol by -
Course starts -
Course ends -
3 Dec 2024
16 Dec 2024
4 May 2025
2025
Jan
Feb

Dates for this course are not finalised yet

Check back later

Enrol by -
Course starts -
Course ends -
To be confirmed
To be confirmed
To be confirmed
Enrol by -
Course starts -
Course ends -
To be confirmed
To be confirmed
To be confirmed
Mar

Dates for this course are not finalised yet

Check back later

Enrol by -
Course starts -
Course ends -
To be confirmed
To be confirmed
To be confirmed
Apr

Dates for this course are not finalised yet

Check back later

Enrol by -
Course starts -
Course ends -
To be confirmed
To be confirmed
To be confirmed
  •  
    Level
    3
  •  
    Credits
    10
  •  
    Cost
    2025
    2024
    $47 NZ Domestic
    $528 NZ International
  •  
    EFTS
    0.0833
  • Delivery type
    Online only
  • Teaching weeks 16 weeks
  • Workload Approximately 7 hours per week
  •  
    Prerequisites Check entry and other requirements under the qualification you are studying