Class Outline

Notice that information which you are responsible for is listed for each week.

Week 1 (Feb. 7-Feb. 11) Basic Unix
  • Monday: Intro
    • Introductions
    • Class overview
    • Survey handout
    • Initial login and intro to netscape
  • Tuesday: Start Unix
    • What is an OS? Why Linux?
    • Directory structure
    • Commands: cd, absolute and relative paths, ls, pwd
    • Hand out exercise 1
  • Wednesday: Finish Unix Intro
    • Commands: rm, mkdir, cat, man, alias, more, less
    • Help with exercise 1 in lab
  • Thursday: vi, Grep and Regular Expressions
    • Why vi?
    • vi Commands: starting, exiting, insert, others
    • Using grep
    • Command line wildcard characters
    • Help with exercise 1 in lab
Quiz Material
  • unix commands: ls, cd, mkdir, rm, cp, grep
  • vi: how to save file in vi and quit vi
Reference Material
Week 2 (Feb. 14-Feb. 18) Basic Web and HTML
  • Monday: Intro
    • Overview of client-server idea: DNS, TCP, HTTP
    • Explain how web browsers parse HTML to display things
    • Turnin Exercise 1
    • Quiz 1
    • Start Exercise 2 (using various HTML elements)
  • Tuesday: HTML
    • Tags: html, title, headers(h1,h2,...), body, p
    • Various lists
    • Tables
    • Work on exercise 2
  • Wednesday: more HTML
    • Tags: comments, em, b, font, others?
    • background colors, point them to color table below
    • anchors
    • Add these elements to own web page for exercise 2
  • Thursday: more HTML still
    • gifs
    • Quiz2 on HTML stuff
    • Final chance to turnin Exercise 1
    • Exercise 2 due
Quiz2 Material
  • html tags: html, title, h1, body, anchor, ul
  • importance of comments
  • What does DNS stand for?
  • What is the difference between TCP and HTTP?
Reference Material
Week 3 (Feb. 21-Feb. 24) Basic Programming
  • Monday: President's Day
  • Tuesday: Basic Programming
    • Basic programming concepts: computers are stupid, commenting is very important
    • Variables, assignment, operations(+), function calls
    • Start Exercise 3: modified hello worlds in many languages C and C++ code
  • Wednesday: Python and Unix scripting
    • Explain what interpreted language means
    • Explain that there are many unix shells. Maybe how to switch, what some of the differences are? There shell is tcsh.
    • Give code for sample program in Unix script and Python. Show how to run.
  • Thursday:
    • Why so many languages?
    • Help work on exercise 3
Reference Material
Week 4 (Feb. 28-March 2) Starting Java Applet Programming
  • Monday: Intro
    • Exercise 3. Write code for Perl and Java on board. Show how to compile and run.
  • Tuesday:
    • Introduce students to how to write a Java applet.
    • Give out Exercise 4, start of Java 'Hello World' which shows various elements of an applet.
    • Those that finish early give a more complicated assignment: Scribble
  • Wednesday:
    • Expand on HelloWorld Java applet.
  • Thursday:
    • Give quiz3 on programming.
    • Turn in exercise 3 and 4.
Quiz 3 Material
  • be able to write out hello world for one language
  • what is the comment character in C, C++, Java, Unix scripting, Python and Perl?
  • What are the steps involved in creating an applet?
  • Be able to tell the result of some simple function calls and variable assignments.
  • Be able to recognize accessor functions and constructors.
Reference Material
Week 5 (March 6 - March 9) More Java Applet Programming: Simple Applet
  • Monday: Intro
    • Exercise 5. Introduce Simple applet.
  • Tuesday:
    • Mousedown code
    • Give out more complicated assignment to those who finish Simple early.
  • Wednesday:
    • Some Java graphics
  • Thursday:
    • Exercise 4 due today (extended from last week).
    • Quiz 4
Quiz 4 Material
  • When are init, start, stop, and destroyed called? (init: upon loading applet, on refresh applet; start: upon loading, refresh applet, and when coming back to page; stop: when leaving page, on refresh applet; destroy: on refresh applet)
  • What 3 files are needed for an applet?
  • What is the applet tag in the html file look like for Simple.class?
Reference Material
Week 6 (March 13-March 16) Introduction to CGI Programming with PHP
  • Monday: Intro
    • Exercise 5 due.
    • What is CGI scripting?
    • Hello World in PHP
  • Tuesday:
    • Useful PHP functions and arrays
  • Wednesday:
    • How a PHP script receives input
    • HTML forms and PHP
  • Thursday:
    • Quiz 5
    • Turn in exercise 6.
Quiz 5 Material
  • What does CGI stand for?
  • What file extension should a PHP file have so that the web server recognizes it as such?
  • What HTML tags do you use to designate php code?
  • What is the HTML tag to specify a form and the script to handle the form?
Reference Material
Week 7 (March 20-March 23) MySQL Introduction
  • Monday: Intro
    • Exercise 7. Simple MySQL activities like creating a table, inserting elements, updating elements, etc.
    • Intro to Databases: schema, SQL, etc.
  • Tuesday:
    • How to create queries with SQL
  • Wednesday:
    • How to create tables
    • How to modify data
  • Thursday:
    • Give quiz6 on MySQL.
    • Turn in exercise 7
Quiz 6 Material
  • What is a database? Give an example of how it can be used.
  • Give the schema of a relation.
  • What is the most common language used to access a relational database? What is the acronym and what does it stand for?
  • Be able to list the result of an SQL query and be able to write a query to figure out some information.
Reference Material
Week 7,8,&9 (April 3-13, April 24-27) program1: Jaleks

Reference Material

Week 10,11,&12 (May 1-18) program2: MySQL and PHP
  • Monday (May 1): Step 1
  • Tuesday (May 2): Step 2
  • Wednesday (May 3): Step 3
  • Thursday (May 4): Step 4

  • Monday (May 8): Lab day
  • Tuesday (May 9): Step 5a
  • Wednesday (May 10): Canceled due to AP test
  • Thursday (May 11): Lab day

  • Monday (May 15): Step 6
  • Tuesday (May 16): Step 7
  • Wednesday (May 17): Step 8
  • Thursday (May 18): Program 2 due at end of the day

Reference Material

Week 13,14,&15 (May 22-June 8) Review program3: Putting it all together

See Lectures for a schedule. .... May 21, 2000