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

[Bhanu Teja Motupalli]

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.