every alternate chapter in the book is about how to develop web pages

http://www.w3schools.com/html/default.asp

cs12.cs.qc.cuny.edu

instructions for web page assignment
http://eniac.cs.qc.edu/~svitak/cs12/webpageassign.html


how do you log on to the cs12 machine (webserver)?

1) run WinSCP
2) log in to the machine with your credentials.

What are your credentials?
hostname: cs12.cs.qc.cuny.edu
login: wajo6789
password: all eight digits of your CUNYFirst ID
123456789
first two letters of last name
first two letters of first name
last four digits of your CUNYFirst ID

public_html
homepage.html

3) create the public_html folder (you only need to do this once)
4) create or edit the file(s) in the public_html folder

5) view the webpage in your web-browser?
http://cs12.cs.qc.cuny.edu/~wajo6789/homepage.html

class is off

very few people showed up. see you after the break!

ipmt
ppmt

csv = comma separated values
importing data

pivot tables
mixed refs
we know absolute refs
we know relative refs
mixed refs: one part absolute, one part relative

cs88

Tutoring schedule link

You can see when tutors are available here.

Practice exam 2

here is a link

hw: ch 3, midlevel exercises and capstone

what is left?
Financial functions, in depth
Goal Seek
Solver
Pivot Tables
(Mixed references)
Go thru the practice exams

Financial functions, in depth
__________________________
time value of money

Present Value
Future Value
how many times am i collecting interest
what is the interest rate

relative vs. absolute references

A1 -- relative reference
$A$1 -- absolute reference

A1 style
r1C1 style

what happens when your formula is wrong?
how do you find the "bug" and fix it?
Grace Hopper
http://en.wikipedia.org/wiki/Grace_Hopper

Sum function
range operator
:
cell ref : cell ref

hw: midlevel and capstone exercises, ch 2, excel