[Using Sakai] Oops, student identities concealed in test
Lydia Li
lydial at stanford.edu
Mon Oct 11 12:13:00 PDT 2010
Hi Warwick,
You can modify the back end DB by doing the following:
1. Find the published assessment id (Note it's the 'ID' column, not the
'ASSESSMENTID' column. That's for the original unpublished assessment),
by running this query:
select id from sam_publishedassessment_t where title = 'your
assessment title';
2. Use the id above and run this query below. This will list you all the
settings that are turned off by this particular assessment type.
select * from sam_publishedmetadata_t where assessmentid = :id
and entry = 'false'
3. You can change any settings by running individual UPDATE statement
on each setting. Or, if you want to turn on all the settings (which is
essentially the default assessment type), you can run this following:
update sam_publishedmetadata_t set entry = 'true' where
assessmentid = :id and entry = 'false'
That should give you back your Grading options. You might want to
try it out on a test instance first.
One last note, unless you understand exactly what each assessment
type does (the goal of assessment types is to hide complexity of the
settings) then I'd advise you to just use the 'Default Assessment Type'
which has all options available.
thanks,
Lydia
On 10/10/10 9:40 AM, Rob Coyle wrote:
>
> Yes, I am seeing that now too. This is new to me. In assessment types
> you can configure all the settings, but once you use that type to
> create an assessment you are limited to the settings you selected as
> part of the "type". Going back and adjusting the Assessment Type
> didn't adjust any assessments created under the old type, regardless
> if they published or not.
>
> However new assessments did pick up the changes to the type.
>
> If there is someone to tweak the settings on the backend in the
> database to get what you are looking for, I'm afraid that is beyond me
> as well.
>
> Sorry I couldn't be of more help. Hopefully someone else in the
> community who knows about the backend can assist further.
>
> Good luck.
>
> --Rob
>
> /Robert M. Coyle/,
>
> Instructional Designer | Instructional Technology and Distance
> Education |
> Johns Hopkins Engineering for Professionals | 6810 Deerpath Road |
> Elkridge, MD 21075 |
>
> o: 410.516.2291 | c: 443.271.0453 | rcoyle at jhu.edu
> <x-msg://18/rcoyle@jhu.edu> | www.ep.jhu.edu <http://www.ep.jhu.edu/>
>
> *From:* Josh Baron [mailto:Josh.Baron at marist.edu]
> *Sent:* Sunday, October 10, 2010 12:27 PM
> *To:* Warwick Chapman
> *Cc:* Rob Coyle; sakai-user; sakai-user-bounces at collab.sakaiproject.org
> *Subject:* Re: [Using Sakai] Oops, student identities concealed in test
>
> Ah, yes, if you select a specific "assessment type" you will not get
> all of the exam configuration settings (purpose of the assessment type
> feature is to allow you to limit the number of configuration
> settings). This may be different with 2.7.1 but with 2.6.3 at least I
> don't believe you can change the assessment type once you've set it
> and created the exam. You may be able to make that change in the DB
> but I'm not myself on the deep technical side and thus couldn't advise
> you on that option.
>
> Josh
>
>
> -----------------------------
> Joshua Baron
> Senior Academic Technology Officer
> Marist College
> Poughkeepsie, New York 12601
> (845) 575-3623 (work)
> Twitter: JoshBaron
>
>
>
> From: Warwick Chapman <warwickchapman at gmail.com>
> To: Rob Coyle <rcoyle at jhu.edu>
> Cc: Josh Baron <Josh.Baron at marist.edu>, sakai-user
> <sakai-user at collab.sakaiproject.org>,
> "sakai-user-bounces at collab.sakaiproject.org"
> <sakai-user-bounces at collab.sakaiproject.org>
> Date: 10/10/2010 12:22 PM
> Subject: Re: [Using Sakai] Oops, student identities concealed in test
> Sent by: sakai-user-bounces at collab.sakaiproject.org
>
> ------------------------------------------------------------------------
>
>
>
>
> Hi Rob
>
> Yes, we're using Samigo on 2.7.1 and we have that setting as well, but
> for whatever reason (perhaps because I used the Formative Assessment
> template instead of Timed Test) I do not see the "Grading" section
> under Settings.
>
> -- Warwick Bruce Chapman | +27 83 7797 094 | http://warwickchapman.com
> <http://warwickchapman.com/>
>
>
> On Sun, Oct 10, 2010 at 6:09 PM, Rob Coyle <rcoyle at jhu.edu
> <mailto:rcoyle at jhu.edu>> wrote:
> Not sure I fully caught what tool you are using specifically, or if
> this is instance related. We are on 2.6.4 and using Samigo Test and
> Quizzes. We have a Setting under Grading:
>
> Students' Identities:
>
> - Students' identities can be seen by graders
>
> - Anonymous grading only
>
> /Robert M. Coyle/,
>
> Instructional Designer | Instructional Technology and Distance
> Education |
> Johns Hopkins Engineering for Professionals | 6810 Deerpath Road |
> Elkridge, MD 21075 |
>
> o: 410.516.2291 | c: 443.271.0453 | rcoyle at jhu.edu | www.ep.jhu.edu
> <http://www.ep.jhu.edu/>
>
> *From:* sakai-user-bounces at collab.sakaiproject.org
> <mailto:sakai-user-bounces at collab.sakaiproject.org>
> [mailto:sakai-user-bounces at collab.sakaiproject.org
> <mailto:sakai-user-bounces at collab.sakaiproject.org>] *On Behalf Of
> *Josh Baron*
> Sent:* Sunday, October 10, 2010 11:50 AM*
> To:* Warwick Chapman*
> Cc:* sakai-user; sakai-user-bounces at collab.sakaiproject.org
> <mailto:sakai-user-bounces at collab.sakaiproject.org>
>
> *
> Subject:* Re: [Using Sakai] Oops, student identities concealed in test
>
> This is labor intensive but one work around we've used is to enter an
> unique comment into each student's exam feedback area (e.g. 1, 2, 3,
> 4, etc.) and then go to the gradebook and see what comment they have
> and then write down their name. You're left with a "key" for which
> unique number is which student.
>
> I agree with Stephen, I thought you can now change the setting on the
> exam after it was taken to reveal the names but if that isn't working
> then this is another option.
>
> Josh
>
>
> -----------------------------
> Joshua Baron
> Senior Academic Technology Officer
> Marist College
> Poughkeepsie, New York 12601
> (845) 575-3623 (work)
> Twitter: JoshBaron
>
>
>
> From: Warwick Chapman <warwickchapman at gmail.com
> <mailto:warwickchapman at gmail.com>>
> To: Stephen Marquard <stephen.marquard at uct.ac.za
> <mailto:stephen.marquard at uct.ac.za>>
> Cc: sakai-user <sakai-user at collab.sakaiproject.org
> <mailto:sakai-user at collab.sakaiproject.org>>
> Date: 10/10/2010 09:38 AM
> Subject: Re: [Using Sakai] Oops, student identities concealed in test
> Sent by: sakai-user-bounces at collab.sakaiproject.org
> <mailto:sakai-user-bounces at collab.sakaiproject.org>
>
> ------------------------------------------------------------------------
>
>
>
>
> Steven
>
> For some reason this assessment (Formative?) doesn't have the
> "grading" options in settings.
>
> -- Warwick Bruce Chapman | +27 83 7797 094 | http://warwickchapman.com
> <http://warwickchapman.com/>
>
>
> On Sun, Oct 10, 2010 at 11:38 AM, Stephen Marquard
> <stephen.marquard at uct.ac.za <mailto:stephen.marquard at uct.ac.za>> wrote:
> Hi Warwick,
>
> You should be able to change the settings of the published assessment
> from anonymous grading to show the identities.
>
> Regards
> Stephen
>
> >>> Warwick Chapman <warwickchapman at gmail.com
> <mailto:warwickchapman at gmail.com>> 10/10/2010 10:06 AM >>>
>
> Hi All
>
> I'm not quite sure how this happened but the test I setup (using
> formative
> assessment) for an entrance exam for 130+ candidates is now not showing
> the
> names of the "students" and just a submission number. I am certain
> that I
> did a practice export on Thursday and the names showed in the
> resultant
> spreadsheet.
>
> How can I establish the names of the candidates?
>
> -- Warwick Bruce Chapman | +27 83 7797 094 | http://warwickchapman.com
> <http://warwickchapman.com/>
>
>
>
>
>
> ###
> UNIVERSITY OF CAPE TOWN
>
> This e-mail is subject to the UCT ICT policies and e-mail disclaimer
> published on our website at_
> _http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from
> +27 21 650 9111. This e-mail is intended only for the person(s) to whom
> it is addressed. If the e-mail has reached you in error, please notify
> the author. If you are not the intended recipient of the e-mail you may
> not use, disclose, copy, redirect or print the content. If this e-mail
> is not related to the business of UCT it is sent by the sender in the
> sender's individual capacity.
>
> ###
>
> _______________________________________________
> sakai-user mailing list_
> _sakai-user at collab.sakaiproject.org
> <mailto:sakai-user at collab.sakaiproject.org>_
> _http://collab.sakaiproject.org/mailman/listinfo/sakai-user
>
> TO UNSUBSCRIBE: send email to
> sakai-user-unsubscribe at collab.sakaiproject.org
> <mailto:sakai-user-unsubscribe at collab.sakaiproject.org> with a subject
> of "unsubscribe"
>
> _______________________________________________
> sakai-user mailing list
> sakai-user at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-user
>
> TO UNSUBSCRIBE: send email to
> sakai-user-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
>
> _______________________________________________
> sakai-user mailing list
> sakai-user at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-user
>
> TO UNSUBSCRIBE: send email to sakai-user-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20101011/1ff31500/attachment-0001.html
More information about the sakai-user
mailing list