1 / 8

Email function and Data Extract from ExamView in ASP

CIS 684 Instructor : Dr. Rushinek Tony Senita Yu-Wei Chang. Email function and Data Extract from ExamView in ASP . Introduction.

kristy
Download Presentation

Email function and Data Extract from ExamView in ASP

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CIS 684 Instructor : Dr. Rushinek Tony Senita Yu-Wei Chang Email function and Data Extract from ExamView in ASP

  2. Introduction • Our goal was to create a personalized form handler for ExamView tests so that we could host the exams ourselves without involving Examview, and this way we can also write our own code so that we can do anything we want with the results.

  3. The Process • First we obtained a copy of ExamView’s default PHP form handler CGI script. • PHP proved to be quite problematic to install and run with IIS and SMTP services in Windows. • Therefore, we decided to use the PHP script as a model to create an ASP script to handle the forms, which we knew IIS would be able to work with.

  4. The Process • First, the form handler ensures that all fields are filled out, and that the email entered is a well-formed email address. • It parses the form data to present the student with his or her results. • It sends an email to the professor with the results of the student’s exam. • Finally, we wrote new code to save the student’s data in a file for the entire class, which can be analyzed and manipulated in Excel (pivot tables, etc.)

  5. Extracted data in Excel 2007

  6. Pivot Table

  7. Pivot Chart

  8. Questions?

More Related