Assessor Resource

ICTICT105
Operate spreadsheet applications

Assessment tool

Version 1.0
Issue Date: December 2018


This unit describes the skills and knowledge required to use spreadsheet applications, including creating spreadsheets, formatting data, incorporating charts and objects, and printing spreadsheets.

It applies to individuals who perform a range of routine tasks in the workplace using a fundamental knowledge of spreadsheets under direct supervision or with limited responsibility.

No licensing, legislative or certification requirements apply to this unit at the time of publication.

You may want to include more information here about the target group and the purpose of the assessments (eg formative, summative, recognition)



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.

ELEMENT

PERFORMANCE CRITERIA

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Create spreadsheets

1.1 Open the spreadsheet application, create spreadsheet files and enter numbers, text and symbols into cells according to information requirements

1.2 Enter simple formulas and functions using cell referencing when required

1.3 Correct formulas when error messages occur

1.4 Use a range of common tools during spreadsheet development

1.5 Edit columns and rows within the spreadsheet

1.6 Use the auto-fill function to increment data where required

1.7 Save the spreadsheet to a folder on a storage device

2. Customise basic settings

2.1 Adjust page layout to meet user requirements or special needs

2.2 Open and view different toolbars

2.3 Change font settings so they are appropriate for the document purpose

2.4 Change alignment options and line spacing according to spreadsheet formatting features

2.5 Format cell to display different styles as required

2.6 Modify margin sizes to suit the purpose of the spreadsheets

2.7 View multiple spreadsheets concurrently

3. Format spreadsheet

3.1 Use formatting features as required

3.2 Copy selected formatting features from another cell in the spreadsheet or from another active spreadsheet

3.3 Use formatting tools as required within the spreadsheet

3.4 Align information in a selected cell as required

3.5 Insert headers and footers using formatting features

3.6 Save spreadsheet as another file type

3.7 Save to storage device and close spreadsheet

4. Incorporate object and chart in spreadsheet

4.1 Import an object into an active spreadsheet

4.2 Manipulate imported object by using formatting features

4.3 Create a chart using selected data in the spreadsheet

4.4 Display selected data in a different chart

4.5 Modify chart using formatting features

5. Print spreadsheet

5.1 Preview spreadsheet in print preview mode

5.2 Select basic printer options

5.3 Print spreadsheet or selected part of spreadsheet

5.4 Submit the spreadsheet to appropriate person for approval or feedback


Submission Requirements

List each assessment task's title, type (eg project, observation/demonstration, essay, assingnment, 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.

ELEMENT

PERFORMANCE CRITERIA

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Create spreadsheets

1.1 Open the spreadsheet application, create spreadsheet files and enter numbers, text and symbols into cells according to information requirements

1.2 Enter simple formulas and functions using cell referencing when required

1.3 Correct formulas when error messages occur

1.4 Use a range of common tools during spreadsheet development

1.5 Edit columns and rows within the spreadsheet

1.6 Use the auto-fill function to increment data where required

1.7 Save the spreadsheet to a folder on a storage device

2. Customise basic settings

2.1 Adjust page layout to meet user requirements or special needs

2.2 Open and view different toolbars

2.3 Change font settings so they are appropriate for the document purpose

2.4 Change alignment options and line spacing according to spreadsheet formatting features

2.5 Format cell to display different styles as required

2.6 Modify margin sizes to suit the purpose of the spreadsheets

2.7 View multiple spreadsheets concurrently

3. Format spreadsheet

3.1 Use formatting features as required

3.2 Copy selected formatting features from another cell in the spreadsheet or from another active spreadsheet

3.3 Use formatting tools as required within the spreadsheet

3.4 Align information in a selected cell as required

3.5 Insert headers and footers using formatting features

3.6 Save spreadsheet as another file type

3.7 Save to storage device and close spreadsheet

4. Incorporate object and chart in spreadsheet

4.1 Import an object into an active spreadsheet

4.2 Manipulate imported object by using formatting features

4.3 Create a chart using selected data in the spreadsheet

4.4 Display selected data in a different chart

4.5 Modify chart using formatting features

5. Print spreadsheet

5.1 Preview spreadsheet in print preview mode

5.2 Select basic printer options

5.3 Print spreadsheet or selected part of spreadsheet

5.4 Submit the spreadsheet to appropriate person for approval or feedback

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
Open the spreadsheet application, create spreadsheet files and enter numbers, text and symbols into cells according to information requirements 
Enter simple formulas and functions using cell referencing when required 
Correct formulas when error messages occur 
Use a range of common tools during spreadsheet development 
Edit columns and rows within the spreadsheet 
Use the auto-fill function to increment data where required 
Save the spreadsheet to a folder on a storage device 
Adjust page layout to meet user requirements or special needs 
Open and view different toolbars 
Change font settings so they are appropriate for the document purpose 
Change alignment options and line spacing according to spreadsheet formatting features 
Format cell to display different styles as required 
Modify margin sizes to suit the purpose of the spreadsheets 
View multiple spreadsheets concurrently 
Use formatting features as required 
Copy selected formatting features from another cell in the spreadsheet or from another active spreadsheet 
Use formatting tools as required within the spreadsheet 
Align information in a selected cell as required 
Insert headers and footers using formatting features 
Save spreadsheet as another file type 
Save to storage device and close spreadsheet 
Import an object into an active spreadsheet 
Manipulate imported object by using formatting features 
Create a chart using selected data in the spreadsheet 
Display selected data in a different chart 
Modify chart using formatting features 
Preview spreadsheet in print preview mode 
Select basic printer options 
Print spreadsheet or selected part of spreadsheet 
Submit the spreadsheet to appropriate person for approval or feedback 

Forms

Assessment Cover Sheet

ICTICT105 - Operate spreadsheet applications
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

ICTICT105 - Operate spreadsheet applications

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: