Training Packages Unwrapped

A database of elements taken from NTIS training packages.

files at NTIS

BSBCMN214A

Create and use simple spreadsheets

This unit covers creating and using simple spreadsheets and charts through the use of spreadsheet software.
This unit is related to BSBCMN107A Operate a personal computer and BSBCMN108A Develop keyboard skills.

Options

? Display Unit

Reconstruct the unit from the database and display it as a plain HTML page.

CLOSE

This has several advantages over the cut-and-paste from PDF option, in that hard carriage returns are removed, and multi-column data is stored in tables. You do miss out on some formatting, but the data is otherwise mostly unchanged, the main difference being that terms and definitions in the range statement's variable/scope list displayed are in alphabetical order here (but not in the original).

?Training O₂ Resources

community submitted and rated resources for the unit

CLOSE

A social news gathering site built around training package units. Students and trainers can submit links to on-line resources which will be voted on by other site users; commented on, and promoted (or not) depending on the resource's usefulness.

?TiddlyWiki

Chose 'Save file as...' from the popup and get a personal, stand-alone student journal for the unit.

CLOSE

This link will prompt you to download a TiddlyWiki for the unit. If you're not sure what a wiki is, the wikipedia is a good example, and it has a good entry on wikis too. TiddlyWikis are special cases of wikis in that they can be saved and edited on a local drive. You will need to save the TiddlyWiki onto your hard drive, and if you're using Internet Explorer, you'll need to allow JavaScript to run for the file (Firefox, Opera and Safari users shouldn't have this trouble).

?Assessment Template

generate a spreadsheet for marking this unit in a classroom environment

CLOSE

This link will create a csv file that can be opened with a spreadsheet application. It lists all the performance criteria and includes some calculations for a final grade. Without any indication of weighting for each criteria in the training package, I've had to allocate each an equal mark. You may need to adjust this :-)

?Evidence Guide

create an evidence guide for individual students to fill in

CLOSE

This will generate a simple html page with a table for students to enter details of evidence they would like assessed as meeting the unit's performance criteria. You can copy this page into a word processor or print it out from your web browser for each student.

?Keywords

a tag cloud of the keywords for the unit with links to on-line resouces for each word

CLOSE

A machine generated list of links to resouces that may be useful when teaching this unit. Includes links to creative commons licensed images, wikipedia articles, and sites listed on del.icio.us

?XML

pick up an XML version of the unit that will allow you to generate stuff directly from the data (like your own assessment templates and evidence sheets)

CLOSE

This link will upload an XML representation of the unit. This should allow you to extract and use the information in a flexible manner, dropping the bits and pieces in where you need them.

I hope the tags are self explanatory, but drop me a line if you're having problems. I'd also love to see any novel new uses people come up with (and if you write a bit of PHP, a schema, DTD or XSLT to manipulate the data please send it to me so that I can include it here)

?MediaWiki and WikiSpaces formats

mark up the unit in a wiki format, ready to paste into the wikiversity or wikispaces

CLOSE

These links will create wikimedia and wikispaces versions of the unit. This should allow you to cut and paste the information into any wikimedia type wiki, such as the wikipedia or wikiversity or a wikispaces wiki.

Search

Browse

• Training Packages
• BSB01 Units
• Source Code
• Credits & Copyright