Grader Instructions Excel 2019 Project Exp19 Excel Chapter 0

Grader Instructions excel 2019 Projectexp19 Excel Ch03 Capassessment

Work involves creating various charts and visualizations in an Excel workbook for a movie download company, including pie charts, combo charts, sparklines, and bar charts, with specific formatting and accessibility features. The task also includes adding titles, data labels, chart styles, alt text, and footers, as well as adjusting axes, colors, and chart placement. After completing the charts, save and close the workbook.

Sample Paper For Above instruction

The assignment involves creating a comprehensive set of visual representations of movie download data for April 2021 using Excel 2019. These visualizations include a pie chart, a combo chart, sparklines, and a stacked bar chart, each serving different analytical purposes. The process emphasizes best practices in chart design, accessibility, and data clarity, aligning with professional standards in data visualization.

Initially, a pie chart is to be created to visualize the proportion of downloads contributed by each genre for April 2021. The relevant data ranges are selected, and the chart is moved to a dedicated chart sheet titled "April Pie Chart." A descriptive title, bold and sizable font, along with clear data labels indicating percentages and categories, enhance readability. The donut chart highlights the comedy genre by exploding its slice by 7% and filling it with dark red, emphasizing this data point. Accessibility is addressed by adding alt text describing the chart’s purpose.

The next step involves creating a combo chart to depict both the total number of downloads and the percentage contribution per genre. The data range is selected, and a Clustered Column - Line on Secondary Axis chart is inserted and positioned below the data, then resized precisely. The chart’s title, "April 2021 Downloads," is formatted with bold, black font. Axis titles are added to clarify the metrics—"Number of Downloads" and "Percentage of Monthly Downloads"—and styled consistently. The legend is removed to streamline the presentation, and the secondary axis is formatted to display percentages without decimal places, improving clarity. The plot area receives a light gradient fill, and alt text is added for accessibility.

To provide a snapshot of weekly performance, sparklines are inserted in the worksheet, displaying weekly trends for each genre using line sparklines with markers and high points colored red. These visual elements help quickly identify peaks and overall trends within the data.

A major component of the analysis is a stacked bar chart illustrating weekly downloads by genre. Created from a specific data range, the chart is moved to a new sheet titled "Weekly Downloads" and styled with Style 8. The chart title is enlarged for visibility, and axes are formatted to enhance readability—category labels are reversed, the maximum value is set at 9000 with major units at 500, and minor gridlines are added for better visual guidance. Accessibility is supported through alt text describing the chart’s purpose.

An important final step involves adding footers across all sheets, embedding the text "Exploring Series," along with sheet and file names as helper codes. The workbook is then set to Normal view, saved, and closed, ready for presentation or further analysis. These steps collectively demonstrate a detailed application of Excel’s charting and formatting features to produce clear, accessible, and insightful data visualizations aligned with professional standards.

References

• Few, S. (2009). Now you see it: Simple visualization techniques for quantitative analysis. Analytics Press.
• Kirk, A. (2016). Data visualization: A successful design process. Packt Publishing.
• Cleveland, W. S. (1993). The elements of graphing data. Hobart Press.
• Microsoft Support. (n.d.). Create a chart from start to finish in Excel. https://support.microsoft.com/en-us/excel
• Few, S. (2012). Show me the numbers: Designing tables and graphs to enlighten. Analytics Press.
• Yau, N. (2011). Data points: Visualization that means something. Wiley.
• Zweig, G. (2014). Data visualization: A guide for librarians, researchers, and professionals. Routledge.
• Heer, J., & Bostock, M. (2010). Declarative language design for interactive visualization. IEEE Symposium on Visual Languages and Human-Centric Computing, 263-270.
• Cairo, A. (2013). The functional art: An introduction to information graphics and visualization. New Riders.
• Müller, S. (2018). Data visualization: Principles and practice. Oxford University Press.