1. spreadsheet = rows/columns of cells
2. cells contain values or formulas
3. formula as right hand side of a statement of the form location = expression
4. conditional formatting (1=dark, 0=light)
5. changing column width, row height
6. a cell range is denoted by upperLeftROWCOL:lowerRightROWCOL
7. start with a random sequence of eight 1s and 0s in cells M1:T1, “the seed”
8. we will fill in the next row (L2:U2); each cell based on its three “parents”
9. fill in B2:D8 with 000 to 111; these are all the possible parent patterns
10. in cells E2:E8, again, a random sequence of 1s or 0s
11. the information in A2:E8 is “the rules”
12. focus on L2; it’s parents are K1:M1; find the pattern in the rules and fill in L2 (treat blanks as zero)
13. repeat for M2:U2
14. but this is tedious; in A2:A8 type 0,…7 to number the rules
15. compute rule number for each cell we want to color in row three
16. ruleNumber = leftParent*4+centerParent*2+rightParent
17. autofill row three cells
18. VLOOKUP(ruleNumber, ruleRange, returnValueInColumn)
19. autofill row three cells
20. auto fill next row
21. try changing the rules
22. try changing the seed
1. binary
2. looking things up in an array
3. expressions
4. stepwise refinement
5. truth table
6. iteration/autofill
7. if-then-else
8. flow chart for if statements
9. conditional formatting

page revision: 0, last edited: 03 Aug 2018 00:15