Read all the instructions below before attempting the assessment task. Assessment tasks are tools used to determine if you have the knowledge and skills to complete tasks to industry standards within the workplace. Your trainer/assessor will help you throughout this task and it is your responsibility to provide enough evidence to justify a competent decision by the trainer/assessor. If you do not understand the questions or what is required, ask your trainer/assessor for assistance. For group assessments, all students are to contribute to the assessment tasks. You can work in groups up to a maximum of four people.
You are to complete all tasks by the due date and assessments must have a coversheet attached. If you think you do not have enough time to complete the tasks by the due date, discuss with the trainer/assessor the reasons of why you cannot submit on time.
Writing your responses
When answering questions, ensure that your answers are detailed enough to so the assessor can draw a conclusion that you have the knowledge and/or skills to demonstrate competency. Handwritten answers must be written in blue or black pen. When producing reports, ensure that your project has a title page, table of contents, page numbers, reference list, ensuring that your answers thoroughly match the questions asked.
Answer all questions in your own words to avoid plagiarism. Plagiarism is copying someone else’s work or ideas and saying that it your own work. Sources of work must be properly referenced, outlining the source of your ideas. Penalties may include having to resubmit the assessment task again, repeating the Unit of competency, or for repeat plagiarism, expulsion from Australian College of Hospitality & Business Management.
Marking of Assessments
On submission of your assessment will be marked for a result of either Satisfactory (S) or Not Yet Satisfactory (NYS). If you receive a NYS result, you will be asked to redo the tasks again. To achieve a competent result with this unit, all tasks need to be completed and marked as satisfactory. Your trainer/assessor will provide feedback to you on each task, outlining where you must improve to achieve a Satisfactory (S) result. When all tasks are marked as Satisfactory (S), you will receive a result of Competent (C) for this unit otherwise, you will be marked Not Yet Competent (NYC). Assessments submitted to the trainer/assessor after the due date may not be accepted, and you may have to pay a resubmission fee / adjustment may apply.
Students with Special Needs
If leaners/learners have any special needs (e.g. physical disability, learning difficulty) regarding assessment, they should be directed to discuss these with the Course Coordinator. The college will endeavour to make all possible and reasonable adjustments to any aspect of assessment in order to address those needs. Some examples of additional support could include:
Reasonable adjustment refers to any modification made to the learning environment, certification requirements, training delivery or assessment method to help learners with a disability access and participate in education and training on the same basis as those without disability (IBSA, 2015). The Disability Standards for Education 2005 were formed under the Disability Discrimination Act 1992. They clarify the obligations of training providers to ensure that learners who have a disability are able to access and participate in education and training on the same basis as those without disability.
Some examples of reasonable adjustments could include:
The determination of “reasonableness” requires judgement that must take into account the impact on the RTO and the need to maintain the integrity of the qualification. While reasonable adjustments can be made to the ways in which evidence of performance is gathered and demonstrated, the criteria for making Competent/Not Yet Competent decisions (and/or awarding grades) should not be altered in any way. That is to say, the standards expected should be the same irrespective of the group and/or individual being assessed (Disability Standards for Education 2005).
Skill Recognition and Credit Transfer
Appropriate credit(s) may be granted to eligible students against each unit of competency on presentation of evidence of successful completion of the same unit in an equivalent or higher qualification. Under the Australian Qualifications Framework, this qualification recognises competencies achieved as part of a Nationally Recognised Qualification from other institutes or universities.
Students may also apply for Recognition of Prior Learning (RPL) by providing evidence that they have the required skills and knowledge in the specific areas of competency through work/industry experience and/or completed eligible assessments in equivalent or higher qualification.
Please refer to college’s RPL/Credit Transfer Policy for more information and applicable procedures. The policy is available either through the faculty coordinator or college’s website
Academic Policies and Procedures
Applicable policies and procedure related to this course including plagiarism, assessments, appeals and complaints, can be found with the course coordinator as well as in the “Policies and Procedures” section of the college’s website.
Submission of Work
All the written works must be submitted in a hard copy, and an additional soft/electronic copy if required by the trainer/assessor, with an accompanying “Assessment Cover Sheet”. Each Assessment Cover Sheet should be signed by the student and must contain student details and date of submission.
Material submitted for assessment—Word processed assignments, reports, essays, projects, etc. must contain student’s name, ID (if available). Within the context of these assessment tasks, the assessor fulfils the role of client, manager or supervisor, as applicable. Work submitted for “approval” within this context must demonstrate care and attention to detail, such that the student inspires confidence that the work is being undertaken competently.
Where soft copy/electronic files are submitted, students are encouraged to name the files according to established procedure. This would typically include a course or unit code, assessment or submission code, and in the case of multiple files an alphanumeric identifier. Multiple files may also be required to be submitted within an enclosing folder (with similar, appropriate naming conventions) or archive format—e.g. zip. Follow submission guidelines in each assessment task for specific instructions.
This unit describes the skills and knowledge required to use spreadsheet software to complete business tasks and produce complex documents.
It applies to individuals employed in a range of work environments who require skills in creation of complex spreadsheets to store and retrieve data. They may work as individuals providing administrative support within an enterprise or may be independently responsible for designing and working with spreadsheets relevant to their own work roles.
On successful completion of this unit, the learner/trainee will be able to;
- Prepare to develop spreadsheet
- Develop a linked spreadsheet solution
- Automate and standardise spreadsheet operation
- Use spreadsheets
- Represent numerical data in graphic form
As well as demonstrating the performance criteria, to be assessed as competent, the learner must demonstrate their ability to apply the required knowledge and skills in a range of situations. These are summarised in the Competency Standards section below.