Nominal Hours | Files

The best source file for the nominal hours for each Unit of Competency (UoC) is that from NCVER (unless funding arrangements require otherwise). If the unit code is not there, check the Training Package or qualification.

This file size is a small tab delimited text file, clear of formatting and quickly downloaded. It is great for updating a compliance system that has matching unit information, such as an RMS or QMS. If you lack such convenience, but have Microsoft Excel; the following steps enable you to create your own app.

Create your own app

Preparation

Some of the unit codes have leading zero’s so ensure that these are not lost when you open it into Excel. How clean the data appears often depends upon the version and variant of Excel you are using and allegedly the confluence of the moon and stars.

Start by downloading the file from NCVER  (note its location)

Open Excel, then locate and open the downloaded file. An import wizard appears.

  1. Ensure that Delimited and My data has headers are enabled, select [Next]
  2. The delimiter should be Tab, select [Next]
  3. Change the column data format to text (this affects the first column only, which is fine), select [Finish]

If that went well and the leading zero’s haven’t been lost, great! If they dissapeared the first column has likely been converted to numbers, so ditch that and try Plan B.

Plan B (Windows)

Open the file from File Explorer

  1. [Shift]+rightclick . A context menu appears,
  2. Hover over the Open with... option and select Excel
    1. If Excel isn’t listed, select Choose another app..
    2. find the executable, it’ll be someplace like
      C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE
    3. The file should open in Excel with no ommissions.
  3. Format the first and second columns as text, the third as number
  4. Save the file
    1. From the File menu choose Save As… and select the destination folder.
      The Save As dialog appears
    2. In Save as type: ensure that Excel Workbook (*.xlsx) is selected
    3. Ensure that the destination is as desired, [Save]
  5. Tweak the file for the end user
    1. From the View ribbon (Window group) open Freeze Panes and select Freeze Top Row.
    2. Select cells A1 to C1 and:
      1. from the Home ribbon (Alignment group) select Wrap Text
      2. from the Data ribbon (Sort and Filter group) select Filter.
    3. Re-arrange column widths to suit your view and save.

You now have a quick and easy way to sort, filter and find information by unit code.

If you wanted to take it further, you could enter the units on your scope into another sheet and use Vlookup or INDEX & MATCH formulas to pull the information from this table to populate your new sheet.NCVER hours (20 Jun 18)

  • NCVER hours (20 Jun 18) is a sample of something we’re working on. It follows the above instructions then goes on to add a tab for looking up the hours for UoC’s entered in a data table. We’re currently looking for a database of the 65K records of current, superceded and deleted unit titles and codes to use as a matchup database. When we find it, we’ll update this base file. If you like what you see, contact ComplySys@gmail.com to discuss your own contextualised copy.

More

For AVETMISS reporting purposes: If a UoC unlisted, the nominal hours may instead be sourced from the UoC’s training package purchasing guide or by searching for the UoC on http://www.education.vic.gov.au/training/providers/rto/Pages/purchasingguides.aspx

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.