Sessional Lecturer - CSC343H1S - Introduction to Databases

Date Posted : 10 / 04 / 2024

Req ID : 39968

Faculty / Division : Faculty of Arts & Science

Department : Department of Computer Science

Campus : St. George (Downtown Toronto)

Description :

Course number and title : CSC343H1S - Introduction to Databases, LEC0301 / LEC2201

Please note, this position is a 0.5 FCE appointment; lecture section codes are different for student enrollment purposes only.

Course description : Introduction to database management systems. The relational data model. Relational algebra. Querying and updating databases : the query language SQL.

Application programming with SQL. Integrity constraints, normal forms, and database design. Elements of database system technology : query processing, transaction management.

Reference :

Estimated course enrolment : 125 students per section

Estimated TA support : one 60-hour TA position for every 30 students

Class schedule :

Mondays, Wednesdays, Fridays 2 : 00pm-3 : 00pm

Please note, the delivery method for this course is currently in-person. Please note that, in keeping with current circumstances, the section delivery method may change as determined by the Faculty or the Department.

Sessional dates of appointment : January 1, 2025 - April 30, 2025

• Salary : Sessional Lecturer I $13,604.00; Sessional Lecturer I - Long Term $14,408.00; Sessional Lecturer II $15,211.00;
• Sessional Lecturer II - Long $15,637.00; Sessional Lecturer III $16,282.00; Sessional Lecturer III - Long Term $16,713.00;

Please note that should rates stipulated in the collective agreement vary from rates stated in this posting, the rates stated in the collective agreement shall prevail.

Minimum qualifications :

• Graduate degree in Computer Science or closely related field required.
• Demonstrated expertise in topic area of the course required.
• Strong organizational, interpersonal, and communication skills required.
• Teaching experience at the university level or equivalent industry level required.

Preferred qualifications :

• Previous experience teaching undergraduate courses in the field of Computer Science preferred.
• Demonstrated evidence of excellence in teaching preferred.

Description of duties :

• Delivering the lectures in-person on campus as scheduled.
• Maintaining course administration including : course website on quercus, marking schemes, lectures, tutorials, assignments, tests, and final assessments.
• Preparing the breakdown of hours for TA duties in the course and supervising the TAs.
• Ensuring that tutorials and / or labs are delivered appropriately by the TAs.
• Managing the grading for the course, which is largely done by the TAs, and carrying out any grading not handled by the TAs.
• Invigilating the final exam if applicable.
• As there are other sections of the same course this term : coordinating with the other instructor(s) to maintain consistency (this includes using common assignments and a common final exam).
• Managing the grades and submitting final course grades, including the timely completion and release of grades and feedback to students throughout the term.

While there is a lot of room for creativity in course delivery, instructors will be expected to follow the basic content and style used by the faculty members who normally teach the course, and must get approval from these faculty members or from the Associate Chair for any substantial changes to the course content or assessment methods.

Instructors will also be expected to consult with the department’s Teaching Support group when creating the course syllabus, final exam, and test(s).

Closing Date : 10 / 28 / 2024, 11 : 59PM EDT

This job is posted in accordance with the CUPE 3902 Unit 3 Collective Agreement.

It is understood that some announcements of vacancies are tentative, pending final course determinations and enrolment. Should rates stipulated in the collective agreement vary from rates stated in this posting, the rates stated in the collective agreement shall prevail.

Preference in hiring is given to qualified individuals advanced to the rank of Sessional Lecturer II or Sessional Lecturer III in accordance with Article 14 : 12 of the CUPE 3902 Unit 3 collective agreement.

Please note : Undergraduate or graduate students and postdoctoral fellows of the University of Toronto are covered by the CUPE 3902 Unit 1 collective agreement rather than the Unit 3 collective agreement, and should not apply for positions posted under the Unit 3 collective agreement.