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 |
|
|
Get Free Quote!
426 Experts Online
| ||
