What’s the Pattern?
Mateo's grade changes from 84 in Trimester 1 to 60 in Trimester 3. What is his change?
-24 points
Which Google Sheets function calculates the average of several values?
AVERAGE()
Which chart is usually best for showing change over time?
Line chart
As study hours increase, grades also generally increase. What type of relationship does this suggest?
Positive relationship
Which is stronger?
A. Emma improved a lot.
B. Emma's grade increased from 40 to 82, a gain of 42 points.
B. Emma's grade increased from 40 to 82, a gain of 42 points.
A student's scores are 88, 87, and 88. How would you describe the trend?
Stable / mostly stable
Which Google Sheets function ranks cells starting at 1?
RANK()
Which chart is useful for comparing categories such as sales by region or grades by student?
Bar/Column chart
As temperature increases, hot chocolate sales decrease. What type of relationship does this suggest?
Negative relationship
A class average increases from 72 to 81. How much did the average increase by?
Increased by 9 points
A student's grades are 70, 78, and 86 over three trimesters. What trend is happening?
Increasing trend
Which function adds all the values in a range?
SUM()
Which chart should we use to investigate whether two numerical variables may be related?
Scatter plot
A scatter plot has points spread everywhere with no obvious direction. What does this suggest?
No clear relationship
Complete the three parts of a strong data statement:
Claim + ______ + Explanation
Evidence
Student A has the highest final grade, but Student B has the greatest improvement. Can both statements be correct?
Yes, because final grade and improvement measure different things.
Which function can tell us the highest value in a dataset?
MAX()
You want to compare Study Hours and Final Grade. Which variable would normally go on the X-axis?
Study Hours
Most students who study more score higher, but one student studies a lot and receives a very low score. What should we do with that point?
It should be investigated why it is different, but it does not affect the results.
Why should a conclusion include numbers from the dataset?
Because numbers provide evidence to support the claim.
Emma's grades are 40, 61, and 82. Describe the trend and calculate her total change.
Increasing trend with a +42 point change
What does this formula do?
=IF(D2>B2,"Increasing",IF(D2<B2,"Decreasing","Stable"))
It compares the starting and final values and labels the result Increasing, Decreasing, or Stable.
A student creates a pie chart to show grades changing over three trimesters. Why might another chart be better?
A line chart is better because the data represents change over time.
A scatter plot shows that students who study more often have higher grades. Can we say studying more definitely caused the higher grades?
No, the data may show a relationship, but it does not prove causation.
Why is this statement weak?
“The graph looks better.”
Because it does not explain what changed or use numerical evidence.