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

[Karen Tsao]

Hi Bhanu,

The scores of all the questions are in sam_item_t, not only the questions
from question pools. Here is a simple query so you can know the relationship
between these tables:

For working assessments:
SELECT i.score from SAM_ASSESSMENTBASE_T a,  SAM_SECTION_T s, SAM_ITEM_T i
where a.id = s.assessmentid and s.sectionid = i.sectionid

For published assessments:
SELECT i.score from SAM_PUBLISHEDASSESSMENT_T a,  SAM_PUBLISHEDSECTION_T s,
SAM_PUBLISHEDITEM_T i where a.id = s.assessmentid and s.sectionid =
i.sectionid

Thanks,
Karen

On Thu, Sep 15, 2011 at 10:09 PM, Bhanu Teja Motupalli <
bhanu1607 at rediffmail.com> wrote:

>
> Hi Karen,
>
>     Thanks for your reply. Now i can found the maximun marks of assessments
> for those questions coming from question pool. Then how about the question
> created by the user at the time of assessment creation. i cannot able to
> find the assessmentid in sam_publishedsection_t. Then, where these question
> and marks will save. In which tables i can found this information.
>
> Regards
> Bhanu.
>
> Karen Tsao wrote:
> >
> > 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"
> >>
> >
> > _______________________________________________
> > 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"
> >
>
> --
> View this message in context:
> http://old.nabble.com/Where-can-we-find-Assessment-Maximum-Marks-in-Database.-tp32470573p32476646.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/9fd318d6/attachment.html