BUS 335 Fall Term, 2016
Tentative Lecture & Lab Schedule
Final
Project Overview
All homework including spreadsheets must include your name. Spreadsheet work should be submitted formatted to print on a page (i.e. the spreadsheet should not be broken). |
Link to book Web site:
|
| Week 1:Aug. 23 | |
| Topic/Reading
Review: Final Project Overview |
*Labs (Right Click, select Save Target As to get files) |
|
Global E-business and Collaboration PDF
Video Case: UPS Global Operations with the DIAD
Goal Seek: Paymentgs.xlsx and Lemonadgs.xlsx |
Jet Blue case study Answer questions 1-3 and be prepared to discuss these questions in class Read Case Global Warming by Computer Be prepared to discuss |
|
Week 2: Aug.30 (No class Sept. 1 - Convocation) |
|
| Topic/Reading
|
*Labs (Right Click, select Save Target As to get files) |
|
Information Systems, Organiations and Strategy PDF
Review spreadsheets Demo on rannges and addressing Demo on Spreadsheet functions Use file: ABC.xlsx
|
|
Week 3: Sept 6 |
||
Topic/Reading |
*Labs (Right Click, select Save Target As to get files) |
|
Subtotaling in Excel Makeupsubtotal
Power Piviot DemoUse files: Analytics and Sales DB
Demo: IF function and VLOOKUP Expert
system case |
Video Case:Salesforce i-Phone Answer questions 1-5 and be prepared to discuss these questions in class |
|
Week 4: Sept 13: On Sept. 15 there will be a review for exam 1 scheduled for Sept. 20 See Exam 1 Study Guide |
|
|
Topic/Reading |
*Labs (Right Click, select Save Target As to get files) |
|
Excel Demo: Data Tables and More What-if Analysis (Decision Support): Data Tables and Conditional formatting and Scenario Manager: Lookup Tables
|
Watch the following videos:
|
Week 5: Sept. 20 Exam 1 |
||
Topic/Reading |
*Labs (Right Click, select Save Target As to get files) |
|
Demo: IBM Dashboard Video
What is Supply Chain Management Video What is Customer Relationship Management Video
|
Complete the following problem: Solver Budget Exercise use file Solver Budget Exercise.xls Complete the following problem: |
|
|
Week 6: Sept 27 |
||
|
Topic/Reading
|
*Labs (Right Click, select Save Target As to get files) |
|
| Foundations of Business Inteligence: Databases and Info. Management PDF Demo Relational databases Read: Databases
|
Video Case: Facebook Privacy Answer questions 1-4 and be prepared to discuss these questions in class
Given the data in the file Mrcostest2.xlsx, what is the predicted monthly operating cost for month 20? Which variable A, B or C adds the least predictive power to estimating the operating cost? |
|
Week 7: Oct 4 |
||||
Topic/Reading |
*Labs (Right Click, select Save Target As to get files) |
|||
|
Video Case: Facebook Privacy Answer questions 1-4 and be prepared to discuss these questions in class Data Tables and Conditional formatting Use file e05ws10GolfWhatIfSolution What is Monte Carlo Simulation Monte Carlo Simulation Software Demo (FrontLine Systems) Decision Analysis and Decision Tree SoftwarePPT
|
|||
|
Week 8: |
||
|
Topic/Reading |
*Labs (Right Click, select Save Target As to get files) |
|
|
Managing Knowledge My Version
Optimization Optimization PPT use file DJJ Enterprise
Capital
Budget.xls
Optimization Demo
Case Study
Predictive Analytics: How Uplift Modeling Helped Obama (video) Why Predictive Analytics(Video)
Demo on Regression & Forecasting
Straightline Regression use file: StraightLine.xlsx Regression analysis and predictive modeling: VIDEO |
Decision analysis with SS demo (Scenario Manager,GoalSeek,Solver)
Capital
Budget.xls
|
|
|
Week 9: Oct. 18- no class Tues. Oct .18 - Fall Break |
||
|
Topic/Reading |
*Labs (Right Click, select Save Target As to get files) |
|
|
Decision Support continued Data Mining Lab Demo: Data Mining
________________________________________________
|
|
|
Week 10: Oct. 25 Oct. 27 Review for Exam 2 Study Guide |
||
Topic/Reading |
*Labs (Right Click, select Save Target As to get files) |
|
Tableau Lab use the following files: Introduction to Tableau
Securing Information Systems PDF
Top Hacker Shows How it is Done video ID Theft - 60 minutes
|
Video Case:Cyberespionage The Chinese Threat Answer questions 1-6 and be prepared to discuss these questions in class
|
|
|
Week 11: Nov 1 Nov 3 Exam 2 |
||
|
Topic/Reading
|
*Labs (Right Click, select Save Target As to get files) |
|
|
|
|
Week 12: Nov. 8 |
||
Topic/Reading |
*Labs (Right Click, select Save Target As to get files) |
|
|
Sales Force CRM Video
Web Sphere Commerce (IBM video) (1)
GoogleWeb Search - How does it work? video
How Does Google Search Algorithm Work video Natural Language Processing: Google Translate - How Does it Work? Video
|
|
|
Week 13: Nov. 15 Review for Final exam on Nov. 15 |
||
Topic/Reading |
*Labs (Right Click, select Save Target As to get files) |
|
Oject Linking Lab Building Information Systems PDF
|
|
|
Week 13: Nov 22 Nov. 22 no class (Nov. 23 - 27 Thanksgiving Break) |
||
Topic/Reading |
*Labs (Right Click, select Save Target As to get files) |
|
|
|
Video Case: IBM WatsonAnswer questions 1-4 and be prepared to discuss these questions in class
WatsonVIDEO How Does Watson Work?VIDEO
|
|
Week 14: Nov. 29 Dec. 1 Presentations |
||
Topic/Reading |
*Labs (Right Click, select Save Target As to get files) |
|
Presentations All presentations are due Nov.29.
|
|
|
Final Exam Dec .6 During normal class time |
Final Exam:Written & On-Line Exam Study GuideSecurity Securing Information Systems PDF
The Cloud
E-Commerce E-Commerce: Digital Markets, Digital Goods PDF
Web Sphere Commerce (IBM video) (1)
Web Search - How does it work? video How Does Google Search Work video
|