BIS 155 Entire Course
For more course tutorials visit
www.shoptutorial.com
BIS 155 Course Project: Excel Project
BIS 155 Lab 1 of 7: Saddle River Marching Band
BIS 155 Lab 2 of 7: Excel’s Advanced Formulas & Functions
BIS 155 Lab 3 of 7: Alice Barr Realty Analysis
BIS 155 Lab 4 of 7: Create Address Labels
BIS 155 Lab 5 of 7: Bruno’s Pizza Analysis
BIS 155 Lab 6 of 7: Day Care Center
BIS 155 Lab 7 of 7: Access Database
****************************************************************************************************
BIS 155 Course Project Excel Project
For more course tutorials visit
www.shoptutorial.com
The general instructions for this project can be found in the Week 6 Lecture material. The Week 6 Lecture describes the assignment and provides an overview of the project as a whole. There are no step-by-steps for the course project. The following are grading criteria for this project.
Guidelines
Organize the Data
Data imported from SalesData.csv text file located in Course Project Materials in DocSharing. Professional formatting follows the formatting guidelines we studied during the first week of class. Documentation sheet added to provide author, purpose, and date and provide information about each of the sheets you will create as you analyze the data. At least one calculated field added and copied to all cells in the worksheet.
Analyze the Data
Analyze the data in at least three different ways. Each form of Data Analysis should be provided on a separate, appropriately labeled worksheet. It is expected that each sheet will be professionally formatted and clearly documented with titles, comments, and explanation. Remove any extra sheets so your workbook is as compact as possible when you turn it in. Go back and review your labs for assistance in completing the different types of analysis.
The following are some examples of analysis you might wish to do:
Sort by discount level. Have discounts increased sales volumes? Is there...