CLSPo Final Presentation

1
CLSPoFinal Presentation

• Powered By Group LISP
• Caitlin Baum
• Curt Dennis
• Bill Michaels
• John Robbins

2
What is it?

• CLISPo (CSE Lab Submission Portal)
• Friendly and more customizable interface for
  student, TA, and Teacher interaction.
• Processes files much more easily than previous
  portals.
• Quickly access all labs, graded or ungraded at
  the click of a button.
• View all grades, and sort classes with one easy
  to use Main page.

3
Implementation

• The final portal is designed according to the
  final design document.
• Each member took on individual modules.
• Using group programming sessions, the modules
  were worked on together, to improve efficiency.
• Using a CSS sheets and JAVAScript, the interface
  can easily be modified to a desired look and
  feel.

4
Login Page

• First page that the user retrieves.
• Verifies username and password information from
  the database.
• Warns the user if the login is invalid.

5
Forgot Password

• Gives the user an option to retrieve password
  information from the database.
• Generates an e-mail that is delivered to the
  specified user.

6
Main

• Access Control for the bulk of the interface.
• Output dynamically changed depending on Access
  Level (TA, Professor, Student).
• Updates to show particular lab queries.
• Generates links and checkboxes for downloading
  and uploading files.

7
Main (Student View)
8
Main (TA/Professor View)
9
Submit

• Student can submit labs that will be added to the
  database.
• The labs are time stamped as they are submitted.

10
Archiver

• Function to control the download of all files.
• Servlet takes an array of strings and compresses
  into a zip file.
• The zip file is then streamed directly to the
  user without saving it locally.

11
Admin

• Easy to use interface that allows for Professors
  to add or remove students from classes.

12
Admin (continued)

• Also allows for the addition and removal of
  courses offered.
• Here the Professor can assign TAs to classes.

13
Block Diagram
14
Testing

• Project was tested using bottom up integration
  testing.
• Developers tested individual modules using throw
  away code. This simplified the integration
  process.
• Development took place across multiple accounts,
  and were then integrated for full system testing.

15
Implementation Challenges

• Raw number of SQL queries, and dynamic content
  causes the servlets to be more complex in design.
• Working knowledge of HTML forms and tables. CSS
  to globally modify the look and feel of the
  portal.
• JAVAScript to generate the check all options.
• File upload and streaming file download.
• E-mailing students with the ForgotPassword
  Servlet.

16
Design Discrepancies

• Logout servlet was not needed.
• Archiver parameter changes. It no longer uses
  the database.
• Archiver does not generate .tar.gz files,
  instead it generates .zip files.
• Original Main function definitions were not
  necessary.

17
Extensions and Improvements

• Comma Separated Value (CSV) input.
• Password encryption/decryption.
• Secure Login.
• General Security improvements for SQL database
  access.
• More administration options.
• More customizable user interface.

18
Phase I Contributions

• Requirements Document
• Presentation/Slides Caitlin
• Document Entire Group

19
Phase II Contributions

• Design Document
• Presentation/Slides John Robbins
• Document Caitlin, Curt, and Bill.

20
Phase III Contributions

• Implementation
• Caitlin
• Main, Admin, SQL Queries, Database
  creation/maintenance.
• Documentation
• Curt
• Login, Forgot Password, Main, SQL Interfacing,
  Logging functionality.
• Presentation/Slides

21
Phase III Contributions

• Implementation (contd)
• Bill Michaels
• Admin, Archiver, Main, Submit
• Graphics
• CSS, JavaScript and HTML finishing touches.
• Demonstrator
• John Robbins
• Admin, CSS, JavaScript, HTML Template
• Documentation

22
Conclusion

• Successful Implementation.
• Met all design constraints.
• Added extra functionality and user friendly
  options.
• Better understanding of JAVA, JAVAScript, CSS,
  HTML, and SQL.
• Fantastic hard working group members made the
  difference.

23
Demonstration

• http//www.cse.msstate.edu/dcspg9/
• http//disney.cse.msstate.edu10049/dcsp/