Grades are now in CUNYFirst

Though they might not show up until Monday for you.

If you got an F, don't fret! This is readily resolvable. It means that I am missing a test for you, for whatever cause, and did not want to give you a low grade without getting your attention. Otherwise, you might have gotten a B and not thought to ask me about it, when you should have gotten an A+, for example. Please contact me ASAP -- I'll try contacting you as well -- and we can resolve this quickly.

The following students should contact me

It is possible a text got misplaced by a lab instructor, or some associated problem, such that you deserve a higher grade:

N. Misra
J. Fernandez
M. Rivera

More to come, possibly.

Answers to the quizzes

1) c
2) control unit
3) b
4) 1024
5) a

---

1) a
2) RAM
3) d
4) nothing. it is a fossilized marine animal.
5) b

-----


1) b
2) b
3) 1023
4) graphical user interface
5) a
6) d

_____________

1) a
2) a
3) 210, or (n + 1) * (n/2) with n =20
4) a code of storing characters
5) c
6) a

------

1) b
2) a
3) 51 * 25
4) 16
5) c
6) b

----


1) you can seek for multiple values in cells
2) b
3) stealing bandwidth by referencing an image located on someone else's website
4) a
5) lets you see what cells this current cell relies on
6) chase-banking.com

----

New:
1) b
2) b
3) 3rd party cookies can be used to track your behavior and history on the web
4) d
5) c
6) d
7) b
8) a value in one table, corresponds to primary key of other table
9) c

list of homeworks

Homeworks:
HW: make a macro, any macro
HW: make a UDF, any UDF

defined here:
http://qccs12.blogspot.com/2011/04/ipmt-ppmt-find-out-is-lab-instructor.html

HW:
lecture book, review questions at end of ch 1
lecture book, exercises in ch 2
lecture book, review questions at end of ch 3

HW:
1) Convert these numbers to binary:
7
14
103

2) Convert these binary numbers to decimal:
11001
110
11
1101

3) Convert those numbers in part 2 to octal.
4) Convert those numbers in part 2 to hexadecimal.

Previous Quiz Questions

1) Convert this binary number to decimal:

10101

a) 19

b) 20

c) 21

d) 22

2) The CPU contains the ALU and the ________

3) Which of the following is an example of long-term memory?

a) CPU registers

b) CD-ROM

c) CD-RAM

d) RAM

4) One kilobyte = how many bytes?

5) Which will be faster, a compiled language or an interpreted language?

a) compiled

b) interpreted

c) same speed

d) neither, because there is no such thing

---------------

1) Convert this decimal number to binary:

25

a) 11001

b) 10001

c) 11011

d) 11000

2) The fetch-execute cycle fetches instructions from ________

3) Which of the following is an example of volatile memory?

a) hard disk drive

b) CD-ROM

c) CD-RAM

d) RAM

4) One trilobite = how many bytes?

5) C++ is an example of a

a) low-level language

b) high-level language

c) interpreted language

d) none of the above

---------------

1) The collection of HTML documents, linked together, across many countries is best called:

a) the Internet

b) the World Wide Web

c) the Intertubes

d) CSS

2) The HTML document you view on your web browser usually initially comes from

a) a web client

b) a web server

c) an http

d) Microsoft Word

3) Using the party trick I discussed in class, using your ten fingers, you could count up to:

______________

4) A GUI is _____________________________

5) A 256 color bitmap can store a pixel in how many bytes?

a) 1

b) 2

c) 3

b) 4

6) If I tried to solve the traveling salesman problem for 100 cities, using the algorithm I described, 

and started it now, it would finish:

a) in one minute

b) in one hour

c) in one day

d) in more than a trillion years

--------------------

1) If I used my algorithm for traveling salesman for five cities, my program

would finish executing in:

a) less than an hour

b) a day

c) a year

d) more than a trillion years

2) A web page will typically be in the following format:

a) HTML

b) HTTP

c) FTP

d) DOC

3) The sum of the numbers 1 through 20 is:

______________

4) ASCII is:

5) Which is likely the smallest of images?

a) a BMP bitmap

b) a JPEG image

c) an SVG vector graphics image

6) If a collection of numbers are sorted, then I can use binary search

a) true

b) false

-------------------------------

1) The Internet is a synonym for the World Wide Web:

a) true

b) false

2) A web page will typically be in the following format:

a) HTML

b) HTTP

c) FTP

d) DOC

3) The sum of the numbers 1 through 50 is:

______________

4) A hexadecimal digit is in base: ________________

5) A "true-color" bitmap can store a pixel in how many bytes?

a) 1

b) 2

c) 3

b) 4

6) Linear search through a collection is faster than binary search, on average:

a) true

b) false

---------------------------

1) Give one way in which Solver is better than Goal seek.

2) If I want to figure out how much to deposit now in order to

retire with a million bucks, I would use the _______ function.

a) FV

b) PV

c) PMT

d) RATE

3) What is hotlinking?

4) Which of the following is a relative reference?

a) A1

b) $A$1

c) $A1

d) R1C1

5) What does the trace precedents tool do?

6) In http://chase-banking.com/login

what is the domain?

----------------------------

New:

1) Which of the following is used for client-side scripting?

a) C++

b) JavaScript

c) Python

d) PHP

2) In CSS, the level which takes highest cascading precedence is:

a) internal

b) inline

c) external

d) web browser settings

3) Give one reason cookies are bad:

_______________________

4) In CSS, we can target:

a) a tag

b) a bunch of related items, by class

c) one individual item, by id

d) all of the above

5) Really, dates and times are stored in Excel and Access as:

a) text

b) dates

c) whole numbers and fractional numbers

d) none of the above

6) The following text will be matched by h??lo

a) hOOOLO

b) bkjlo

c) helo

d) hello

7) Descartes walked into a bar. When he turned down a drink:

a) he appeared

b) he disappeared

c) he reappeared

d) all of the above

8) A foreign key is: ______________________

9) A record is a collection of:

a) records

b) rows

c) fields

d) views

we did some simple PHP.
AJAX - asychronous JavaScript and XML

Web 2.0

ajax is really just the combination of JavaScript on the client side with e.g. PHP on the server side, communicating with each other asynchronously via XML

Open source software
http://en.wikipedia.org/wiki/Open-source_software

Linux -- a free, open source Operating System

OpenOffice - a free office clone
openoffice.org

talk next time briefly about google docs

lecture

<html>
<head>
<link rel="stylesheet" type="text/css"

href="first.css" />
</head>

<body>
<p>This is all about my friends!</p>
<hr/>
<p>They are nice.</p>
</body>
</html>

for the web site, use an external style sheet on at least one web page.

client side scripting vs. server-side scripting


web server sends info to the web browser (which is the client)

Javascript -- carried out on the client's machine

javascript is event-driven.
as opposed to procedural-based programming.

Javascript can write cookies.

drawbacks of cookies.
stays only on that machine.

third-party cookies.
both site A and site B get their ads from site Z. site Z is the third party.

third-party cookies can be used to track users.

Amazon obviously does NOT use simple cookies to keep track of your order.

they use server-side scripting. examples of lanugages that support it: PHP, vbscript meaning ASP, ASPX.

often, hooked up to a database.

next up, AJAX.