Making Pat Hine's (PatH) very important ChemGrades DB more robust, and enabling necessary increased functionality, especially for teaching faculty and students. Ensuring its long-term support and operation.

To do's and questions

Establish procedure for PatH to update web-hosted data. "Push the button".

As of 7/31/13, function doesn't exist for PatH.

Establish semester-end procedures and processes. Includes:

Pat pulling the final data
The data getting zeroed out in each of the ChemGrades DBs before the start of their next use

Establish semester-start procedures and processes. Includes:

Initially populating the DB with PeopleSoft data via a PeopleSoft import.
- Question: Can a vetted clone of a DB on Pat's desktop be used to replace the server production DB?
- Function tends to be of most value at the beginning of the semester. Other times? (See revert procedure, below).

Establish DB revert procedure. Initiating request and subsequent restoration from back-up.

Likelihood of needing to do this is reduced because Pat and others can run recent clone of production DB (from backup) and test on own desktop first.

Ensure Pat's "low friction" access to the backup files.

Do in a way to minimize need for mediation by others. Pat may need access during a weekend or after-hours, for example.

Enable Pat's view of DB from home.

View only (where web access or clone (backup) would suffice), or are modifications required?
Web version OK for view-only of some data, but obviously not as flexible for searching.
Idea 1: With FMPro installed on dept. laptop, access AS's FMPro server off-campus (possible?) and do the work that way.
Idea 2: Enable Remote Desktop on PatH's main work computer. Access from off-campus via VPN.

Ensure security of FERPA data in Grades DB.

Who else has access to Grades DB FMPro DB?
Ideal: Make all access via NetID/ NetID p/w, not via FMPro DB's own controls.
- Control NetID membership via Active Directory groups.
  - Start with Grad TA access, via theTA room kiosks? Also start with faculty access?
  - Once process confirmed, establish procedure for enabling and disabling NetID access to Grades FMPro DB by grads and faculty
    - Can take ChemIT staff less than a minute to do this, and is effective immediately.