 |
 |
Hi Arthur, Below is a snipet if sql I use to extract out survey results from the db. I have trimmed it down a bit to only pull those incomplete attempts (where attempt.status = '3'). Because it contains all the tables required to pull survey results it is NOT optimised to only find incomplete attempts and I have never used it for this purpose but I assume it will give you what you want. You will need to change the condition on the third last line of this sql to the name of your survey. Hope this is helpful select distinct um.user_id, um.lastname, cm.course_name, gbm.title, att.status, att.attempt_date from bb_bb60.course_main cm, bb_bb60.course_users cu, bb_bb60.users um, bb_bb60.gradebook_main gbm, bb_bb60.gradebook_grade gbg, bb_bb60.attempt att, bb_bb60.qti_asi_data adt1, bb_bb60.qti_result_data qres1, bb_bb60.qti_asi_data adt2, bb_bb60.qti_result_data qres2, bb_bb60.qti_asi_data adt3, bb_bb60.qti_result_data qres3 where cm.pk1 = cu.crsmain_pk1 and cm.pk1 = adt1.crsmain_pk1 and cu.users_pk1 = um.pk1 and cu.pk1 = gbg.course_users_pk1 and gbg.gradebook_main_pk1 = gbm.pk1 and att.gradebook_grade_pk1 = gbg.pk1 and att.qti_result_data_pk1 = qres1.pk1 and gbm.qti_asi_data_pk1 = adt1.pk1 and qres1.qti_asi_data_pk1 = adt1.pk1 and qres2.parent_pk1 = qres1.pk1 and qres2.qti_asi_data_pk1 = adt2.pk1 and qres2.pk1 = qres3.parent_pk1 and qres3.qti_asi_data_pk1 = adt3.pk1 and gbm.title = 'VLE Entry Survey' and att.status = '3' and cu.role = 'S' order by um.user_id Cathy Cathy Colless VLE Application Manager e-Learning Development Team Projects Office Raymond Burton Library University of York York YO10 5DD United Kingdom Email: [log in to unmask] Tel: +44 (0)1904 32 1140 Fax: +44 (0)1904 32 1130 http://www.york.ac.uk/univ/org/vle/ -----Original Message----- From: Blackboard/Courseinfo userslist [mailto:[log in to unmask]] On Behalf Of Arthur Loughran Sent: 19 January 2006 13:54 To: [log in to unmask] Subject: Identifying survey incompletes Hi, I have a survey in which 695 students attempted (opened it) but not all completed (ie Submitted). Non-submission is shown as a padlock and so we can count the padlo-cks and subtract from the 695 and find out how many people actually submitted. This gets the percentages right. I have one wee problem, ie there are 6585 students on the survey and the system lists them 25 at a time. Hence I have a lot of clicking to do in order to count the padlocks. I am praying that someone can tell me a much simplier way of determining the non-submitters. thanks, Arthur Loughran >>>>>>>>>>>>>>>>>>>>>>>>>>>>> Dr. Arthur J. Loughran Senior Lecturer Centre for Learning and Teaching University of Paisley Paisley PA1 2BE tele: +44-(0)141-848-3558 fax: +44-(0)141-848-3822 email: [log in to unmask] >>>>>>>>>>>>>>>>>>>>>>>>>>>>> Legal disclaimer -------------------------- The information transmitted is the property of the University of Paisley and is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination and other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. --------------------------