Student+Survey


 * created the survey on phpESP
 * http://dlwashington.com/phpESP/
 * Create the survey from hard copy in Donna's drawer under survey.
 * Make sure all settings are input as outlined in hard copy.
 * have someone proof the survey
 * set survey in test mode
 * put instructions here
 * send survey to tester
 * Activate the survey
 * Go to management interface
 * Clicked activate
 * Use copy email saved dlearning drive under Stuemail
 * get the student email addresses
 * get user extract file information
 * Open user extract file
 * export to excel
 * delete the row that says Users Extract
 * save the file as a Text (tab delimited) file on the dlearning drive under Stuemail and qtr folder
 * close the file (only)
 * re-open the file to where you saved it.
 * delete empty columns (probably column I)
 * Save Again
 * Get Student course assignment information
 * Open student course assignment information
 * export to excel
 * delete all rows above all column titles
 * save the file as a Text (tab delimited) file on the dlearning drive under Stuemail and qtr folder
 * close the file (only)
 * re-open the file to where you saved it.
 * delete empty columns (probably column C)
 * Save Again
 * import extract information into StudentEmail database located on the dlearning drive in the folder named Stuemail.
 * empty the users extract table
 * Open table
 * click the small square between rows and columns to highlight all data
 * hit delete key
 * import user extract data into user extract table
 * File, get external data, import
 * select file
 * click next and make sure you click the box named First Row Contains field names
 * click next and make sure radio button is selected near IN an Existing table and choose User Extract file
 * click next and make sure all fields are set to data type "text"
 * click next and select no primary key
 * click next and finished
 * Import Student Assignment data into student assignment table
 * File, get external data, import
 * select file
 * click next and make sure you click the box named First Row Contains field names
 * click next and make sure radio button is selected near IN an Existing table and choose User Extract file
 * click next and make sure all fields are set to data type "text"
 * click next and select no primary key
 * click next and finished
 * Open Student email table and delete data
 * Update student email append query
 * open query
 * change criteria to current quarter
 * run query
 * Export student email table to excel
 * send the emails
 * copy email address from excel file into outlook under bcc and cc Andy
 * outlook is restricted to 1,000 recipients per email.
 * copy email address from excel file into outlook under bcc and cc Andy
 * outlook is restricted to 1,000 recipients per email.