WK8 A2 Overview: Excelling With Excel Due Week 204968

WK8_A2 Overview Assignment 2: Excelling with Excel Due Week 8 and worth 175 points

Microsoft Excel is a versatile tool for presenting, organizing, and calculating data. This assignment requires creating a detailed spreadsheet related to your school supplies purchases for the quarter. You will document your purchases, perform calculations, and produce visual representations using Excel features, demonstrating your proficiency with the software.

To complete this assignment successfully, you must submit a Microsoft Excel workbook that includes a properly formatted title page, a detailed list of school supplies with costs, and a pie chart illustrating the expense distribution. Follow the step-by-step instructions provided, ensuring each element adheres to specified formatting and computational guidelines. Your workbook should be saved with the name “CIS105_Assignment2_FirstName_LastName.xlsx” before submitting online within Week 8.

Paper For Above instruction

The use of Microsoft Excel for organizing, analyzing, and visualizing data has become integral in both academic and professional settings. This assignment aims to enhance practical skills in spreadsheet creation, data entry, formula application, and chart generation, focusing specifically on managing school supplies expenses for a quarter. Engaging with this task not only reinforces core Excel competencies but also demonstrates the ability to translate real-world data into meaningful visual reports, aligning with the broader goal of cultivating data literacy.

The initial step involves designing a comprehensive title page within the Excel workbook. Users are instructed to enter their personal information, such as name, course section, professor’s name, and the assignment title in designated cells. This information must be formatted with the Century Gothic font at 14-point size to establish a professional appearance. The title page establishes context and identity, aligning with best practices for formal reports and assignments.

Moving into the main data sheet, labeled initially as "Sheet 3," students are directed to rename it as “School Supplies.” The worksheet begins with a prominent title cell formatted with Calibri Light font, 20-point size, and a striking color to make it stand out. Below, column headers are set up for the list of supplies, quantities, prices, and total costs, each formatted with bold and 16-point font. These labels serve as guides for entering specific data, which includes ten items representing various school supplies such as notebooks, pens, and textbooks. Proper formatting—font size, type, and color—enhances readability and visual appeal.

The supply names are to be entered into cells A3 through A12, with autofitting to display full names clearly. Text in these cells is to be formatted with 16-point Calibri Light font in orange for emphasis. Adjacent columns B and C prompt the user to input quantities and unit prices, with columns B set to a fixed width of 11.5 inches to accommodate entries comfortably. Quantity cells are formatted similarly to the labels for consistency, but with a brown font color for differentiation.

In column C, unit prices are entered and formatted with Arial font at 14-point size in dark blue to distinguish them from other data. Column D calculates total costs by multiplying quantities by prices using Excel's multiplication formula, e.g., =(B3*C3). This formula is filled down through D12, ensuring each item's total is computed correctly. The total cost cells are formatted in bold Arial font, 14-point, with dark blue color, making totals stand out.

Following data entry and calculations, the worksheet is to be renamed “School Supplies,” providing clarity. The next step involves creating a pie chart based on the data range covering supply names and total costs. The chart should display dollar amounts for each item, accompanied by data labels to facilitate easy interpretation of expenses. A descriptive title is added above the chart, and the entire visual is positioned to avoid overlapping with data entries, ensuring a clean presentation.

Throughout this process, students are reminded to review their work for accuracy and formatting adherence. Additionally, prior to submission, the guide instructs removal of the auxiliary sheets (“WK8_A2_Overview” and “WK8_A2_Instructions”) to ensure a clean, professional final file. Properly saving the document with the specified naming convention ensures easy identification and grading.

By completing this assignment, students deepen their understanding of essential Excel skills, including cell formatting, formula application, chart creation, and document organization. These capabilities are foundational for effectively managing data-related tasks across various academic and professional contexts, promoting efficiency and clarity in data representation.

References

• Clark, J. (2019). Excel 2019 Formulas and Functions for Dummies. John Wiley & Sons.
• Chamberlin, A. (2020). Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables. John Wiley & Sons.
• Microsoft Support. (2023). Create and format charts in Excel. https://support.microsoft.com
• Gupta, S. (2021). Practical Excel for Academics and Researchers. Academic Press.
• Lynda.com. (2023). Excel 2016 Essential Training. LinkedIn Learning.
• Ross, S., & Johnson, M. (2018). Excel for Beginners: A step-by-step guide. Excel Publishing.
• Science, W. (2020). Applying Excel to Data Analysis in Education and Social Science. Education Science Publishers.
• Excel Easy. (2023). Excel tutorial for beginners. https://www.excel-easy.com
• Microsoft Office Support. (2023). Insert a chart. https://support.microsoft.com
• William, S. (2019). Data Visualization with Excel Charts. Data Science Press.