Watson Capstone Project Management System

Scope

WCPMS web site is developed to arrange and organize project assessment spreadsheets. The main purpose of the project is to reduce paper work while saving time and increasing the efficiency of the current system. The website is easy to use not only for the professors or teaching assistants but also for students. This project has been started on the school year of 2013-2014. It is to be considered as Phase I. This year’s effort has two phases, Phase IA and Phase II. The project is sponsored by Watson Capstone Project, and the customer is Prof. Maynard. The site of operation will be Binghamton University.

WCPMS Context Diagram

System Requirements

WCPMS-2 shall provide for entry of project IDs, names, descriptions, sponsors, clients, advisors, assigned students, and allocated funds. - {WCP99-001}

WCPMS-2 shall provide for the generation of emails with fields populated from the WCPMS database. - {WCP99-002}

WCPMS-2 shall provide for the generation of reports with fields populated from the WCPMS database. - {WCP99-003}

WCPMS-2 shall provide for the generation of spreadsheets with fields populated from the WCPMS database. - {WCP99-004}

WCPMS-2 shall be installed on a new WCP.Binghamton.edu server running CentOS7. - {WCP99-005}

The WCPMS shall maintain compatibility with the BU Central Authorization System. - {WCP99-006}

The WCPMS should maintain growth provisions for tracking lab equipment, computers, and workspace assignments. - {WCP99-007}

An SQL script shall be provided that creates and initializes the WCPMS database. - {WCP99-008}

System shall have two types of accounts, Students and Professor/TAs. - {WCP99-009}

System shall distinguish users according to their BU ID (Professor/Student). - {WCP99-010}

Students shall be able to input their personal information (BU ID, name, major, GPA, e-mail, phone number etc.) - {WCP99-011}

Students shall be able to input their skills and abilities. - {WCP99-012}

Students shall be able to input their courses. - {WCP99-013}

Students should be able to input their current schedules as spreadsheets (.xlsx, excel format). - {WCP99-014}

Students should be able to view the projects that they are assigned to. - {WCP99-015}

Students should be able to view the due dates of their projects. - {WCP99-016}

Professors shall be able to input their personal information (name, title, department, e-mail, phone number) - {WCP99-017}

Professors shall be able to add/edit/delete project descriptions. - {WCP99-018}

Professors shall be able to access the spreadsheets filled by students. - {WCP99-019}

Professors shall be able to assign students to projects. - {WCP99-020}

Professors shall be able to generate e-mails to students from the website. - {WCP99-021}

The connection with the database, the SQL Server, shall be provided through Apache via the written PHP codes. {WCP99-022}

The inputs (inputs entered by the users) shall be sent to the SQL Server over Apache, and the corresponding tables, lists or any kind of information shall be returned as outputs. {WCP99-023}

System shall have two types of accounts as mentioned in WCP99-009, Students and Professor/TAs.

System shall distinguish users according to their BU ID (Professor/Student) as mentioned in WCP99-009.

Students shall not have access to add/edit/delete projects created by professors. - {WCP99-024}

Students shall not have access to other students’ or professors’ personal information. - {WCP99-025}

User Interface

Since we are building this website for the University we tried to choose the colors and styles that are similar to the current University services such as BU Brain and Blackboard.

This is the Home page that both the students and professors see when they login to the system. They can view their personal information and view the announcements.

File:Student Projects.jpg