[Using Sakai] Oops, student identities concealed in test
Warwick Chapman
warwickchapman at gmail.com
Mon Oct 11 22:20:10 PDT 2010
Lydia
I did it like this (sorry I only saw now that I sent this to Rob only:
In the settings for the published assessment, under option "Assessment
Released To", there is a Published Assessment URL which give the "ALIAS" of
the test, a long code like
"ba96b21c-6fbf-4b23-984c-2f4a2000a2241286529454506".
Then in the SAM_PUBLISHEDMETADATA_T table, find the code against the label
called "ALIAS" and look at the corresponding ASSESSMENTID. Then find the
label against that ASSESSMENTID called "testeeIdentity_isInstructorEditable"
and set it to true.
Once that's done, I could configure the identities to be viewable in
Grading.
Thanks for the below, it clears up that it would be safe to set them all to
true.
-- Warwick Bruce Chapman | +27 83 7797 094 | http://warwickchapman.com
On Mon, Oct 11, 2010 at 9:13 PM, Lydia Li <lydial at stanford.edu> wrote:
> 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 | www.ep.jhu.edu
>
>
>
> *From:* Josh Baron [mailto:Josh.Baron at marist.edu <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><warwickchapman at gmail.com>
> To: Rob Coyle <rcoyle at jhu.edu> <rcoyle at jhu.edu>
> Cc: Josh Baron <Josh.Baron at marist.edu> <Josh.Baron at marist.edu>,
> sakai-user <sakai-user at collab.sakaiproject.org><sakai-user at collab.sakaiproject.org>,
> "sakai-user-bounces at collab.sakaiproject.org"<sakai-user-bounces 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
>
>
> On Sun, Oct 10, 2010 at 6:09 PM, Rob Coyle <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
>
>
>
> *From:* 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
>
> *
> 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>
> To: Stephen Marquard <stephen.marquard at uct.ac.za>
> Cc: sakai-user <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
> ------------------------------
>
>
>
>
> 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
>
>
> On Sun, Oct 10, 2010 at 11:38 AM, Stephen Marquard <
> 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> 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
>
>
>
>
>
> ###
> 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*
> *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"
>
>
> _______________________________________________
> sakai-user mailing listsakai-user at collab.sakaiproject.orghttp://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/20101012/61726021/attachment-0001.html
More information about the sakai-user
mailing list