Overview Of Sample Name Jane Doe Course Section CIS 105 111

Overview Samplenamejane Doecourse Sectioncis1051111professor Nameel

Complete a comprehensive Microsoft Excel worksheet that documents and calculates the costs of ten school supplies purchased for your course work, following detailed formatting, formula, and charting instructions provided. The assignment requires entering personal and course details on an overview sheet, listing supplies with quantities and prices, calculating total costs via formulas, creating a pie chart with data labels, and preparing the document for submission with specific file naming conventions.

Paper For Above instruction

The ability to utilize Microsoft Excel effectively is a vital skill for students, enabling efficient presentation and management of data ranging from budgeting to inventory tracking. This assignment offers a practical application of Excel's core functionalities—entering data, formatting cells, constructing formulas, and creating visual data representations—by documenting recent school supply purchases. The exercise emphasizes not only technical proficiency but also the importance of clear, professional presentation of data for academic and personal projects.

The initial step involves synthesizing personal and course-related information on an 'Overview' sheet. Students must input their name, course section, professor’s name, and assignment title, all formatted with Century Gothic font at 14-point size to ensure readability and professionalism. This preliminary step contextualizes the worksheet and underscores the importance of consistent formatting in data presentation.

Subsequently, students will transition to a dedicated 'School Supplies' sheet where they will list ten supplies—such as notebooks, pens, or textbooks—that they have either purchased or plan to purchase. Attention to detail is critical here: the worksheet must include specific labels in distinct font styles and sizes, with the supply names entered in the first column. The font color and size should conform to the specified guidelines to enhance clarity.

Entering Quantities and Prices involves careful data input with appropriate cell formatting. Quantities should be entered as whole numbers, with column width adjusted for visibility. The prices, expressed as dollar amounts, require clear formatting with Arial font at 14-point size and a dark blue font color to distinguish cost data. The accuracy of these inputs directly impacts subsequent calculations and visualizations.

Calculating total costs involves applying simple multiplication formulas, such as =B3*C3, to compute individual item totals based on quantity and unit price. Proper formula copying ensures consistency and efficiency across all entries. The total costs are formatted boldly with the same dark blue font to visually distinguish calculated data. These calculations underpin both financial summary and visual representation of expenditures.

Creating a pie chart from selected data enhances understanding of expenditure distribution. Students will select the range encompassing supply names and their respective total costs, then insert a pie chart that displays dollar amounts for each item. Customizations include adding an informative title, positioning it above the chart, and including data labels showing total prices. Proper positioning ensures the chart does not obstruct data, maintaining clarity and professionalism in presentation.

Final steps involve cleaning up by deleting any auxiliary sheets (such as instruction or overview sheets) before submission. The completed workbook must be saved under a specific filename—CIS105_Assignment2_FirstName_LastName.xlsx—to facilitate instructor review. Overall, this assignment guides students through fundamental Excel operations, from data entry and formula application to chart creation and presentation formatting, all within a real-world context of tracking school supplies expenditure.

References

• Gaskins, H. (2018). Mastering Excel: From beginner to advanced. Wiley.
• Hubbard, L. (2020). Excel Formulas and Functions for Dummies. Wiley.
• Microsoft. (2023). Create a chart from start to finish. Microsoft Support. https://support.microsoft.com/en-us/excel
• Walkenbach, J. (2017). Excel Bible. Wiley.
• Hein, R. (2021). Data visualization with Excel. Packt Publishing.
• Chandoo, P. (2019). Excel Charts: Mastering to Unlock Data Visualizations. Chandoo.org.
• Excel Easy. (2023). Excel tutorial. https://www.excel-easy.com
• Shweta, G. (2020). Practical Excel: Tips and Tricks. Packt Publishing.
• Exceljet. (2023). Excel formulas and functions. https://exceljet.net
• Yuditskaya, A. (2019). Effective Data Visualization and Charts: Best Practices. Springer.