examples for test

ch 6: date and time
give a bunch of times in and out
get me the sum of the time for the person
multiply by hourly rate
how much does he earn

Bill worked from 4/1/1903 to 5/4/1905. He had off on Sundays and Saturdays, as well as the holidays listed in C5:C30
He got $60 a day. How much did he earn?

Bill came in at 5:30 AM. He worked for 5 hours, 12 minutes and 2 seconds. Generate the time he leaves.

summing over a range using simple functions
and using array formulas

some simple array manipulations

chapters for second midterm

formula: ch 6, 7, 14, 15
grauer: 5, 6, 7

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

Lecture Homework Submission Form

Things to do with char and code

1) Convert text numbers to actual numbers. (HW)
2) Convert the other way. (HW)

still to come:
1) find out if text is uppercase
2) find out if text is lowercase
3) using (1) and (2) make a *safer* conversion to upper and lowercase.
4) reverse case
5) rot13

walkenbach, formulas, ch 3, names
you can define a name
manage it from name manager
define multiple names at once
name a range
intersection of named ranges
names for literal values
names for calculation
names for relative refs
names for mixed refs
names for calculated refs
scope
CamelCaseThisIsAnExample


INDIRECT
OFFSET

=INDIRECT("A1")

Welcome to cs88, Spring 2010 Semester

Final Makeup

Here is a link to the instructions. Here is a link to the data files.