cs12 quiz 3

Excel Plan

VLOOKUP
Goal Seek
Solver
Macros
Financial Functions
Go over sample excel exams

notes

traveling salesman problem

a, b, c, d
minimize cost, don't visit same city twice

a, b, c, d = 100 + 230 + 10 = 340
a, d, c, b = 50 + 10 + 230
a, c, b, d

1. generate all permutations of cities
2. add up the cost of traveling on each of the perms
3. find the minimum cost, and print that order of cities

consider for 100 cities
how many diff perms do we have?

comp scientists: work on algorithms
work on new types of hardware
von Neumann arch is basicly a Turing Machine
Quantum Computer
DNA computer


decision tree (part of AI)
expert system

cs12 svitak
web page assinment, part 1
Winscp download
fugu

index.html
aboutme.html
friends.html
hobbies.html
a link to QC website

use knowledge from w3schools.com

homework: excel practice exercise 1-4 in chapter 2
using large or small, make a grade book and weight the four exams. use relative and absolute refs as appropriate

Quiz 2

notes from class

SUM function (built in)
pass in arguments, also known as parameters

average weights everything equally

isolate assumptions

three different types of references
relative reference
absolute reference
mixed reference

next time, talk about r1c1 ref style, what absolute and relative really mean, do some mixed

how to login:
Joshua Waxman
123456789
hostname: cs12.cs.qc.cuny.edu
login: wajo6789
password: 123456789

there is some initial setup. only need to do this once

we need to make a folder called public_html
inside that folder, make a file called hello.html

You; group; everyone

read, write, execute

hotlinking images is a violation of netiquette
rather, upload all images to your own site and reference them'

winscp download
joshwaxman@gmail.com

how a URL is formed

anti-Phishing Phil
protocol
ftp
telnet
http
https

address
filename

domain
subdomain
understandingpersonalcomputers.blogspot.com

IP address
DNS -- domain name server

Opera
Chrome
Firefox
Safari

Spybot search and destroy

notes from class

EXCEL

operators, operands, built in functions. literals, formulas
references

images:
BMP (bitmap)
alternate file formats
which don't take as much space

raster vs. vector
vector is much smaller, smoother

GIF, JPG
one uses lossless compression,
one uses lossy compression

run length encoding
00000000 00000000 00000000 00000000 00000000
01001100 01001100 01001100 00000000

00000000 "500 in binary"
01001100 "3" in binary"

huffman codes
lossless compression

JPG: lossy compression
every time you save a jpeg, it gets worse

notes

developing web pages
WINSCP download
remotely log in to another computer

Joshua Waxman
SSN: 123456789

hostname: cs12.cs.qc.cuny.edu
username: wajo6789
password: 123456789

get the winscp program installed
or, for macs:
http://www.pure-mac.com/downloads/fugudl.html

create a folder called public_html

venus.cs.qc.cuny.edu/~joshwaxman/hellothere.html

snopes.com
archive.org
information on the web does not disappear!
google.com

searching: use quotes for phrases
* wildcard character
+ require this
- that dont contain
site:
link:

NLP: natural language processing
computational linguistics
machine translation
books.google.com
bugmenot.com
retailmenot.com