List of Contributions

Contact Details

University of Wisconsin - Madison

Ribbons

Badges

Ms. Sherran Pak

University of Wisconsin - Madison

Contributions

1 to 3 of 3 total
Posted By Sherran Pak 08-07-2026 03:06 PM
Found In Egroup: PS Query & SQL
\ view thread
Thanks to everyone who has responded so far. I imagine there are many different ways of setting up courses among institutions so, just in case this is helpful, here's an Adjust Class Associations view of one section of one of our courses that has 9999 lectures. This course consists of three lectures, ...
Posted By Sherran Pak 08-07-2026 12:44 PM
Found In Egroup: PS Query & SQL
\ view thread
Thanks very much for your reply. Unfortunately, that's exactly how our query is set up but what it actually returns are the lectures with an association of 9999 in a course that also includes graded lectures. We have a number of courses that include both 9999 lectures and standalone lectures that have ...
Posted By Sherran Pak 08-06-2026 09:35 AM
Found In Egroup: PS Query & SQL
\ view thread
When we have a course that consists of a lecture associated with multiple discussions or labs, we assign the lecture the associated class number 9999 and the discussions or labs are each given a unique non-9999 association. We have a query that finds courses that contain both a graded lecture and a ...