Bsbtu402a Swot Analysis

2566 Words11 Pages
BSBITU402A Develop & use complex spreadsheets Assessment 2 Assignment 2 There are two parts to this assignment, Part A and Part B. Part A is compulsory. You must complete all tasks with Part A to be considered competent in this unit. If you wish to continue and be considered for a COMPETENT CREDIT or COMPETENT DISTINCTION you must complete Part B. Portfolio Task Compulsory Weighting Minimum Marks Required to achieve Competency 8 marks 26 marks 16 marks Part A, Task 1 Part A, Task 2 Part A, Task 3 Part B, Task 1 Part B, Task 2 TOTAL Yes Yes Yes No No 10 marks 30 marks 20 marks 35 marks 5 marks 100 marks 50 marks 2 LA014027, Assessment 2 – BSBITU402A – Develop and use complex spreadsheets ©New South Wales, Department of Education and Training 2011 Version 1, March 2011 Part A: What you have to do You are required to submit a portfolio of 3 tasks that demonstrates your ability to produce a variety of complex spreadsheets. These tasks incorporate a range of complex functions and design features. To be considered competent for this assessment, you must complete the three tasks to workplace standards. Part A, Portfolio Task 1 You would like to borrow $350,000 to purchase…show more content…
The workbook will be the platform on which future weekly pays will be calculated so it is imperative that you incorporate the concepts of sound spreadsheet design (as covered in your learning materials) within your spreadsheet. A. Create a new workbook. Sheet 1 will be your input area. In Sheet 1, enter the I. Commission Threshold table II. Employees, Standard Pay table Sheet 2 will be your work and output area. Within this sheet, you will create functions that reference the two tables created in Sheet 1 (your input area). Create a table in Sheet 2 that can be used to calculate the Total Pay including
Open Document