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

very short lecture notes

WYSIWYG
what you see is what you get

1) go thru wizard
2) customize for criteria in design view

lecture

Relational databases
Internet vs. World Wide Web

Cartesian product
Select *
From Orders, Customer

then, filter by keys
Select *
From Orders, Customer
Where Orders.CUSID = Customer.CUSID

This is called an Inner Join
alternatively:
SELECT Orders.OrderDate, Orders.Description, Orders.Cost, Customer.FirstName, Customer.LastName
FROM Customer INNER JOIN Orders ON Customer.CUSID = Orders.CUSID;


Internet is connection of computers, or of networks
as opposed to an Intranet

can communicate across the Internet using a protocol
protocol - agreed upon method of communicating

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

HTTP is only ONE protocol that exists on the internet

domain names

database:
tables
queries - asking questions, performing actions to your data
reports
forms

SQL - a language for queries

within access, there are three ways to design a query
1) Wizard
2) Design View for queries
3) SQL


within wizard, three things can choose
1) what table?
2) what fields?
3) what will we name this query?


SELECT LastName, SSN, Age
FROM Customer;



SELECT Customer.LastName, Customer.SSN, Customer.Age, Customer.FirstName
FROM Customer
WHERE Customer.FirstName="Joshua";

where clause

SELECT LastName, SSN, Age, FirstName
FROM Customer
WHERE Age>50 AND FirstName="Joshua"

SELECT Customer.LastName, Customer.SSN, Customer.Age, Customer.FirstName
FROM Customer
WHERE (((Customer.LastName)="Waxman")) OR (((Customer.Age)<25));


UPDATE Customer
SET FirstName="Josh"
WHERE FirstName="Joshua"

UPDATE Customer
SET FirstName="James"
WHERE FirstName="Josh" And LastName = "Waxman"

UPDATE Customer SET Customer.FirstName = "Jimmy"
WHERE (((Customer.LastName)="Waxman"));

DELETE *
From Customer
Where LastName = "Waxman"

INSERT into Customer
VALUES
("Joshua", "Waxman", "1234346", 54)

lecture

non-relational database
problems:
1) gets huge, repetitive data
2) inconsistent data

relational database
primary key
foreign key is a field which is a primary key of a different table

why should i use an index?
instead of (n^2)/2 guesses (is it 1? is it 2? is it 3? etc. not very productive)
log(n) is much more productive

if n is 100, instead of an average of 50 guesses, it would be an an average of 6 or 7.

DataSheet View -- see the actual data
Design View -- see the metadata


saving is weird in MSACCESS
also, no undos.

Solver, in Excel
goal seek has limitations:
1) seek for a specific value
2) can only fiddle with one value
3) no way of imposing constraints

Solver is an Add-In
lets us do all these things
lets us optimize

lecture

interesting UNIX commands you can use to log on to the cs12 computer and "do stuff"

unix commands
cd -- change directory
elm -- electronic mail
pine -- pine is not elm
pico -- pine composer

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

plus, we are going to do:
forms
css
php
javascript

imperative programming languages (like Visual Basic, Java, JavaScript, PHP, C++)

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

This is the beginning of my program!

{?php
for($i = 0; $i < 10; $i = $i + 1) echo "

Hello $i

";

?}

amazon.com
how do we remember info about the user?
server side scripting
client side scripting


early websites that implemeted shopping carts
used client side scripting
javascript
cookie

cookies dont move from computer to computer
they leave a trace
3rd party cookies -- used to track your movement across the web

some javascript that writes a cookie, when displaying an ad. if mult sites use same 3rd party for ads, they can track where you have been. privacy concerns.

use server side scripting
PHP, ASP, ASP.NET

next quiz up to here, no further

Database:
collection of objects used for storing and accessing information

Tables
Table is collection of records
Record is collection of fields

Ways of accessing the data in the table
Form
Report
Query

in MSACCESS

walkthru 5th excel exam

walkthru 4th excel exam

walkthru 3rd excel exam

walkthru 2nd excel exam

lecture notes

connect to cs12 machine

if you have a mac,
to download fugu
http://download.cnet.com/Fugu/3000-2155_4-26526.html
instructions for setting it up with your text editor
http://cs12.cs.qc.cuny.edu/~xiuyi/fugu.html

if you can't log in using a wireless connection from your laptop
on campus, it is because you signed on as Guest. you need to
use real credentials

to convert from APR to annual rate
(1 + RATE/freq)^freq

Walkthru, first practice Excel exam

more to come...

we can nest
HOWEVER, only 7 deep
restriction of Excel


this is limitation
the other is that the formula becomes incredibly complicated

we can reduce the height of the tree by BALANCING the tree
then we can ask a lot more questions
and get a lot more results
specifically, 2^height results

AI = artificial intelligence
expert system
20Q

2^20?

Turing Test. by Alan Turing
http://en.wikipedia.org/wiki/Alan_Turing

http://www.sosmath.com/CBB/viewtopic.php?t=7238&sid=e7a5ec278f2f205c20b1b11074468e35

chatbots
eliza
http://www.cleverbot.com/

try interacting with one of these
=RATE(5,-4500,-25000,70000,0)
=NPER(0.6%, -1000, 12000, 1000000, 0)
=A2/12
=PV(0.7%, 10*12, -1000, 1000000, 0)
=PV(8%, 25, 25000, 0, 0)
forever?
=PV(8%, 3000, 25000, 0, 0)

=PV(8%, 1000, 0, 1000000)

lecture notes

Excel Financial functions

using John Walkenbach, Excel 2003 Formulas
Chapter 11
Not present in the 2007 book

PMT, FV, PV, RATE, NPER

Time value of money
FV = PV*(1 + RATE) ^ NPER

for one year:
FV = PV + PV * RATE
FV = PV * (1 + RATE)

if FV is PV for next year,
for subsequent year, mult by (1 + RATE)

FV = PV*(1 + RATE) ^ NPER
we can solve for PV

flow of money represented by a sign
money flowing towards me is positive
money flowing away from me is negative
answers:

=FV(7%, 3, 0, -1000)
=RATE(8, 0, -1000, 2000)
=NPER(14%, 0, -100000, 1000000)
=PV(1%, 12, 0, 10573.45)
=FV(1%, 24, -300, 0, 1)
=FV(7%, 3, 0, 1000)
=FV(0.75%, 36, -500, -5500, 0)

we finished problem #8

back to the Ifs
=(Subtotal+TaxAmt)* IF(Subtotal>B14, IF(Subtotal>B15, C15, C14), 0)

This is called Nesting
especially when we put one If inside of another If

lecture notes

Visual Basic, If statement

decision making
VB program to calculate semester avg
input?
output?

Private Sub cmdCalculate_Click()
    Dim semesterAverage As Integer
    Dim midterm As Integer
    Dim final As Integer
    Dim bribe As Integer
  
    ' get input
    midterm = txtMidterm.Text
    final = txtFinal.Text
    bribe = Val(txtBribe.Text)
  
    ' processing
    If bribe >= 50 Then
        semesterAverage = 100
    Else
       semesterAverage = (midterm + final) / 2
    End If
  
    ' output results
    cmdCalculate.Caption = semesterAverage
End Sub

HW: Make a greeting line, where if
the Title is absent,
 do something intelligent

HW: In Word MergeFields, use an If Else.
If the person has a pet, inquire about the
pet's well-being, by name. Otherwise, suggest
that they adopt a pet.

Excel
self-documenting
using the Name box
default is to name Absolute References

HW: In excel, using an If, taking in midterm, final, bribe, calculate semester average
Use names for it. All you need to submit is the formula, not a whole spreadsheet

=IF(Subtotal>=100, (Subtotal+TaxAmt)*DiscountPercentage, 0)
=(Subtotal>=100)*(Subtotal+TaxAmt)*DiscountPercentage
It turns out that TRUE is 1.
It turns out that FALSE is 0.

Nesting

HW: Using nesting, calculate a 20% discount
for over $200, a 10% discount for over $100,
otherwise, nothing

Web
Styles are defined within CSS
Cascading Style Sheets
http://www.w3schools.com/css/css_intro.asp

selector declaration
p {color:red;text-align:center;}

Quiz two mondays from now, only up to this lecture

The sorting spreadsheet

has been uploaded to BlackBoard, so check it out.

lecture notes

Bubble Sort, Selection Sort
O(n^2)
as n got really big, problem couldn't be solved in our lifetimes

analyze algorithms

Insertion Sort, also, modification of radix sort

http://en.wikipedia.org/wiki/Insertion_sort
also O(n^2)

modification of radix sort
call range of the numbers m
O(n + m)

if n is a billion
and m is a billion

analyze algorithms to choose appropriate method

http://www.claymath.org/millennium/


traveling salesman problem

generate all possible permutations of cities
then add up cost of all roads
find the minimum
for four cities, 4!
4 x 3 x 2 x 1


what if i have 100 cities?

how many perms? 100!

2^100 < 100!

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

von Neumann architecture
not able to solve it


multiprocessor machines
distributed computing

http://en.wikipedia.org/wiki/DNA_computing
http://en.wikipedia.org/wiki/Quantum_computing

HTML
http://www.w3schools.com/html/html_formatting.asp

gradual move from marking up formatting explicitly to marking up meaning
we'll see more in CSS (cascading style sheets)

font tag
deprecated
instead, we use CSS
style

notes from lecture

Two point curve for the latest lab section
No curve for other section

fear not! there will be other quizzes

computer concepts
___________________
algorithm - like a recipe

task: take a bunch of nums, in any random order, and make them appear in ascending order
Bubblesort
Selection sort
Insertion sort

As the cardinality of numbers get really big, time to carry it out can get out of control
Analysis of Algorithms


Bubblesort: "Are they in the right order?"
if yes, leave alone. if no, swap
http://en.wikipedia.org/wiki/Bubblesort

How long will Bubblesort take? in worst scenario, best, average?
thinking about worst
we have N numbers we want to sort
how many operations will it take?

O(n^2)
10 x 10 == 100

hertz
kilahertz
megahertz
gigahertz

2.8 gigahertz
that's a lot

1 million numbers

Moore's Law

selection sort: "scan for the smallest number and put it into the correct position"
we do less swaps, but still is O(n^2)
http://en.wikipedia.org/wiki/Selection_sort

understand the animations at Wikipedia

x is pos in array (in the collection)
y is size of the number

check BlackBoard soon for the Excel spreadsheet from class

notes

We will make our very *first* program!
adding program

what did I do?
Drew the GUI. Changed the fornt size and other properties of the controls. Changed the name property of a bunch of controls.

at run time, to get access to the properties of a control, we use the . operator

Private Sub cmdCalculate_Click()
    Dim x As Integer
    Dim y As Integer
    Dim z As Integer
    x = txtFirstNumber.Text
    y = txtSecondNumber.Text
    z = x + y
    lblOutput.Caption = z
End Sub

HW: Take as input the Title, FirstName and LastName. Calculate FullName and Display it.

VB or VBA programming


Excel
Relative references, Absolute references, Mixed References
A1 style vs R1C1 style

Relative references change when you copy them

Absolute references stay put
Mixed References: row absolute, column relative
OR
column absolute, row relative


R1C1 stands for row 1 column 1

notes from lecture

CS12

making a web page using WinSCP

first, using notepad
c:\josh\webpage1.html

how do we specify path?
1) full path
c:\josh\subfolder\cow3.jpg
2) relative path
./subfolder/cow3.jpg
../parallelfolder/cow3.jpg
3) we can store it in the same folder
cow3.jpg
4) you can specify a URL
http://co2calculator.files.wordpress.com/2008/09/grazing-cow-1b.jpg

this is called hotlinking. NOT a nice thing to do. and dangerous.

you can host it yourself. or you can get web site hosting from elsewhere

we have:
cs12.cs.qc.cuny.edu/~yourloginname

file transfer protocol, ftp
WinSCP
for Macs (Fugu)

WinSCP lets you edit in place

create a new HTML file using WinSCP
first, create a folder called public_html

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

chmod

VB
Dim varName as Integer

Assignment statement
varName = 7
varName = 9
that is why it is called a variable
its value varies over time

MsgBox is an output statement

Private Sub CommandButton1_Click()
    Dim TaxRate As Double
    TaxRate = 0.078
    MsgBox TaxRate
    TaxRate = TaxRate + 0.05
    MsgBox TaxRate
End Sub

notes

Microsoft DOS
it was a "Disk Operating System"
it used a command prompt instead of GUI
cmd

command prompt

A, B were floppy disks
C was typically hard drive

backslash is the root folder

commands:
tree
c:
dir
dir *.xlsx
cd
cd josh
cd .
cd ..
md
mkdir

BATCH file

three letter palindrome
<([A-Za-z])[A-Za-z]\1>

101
1010
10100

bitshift

VB programming
variable
has name, address, value, data type
declare a variable
Dim TaxRate As Double
double is the data type
7.45 is a double

7 is an integer
"hello there" is a string

Private Sub CommandButton1_Click()
    Dim TaxRate As Double
End Sub

notes

Download and Install WinSCP

webserver
cs12.cs.qc.cuny.edu/~login

username: first two letters of last, first two letters of first name, last 4 digits of SSN
password: all digits of ssn

username: wajo6789
password: 123456789

for Mac, download Fugu instead

HTML
HyperText Markup Language

w3schools.com

markup tags
a is for anchor

read up until HTML attributes

save as DOTM
right click on your own file, rather than Normal, and add the UserForm

write the codebehind
event handler
write VBA syntax
write VBA code to handle these event


input statements
output statements
processing statements

MsgBox is an output statement

Excel
formula auditing
name box to name specific cells

try to login

lecture notes

lossless compression (GIF)
    e.g. run length encoding
lossy compression (JPG, JPEG)
don't save as JPEG until the end

http://en.wikipedia.org/wiki/Vector_Graphics
http://en.wikipedia.org/wiki/Raster_graphics

vector graphics are sharper when zoom in
file size smaller

Macromedia Flash

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

http://www.w3schools.com/

WinSCP Download

Excel
literals
formulas begin with =
operators
can refer to other cells
A1 style
as opposed to R1C1 style
built in functions
SUM, AVERAGE

Tutors and tutor schedule

is available here

what can we do (so far) with binary numbers?

* convert to, from decimal
* add 'em, subtract 'em
* represent negative nums

 101
 101
_____
1010

 11
 11
____
110

 11011
 11011
______
110110

multiplication by powers of 2 can be accomplished via bitshifting to the left

division by powers of 2 can be accomplished via bitshifting to the right

1010 becomes 101 becomes 10 becomes 1 becomes 0

letter A
how do we represent characters?
ASCII
http://www.asciitable.com/

ASCII uses 7 bits
total number of combination is 2 ^ number bits
2 ^ 7 = 128 possibilities

extended ascii

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

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

how do we encode pixels?
pixel = picture element
654 x 466 = 302764


web safe colors

RGB = red green blue
1 byte for each, total 3 bytes

BMP

what is a GIF? what is a JPEG?
compression


lossless compression
- run-length encoding
- GIF
lossy compression

write regular expressions for the following:

1) a sibilant followed by any letter followed by asterisk symbol
2) a capital letter except G followed by anything

1) [sczSCZ][A-Za-z][\*]
2) [A-FH-Z]*

* convert from binary to decimal
* convert from decimal to binary
* add two binary numbers
* subtract two binary numbers

HW: Convert the following numbers to binary and add them:
27 + 56
1 + 6
7 + 3
give me the binary result

HW: Convert the following numbers to binary and subtract them:
8 - 5
12 - 9
20 - 10

remember also the cool trick with 10's complement. and show your friend.

how do we store negative numbers?
-83
three different approaches

* sign bit

83 in binary is  0101 0011
-83 in binary is 1101 0011

* use the one's complement
83 in binary is  0101 0011
-83 in binary is 1010 1100

* use the two's complement
83 in binary is  0101 0011
-83 in binary is 1010 1101

Two's complement is "best"
in terms of values you can store

8 bits lets me store 256 distinct values
2 ^ number of bits
0000 0000 = 0
0000 0001 = 1
0000 0010 = 2

0 .. 255

-0
0000 0000

sign bit
1000 0000

one's complement
1111 1111

two's complement
0000 0000

A clarification of what to submit for assignment 2

for assignment 2, there is no file, and you are not supposed to submit any file to me. make up your own file to search in and then come up with the appropriate regular expressions.

For example, imagine that the first question was to find text in the document which was the letter w, then the letters i or o, then the letter n.

You could write in your document the text:
win
won
wan

In the Find What box, you would type:
w[io]n

and turn on the wildcard option. And when you tried to find, it would find win and won, but not wan. What should you submit to me? In Blackboard, in the comment section, the text w[io]n. But no Word document.

Don't actually submit to me w[io]n. Rather, submit to me the appropriate answers to the questions 1 through 5 in assignment 2.

lecture notes

how do we convert? use a series of subtractions of powers of 2.
Assignment 4:
Convert the folowing decimal numbers to binary.
599
1209
970
1846
849


GUI - pronounced gooey
graphical user interface
controls
dropped the controls on the form
modify properties of those controls

Assignment 5:
Imagine a program where the Input is Title, FirstName, LastName, and the Output is the FullName. Draw a GUI for this program.

Assignment 4 and 5, due next Monday

Don't forget!

Assignment #1 is due this Monday night!

And Assignment #2 and #3 this Wednesday night.

Assignment 2, 3 is now posted

on BlackBoard.

class 3 notes

file extensions

termpaper.DOC
termpaper.DOCX
termpaper.DOCM

.HTML
.TXT
.EXE

TestDatabase.accdb

Old way: First run program. THEN open the file

New way: File extensions. Associates with program.

*
?
regular expressions

read these two articles:
http://office.microsoft.com/en-us/support/add-power-to-word-searches-with-regular-expressions-HA001087305.aspx?redir=0

http://office.microsoft.com/en-us/support/putting-regular-expressions-to-work-in-word-HA001087304.aspx?redir=0

1) Find all three-letter words which have a vowel as the middle letter.
2) Find all three-letter palindromes
3) Find all four letter words which begin with the letter K
4) Change Waxman, Joshua to Joshua Waxman
5) Transform active voice to passive voice. That is, find sentences such as:
Jim kissed Pam.
and replace it with
Pam was kissed by Jim.
For this last one, what goes in the find what box, and what goes in the replace with box?

bit: 0, 1
how do i represent numbers using these bits?
binary: base 2

HW: Convert the following binary numbers to decimal.

11011
11
111
1111
10010

How to record a macro in Microsoft Word

Assignment 1 is now posted

to BlackBoard.

notes, class 2

Programming language: VBA
Visual Basic for Applications

record a macro homework

how do I make a 15 pg paper into a 20 pg paper
Line spacing
Adjust margins
Spacing before and after paragraphs
Change the font

font is measured in point size
1 point = 1/72 inch

fixed-width, proportion-width fonts

serif, sans serif

lorem ipsum

Three types of formatting in Word
Character
Paragraph
Section

be careful about search and replace
advanced search and replace
wildcard
* ?
* is any number of letters
? is exactly one character
qccs12.blogspot.com

notes, class 1

http://www.cs.qc.edu/tutors.html

things a computer needs
input
output
memory
control
math ability

von Neumann architecture
http://en.wikipedia.org/wiki/Von_Neumann_architecture
CPU (central processing unit):
    ALU - arithmetic / logic unit
    control unit
memory (RAM)
    bus

http://en.wikipedia.org/wiki/Computer#History_of_computing

Syllabus

Joshua Waxman
joshwaxman@gmail.com

qccs12.blogspot.com

Understanding Personal Computers (Cs12)
Computer Concepts
Microsoft Word
Microsoft Excel
Microsoft Access
HTML

Book:
Grauer, Exploring Microsoft Word 2007
Exploring Microsoft Excel 2007
Exploring Microsoft Access 2007

NOT 2003!
Comprehensive OK, Plus OK
Volume 1 OK,
Volume 2 NOT OK!

Exploring Microsoft Office 2007

Lab exams
Word - 10%
Excel - 25%
Access - 25%

Website -- 10%
HW -- 10%
Quizzes -- 10%
Final -- 10%

http://office.microsoft.com/en-us/

microsoft ultimate steal
http://www.microsoft.com/student/office/en-us/default.aspx

Prentice Hall's Website
for downloading the files
prenhall.com/grauer