Standard 5 Math and Computational Thinking

Using Math and Computational Thinking

In science we want to name things and observe them. Qualitative measurements are great, as we begin our observations. We also want to find out how the materials we explore differ in quantities ( numbers). We use data tables and graphs to compare these numbers.

student sample mastery 4 Disease Data Analys - 4562310.1 Analyzing Data and planning space - Column chart 1

Proficient Computer Tables (These tables show all the pieces needed to be able to make great graphs). Notice the formula is coded correctly. If the student hi-lights this data, they will be able develop a graph.

Mastery Computer Generated Graph ( the chart on the right in red)

zyra type of cell graph

Compare the blue graph with the red graph. The red graph is a mastery example because the student hi-lighted the headers when they inserted the chart. The headers ( when hi-lighted) will auto-populate to label the axis. This only work when you use a two column set up.

Graphs that did not yet reach mastery because they are missing key parts. See below

This graph is based on a table with three columns. When you build more than two columns into your data table you lose the computer auto generating you axis labels. Look at the number 0-10 on the Y axis. The word "gram" is missing.

Watch this video if you need to learn how to insert a chart

missing a title

The student might have forgot to hi-light the headers for this graph before they inserted the chart.

missing a formula

There is no math thinking here yet

units below the headers

The student included "mg" below the green header. Any text that appears in the cells will "clog" the chart and not allow the chart to appear.

Data Tables below are missing important parts like headers. Watch THIS VIDEO to understand why

horizontal headers

This is one of the most common mistakes. It is easy to think that you are setting up headers when you place your measurable quantity in row two. This could work if you inserted a new column like the green columns with a header of "food" on the graph on the right.

manually entering in axis labels

This student started moving to use more than one column, and they were able to get the axis labeled by manually inserting the names for each axis. If you need help with this see HOW to manually add labels to google charts

Formula snafu

This work has a formula but it got places in cell B8 and will not show up as a "skyscraper" or bar on the bar graph. The student also wasn't familiar with wrapping text so "difference between and peanut and beef showed up on two different cells and were labeling two ghost bars.

ghost bar

You've reached mastery and want to challenge yourself. Try a sparkline or converting time to total minutes, AND merging cells together!

Report abuse