- BSBADM305A - Create and use databases
Unit of Competency Mapping – Information for Teachers/Assessors – Information for Learners
BSBADM305A Mapping and Delivery Guide
Create and use databases
Version 1.0
Issue Date: March 2024
Qualification | - |
Unit of Competency | BSBADM305A - Create and use databases |
---|---|---|---|
Description | This unit covers the creation of simple data tables, forms, reports and queries to create a simple database that is used for storage and retrieval of information. This unit is related to BSBADM403A Develop and use complex databases.This unit covers the creation of simple data tables, forms, reports and queries to create a simple database that is used for storage and retrieval of information. This unit is related to BSBADM403A Develop and use complex databases | ||
Employability Skills | Not applicable. | ||
Learning Outcomes and Application | Not applicable. | ||
Duration and Setting | X weeks, nominally xx hours, delivered in a classroom/online/blended learning setting. |
||
Prerequisites/co-requisites | Not applicable. | ||
Competency Field |
Development and validation strategy and guide for assessors and learners | Student Learning Resources | Handouts Activities |
Slides PPT |
Assessment 1 | Assessment 2 | Assessment 3 | Assessment 4 | |
---|---|---|---|---|---|---|---|---|
Elements of Competency | Performance Criteria | |||||||
Element: Use safe work practices |
| |||||||
Element: Create simple databases |
| |||||||
Element: Create simple database queries |
| |||||||
Element: Use simple databases |
|
Evidence Required
List the assessment methods to be used and the context and resources required for assessment. Copy and paste the relevant sections from the evidence guide below and then re-write these in plain English.
Critical Aspects of Evidence
Integrated demonstration of all elements of competency and their performance criteria
Databases are appropriate to task requirements and efficient input of data
Underpinning Knowledge*
* At this level the learner must demonstrate understanding of a broad knowledge base incorporating some theoretical concepts.
Relevant legislation from all levels of government that affects business operation, especially in regard to Occupational Health and Safety and environmental issues, equal opportunity, industrial relations and anti-discrimination
Organisational policy and procedures on
saving and backing up files
format of workplace reports / documents
energy and resource conservation
databases, including entry
database reports strategy
simple formulae
Underpinning Skills
Numeracy skills in relating to creating simple queries and using simple formulae
Ability to relate to people from a range of social, cultural and ethnic backgrounds and physical and mental abilities
Resource Implications
The learner and trainer should have access to appropriate documentation and resources normally used in the workplace. These may include:
workplace reference materials such as style guides
computer equipment with database software
English dictionary
Consistency of Performance
In order to achieve consistency of performance, evidence should be collected over a set period of time which is sufficient to include dealings with an appropriate range and variety of situations
Context/s of Assessment
Competency is demonstrated by performance of all stated criteria, including paying particular attention to the critical aspects and the knowledge and skills elaborated in the Evidence Guide, and within the scope as defined by the Range Statement
Assessment must take account of the endorsed assessment guidelines in the Business Services Training Package
Assessment of performance requirements in this unit should be undertaken in an actual workplace or simulated environment
Assessment should reinforce the integration of the key competencies and the business services common competencies for the particular AQF level. Refer to the Key Competency Levels at the end of this unit
Key Competency Levels
Collecting, analysing and organising information - to determine the most appropriate database format
Communicating ideas and information - through the production of effective database reports
Planning and organising activities - to determine queries, formulae and input data
Working with teams and others - to determine database outputs and printing requirements
Using mathematical ideas and techniques - while using queries and formulae in the database
Solving problems - using manuals and on-line help
Using technology - to create and use databases
Please refer to the Assessment Guidelines for advice on how to use the Key Competencies
Critical Aspects of Evidence
Integrated demonstration of all elements of competency and their performance criteria
Databases are appropriate to task requirements and efficient input of data
Underpinning Knowledge*
* At this level the learner must demonstrate understanding of a broad knowledge base incorporating some theoretical concepts.
Relevant legislation from all levels of government that affects business operation, especially in regard to Occupational Health and Safety and environmental issues, equal opportunity, industrial relations and anti-discrimination
Organisational policy and procedures on
saving and backing up files
format of workplace reports / documents
energy and resource conservation
databases, including entry
database reports strategy
simple formulae
Underpinning Skills
Numeracy skills in relating to creating simple queries and using simple formulae
Ability to relate to people from a range of social, cultural and ethnic backgrounds and physical and mental abilities
Resource Implications
The learner and trainer should have access to appropriate documentation and resources normally used in the workplace. These may include:
workplace reference materials such as style guides
computer equipment with database software
English dictionary
Consistency of Performance
In order to achieve consistency of performance, evidence should be collected over a set period of time which is sufficient to include dealings with an appropriate range and variety of situations
Context/s of Assessment
Competency is demonstrated by performance of all stated criteria, including paying particular attention to the critical aspects and the knowledge and skills elaborated in the Evidence Guide, and within the scope as defined by the Range Statement
Assessment must take account of the endorsed assessment guidelines in the Business Services Training Package
Assessment of performance requirements in this unit should be undertaken in an actual workplace or simulated environment
Assessment should reinforce the integration of the key competencies and the business services common competencies for the particular AQF level. Refer to the Key Competency Levels at the end of this unit
Key Competency Levels
Collecting, analysing and organising information - to determine the most appropriate database format
Communicating ideas and information - through the production of effective database reports
Planning and organising activities - to determine queries, formulae and input data
Working with teams and others - to determine database outputs and printing requirements
Using mathematical ideas and techniques - while using queries and formulae in the database
Solving problems - using manuals and on-line help
Using technology - to create and use databases
Please refer to the Assessment Guidelines for advice on how to use the Key Competencies
Submission Requirements
List each assessment task's title, type (eg project, observation/demonstration, essay, assignment, checklist) and due date here
Assessment task 1: [title] Due date:
(add new lines for each of the assessment tasks)
Assessment Tasks
Copy and paste from the following data to produce each assessment task. Write these in plain English and spell out how, when and where the task is to be carried out, under what conditions, and what resources are needed. Include guidelines about how well the candidate has to perform a task for it to be judged satisfactory.
Not applicable.
Legislation, codes and national standards relevant to the workplace which may include:
award and enterprise agreements and relevant industrial instruments
relevant legislation from all levels of government that affects business operation, especially in regard to Occupational Health and Safety and environmental issues, equal opportunity, industrial relations and anti-discrimination
relevant industry codes of practice
Organisational policy and procedures may include:
log-on procedures
password protection
storage / location of data
standard formats
author's instructions
use of templates
Ergonomic requirements may include:
workstation height and layout
chair height, seat and back adjustment
footrest
screen position
keyboard and mouse position
document holder
posture
avoiding radiation from computer screens
lighting
noise minimisation
Work organisation may include:
mix of repetitive and other activities
rest periods
exercise breaks
Conservation techniques may include:
double-sided paper use
re-used paper for rough drafts (observing confidentiality requirements)
recycling used and shredded paper
utilising power-save options for equipment
Software functions may include:
field definitions / attributes
inserting / deleting blank lines and spaces
altering field widths
adding, deleting, moving, re-labeling fields
repeating (if available)
calculate/formula
formatting fields
formatting text
data protection
headers/footers
table, form and report wizards
Simple formulae may include:
count
maximum
minimum
average
sum
subtraction
multiplication
division
combinations of above
Report formatting may include:
alignment on page
tables
columns
enhancements to format - borders, patterns and colours
enhancements to text
headers/footers
Data may include:
numbers
text
Checking may include:
proofreading
accuracy of data
spelling, electronically and manually
accuracy of formulae with calculator
outcome of sorting / filtering
ensuring instructions with regard to content and format have been followed
Designated timelines may include:
timeline agreed with supervisor/person requiring database
timeline agreed with internal/external client
Printing may include:
records
tables
forms
queries
reports
Storage of data may include:
storage in electronic folders / sub-folders
storage on hard/floppy disk drives, CD ROM, tape backup
organisation policy for backing up files
organisation policy for filing hard copies of databases
filing locations
security
authorised access
Legislation, codes and national standards relevant to the workplace which may include:
award and enterprise agreements and relevant industrial instruments
relevant legislation from all levels of government that affects business operation, especially in regard to Occupational Health and Safety and environmental issues, equal opportunity, industrial relations and anti-discrimination
relevant industry codes of practice
Organisational policy and procedures may include:
log-on procedures
password protection
storage / location of data
standard formats
author's instructions
use of templates
Ergonomic requirements may include:
workstation height and layout
chair height, seat and back adjustment
footrest
screen position
keyboard and mouse position
document holder
posture
avoiding radiation from computer screens
lighting
noise minimisation
Work organisation may include:
mix of repetitive and other activities
rest periods
exercise breaks
Conservation techniques may include:
double-sided paper use
re-used paper for rough drafts (observing confidentiality requirements)
recycling used and shredded paper
utilising power-save options for equipment
Software functions may include:
field definitions / attributes
inserting / deleting blank lines and spaces
altering field widths
adding, deleting, moving, re-labeling fields
repeating (if available)
calculate/formula
formatting fields
formatting text
data protection
headers/footers
table, form and report wizards
Simple formulae may include:
count
maximum
minimum
average
sum
subtraction
multiplication
division
combinations of above
Report formatting may include:
alignment on page
tables
columns
enhancements to format - borders, patterns and colours
enhancements to text
headers/footers
Data may include:
numbers
text
Checking may include:
proofreading
accuracy of data
spelling, electronically and manually
accuracy of formulae with calculator
outcome of sorting / filtering
ensuring instructions with regard to content and format have been followed
Designated timelines may include:
timeline agreed with supervisor/person requiring database
timeline agreed with internal/external client
Printing may include:
records
tables
forms
queries
reports
Storage of data may include:
storage in electronic folders / sub-folders
storage on hard/floppy disk drives, CD ROM, tape backup
organisation policy for backing up files
organisation policy for filing hard copies of databases
filing locations
security
authorised access
Copy and paste from the following performance criteria to create an observation checklist for each task. When you have finished writing your assessment tool every one of these must have been addressed, preferably several times in a variety of contexts. To ensure this occurs download the assessment matrix for the unit; enter each assessment task as a column header and place check marks against each performance criteria that task addresses.
Observation Checklist
Tasks to be observed according to workplace/college/TAFE policy and procedures, relevant legislation and Codes of Practice | Yes | No | Comments/feedback |
---|---|---|---|
Workspace, furniture and equipment are adjusted to suit the ergonomic requirements of the user | |||
Work organisation meets organisational and occupational health and safety requirements for computer operation | |||
Energy and resource conservation techniques are used to minimise wastage in accordance with organisational and statutory requirements | |||
Organisational requirements in relation to data entry, storage, output and presentation requirements are identified | |||
Database use, output, reporting and presentation requirements are determined in accordance with organisational policy and procedures | |||
Database utilises software functions and simple formulae to meet identified requirements | |||
Data table and form layout enable efficient data input and display | |||
Database reports are formatted in accordance with organisational style and presentation requirements | |||
Information output, database tables to be used and report layout are determined to meet task requirements | |||
Data groupings, search and sort criteria are determined to meet task requirements | |||
Queries are run and the results checked to ensure they provide the required data | |||
Data is entered, checked and amended in accordance with organisational and task requirements | |||
Data input meets designated timelines and organisational requirements for speed and accuracy | |||
Queries and formulae are tested to confirm output meets task requirements | |||
Manuals, user documentation and on-line help are used to overcome problems with database design and production | |||
Database reports and/or forms are previewed, adjusted and printed in accordance with organisational and task requirements | |||
Databases are named and stored, in accordance with organisational requirements and the application exited without data loss/damage |
Forms
Assessment Cover Sheet
BSBADM305A - Create and use databases
Assessment task 1: [title]
Student name:
Student ID:
I declare that the assessment tasks submitted for this unit are my own work.
Student signature:
Result: Competent Not yet competent
Feedback to student
Assessor name:
Signature:
Date:
Assessment Record Sheet
BSBADM305A - Create and use databases
Student name:
Student ID:
Assessment task 1: [title] Result: Competent Not yet competent
(add lines for each task)
Feedback to student:
Overall assessment result: Competent Not yet competent
Assessor name:
Signature:
Date:
Student signature:
Date: