PivotTable Memo Report Your main task is to write a Memo Report about the data you are analyzing from the Module 7: Project Assignment. You must follow the directions in Assessment to ensure you are analyzing the correct data. You were placed randomly placed in a group Adult, Summer or Youth (Level 1 to Level 6). (Your assigned group should be YOUTH LEVEL 1) . Your task is to change the field according to directions below, then analyze and write a 2-page Memo Report. The Memo Report should be based on the group you are assigned to from the ΒAll Teams PivotTableΒ tab / worksheet you created from Module 7: Project Assignment. Steps: 1. From the League filter to your assigned group on Canvas. 2. From the Level filter to your assigned group on Canvas. 3. Generate a new PivotChart
The Memo Report should contain information / analysis about the data you are currently viewing, such as: 1. Explain in detail the overall data (such as, what do the results indicate). 2. Explain in detail how the data looks. 3. Present any forecast you may see. 4. Address recommendations on what can be done.
Memo Report Length: 2 Pages double spaced
Ensure that you embed your unique copy of the PivotTable and PivotChart in your Memo Report from the worksheet. Then submit the Memo Report to Canvas. You may download
a memo template from Microsoft Word in order to complete this assignment.
For complete grading details breakdown, please review PivotTable Rubric.
This criterion is linked to a Learning Outcome IAL2: Connections to Discipline: Sees (makes) connections across disciplines, perspectives threshold: 3.0 pts 4 pts Independently creates wholes out of multiple parts (synthesizes) or draws conclusions by combining examples, facts, or theories from more than one field of study or perspective. This criterion is linked to a Learning Outcome IAL4: Integrated Communication threshold: 3.0 pts 4 pts Fulfills the assignment(s) by choosing a format, language, or graph (or other visual representation) in ways that enhance meaning, making clear the interdependence of language and meaning, thought, and expression. Outcome Header Information about the Header (From, To, Date, Title, etc.) 10 pts Strong Has all the required information. Introduction Discuss what the Memo is about. 15 pts Strong Provides detailed descriiption of memo and purpose. Outcome Explanation / Discussion What does your data contain? Discuss the important variables you are understand from the data. 25 pts Strong Provides detailed analysis with examples. Chart
The post Pivot Table Analysis appeared first on learnedprofessors.