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