Software Plan - Siena College



Software Plan

Simnet View

Requested By: Ms. Jami Cotler

Lecturer of Computer Science

Computer Science Department

Siena College

Dr. Timoth C. Lederman

Professor of Computer Science

Computer Science Department

Siena College

InnoSmart Technologies

Prepared by: Kevin Decker

Shane Leighton

James Mayben Jr.

Caitlin Sheil

Andrey Taran

September 21, 2007

Table of Contents:

Simnet View

System Definition

1. Problem Definition . . . . . . . . . . . . . . . . . . . . . . 2

2. System Justification . . . . . . . . . . . . . . . . . . . . . . 2

3. Goals for the System and for the Project . . . . . . . . . . . . . . 2

4. Constraints on the System and for the Project . . . . . . . . . . . . 2

5. Functions to be Provided . . . . . . . . . . . . . . . . . . . . 3

6. User Characteristics . . . . . . . . . . . . . . . . . . . . . . 3

7. Development/Operating/Maintenance Environments . . . . . . . . . 3

8. Solution Strategies . . . . . . . . . . . . . . . . . . . . . . . 3

9. Priorities of System Features . . . . . . . . . . . . . . . . . . . 4

1.10 System Acceptance Criteria . . . . . . . . . . . . . . . . . . . 4

1.11 Sources of Information . . . . . . . . . . . . . . . . . . . . . 4

Problem Definition

2.1 Life Cycle Model: Linear Sequential (Classic Waterfall) Model . . . . . 5

2.2 Organizational Structure . . . . . . . . . . . . . . . . . . . . 6

2.3 Preliminary Staffing and Resource Requirements . . . . . . . . . . . 6

2.4 Preliminary Development Schedule . . . . . . . . . . . . . . . . 7

2.5 Project Monitoring and Control Mechanisms . . . . . . . . . . . . 7

2.6 Tools and Techniques to be Used . . . . . . . . . . . . . . . . . 7

2.7 Programming Languages . . . . . . . . . . . . . . . . . . . . 7

2.8 Testing Requirements . . . . . . . . . . . . . . . . . . . . . 7

2.9 Supporting Documents Required . . . . . . . . . . . . . . . . . 8

2.10 Manner of Demonstration and Delivery . . . . . . . . . . . . . . 8

2.11 Sources of Information . . . . . . . . . . . . . . . . . . . . . 8

2.12 Gantt Chart . . . . . . . . . . . . . . . . . . . . . . . . . 9

Appendix

3.1 Glossary of Terms . . . . . . . . . . . . . . . . . . . . . . . 10

3.2 Team Resumes . . . . . . . . . . . . . . . . . . . . . . . . 12

System Definition

1.1 Problem Definition

Our clients, Ms. Cotler and Dr. Lederman have a lot of information from old Simnet tests (Excel Spreadsheet Tests) that needs to be organized and made accessible. InnoSmart Technologies can offer them a solution, one which will set up a gateway to access past, present and future test data. This will enable them to get more meaningful information from the data.

1.2 System Justification

The purpose of Simnet View is to analyze the data obtained by a testing package, Simnet, which is designed to test students' understanding of Microsoft Office software. Our clients have used Simnet primarily to test students knowledge of the Excel program. The user of Simnet View will be able to see all the relevant data about each student, such as their name, grade, class, the date the exam was taken, how many questions they got wrong or right, how many tries it took them, etc. Simnet View will be accessible on the World Wide Web making it simple to with any web browser. The software will be able to output the analyzed data in Microsoft Excel format, as well as export that data to a Oracle DBMS.

1.3 Goals for the System and on the Project

The goal of our project is to develop software that will read the results of tests taken through Simnet, and make it possible to analyze them in different ways. The results will be accessible from five accounts, two administrator accounts and three general accounts. The data from separate tests will be stored in separate XML files and will be accessible in the future to compare results of future tests. The software must also be platform independent so it can be run on either Mac OS X or Windows XP.

1.4 Constraints on the System and on the Project

Simnet View must be able to run either on MAC OS X or Windows XP and in any of three major web browsers, Firefox, Safari, and Internet Explorer. The web server where Simnet View will be stored and run from has been specified, it is a Red Hat Enterprise linux operating system, running an Apache web server and MySQL database management software package. Any future constraints will be handled on a case-by-case basis as they arise by the InnoSmart team.

1.5 Functions to be Provided

• Online interface to view the data and the chosen analysis.

• Compatibility with major browsers, such as Mozilla Firefox, Internet Explorer, and Safari.

• Secure login system.

• Ability to move selected records to new locations in the directory.

• Search functionality within the interface. An example would be searching

for a student's results by their name.

• Ability to export the data into a Oracle DBMS or a Microsoft Excel file.

• Ability to retrieve the data from XML and Microsoft Excel files, as well

as an Oracle DBMS.

1.6 User Characteristics

The primary users of Simnet View will be Ms. Cotler and Dr. Lederman, our clients. However, there will be three general accounts that will allow other faculty to access the data per request.

1.7 Development/Operating/Maintenance Environments

Simnet View will be developed on the Siena College Software Engineering workstations. The workstations we have available are an Apple I-Mac running Mac OS X 10.4.10 and a Dell Dimension 4550 running Microsoft Windows XP Service Pack 2. The software we will be utilizing includes Macromedia Dreamweaver MX 2004, Macromedia Fireworks MX 2004, and the Microsoft Office 2003 suite.

Simnet View will be stored and ran on a Dell PowerEdge 2550 server, running Red Hat Enterprise Linux ES release 3, running an Apache 2.0.54 web server with PHP 4.3.11 and MySQL 4.1.14.

The maintenance of Simnet View after May 2008 will be determined at a future date.

1.8 Solution Strategies

To meet our clients’ requests, we will be using the Classic Waterfall Method to develop the project. This model involves the following steps:

Project Definition – Definition of the problem and outline of the final project.

Requirements Specification – Gather information from the clients in order to establish the requirements.

Preliminary Design – Address the requirements specification in a representation of the final project.

Detailed Design – Expanding upon the preliminary design and begin coding.

Acceptance Test – Final testing and delivery of software to the client.

1.9 Priorities of System Features

The most important system feature is the ability to analyze and compare the data from numerous tests. It must also be possible to display the data in the database by test, student or question.

1.10 System Acceptance Criteria

Simnet View will allow for a number of activities by a user, including at a minimum:

• Import collected data from an XML format into formats such as a Microsoft Excel file, a Comma Separated Value file, and in a form to be displayed online.

• Allow users with administrative rights the ability to move and separate student files within directories, and create or delete a directory to store data.

1.11 Sources of Information

The information presented in this Software Plan was gathered in meetings with

our clients Ms. Cotler and Dr. Lederman of the Computer Science Department at Siena College. Other information was also obtained from the textbook for this course, Software Engineering: A Practitioners Approach by Roger S. Pressman. We have also collected additional information from Software Plans created by students taking the Software Engineering course in previous years. Another possible source will be current open source code.

Problem Definition

2.1 Life Cycle Model: Linear Sequential (Classic Waterfall) Model

[pic]

Software Plan

Definition of the problem and outline of the overall expectations of the final project.

Requirements Specifications

Gather information from the clients in order to establish requirements and specifications.

Preliminary Design

Address the requirement specifications in a representation of the final project.

Detailed Design

Expand upon the Preliminary Design representation.

Acceptance Test

Conclude the Life Cycle Model with final testing and delivering the product to the client.

2.2 Organizational Structure

InnoSmart Technologies is comprised of the following members:

Name Email Phone

Kevin Decker kj23deck@siena.edu (518) 321-8839

Shane Leighton sr08leig@siena.edu (603) 369-1449

James Mayben ja19mayb@siena.edu (518) 577-5286

Caitlin Sheil cs24shei@siena.edu (518) 755-3008

Andrey Taran taran.andrey@

InnoSmart Technologies is organized as follows for the Simnet View project:

Kevin Decker Team Leader

Shane Leighton System Administrator

James Mayben Webmaster

Caitlin Sheil Documentarian

Andrey Taran Web Developer

The team structure of InnoSmart Technologies is democratic. Decisions are made according to the majority vote with the team leader acting as a tiebreaker if needed.

The responsibilities of the positions are as follows:

Team Leader Organizes and sets agenda for team and client meetings. Distributes work accordingly amongst team members and keeps the team on track for the semester.

System Administrator Maintains all user accounts and software on the team’s computers.

Webmaster Designs and maintains the team website.

Documentarian Compiles and organizes all documents pertaining to the team.

Web Developer Assists the webmaster in the creation of the website. Is also available to assist in other areas as needed.

2.3 Preliminary Staffing and Resource Requirements

Our team will need to utilize various hardware, software, and human resources. The hardware needed includes computer systems, a LINUX based web server with Oraserv, printers, and the computers in the Software Engineering lab. The software needed includes Microsoft Office, Adobe Software Suite which includes Dreamweaver and Fireworks, and Oracle DBMS. Our human resources include Ms Cotler, a client, and Dr. Lederman, a client and our Software Engineering professor.

2.4 Preliminary Development Schedule

The Waterfall Model for software engineering that will be followed in establishing reporting milestones is located in Section 2.1 on page 5 and a timeline (Gantt Chart) is located in Section 2.12 on page 9.

2.5 Project Monitoring and Control Monitoring

InnoSmart Solutions will have a minimum of one team meeting per week, sometimes two or more team meetings depending on the work needed to be done. This will ensure consistent contact between the members of the group, facilitating smooth interaction, as well as ensuring individuals are up to date. There will be a weekly meeting with the client to ensure both sides are in tune with the project’s vision. Finally, weekly meetings between the team leader and Dr. Lederman will help to stay on task, as well as address any issues the team might have.

2.6 Tools and Techniques to be Used

InnoSmart will be using computers with various software applications including Microsoft Office, Adobe Software Suite and a MySQL DBMS. Our team will be using PHP, HTML and CSS to implement the online interface and the module to manage and analyze the data. Oracle DBMS will be used to simplify the storage for future reference. InnoSmart will also use a XML parser for its web application. We will be utilizing Microsoft Project and the techniques obtained in Software Engineering to complete the design process.

2.7 Programming Languages

InnoSmart Technology will be using XHTML, CSS, PHP and JavaScript for their website. Any other possible programming languages to be used will be addressed on a case-by-case basis.

2.8 Testing Requirements

After each project component is completed, that component will be tested. The clients will be asked to aid in the testing process, and will also be made aware when the project reaches a segment where it will enter testing. The final testing will include all requirements and conditions from our client.

2.9 Supporting Documents Required

The following documents are to be handed in and provided to our clients during the current semester on the following approximate dates:

• Software Plan: September 21st, 2007

• Software Requirements Specification: October 24th , 2007

• Preliminary Design: November 28th, 2007

2.10 Manner of Demonstration and Delivery

InnoSmart will make several different presentations throughout the development process to update our clients on our progress as well as to ensure that all standards are met. These presentations include, but are not limited to, PowerPoint presentations, speeches, handouts, and Simnet View web application demonstrations. InnoSmart will update clients on a regular basis as to the dates and times of these presentations.

2.11 Sources of Information

The information presented in this Software Plan was provided by our clients Ms. Cotler and Dr. Lederman of the Computer Science Department at Siena College. Other information was also obtained from the textbook for this course, Software Engineering: A Practitioners Approach by Roger S. Pressman. We have also collected additional information from Software Plans created by students taking the Software Engineering course in previous years. Another possible source will be current open source code.

2.12 Timeline (Gantt Chart)

[pic]

Appendix

3.1 Glossary of Terms

Code - The symbolic arrangement of data or instructions in a computer program or the set of such instructions.

Database - A collection of data arranged for ease and speed of search and retrieval.

DBMS (Database Management System) - Software that controls the organization, storage, retrieval, security and integrity of data in a database.

Gantt Chart - A chart that depicts progress in relation to time, often used in planning and tracking a project.

HTML (Hyper Text Markup Language) – A markup language used to structure text and multimedia documents and to set up hypertext links between documents, used extensively on the World Wide Web.

Internet - An interconnected system of networks that connects computers around the world via the TCP/IP protocol.

Linear Sequential Model / Classic Waterfall Model – A systematic, sequential approach to software development that begins at the system level and progresses through analysis, design, coding, testing, and support.

Microsoft Excel - is a spreadsheet application that features many calculation and graphing tools.

PC (Personal Computer) - Another name for a microcomputer designed for use by a single user.

PHP (PHP Hypertext Preprocessor) – A server-side, cross-platform, HTML-embedded scripting language used to create dynamic web pages. PHP is open source software.

Simnet – Proprietary software which enables professors to create and offer tests on Microsoft Office applications and then view the results.

Software - Written programs or procedures or rules and associated documentation pertaining to the operation of a computer system and that are stored in read/write memory.

SQL (Structured Query Language) - Pronounced "sequel", it is a language that provides an interface to relational database systems.

XML – Extensible Markup Language is a general-purpose markup language. It is classified as an extensible language because it allows its users to define their own tags.

3.2 Team Resumes

KEVIN J. DECKER

e-mail: KevinJDecker@

Present Address: Permanent Address:

515 Loudon Road SPOB 4124 25 French Settlement Road

Loudonville, NY 12211 Chateaugay, NY 12920

518-321-8839 518-497-3217

EDUCATION:

Siena College, Loudonville, NY

B.S. in Computer Science with 3.6 GPA, Minor in Multimedia Design, May 2008

Activity: Member (former Vice President) of Computer Science Club, Sept. 2004 - Present

COMPUTER & SUPERVISORY EXPERIENCE:

Computer Science Trainee, Federal Highway Administration, NY Division, Albany, NY, 6/07-Present

• Program new web applications for use inside office.

• Monitor web applications to ensure they run properly.

• Assist in maintaining on-site servers, workstations and network integrity.

• Provide technical support to approximately 50 employees.

Student Head Consultant, Siena College, Information & Technology Services Dept., Loudonville, NY, 6/06-6/07

• Act as liaison between student consultants and staff and administrators.

• Serve as leader and model for student consultants.

• Provide administrative support for department heads and managers within I&TS.

• Train student consultants on the internal ticket tracking process.

• Provide input to I&TS staff on practices and procedures.

• Explain policies and procedures to the staff to ensure proper implementation.

• Ensure adherence to department policies and procedures.

• Organize inventories of paper and printer supplies for the department and its network.

Student Consultant, Siena College, Information & Technology Services Dept., Loudonville, NY, 1/05-6/06, 9/07-Present

• Serve as a representative of Siena College and the I&TS Department.

• Provide daily inventories to I&TS staff.

• Ensure public computer labs are in clean and working condition.

• Assist students and faculty with technological problems.

• Assist students and technicians to ensure mutual understanding of problems.

COMPUTER SKILLS:

• Programming: Microsoft Visual Basic, Java, HTML, PHP, MySQL, MSSQL,

Javascript, CSS, also familiar with C++, ASM, and .

• Knowledgeable in use of Microsoft operating systems, and Office programs.

• Coursework: Introduction to Programming, Data Structures, Assembly Language and Computer Architecture, Object Oriented Design and Programming, Analysis of Algorithms, Web Design, Operating Systems, Computer Graphics, Multimedia Design, Database Management, Software Engineering.

Shane R. Leighton

152 Hoit Road

Concord, NH 03301

(603) 369.1449

leighton.shane@

OBJECTIVE

To obtain a challenging position in the Information Technology field which utilizes my knowledge and allows for further learning.

EDUCATION

Siena College, Loudonville, NY

B.S. in Computer Science, May 2008

GPA: 3.12/4.0 in major

COMPUTER SKILLS

Microsoft Windows 98, ME, XP, Vista; Microsoft Office: Word, Excel, Power Point; Microsoft Visual Basic 6.0; Microsoft IE 6, 7; Mozilla/Firefox; Java; Adobe Dreamweaver CS3; Apple iMovie

EXPERIENCE

Chief Systems Administrator, Software Engineering I, InnoSmart Technologies

• Managed user accounts and access.

• Worked with group and clients to work towards a product of use.

ADDITIONAL EXPERIENCE

Customer Service, Sodexho, Loudonville, NY, September 2006 – Present

• Served customers.

• Managed pizza oven.

Customer Assistant, Pacific Sunwear, Concord, NH, July 2006 – September 2006

• Stocked clothing.

• Assisted customers with purchases.

Sales Associate, Finish Line, Concord, NH, May 2005 – July 2006

• Pitched sales for shoes.

Telemarketer, Curran Management, Concord, NH, August 2003 - April 2004

• Make calls to gain information.

HONORS / AWARDS

Best one day multiple sales (9 of 11), Finish Line

2nd highest one day sales, Finish Line

Most appointments of the night (2 times (7)), Curran Management

Most weekday appointments (2 times (5)), Curran Management

ACTIVITIES

Member, Division I Cross Country, Siena College, Fall 2004 – Present

James Anthony Mayben Jr.

ja19mayb@siena.edu

(518) 577-5286

Campus Address Permanent Address

Siena College 685 Clinton Avenue

515 Loudon Road SPOB 2759 Albany, NY, 12206

Loudonville, NY 12211

OBJECTIVE: To obtain a position where my skills in computer science will be of value.

EDUCATION:

Siena College, Loudonville, NY

B.S. in Computer Science; Minor in Business; Anticipated Graduation Date: May 2008

COMPUTER SKILLS:

Microsoft Visual Basic, Word, Excel, PowerPoint, Publisher, IE 6, IE 7; Competent in Java Programming, HTML, CSS, PHP; Familiar with C++ Programming, Java Script; Competent in Web Design

EXPERIENCE:

Webmaster, LightzOut Entertainment & Production Company; Albany, NY. July 2007 - Present

• Design, create, and maintain newly established music and event company website for company artists and events promotions.

• Update website on a regular basis with new client information.

• Troubleshoot for any technical issues relating to website functionality.

Computer Instructor/ Camp Counselor, Mentoring Program, Siena College, Loudonville, NY. Summer 2007

• Explained introductory computer skills to inner-city children ages 7-14.

• Created educational website resource for children.

• Monitored safe internet viewing.

Resident Assistant, Dept. of Residential Life, Siena College, Fall 2005- Spring 2007

• Responsible for enforcement of college policy in residential living areas.

• Developed and implemented events and programs to enhance the student experience.

• Advised and referred students facing academic, social, and/or personal challenges.

• Filed room condition, census, duty log, and maintenance reports on a regular basis.

Student Consultant, Information and Technology Services, Siena College, Fall 2005

• Managed “Help Desk” and assisted students, faculty, and staff with technology related issues.

• Maintained computer labs for maximum efficiency of use.

• Referred computer related issues to lead user specialist when necessary

• Solved computer and printer related problems

• Acquired thorough knowledge of all institutional computer operations

Orientation Leader, Dept. of Student Affairs, Siena College, Summer 2005

• Assisted incoming freshman with transition to college life.

• Conducted group workshops related to college resources and time management.

• Supervised incoming freshman in residence hall.

ACTIVITIES/HONORS:

• Executive Board Member, Black and Latino Student Union, Siena College,

Spring 2007 – Present

• Executive Member, Muslim Student Association, Siena College,

Fall 2006- 2007

• H.E.O.P Academic Honors, Siena College, Fall 2004, Spring 2006

• Mentor, Big Brothers Big Sisters, Siena College 2004- Present

• Mentor, H.E.O.P., Siena College, Fall 2005; Urban Youth Scholars Program,

Siena College, Fall 2004

Caitlin S Sheil

cs24shei@siena.edu

Permanent Address: Present Address:

37 Rudolph Weir Jr. Rd. Siena College

Leeds, NY 12451 515 Loudon Rd SPOB 2422

(518) 755-3008 Loudonville, NY 12211

(518) 755-3008

Objective: An entry level position in the field of information technology.

Education:

Siena College, Loudonville, NY

B.S. in Computer Science, May 2008

Study Abroad: Siena, Italy Spring 2007

Computer Skills:

Knowledge in HTML, XHTML, PHP, CSS, MySQL, Microsoft Word and Powerpoint, Macromedia Dreamweaver, Flash and Fireworks, Adobe Photoshop

Related Experience:

Building website, Shaker Heritage Society

Created and currently maintaining website, Catskill Fire Company,

Additional Experience:

Maintenance, New York State Bridge Authority (NYSBA), Catskill NY.

May 2005 – August 2007 (seasonal)

Secretary, R.C. Lacy Inc. Car Dealership, Catskill NY. October 2003 – September 2004

Activities:

Computer Science Club, Fall 2007 - present

Big Brother Big Sister, Siena College Mentor Program, Fall 2005 - Fall 2007

Andrey A. Taran

6 Sugarbush Rd

Clifton Park, NY 12065

taran.andrey@

OBJECTIVE

Obtain a challenging position in the field of Computer Science that would utilize my Java programming skills.

EDUCATION

Siena College, Loudonville, NY

Bachelor of Science in Computer Science, May 2008

Major GPA: 3.15 / 4.0

RELEVANT COURSES

Introduction to Computer Science, Data Structures, Object-Oriented Design and Programming, Analysis of Algorithms, Operating Systems, Artificial Intelligence, Calculus I / II / III, Discrete Mathematics I, Discrete Mathematics II, Linear Algebra

WORK EXPERIENCE

Business Machines Sales Associate, Staples, Latham, NY, October 2005 – July 2006

• Assisted customers in making purchasing decisions to best fit their budget

• Provided technical support for the customers’ IT needs

• Consulted customers on the advantages of various tech products

• Installed various hardware components

Technical Administrator Assistant, Siena College, Latham, NY, August 2006 –

December 2006

• Assisted in maintaining an array of PCs for lab use

• Analyzed intricacies of installation of various software packages including SAS

• Performed troubleshooting of Windows XP PCs and their peripherals

COMPUTING EXPERIENCE

Operating Systems: DOS, Windows 3.1 / 95 / 98 / NT4 / 2000 / XP, Linux

Programming Languages: proficient in Java;

familiar with C / C++, Delphi, HTML, BASIC and VB

Application Software: Microsoft Office, OpenOffice, Dreamweaver,

Knowledge of PC hardware

LANGUAGE SKILL

Fluent in Russian Language

-----------------------

Acceptance Test

Detailed Design

Preliminary Design

Requirements Specifications

Software Plan

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download