we finished css absolute reference relative reference we are used to A1 reference style R1C1 reference style keyboard shortcuts with number keys IF function there is a diff between actual value in a cell and the value displayed http://supermanhomepage.com/movies/movies.php?topic=m-movie3 Having now taken a job as a computer programmer at Webscoe Industries, Gus Gorman is extremely disappointed when he sees his first paycheck. "Where did it all go?" he asks. During lunch, Gus and a friend discuss all the percentages taken from a paycheck. When Gus tells him that there has to be fractions of cents left over, Gus's friend tells him that the checks are rounded down to the nearest "half-cent". "Where do those half-cents go?" asked Gus. Suddenly, another light bulb goes on above Gus's head. When everyone else is leaving, Gus is still busy programming. we will have a quiz next Thursday, up to this material, plus a chapter in the book.

Reading assignment:
Lecture book, ch 5
Do the quickchecks


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

CSS rules
selector { declarations; declarations;}
declaration is property:value

selectors which are tags
id and class selectors

we are up to CSS how to

excel
rows
cols
cells
name box tells you name of the cell

in cells, can store values, formulas

we call these values literals

formulas begin with =
formula bar will display the formula
operators and operands
+ - / * ^
PEMDAS


how to "debug" formulas
1) stare blankly at screen; think hard
2) use debugging tools
Formula Auditing / Evaluate formula


excel is smart! it adjusts relative refs for you. increment, decrement rows and cols

functions are basically operators without the symbols
pass in 'operands' as parameters
diff number of arguments

A1:B6 means all the cells from A1 to B6
is called a range


Ctrl plus and minus

refer to diff sheets
diff books

magic number
isolate assumptions
using names and the name box

Names

No class this Thursday, Oct 20, 2011

Reading assignment:
Lecture book, ch 4
Do the quickchecks

How to set up your webpage:
http://eniac.cs.qc.edu/~svitak/cs12/

1) We need to set up a folder called public_html
2) In that folder, we will put a file, main.html, which is an HTML file
3) If necessary, we will set permissions
owner, group, universe
r,w,x
755

chmod command to change permissions

We can use WINSCP to change it
We can use a command line interface, putty, SSHSecureShell

4) load the webpage in your web browser
hostname/~yourlogin/filename

SSH Secure shell
http://www.dartmouth.edu/comp/soft-comp/software/downloads/windows/ssh-sftp/install.html

Putty download
http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html

These are "telnet" clients
Lets you log on to a computer and do things

there is one computer, running programs for multiple users
it uses a command line interface
command prompt:
c:\>

GUI - graphical user interface

Citrix server

"telnet"  uses a command line interface

Advertisement:
logmein
free competitor to gotomypc


<table border="1">
<tr>
<td>row 1, cell 1</td>
<td>row 1, cell 2</td>
</tr>
<tr>
<td>row 2, cell 1</td>
<td>row 2, cell 2</td>
</tr>
</table>

we have finished all of HTML
next time, move on with CSS

Reading assignment:
Lecture book, ch 3

Do the quickchecks

Next quiz this coming tuesday
material from last Thursday and today
Also, ch 2 in the lecture book

[72.14.204.147]

http://www.overclock.net/faqs/44143-how-use-hosts-file-block-websites.html

how to block websites
the hosts file

webserver
client


in loading a website
http://upload.wikimedia.org/wikipedia/commons/c/c6/Http_request_telnet_ubuntu.png
starts with an HTTP request from the web client

the server responds with an HTTP response

200 = OK
404 = Not Found
403 = Forbidden

hostname: cs12.cs.qc.cuny.edu
i will not be here this Thursday (10/13)!

WinSCP
you all have accounts created by Xiuyi
on this machine

your credentials:
username: first two letters of last name +
first two letters of first name +
last 4 digits of your CUNYFirst ID

password: all 8 digits of your CUNYFirst ID

So, for example, Josh Waxman's credentials:
my cuny first id happens to be: 12345678

login: wajo5678
password: 12345678

It has to be all lowercase

how do I get Winscp?

do a google search for the words
winscp download

http://winscp.net/eng/download.php

You don't want a beta release
You want a stable release

What is a beta?

we will use Winscp to make our web pages

it is a file editor for remote files
and a file transfer program


http://cs12.cs.qc.cuny.edu/~xiuyi/fugu.html



img tag
hotlinking and why it is bad
it's stealing!
it is a bad idea
to download the files from lab:
prenhall.com/grauer
alternatively:
http://www.pearsonhighered.com/exploring/

http://wps.prenhall.com/bp_exploring_excel_2010_comp/
click on student data files

quiz up to here

2nd quiz will be up to last lecture
meaning, sept 20 and 22nd
Lecture book: ch 1

Anatomy of a URL
url: website address

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

scheme://domain:port/path?query_string#fragment_id

scheme://domain/

scheme, or protocol
http://
https://
ftp://
telnet://
gopher://

http = hypertext transfer protocol

http://en.wikipedia.org/wiki/Uniform_Resource_Locator
what is the scheme?
http

what is the domain?
en.wikipedia.org

what is the path?
(C:\josh\subfolder\hello.txt)
/wiki/Uniform_Resource_Locator

#fragment_id
some bookmark within the html page

Analyzing domains

http://mypage.net/5/6/www.chase.com/login
Phishing
embedding name not in the domain portion
misspellings

TLD - top level domain
example of a TLA (three letter acronym)
.com
.net
.gov
.org
.edu

www.chase.net

countries
.uk
.ru

.ac.uk
.co.uk

Domain:
www.google.com
what I will define as 'domain' is JUST the google.com

the www is what we call a subdomain

http://eniac.cs.qc.edu/~svitak/cs12/


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

look at the very last two things before the first slash
THAT is the domain

IP address
Really, there are four numbers that are used to identify any location on the Internet
http://en.wikipedia.org/wiki/IP_Address
Internet Protocol


IP addresses are hard to memorize
http://www.whois.net/
you type in a domain, they will tell you the IP


The Internet is NOT the same as the Web
The web is a bunch of connected documents
the internet is a bunch of connected computers (networks)

The "World Wide Web" is one service available on the Internet.

DNS - domain name service
automatic address book, mapping names to IP addresses
when i type google.com