[Building Sakai] Question in creating new course site
Zhen Qian
zqian at umich.edu
Thu May 21 09:34:38 PDT 2009
Phuc Bui:
As I said, it all depends on your institution's implementation for
getting the right information into db or using the external provider
approach.
But here is the result of using the sample data loader from OOTB
Sakai. You can see the mapping between Course_Set, Course_Offering,
and Section.
mysql> select * from CM_COURSE_SET_OFFERING_ASSOC_T;
+-----------------+------------+
| COURSE_OFFERING | COURSE_SET |
+-----------------+------------+
| 4 | 1 |
| 5 | 1 |
| 6 | 1 |
| 7 | 1 |
| 8 | 1 |
| 9 | 1 |
| 10 | 1 |
| 11 | 1 |
+-----------------+------------+
8 rows in set (0.01 sec)
mysql> select * from CM_ENROLLMENT_SET_T;
+-------------------+---------+------------------+--------------------
+------------+--------------+-----------------------
+------------------------
+-------------------------------------------------------+----------
+-----------------+-----------------+
| ENROLLMENT_SET_ID | VERSION | LAST_MODIFIED_BY | LAST_MODIFIED_DATE
| CREATED_BY | CREATED_DATE | ENTERPRISE_ID |
TITLE |
DESCRIPTION | CATEGORY |
DEFAULT_CREDITS | COURSE_OFFERING |
+-------------------+---------+------------------+--------------------
+------------+--------------+-----------------------
+------------------------
+-------------------------------------------------------+----------
+-----------------+-----------------+
| 1 | 0 | NULL | NULL
| admin | 2009-05-14 | SMPL101 Winter 2009es | SMPL101
Enrollment Set | Sample course offering #1, Winter 2009 Enrollment
Set | lecture | 3 | 4 |
| 2 | 0 | NULL | NULL
| admin | 2009-05-14 | SMPL202 Winter 2009es | SMPL202
Enrollment Set | Sample course offering #2, Winter 2009 Enrollment
Set | lecture | 3 | 5 |
| 3 | 0 | NULL | NULL
| admin | 2009-05-14 | SMPL101 Spring 2009es | SMPL101
Enrollment Set | Sample course offering #1, Spring 2009 Enrollment
Set | lecture | 3 | 6 |
| 4 | 0 | NULL | NULL
| admin | 2009-05-14 | SMPL202 Spring 2009es | SMPL202
Enrollment Set | Sample course offering #2, Spring 2009 Enrollment
Set | lecture | 3 | 7 |
| 5 | 0 | NULL | NULL
| admin | 2009-05-14 | SMPL101 Summer 2009es | SMPL101
Enrollment Set | Sample course offering #1, Summer 2009 Enrollment
Set | lecture | 3 | 8 |
| 6 | 0 | NULL | NULL
| admin | 2009-05-14 | SMPL202 Summer 2009es | SMPL202
Enrollment Set | Sample course offering #2, Summer 2009 Enrollment
Set | lecture | 3 | 9 |
| 7 | 0 | NULL | NULL
| admin | 2009-05-14 | SMPL101 Fall 2009es | SMPL101
Enrollment Set | Sample course offering #1, Fall 2009 Enrollment
Set | lecture | 3 | 10 |
| 8 | 0 | NULL | NULL
| admin | 2009-05-14 | SMPL202 Fall 2009es | SMPL202
Enrollment Set | Sample course offering #2, Fall 2009 Enrollment
Set | lecture | 3 | 11 |
+-------------------+---------+------------------+--------------------
+------------+--------------+-----------------------
+------------------------
+-------------------------------------------------------+----------
+-----------------+-----------------+
8 rows in set (0.02 sec)
It is always helpful to review the "Sakai course management model "
diagram: http://bugs.sakaiproject.org/confluence/display/~markjnorton/
Sakai+Course+Management+Model Thanks, Mark!
- Zhen
On May 21, 2009, at 12:11 PM, Phuc Bui wrote:
> Dear,
> Here is what I want
> http://i693.photobucket.com/albums/vv296/phucbm/
> creating_new_couse_site_1.jpg
> When I select a subject, it gives the corresponding Course offering
> and sections.
> So how do I make that data ? Which table contains those data ?
>
> Thanks,
> Phuc Bui
>
> From: Zhen Qian [mailto:zqian at umich.edu]
> Sent: Thursday, May 21, 2009 9:52 PM
> To: Phuc Bui
> Cc: sakai-dev at collab.sakaiproject.org
> Subject: Re: [Building Sakai] Question in creating new course site
>
> Phuc Bui:
>
> You can get a sense of the dropdown list by setting -
> Dsakai.demo=true in your JAVA_OPTS.
>
> The course select page is based on the "CourseSet"-
> >"CourseOffering"->"Section" hierarchy set in
> CourseManagementService. Your CMS implementation would populate the
> content for the cascading drop-down menus.
>
> If the user cannot find any after looking at the drop-down menus,
> he then can click on "Still cannot find your course/section? " link.
>
> The "subject", "course", "section" labels are customizable. Please
> check the api and impl of SectionFieldProvider and SectionField.
>
> Thanks,
>
> - Zhen
> On May 21, 2009, at 10:34 AM, Phuc Bui wrote:
>
>
> Dear,
> I mean this stage (view the image)
> http://i693.photobucket.com/albums/vv296/phucbm/
> creating_new_couse_site.jpg
>
> Thanks,
> Phuc Bui
> From: Phuc Bui [mailto:phucbui2006 at yahoo.com.vn]
> Sent: Thursday, May 21, 2009 3:32 PM
> To: 'sakai-dev at collab.sakaiproject.org'
> Subject: Question in creating new course site
>
> Dear all,
> When I create a course site, I wonder how to select from some
> available Subject, course, section instead of selecting ‘Still
> cannot find your course/section’
> Does Sakai support tools to manage that or we have to insert data
> directly into database ?
>
> Thanks,
> Phuc Bui
> _______________________________________________
> 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/20090521/6b0b9394/attachment.html
More information about the sakai-dev
mailing list