This page provides links to files used in IS208A, Spring semester, 2004.  
(Last updated 3/3/2004)

• Certain files, such as those with the work of former students and those provided by the textbook publisher, are in a protected area of the SIMS LAN.  You will need your login id and password to access these from outside of SIMS. Non-SIMS students MUST obtain a user-id and password from Professor Braunstein
• Windows users should right-click on the hyperlink; some non-HTML files (e.g. MS Project, Visio & SPSS) only sometimes work automatically with IE and even less often with other browsers.
• If you still have problems, let me know and I'll created a "zipped" archive file.
• Mac users should click and hold.

IS 208

[All Powerpoint files to support the lectures are now directly linked to the schedule of topics.]

• Past final reports.  Several students from previous years have agreed to make their final reports available for you to review.  As we get printed versions, they will be put "on reserve" in the computer lab.  Links to electronically readable versions are below. 
• 2002 projects
  
• "Books-O-Rama" (1.1 MB Word doc; Authors: Christina Heyl, Beth Manning, Natalia Perelman, Guoping Li)
• "Electronic Collection Management System" (0.5 MB pdf file; Authors: Maggie Law, Behrang Mohit, Leah Zagreus)
• 2003 projects
• "AutoBuilding" (Written report available in Lab; Authors Laheem Jordan, Ashley Tan, Lauren Wilkinson)
• "Customer Delivery Preference System for UPS" (230K zipped file; Authors: Florence Gee, Judy Ma; Keasha Martindill)
  
  

• SPECIAL-- Comparison of corporate mission statements (HTML; with links)

• "Writing a Software Requirements Document" by Tanya Berezin (June 1999) [Note: We have lost the original source for this document.  There is a special prize for the first student who finds the source for us.]
• Three Powerpoint templates for reporting and reviewing projects and their status, courtesy of Microsoft:
• Project overview
• Project status
• Project post-mortem
• Sample MS Project files:
• Three notes about these files--
1. Macros: MS Project's "global template" has several macros, some of which may be saved with your file.  As a result, Project 2000 will warn you about macros as you open some of these files.
2. see note for help with downloading thes files
3. almost useless statement from Microsoft on Project file format compatibility
• Dining Room Table
  
• Version a; 14 tasks entered but not linked
• Version b; tasks linked into a network
• Version c; critical path identified, resources entered and assigned to tasks
• Version d, with "tracking Gantt chart, etc.. 3 tasks completed--one late, weekend work schedule corrected, etc.
• Revised Version c, with summary tasks; created  to illustrate project phases.  (This version and format show the summary tasks with a unique format in the Network Diagram View.)

• Process Modeling (see note for help with downloading these files)
• Dining Room Table Flowcharts in Visio
  
• Simple flow chart with three steps
• More complete with links to datafile stores
  
• Data Flow Diagram illustrating communications problem between JPL and Lockheed-Marietta (in Visio)
• William Harwood's analysis of the problem (Spaceflight Now 3/14/2000)
• Template for Use Cases (Word; provided by the textbook authors)
• Samples of spreadsheet documentation diagrams
  
• Telecom finance spreadsheets
  
• Introduction to Functional Decomposition Diagrams (Word; provided by the textbook authors)

• Statistical Analysis and Related Topics
  

• "Pivot Table Reports 101" for Excel 2002
• Survey planning flowchart (a PDF file)
• Analyzing Data & Using Descriptive Statistics
• Comparison of SPSS & Excel
• SPSS logic flowchart (a PDF file)
• SPSS FAQ (a brief--11 Q&A's--and very useful Word document courtesy of CP204a)
  
• Practice data sets
• for Excel
• Student height and weight
• Oakland voter profile
• Four private colleges
• for SPSS (see note for help with downloading thes files)
• Oakland voter profile
• Sample output from Oakland data (from lecture )
• US colleges
• World95
• Statistical Analysis Assignment
• The assignment (html)
• The data set (see note above)
• Almost clear text (HTML format)
  
• Excel .xls format
• SPSS .sav format
• Zip file with both formats
  
• Sample memo
• Answers, all done in SPSS (memo not included)
  

• Cost Analysis, Planning, Finance & Budgets
• Introduction to cost analysis
• Excel workbook with time value of money examples
• Supplemental lecture on costs & cost accounting (PPT file in protected directory; provided by a friend of SIMS)
• In-class budgeting example (Excel)
• Assorted budget documents
• UCB Chancellor's Budget Report 2001-2002 Fiscal Year
• UC and the State Budget (website; last updated 1/14/2004)
  
  

Follow these links to get back to the course home pages:

 

To IS 208A

-