Implementation - Automatic Helper Finder

2. Implementation of Automatic Helper Finder:

• Integration with Jim Clause's search tool for searching keywords in transcripts.
• Connection to the VC Database
• Queries to search for weak courses of students and keywords per course.

Pseudo code:

• When Automatic Helper Finder option is selected by the user:
  • Connect to Database
  • Perform query (in the Database) to select the weak courses of the current student (courses in which his/her grade is less than 60).
  • Perform query (in the Database) to select the keywords (or topics) of the weak courses of the current student.
  • Use Search in Transcripts Tool, to look for users who have mentioned any of the keywords.
  • Perform query (in the Database) of all the students who have been retrieved by the transcript search and obtain email addresses.
  • Display all the weak courses, and contact information of the potential helpers (except from the current user).
  • If no helpers or weak courses are found, inform the user.