[Building Sakai] Where can we find Assessment Maximum Marks in Database.

[Karen Tsao]

Hi Bhanu,

In Samigo, we don't save the total max scores for assessments. We save the
individual score for each question. These scores are in the SCORE column in
SAM_ITEM_T table. So to get the max score for one assessment, you need to
join SAM_ASSESSMENTBASE_T, SAM_SECTION_T, and SAM_ITEM_T, get the scores for
every question in that assessment, and then add them up. For the published
assessments, you can do the same thing to SAM_PUBLISHEDASSESSMENT_T,
SAM_PUBLISHEDSECTION_T, and SAM_PUBLISHEDITEM_T.

In Gradebook, the NAME column in GB_GRADABLE_OBJECT_T table is Samigo's
published assessment title.

Thanks,
Karen

On Thu, Sep 15, 2011 at 3:30 AM, Bhanu Teja Motupalli <
bhanu1607 at rediffmail.com> wrote:

>
> Hi,
>
>         I have a problem with Assessments. I cannot able to find Assessment
> Maximum marks(not user's total marks). Can you please tell me, in which
> table these maximum marks well available.
>
>         I have seen Assessments titles and their maximum marks in
> gb_gradable_object_t. But these is no clear relation between this table and
> sam tables.
>
>          Can you please explain where the Assessment maximum marks will be
> held and relation between sam tables and gradebook tables.
>
>
> Regards
> Bhanu.
> --
> View this message in context:
> http://old.nabble.com/Where-can-we-find-Assessment-Maximum-Marks-in-Database.-tp32470573p32470573.html
> Sent from the Sakai - Development mailing list archive at Nabble.com.
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110915/b266d233/attachment.html