IS-207: System Analysis and Design

 

Resources

 

Home

 

Schedule

Assignments

Resources

 

 

Help with the Assignments

 

A short outline for an oral progress report, detailing how to be succinct and to-the-point.

A sample Table of Contents of the final project report, along with some general guidelines.

 

 

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
      • "Customer Delivery Preference System for UPS" (230K zipped file; Authors: Florence Gee, Judy Ma; Keasha Martindill)
    • 2004 projects
      • "System Analysis of a Web Portal for China’s Technology Industry" (870K Word doc; Author: Hong Qu)
    • 2005 projects
      • "VERN: Web-based Meeting Scheduling" (1MB Word doc; Author: Sarita Yardi)

 

 

 

General resources

  • "Writing a Software Requirements Document" by Tanya Berezin (June 1999) [Note: Ms. Berezin has graciously agreed to let us use this valuable document.]
  • 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)

 

  • Three Powerpoint templates for reporting and reviewing projects and their status, courtesy of Microsoft:
    • Project overview
    • Project status
    • Project post-mortem

 

  • A few documents that detail Software Development Process at a few different organizations:
    • The development process at Documentum's San Francisco office, circa 1999.
    • A very short outline of the process to create a "Creative Brief" at Interactive Bureau, a web design shop (circa 1998).
    • An outline of the software development process in use at Alibris, Inc (developed in 2003).
  • A very small example of MS Project in action (or is that inaction?):
    • a 20 task project plan for making chicken soup
    • the specification (a.k.a. the recipe).
  • Sample MS Project files:
    • Dining Room Table (see note for help with downloading these files)
      • 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.)
  • Visio files
    • Sample diagrams from Microsoft. This download includes 20 sample Visio 2003 diagrams related to support and sales demos.

 

 

 

Statistics

  • Statistics assignment
    • The assignment (html)
    • The data set (see note for help with downloading these files)
      • Almost clear text (HTML format)
      • Excel .xls format
      • SPSS .sav format
      • Zip file with both formats
      • Same archive, but in .sit format (not yet available)
    • Sample memo
    • “Answer sheet” for the assignment--Feb. 2007. (This is not the memo required; instead it is SPSS output in HTML with the answers to Questions 1-8.)

  • Practice data sets
    • for Excel
      • Student height and weight (1000 obs.; Excel – Office 2003 format)
        • In Excel v.4 for either Excel or SPSS
      • Oakland voter profile
      • Four private colleges
    • for SPSS (see note for help with downloading these files)
      • Oakland voter profile
      • Sample output from Oakland data (from lecture )
      • US colleges
      • World95
        • As used in class (with additional variables)
        • Sample output

  • Handouts and related files discussed in class
    • Two-page handout on Pivot Tables (thanks to Scott Fisher)
    • Flow of information in a survey
    • Sample survey of California ISPs
    • Brief comparison of Excel & SPSS
    • MS link: “Pivot Table Reports 101”
    • SPSS “flow of logic” handout
    • SPSS FAQ (a brief--11 Q&A's--and very useful Word document courtesy of CP204a)

 

 

Costs, accounting & planning

  • Cost analysis & economic feasibility

o         Introduction to cost analysis (one page; html text)

o         Time-value of money examples (Excel file)

  • Lectures and supplemental materials

o         Accounting & Planning PPT slides

o         Costs & Cost Accounting PPT slides (see note)

o         Accounting—A Quick Course PPT slides (see note)

 

Important notes

 
  • Notes about MS Project, “sav”, and “vsd” files
    • 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.
    • 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. Similarly, there may be macros in the Visio documents.
    • almost useless statement from Microsoft on Project file format compatibility
  • Note about “protected” files

Certain files, such as those with the work of former students and those provided by outside sources, are in a protected area of the iSchool LAN.  You will need your login id and password to access these from outside of South Hall. Non-iSchool students MUST obtain a user-id and password from Professor Braunstein.