New Spreadsheets 101
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQ
1
a
2
Spreadsheet Math 101This Lab introduces you to Spreadsheets and Functional Thinking.
3
4
5
6
7
8
ParametersFunctionGraph
9
You will build and use Arithmetic and Geometric sequences and apply them to finance including interest and present value. These are the big ideas.Initial Inputi₀-6.0InputOutput
10
Increment△i0.5IndexValue
11
Initial Outputv₀0.0-6.00.0
12
Parameters -- Make spreadsheets dynamic. What if you change the value of d from 3 to a negative number? Try it. How did the Function Table and Graph respond?
Common Difference
d8.0-5.58.0
13
Common Ratio-5.016.0
14
-4.524.0
15
Functions -- Have an input, an output, and a rule that changes the input to the output. To see the rule doubleclick on an output cell. What symbol does every rule start with?-4.032.0
16
-3.540.0
17
-3.048.0
18
Graphs -- You can show your function as a graph. Change d, what happens to the graph? What happens to the outputs in the function table?-2.556.0
19
-2.064.0
20
-1.572.0
21
Debug -- You can't break a spreadsheet program. If you make a mistake use Undo, or reload the spreadsheet. But you can make mistakes. Be sure to look at the values in the tables and ask, "Is this what I expected? Have I made a mistake? Does the graph look right."-1.080.0
22
23
24
25
Cut, Copy & Paste -- You can use copy and paste to fill cells. Copy the last row of the Function table and past it into the next 15 rows. What did the graph do?
26
27
28
29
WHAT IF…?
30
31
What if... questions should get you experimenting, thinking out-of-the-box. What if you changed some of the other parameters? Do you have a conjecture about what will happen? Play with changing them. Make note of your observations.
32
33
34
Now click on the tab below (1. Arithmetic Sequence) to make spreadsheets your tool!
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
What If Math - Sustainablearning © 2019
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...