Please Check Blackboard

I put in all the exam grades. If you took the exam but don't see your grade there, please contact me ASAP.

Thanks,
Josh

how to download and install fugu and textwrangler
http://cs12.cs.qc.cuny.edu/~xiuyi/fugu.html

the web page assignment
http://eniac.cs.qc.edu/~svitak/cs12/webpageassign.html

Access exam is today

at 10 AM.
If you took it last week, then you already took it.

Here is a direct link to the second practice access test

Here you go.

Practice Access Exams

#1


and #2

Instructions for the web page assignment

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

#775F55

hexadecimal - base 16

binary base system
octal base system

0123456789ABCDEF

two decimal digits -- 100 diff values

two binary digits - 4 different value
00
01
10
11

two hexadecimal digits - 256 different values
16 x 16 = 256
2 ^ 8 = 256

colors often stored as RGB
255
0
0
pure red

0
255
0
pure green

0
0
255
pure blue

0 - 00
0
0
black

255 - FF
255
255
pure white

How to view the web page you wrote

It can be found at:
http://cs12.cs.qc.cuny.edu/~yourloginname/yourhtmlfilename.html

Ch 3, practice exercises 1-4

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

But:
I also want you to incorporate a bit of CSS in it
http://www.w3schools.com/

lecture notes

three steps in the wizard
1) choose your table(s)
2) choose your field(s)
3) name the query

THEN, you will likely need to go to Design View
there, you will choose your criteria, sorting order, etc.

SELECT Accounts.CID, Accounts.BID, Accounts.Balance
FROM Accounts;

SELECT CID, BID, Balance FROM Accounts WHERE BID="B5";

SELECT Accounts.CID, Accounts.Balance, Branch.Location, Customers.FirstName, Customers.LastName
FROM Customers INNER JOIN (Branch INNER JOIN Accounts ON Branch.BID = Accounts.BID) ON Customers.CID = Accounts.CID
WHERE (((Branch.Location)="Central"))
ORDER BY Accounts.AID;

HW: Not chapter 1. yes, chapter 2, access, practice exercises 1-3

Cartesian Product
Select, Customers.CID, FirstName, LastName
OrderID, OrderDate,Orders.CID,Cost
From Customers, Orders;

SELECT * From Customers, Accounts
WHERE Customers.CID = Accounts.CID
This is called an INNER JOIN


SELECT * From Customers INNER JOIN Accounts
ON Customers.CID = Accounts.CID

lecture

note to self
pick up at example 16 or 17

start access:
start/run/
msaccess

http://www.officelive.com/en-us/

openoffice.org

Database - data and methods of accessing that data
a collection of Tables

Table - a collection of records

Record - a collection of fields

Field - one unit of information

Query - a question about the data

Form - a means of modifying the data in a controlled manner

Report - a means of displaying the data, often for printout

walkthru excel practice 5

walkthru excel practice 4

walkthru excel practice 3

walkthru excel practice 2

Walkthru, first practice Excel exam

more to come...

Preparation for the Excel Exam

Here is a link to a study guide
Instructions for Practice Exam 1, Exam 2, Exam 3, Exam 4, Exam 5
Download the files for the exam here.
But those were the files I placed in your Desktop folder

Plan for today:
* date and
time arithmetic
* conditional formatting
pivot tables
* goal seek vs.
solver
advanced filtering

excel practice exams

web pages

begin Microsoft Access

----

* date and
time arithmetic

a Date is a whole number (integer) representing the number of days since January 0, 1900

we can do simple arithmetic using + - / *
and also, there are date functions such as Today(), Day(), Month(), Year(), Date()

Time is represented by a fraction of a day
we can do simple arithmetic using + - / *
and also, there are date functions such as Now(), Minute(), Second(), Hour(), Time()

goal seek vs. solver

Goal seek has limitations
goal seek only lets you fiddle with ONE number
does not allow you to apply constraits to reflect reality
only lets you "seek" towards a specific number, rather than, say, a maximum or a minimum

Instead, solver

Solver is a add-in, comes free with Excel

Excel exam, two weeks from now

Pivot Tables
Macros
UDFs (User Defined Functions)
Solver

HW: Ch 4, practice exercises 1-4

w3schools.com

log in using WinSCP to our cs12 accounts
we will make a folder called public_html
everything within public_html is exposed to the world.
we will write HTML files within this public_html folder

host: cs12.cs.qc.cuny.edu
user name: wajo6789
password: 123456789

index.html

open up a web browser. URL is:
cs12.cs.qc.cuny.edu/~wajo6789/index.html

I committed a breach of "Netiquette".
I hotlinked.

IF function in Excel

AI (artificial intelligence)
expert system working via decision tree


concept of time value of money
FV = PV*(1 + RATE)^PER

expressing interest rates
APR -- annual percentage rate; nominal rate
Annual Effective Rate -- how much you are really getting / paying, for the year
Periodic Effective Rate -- how much you are really getting / paying, for the compounding period

goal seek

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

HW:
Excel Ch1, Ch2, practice exercises 1-4

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

C:/webpage/hello.html