BSBTEC302 V2 AE2 Feedback Courtney Cannon 344014035 (1)
.pdf
keyboard_arrow_up
School
TAFE NSW - Sydney Institute *
*We aren’t endorsed by this school
Course
BSBTEC302
Subject
Accounting
Date
Jan 9, 2024
Type
Pages
7
Uploaded by CaptainJaguarPerson166
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
Related Questions
I need help with B, C, D on the attached assignment
arrow_forward
Ethics case: Uncollectible Accounts
Introduction
The purpose of this discussion forum is to give you an opportunity to apply your critical-thinking ability to the knowledge you’ve gained. The assignment provides you with an opportunity to develop your research, analysis, judgment, and communication skills. You also will work with other students, integrate what you’ve learned, apply it in real-world situations. This practice will broaden your knowledge and further develop your decision-making abilities. The assignment achieves learning objective 5.
The assignment information is given below;
You have recently been hired as the assistant controller for Stanton Industries, a large, publicly held manufacturing company. Your immediate superior is the controller who, in turn, is responsible to the vice president of finance. The controller has assigned you the task of preparing the year-end adjusting entries. In the receivables area, you have prepared an aging of accounts receivable and have…
arrow_forward
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
arrow_forward
Please I want answer for this question by your understanding and experience in this field and typing it. Thanks
arrow_forward
PLEASE USE EXCEL ON ANSWERING THE QUESTIONS. MAKE SURE TO TAKE A SCREENSHOT STEP BY STEP OF HOW YOU DID THE SOLUTIONS IN EXCEL. ANSWER THIS COMPLETELY TO GET AN UPVOTE. I POSTED A LOT OF THIS, IF YOU SEE THIS AGAIN, YOU CAN SEND THE SAME SOLUTIONS, I WILL STILL UPVOTE DO NOT WORRY, JUST GIVE ME THE CORRECT SOLUTIONS AND ANSWERS.
I REPEAT, ONLY EXCEL
arrow_forward
Hi, I attempted this question but didn't get some parts correct. Can you help me so I can see where my mistakes were made? I've attached a picture of the problem and what they're asking for. Thanks!
arrow_forward
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
arrow_forward
Is this an equation I have deducted from an answer provided by a tutor? If it is right, what is it for because I’ve since been given these other formulas in the second pic
arrow_forward
Search for tools, help, and more (Alt + O
IMPORTANT: Answer grading policy
For an answer to be graded as correct, you must use an Excel formula:
1. Begin each formula with an = sign.
2. Reference cells, instead of entering values.
Example: =B3+C3
OK
☑
15
arrow_forward
or students doing a Project Study and students doing an internship, prepare a journal entry sharing your reflections on your experience in collecting the (primary) data you collected for your research.
For students doing a Systematic Review prepare a journal entry sharing your reflections on your experience in collecting the (secondary) data you collected from your selected resources.
You are to follow Gibb’s Reflective Cycle as your guide in laying out your reflection.
arrow_forward
Imagine you are the project manager at an investment firm and given the task of preparing a report (essay) addressing several companies' projects' evaluations. Use the supplied information for each project to answer the associated questions. Your deliverable is a professionally prepared MS Excel file, MS Word report (essay) applying APA 7 formatting and a quick information sheet. In your recommendation/conclusion of your report identify the best project to invest in and give reasons why. The quick information sheet is this document with the blanks filled out for each question area.
Harris Dance Company, Inc., a manufacturer of dance and exercise apparel, is considering replacing an existing piece of equipment with a more sophisticated machine. The following information is given.
The firm pays 40 percent taxes on ordinary income and capital gains.
Project 2 Questions:
1) Calculate the book value of the existing asset being replaced.
2) Calculate the tax effect from the sale…
arrow_forward
Imagine you are the project manager at an investment firm and given the task of preparing a report (essay) addressing several companies' projects' evaluations. Use the supplied information for each project to answer the associated questions. Your deliverable is a professionally prepared MS Excel file, MS Word report (essay) applying APA 7 formatting and a quick information sheet. In your recommendation/conclusion of your report identify the best project to invest in and give reasons why. The quick information sheet is this document with the blanks filled out for each question area.
Carolina Company, Inc. is considering purchasing a new gluing machine. The gluing machine costs $50,000 and requires installation costs of $2,500. The sale of an existing gluer would partially offset this outlay. The existing gluer originally cost $10,000 and is four years old. It is being depreciated under MACRS using a five-year recovery schedule and can currently be sold for $15,000. The existing gluer…
arrow_forward
Q1: Write an e-mail to technical support team of your college to retrieve your login
credentials. In order to make your e- mail effective mention all the important details and
reasons to prioritize your response
arrow_forward
Please see below. I need help with this excel sheet. Please note that this problem requires cell referencing and particular formulas to get the correct answers. Please be sure to include these items.
arrow_forward
Required information
Excel Analytics 12-01 (Algo) Internal Rate of Return [LO12-2, LO12-3]
To complete this activity, you will need to have Excel installed on your computer. This exercise requires you to work in
Excel and answer questions in Connect. You will read a brief scenario and then download an Excel file that you will need
to complete the requirements in Parts 2 and 3 of this exercise.
Some of the requirements include brief video tutorials on using Excel functions. After viewing the tutorials, you will then
use what you learned to work directly in Excel to answer the required questions in Connect.
Henderson Company has an opportunity to manufacture and sell a new product for a five-year period. The company
estimated the following costs and revenues for the new product:
Cost of new equipment
Initial working capital required
$420,000
$125,000
Overhaul of the equipment after three years
$50,000
Salvage value of the equipment after five years.
$30,000
Annual revenues and costs:…
arrow_forward
Instructions:
Imagine you are the project manager at an investment firm and given the task of preparing a report (essay) addressing several companies' projects' evaluations. Use the supplied information for each project to answer the associated questions. Your deliverable is a professionally prepared MS Excel file, MS Word report (essay) applying APA 7 formatting and a quick information sheet. In your recommendation/conclusion of your report identify the best project to invest in and give reasons why. The quick information sheet is this document with the blanks filled out for each question area.
Project 1
Callaloo Collaborators, Inc. has been considering several capital investment proposals for the year beginning in 2019. For each investment proposal, the relevant cash flows and other relevant financial data are summarized in the table below. New assets will be depreciated under the MACRS system rather than being fully expensed right away. In the case of a replacement decision, the…
arrow_forward
Can you help solve this problem. I have one more try.
arrow_forward
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
arrow_forward
Uploaded
arrow_forward
Depending on the way your practice works, you may need to give team members different access levels based on their roles.
What are the 3 levels of access that can be granted to Team users of QuickBooks Online Accountant?
Full access
VIP access
Basic access
Custom access
Standard access
arrow_forward
Hello tutor. I hope you doung fine. Can you please include a step by step process with formula. Thank you
arrow_forward
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
arrow_forward
Knowledge Check 01
Select the correct order of the following steps in the decision-making process.
1. Evaluate the costs and benefits of the alternatives
2. Determine the decision alternatives
3. Identify the decision problem
4. Review the results of the decision
5. Make the decision
arrow_forward
How would I calculate this problem? I just guessed on which answer made sense to me. Please help. thank you in advance.
arrow_forward
Case Study: Riversdale College Learning Management SystemTraditional face‐to‐face teaching still plays a critical role in teaching and learning, howeverchallenges such as COVID‐19 has necessitated the introduction of Learning Management Systems(LMS) in higher educational institutions at a large scale. An LMS is a software system designed toaid teaching and learning which operates in the World Wide Web, hence, having the flexibility ofanytime access (Ho, Higson, Dey & Xu, 2009). Riversdale College has invested in a Learning Management system in order to create, share andmanage the delivery of educational content. The LMS goal is in enhancing teaching and learning.The main aim of Riversdale College is to provide excellent educational opportunities that areresponsive to the needs of a demographically diverse student population and equip them toexceed challenges as active participants in shaping the future of our world. Riversdale Collegeuses the LMS in more innovative ways like…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L
Related Questions
- I need help with B, C, D on the attached assignmentarrow_forwardEthics case: Uncollectible Accounts Introduction The purpose of this discussion forum is to give you an opportunity to apply your critical-thinking ability to the knowledge you’ve gained. The assignment provides you with an opportunity to develop your research, analysis, judgment, and communication skills. You also will work with other students, integrate what you’ve learned, apply it in real-world situations. This practice will broaden your knowledge and further develop your decision-making abilities. The assignment achieves learning objective 5. The assignment information is given below; You have recently been hired as the assistant controller for Stanton Industries, a large, publicly held manufacturing company. Your immediate superior is the controller who, in turn, is responsible to the vice president of finance. The controller has assigned you the task of preparing the year-end adjusting entries. In the receivables area, you have prepared an aging of accounts receivable and have…arrow_forwardhelp please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all workingarrow_forward
- Please I want answer for this question by your understanding and experience in this field and typing it. Thanksarrow_forwardPLEASE USE EXCEL ON ANSWERING THE QUESTIONS. MAKE SURE TO TAKE A SCREENSHOT STEP BY STEP OF HOW YOU DID THE SOLUTIONS IN EXCEL. ANSWER THIS COMPLETELY TO GET AN UPVOTE. I POSTED A LOT OF THIS, IF YOU SEE THIS AGAIN, YOU CAN SEND THE SAME SOLUTIONS, I WILL STILL UPVOTE DO NOT WORRY, JUST GIVE ME THE CORRECT SOLUTIONS AND ANSWERS. I REPEAT, ONLY EXCELarrow_forwardHi, I attempted this question but didn't get some parts correct. Can you help me so I can see where my mistakes were made? I've attached a picture of the problem and what they're asking for. Thanks!arrow_forward
- help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all workingarrow_forwardIs this an equation I have deducted from an answer provided by a tutor? If it is right, what is it for because I’ve since been given these other formulas in the second picarrow_forwardSearch for tools, help, and more (Alt + O IMPORTANT: Answer grading policy For an answer to be graded as correct, you must use an Excel formula: 1. Begin each formula with an = sign. 2. Reference cells, instead of entering values. Example: =B3+C3 OK ☑ 15arrow_forward
- or students doing a Project Study and students doing an internship, prepare a journal entry sharing your reflections on your experience in collecting the (primary) data you collected for your research. For students doing a Systematic Review prepare a journal entry sharing your reflections on your experience in collecting the (secondary) data you collected from your selected resources. You are to follow Gibb’s Reflective Cycle as your guide in laying out your reflection.arrow_forwardImagine you are the project manager at an investment firm and given the task of preparing a report (essay) addressing several companies' projects' evaluations. Use the supplied information for each project to answer the associated questions. Your deliverable is a professionally prepared MS Excel file, MS Word report (essay) applying APA 7 formatting and a quick information sheet. In your recommendation/conclusion of your report identify the best project to invest in and give reasons why. The quick information sheet is this document with the blanks filled out for each question area. Harris Dance Company, Inc., a manufacturer of dance and exercise apparel, is considering replacing an existing piece of equipment with a more sophisticated machine. The following information is given. The firm pays 40 percent taxes on ordinary income and capital gains. Project 2 Questions: 1) Calculate the book value of the existing asset being replaced. 2) Calculate the tax effect from the sale…arrow_forwardImagine you are the project manager at an investment firm and given the task of preparing a report (essay) addressing several companies' projects' evaluations. Use the supplied information for each project to answer the associated questions. Your deliverable is a professionally prepared MS Excel file, MS Word report (essay) applying APA 7 formatting and a quick information sheet. In your recommendation/conclusion of your report identify the best project to invest in and give reasons why. The quick information sheet is this document with the blanks filled out for each question area. Carolina Company, Inc. is considering purchasing a new gluing machine. The gluing machine costs $50,000 and requires installation costs of $2,500. The sale of an existing gluer would partially offset this outlay. The existing gluer originally cost $10,000 and is four years old. It is being depreciated under MACRS using a five-year recovery schedule and can currently be sold for $15,000. The existing gluer…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE L
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L