year 1 (units 1 & 2) teacher resource - ivet · pdf file · 2017-11-03vet...

VET Information and Communication Technology YEAR 1 (Units 1&2)- TEACHER RESOURCE

Copyright © IVET 2018 Edition 1

Innovative Vocational Education and Training Institute

VET INFORMATION AND COMMUNICATIONS

TECHNOLOGY

YEAR 1 (UNITS 1 & 2)

TEACHER RESOURCE

CERTIFICATE III (ICT30115)

CORE COMPETENCIES and SELECTED ELECTIVES



HOW TO USE YOUR

TEACHER RESOURCE

The teacher resource contains:

ü Instructions for Assessment

ü Suggested answers for some of the student workbook activities

ü Software requirements for each unit

•***IVET grants permission for this page to be photocopied by the purchasing school for the 2018 school year

Please note - Only pages that have the following copyright waiver, can be photocopied by the purchasing school:



CONTENTS

IMPORTANT ASSESSMENT INFORMATION ***To be read prior to beginning your VET in schools program 4 Software requirements 8 ELECTIVE UNIT CHAPTER 1 ICTICT203 - Operating application software packages 9 CORE UNITS CHAPTER 2 BSBWHS304 - Participate effectively in WHS communication and consultation process 18 CHAPTER 3 ICTICT202 - Work and communicate effectively in an ICT environment 23 CHAPTER 4 ICTSAS301 - Run standard diagnostic tests 33 ELECTIVE UNIT CHAPTER 5 ICTWEB303 - Produce digital images for web 41 ELECTIVE UNITS (Optional) CHAPTER 6 ICTWEB201 - Use social media tools for collaboration 43 CHAPTER 7 BSBSUS301 - Implement and monitor environmentally sustainable work practices 50 CHAPTER 8 ICTSAS303 - Care for computer hardware 54 CHAPTER 9 BSBWOR301 - Organise personal work priorities and development 58



IMPORTANT INFORMATION

HOW TO COMPLETE YOUR IVET INSTITUTE ASSESSMENTS As a Registered Training Organisation (RTO) the IVET Institute is required to ensure that all of our VET in school students complete compliant assessments that have been thoroughly mapped in accordance with ASQA’s (the National VET regulator) requirements. This assessment must be completed for every student for every unit of competency completed. Your students will be provided with all assessment materials online through IVET’s on line portal IVETConnect (www,ivetinstitute.com.au). Students are required to log in with the secure password given to them by IVET and complete all of their assessment online. Each student is required to complete every assessment that is part of your schools program. All assessors are required to mark the students work on line and competency cannot be achieved until this occurs. All other materials provided by IVET, including student and teacher resources, are to support you in your teaching; we do not require any tasks, assignments or activities from these resources. LOGGING IN 1. Prior to completing any assessment tasks, trainer must first set up their classes on line. This is a very easy

process and can be completed in three simple steps. 2. Trainers are to access the IVET Connect logo located on the IVET Institute website. www.ivetinstitute.com.au

3. Trainers will need to enter their Login and Password details to access IVET Connect. (this code has been sent

to all trainers via email)



HOW TO SET UP A CLASS Trainers are to then select the icon at the top of the triangle named SET UP AND MANGE MY CLASSES and follow the structure of setting up a class. Only students names and your class name need to be entered.

HOW TO COMPLETE AND ACCESS TRAINER QUALIFICATIONS The teacher dashboard allows trainers to access all of their qualifications in PDF format that have been stored from past years as well as complete new qualification updates. Note: Trainers will not be able to assess students until qualifications have been approved

HOW TO LOCATE STUDENT LOG IN DETAILS

1. 2.



HOW TO ACTIVATE ASSESSMENTS

1. 2. HOW TO MARK ASSESSMENTS ON LINE

1. 2. STUDENTS PROGRESS

1. 2.

3. Note: Tutorials can be found on how to use IVET Connect detailing what are all features of this system on each section of IVET Connect. Simply select the tutorial or for further information contact IVET



SOFTWARE REQUIRED TO COMPLETE THIS COURSE The following is a list of software required to complete activities in the student handbook. All units require a web browser, a word processor and a PDF reader. Chapter 1 - Operating application software packages

• Spread sheet software • Database software

Chapter 2 – Participate effectively in OHS communication and consultative processes

• Presentation software

Chapter 3 - Work and communicate effectively in an I.T. environment

• Advanced Office Password Recovery • Database software

Chapter 4 – Run standard diagnostic tests

• Spread sheet software • Presentation software • Prime95 • HWMonitor • Backup software (x2) – students choose their own • Anti-Malware suites (x3) – students choose their own

Chapter 5 – Produce digital Images for web

• Presentation software • Spread sheet software • Adobe Photoshop CS6 or greater

Chapter 6 - Use social media tools for collaboration

• No specific software required Chapter 7- Implement and monitor environmentally sustainable work practices

• No specific software required Chapter 8 -Care for computer hardware

• Cleaner Chapter 9 - Organise personal work priorities and development

• Spread sheet software



Operate Application Software Packages – Assessment Guide

Activity Answers Product or answers demonstrate satisfactory understanding of the topic

1.0 – Exercises for computer users • Six exercises shown with o Images o Description o Instructions

• Satisfactory grammar and document formatting

1.1 – Lighting in the office • All six lighting hazards explained • Ways to reduce each issue recommended • Satisfactory grammar and document formatting • Diagrams explaining aspects of two hazards • 300 – 350 words

1.2 – Workstation desk layout • All three desk setup aspects explained in appropriate detail • Diagrams included for all aspects • Satisfactory grammar and document formatting • Diagrams explaining aspects of two hazards • 300 – 350 words

Review questions Set 1 • All questions answered with appropriate detail • Satisfactory grammar and document formatting

1.3 – Word processes • All aspects of table researched and filled in correctly

1.4 – Folders • Folders created as required

1.5 – Word file types • All aspects of table researched and filled in correctly

1.6 – Sign up for cloud storage • Signed up to appropriate cloud storage

1.7 – MS Word home tab • All aspects of 15 icons described correctly • Satisfactory grammar and document formatting

1.8 – Recreate this document Document contains less than five errors from the original – • Header • Title • Normal • Heading 1 • Heading 2 • Heading 3 • Bold and top border • Italics and indented • Size 16 and highlighted grey 50% • Coloured Black, Text 1, Lighter 50% • Center Align • Right Align • Paragraph Line Spacing of 1 • Numbers List • Comic Sans Font • Table of 3 rows and 2 columns, text aligned right • Autofit contents • Table border White, background 1, 25% • Text box with dash dot border • Footer

1.9 – Creating logo • Large list of words and ideas relating to the logo design • At least three different designs attempted • Colour used on final design • Final logo scanned to create electronic version



1.10 – Letter template • Letter following block template outline • Satisfactory information for new customer • No errors in spelling or grammar • Logo included

1.11 – Bill template • Logo included • Bill follows bill template • Effective use of tables and shading • Bar chart used to show data downloads • Satisfactory grammar or document formatting

1.12 - Questionnaire • Logo used • Consistent formatting with other documents • Two questions for each area of feedback

1.13 – ISP brochure • All information included about the ISP • Logo placed on brochure • High quality images used • Satisfactory grammar or document formatting

1.14 – Mail merged Letter • Successfully use the mail merge wizard to insert the data from the spreadsheet into the word document.

• Print off all six letters

1.15 - Manipulating cells • Cell heading included • Fill included • Borders included • Columns fit contents of cells • Five names included

1.16 – Using excel for mathematical equations

• All four functions used appropriately • Found the final answer of 15583.59 • Borders included • Fill colour included • Headings included

1.17 – Water usage • Cells formatted to match image shown • RANDBETWEEN function used correctly • MIN/MAX functions used correctly • AVERAGE function used correctly • Formatting of cells changed to 2 decimal places

1.18 – Students grades - IF • IF used correctly • COUNTIF used correctly • NESTED IF used correctly • Headings and data entered correctly

1.19 – Student grades - VLOOKUP • VLOOKUP used correctly

1.20 – Conditional formatting • Data bar conditional formatting used appropriately • Cells highlighted correctly • Icon sets used for number of tests passed

1.21 – Student grades - Charts • Charts used appropriately to display data for Test 1 and 2 • Includes names, legend and title

1.22 – ISP download data • Table formatted appropriately • NESTED IF used to display cost and data • COUNTIF used to count data plans purchased • SUM/MIN/MAX and AVERAGE used as required • Conditional formatting used as required • VLOOKUP used to provide description • Charts created for each user


Act 1.23 – DVD database - Table • Table setup with appropriate fields • Lookup tables used where appropriate • All five records entered appropriately

Act 1.24 – DVD database - Form • Label inserted onto form



• Fields resized appropriately • Date and name included • Field placed in logical order

Act 1.25 – Data validation • Ten DVD records created • Validation rules set for each field

Act 1.26 – Rating and dist. forms • Two tables created • Two forms created • Data entered into both tables (using form)

Act 1.27 – DVD database – Queries • All 15 queries created • Correct record shown for each query

Act 1.28 – Advanced queries • All ten queries created • Correct record shown for each query

Act 1.29 - DVD database – Reports • Reports created for all queries in database • Report takes up 1page width • Column widths set so that all data is visible • Grouping levels used as required • Report headers included on each report

Act 1.30 – ISP database • Four tables created • Four forms created • Six queries created • Six reports created • Forms and reports formatted appropriately




CHAPTER 1 - REVIEW QUESTIONS (SET 1)

1. Define the term ‘ergonomics’. Ergonomics is the study and science of how equipment and environment interacts with and affects the human body.

2. Give two benefits of using LCD monitors over CRT monitors.

• Lower radiation output • Lower power usage • Take up less space on the desk

3. What is the purpose of a footrest? To allow the user to rest their feet flat if they cannot reach the floor.

4. What is ‘Occupational overuse syndrome’ and how can it be avoided? Occupational overuse syndrome is a condition related to performing the same action repeatedly over a long period of time, causing pain and soreness in the affected area.

5. List three possible causes of noise in an office area / I.T. environment

• People having loud conversations • Printers and photocopiers • Air-conditioners / Toilets

6. Draw and label diagram that shows the position and angle or the back, hips, knees and ankles that

should be used when sitting at a computer desk. Sample:

7. What is the purpose of a document holder?



Document holders are placed to the left/right of the monitor and are used to hold documents at eye level, minimising head and neck movement.

8. How often, and for how long, should exercise breaks be implemented? Exercise breaks (such as walking around) should be implemented roughly every 20-30 minutes, and should last for about 20-30 seconds.

9. In what units is light intensity measured? Light is measured in units of Lux (lx).

10. What is ‘glare’ and how can it be avoided? Glare is caused by differences from one area to another, and usually occurs if a monitor is placed directly in front of a window. This can be avoided by using blinds or placing the monitor perpendicular to the light source.

11. What body positions are associated with bad posture while sitting at a computer? Examples of bad posture while at the computer include:

• Leaning too far forward • Hunching over the keyboard • Leaning back with feet on the desk

12. How should the height of the monitor be adjusted?

The monitor height should be adjusted so that the top of the monitor is at eye level when the user looks directly forward.



WORD PROCESSORS

Software Required: • None

Periods Required

• One

Instructions • Use the internet to fill in the table below for each of the main word processing applications

Name Developer Latest Version

Default file

type URL Price Suite

Word Microsoft As found docx http://office.microsoft.com/en-au/word/

AUD $209

Office

Writer The document foundation

As found .odt http://www.libreoffice.org/features/writer/ Free LibreOffice

Pages Apple As found .pages http://www.apple.com/iwork/pages/ USD

$19.99 iWork

year 1 (units 1 & 2) teacher resource - ivet · pdf file · 2017-11-03vet...

Documents