BSBTEC302 V2 AE2 Feedback Courtney Cannon 344014035 (1)

.pdf

School

TAFE NSW - Sydney Institute *

*We aren’t endorsed by this school

Course

BSBTEC302

Subject

Accounting

Date

Jan 9, 2024

Type

pdf

Pages

7

Uploaded by CaptainJaguarPerson166

Report
Resource ID: BSBTEC302_DL_MD_V2 FeedbackTemplate_Pro2of2 OFFICIAL OFFICIAL BSBTEC302 V2 Design and Produce Spreadsheets Assessment event 2: Project Student name - number Courtney Cannon 344014035 Overall Assessment Feedback: Some great work in this assessment. There were however, areas in which I identified could be improved and for this reason, I have requested more evidence from you. Please refer to the feedback in the table below. Areas that require review have been highlighted for ease of reference. Should you have any queries, please contact the Accounting Help Desk on 02 7920 1051 (select option 3 to talk to a Teacher) between 8:30am to 4:45pm Monday to Friday and until 8pm Tuesday and Wednesday evenings. We will allow you one final attempt and opportunity to resubmit your entire assessment. Before resubmitting this assessment, you must email it to us for review: Email to: tafedigital.accounting@tafensw.edu.au Subject line: (your TAFE ID) BSBTEC302 review 2nd attempt Project 2 Please wait for feedback by email before uploading your second attempt as further attempts are not permissible. Assessment outcome Satisfactory More evidence required Unsatisfactory Assessor name and date: Lisa Rice 10/10/2023
Resource ID: BSBTEC302_DL_MD_V2 FeedbackTemplate_Pro2of2 OFFICIAL OFFICIAL Task number Did the student do the following? Result S/US Assessor comments Record your comments in enough detail to demonstrate your judgement of the student's performance against the criteria required. Part 1 Store spreadsheets Task 1 Create a folder for the project named BSBTEC302 Assessment 2 S Well done. Folder contained the files downloaded file. Task 3 Download the required data file BSBTEC302_AE_Data.xlsx S Task 4 Save the downloaded file to designated folder. S Task 5 Provide a screenshot of the assessment folder showing the downloaded data file. S Part 2 Help Screens 1 Use Help to find out how to wrap text in a cell S Image supplied of how to wrap text in a cell. The summary of steps demonstrated your understanding. Help also used to search for grouping selected worksheets. 2 Provide a screenshot of the Help topic. S 3 In your own words, summarise the steps to wrap text in a cell. S 4 Use the Help function to find out how to group selected worksheets. Provide a screenshot of the Help topic. S Part 3 Spreadsheet plan for monthly sales
OFFICIAL OFFICIAL Task number Did the student do the following? Result S/US Assessor comments Record your comments in enough detail to demonstrate your judgement of the student's performance against the criteria required. Task 3.1 Plan the spreadsheet by providing all relevant details in the template (Table 2 – Spreadsheet plan 1). S Task 3.2 1 The most appropriate software selected Monthly sales – June and July 2 Data from the A2 Sheet 1 worksheet copied/typed onto separate sheets for June and July. U You were supposed to remove all other tabs and raw data. This is a report that staff use, so don’t have excess tabs. 3 Worksheet tab names reflect the month (for example, June Sales). U Sheets were appropriately named. Only June and July tabs are needed. 4 Add a new column and add a label: Total Sales. Add a formula to calculate the total sales for each Sales Representative. S Total sales for the region / sales representative created using the SUM function. 5 Below the data, add a new label: Weekly Total. Add a formula to calculate the totals for each week. S Totals sales for each week (column) created using the SUM function. 6 Format column headings following the Gelos Style Guide S Column headings for formatted in accordance with the style guide 7 Adjust column widths so all data is appropriately displayed S All headings and data were visible. 8 Apply middle alignment to all headings S Headings were aligned to the middle. .
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help