CSCE Capstone

Student Site for Individual and Collaborative Activities

CSCE Capstone

Student Site for Individual and Collaborative Activites

Team 7 – Room Scheduler

Team Members:

Miguel Campbell

Creighton France

Jackson DiRienzo

Alex Lim

Wesley Parker

Description:

The University of Arkansas Data Science Program would like a solution that will allow Data Science students to reserve rooms in the new Champions Hall common space. Having a common space solely for the Data Science Program fosters a sense of community and collaboration amongst the department’s students, so it is important that this space be efficiently used. The capstone team will provide a solution by building a web application in Python, which students can use to reserve rooms for maximum usage efficiency, and it is an opportunity for Data Science students to be involved in the application’s future development and maintenance.

Schedule (Fall)
 Tasks  Dates

Background research and preliminary project planning 

  • Complete Django tutorial 
  • Create GitLab Project 
  • Design preliminary architecture (models, views) 
  • Preliminary project proposal 
09/15 – 10/15 

Final project planning 

  • Finalize architecture (down to the method/function/endpoint) 
  • Finalize deployment process with IT 
  • Finalize project proposal 
  • Finalize design document 
10/15 – 12/15 
Schedule (Spring)

 

Tasks  Dates 

Sprint 1 

  • Address Additional Features with Project
  • Implement User, Room, Reservation, and Availability models according to architecture outline 
  • Implement barebone views and map them to the appropriate URL
  • Create updated frontend mockups (Modern Styling)
01/17 – 01/31 

Sprint 2

  • Review and confirm new UI proposals with Sponsors
  • Implement Login, Logout, Reservation, and Reservation Confirmation
  • Implement HTML/Django/database interaction for above views
  • Write unit tests for views’ functions 
02/01 – 02/14 

Sprint 3

  • Implement Dashboard,  Admin Dashboard, and Reservation Cancellation views
  • Implement HTML/Django/database interaction for above views
  • Code CSS to match frontend mockup
02/15 – 02/28 

Sprint 4 

  • Discuss and complete backlog tasks
  • Implement SSO
  • Implement Dashboard Calendar
  • Implement Reservation Manage Grid
  • Update Reservation database interactions to utilize Status Codes
  • Set up account/credentials for DASC Scheduler Email
03/01 – 03/14 

Sprint 5

  • Begin end-user guide 
  • Begin programming documentation in GitHub
  • Implement Admin Manage Grid Functions
  • Implement Outlook Invites/Emails
  • Implement database interactions for Report, Cancelled Reservations
  • Begin report/presentation (Preliminary)
03/15 – 04/04 

New Function Freeze

  • Bug Hunting
  •  All-Day Demo for DASC Students (receive feedback and concerns)
  • Patch bugs found during Bug Hunting and Day Demo
  • Finalize Styling and other Finishing Touches
  • Make modifications/changes to app based on performance 
04/05 – 04/18 

Code Freeze

  • Final project modifications 
  • Finalize end-user guide 
  • Finalize programming documentation in GitLab 
  • Finalize deployment 
  • Final report/presentation (April 27) 
04/19 – 04/27 

Deliverables

Final Proposal Report

Final Proposal Slides

Task List (Trello)

Meeting Records

Frontend Mocks

Source Code

Application