Week
(tentative) |
Topic and
PowerPoint
|
In Lab |
Homework Assignments |
| Week 1 |
Introduction to CSC105 PPT
Intro to Excel PPT
Intro. to Excel (xlsx) |
Review Demo
on Spreadsheet functions Use file: ABC.xls
Purchase Orders
Decision Support for Supply Chain Use file: SupplierData.xls
The IF Statement
Outsourcing Decision Model Using an IF statement
Visualizing data with Pivot Tables and Pivot Charts
Demo Pivot Table: BankAccountsDemo
In the Lab Use file e03ws06GolfMktg (we will do this together)
Demo Pivot Charts: Pivot Tables & Charts.xlsx |
Read:
Cincinatti Zoo(1)
Cincinatti Zoo(2)
Read:
Big Data Big Rewards(1)
Big Data Big Rewards(2)
Lab Homework:
Homework Assignment: The Excel file Credit Risk Data provides information on 425 bank customers who applied for loans. The data include the purpose of the loan, checking and savings account balances, nmber of months as a customer of the bank, months employed, gender, marital status, age, housing status and number of years at current residance, job type, credit-risk classification by the bank.
a. Use the COUNTIF function to determine how many customers applied for new car, used car, business, education, small appliance, and furniture loans and the number of customers with checking account balances less than $500.
b. Modify the spreadsheet usin the IF functions to include new columns, classifying the checking and savings account balances as LOW if the balance is less than $500, MEDIUM if between $500 but less than $2000, and HIGH otherwise.
Use data file Credit Risk Data2
Your solution should look like this: Solution #4
Turn in a printout of both the spreadsheet and the formulas |
|
week 2 |
Big Data and Data Analytics PPT
Charts_Graphs PPT
Graph Design for Effective Communication PPT
Take the Graph IQ Test
Excel Charts |
Analyzing Uncertainity and Risk
(What-if Analysis, Data Tables, Scenario Manager, Goal Seek )
Lookup Tables
Lookup tables Use Files: Expert System.doc and ExpertSystem.xls
More Conditional formatting Globalwarming2 and Conditional Using Formula 2
Answers for Predictive Modeling problems use file: Moore Phamaceuticals
Chart lab work:
Histograms Use file: Histogram.xls
Practice with various charts. Use file: e02ws04SpaSales Create the following 5 charts:
For ProductData tab> Massage Totals create a Column or Bar chart.
For Revenue tab create a Line Chart.
For RedesignProject tab create a Stacked Bar (Gantt Chart)
For Survey tab create a Histogram for Age.
For SpaSales tab create a Combo chart.
Sparklines |
|
Homework Assignment:
Use pivot tables to construct cross-tabulation tabulations of Gender versus Carrier and Type versus Usage
Use data file Cell Phone Survey
Read: Moneyball |
| week 3 |
Computer Basics PPT
Regression Analysis PPT
House Rgression.xlsx
Correlation vs. causalityPPT
|
Predictive Analytics
Demo
on Regression & Forecasting -Relationships and Trends
Intro to regression use file: Tuition and Grades Regression.xlsx
StraightLine Regression use file: StraightLine.xlsx
Use Files: Home Market Value Video_books
Predictive Model Regression
Price Sales.xlsx
In Lab
Multiple Regression.xlsx Banking.xlsx
Regression analysis and predictive modeling: VIDEO
Use File Predictive modeling - regression
|
|
Week 4
Exam 1: Study
Intro to Excel PPT
Big Data and Data Analytics PPT
Graph Design for Effective Communication
PPT
Regression Analysis PPT
Why Predictive Analytics(Video)
|
Charts Tableau PPT
Digital Representation of Information PPTjmn |
Visualization: Using Tableau
STUDENT LICENSE / KEY
Each student should go to the landing page to download Tableau and enter the key noted below.
- Instructions: Click on the link above and fill out the form on the right hand side of the page. Under "Job Title",
mark Student; and under "Organization", please input Furman University.
Tableau's data visualization software is provided through the Tableau for Teaching program
Lab Key: TD6C-EA5D-9D40-11DB-BBE4 |
|
(Read these 3 articles from the BI Journal {above} by Oct.6: BI Experts Perspective, Business Analytics Insight : Hype or Here to Stay, How Your Favorite Companies Use BI to Suceed)
Watch the following video: We'll discuss it: Don't Panic
|
Week 5 Exam 1 |
Into. to Databases PPT(my lecture) |
Databases Introduction |
Read: and answer the questions for following case study:
HSBC (1)
HSBC (2)
HSBC (3) |
| week 6 |
Files
VS DatabasesPPT (my lecture) |
Databases
|
Read: Databases |
week 7 |
What is Big Data?VIDEO
Text Mining Video
Sentiment Analysis Video
Data warehouse at REI Video
Data Mining VIDEO
Data Brokers VIDEO |
Databases continued
|
|
week 8
No class Tues |
Python Programming 1 PPT
Python Programming 2 PPT |
Python Programming
http://www.python.org
http://code.google.com/p/pyscripter/
Python programming
IDLE
Using IDLE
Python Lab 1
Python Lab 2 |
Installing Python
|
| week 9 |
Python Programming RepetitionPPT
Python Programming Decision Structures PPT |
More Python:
Functions Lab
Functions Programs
Python Lab 3 |
|
week 10
Exam 2Study Guide |
|
More Python
|
|
week 11
Exam 2 |
Python Programming 5 PPT |
Python Lab 5
Python Nested Loops:
Clock Simulator program
Test Scores programs Test Scores2.py
Rainfall Program |
|
week 12
|
Optimization and Linear Programming PPT |
Optimization Using Solver
Investement Decision.xls
Transportation Problem.xls
Optimization using Solver
Capital Budget Using Solver Use File CapitalBudgeting.xlsx
Solver Product MixUse File: Solver Product Mix(Opt)
Pager Distribution Transportation problem Use File: Optimal Distribution.xlsx
Homework Assignment One Hot Springs Use File: Hot SpringsSolver.xlsx
Homework Assignment Two SurvivOr Puzzle
Turn in a printout of both the spreadsheet and the Solver solution (use PrtSc) (due 11/15)
Organize, Import, Cleanse, Data Sets
|
|
| week 13 |
|
Artificial Intelligence
Watson Videos
More on Machine Learning
|
|
week 14
Thanksgiving
Nov 25-29 |
|
|
|
week 15
Projects Due
- Project presentations
- Review for Final Exam
|
|
Presentations
Review for Exam:
|
|
| week 16 |
Exam in lab |
|
|
.