BIS 155 Advanced PC Applications with Lab - DeVry

=============================
BIS 155 Entire Course Week 1 - 8
=============================
BIS 155 Week 1 iLab: Upper Saddle River Marching Band
BIS 155 Week 1 Discussion: Getting Familiar with Excel (graded)
BIS 155 Week 1 Quiz
BIS 155 Week 2 iLab: Excel’s Advanced Formulas & Functions
BIS 155 Week 2 Discussion: Formulas and Functions (graded)
BIS 155 Week 2 Quiz
BIS 155 Week 3 iLab: Alice Barr Realty Analysis
BIS 155 Week 3 Quiz
BIS 155 Week 3 Discussion: Data Analysis (graded)
BIS 155 Week 4 iLab: Create Address Labels
BIS 155 Week 4 Quiz
BIS 155 Week 4 Discussion: Excel Data Exchange (graded)
BIS 155 Week 5 iLab: Bruno s Pizza Analysis
BIS 155 Week 5 Quiz
BIS 155 Week 5 Discussion: Data Consolidation and What-if Analysis (graded)
BIS 155 Week 6 iLab: Day Care Center
BIS 155 Week 6 Course Project; Excel Project
BIS 155 Week 6 Course Project: Project Memo Template
BIS 155 Week 6 Discussion: Bringing It All Together (graded)
BIS 155 Week 7 iLab: Access Database
BIS 155 Week 7 Discussion: Database Decisions (graded)
BIS 155 Week 8 Discussion: Looking Ahead (not graded)
***********************************
BIS 155 Week 8 Final Exam
***********************************
1. (TCO 1) You work for a local construction firm, "DeVry Engineering Group" and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions:....... (Points : 40)
2. (TCO 3) You currently work for an automotive parts supply store. Your company is growing and is considering expansion. The company currently has three locations (North, South, and Central) in one state. Each parts supply store carries inventory in four categories. You have been presented with the sales figures for the last three years for each location and inventory category by store. Based on this information, you're tasked with analyzing current sales for each store by category and overall total sales by store and category….. (Points : 40)
3. (TCO 4) You are given a spreadsheet with daily sales numbers ordered by date from January 1st to December 31st. You have been tasked with finding the average sales of each month, then to reorder the months so they are listed in order from highest to lowest average sales. Give a step-by-step explanation of how you will rearrange the data so you can analyze the best and worst months….. (Points : 40)
4. (TCO 5) You've just joined the staff of the XYZ Manufacturing Company (XYZ, for short). XYZ manufactures only one product, the gizmo. It comes in two sizes, the mini-gizmo and the magna-gizmo. Both are difficult to manufacture, and consequently, the company closely monitors rejected units. The company has three locations, each of which produces both the mini and the magna-gizmos. You are automating the weekly production reports so that you can easily calculate total production for the entire company each week. The mini-gizmo is priced at $3.25 per unit. The magna-gizmo is priced at $7.00 per unit. The unit cost for a reject mini-gizmo is $1.75. The cost for a reject magna-gizmo is $3.50. Respond fully to the following questions regarding this task:…… (Points : 40)
5. (TCO 9) You have been tasked with analyzing an extremely large amount of data and to ultimately produce a report to share with the board of directors. The data is currently in a text file and has over two thousand records of data. Explain how you would use Excel to analyze this data and organize it to prepare a written report. Be very specific on the variety of tools you would use and the steps you would go through to analyze the data and to ultimately prepare a detailed report with recommendations………(Points : 40)
Powered by