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

Word Practice Exam Walkthrough

cell references
relative vs. absolute references vs. mixed

A1 reference style
R1C1 reference style

operators and operands
5 + 4

functions (also verbs, like operators)
parameters (like operands)
ADD(5, 4)

=SUM

range operators
:
space
,

dates and times are really numbers


WinSCP download
and try to log in
http://winscp.net/eng/download.php
http://www.w3schools.com/html/default.asp

for macs:
http://fugu.en.softonic.com/mac

webserver
client web browser
you type a URL

Joshua Waxman
Social is: 123-45-6789

domain: cs12.cs.qc.cuny.edu
login: wajo6789
password: 123456789

notes

mail merge

To err is human. To really foul things up takes a computer.

Document template
Database (collection of records)

merge these two together

1) we will make the "database" in Excel
make the template in word
insert merge fields
merge the document

2) we will make the database in Word
perhaps modify some of the fields
(it saves it to an Access database)
make the template in word
insert merge fields
merge the document


EXCEL
spreadsheet package
what can i put in a cell?
literal
formulas (start with = sign)
operators, operands

debugging
computer bug
http://en.wikipedia.org/wiki/Grace_Hopper
formula auditing
evaluate formula

cell references

notes from class

qccs012.blogspot.com

VBA
Visual Basic for Applications

macros
record a macro by Doing it
behind the scenes generates VBA code

1) Find all three-letter words, which have a vowel as the middle letter
<[a-zA-Z][AEIOUaeiou][a-zA-Z]>

madamimadam

a man, a plan, a canal, Panama

bits, bytes

bit: binary digit
0, 1

8 bits = 1 byte
4 bits = nibble
2 bytes = word
2 words = dword

1 KB (kilobyte) = 1000 bytes, 10^3 bytes, 1024 bytes, 2^10 bytes
1 MB (megabyte) = 1 million, 2^20 bytes
1 GB (gigabyte) = 1 billion, 2^30 bytes
1 TB (terabyte) = 1 trillion, 2^40
peta
exa
http://en.wikipedia.org/wiki/Petabyte

kilohertz

1 bit, can only store 0 or 1


combining bits together to encode bigger nums

tell me what these nums mean in decimal
HW:
Convert these binary numbers to decimal
11011
111
11
1011011

Preparation for the Word Exam

Here is a prep document.
The file for the practice exam.
And the practice exam.

Homework 4

Chapter 3, hands-on exercise 2
Chapter 3, practice exercise 1, 2, 3, 4

Record a macro in a DOCM file

Tutors, and that there is no class next week

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

And we skip next week, and meet the week after.

Regular expression homework

Write regular expressions in Microsoft Word for each of these things
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) 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?

notes

three types of formatting
character formatting
paragraph formatting
section formatting

insert section break


how do i show file extensions?


wildcards and regular expressions in Microsoft Word

*
?

http://en.wikipedia.org/wiki/Wild_card_(card_games)

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

No class on 9/5/2010 -- Labor Day

I found the academic calendar for the QC Weekend College online. It is here.

It is somewhat difficult to read, but if read correctly, it states that this coming Sunday, 9/5, we have off for Labor Day Weekend. The next time we meet is 9/12.

Have a great vacation!

Some reading

What is a computer?

Something that computes.
http://en.wikipedia.org/wiki/Computer#History_of_computing
http://en.wikipedia.org/wiki/Babbage#Design_of_computers
http://en.wikipedia.org/wiki/Ada_Lovelace#First_computer_program
http://en.wikipedia.org/wiki/Von_Neumann_architecture

long term memory: e.g. hard disk
short term memory: RAM

ALU, arithmetic / logic unit
CPU: central processing unit, = ALU + control unit

Howdy!

Joshua Waxman
CS12 -- Understanding Personal Computers
8:30 - 12:00

We will have a website

You can get the books at the QC bookstore
Grauer, Exploring Microsoft Office 2007 (plus, or vol 1)
NOT!!!!! volume 2

OR, these three:
Grauer, Exploring Microsoft Office Excel 2007
Grauer, Exploring Microsoft Office Word 2007
Grauer, Exploring Microsoft Office Access 2007
NOT!!!! volume 2

Word exam -- 15%
Excel exam -- 25%
Access exam -- 25%
lecture midterm, final -- 10%
web project -- 10%
homeworks -- 10%

get the books!
how to get MS Office

Microsoft Office Ultimate Steal

Start / Run / Excel
Start / Run / Winword
Start / Run / Msaccess

Go to Grauer's website and download the files
http://www.pearsonhighered.com/exploring/
http://wps.prenhall.com/bp_exploring_office_2007_Plus/