Excel analysis assignment | Information Systems homework help


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 only your work. Be sure to cite ideas that came from others, even if you are not quoting them (e.g., group discussions suggested that…). Do not present an idea as your own, if it is not.

When you upload your assignment to the   D2L Assignments folder, 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.

After you download the Excel Analysis   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 when analysis tools like Charts, Filter & Sort, and 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 data set. 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:

  • The popularity of our undergraduate classes (numbers 100-499, please exclude 400-410 course        numbers)
    • By concentration and BA core
    • Fill rate and a total enrollment
  • What term/meeting day is the most popular and which is the least?
    • Fill rate and a total enrollment
  • What is the ratio of ground campus classes versus online courses?
    • By concentration and BA core

While you are running these calculates,   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 an Executive Summary (no more than        800) 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 Expectations and the BA 325 Information Literacy Assessment Rubric (You may use any font size/style/paragraph spacing/line spacing that you are comfortable with).


Due   Date: Nov 8, 2020 5:00 PM

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more