spreedsheet 1

Week # 6 - Chapter # 10 Assignment

This week we will see: Chapter 10: Troubleshooting Workbooks and Automating Excel Applications.

This week we cover the Level 1 and 2 of Chapter Ten of your textbook. Before you start on the Excel exercises be sure to read and make sure you understand the Chapter Introduction and VERY IMPORTANT, the Case Scenario on page 606. Power Points are available in Blackboard Lectures and, video tutorials guiding you through the Learning part of each level of each chapter are available on youtube.com. .

Let's get started: ==========================================================================================

Week # 6 - Chapter # 10 Assignment

Chapter # 10 - Level 1: Objectives (Pages 604 – 630)  Plan an Excel application  Control data-entry errors  Protect worksheets and workbooks  Document workbooks

Level One: LEARNING

Read the Chapter Introduction and Case Scenario on page 606. Read it 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.

The material covered the Case Scenario in Level 1 (pages 604 - 630) “Automating Excel Tasks”.

You should read learning material on pages 604 to 630 and the youtube.com video tutorial for this level. Use the attached presentation in Level 1 to see the video Level 1: “Preparing Error-Free Workbooks” Or use the link: https://www.youtube.com/watch?v=_j3GnzjNlek&list=PLnz4OKywJPqsAcTWt_cFbq8pArR8au

h8d&index=28

Level One: PRACTICE: In the Week # 6 - Chapter 10 - Exercises.pdf document, make the Exercise Ch10-1: Level 1 – Helmet Template Post your completed file to Blackboard for review and grading. The file Name should be 10-1-Helmet-Template-YourName.xlsx POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)

Level One: APPLYING: In the Week # 6 - Chapter 10 - Exercises.pdf document, make the Exercise Ch10-2: Level 1 – Projected Sales and Commissions for CKG Auto Post your completed file to Blackboard for review and grading. The file Name should be 10-2-Scrapbooking-Payroll-YourName.xlsx.

POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)

==================================================================

Week # 6 - Chapter # 10 Assignment

Chapter # 10 - Level 2: Objectives (Pages 631 – 645)  Audit formulas for accuracy and validity  Evaluate and trace formula errors  Identify, analyze, and correct errors  Set error-checking options

Level Two: LEARNING Read the Chapter Introduction and Case Scenario on page 606. Read it 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.

The material covered the Case Scenario in Level 1 (pages 631 - 645) “Identifying and Correcting Formula Errors”.

You should read learning material on pages 631 to 645 and the youtube.com video tutorial for this level. Use the attached presentation in Level 2 to see the video Level 2: “Identifying and Correcting Formula Errors” Or use the link: https://www.youtube.com/watch?v=uAgFE6bchuw&list=PLnz4OKywJPqsAcTWt_cFbq8pArR8a

uh8d&index=30

Level Two: PRACTICE: In the Week # 6 - Chapter 10 - Exercises.pdf document, make the Exercise Ch10-3: Level 2 –Cost of Goods Sold. Post your completed file to Blackboard for review and grading. The file Name should be 10-3-COGS-Template-YourName.xlsx POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)

Level Two: APPLYING: In the Week # 6 - Chapter 10 - Exercises.pdf document, make the Exercise Ch10-4: Level 4 – Troubleshooting Formulas in a Job Invoicing

Workbook for David’s Computer Repair Post your completed file to Blackboard for review and grading. The file Name should be 10-4-Repair-Invoicing-YourName.xlsx.

POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)

==================================================================

Week # 6 - Chapter # 10 Assignment

Create a Word Document 6-Essay-Chapter10-YourName to answer the following questions for Chapter# 10 Level 1-2. POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)

1. What is a decision support system? 2. Data validation can be used to minimize this type of mistake when creating Excel applications. 3. What is a data validation rule? When would you use the Circle Invalid Data feature? 4. What is the difference between an input message and an error alert in the context of Excel data validation? 5. What style of error alert prevents a user from storing an invalid entry in a worksheet?

Week # 6 - Chapter # 10 Assignment

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: 10-1-Helmet-Template-YourName.xlsx (20 points) 10-2-Scrapbooking-Payroll-YourName.xlsx (20 points) 10-3-COGS-Template-YourName.xlsx (20 points) 10-4-Repair-Invoicing-YourName.xlsx (20 points) 6-Essay-Chapter10-YourName.docx (Questions requested) (20 points)