1.I have uploaded the rubric please read it.

2.I have uploaded the excel anlysis instructions as well so please read them.

2.I have uploded the required data points to solve and complete the following :

Your Deliverable:

· Write up your findings in a Word Document with Executive Summary (no more than 900) that answers your boss’ questions. Use screen clippings of the analysis you did in Excel as evidence to support your conclusions (75%).

· Also submit your Excel workbook that shows your calculations, charts, figures, tables, etc. (25%).

· At this point, you should be very comfortable with some of the analytical tools within Excel, and this is an opportunity to show that. Be sure to follow the guidelines set in the BA 325 Information Literacy Assessment Rubric (You may use any font size/style/paragraph spacing/line spacing that you are comfortable with).

Information Literacy Reminders:

These assignments are open-ended by design and are meant to simulate the type of instructions you would get in a work environment. The goal is to get you comfortable working with datasets and interpreting information. In addition, these activities build the “critical thinking muscle” by requiring you to consider the information resource more critically than you may have previously done. When you are performing your analysis in any given assignment, remember to place context on all data and link it to the relevant course concepts. Your conclusions in any given assignment should be supported by your observations/analysis and demonstrate your comprehensive understanding of the topic(s).

This is an independent assignment meaning that you may not collaborate with a friend. If you talk together about the assignment and brainstorm ideas, you must be sure that what you turn in is yours and yours alone. You must cite ideas that come from others – even if you are not quoting them. Do not present an idea as your own, if it is not. When you upload your assignment to D2L dropbox you are stating that the work is your own. All assignments will be evaluated through TurnItIn, so any metadata that is not your own will flag an Academic Integrity Review.

Instructions:

The goal of this assignment is to give you more comfort investigating a data set that is unknown, and will require some data cleaning/preparation before you can make use of it. Preparing your data to be interpreted generally is the most labor-intensive part of analysis. This assignment will stretch your critical thinking skills, as you are given less direction by design. In a professional situation, you will often be given even less direction, and be expected to use your resources to answer the questions that come up along your analytical process.

· Note: I created the  Analytical Thinking Guide  specifically as a support resource for this assignment. It is a good resource in general, but the steps align with this assignment and should give you some good initial direction.

After you download the Excel data file associated with this assignment, please look through the data, and then respond to the following questions that are used to assess your information literacy skills. This assignment asks you to think about what analysis tools like Charts, Filter/Sorts, or PivotTables are useful for business decisions.

Erica Wagner, your boss, sends you this Excel file and gives you the following information. She says she wants your analysis when she returns from a conference next week.

“Once you organize this dataset. I need you to analyze the 18-19 academic year (summer, fall, winter, spring) enrollment by course and term. I am giving a presentation to the new Provost in an attempt to convince her to invest more money in the undergraduate business program because we are growing both online and on campus. I think the following stats will be convincing:

· Popularity of our undergraduate classes (numbers 100-499, please exclude 400-410 course numbers)

· By concentration and BA core

· Fill rate and total enrollment

· What term/meeting day is the most popular and which is the least?

· Fill rate and total enrollment

· What is the ratio of ground campus classes versus online courses?

· By concentration and BA core

While you are running these calculations see what else you can interpret from the data that should also be included in my talk.

Please get this to me by end of next week. Thanks!”

 

Your Deliverable:

· Write up your findings in a Word Document with Executive Summary (no more than 900) that answers your boss’ questions. Use screen clippings of the analysis you did in Excel as evidence to support your conclusions (75%).

· Also submit your Excel workbook that shows your calculations, charts, figures, tables, etc. (25%).

· At this point, you should be very comfortable with some of the analytical tools within Excel, and this is an opportunity to show that. Be sure to follow the guidelines set in the BA 325 Information Literacy Assessment Rubric (You may use any font size/style/paragraph spacing/line spacing that you are comfortable with).

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *