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: Sept. 15 there will be a review for exam 1 on 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 Exam 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: Oct 11 |
||
|
Topic/Reading |
*Labs (Right Click, select Save Target As to get files) |
|
|
Predictive Analytics: How Uplift Modeling Helped Obama (video) Why Predictive Analytics(Video)
Memphis PD relies on IBM to keep ahead of criminals
Demo on Regression & Forecasting
Straightline Regression use file: StraightLine.xlsx Regression analysis and predictive modeling: VIDEO Monte Carlo Simulation |
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
________________________________________________
Tableau Demo Use file: NYC Grafitti
Tableau Lab use the following files:
|
|
|
Week 10: Oct. 25 |
||
Topic/Reading |
*Labs (Right Click, select Save Target As to get files) |
|
Optimization Demo
Capital
Budget.xls
Monte Carlo Simulation
Securing Information Systems PDF Video: How to spot a phishing scam Video: Data gathering is a two-way street
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 A Rogue Trader at Societe Generale Roils the World Financial System (handout) Answer questions at end of case
|
|
|
Week 11: Nov 1 Review Exam 2 Study Guide |
||
|
Topic/Reading
|
*Labs (Right Click, select Save Target As to get files) |
|
Keeping Your Computer Fine Tuned Securing Your Wireless Network Should you protect your wireless network Video?
|
|
|
Week 12: Nov. 8 Exam 2 Thurs Nov. 10 |
||
Topic/Reading |
*Labs (Right Click, select Save Target As to get files) |
|
Managing Knowledge My Version PDF
Video: Electronic Pick Pocketing
|
|
|
Week 13: Nov. 15 |
||
Topic/Reading |
*Labs (Right Click, select Save Target As to get files) |
|
Securing Information Systems PDF (continued) Keeping Your Computer Fine Tuned Securing Your Wireless Network Should you protect your wireless network Video?
E-Commerce: Digital Markets, Digital Goods PDF Web Sphere Commerce (IBM video) (1)
Web Search - How does it work? video
|
Video Case: Groupon
|
|
Week 13: Nov 22 (Nov. 23 - 27 Thanksgiving Break) |
||
Topic/Reading |
*Labs (Right Click, select Save Target As to get files) |
|
|
Lab
on Spin Buttons, Option Buttons etc. QuarterlyBefore & QuarterlySolved Demo: Consolidate Data Use files:
|
Video Case: IBM WatsonAnswer questions 1-4 and be prepared to discuss these questions in classVideo Case: Fresh DirectAnswer questions 1-4 and be prepared to discuss these questions in class
WatsonVIDEO How Does Watson Work?VIDEO
Kaiser Permanente Botches Its Kidney Transplant Center Project- Handout Answer the following questions:
|
|
Week 14: Nov. 29 |
||
Topic/Reading |
*Labs (Right Click, select Save Target As to get files) |
|
Presentations All presentations are due Dec 1.
|
|
|
Final Exam Dec .6 During normal class time |
Final Exam:Written & On-Line Exam Study GuideManaging Knowledge Managing Knowledge My Version PDF Security Securing Information Systems PDF
ID Theft - 60 minutes
E-Commerce E-Commerce: Digital Markets, Digital Goods PDF
Web Sphere Commerce (IBM video) (1)
|