Formats and tools
- Unit Description
- Reconstruct the unit from the xml and display it as an HTML page.
- Assessment Tool
- an assessor resource that builds a framework for writing an assessment tool
- Assessment Template
- generate a spreadsheet for marking this unit in a classroom environment. Put student names in the top row and check them off as they demonstrate competenece for each of the unit's elements and performance criteria.
- Assessment Matrix
- a slightly different format than the assessment template. A spreadsheet with unit names, elements and performance criteria in separate columns. Put assessment names in column headings to track which performance criteria each one covers. Good for ensuring that you've covered every one of the performance criteria with your assessment instrument (all assessement tools together).
- Wiki Markup
- mark up the unit in a wiki markup codes, ready to copy and paste into a wiki page. The output will work in most wikis but is designed to work particularly well as a Wikiversity learning project.
- Evidence Guide
- create an evidence guide for workplace assessment and RPL applicants
- Competency Mapping Template
- Unit of Competency Mapping – Information for Teachers/Assessors – Information for Learners. A template for developing assessments for a unit, which will help you to create valid, fair and reliable assessments for the unit, ready to give to trainers and students
- Observation Checklist
- create an observation checklist for workplace assessment and RPL applicants. This is similar to the evidence guide above, but a little shorter and friendlier on your printer. You will also need to create a seperate Assessor Marking Guide for guidelines on gathering evidence and a list of key points for each activity observed using the unit's range statement, required skills and evidence required (see the unit's html page for details)
- Self Assessment Survey
- A form for students to assess thier current skill levels against each of the unit's performance criteria. Cut and paste into a web document or print and distribute in hard copy.
- Moodle Outcomes
- Create a csv file of the unit's performance criteria to import into a moodle course as outcomes, ready to associate with each of your assignments. Here's a quick 'how to' for importing these into moodle 2.x
- Registered Training Organisations
- Trying to find someone to train or assess you? This link lists all the RTOs that are currently registered to deliver ICAB4136B, 'Use structured query language to create database structures and manipulate data'.
- Google Links
- links to google searches, with filtering in place to maximise the usefulness of the returned results
- Books
- Reference books for 'Use structured query language to create database structures and manipulate data' on fishpond.com.au. This online store has a huge range of books, pretty reasonable prices, free delivery in Australia *and* they give a small commission to ntisthis.com for every purchase, so go nuts :)
Elements and Performance Criteria
ELEMENT | PERFORMANCE CRITERIA |
1. Write a simple SQL statement to retrieve and sort data | 1.1. Retrieve all the data from a single table 1.2. Retrieve data from specific columns in a single table 1.3. Use 'order by' to sort query output |
2. Write an SQL statement that selectively retrieves data | 2.1. Restrict the number of rows retrieved by placing criteria in the 'where' clause 2.2. Restrict the number of rows retrieved by placing specific criteria in the select statement 2.3. Use comparisonoperators in the 'where' clause to compare numeric, character, string, date and time data 2.4. Use Booleanoperators with the correct precedence 2.5. Use criteria in the 'where' clause to check for a range of values, to select values from a list, and to check for values that match a pattern 2.6. Use SQL syntax to suppress duplicate values from query results 2.7. Take action to exclude null values from a query result |
3. Write SQL statements that use functions | 3.1. Use arithmeticaloperators with the correct precedence 3.2. Use string functions and operators to obtain the required query output 3.3. Use mathematicalfunctions to obtain the required output, where required 3.4. Use date functions to obtain the required output 3.5. Use SQL aggregate functions to obtain the required output |
4. Write SQL statements that use aggregation and filtering | 4.1. Use 'group by' to aggregate data by multiple columns 4.2. Sort aggregated data in the query output 4.3. Filter aggregated data using the 'having' clause |
5. Write SQL statements that retrieve data from multiple tables | 5.1. Employ the inner join syntax to retrieve data from two or more tables 5.2. Use 'left outer', 'right outer' and 'full outer' syntax to join tables in the select statement 5.3. Use correct syntax in the 'where' clause to retrieve data from multiple tables 5.4. Write a union query that retrieves data from more than one table |
6. Write and execute SQL sub-queries | 6.1. Construct single and nested sub-queries 6.2. Construct sub-queries that return a single row, and multiple rows 6.3. Use correlated sub-queries to retrieve required data 6.4. Write sub-queries that use aggregates |
7. Create and manipulate tables | 7.1. Identify required columns, data types, keys, relationships, indexes and constraints 7.2. Use relevant naming conventions for all database elements 7.3. Create tables that implement all required elements 7.4. Insert rows into tables 7.5. Update some or all of the data in a table 7.6. Add columns to a table 7.7. Modify a column within a table 7.8. Delete a column from a table 7.9. Delete rows from a table 7.10. View detailed information regarding a table 7.11. Delete tables with regard to referential integrity rules |
8. Create and use views | 8.1. Create views that satisfy informationrequirements 8.2. Use check constraints in a view 8.3. Retrieve, insert, update and delete data using a view 8.4. Drop a view from a database |
9. Create and use stored procedures | 9.1. Create and execute stored procedures that use SQL to retrieve, insert or modify data according to informationrequirements 9.2. Create and execute stored procedures that use one or more parameters 9.3. Drop a stored procedure from the database 9.4. Create and test database triggers that automate data management or perform specific required data-related functions |