Concordia College Business Productivity Software Case Study Analysis

Instructions to the Mini Case assignment Purpose of Assignment The purpose of this assignment is to give you the chance to solve a realistic business problem, using business productivity software and knowledge that you would have learned from the course. Your submission will require: 1) A word document that contains the steps (elaborated) you took to solve the problem (Analysis Steps) and the final decision based on your analysis 2) An Excel file that contains the data set and the analysis steps you followed including the manipulation of the data in the data set NB: To submit your assignment, you will need to zip all your files into a zip folder Name the zipped folder with your first name, last name, and assignment name – for example if you name is john doe and submitting assignment 1, then the file should be names: johndoeassignment1.zip Grading breakdown Your grade will be based on the content of your word file which should include all figures and tables and text created in excel, access, etc… (What is to be included is up to you. The goal of the word file is that it integrates all information necessary from identifying the problem to the solution graphs and figures and interpretation). In other words, the statement of the problem, your analysis and how you went about it, any assumptions you may have made, and integration and explanations of your graphs and figures into the document from other sources such as excel and access. However, there will be points allocated to the individual files as explained below. 

? Word file: ~1000 words ? Figures: 2 or more figures ? Tables: 2 or more tables ? Excel: Create cells; graphs; trendline; insert formula; if-the-else function; insert some statistical functions such as average explain graphs