Software Plan
Simnet View
Requested By:Ms. Jami Cotler
Lecturer of Computer Science
Computer Science Department
SienaCollege
Dr. Timoth C. Lederman
Professor of Computer Science
Computer Science Department
SienaCollege
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.1 Problem Definition ...... 2
1.2 System Justification ...... 2
1.3 Goals for the System and for the Project ...... 2
1.4 Constraints on the System and for the Project ...... 2
1.5 Functions to be Provided ...... 3
1.6 User Characteristics ...... 3
1.7 Development/Operating/Maintenance Environments ...... 3
1.8 Solution Strategies ...... 3
1.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. Ledermanhave 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 astheir 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 datain 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.5Functions 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 allowother 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 FireworksMX 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 SienaCollege. 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.1Life Cycle Model: Linear Sequential (Classic Waterfall) Model
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:
NameEmailPhone
Kevin (518) 321-8839
Shane (603) 369-1449
James (518) 577-5286
Caitlin (518) 755-3008
Andrey
InnoSmart Technologies is organized as follows for the Simnet View project:
Kevin DeckerTeam Leader
Shane LeightonSystem Administrator
James MaybenWebmaster
Caitlin SheilDocumentarian
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 LeaderOrganizes and sets agenda for team and client meetings. Distributes work accordingly amongst team members and keeps the team on track for the semester.
System AdministratorMaintains all user accounts and software on the team’s computers.
WebmasterDesigns and maintains the team website.
DocumentarianCompiles and organizes all documents pertaining to the team.
Web DeveloperAssists 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 atimeline (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 oneteam 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 includingMicrosoft Office, Adobe Software Suite and a MySQL DBMS. Our team will be using PHP, HTMLand CSS to implement the online interface and the module to manage and analyzethe data. Oracle DBMS will be used to simplify the storage for futurereference. InnoSmart will also use a XML parser for its web application. We will be utilizing Microsoft Project and the techniques obtainedin Software Engineering to complete the design process.
2.7 Programming Languages
InnoSmart Technology will be using XHTML, CSS, PHPand 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 SienaCollege. 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.
InnoSmart TechnologiesSoftware Plan1
2.12 Timeline (Gantt Chart)
InnoSmart TechnologiesSoftware Plan1
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 Languageis 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:
Present Address: Permanent Address:
515 Loudon Road SPOB 4124 25 French Settlement Road
Loudonville, NY12211 Chateaugay, NY12920
518-321-8839 518-497-3217
EDUCATION:
SienaCollege, 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,SienaCollege, 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, SienaCollege, Information & Technology Services Dept., Loudonville, NY, 1/05-6/06, 9/07-Present
• Serve as a representative of SienaCollege 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 ASP.NET.
• 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, NH03301
(603) 369.1449
OBJECTIVE
To obtain a challenging position in the Information Technology field which utilizes my knowledge and allows for further learning.
EDUCATION
SienaCollege, 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,SienaCollege, Fall 2004 – Present
James Anthony Mayben Jr.
(518) 577-5286
Campus AddressPermanent Address
SienaCollege 685 Clinton Avenue
515 Loudon Road SPOB 2759 Albany, NY, 12206
Loudonville, NY12211
OBJECTIVE: To obtain a position where my skills in computer science will be of value.
EDUCATION:
SienaCollege, 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