Course Schedule: Topics, Readings, and Assignments

Reading Assignments should be COMPLETED before class time on the date given.
Otherwise you may be at a disadvantage in class discussions.

Course Coding Standards  - Refer to these course standards when developing your programs for submission

Date Topic Assignments
Tue Jan 14 Structure of Web Applications
    First Day Survey
A Reading for next time:
Full Stack Development Explained
Thu Jan 16
Simple Flat-file databases
  Exercise: Plotting / Reading CSV files
Introduction to CSV Files
Tue Jan 21 Working with CSV Files Reading: Why You Should Learn SQL
Thu Jan 23 Relational Databases and SQL
  Exercise: Connect to Database Server
.
Tue Jan 28 Query a Database with SELECT HW 0 - Due Jan 30
Thu Jan 30 Queries with GROUP BY HW 1 - Due Feb 04
Tue Feb 04 Queries on Multiple Tables - INNER JOIN
  Exercise: Query Practice
HW 2  - Due Feb 13
Thu Feb 06 Subqueries .
Tue Feb 11 Creating and Populating Tables Reading: Creating Tables and Loading Data
Thu Feb 13 Populating Tables with Data
  Exercise: Using CREATE and INSERT
.
Tue Feb 18 Loading Data Programmatically
 Demo Notes
HW 3  - Due Feb 27
Thu Feb 20 Database Design
 Normalization
.
Tue Feb 25 HTML and CSS Reading: Using HTML
Thu Feb 27 Working with Web Pages
  Exercise: Making it yours
Exam One Review
Tue Mar 04   Exam One .
Thu Mar 06
Spring Break - no class
Tue Mar 11 Spring Break - no class
Thu Mar 13
Spring Break - no class
Tue Mar 18 HTML Forms
  Exercise: Forms Example
For next time: in your sandbox,
create the page described in Your First Form
Thu Mar 20 Client-side evaluation
  Exercise: Post Your First Form results
HW 4 - Due Mar 27
Tue Mar 25 The Flask Framework Reading: Flask Quickstart through at least
Accessing Request Data
Thu Mar 27 Flask Toy Examples and Templates
  Exercise: Part 1 of HW 5
HW 5 - Due Apr 03
Tue Apr 01 Using Jinja Templates Reading: Template Designer Documentation
Thu Apr 03 Web Forms with Flask
  Exercise: WTForms Tutorial
HW 6 / Initial Project Proposals - Due Apr 10 / Apr 8
Tue Apr 08 CSS: Using Specificity
  Exercise: Logins
Flask Project - Final version due Wed, Apr 30
Presentations: May 04 (final exam timeslot)
Thu Apr 10 Instructor Out .
Tue Apr 15 Deployment
  Exercise: Deploying Webapps
Exam Two Review
Thu Apr 17 Connecting Flask to Database Server
  Exercise: Flask-MySQLdb
Take-home Exam: due Tues. 4/22
Milestone: Abstract designs and queries
Tue Apr 22 Making webpages more dynamic Reading: TBD
Thu Apr 24  MySQL Indexing Milestone: SQL design and queries
Reading: TBD
Tue Apr 29 Last Day of Classes Milestone: preliminary scripts (by Wednesday)
Be preparing for your final project demonstration
Thu May 01 Reading Day
Sun, May 04 Final Project Presentations 2:00 pm
For your consideration...
The Language of Science is Math How Algorithms Shape the World Visualizing Our Humanity Software As Art