Demonstrate skills in creation of complex spreadsheets to store and retrieve data.

business

Description

BSBITU402 Develop and Use complex spreadsheets

 

ASSESSMENT 1: PORTFOLIO (AT1)

 

PORTFOLIO COVER SHEET

CANDIDATE’S NAME:

 

I declare this evidence has been produced by the undersigned and that whilst completing the tasks my work space, furniture and equipment were adjusted to suit my personal requirements. (See self assessment below.)

 

Candidate’s Signature: _________________________________  Date Submitted:  _____________

ASSESSOR’S NAME AND TEACHING AREA: Vinesh Saiboo, IT, Business

Evidence to be presented:

 

Element

Satisfactory (S) /

Not Satisfactory (NS)

Comments

Task 1 -  Select and prepare resources

EL 1

P.C 1.1-1.4

 

 

 

Ergonomic Checklist

As above

 

 

 

Spreadsheet Specifications

As above

 

 

 

Task Requirements

As above

 

 

 

Resource Conservation

As above

 

 

 

Task 2 –

Develop linked spreadsheet application

 

EL 2

P.C 2.1 -2.4

 

 

 

 

Question 1

As above

 

 

 

Question 2

As above

 

 

 

Question 3

As above

 

 

 

Question 4

As above

 

 

 

Question 5

EL 2

P.C 2.1 -2.4

 

EL 3

P.C 3.1 – 3.4

 

EL 4

P.C 3.1 – 3.4

 

 

 

 

 

Question 6

As above

 

 

 

Question 7

As above

 

 

 

Question 8

As above

 

 

 

Question 9

As above

 

 

 

Question 10

As above

 

 

 

Question 11

As above

 

 

 

Question 12

As above

 

 

 

Question 13

As above

 

 

 

Question 14

As above

 

 

 

Question 15

As above

 

 

 

Question 16

As above

 

 

 

Question 17

As above

 

 

 

Question 18

As above

 

 

 

Task 3 -

Automate and standardise spreadsheet operation

 

EL 3

P.C 3.1 – 3.4

 

 

 

 

Question 19

As above

 

 

 

Question 20

As above

 

 

Instruction Files
AT1.doc
300.0 KB

Related Questions in business category

Get Higher Grades Now
251 Tutors Online
Description

Cookies Use

We use cookies to ensure a smooth browsing experience. By continuing we assume you accept the use of cookies.

Okay