SELECT distinct T_Survey_Questions.QuestionID AS Q_QuestionID, T_Survey_Questions.QuestionDesc,T_Survey_Questions.Active,T_Survey_Answers.AnswerID AS Q_AnswerID,T_Survey_Answers.AnswerDesc,SUBQUERY.QuestionID AS S_QuestionID,SUBQUERY.AnswerID AS S_AnswerID, ImgStr FROM T_Survey_Questions INNER JOIN T_Survey_Question_Answer ON T_Survey_Questions.QuestionID=T_Survey_Question_Answer.QuestionID INNER JOIN dbo.T_Survey_Answers ON T_Survey_Answers.AnswerID=T_Survey_Question_Answer.AnswerID LEFT OUTER JOIN ( SELECT T_Survey_Responses.QuestionID, T_Survey_Responses.AnswerID, CASE WHEN Correct=T_Survey_Responses.AnswerID THEN 'right' ELSE 'wrong' END As ImgStr From dbo.T_Survey_Responses INNER JOIN T_Survey_Question_Answer ON T_Survey_Responses.QuestionID = T_Survey_Question_Answer.QuestionID WHERE StudentID='#S_ID#' AND SurveyID=(SELECT MAX(SurveyID) FROM T_Survey_Responses WHERE StudentID='#S_ID#') AND Correct <> 0 )SUBQUERY ON T_Survey_Questions.QuestionID=SUBQUERY.QuestionID where isnull(T_Survey_Questions.Active,0)=1 ORDER BY T_Survey_Questions.QuestionID SELECT TOP 1 FirstName, LastName, Email, InstructorEmail, Correct, Score FROM T_Survey_Summary INNER JOIN T_Survey_Students ON T_Survey_Students.StudentID = T_Survey_Summary.StudentID INNER JOIN T_Survey_Responses ON T_Survey_Summary.SurveyID=T_Survey_Responses.SurveyID AND T_Survey_Summary.StudentID=T_Survey_Responses.StudentID WHERE T_Survey_Summary.StudentID='#S_ID#' ORDER BY SurveyDate DESC,T_Survey_Summary.SurveyID DESC FCC - Virtual Library Orientation (VLO) Assessment

YOUR SCORE: #NumberFormat(Score*100)#% (#Answers# out of 15)
SYSTEM MESSAGE!
#sys_msg#

Let’s see how much you’ve learned about FCC’s Library and about finding, evaluating and using information. If your instructor has required that you complete this assignment, you can forward your results to his/her email.

Student Last Name: 
Student First Name: 
Student Email:  @myfcc.frederick.edu
Instructor Email: 
(if instructor requires proof of score). Search the faculty/staff directory; the email name convention is [email protected], e.g., Nicole Martin would be [email protected].


 Question #loopID#
#Q_Survey.QuestionDesc#
checked>  #chr(96+loopQID)#. #Q_Survey.AnswerDesc#