MIS 399

View Syllabus

What's New 11/19/08 - We're going to start looking at SharePoint today.
Here is an fairly good SharePoint tutorial site: http://sptraining.sharepointsite.net/default.aspx

11/17/09 - Here is the correct hints file for the exam: ss4-hints-revised.xlsm

11/12/09 - Here are the instructions for installing the Microsoft-Office-2007-Web-Components.html

11/10/09 - Here is a new assignment on table analysis and data mining - assign05.docx

Here is a link to the Nvu HTML editor that we talked about in class: http://www.net2.com/nvu/download.html

11/02/09 - Data Mining Examples for Excel - DMAddins_SampleData-2007.xlsx

10/27/09 - Here is the cite for the seminal article on Balanced Scorecards
Robert S. Kaplan and David P. Norton, "The Balanced Scorecard - Measure that Drive Performance,"
Harvard Business Review, January-February 1992, 71-79.

Here are links to:
An article about the "first" blanaced scorecard
   http://www.schneiderman.com/Concepts/The_First_Balanced_Scorecard/BSC_INTRO_AND_CONTENTS.htm
An article about KPI's
         http://www.information-management.com/news/1043378-1.html
A comparison of dashboards and scorecards
http://www.information-management.com/news/10001076-1.html
An article on how BI and Performance Management fit together
http://www.information-management.com/news/1051320-1.html

10/22/09 - Here is your exam, two files are include, a Word document and an Excel workbook: exam1.zip
Here is an example macro file from MIS 370 that may be of some use: ss1-hints.xls

Here are some notes we will review today: Balanced-Scorecard-Step-By-Step.pptx

10/13/09 - Here is your data cube research assignment: assign04.docx

Here is a paper that illustrates the differences between SQL query, OLAP, and data mining in
a relatively straight forward way: Query-vs-OLAP-vs-Data-Mining.pdf

10/09/09 - Here is the partial solution Excel file for assignment 3 that we looked at on Thursday: IRA-Conversion-Partial-Example.xls

10/01/09 - Here is an Excel assignment for the IRA conversion decision: assign03.docx

09/29/09 - Here is the Excel assignment for the directory listing: assign01.docx
I've added a number of enhancements to what we talked about in the last class period.

09/15/09 - Here are installation web pages that were on the web page that we looked at in class today: NDSU-BI.zip

09/10/09 - Here are two example spreadsheets that we will use today: Example-Data-20090910A.xlsx Example-Data-20090910B.xlsx

09/08/09 - Here is an example spreadsheet that we will use in class today: Example-Data-20090908.xlsx

09/03/09 - The example files used in the text book can be found by:
Going to www.mhprofessional.com
Clicking on the Computing tab
Clicking on the Downloads page
Clicking on the book title
I've also include a link to the files in the Homework Assignments section at the bottom of this page.

We will be using the Microsoft SQL Server 2008 Data Mining Add-ins for Microsoft Office 2007
You will probably want to download and install these add-ins on your home computer.

  Utility2.xls This is an Excel file that has utility data for periods later than the historic data in the Utilities.xls file.
Use the new data to determine how accurate your forecast model is.

09/01/09 - Here is a file that you can use as a template for the utility forecasting assignment.
   Utilities-forecast.xls

08/25/09 - Course Intro.
BI Example
Utilities.xls

Here is a link to a great deal on Microsoft Office 2007 for $60.
The NDSU bookstore has the Microsoft Office Pro 2007 retail package (includes 3 product keys) available for $99. This is a limited time offer.
Note - the regular student package at the bookstore only includes 1 product key.

Course Notes I will make every attempt to post lecture notes the night before they will be discussed in class.

It is suggest that you print out these notes and bring them to class. The print option for 3 slides per page seems to work well for most students.

Note for cluster users: Left clicking on the Power Point file link will open the slides in a web browser. If you have trouble printing the slides from the web browser you can force the browser to download the file by holding the SHIFT key down while left clicking on the link. You can then open the file using Power Point.
Don't have PowerPoint on your machine? Then install Microsoft's PowerPoint Viewer 2007

Homework Assignments


Utilities.xls	Utilities-forecast.xls	Textbook-Files.zip	Example-Data-20090908.xlsx