Submit The Completed Excel Workbook For Week 3's Graded Proj

Submit Thecompleted Excel Workbookfor The Week 3 Graded Project You

Submit the completed Excel Workbook for the week 3 graded project. You will be completing Case 6: Mohopo Collections Inc. workbook from the textbook "Problem Solving Cases in Microsoft Access and Excel" (14th edition). This is a Microsoft Excel case study. A starting data file and notes on the required formulas are provided in the week 3 tutorial project link. The starting data file is only a starting point and not the completed workbook. The project will be graded based on worksheet formatting (10%), data entry (20%), calculations/formulas (50%), and scenario summary using Scenario Manager (20%). It is essential to read all of case 6 carefully before proceeding to complete the workbook.

Paper For Above instruction

The Week 3 graded project involves the comprehensive completion of a Microsoft Excel workbook related to Case 6: Mohopo Collections Inc., as outlined in the textbook "Problem Solving Cases in Microsoft Access and Excel" (14th edition). This project is designed to assess proficiency in data entry, worksheet formatting, formulation skills, and scenario analysis using Scenario Manager within Excel, which collectively bolster students' practical understanding of problem-solving using spreadsheet tools.

Introduction

Microsoft Excel remains an essential spreadsheet application widely used in business, finance, and data analysis domains. Proficiency in Excel encompasses skills ranging from basic data entry and formatting to advanced calculations and scenario analysis. The Case 6 project for Week 3 offers an integrative approach, requiring students to apply various skills in a practical, real-world context. The primary objective is to construct an accurate, well-formatted, and dynamic workbook capable of providing insights into Mohopo Collections Inc.'s financial scenario, using formulas, data management, and Scenario Manager.

Project Description and Objectives

The project tasks students with completing a partially filled worksheet, which involves four core activities:

  1. Worksheet Formatting: Ensuring the worksheet is clearly organized, visually appealing, and adheres to best practices in Excel formatting.
  2. Data Entry: Accurately inputting data into designated cells based on the starting data file and notes provided.
  3. Calculations and Formulas: Developing and implementing formulas to derive necessary financial metrics, forecasts, or other relevant calculations based on input data.
  4. Scenario Summary Using Scenario Manager: Creating different financial scenarios to analyze potential outcomes and summarizing these scenarios within the workbook.

Methodology

Students should begin by thoroughly reading the entire Case 6 to understand the context and objectives. Using the provided starting data file, the student is expected to correctly input data into designated cells, ensuring accuracy. Formatting steps should improve the readability and presentation of the worksheet, such as adjusting cell formats, applying borders, and using headings effectively.

Subsequently, appropriate formulas should be applied to perform calculations. These might include sum totals, percentage calculations, interest computations, or other financial formulas relevant to collections analysis. It is crucial that formulas are correct, efficient, and adaptable for scenario analysis.

The student then employs the Scenario Manager feature in Excel to model at least three different scenarios. These could involve best-case, worst-case, and most-likely scenarios, varying key assumptions or inputs. The scenario summaries should be created to facilitate comparison and decision-making based on different projected outcomes.

Evaluation Criteria

The project will be evaluated on four main aspects:

  • Worksheet Formatting (10%): Effective use of formatting tools to enhance clarity and presentation.
  • Data Entry (20%): Precise and accurate data input reflecting the provided starting data file and notes.
  • Calculations and Formulas (50%): Correctness and complexity of formulas used to derive key metrics.
  • Scenario Summary (20%): Appropriate setup and presentation of different scenarios, enabling meaningful analysis.

Conclusion

Completing this project will strengthen proficiency in fundamental and advanced Excel skills, crucial for financial and data analysis in professional environments. Mastery of worksheet formatting, accurate data entry, formula development, and scenario analysis are vital components for effective decision-making. Students are advised to carefully follow instructions, validate formulas, and ensure the workbook is professionally formatted and fully functional before submission. A thorough understanding of the case and systematic approach to building the workbook will ensure a high-quality deliverable, demonstrating both technical skill and analytical insight.

References

  • Gaskins, W., & Kirsch, J. (2015). Problem Solving Cases in Microsoft Access and Excel (14th ed.). Pearson Education.
  • Walkenbach, J. (2013). Excel 2013 Bible. Wiley Publishing.
  • Larson, D., & Hostetler, R. (2014). Microsoft Office 2013: Introductory Concepts and Techniques. Cengage Learning.
  • Coronel, C., & Morris, S. (2016). Database Systems: Design, Implementation, & Management. Cengage Learning.
  • Turner, C. (2018). Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables. Wiley.
  • Schwarz, J. (2017). Mastering Excel Formulas and Functions. Packt Publishing.
  • Few, S. (2009). Now You See It: Simple Visualization Techniques for Quantitative Analysis. Analytics Press.
  • Chandoo, P. (2015). Excel Charts & Graphs: Your visual blueprint for analyzing data, charts, and PivotTables. Packt Publishing.
  • Higgins, A. (2018). Excel Power Query & Power Pivot For Dummies. Wiley.
  • Microsoft Support. (2021). Create and manage scenarios in Excel. Retrieved from https://support.microsoft.com/

Related Assignments