Course Schedule: Topics, Readings, and AssignmentsReading Assignments should be COMPLETED before
class time on the date given. 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 | Connecting to Databases with Flask Exercise: Logins |
Flask Project Writeup
- Final version due Wed, Apr 30 Presentations: May 04 (final exam timeslot) |
| Thu Apr 10 | SQLAlchemy | Milestone: Abstract designs
and queries |
| Tue Apr 15 | Interactive Queries Exercise: Deploying Webapps |
Milestone: SQL design and
queries Exam Two Review |
| Thu Apr 17 | Making webpages more dynamic Exercise: 12 |
Take-home Exam: due Tues. 4/22 Reading: Chapter 15 Sections 15.1-15.5 |
| Tue Apr 22 | MySQL Indexing | Reading: Section 16.4 |
| Thu Apr 24 | Milestone: preliminary scripts | Reading: Sections 15.2, 16.1 |
| Tue Apr 29 | Last Day of Classes | 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 | ||