note to self. midway on midlevel exercise 3 on ch 6, assigned mid 4 for hw

my email address

is joshwaxman at gmail dot com.

contact me if you need to know your grade

in chapter 6, we finished up to NETWORKDAYS

cs88 test 1 planned

next wednesday
1) some group of tasks from ch1 (grauer)
2) some group of tasks from ch2 (grauer)
3) some group of tasks from ch3 (grauer)
4) some group of tasks from ch4 (grauer)
5) 2 or 3 formula oriented tasks from formula book, ch 1-5

walkenbach
ch 3) making names of different types
ch 4) writing simple formulas, making use of simple functions we have seen (Cs12 type material, maybe slightly harder/)
ch 5) formula to solve something
a) give me a *plan* for extracting the third word from The rain in Spain falls....
b) i'll tell you what we want accomplished, and give you a general plan. write the formula

=FIND(" ", A38)    =FIND(" ", A38, A54+1)    =SUBSTITUTE(A38, " ", "@", 2)    =FIND("@", C54)    =MID(A38, A54+1, D54-A54-1)

things to do with nested if

leapyear problem

lecture notes

available here.

HWs so far

1) Ch 1 mid 5
2) Ch 1 mid 4
3) Lecture: Convert text numbers to actual numbers. Convert the other way.
4) Ch 2 practice 3 -- election trends
5) Lecture: Tell me if a letter contained in A1 is lowercase.
6) Lecture: Safely convert to UPPERCASE, only if the letter is lowercase.
7) Ch 2, mid-level exercise 3: high school art collection
8) Ch 2, mini-case 2: investment club
9) ch 3, practice exercise 2: anytimetalk inc
10) ch 3, midlevel exercise 1: the next car you purchase
11) ch 3, midlevel exercise 5: computer sales analysis
12) ch 4, practice exercise 1
13) ch 4, practice exercise 4
14) ch 7, all the hands-on exercises
14) ch 4, capstone exercise
15) ch 4, mini case 3
16) lecture: leap year not using date trick
17) ch 5, mid-level 1 and 2
18) ch 6, practice exercises 1 thru 4
19) ch 6, mid-level 4
20) ch 7, all the hands-on exercises (there are two of 'em)
21) ch 8, mid level exercise 1 and 2