1. Bar_Graph_8.xls
A generic 8 item
bar graph that can be dynamically altered with custom data and labels.
2.
Comparing_Data.xls
The student enters data and then the spreadsheet generates several
measures of that data such as mean, median, mode, quartiles, and range,
which the user can investigate and compare.
3.
Comparing_Graphs.xls
Three different sets of data (earnings, votes, heights) are shown with
three different types of graphs (line, bar, circle). The student is to
compare the different graphs to determine which is the best
representation.
4.
Misleading_Graphs.xls
Two different bar graphs are made from the same survey of favorite
foods. The students need to determine which graph is more fair and why,
by studying the graphs and altering the data.
5.
Multiples_Generator.xls
The user enters in up to three numbers and the spreadsheet generates the
first 50 multiples. Great for exploring LCM.
6.
Mystery_Functions.xls
With the answers available (right click to save, left click to open)
Mystery_Functions_Hidden.xls with the answer columns hidden (right
click to save, left click to open
*There are 20 different mystery formulas in this spreadsheet. For each
one the student enters several numbers for the "Input" and examines what
comes out for the "Result", trying to determine each function by looking
for patterns.
7.
Visualizing_Fractions.xls
As the user enters values for the numerator and denominator of a
fraction, a circle graph is generated to show a visual representation of
the fraction. |
