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.

Here, the students are able to upload/update their personal information, grades and technical skills.

This page shows a list of the current projects where the students are able to view the project details and apply to up to 4 preferences.

If the students wish to enter a personal statement to emphasize on a skill or anything else, this is where they do so.

The professors enter the project details as well as uploading the project proposal in any type of format that is supported by Google Docs.

This page is similar to the Projects page of the Student side. It shows the details of active projects.

Here, the professors are able to view students and all of their information they uploaded; their personal statements, preferences, grades, skills etc.

This is the page where the students get assigned to the projects. A project is selected from the upper list and the project details is shown on the left whereas the students who applied to the project and their information is shown on the right. If needed, a list of unassigned students is also available.

The purpose of this page is basically the same as the Project Assignment page, with a spreadsheet view allowing the user to work on multiple projects at a time.

Here the user has the option of creating new announcements, enabling/disabling the project application for students, upload a full list of students to the database and generate excel reports of lists of students and reports

The Students Report that is generated from the Admin Panel that has the students information.

The Projects Report that is generated from the Admin Panel that has the projects information.