Week 5 Assignment
This week we cover Chapter 4 “Retrieving Data for Computation, Analysis, and Reference” where we will use the “Sales: Creating Product Order Forms for Equipment Purchases as the learning example. We will cover Levels 1 and 2 only.
Use the Chapter # 4 – Videos presentation to see the videos if you prefer.
NOTE: Create a Word Document 5-Essay-Week5-YourName for all the essay parts.
The Assignment has three parts:
Part A:
Read the Chapter Introduction and Case Scenario on page 212. Read this page very carefully. It is important that you clearly understand what the Chapter material is all about – otherwise you will just be putting numbers in cells. You might also want to watch the youtube.com video for this chapter.
Part B:
1. Study (LEARN) the material covered in Level 1: Accounting: Establishing a Credit Approval Process for Accounts Receivable on pages 214 to 240. The CH04 Level 1 Figures.xlsx file in Lectures (Student Data Files Chapter 4) replicates all the Figures in this section so you can easily follow along with the textbook discussions.
2. PRACTICE what you learned in the first part by completing the Steps to Success: Level 1 exercise starting on page 241. The starting workbook: PO527.xlsx needs to be downloaded from Lectures – (Student Data Files Chapter 4)
The result file Name should be 5-1-PO527 Credit Analysis.xlsx
POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)
3. APPLY what you have learned to a new business marketing situation by completing the Level 1 Case Problem on page 275 of your textbook. The starting workbook Hiring.xlsx needs to be downloaded from Lectures – (Student Data Files Chapter 4).
The result file Name should be 5-2-WWC Hiring Analysis.xlsx
POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)
4. Write a short essay on what you have learned in Level 1 and how you could apply this to other business situations. POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (10 POINTS)
Part C:
1. Study (LEARN) the material covered in Level 2: Analyzing Data Using IF Functions and Nested Functions on pages 177 to 194. The CH04 Level 2 Figures.xlsx file in Lectures (Student Data Files Chapter Three) replicates all of the Figures in this section so you can easily follow along with the textbook discussions.
2. PRACTICE what you learned in the first part by completing the Steps to Success: Level 2 exercise starting on page 256. The starting workbook: Unpaid.xlsx needs to be downloaded from Lectures – (Student Data Files Chapter 4).
The result file Name should be 5-3-Unpaid Invoice Penalties.xlsx
POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)
3. APPLY what you have learned to a new business marketing situation by completing the Level 2 Case Problem on page 277 of your textbook. You must create your own starting worksheet for this exercise.
The result file Name should be 5-4- Paint Calculator.xlsx
POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)
4. Write a short essay on what you have learned in Level 2 and how you could apply this to other business situations. POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (10 POINTS)
A Power Point review of Chapter 4 is posted in Lectures
==================================================================
Let me know if there is anything you don’t understand — the earlier the better. ALWAYS attach a copy of yours excel file clearly indicating where you have a problem.
The solution files that you need to attach are:
5-1-PO527 Credit Analysis.xlsx
5-2-WWC Hiring Analysis.xlsx
5-3- Unpaid Invoice Penalties.xlsx
5-4- Paint Calculator.xlsx
5-Essay-Week5-YourName.docx (With the short essays on what you learned in each Level)