University of Regina
Department of Computer Science

CS 215: Web & Database Programming

Spring/Summer 2020

Instructor: Dr. Orland Hoeber Web: http://www.cs.uregina.ca/~hoeber/
Format: Asynchronous Course Content Delivery + Synchronous Lectures Delivery Mode: Zoom (link on UR Courses)
Online Programming & Problem Solving: MW 12:30 - 1:45 PM
Email: orland.hoeber@cs.uregina.ca
Office Hours: MW 2:00 - 3:00 PM
(other times by appointment only)

Course Prerequisite

CS 210 (Data Structures and Abstractions)

Course Objectives

This course shows how interactive database-driven web applications are designed and implemented. Appropriate protocols and languages for web and database programming will be discussed, with a focus on client-server architectures, interface design, graphics and visualization, event-driven programming, information management, data modeling, and database systems.

Textbook

Nixon, R. Learning PHP, MySQL, & JavaScript, 5th Edition, O’Reilly Media, 2018 (ISBN- 13: 978-1-491-97891-7)

Evaluation

The final grade in the course will be determined as follows:

Assignments: 6 x 5% 30%
Lab Assignments: avg. of 11 labs 8%
Online Quizzes: 6 x 2% 12%
Attendance & Participation:   5%
Midterm Exam: Mon Jul 28 15%
Final Exam: Aug 26 30%
Total: 100%

In order to pass the course, you must pass the final exam (exam (failure to pass the final exam may result in your final exam grade being assigned as your final course grade). Your final mark may be adjusted by +/- 5%, at the instructor's discretion.

Format

This course will be offered in a hybrid online format (Asynchronous Course Content Delivery + Synchronous Lectures). Every Sunday at 6:00 AM, online course material will be posted to UR Courses for the week’s topics. While you will have the flexibility to review this material and try the online exercises according to your schedule, it is recommended that you review it as soon as possible in the week.

Twice per week, the course instructor will hold synchronous programming and problem-solving sessions (Monday/Wednesday 12:30 – 1:45 PM, via Zoom). Students are expected to attend these sessions, and participate in the activities lead by the instructor. Attendance will be taken and participation logged, which will form part of the final grade for the course.

Syllabus

The course syllabus contains the course schedule, topics, assignment due dates, and other details about the course.

Assignment Submissions

All assignments are due at 11:55 PM on the specified dates, and must be submitted electronically via UR Courses. Late submissions will not be accepted, but the grades for missing assignments may be moved to the final exam under exceptional circumstances, and with appropriate documentation.

Labs and Lab Assignments

Students are expected to attend the labs in the lab session in which they are registered only. Attending a lab session for which you are not registered is not permitted due to space and resource limitations.

Lab attendance will be logged during each lab session; 1/5 of your lab mark is based on your attendance and active participation in the activities of the lab.

Lab assignments are due by 11:55 PM on the day of the lab session in which you are registered. For example, if you are registered in the Wednesday afternoon lab, your lab assignment will be due at 11:55 PM on that day. Late submissions will not be accepted, but the grades for missing lab assignments may be moved to the final exam under exceptional circumstances, and with appropriate documentation.

Important Dates

July 10, 2020

July 21, 2020

July 28, 2020

July 28, 2020

August 4, 2020

August 11, 2020

August 18, 2020

August 26, 2020

Valid XHTML 1.0 Strict

Valid CSS!