In-class Examples List

CS 328 - Web Apps Using Databases
Section 10 - CRN 22226 - MW 3:00-4:20pm
Spring 2026

Last modified: Thursday, February 26, 2026

Important Notes:

• This is merely a selection of files and examples, most of which were mentioned or used in the class (lectures and labs). It is not a comprehensive list, nor are all lectures and labs included. Formatting is generally minimal.

• Week 6 Labs, February 26, 2026 - review clicker questions followed by a lab exercise
  • Week 6 Lab projected notes
    
    
  • Week 6 Lab Exercise (in tagged PDF)
  • lab6-start.html - syntax-colored display version
    
    
  • 328lect06-1.html - which is styled by:
  • 328lect06-1.css - our first external CSS stylesheet
  • Runnable version on nrs-projects:
    https://nrs-projects.humboldt.edu/~st10/s26cs328/328lect06-1/328lect06-1.html
    
    
  • https://jigsaw.w3.org/css-validator/ - W3C CSS Validator
  
  
• Week 6, Lecture 2, February 25, 2026: review for Exam 1
  • Week 6 Lecture 2 projected notes
    
    
  • Inaccessible Gallery - an attempt to visualize common web page accessibility issues
    
    
  • Exam 1 Review Suggestions (in tagged PDF)
  
  
• Week 6, Lecture 1, February 23, 2026 - started intro to CSS (Cascading Style Sheets)
  • Week 6 Lecture 1 projected notes
    
    
  • CSS references so far
  • https://jigsaw.w3.org/css-validator/ - W3C CSS Validator
    
    
  • CS 328 CSS Coding Standards so far
    
    
  • 328lect06-1.css - CSS external stylesheet with our first CSS rules
    
    
  • 328lect06-1.html - styled using 328lect06-1.css above; here is the runnable version on nrs-projects:
    https://nrs-projects.humboldt.edu/~st10/s26cs328/328lect06-1/328lect06-1.html
    
    
  • normalize.css
    • to read more about it: https://nicolasgallagher.com/about-normalize-css
    • to download it: https://necolas.github.io/normalize.css/
    • (but note that a link to a "local" copy in my nrs-projects directory is also included in the posted html-template.html)
  
  
• Week 5 Labs, February 19, 2026 - lab exercise to be done in or out of lab session, in pairs or individually, because of instructor travel to a conference
  • Week 5 Lab Exercise (in tagged PDF)
  • 328lect05-1.sql - includes PL/SQL stored procedure job_overview and PL/SQL stored functionjob_count
  • 328lect05-2.sql - includes PL/SQL stored procedure loopy
    
    
  • set-up-ex-tbls.sql - for reference
  
  
• RECORDED for Week 5, Lecture 2, February 18, 2026 - continuing intro to PL/SQL, including intro to three of its loop types and intro to its exception-handling
  • See Canvas Modules, Class Recordings, for the two Zoom recordings walking through creating the function below
    
    
  • Recorded Week 5 Lecture 2 projected notes
    
    
  • 328lect05-2.sql - includes:
    • stored procedure loopy, which demos three of PL/SQL's loop types as well as handling no_data_found and too_many_rows exceptions
    • uses dept table created and initially populated by set-up-ex-tbls.sql
    • example output from running 328lect05-2.sql
  
  
• Week 5, Lecture 1, February 16, 2026 - more PL/SQL, including intro to its basic parameters, how to write a stored function (and how to call it from SQL*Plus), and intro to its basic if statement
  • Week 5 Lecture 1 projected notes
    
    
  • 328lect05-1.sql - includes:
    • stored function job_count, which also has a parameter
    • stored procedure job_overview, which has a parameter, calls job_count, and includes an if statement
    • how to declare a SQL*Plus local variable (bind variable), assign to it the result of calling a PL/SQL stored function, and print its value
      
      
    • uses dept table created and initially populated by set-up-ex-tbls.sql
    • example output from running 328lect05-1.sql
  
  
• Week 4 Labs, February 12, 2026 - clicker questions followed by a lab exercise
  • Week 4 Lab projected notes
    
    
  • Week 4 Lab Exercise (in tagged PDF)
    
    
  • Some Additional Form Widgets - (in tagged PDF)
  • html-template.html
    
    
  • 328lect04-2.sql - includes PL/SQL stored procedures hello_world and goofball
  • set-up-ex-tbls.sql - for reference
  
  
• Week 4, Lecture 2, February 2, 2026: started discussing PL/SQL, including our first PL/SQL stored procedure hello_world
  • Week 4 Lecture 2 projected notes
    
    
  • 328lect04-2.sql - includes PL/SQL stored procedures hello_world and goofball
    
    
  • A selection of PL/SQL references
  • CS 328 SQL and PL/SQL Coding Standards so far
  
  
• Week 4, Lecture 1, February 9, 2026: discussed a few more HTML form widget elements
  • Week 4 Lecture 1 projected notes
    
    
  • Some Additional Form Widgets - (in tagged PDF) - summarizes most of the form widget elements featured below
    
    
  • 328lect04-1.html - including/demonstrating several more input attributes and also form widget elements input type="radio" (radio button), input type="checkbox" (checkbox), textarea, and select (drop-down box); here is the runnable version on nrs-projects:
    https://nrs-projects.humboldt.edu/~st10/s26cs328/328lect04-1/328lect04-1.html
    
    
  • https://html.spec.whatwg.org/multipage/forms.html - HTML Living Standard section on Forms
  
  
• Week 3 Labs, February 5, 2026 - clicker questions followed by a lab exercise
  • In-Lab projected notes
  • Week 3 Lab Exercise (in tagged PDF)
    
    
  • html-template.html
  
  
• Week 3, Lecture 2, February 4, 2026: continuing intro to HTML forms and the HTML form element
  • Week 3 Lecture 2 projected notes
    
    
  • 328lect03-2.html - an HTML page built during class demonstrating our first form element; here is the runnable version on nrs-projects:
    https://nrs-projects.humboldt.edu/~st10/s26cs328/328lect03-2/328lect03-2.html
    
    
  • https://html.spec.whatwg.org/multipage/forms.html - HTML Living Standard section on Forms
  • https://developer.mozilla.org/en-US/docs/Web/HTML - MDN's HTML web docs; see the "References" on the left-hand side, and click on "HTML elements" to expand a list of links to different HTML elements.
    • Note that each element's page that is linked from here also include BROWSER COMPATIBILITY info; COOL, and could be useful!
  • https://caniuse.com - Can I Use...web site: can also help with checking browser support for different web technologies
  
  
• Week 3, Lecture 1, February 2, 2026: more HTML basics, including intro to HTML's table element; just started discussion of HTML forms
  • Week 3 Lecture 1 projected notes
    
    
  • 328lect03-1.html - an HTML page built during class demonstrating several discussed elements, including our first table element; here is the runnable version on nrs-projects:
    https://nrs-projects.humboldt.edu/~st10/s26cs328/328lect03-1/328lect03-1.html
    
    
  • https://nrs-projects.humboldt.edu/~st10/s26cs328/328lect03-2/Tux.svg - absolute URL to the copy of the Linux penguin image used with a relative URL in the above example; this is a scalable vector graphics version of Tux that was originally drawn as a raster image by Larry Ewing in 1996 (source: Wikipedia, https://en.wikipedia.org/wiki/Tux_(mascot))
  
  
• Week 2 Labs, January 29, 2026 - clicker questions followed by a lab exercise
  • In-Lab projected notes
  • Week 2 Lab Exercise (in tagged PDF)
    
    
  • html-template.html
  
  
• Week 2, Lecture 2, January 28, 2026: continuing intro to strict-style HTML, including further discussion of semantic HTML, discussion of block and inline elements, and more
  • Week 2 Lecture 2 projected notes
    
    
  • html-template.html - CS 328 HTML template
    
    
  • 328lect02-2.html - an HTML page built during class (and added to a little after class) to demo some of the concepts and elements discussed during class; here is the runnable version on nrs-projects:
    https://nrs-projects.humboldt.edu/~st10/s26cs328/328lect02-2/328lect02-2.html
    
    
  • Section 3.2.1 of the HTML living standard includes a good discussion of semantic HTML:
    https://html.spec.whatwg.org/#semantics-2
    
    
  • MDN (formerly Mozilla Development Network) has a good discussion of block-level and inline-level content:
    https://developer.mozilla.org/en-US/docs/Glossary/Block-level_content ,
    https://developer.mozilla.org/en-US/docs/Glossary/Inline-level_content
  
  
• Week 2, Lecture 1, January 26, 2026: absolute URLs for nrs-projects; starting intro to strict-style HTML
  • Week 2 Lecture 1 projected notes
    
    
  • Screen shot of zoomed-in part of campus map showing location of the Mill Street Lawn Emergency Assembly Point (EAP)
  • Lori Dengler - "An open letter about preparedness to Cal Poly Humboldt President Dr. Carvajal" - published in the Times-Standard, 2026-01-24
    
    
  • Setting up your nrs-projects web directory - (in tagged PDF)
    
    
  • A selection of HTML references
  • CS 328 HTML Coding Standards so far
    
    
  • html-0.html - example of basic HTML document structure (with a title and p element added so SOMETHING will display!); here is the runnable version on nrs-projects:
    https://nrs-projects.humboldt.edu/~st10/s26cs328/328lect02-1/html-0.html
  
  
• Week 1 Labs, January 22, 2026 - example clicker question followed by a lab exercise
  • In-Lab projected notes
  • Week 1 Lab Exercise (in tagged PDF)
    
    
  • Connecting to nrs-projects and sqlplus - (in tagged PDF)
  • Useful details: ssh and sftp - (in tagged PDF)
  • Useful Linux commands - (in tagged PDF)
  • Useful details: ~st10/328submit - (in tagged PDF)
  • Setting up your nrs-projects web directory - (in tagged PDF)
  
  
• Week 1, Lecture "2", January 21, 2026 - course intro, started discussion of n-tier software architectures for interactive applications that happen to use databases
  • CS 328 Course Syllabus (in tagged PDF)
  • Week 1 Lecture 2 projected notes
  
  
• (was no Week 1, Lecture 1 in Spring 2026, due to Humboldt Martin Luther King, Jr., Holiday)

Back to Course Home Page