Depts

Dept asked to have a sub-item added to one of the menu items on their home page (i.e. a "summer courses" item to the courses offered menu). When I added that, the images for the subsequent sections disappeared from the page, but all the code worked properly. Investigation showed that any change to the menu sub-items causes the images for subsequent menu items to disappear. Greg and Martin helped a bit on debugging. I wrote to Clifton as he edited this site a bit over the summer and may have a better idea of what's going on.
Also made a couple of other trivial changes to the site without consequence.

Met with History professor Norm Fennema today regarding moodle. He's keen to use the system, and understands that we're just learning how things work. His primary interest is in using moodle as a content delivery tool rather than a course delivery mechanism. Basically, it's a webpage to hold course stuff like a syllabus, assignments and so forth as opposed to wikis, blogs etc.

With that in mind, I've set him up as a user and created three courses for him: Hist245, Hist367 and CS102.

Documentation:
This is documented due to a confusing overlap of functionality in the assignation of roles in moodle.
I found that just assigning roles is not enough. If roles get assigned on a global level (Users>Permissions>Assign roles) everyone gets added to every course - no good. What you need to do is create categories and sub-categories (as in Humanities>French, Humanities>History), create courses inside that context and then assign roles inside that context.

With Clifton worked out structure for tables for Agenda. A course is static (e.g. SPAN 100); a section includes administrative information for a single offering of a course (e.g. SPAN 100 Y01 in 2007), but no sequence/time or room details; a class includes the time and room details for a section.

Also worked out what conflicts to nofify user about and when.

courses
courseId int(11)
courseCode varchar(4) : SPAN
courseNum varchar(4) : 204B
courseTitle varchar(255) : 19th Century Spanish Poetry
courseDesc varchar(255) :
courseDept deptId_fk
courseAlsoKnownAs varchar(255) : used for display only for courses cross-offered by >1 dept e.g. Fren 280 and Hist 280
courseActive int(1) : 0=false, 1=true(default) course can be offered

sections (was offerings)
sectionId int(11)
sectionCourse courseId_fk
sectionType char(10) : lecture,lab,online Maybe online should be separate boolean
sectionExpires date : 3 years from entry
sectionSession int(4) : 2007
sectionTerm char(1) : F | S | Y | A | J | K | M | P | Q | R
sectionNum char(2) : 03
sectionMaxEnroll int(3) : 120
sectionDescription varchar(255) : Special Topic N
sectionLinkedTo sectionId_fk : default=0, for Y courses create F and S linked to each other

classes
classId int(11)
classSection sectionId_fk
classProf profId_fk
classStartTime time : 00:00 default and for online
classEndTime time : 00:00 default and for online
classMeetsM int(1) : 0=false(default) 1=true
classMeetsT int(1) : 0=false(default) 1=true
classMeetsW int(1) : 0=false(default) 1=true
classMeetsR int(1) : 0=false(default) 1=true
classMeetsF int(1) : 0=false(default) 1=true
classRoom varchar(11) : Cler A108
classOrphaned time : default 0, any other value is time this class orphaned, record deleted 1 month after being orphaned
classOrphanedReason varchar(255) : "section deleted" | "section Term changed" | "section Type changed" | "section expired"

- show all sections which are not online and have start-time and end-time of 00:00, or no meeting days

- show instances where one prof is assigned to two classes at same time (acceptable case: phil 499 and phil 501, unacceptable case: hist 240 and hist 430, what about cases where one prof is assigned by more than one dept, e.g. fren 280 and hist 280 which may or may not be acceptable)

- show all orphaned classes (those whose section has been deleted or altered, but have not yet been deleted from db)

- show all courses which have at least one section-class offering, and the section-class details for each

- show all classes assigned to special TBA instructor

• Add list of Departmental Advisors to Contact Us page
• Make link to "Studies in Philosophy Booklet" more prominent in the courses sections
• Made images for Dr. Young accessible
• Replace current faculty details page with 1) page listing faculty categorized (regulary faculty, adjunct faculty, continuing sessional, other sessional) and showing for each person whether they are entitled to supervise grad students; 2) page for each individual faculty member.

As of end of December, only this task remained:

To grad courses page, keep current listing under heading "this year", add new section under heading "next year"

Changes to content and navigation items

• Add list of Departmental Advisors to Contact Us page, or as separate listing in the department section.
• Make link to "Studies in Philosophy Booklet" more prominent in the courses sections
• Images for Dr. Young currently inaccessible, fix that.

Changes to structure of philosophy dept site

• Replace current faculty details page with 1) page listing faculty categorized (regulary faculty, adjunct faculty, continuing sessional, other sessional) and showing for each person whether they are entitled to supervise grad students; 2) page for each individual faculty member.
• To grad courses page, keep current listing under heading "this year", add new section under heading "next year"
• Add list of Departmental Advisors to Contact Us page, or as separate listing in the department section.
• Make link to "Studies in Philosophy Booklet" more prominent in the courses sections