MIS 462 Decision Support Systems

Course Policy
Software Installation
Windows Explorer
Self Extracting Files

IT Links
Spreadsheet History
Spreadsheet Comparison
Spreadsheet Page
MELB
Project Groups
BigCharts
Excel @ MS
Excel Add-Ins
Excel Camera Tool
Online Classroom

*Week
Class
Date
Class work
Presentations
* Assignments
1/35
1
Tue, 8/25/09
Project 1- HW web site
Project 2
VisiCalc
Dual monitors
Excel Fundamentals

Class Introduction
Safe Computing
Attend Project 1 workshop!
1/35
2
Th, 8/27/09
Excel Overview
   
2/36
3
Tue, 9/1/09
Start Data Analysis and Business Modeling
T1-Range Names
C2-Lookup
 

Project01

2/36
4
Th, 9/3/09
C3-Index
C4-Match
  
5425 Assessment
-Getting Started

Homework01 Ans
3/37
5
Tue, 9/8/09

C5-Text
C6-Dates
C7-Net Present Value

   
3/37
6
Th,9/10/09
C8-Internal Rate of Return
C9-PV, FV, PMT, PPMT, IPMT 		 
Homework02    Ans
Week
Class
Date
Class work
Presentations/Materials
Assignments
4/38
7
Tue, 9/15/09
Project2 Assignment
C10-Circular References
C11-IF
C12-Time
C13-Paste Special
C14-Auditing
    
4/38
8
Th, 9/17/09
C15-Sensitivity Analysis
C16-Goal Seek
C17-Scenario Manager		  
5426 Assessment-
Performing Calculations
5/39
9
Tue, 9/22/09
C18-Count, CountIF... Functions
C19-Sum, SumIF... Functions
  
Homework03    Ans
5/39
10
Th, 9/24/09
C74-Array Formulas
C20-Offset
Indirect.xls-Examples

 
6/40
11
Tue, 9/29/09
DSS/BI at Federated
Scott McCauley
   
6/40
12
Th, 10/1/09

Karen Spielman

    
Week
Class
Date
Class work
Presentations/Materials
Assignments
7/41
13
Tue, 10/6/09
 C21-Indirect
C22-Conditional Formatting
C23-Sorting
C24-Tables
C25-Form controls		    
7/41
14
Th, 10/8/09
C26-Solver for Optimization
C27-Solver-Optimal Product Mix
C28-Solver-Worker Scheduling
C29-Solver-Transportation
C30-Solver-Capital Budgeting
C31-Solver-Financial Planning
Solver Setup

Homework04   Ans
8/42
15
Tue,10/13/09
C33-Importing Text
C34-Importing Web Data
C35-Validating Data
C36-Histograms
Midterm 1
C1-C31
  
   
Wed, 10/14/09
WSU Career Fair
    
8/42
16
Th, 10/15/09
C37-Descriptive Statistics
C38-PivotTables
C39-Database Statistical Functions 		 
Homework05   ans

Project 2 Interim Updates
9/43
  
Tue,10/20/09
University Improvement Day
No Class
  
9/43
17
Th,10/22/09
C40-Filtering Data
C41-Consolidating Data
C42-Subtotals
C43-Straight Line Relationships
C44-Exponential Growth
C45-Power Curve
C46-Correlations

 

 
Midterm 1 due back!

9/43  
Fr, 10/23/08
Microsoft Technology Seminar
8am-noon Network admin/support
1pm-5pm Developers
Baldwin Lounge
  
Week
Class
Date
Class work
Presentations/Materials
Assignments
10/44
18
Tue, 10/27/09

 
Homework06    ans
10/44
19
Th, 10/29/09
C55-Random Variables
C58-Normal Random Variables
C60-Monte Carlo Simulation

Monte Carlo Tutorial

 
11/45
20
Tue, 11/3/09
C59-Weibull Dist.-Machine Life
C61-Optimal Bids
C67-Economic Order Qty

Midterm 2

Start Excel Programming
C7-Introducing VBA
Review Chapters 5 and 6- Spreadsheet Applications
  
11/45
21
Th, 11/5/09
C8-VBA Programming
C9-Subs
  
Homework07   ans
12/46
22
Tue, 11/10/09
C10-Functions
C11-Techniques

Project 2 Progress Report

  
12/46
23
Th, 11/12/09
C12-Dialog Boxes
C13-UserForms
C14-UserForm Examples
C15-Advanced UserForms		    
Week
Class
Date
Class work
Presentations/Materials
Assignments
13/47
24
Tue, 11/17/09
 C16-Utilities
C17-Pivot Tables
C18-Charts 		 
Homework08   ans
13/47
25
Th, 11/19/09
C19-Events
C20-Control other Apps
C21-Add-Ins		    
14/48
26
Tue, 11/24/09
Work on Project 2
   
14/48
Thanksgiving
Th, 11/26/09
     
15/49
27
Tue, 12/1/09
Project 2 Presentations
   
15/49
28
Th, 12/3/09
Class review and feedback
Course Evaluation
RateMyProfessors.com
   
           
Final
Somsen 301
Tue, December 8
3:30pm to 5:30pm

Final exam topics