CPSC 120, Fall 2011
About the Final Exam

The final exam for CPSC 120 will be given during the time period scheduled by the registrar and announced in the course handout on the first day of class: Tuesday, December 13, at 1:30 PM. The exam will be held in Albright Auditorium.

The final exam counts for 15% of the course grade, which is the same proportion as the in-class tests. The exam will be five pages long. The last page will be a long essay that asks you to show what you've learned about how the web works and the technologies that are used to implement it. The exam covers material from the entire course, but the following topics will definitely not appear: canvas and graphics, GIMP, HTML tables, JQuery animate function, JSON objects, writing PHP. (However, you might have to read some PHP code and say what it dows.)

At the exam, you will have a copy of a sample HTML file. I will attach a copy of that file to this page when I hand it out in class, and it is available on-line. This file has examples of some things that you should know how to do with HTML, CSS, JavaScript, JQuery, forms, and AJAX.

Your web portfolio is due at the same time as the final exam and will be graded sometime after the end of the exam. Remember that you must have a file index.html that has links to your other work. You want an index page that looks nice and that gives some indication of what each link will lead to. You will probably also want to do some work on the appearance of other pages in your portfolio, and you might want to fix problems that you had on those pages. You do not necessarily have to include every bit of work that you did on the labs. The basic grade on web portfolios will be 8 out of 10 points, and the grade will be adjusted up or down from there, depending on the quality and amount of work that you've done.

Since the third test, we have covered only a few things, including:

relational database
tables in a relational database
column names in a table
SQL (Structured Query Language)
some basic SQL statements:
   SELECT * FROM table-name
   SELECT * FROM table-name WHERE condition
   INSERT INTO table-name (column1, column2, ...) VALUES (value1, value2, ...)
   DELETE FROM table-name WHERE condition
   UPDATE table-name SET column = expression WHERE condition

server-side programming
the purpose of a .php file is to write HTML (or some other type of response to a web request)
using  <?php ... ?>  to hold PHP code in a .php file
PHP variable names start with $, such as  $i  $_POST  $value
using variables inside double-quoted strings
the print() function in PHP
using the $_POST[] array to access data from a form

You will also want to review the information sheets for the first three tests.