design a table to store course information,
make up information to fill that table
course number, number of credits, faculty, faculty rating

design a table to store faculty information,\
msaccess


Access is different from other office applications
does not automatically start with a blank database
you need to create a blank database on the disk

Many changes to the database automatically save
(editing a table)
also, cannot undo

which is why we often save backup copies of a database

create /; table design
there is data and there is meta-data

in access, must explicitly save meta-data
changes to data automatically save
Link of the CS dept at Queens College
http://www.cs.qc.cuny.edu/

http://www.cs.qc.cuny.edu/schedule/fa12/fa12.htm

non-relational
will have duplicated values
inconsistent data

Guidelines:
in general, fields should be as atomic as possible
keep fields as unchanging as much as possible
calculate changing values based on that

Prepare for the Excel exams

Excel practice exam files,

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


Walkthroughs:
Exam 1



Exam 2


Exam 3


Exam 4


Exam 5

UDF: user defined function

Alt-F11: launches VB editor
Insert/Module: add new module

then type:
Function MySum(X, Y)
    MySum = X + Y
End Function


HW: write a UDF called MyProduct
which will be X times Y

why use names? self-documenting formulas

you can also Name relative refs and mixed refs
name manager
DiagonalUp

MonthlyPayment
='HO3-4'!$H9

databases
record: row in Excel
table: collection of records, tab, worksheet
database: collection of tables and methods of interacting with those tables
field: corresponds cell (or column?)

Access is a relational database
what does that mean?
*shrugs*

HW:
design a table to store course information,
make up information to fill that table
course number, number of credits, faculty, faculty rating

design a table to store faculty information,\
msaccess

codeacademy, defining functions, and that is almost all

VBA

stands for Visual Basic for Applications

classes (types) of programming languages
- functional programming language (Lisp)
- logical programming languages (Prolog)
- imperative programming language (C, C++, Javascript, VBA, etc)

to gain access to VBA, Alt-F11

Immediate window lets me type commands which are immediately carried out
to access the immediate window, must press Ctrl-G
HW: try this out in VBA in Excel
? 1
 1
? "hello"
hello
? 1 + 2
 3
? 50 + 100 / 2
 100
? Len("Ryan")
 4
myFirstName = "Joshua"

? myFirstName
Joshua
lastName = "Waxman"
myFullName = myFirstName & " " & lastName
? myFullName
Joshua Waxman
? Len(myFullName)
 13
Call MsgBox("hello")
Call MsgBox("hello", vbYesNo)
number = 42
? number / 2
 21
? number Mod 10
 2
myString = "hello"
? Mid(myString, 1, 2)
he
three = Mid(myString, 1, 3)
? three
hel
? replace("coding rules", "coding", "programming")
programming rules
? UCase(myString)
HELLO
? LCase(myString)
hello
? Range("A1")
 761
Range("B1").Value = 986

Quiz #2 will be on Mond, Tues, next week, in lab.

HW: due next Tues,
submit via screenshot

1) Write up a single webpage about your favorite sport.
Use 2 pictures to illustrate it. Some text should be:
* bold
* italics
* bold italics
* underlined

Also, include a link to another webpage somewhere on the Web which discusses your sport.

for help with the HTML, remember that you have w3schools.com

web pages:
order a tuna sandwich

hotlinking
is often like stealing

 netiquette - internet etiquette
1) don';t hotlink
2) NO ALL CAPS!!!!
3) Don't reply all.

Email storm

To:
CC:
BCC:
http://en.wikipedia.org/wiki/Email_storm

also, with hotlinking, you are not in control of the image

Second quiz only up to today.

we did more excel. if, vlookup

sequential search, binary search

Sputnik and the internet

http://www.computerworld.com/s/article/9036482/Happy_Birthday_Sputnik_Thanks_for_the_Internet_

http://computer.howstuffworks.com/internet/basics/internet-start.htm

every computer can have an IP address
http://en.wikipedia.org/wiki/IP_address?utm_source=twitterfeed&utm_medium=twitter

DNS domain name service
google.com
will yield
http://72.14.204.101/

0.. 255
256 ^ 4

URL
Uniform resource locator
http://en.wikipedia.org/wiki/Uniform_resource_locator

scheme://
protocol://

http://
hypertext transfer protocol

https://
secure

ftp://

telnet://

gopher://

domain:
en.wikipedia.org
http://en.wikipedia.org/wiki/Uniform_resource_locator
scheme://domain/

domain
last two items, usually, in the US
subdomain
e.g., en, www,

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

scammers
phishing scheme

http://chase.safenetworking.com/login
http://chase.scamsite.com/login

http://3.0.4.123/chase.com/

http://0xc.0x2.4.123/chase.com/

TLD
top level domains
TLAs
three letter acronyms

.com
.net
.biz
.tv
.org
.gov
.edu
.xxx

country codes
uk
.co.uk
google.co.uk

whitehouse.gov
whitehouse.net

rot13
http://www.pearsonhighered.com/exploring/

in excel, dates are really numbers
number of days since Jan 0, 1900

R1C1 reference style

Row 1 column 1

A1 reference style
column A row 1

naming cells makes absolute refs much easier