lecture notes class 4

c:\excel

decision tree

time value of money
money today worth more than money a year from now because I can invest

PV = present value
FV = future value
use interest rate and time to move from PV to FV, or from FV to PV

plus and minus indicate directionality, flow of money
- money away from me
+ money towards me

C:\WORD

what does control do with the navigation keys?

lecture 3

C:\Excel

prenhall.com/grauer
www.pearsonhighered.com/exploring/

select your book
student data files

lab
csstudent

in your c:\excel folder
e02h1loans.xlsx

save as
e02h1loans_LastNameFirstName.xlsx

reference styles in Excel
A1 reference style (columns are letters like A, rows as numbers like 1)
R1C1 reference style (R means row so Row 1, C means column, so column 1)

we can switch between reference styles
File tab / Excel Options / Formulas and check off or clear the checkbox for R1C1 reference style


Quiz: questions from pg 44
I will ask you to count to five in binary
000 0
001 1
010 2
011 3
100 4
101 5

hw: practice and mid-level exercises (45-48)
hw: practice and mid-level exercises for Excel ch 1 (364-370)


input
output
math ability
memory
control

necessary for computer

von Neumann
http://en.wikipedia.org/wiki/John_von_Neumann

Von Neumann architecture
general purpose computer
(universal computer)

memory (RAM)
CPU - central processing unit
control unit
ALU -- arithmetic / logic unit
input
output

fetch-execute cycle
first you fetch an instruction
from memory
and push it into the ALU
ALU executes it

it is a cycle
so the process starts

a computer program to add two numbers together

1. Say "please enter a number"
2. Read a number from input, push it into memory, calling it x
3. Say "please enter a second number"
4. Read a number from input, push it into memory, calling it y
5. Add x and y, store the result in memory, calling it z
6. Say x and y is z
7. Goto step 1

control unit has IP: 1


ADD AX, 5
MOV BX, 5
JMP 1
CMP AX, 7

lecture 2

Can try it one month for free
Split it 5 ways for 9.99 a month before splitting
http://office.microsoft.com/en-us/try/


josh waxman
cunyfirst id: 12345678

login: wajo5678
password: 12345678


1 point = 1/72 "

Serial Numbers in Excel


a text file consist of a series of bytes:

"ABC"

what would stored is:
65 66 67

"65"

54 53

.txt
plain text files where each character corresponds to a single byte
ASCII code for that symbol

Attending

Welcome

CS12
Understanding Personal Computers

Josh Waxman

we will learn about Computer Concepts
we will learn about Microsoft Office
other technologies, e.g. HTML

qccs12.blogspot.com

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

Exploring Microsoft Office 2010
either this one
or this one


Computer Concepts, June Parsons

New Perspectives on Computer Concepts 2011: Introductory (June Parsons Author)

3 big exams
Word - 10%
Excel - 25%
Access - 25%

quizzes - 10%
often on lecture material, maybe some hands-on small actions.
or pulled from mult choice in hands-on book

lecture final - 10%
very similar to on-paper quizzes

homework - 10%
project - 10%

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

Word
Excel
Access

hw: make sure you have these three at home

Windows Key-R
WINWORD and press enter key
EXCEL and press enter key
MSACCESS and press enter key

We made a very simple webpage
name it web1.html


open notepad.
type something
save
change Save as type to All files (instead of Text files)

How to launch Excel
Navigate to the folder that contains EXCEL.EXE program and then double-click on that

1) Launch Windows Explorer (Windows Key-E)
2) Navigate to C drive
3) Navigate to Program Files subfolder
4) Navigate to Microsoft Office subfolder
C:\Program Files\Microsoft Office
5) Navigate to Office15 subfolder
C:\Program Files\Microsoft Office\Office15
6) scroll down until see EXCEL
7) double-click on EXCEL


Call the file
e01h1markup_WaxmanJoshua

we finished excel ch 1 hands on exercises 1-3

File Extensions
what they are, how to see them

8 letter names + 3 letter file extension
WINWORD.EXE
POWERPNT.EXE
EXCEL.EXE

.EXE computer program
.TXT text file
.DOC Microsoft Word Document
.XLS Microsoft Excel Spreadsheet
.HTM plain text, but contains Hypertext Markup language

File extension associations


For the Quiz:
the keyboard shortcuts
Ctrl-S
Ctrl-X
Ctrl-C
Ctrl-V
Shift-Del
Ctrl-Z
Alt-tab
Windows Key-R
Ctrl -
Ctrl +
Ctrl-`

Create a shortcut
Create a folder
Pin a program to the taskbar

End quiz

Binary

qccs12.blogspot.com