Practice Access Exam #2

more on domains.

top level domains, subdomains.

Final
next wednesday, in this room, 4 - 6
a lot of multiple choice
maybe a few short answers
25 - 30 questions total


qccs12.blogspot.com
qccs12 is a subdomain
blogspot.com is a domain

cs12.cs.qc.cuny.edu
eniac.cs.qc.edu
venus

why is this important?
Phishing scams
http://www.chase.com.scamsite.ru/

TLDs
top level domain
.com, .net, .org, .edu, .gov

yahoo.co.uk

Solver in Excel
how is it better than goal seek?
can seek to min or max,
fiddle with multiple cells,
impose constraints

backing up your data
most important: data files

Dropbox

Practice Access Exam #1

useful websites
google.com

http://www.nytimes.com/2010/11/28/business/28borker.html?pagewanted=all


gmail uses AJAX
AJAX: asynchronous Javascript and XML
stuff going on on the client, and on the server
makes a website more reactive

books.google.com
translate.google.com
docs.google.com

http://www.openoffice.org/

archive.org
has the wayback machine

cache
personal copy of some website
used to speed up web viewing

cache:http://www.joyofhandspinning.com/

http://www.pandora.com/


anatomy of a URL

http://en.wikipedia.org/wiki/URL

The syntax is
scheme://domain:port/path?query_string#fragment_id

everything from :// to FIRST / is the domain
very VERY useful for catching Phishing schemes

http://en.wikipedia.org/wiki/Phishing

why seeing numbers should be a clue of something suspicious

IP address
DNS
phone book looking up names and matching to IP addresses
http://www.whois.net/



which will help detect Phishing scam

Instructions from Xiuyi on installing Fugu and TextWrangler for MAC.

The web page assignment:

Everything as described here:
http://eniac.cs.qc.edu/~svitak/cs12/webpageassign.html

Plus:
1) Use an external CSS file to style the webpages (for example, to make all the backgrounds the same image, or green; to make all paragraphs of some type (e.g. "topic paragraph") centered.

e.g.
in the main CSS file
p.topic {text-align:center;}

in an individual HTML page

This paragraph will be center-aligned.

2) Make a form which prompts for First Name and Last Name, and button to Submit.

Recall, w3schools has enough to let you do this with simple cut and paste.

This will be hooked up to a PHP program which will greet the person by the full name. "Hello, FirstName LastName".

Recall, w3schools has enough to let you do this with slight modifications from the section PHP Forms.

3) Using JavaScript, make a webpage with a button. When you click on the button, make the caption of the button become "Hello World".

Reminder: the quiz

will not include any material on databases