Web Page Assignment

The web page assignment is due the day of the final exam.


But, all the files and directories making up your web pages assignment must end up in the public_html directory of your UNIX account. The filename of your main web page must be called index.html and located directly in the public_html directory of your UNIX account. Your web page assignment has to have at least the following:

• Pictures - Create a directory called pictures in your public_html directory. Don't forget to set the proper permissions for the pictures directory. Place all of the image files (pictures) you are using in all of your web pages in the pictures directory.
• About me - Create a web page (html file), in your public_html directory, describing yourself. Include a "photo", real or imagined, of yourself on this web page. Create a link to this web page in your main web page (index.html).
• My family - Create a web page (html file), in your public_html directory, describing your family. You can link to their web pages from there or include scanned pictures if you like! Create a link to this web page in your main web page (index.html). This web page should use CSS, referring to the external style sheet.
• My friends - Create a web page (html file), in your public_html directory, describing your friends. You can link to their web pages from there or include scanned pictures if you like! Create a link to this web page in your main web page (index.html). This web page should use CSS, referring to the external style sheet.
• My hobbies - Create a directory called hobbies in your public_html directory. Don't forget to set the proper permissions for the hobbies directory. Create a web page (html file), in the hobbies directory, that describes your hobby. Provide links to at least 2 web sites that deal with your hobby and you can put pictures there too. Create a link to this web page in your main web page (index.html).
• Queens College - Create a link to the college's main web page in your main web page (index.html).

Be Creative!!!

Experiment!!!

Make it look nice!!!

Practice Excel Exam 1.
Practice Excel Exam 2.
Practice Excel Exam 3.
Practice Excel Exam 4.
Practice Excel Exam 5.
Excel Review Presentation.


Download for Excel practice examsExam 1

HW:
Read through Ch 6, do the quickchecks


What needs to be done:
better review of financial functions
Goal Seek
Solver
Pivot Tables

HW: Do practice exercises for this chapter (excel ch 3 and 4)

Word exam walkthrough

Practice Word Exam.
Word practice exam file,  

Word exam:

Formula auditing

debugging your formulas
evaluate formula is one suich debugging tool

trace precedents (draws arrows...)
trace dependents (draws arrows...)

Relative reference - get changed as copy formula
Absolute reference - stays put

Using the Name Box, you can give Names to Absolute references

FUNCTION is basically a named operator

+-*/^

5 + 4
5 and 4 are operands

SQRT
SQRT(16)
operands we call parameters or arguments

we covered some basic functions


Number formatting:
There is a diff between the actual value stored in a cell and the way it displays.

Superman III, Office Space
maybe use the round function

Read through Ch 5 in the Lecture Book
Do quickchecks
No Quiz next week. Instead, a Word exam


IF function
VLOOKUP function

Do Practice Exercises for ch 2 in Excel
(you might want to also look at the mid-level exercises, since that won't have as much hand-holding, and you want to be able to develop and intuition about writing formulas, to prepare for the Excel hands-on exam.)

workbook
has many worksheets

literals vs formulas

sometimes you will make a mistake
formula auditing is a "debugging" tool
Evaluate Formula

Word exam (hands on) - Nov 6

next week, Oct 30, quiz
on material from
SUNDAY, OCTOBER 16, 2011
http://qccs012.blogspot.com/2011/10/something-called-ip-address-httpen.html
http://qccs012.blogspot.com/2011/10/httpqcpages.html
plus, lecture book, ch 3, all sections

Please finish Ch 4 in lecture book
do the quickchecks

From lab book, do Practice Exercises for Ch1 of Excel


start with HTML images
for the src tag, you can give relative or absolute paths

we can store on the same webserver, or pull images from a different webserver
src="/images/pulpit.jpg"
this means that it is on the same webserver
src="http://img.thesun.co.uk/multimedia/archive/00440/cow_682_440047a.jpg"

What I just did, pulling the image from another webserver is called "hotlinking".

not nice; not a good idea
"stealing" bandwidth

we got up to the end of lists
that is it for now for HTML

CSS - cascading style sheets
http://www.w3schools.com/css/default.asp

font tag, and other tags were deprecated

CSS Syntax
selector
declarations
together, they form a CSS rule

simple selectors are based on the tag
class selectors, id selectors

We will start our web pages:
1) log in using WinSCP
2) We will create a folder called public_html
3) We will create a file called main.html inside the public_html folder
4) we will see our webpage in a webbrowser

hostname of OUR webserver is:
cs12.cs.qc.cuny.edu
username: wajo5678
password: 12345678

permissions
three groups:
you, group, universe
actions: read, write, execute

octal means base 8
so far, we have seen base 10 (decimal); base 2 (binary);
each 3 bits corresponds to a single octal digit, for the sake of setting permissions

chmod 705 main.html
would change the permissions to give all rights to the owner, none to the group, and read and execute to the universe


to see your webpage:
hostname/~loginname/filename
http://cs12.cs.qc.cuny.edu/~wajo5678/main.html

404 error: not found
you typed the URL wrong
or filename isn't actually in public_html

403 error: forbidden
you didn't set the permissions correctly

Every folder has two folder within it
One is called .
means myself
One is called ..
means parent

cmd line (DOS), text based interface to the Operating System

cd means change directory (a directory is a folder)
cd .
cd ..

HW: (not to hand it)
go home, log in to WinSCP, make an html page called new.html, put something there
Also, edit main.html

DropBox
https://www.dropbox.com/

something called an IP address
http://en.wikipedia.org/wiki/IP_address
a 32-bit number
that means that there are 4 bytes in an IP address

hard to remember IP addresses
DNS - domain name server
will give you IP addresses in return for domain names

hosts file in a specific folder on your computer

can use it to block web sites
scammers can use it, so nowadays, only edit as admin

Domain:
everything from the :// until the first / after that


http://www.scamsite.ru/login/www.chase.com/

http://23.123.6.5/www.chase.com/login

http://0x62.0x1F.0x11.0x44/www.chase.com/login

TLDs - top level domain
TLAs = three letter acronym

.com
.org
.net
.gov
.edu
.xxx

whitehouse.gov


countries have their own top level domain
.uk
ac.uk
co.uk

google.co.uk
google.com

subdomain
www.google.com

www is a subdomain within google.com
google.com is the "real" domain

Dr. Svitak's website
http://eniac.cs.qc.edu/~svitak/cs12/

eniac.cs is the subdomain

http://www.chase.com.gimmeyourinfo.ru/login
This is NOT really chase.com
It is a Phishing scheme

Let us pretend that my name is Joshua Waxman and my CunyFirst ID is 12345678

hostname of OUR webserver is:
cs12.cs.qc.cuny.edu
login: first two letters of YOUR last name +
first two letters of YOUR first name +
last 4 digits of your CunyFirst ID
my login: wajo5678
my password: 12345678

#1: lowercase
#2: maybe the first and lastnames are reversed
#3: it is YOUR information, not mine
#4: if it still doesn't work, see Xiuyi

HW: Go home and install WinSCP on your computer
(or Fugu / TextWrangler if you have a Mac)

Usually, web pages are stored on web server
Your web browser is called the client

When you load up a webpage by typing in a URL

you are sending an "HTTP request"
http://en.wikipedia.org/wiki/Hypertext_Transfer_Protocol

You type in: http://en.wikipedia.org/wiki/Main_Page

something like: GET /wiki/Main_Page http/1.1
to host: en.wikipedia.org

The webserver responds with an Http response
HTTP/1.0 200 OK
followed by the contents of the requested html page

web client receives it, and renders it

other responses:
404 Page not found
403 Forbidden

The Web is NOT the Internet
it is one of the services available on the internet




there is software called WinSCP
is windows software for editing files remotely, and file transfer

if you have a Mac, you will need Fugu instead
follow this link
http://cs12.cs.qc.cuny.edu/~xiuyi/fugu.html

If you a PC (most of you do):
http://winscp.net/eng/download.php

Make sure you don't download the Beta version

What is Beta?
What is Alpha?
make sure to get the stable version