Coding in the Classroom: Google SheetsSphereo Units of Study: 1 Integer.2 Algebra.3 Equations.4 Linear.5 Analytic Geometry.6 Data.7 Geometry.8 Finanical Literacy

This course enables students to consolidate, and continue to develop, an understanding of mathematical concepts related to number sense and operations, algebra, measurement, geometry, data, probability and financial literacy. Students will use mathematical processes, mathematical modelling, and coding to make sense of the mathematics they are learning and to apply their understanding to culturally responsive and relevant real-world situations. Students will continue to enhance their mathematical reasoning skills, including proportional reasoning, spatial reasoning, and algebraic reasoning, as they solve problems and communicate their thinking.

Credit Value 1.0, Prerequisite: None

Opening Week Activitiesup

Lesson Hints Solution Check Your Understanding Video
Bridge Problem Hint 1, Hint 2, Hint 3 Solution   From Ted Ed: https://www.youtube.com/watch?v=7yDmGnA8Hw0
Gold Bar Problem        
         
         
         

 

Story-Tellingup

Lesson Video Activities Check Your Understanding Other Resources
Wheat on a Chessboard (Exponents, Exponental Growth)        
Circumference of Earth (Parallel Lines, Circle formulas)        
         
         
         

 

Coding in the ClassrooM

Google Sheetsup

Lesson Video Activities Homework Questions An old version from Excel
Fill Down, *, +, -, \ Multiplication Table
Fill Down (Tip Calculator)
Multiplication Table
Geometry Formulas
Fill Down Practice
  Student Work
Average, Sum, Min, Max Formula Intro Unit 6 Data, 2A, 2B   Student Work
Box and Whisker, Quartiles Candlestick graph Unit 6 Data, 2C, 2D    
Scatterplots, y=mx+b Slope, Yint, Line of Best Fit Unit 6 Data, 3A, 3D   Video, Student Work, Another, Still another
Correlation Coefficient (r & r^2) r, r^2, adding to graph      
Area       Worksheet
Own functions + Variables       Assignment, Student Work, Adding a Dialog Box
Vlookup       Video 1, Video 2, Student Work
Histograms       Video, Student Work, Review
Compounded Interest       Mortgage Calculator, Assignment
Law of Large Numbers       Student Work, Assignment
Pivot Table       Student Work, Assignment
And, Or, Not       Student Work
Ifs       Student Work
SumIf, CountIf       Student Work
Venn Diagrams       Student Work, Review
Pie Charts       Review
Pictographs       Assignment, Lesson

 

Spheros up

Lesson Video Activities Check Your Understanding Other Resources
Introduction   Intro Grid Intro Form  
Loops   Loops Grid    
Math, Variables   Math Variable Grid Variables Form
Math Form
 
Shapes   Shapes Grid    
Inequalities, Ifs        

 

Units of Study

Integer, Number Sense and Operations up

  Lesson Curriculum Activities Check Your Understanding Questions Other Resources
           

 

Algebra up

  Lesson Curriculum Activities Check Your Understanding Questions Other Resources
           

 

Equationsup

  Lesson Curriculum Activities Check Your Understanding Questions Other Resources
           

 

Linear and Non-Linearup

  Lesson Curriculum Activities Check Your Understanding Questions Other Resources
           

 

Analytic Geometry up

  Lesson Curriculum Activities Check Your Understanding Questions Other Resources
           

 

Data up

  Lesson Curriculum In-Class Tasks Check Your Understanding Questions Other Resources
1

Introduction to Statistics
PPDAC - Mathematical Process

  • Problem (Hypothesis)
  • Plan (How to collect data)
  • Data
  • Analysis (use math)
  • Conclusions

D2.1 [Application of Mathematical Modelling] describe the value of mathematical modelling and how it is used in real life to inform decisions

A2. [Mathematical Thinking and Making Connections] make connections between mathematics and various knowledge systems, their lived experiences, and various real-life applications of mathematics, including careers

1A - Scramble Sentences
1B - Find the Variables
1C - IAT and Conclusions

1 Data for In-Class Tasks

1 Intro to Statistics Questions

 
2

Data Phase: 1-Variable (Descriptive)

  • Mean, Median, Mode
  • Quartiles
  • Box Plots
  • (by hand and using Google sheets)

D1.2 [Representation and Analysis of Data] represent and statistically analyse data from a real-life situation involving a single variable in various ways, including the use of quartile values and box plots

C2.1 [Coding] use coding to demonstrate an understanding of algebraic concepts including variables, parameters, equations, and inequalities

2A - What Mark Should they get? (Goggle sheets)
2B - The Martian Thermometer
2C & 2D - Box and Wisker (Goggle sheets)

2 Google Sheet for In-Class Tasks

Box & Whisker
Mean, Median, Mode
2A Formula Demo Video
2D Box and Whisker Demo Video
3

Data Phase - 2 Variable (Causal)

  • Scatter Plots (by hand and using the Google sheets)
  • Independent and dependent variables
  • Correlation Coefficient & Its Meaning
D1.3 [Representation and Analysis of Data] create a scatter plot to represent the relationship between two variables, determine the correlation between these variables by testing different regression models using technology, and use a model to make predictions when appropriate

3A - Movie Choices
3B - Google sheets
3C - Which is the most important factor?

Final Summary

3 Correlation Coefficient 3B Line of Best Fit, Slope,
3B r, r^2
4 Line of Best Fit
Interpolation & Extrapolation
Data Mining, Large Data Sets, Big Data, ABR issues associated with them.

D2.1 [Application of Mathematical Modelling] describe the value of mathematical modelling and how it is used in real life to inform decisions

D1.1 [Data] identify a current context involving a large amount of data, and describe potential implications and consequences of its collection, storage, representation, and use

4A
4B
4C Data Mining
   
5 Curves of Best Fit
(Also in Google sheets)
C3.1 [Application of Linear and Non-Linear Relations] compare the shapes of graphs of linear and non-linear relations to describe their rates of change, to make connections to growing and shrinking patterns, and to make predictions      
6 Summative Task - Experiments,
Google Sheets Assessment

D2.2 [Process of Mathematical Modelling] identify a question of interest requiring the collection and analysis of data, and identify the information needed to answer the question

D2.3 [Process of Mathematical Modelling] create a plan to collect the necessary data on the question of interest from an appropriate source, identify assumptions, identify what may vary and what may remain the same in the situation, and then carry out the plan

D2.4 [Process of Mathematical Modelling] determine ways to display and analyse the data in order to create a mathematical model to answer the original question of interest, taking into account the nature of the data, the context, and the assumptions made

D2.5 [Process of Mathematical Modelling] report how the model can be used to answer the question of interest, how well the model fits the context, potential limitations of the model, and what predictions can be made based on the model

6 Crawford Lake Outline
6 Crawford Lake Raw Data
   

 

Geometryup

  Lesson Curriculum Activities Check Your Understanding Questions Other Resources
           

 

Financial Literacyup

  Lesson Curriculum Activities Check Your Understanding Questions Other Resources