*** CAPSTONE PROJECT SELECTION PROCESS ***

This file describes the directory structure of the code for our project! All of our automation and back-end scriptings were done through Google Apps Script and are viewable in the Spreadsheet and Forms folders. The front end utilized Google Sites elements and HTML embeds, the latter of which can be found in the Website folder.


*** HTML STRUCTURE ***

The website can be found here: 
https://sites.google.com/d/1sUIsencVwrGK2nBF1Gyq0-XP_dOmH2xG/p/1HGtAA4sV2TOPHABQREziIaRgyy-Qf3KH/edit

Each Capstone course has its own embedded button on the home page.
- Capstone I.html
- Capstone II.html
- Senior Project.html

Each major also has its own embedded button on the projects page.
- Computer Science.html
- Cybersecurity.html
- Information Technology.html

There is also a project list template contained in Project Template.html.

These files are embedded within the website and do not need further installation before development.


*** SPREADSHEET SCRIPT STRUCTURE ***

The spreadsheet and website each contain scripting that can be found below:

https://docs.google.com/spreadsheets/d/132w-qfCYjv3-N_eptSbiT4HE_BYDEHiRi8tNft4hGa8/edit#gid=0
- Global.gs:		Gathers information from the spreadsheet for all other spreadsheet scripts to utilize. Also provides some utility functions.
- Forms.gs:			Updates the forms through onEdit or daily triggers. Only runs inclusively between deadlines.
- Selection.gs:		Places students in projects/groups through a daily trigger. Group placement occurs once after the deadline. Project placement occurs inclusively between deadlines
- Email.gs:			Emails students information about their placements through a daily trigger. Starts occurring 1 day after the start date and stops 1 day after the deadline date.
- Menu.gs:			Creates a menu for spreadsheet users to modify deadline dates or cleanly clear data.
- Reset.gs:			Clears and backs up information on the spreadsheet. This will only execute through the menu.
- Project Info.gs:	Generates project lists for each major. Deployed once for each major and is otherwise unused.


*** FORM SCRIPT STRUCTURE ***

Each form's script can be found below:

Capstone I: https://docs.google.com/forms/d/1mfUwgOOB_VAdBixiVKv2ozR08BW168ZJDKbXxzTp-2w/edit
- Submit Response.gs:		Submits a formatted version of a Capstone I student's preference to the spreadsheet through an onSubmit trigger.
- Accepting Responses.gs:	Opens/closes the form through a daily trigger. Opens at the starting date and closes on the end date.

Capstone II: https://docs.google.com/forms/d/1dS0ftxq1kjT-YpTVbpYK75MNA3puLDihPc6zr6nny5M/edit
- Submit Response.gs:		Submits a formatted version of a Capstone II student's preference to the spreadsheet through an onSubmit trigger.
- Accepting Responses.gs:	Opens/closes the form through a daily trigger. Opens at the starting date and closes on the end date.

Senior Project: https://docs.google.com/forms/d/1w6r8qCtHYCVf-Rr37ScsslgsYNISkRNXXPf7Vt4Z9I4/edit
- Submit Response.gs:		Submits a formatted version of a Senior Project student's preference to the spreadsheet through an onSubmit trigger.
- Accepting Responses.gs:	Opens/closes the form through a daily trigger. Opens at the starting date and closes on the end date.

Project Proposal Form: https://docs.google.com/forms/d/17rS5DydlyaZv7sWfcw_Y17bdrWFo_eqM5XKCV0sY37E/edit
- Submit Response.gs:		Submits a formatted version of a project proposal to the spreadsheet through an onSubmit trigger.
- Accepting Responses.gs:	Opens/closes the form through a daily trigger. Opens after the end date and closes before the start date.


NOTE: All files can be opened with a text editor such as Notepad.