Skip to main content

Home/ Digital Resource Grant/ Group items tagged excel

Rss Feed Group items tagged

Jennifer Armstrong

Excel Activity - Circle Graphs - 0 views

  •  
    A generic 8 item pie chart can be dynamically altered with custom data and labels.
Jennifer Armstrong

Excel Activity - Pi - 0 views

  •  
    As students report measurements on circumference and diameter of objects, the spreadsheet calculates their ratio and averages them together to approximate pi.
Jennifer Armstrong

Excel Activity - Comparing Data - 0 views

  •  
    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.
Jennifer Armstrong

Excel Activity - Comparing Graphs - 0 views

  •  
    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.
Jennifer Armstrong

Excel Activity - Misleading Graphs - 0 views

  •  
    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.
Jennifer Armstrong

Excel Activity - Mystery Functions - 0 views

  •  
    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.
Jennifer Armstrong

Excel Activity - Visualizing Fractions - 0 views

  •  
    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.
Jennifer Armstrong

Excel Activity - Bar Graph - 0 views

  •  
    A generic 8 item bar graph can be dynamically altered with custom data and labels.
Jennifer Armstrong

Excel Activity - Scatterplots - 0 views

  •  
    As the user enters ordered pairs, the spreadsheet graphs a scatterplot, creates a line of best fit, and displays its equation (in linear or polynomial form).
Jennifer Armstrong

Excel Activity - Slope - 0 views

  •  
    Students learn about slope by experimenting with different values for "m" in the slope-intercept equation, then looking for patterns, relationships, and generalizations.
Jennifer Armstrong

Excel Activity - Effects of Parentheses - 0 views

  •  
    The user inputs a mathematical expression, and then alters it with parentheses to see how many different answers can be generated. Great for order of operations.
1 - 14 of 14
Showing 20 items per page