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