Montclair State University Data Analysis for Brevard County Memorandum

Question Description

I’m working on a Excel project and need an explanation to help me study.

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 select a group.
2. From the Level filter select a group.
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.

Outcomes – INFO173

Criteria

Ratings

Pts

This criterion is linked to a Learning OutcomeIAL2: Connections to Discipline:Sees (makes) connections across disciplines, perspectives

threshold: 3.0 pts

4.0 ptsIndependently 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.

3.0 ptsIndependently connects examples, facts, or theories from more than one field of study or perspective.

2.0 ptsWhen prompted, connects examples, facts, or theories from more than one field of study or perspective.

1.0 ptsWhen prompted, presents examples, facts, or theories from more than one field of study or perspective.

0.0 ptsDoes not meet benchmark criteria.

—

This criterion is linked to a Learning OutcomeIAL4: Integrated Communication

threshold: 3.0 pts

4.0 ptsFulfills 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.

3.0 ptsFulfills the assignment(s) by choosing a format, language, or graph (or other visual representation) to explicitly connect content and form, demonstrating awareness of purpose and audience.

2.0 ptsFulfills the assignment(s) by choosing a format, language, or graph (or other visual representation) that connects in a basic way what is being communicated (content) with how it is said (form).

1.0 ptsFulfills the assignment(s) (i.e. to produce an essay, a poster, a video, a PowerPoint presentation, etc.) in an appropriate form.

0.0 ptsDoes not meet benchmark criteria.

—

This criterion is linked to a Learning OutcomePivotTable Memo

0.0 pts

No Description

0.0 pts

No Description

0.0 pts

This criterion is linked to a Learning OutcomeHeaderInformation about the Header (From, To, Date, Title, etc.)

10.0 pts

Strong

Has all the required information.

7.5 pts

Proficient

Has more than half of the information.

5.0 pts

Satisfactory

Has half of the information.

2.5 pts

Novice

Has less than half of the information.

0.0 pts

Unacceptable

Missing information or not related to topic.

10.0 pts

This criterion is linked to a Learning OutcomeIntroductionDiscuss what the Memo is about.

15.0 pts

Strong

Provides detailed description of memo and purpose.

11.25 pts

Proficient

Provides some detailed overview of the memo.

7.5 pts

Satisfactory

Provides a brief overview of the memo.

3.75 pts

Novice

Provides little or no overview of memo.

0.0 pts

Unacceptable

Missing information or not related to topic.

15.0 pts

This criterion is linked to a Learning OutcomeExplanation / DiscussionWhat does your data contain?
Discuss the important variables you are understand from the data.

25.0 pts

Strong

Provides detailed analysis with examples.

18.75 pts

Proficient

Provides more than half detailed analysis.

12.5 pts

Satisfactory

Provides half detailed analysis.

6.25 pts

Novice

Provides less than half detailed analysis.

0.0 pts

Unacceptable

Missing information or not related to topic.

25.0 pts

This criterion is linked to a Learning OutcomeChart & GraphDiscuss the chart and information.
What does the data mean?

15.0 pts

Strong

Discusses in where the data came from and summarizes data.

11.25 pts

Proficient

Provides some detailed overview of the data.

7.5 pts

Satisfactory

Provides a brief overview of the data.

3.75 pts

Novice

Provides little or no overview of data.

0.0 pts

Unacceptable

Missing information or not related to topic.

15.0 pts

This criterion is linked to a Learning OutcomeConclusionClosing statement, Recommendation, Forecasting, etc.

15.0 pts

Strong

Provides detailed conclusion, recommendations, and/or forecasting, and provided examples.

11.25 pts

Proficient

Provides some detailed conclusion, recommendations, and/or forecasting.

7.5 pts

Satisfactory

Provides brief conclusion, recommendations, and/or forecasting.

3.75 pts

Novice

Provides little or no conclusion, recommendations, and/or forecasting.

0.0 pts

Unacceptable

Missing information or not related to topic.

15.0 pts

This criterion is linked to a Learning OutcomePivotTable / PivotChartWere the instructions carried out properly?

20.0 pts

Strong

Correct chart and table added to memo.

10.0 pts

Satisfactory

Correct chart or table added to memo.

0.0 pts

Unacceptable

Missing information or not related to topic.

20.0 pts

This criterion is linked to a Learning OutcomeExtra Credit

0.0 pts

No Description

0.0 pts

No Description

0.0 pts

This criterion is linked to a Learning OutcomeCreativityAdds something unexpected

5.0 pts

Added Creativity

Added something outside the requirement or unexpected.

2.5 pts

Partial Creativity

Added some creativity.

0.0 pts

No Creativity

There is no creativity.

5.0 pts

^{"Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you "A" results."}