CIS 201 (Web Programming) Documents

Before 2008 this course was called CS 201. In 2008 and 2009 this course was called CIS 201. The course was last taught Spring 2009. It was replaced by a more advanced course, CIS 401.

Catalog   Prof Colton   Don Colton   DC Quiz   IS2   GradeBot Lite   iconGradeBot
Downloads (for MS Windows):   perl   ssh   emacs   favicon

Spring 2009 (Don Colton)   is2 2092

Online Textbook: I am writing a textbook for this class. There will be occasional updates this semester.

  Current Readings
Course Syllabus and Calendar (5p pdf)
TableViewer: Using CGI to List Tables and Rows (1p pdf)
Shopping Cart Labs (2p pdf)

Winter 2009 (Don Colton)   is2 2091

Online Textbook: Course Syllabus and Calendar (4p pdf)
Web and CGI Tutorial (9p pdf)
CALC lab instructions and signoff sheet (1p pdf)
TableViewer: Using CGI to List Tables and Rows (1p pdf)
Shopping Cart Labs (2p pdf)

QuizGen CIS201 Tests on Demand   QG

QPF: Formatted Printing printf   tutorial (6p)
QEM: Emacs Command Memorization   refcard (1p)
QP1: Precedence Mult Add   tutorial (4p)
QP2: Precedence Mult Add LT EQ And Or
QR1: Regular Expressions memorization   tutorial (4p)
QR2: Regular Expressions string matching
QL1: CGI Language Identification perl html   primer (2p)
QL2: CGI Language Identification perl html dbi sql
QS1: SQL Query Types   list (1p)
QS2: SQL Data Types   list (1p)
QB1: BigOh Simple Loops (extra credit)   tutorial (4p)
QB2: BigOh Logs and Roots (extra credit)

Fall 2008 (Don Colton)   is2 2085

  Course Syllabus and Calendar (pdf, Spring)

Spring 2008 (Don Colton)   is2 2083

  s0 Apr 30: Course Syllabus and Calendar (8p pdf)
  s0 May 01: due: read the syllabus
  s0 May 01: due: look at each page of the cPanel User Manual (221p)
  s0 ... ..: Perl Debugging handout (3p pdf)
  s0 ... .. Emacs Quick Reference Card (cs201, ancient, 1p pdf)
  s1 ... ..: Making Perl Executible on IS2: (OLD) is2a.pdf (2p)
  s0 ... ..: due: get an autograph from a CIS tutor
  s0 ... ..: due: fix password
  s1 ... ..: Exam Rules
  s1 ... ..: Exam Hints and Sample Code
  s2 ... .. Web and CGI Tutorial (9p pdf)
  s2 ... .. CALC lab instructions and signoff sheet (1p pdf)
  s2 ... .. NUTS lab instructions and signoff sheet (1p pdf)
  s2 ... .. Midterm 2   actual test (Spring 2006)
  s3 ... .. Using a MySQL Database (5p pdf) includes column data types.
  s3 Jun .. TableViewer: Using CGI to List Tables and Rows (1p pdf)
  s3 Jun .. Shopping Cart Labs (2p pdf)

Winter 2008 (Don Colton)   is2 2081

  s0 Jan 09: Course Syllabus and Calendar (8p pdf)
  s0 Jan 09: due: read the syllabus
  s0 Jan 09: due: look at each page of the cPanel User Manual (221p)
  s0 Jan 30: Perl Debugging handout (3p pdf)
  s0 ... .. Emacs Quick Reference Card (cs201, ancient, 1p pdf)
  s1 Jan 30: Making Perl Executible on IS2: (OLD) is2a.pdf (2p)
  s0 ... ..: due: get an autograph from a CIS tutor
  s0 ... ..: due: fix password
  s1 ... ..: Exam Rules
  s1 ... ..: Exam Hints and Sample Code
  s2 ... .. Web and CGI Tutorial (9p pdf)
  s2 Mar 12 CALC lab instructions and signoff sheet (1p pdf)
  s2 Mar 17 NUTS lab instructions and signoff sheet (1p pdf)
  s2 Mar 21 Midterm 2   actual test (Spring 2006)
  s3 Apr 04 Using a MySQL Database (5p pdf) includes column data types.
  s3 Apr 16 TableViewer: Using CGI to List Tables and Rows (1p pdf)
  s3 Apr 16 Shopping Cart Labs (2p pdf)

Fall 2007 (Don Colton)   is2 2075

  See Tests On Demand above for testing center practice and training
  s0 Aug 29: Course Syllabus and Calendar (8p pdf)
  s0 Aug 31: due: get an autograph from a CS tutor
  s0 Aug 31: due: read the syllabus
  s0 Aug 31: due: look at each page of the cPanel User Manual (221p)
  s0 Sep 05: due: fix password
  s1 Sep 26: Making Perl Executible on IS2: is2a.pdf (2p)
  s1 Oct 01: Exam Rules
  s1 Oct 01: Exam Hints and Sample Code

Spring 2007 (Don Colton)   is2 2073

  See Tests On Demand above for testing center practice and training
  s0 May 02 Course Syllabus and Calendar (8p pdf)
  s0 ... .. Emacs Quick Reference Card (cs201, ancient, 1p pdf)
  s1 ... .. Exam Rules and Hints
  s2 ... .. Web and CGI Tutorial (9p pdf)
  s2 ... .. CALC lab instructions and signoff sheet (1p pdf)
  s2 ... .. NUTS lab instructions and signoff sheet (1p pdf)
  s2 ... .. Midterm 2   actual test (Spring 2006)
  s3 ... .. Using a MySQL Database (5p pdf) includes column data types.
  s3 ... .. TableViewer: Using CGI to List Tables and Rows (1p pdf)
  s3 ... .. Shopping Cart Labs (2p pdf)

General Interest

Perl Documentation
Learn Python in 10 minutes
Various Tutorials

Warning: Current Semester dates and links are tentative, especially the .. dates (if any). Many are simply linked to past semester materials until they are updated for the current semester. While the general outline is accurate, some details may change.

Winter 2007 (Don Colton)   is2 2071

  See Tests On Demand above for testing center practice and training
  s0 Jan 10 Course Syllabus and Calendar (7p pdf)
  s0 ... .. Emacs Quick Reference Card (cs201, ancient, 1p pdf)
  s1 ... .. Exam Rules and Hints
  s2 ... .. Web and CGI Tutorial (9p pdf)
  s2 ... .. CALC lab instructions and signoff sheet (1p pdf)
  s2 ... .. NUTS lab instructions and signoff sheet (1p pdf)
  s2 ... .. Midterm 2   actual test (Spring 2006)
  s3 ... .. Using a MySQL Database (5p pdf) includes column data types.
  s3 ... .. TableViewer: Using CGI to List Tables and Rows (1p pdf)
  s3 ... .. Shopping Cart Labs (2p pdf)
is2 homepage   Winter 2007 Class Links   w07/cpanel   w07/whm

Fall 2006 (Don Colton)   is2 2065

  See Tests On Demand above for testing center practice and training
  s0 Aug 30 Course Syllabus and Calendar (7p pdf)
  s0 Sep 11 Emacs Quick Reference Card (cs201, ancient, 1p pdf)
  s1 ... .. Exam Rules and Hints
  s2 ... .. Web and CGI Tutorial (9p pdf)
  s2 ... .. CALC lab instructions and signoff sheet (1p pdf)
  s2 ... .. NUTS lab instructions and signoff sheet (1p pdf)
  s2 ... .. Midterm 2   actual test (Spring 2006)
  s3 ... .. Using a MySQL Database (5p pdf) includes column data types.
  s3 ... .. TableViewer: Using CGI to List Tables and Rows (1p pdf)
  s3 ... .. Shopping Cart Labs (2p pdf)
is2 homepage   Fall 2006 Class Links   f06/cpanel   f06/whm

Spring 2006 (Don Colton)   is2 2063

  See Tests On Demand above for testing center practice and training
  s0 May 03 Course Syllabus and Calendar (6p pdf)
  s0 May 03 Emacs Quick Reference Card (cs201, ancient, 1p pdf)
  s1 May 17 Exam Rules and Hints
  s2 May 18 is2.byuh.edu classmember links
  s2 May 18 Web and CGI Tutorial (9p pdf)
  s2 May 22 CALC lab instructions and signoff sheet (1p pdf)
  s2 May 23 NUTS lab instructions and signoff sheet (1p pdf)
  s2 Jun 05 Midterm 2   hints page   actual test (Spring 2006)
  s3 May 31 Using a MySQL Database (5p pdf) includes column data types.
  s3 Jun 06 TableViewer: Using CGI to List Tables and Rows (1p pdf)
  s3 Jun 08 Shopping Cart Labs (2p pdf)
is2 homepage   Spring 2006 Class Links   s06/cpanel   s06/whm

Winter 2006 (Don Colton)

  See Tests On Demand above for testing center practice and training
  s0 Jan 11 Course Syllabus and Calendar (6p pdf)
  s0 Jan 11 Emacs Quick Reference Card (cs201, ancient, 1p pdf)
  s2 Feb 10 Web and CGI Tutorial (9p pdf)
  s2 Feb 17 CALC lab instructions and signoff sheet (1p pdf)
  s2 Feb 22 NUTS lab instructions and signoff sheet (1p pdf)
  s3 Mar 15 Using a MySQL Database (5p pdf) includes column data types.
  s3 Mar 15 TableViewer: Using CGI to List Tables and Rows (1p pdf)
  s3 Mar 22 Shopping Cart Labs (2p pdf)

Fall 2005 (Don Colton)

Section Zero: preparatory materials
  s0 Sep 01 Course Syllabus and Calendar
  s0 Sep 01 Quick Reference Card (cs201)
Section One: Review of Programming, Introduction to Perl
  s1 Sep 06 Testing Center: QP1 (tc quiz 1): Precedence (plus, minus, times, divide, rem)
  s1 Sep 08 Testing Center: QP2 (tc quiz 2): Precedence (arith, less, equal, and, or)
  s1 Sep 22 Midterm 1 actual test (Spring 2005)   Exam Rules and Hints
Section Two: Common Gateway Interface (CGI) for Web Programming
  s2 Sep 27 Web and CGI Tutorial
  s2 Oct 04 Testing Center: QL1: Language ID (html vs perl)
  s2 Oct 04 Testing Center: QR1: Regular Expressions (Perl matching)
  s2 Oct 04 Testing Center: QR2: Regular Expressions (string vs pattern)
  s2 Oct 13 CALC lab instructions and signoff sheet
  s2 Oct 18 NUTS lab instructions and signoff sheet
  s2 Oct 27 Midterm 2 actual test (Spring 2005)   Exam Rules and Hints
Section Three: Database Programming using the Perl DBI
  s3 Nov 01 Using a MySQL Database (5p) includes column data types.
  s3 Nov 03 Testing Center: QS1: SQL Commands
  s3 Nov 03 Testing Center: QS2: SQL Data Types
  s3 Nov 08 Testing Center: QL2: Language ID (html, perl, dbi, sql)
  s3 Nov 08 TableViewer: Using CGI to List Tables and Rows (1p)
  s3 Nov 10 Shopping Cart Labs (2p)
  s3 Nov 22 Midterm 3 actual test (Spring 2005)   Exam Rules and Hints
Section Four: Big Oh Analysis of Algorithms
  s4 Dec 06 Testing Center: QB1: Big Oh (simple)
  s4 Dec 08 Testing Center: QB2: Big Oh (logs and roots)
End of Semester
  s6 Dec 13 Final Exam Problems actual test (Fall 2004)   Exam Rules and Hints

Spring 2005 (Don Colton)

Section Zero: preparatory materials
  s0 Apr 28 Course Syllabus and Calendar (to be added)
  s0 Apr 28 Quick Reference Card (cs201)
Section One: Review of Programming, Introduction to Perl
  s1 May 02 Testing Center: QP1 (tc quiz 1): Precedence (plus, minus, times, divide, rem)
  s1 May 02 Testing Center: QP2 (tc quiz 2): Precedence (arith, less, equal, and, or)
  s1 May 09 Midterm 1 actual test (Spring 2005)   Exam Rules and Hints
Section Two: Common Gateway Interface (CGI) for Web Programming
  s2 May 12 Testing Center: QR1 (tc quiz 3a): Regular Expressions (Perl matching)
  s2 May 12 Testing Center: QR2 (tc quiz 3b): Regular Expressions (string vs pattern)
  s2 May 13 Web and CGI Tutorial
  s2 ... .. Testing Center: QL1: Language ID (html vs perl)
  s2 May 17 CALC lab instructions and signoff sheet
  s2 May 20 NUTS lab instructions and signoff sheet
  s2 May 24 Midterm 2 actual test (Spring 2005)   Exam Rules and Hints
Section Three: Database Programming using the Perl DBI
  s3 May 23 Using a MySQL Database (5p) includes column data types.
  s3 May 24 Testing Center: QS1: SQL Commands
  s3 May 24 Testing Center: QS2: SQL Data Types
  s3 May 26 Testing Center: QL2: Language ID (html, perl, dbi, sql)
  s3 May 26 TableViewer: Using CGI to List Tables and Rows (1p)
  s3 May 31 Shopping Cart Labs (2p)
  s3 Jun 09 Bonus: Invent Your Own CGI/DB
  s3 Jun 10 Midterm 3 actual test (Spring 2005)   Exam Rules and Hints
Section Four: Big Oh Analysis of Algorithms
  s4 Jun 13 Testing Center: Quiz 4, QB1: Big Oh (simple)
  s4 Jun 14 Testing Center: Quiz 5, QB2: Big Oh (logs and roots)
End of Semester
  s5 Jun 14 Testing Center: Quiz 6: Comprehensive Exam
  s6 Jun 16 Final Exam Problems actual test (Fall 2004)   Exam Rules and Hints

Winter 2005 (Don Colton)

Section Zero: preparatory materials
  s0 Jan 05 Course Syllabus and Calendar
  s0 Jan 05 Quick Reference Card (cs201)
Section One: Review
  s1 Jan 10 Quiz 1: Simple Precedence (arithmetic)
  s1 Jan 10 Quiz 2: Mixed Precedence (arithmetic)
  s1 Jan 26 Midterm 1 Sample test
  s1 Jan 26 In-Class Exam Rules Sheet (mid1, mid2, mid3, final)
Section Two: Common Gateway Interface
  s2 Jan .. Web and CGI Tutorial
  s2 Jan .. Quiz 3 (was 4): Regular Expressions
  s2 Jan .. CALC lab instructions and signoff sheet
  s2 Jan .. NUTS lab instructions and signoff sheet
  s2 Feb .. Midterm 2 (the actual test that was given in class)
Section Three: Database
  s3 Feb .. Creating a Table By Hand (2p) ... includes a list of column data types.
  s3 Feb .. Using a Program to List Databases (2p)
  s3 Mar .. TableView: Using CGI to List Tables and Rows (1p)
  s3 Mar .. Shopping Cart Tutorial
  s3 Mar .. old Database Handout (6p)
  s3 Mar .. Shopping Cart Labs (2p)
  s3 Mar .. Bonus: Invent Your Own CGI/DB
  s4 Apr 06 Quiz 7: SQL Commands
  s4 Apr 06 Quiz 8: CGI Language ID
  s4 Apr 06 Quiz 9: SQL Column Types
  s3 Mar .. Midterm 3 (the actual test that was given in class)
Section Four: Big Oh
  s4 Apr 08 Quiz 4 (was 3): Big Oh (simple)
  s4 Apr 11 Quiz 5: Big Oh
End of Semester
  s5 Apr 13 Quiz 6: Comprehensive Exam
  s6 Apr 18 Final Exam Rules / Hints
  s6 Apr 18 Final Exam Problems (the actual test that was given in class)

Fall 2004 (Don Colton)

Section Zero: preparatory materials
s0 Aug 25 Course Syllabus and Calendar (preliminary)
s0 Aug 25 Quick Reference Card (cs201)
Section One: Review
s1 Aug 30 Quiz 1: Simple Precedence (arithmetic)
s1 Aug 30 Quiz 2: Mixed Precedence (arithmetic)
s1 Sep 15 Midterm 1 (the actual test that was given in class)
Section Two: Common Gateway Interface
s2 Sep 17 Web and CGI Tutorial
s2 Sep 24 Quiz 3 (was 4): Regular Expressions
s2 Sep 24 CALC lab instructions and signoff sheet
s2 Sep 27 NUTS lab instructions and signoff sheet
s2 Oct 29 Midterm 2 (the actual test that was given in class)
Section Three: Database
s3 Oct 18 Creating a Table By Hand (2p) ... includes a list of column data types.
s3 Oct 20 Using a Program to List Databases (2p)
s3 Nov 01 TableView: Using CGI to List Tables and Rows (1p)
s3 Nov 03 Shopping Cart Tutorial
s3 Nov .. old Database Handout (6p)
s3 Nov .. Shopping Cart Labs (2p)
s3 Nov .. Bonus: Invent Your Own CGI/DB
s3 Nov 24 Midterm 3 (the actual test that was given in class)
Section Four: Big Oh
s4 Nov 29 Quiz 4 (was 3): Big Oh (simple)
s4 Dec 01 Quiz 5: Big Oh
End of Semester
s5 Dec 03 Quiz 6: Comprehensive Exam
s6 Dec 10 Final Exam Rules / Hints
s6 Dec 10 Final Exam Problems (the actual test that was given in class)

Spring 2004 (Don Colton)

s0 Apr 29 Course Syllabus and Calendar
s2 May 14 Web and CGI Tutorial
s2 May 20 Quiz 4: Regular Expressions
s2 May 21 CALC lab instructions and signoff sheet
s2 May 24 NUTS lab instructions and signoff sheet
s3 Jun 01 Creating a Table By Hand (2p) ... includes a list of column data types.
s3 Jun 03 Using a Program to List Databases (2p)

Winter 2004 (Don Colton)

s0 Course Syllabus      s0 Quick Reference Card (cs201)
s2 11 Feb CGI Tutorial (revisions in progress), old version: CGI Tutorial
s2 25 Feb CALC lab instructions and signoff sheet
s2 01 Mar NUTS lab instructions and signoff sheet
s3 05 Mar Shopping Cart Tutorial
s3 10 Mar old Database Handout (6p)
s3 17 Mar Creating a Table By Hand (2p) ... includes a list of column data types.
s3 19 Mar Using a Program to List Databases (2p)
s3 22 Mar Using CGI to List Tables and Rows (1p)
s3 24 Mar Shopping Cart Labs (2p)
s3 07 Apr Midterm 3 Actual sample with grades
s4 09 Apr Quiz 3: Big Oh (simple)
s4 12 Apr Quiz 5: Big Oh

Fall 2003 (Don Colton)

s0 Course Syllabus      s0 Quick Reference Card (cs201)
s0 In-Class Exam Rules Sheet (qic1, qic2, qic3, final)
s1 Sep 08 Quiz 1: Simple Precedence (arithmetic)
s1 Sep 11 Quiz 2: Mixed Precedence (arithmetic)
s1 Sep 19 Quiz In Class 1: First 25% of the Semester Actual sample with grading
s2 Sep 27 CGI Tutorial
s2 Oct 07 Quiz 4: Regular Expressions
s2 Oct 13 Quiz In Class 2: Second 25% of the Semester Actual sample with grading
s3 Oct 15 Database Handout (6p) ... includes dbselect and dbupdate lab signoff sheet.
s3 Oct 30 Quiz 3: Big Oh (simple)
s3 Nov 05 Quiz In Class 3: Third 25% of the Semester Actual sample with grading
s4 Nov 08 Quiz 5: Big Oh
s5 Dec 05 Quiz 6: Comprehensive Exam
s5 Dec 08 Final Exam (3 hours, in class) Actual sample with grading

Spring 2003 (Don Colton)

s0 Course Syllabus      s0 Quick Reference Card (cs201)
s0 In-Class Exam Rules Sheet (qic1, qic2, qic3, final)
s1 May 02 Quiz 1: Simple Precedence (arithmetic)
s1 May 06 Quiz 2: Mixed Precedence (arithmetic)
s1 May 09 Quiz In Class 1: First 25% of the Semester . . . makeup
s2 May 14 CGI Tutorial
s2 May 19 Quiz 4: Regular Expressions
s2 May 21 Quiz In Class 2: Second 25% of the Semester . . . makeup
s3 May 23 Database Handout (6p) ... includes dbselect and dbupdate lab signoff sheet.
s3 Jun 02 Quiz 3: Big Oh (simple)
s3 Jun 04 Quiz In Class 3: Third 25% of the Semester
s4 Jun 06 Quiz 5: Big Oh
s5 Jun 17 Quiz 6: Comprehensive Exam
Anonymous Letter . . . My Reply . . . Comments?

Winter 2003 (Don Colton)

Course Syllabus      Quick Reference Card (cs201)
Quiz 1: Simple Precedence (arithmetic)
Quiz 2: Mixed Precedence (arithmetic)
Quiz 5: Big Oh
Quiz 4: Regular Expressions
Quiz 3: Unix, Emacs, Rmail (memorization) extra credit
Quiz 6: Comprehensive Exam
Database Handout (5p, Mar 19, 2003) ... includes dbselect and dbupdate lab signoff sheet.

Fall 2002 (Don Colton)

Course Syllabus      Quick Reference Card (cs201)
Quiz 1: Simple Precedence (arithmetic)
Quiz 2: Mixed Precedence (arithmetic)
Quiz 3: Unix, Emacs, Rmail (memorization)
Quiz 4: Regular Expressions
Quiz 5: Big Oh

This course is based on IS 231 as taught from 1999 to 2002. On the IS 231 web page you can find further background information that may be interesting or helpful.

Courses   Prof Colton   Don Colton   html (broken)   css