SCI 1: Lead a Scientific Investigation
1.6 I can test the prediction
1.7 I can iterate using the results
SCI 2: Analyze and Interpret Data
2.1 Make meaning of data collected
2.2 Represent data
Step 1: Make a Copy of the Generic Continuous Data Analysis Guide.
Step 2: Watch the videos about how to make a graph in Excel or Google Sheets
Step 3: Show your science teacher a draft of your graph to ensure you are headed in the right direction. Revise as needed.
Step 4: Complete all the sections of the Data Analysis Guide
Step 5: Copy information into your lab template under the Data Analysis section and finish that section. Take your information from the data analysis doc and add it to the Data Analysis portion of your lab template and put your graph/table in it, or create a separate document for those things. Go talk to your science teacher again.
Step 6: Submit your lab template AND your Data Analysis Worksheet to Slate.
How to Graph using Google Sheets
Necessary parts of a Data Table
Explanation of Outliers
An outlier is a data point that differs significantly from other observations in your data set. If you can identify a pattern, is there a point or two that does not follow that pattern? It may be an outlier. These can be caused by several things, but most often its bad data caused by poor data collection, or failure to control all the controlled variables during your experiment. You can see outliers in the chart above, and below.
Your Task
Important components of all graphs:
Chart Title - keep it simple
Axis titles (with units in parenthesis)
Axis scale (the numbers)
Data points
Trendline/fit line
Equation (Optional)
R2 value
Legend or Key (optional, and should be on the bottom or right of the graph.)
Step 1: Open your copy of the lab template and complete section 1.7 Iterate Results.
Step 2: Complete this section using the information from your experiences and your data analysis.
Step 3: Submit the Lab template to Slate.