Grades

for final exam are posted. quiz grades up shortly.
contact me if you took the final but don't see a grade in blackboard.

Forms and JavaScript

Forms and PHP
http://w3schools.com/php/php_forms.asp

JavaScript
http://www.permadi.com/tutorial/jsInnerHTMLDOM/index.html

Final review

Is available here:
https://docs.google.com/document/pub?id=1jTkFG9LLKnjCZeuKw1RheGZSolbLmBmO4h1eWlsUxDg

for button in JavaScript, see here: http://www.permadi.com/tutorial/jsInnerHTMLDOM/index.html

Quiz 4 questions

1) In a database, a record is roughly the equivalent of an Excel
a) column
b) row
c) cell
d) tab

2) The Access object which lets you modify records in a controlled manner is a:
a) query
b) table
c) form
d) report

3) Why would I want to make first name and last name indexes of a table?

4) A primary key is:
a) one used to lock a table
b) one used to unlock a table
c) used to uniquely identify a record in a table
d) a key used by an ape

5) Solver is better than Goal Seek because
a) it allows you to specify constraints
b) it allows you to fiddle with multiple cells
c) it allows you to seek maximums and minimums
d) all of the above

6) If I want a list of all people named Joshua whose age is more than 50, I would write:
a) SELECT LastName, SSN, Age, FirstName
FROM Customer
WHERE Age>50 AND FirstName="Joshua"
b) SELECT LastName, SSN, Age, FirstName
FROM Customer
WHERE Age>50 OR FirstName="Joshua"
c) UPDATE Customer
SET FirstName="Josh"
WHERE Age > 50

7) When Descartes turned down a beer in a bar,
a) he appeared
b) he reappeared
c) he disappeared
d) none of the above

8) The Internet is the same as the Web:
a) true
b) false

9) Explain

10) In http://en.wikipedia.org/wiki/Hypertext_Transfer_Protocol,
the http is the
a) protocol
b) filename
c) hypertext
d) widget

11) In http://en.wikipedia.org/wiki/Hypertext_Transfer_Protocol, the domain is:
a) http
b) en.wikipedia.org
c) wikipedia.org
d) org

12) An example of a top level domain is:
a) .edu
b) .co
c) yahoo.com
d) www

Quiz 3 Questions

1) If I want to borrow $1,000 today, and the APR is 6%, compounded quarterly (that is, four times per year), what will be the value of that investment 10 years from now? Let me know what EXCEL function you would use, as well as the values for each of the parameters. (You don't need to have them in the right order -- just identify the parameters and their values.)

2) Describe, in one sentence, the Turing Test. (Just enough so that I know that you know what it means.)

3) An example of a programming language used for Server-Side scripting is:

a) Java

b) JavaScript

c) Visual Basic for Applications

d) PHP

4) What is a cookie?

5) Give me an example of a Unix command.

1) If I want to invest $1,000 today, and the APR is 6%, compounded monthly (that is, twelve times per year), and I eventually want to have $1 million, how long should I leave that money in the account? Let me know what EXCEL function you would use, as well as the values for each of the parameters. (You don't need to have them in the right order -- just identify the parameters and their values.)

2) Describe, in one sentence, an expert system. (Just enough so that I know that you know what it means.)

3) An example of a programming language used for Client-Side scripting is:

a) Java

b) JavaScript

c) Visual Basic for Applications

d) PHP

4) Who gets to read a cookie which has been written to your hard drive?

5) Give me an example of a DOS command.

1) If I want to invest $1,000 today, and have $1 million ten years from now, what will be the annual rate of return? Let me know what EXCEL function you would use, as well as the values for each of the parameters. (You don't need to have them in the right order -- just identify the parameters and their values.)

2) Describe, in one sentence, decision tree. (Just enough so that I know that you know what it means.)

3) An example of a programming language used for Server-Side scripting is:

a) Java

b) JavaScript

c) Visual Basic for Applications

d) PHP

4) Why are third-party cookies a privacy risk?

5) What does the CD command do, in either Unix or DOS?

Quiz 2 Questions

1) In Visual Basic for Applications (that programming thing we did in Microsoft Word), give me an example of an assignment statement.

2) What is an example of a relative path?

a) <img src="http://apple.com/fruit.gif" />

b) <img src="../images/fruit.gif" />

c) <img src="fruit.gif" />

d) <htlnk src=""http://apple.com" />

3) If I am in cell C5, and I want to write an absolute R1C1 reference to cell A1, what would I type?

4) Selection sort runs in O(n^2) time. What does that practically mean, if I want to bubblesort a million numbers into ascending order? Explain.

5) If the person's state is Texas, then I want Mail Merge in word to greet them using Howdy! Otherwise, I want to greet them using the form of Dear FirstName LastName, but with FirstName and LastName replaced with the actual name. What would you type to accomplish this If in Mail Merge?

1) In Visual Basic for Applications (that programming thing we did in Microsoft Word), the dot operator is used as a possessive, like apostrophe s in English. Give me an example of this dot operator in use.

2) What is an example of a selector?

a) <img src="http://apple.com/fruit.gif" />

b) The p in p {font-family:"Times New Roman";}

c) The font-family in p {font-family:"Times New Roman";}

d) The "Times New Roman" in p {font-family:"Times New Roman";}

3) If I am in cell C5, and I want to write an absolute reference to cell A1, what would I type?

4) Explain the behavior of selection sort, in brief (a sentence or two).

5) Why would it make sense to make the reference, to the table in which you are looking up some value in a VLOOKUP, an absolute reference?

1) In Visual Basic for Applications (that programming thing we did in Microsoft Word), give me an example of a declaration.

2) What is an example of hotlinking?

a) <img src="http://apple.com/fruit.gif" />

b) <img src="../images/fruit.gif" />

c) <img src="fruit.gif" />

d) <htlnk src=""http://apple.com" />

3) If I am in cell C5, and I want to write a relative R1C1 reference to cell A1, what would I type?

4) Bubblesort runs in O(n^2) time. What does that practically mean, if I want to bubblesort a million numbers into ascending order? Explain.

5) If the first name is Conrad, then the student gets 100 on his semester grade. Otherwise, it depends on the student's last name. Namely, if the student's Last Name is Schiff, then he gets a 90. Otherwise (meaning the first name is not Conrad and the last name is not Schiff), then the student gets the average of his midterm and final grade. Write an Excel formula, using the IF function, which computes this.

Quiz 1 Questions

1) In the von Neumann architecture, what does the control unit do?

2) An example of long-term memory is:

a) RAM

b) a CPU register

c) a hard disk

d) an elephant

3) In terms of fonts, what is a serif? ______________________

4) The ? wildcard character matches what?

5) Here is a word regular expression. Give an example of something this would match:

<([A-Z])[!aeiou]\1>

6) If select a word and then I change the font size, this will impact the formatting of entire paragraph.

a) True

b) False

7) Where would I find the record Macro button in Word?

8) A Word 2007 Document which does NOT include macros would have a file extension of:

9) What is the binary number 1010 in decimal?

a) 11

b) 10

c) 9

d) 8

10) To get the one's complement of a binary number,

a) I flip the bits

b) I flip the bits and add one

c) I tell it that its tie is nice

d) I shift the bits to the right

11) What is a command prompt?

12) In HTML, what does the <p> tag mean?

13) Give me an example of an output device.

14) If I made a 256-color bitmap, which was 10 pixels across and 10 pixels down, approximately how many bytes would that take up?

15) An example of something which uses lossless compression is:

a) GIF

b) BMP

c) Scalable Vector Graphics

d) JPG

1) In the von Neumann architecture, what does the bus do?

2) An example of short-term memory is:

a) RAM

b) a CD

c) a hard disk

d) an elephant

3) In terms of fonts, what is a point?

4) In Microsoft Word regular expressions, the < character does what?

5) Here is a word regular expression. Give an example of something this would match:

<P??X>

6) If select a word and then I change the margins, this will impact the formatting of the entire:

a) paragraph

b) page

c) section

d) document

7) What is the codebehind?

8) A plain text document, written in NOTEPAD, would typically have a file extension of:

9) What is the binary number 1000 in decimal?

a) 11

b) 10

c) 9

d) 8

10) To multiply a binary number by 2,

a) I flip the bits

b) I flip the bits and add one

c) I tell it that its tie is nice

d) I shift the bits one position to the left

11) What is a command prompt?

12) In HTML, what does the <h1> tag mean?

13) What is a bit?

14) If I made a 16-color bitmap, which was 10 pixels across and 10 pixels down, approximately how many bytes would that take up?

15) An example of something which does NOT use raster graphics is:

a) GIF

b) BMP

c) Scalable Vector Graphics

d) JPG

1) The ALU stands for

a) Truth, Justice, and the American Way!

b) The American Liberties Union

c) The Arithmetic / Logic Unit

d) The Arithmetic / Logarithmic Unit

2) In the von Neumann architechture, the thing which transfers 

data from one portion to another is called the

a) truck

b) bus

c) car

d) van

3) Define a fixed width font: ______________________

4) The * wildcard character matches what?

5) Here is a word regular expression. Give an example of something this would match:

<[A-Z][!aeiou][!aeiou][!aeiou]>

6) If select a word and then I change the line-spacing, this will impact the entire paragraph.

a) True

b) False

7) How do I display the Developer tab in Word?

8) A Word 2007 Document which happens to include macros would have a file extension of:

9) What is the binary number 1011 in decimal?

a) 11

b) 10

c) 9

d) 8

10) To get the two's complement of a binary number,

a) I flip the bits

b) I flip the bits and add one

c) I tell it that its tie is nice

d) I shift the bits to the right

11) What does GUI stand for?

12) In HTML, what is a tag?

13) Give me an example of an input device.

14) If I made a two-color bitmap (black and white), which was 400 pixels across and 100 pixels down, approximately how many bytes would that take up?

15) An example of something which uses lossy compression is:

a) GIF

b) BMP

c) Scalable Vector Graphics

d) JPG

Practice Access Exam #2

more on domains.

top level domains, subdomains.

Final
next wednesday, in this room, 4 - 6
a lot of multiple choice
maybe a few short answers
25 - 30 questions total


qccs12.blogspot.com
qccs12 is a subdomain
blogspot.com is a domain

cs12.cs.qc.cuny.edu
eniac.cs.qc.edu
venus

why is this important?
Phishing scams
http://www.chase.com.scamsite.ru/

TLDs
top level domain
.com, .net, .org, .edu, .gov

yahoo.co.uk

Solver in Excel
how is it better than goal seek?
can seek to min or max,
fiddle with multiple cells,
impose constraints

backing up your data
most important: data files

Dropbox

Practice Access Exam #1

useful websites
google.com

http://www.nytimes.com/2010/11/28/business/28borker.html?pagewanted=all


gmail uses AJAX
AJAX: asynchronous Javascript and XML
stuff going on on the client, and on the server
makes a website more reactive

books.google.com
translate.google.com
docs.google.com

http://www.openoffice.org/

archive.org
has the wayback machine

cache
personal copy of some website
used to speed up web viewing

cache:http://www.joyofhandspinning.com/

http://www.pandora.com/


anatomy of a URL

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

The syntax is
scheme://domain:port/path?query_string#fragment_id

everything from :// to FIRST / is the domain
very VERY useful for catching Phishing schemes

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

why seeing numbers should be a clue of something suspicious

IP address
DNS
phone book looking up names and matching to IP addresses
http://www.whois.net/



which will help detect Phishing scam

Instructions from Xiuyi on installing Fugu and TextWrangler for MAC.

The web page assignment:

Everything as described here:
http://eniac.cs.qc.edu/~svitak/cs12/webpageassign.html

Plus:
1) Use an external CSS file to style the webpages (for example, to make all the backgrounds the same image, or green; to make all paragraphs of some type (e.g. "topic paragraph") centered.

e.g.
in the main CSS file
p.topic {text-align:center;}

in an individual HTML page

This paragraph will be center-aligned.

2) Make a form which prompts for First Name and Last Name, and button to Submit.

Recall, w3schools has enough to let you do this with simple cut and paste.

This will be hooked up to a PHP program which will greet the person by the full name. "Hello, FirstName LastName".

Recall, w3schools has enough to let you do this with slight modifications from the section PHP Forms.

3) Using JavaScript, make a webpage with a button. When you click on the button, make the caption of the button become "Hello World".

Reminder: the quiz

will not include any material on databases