| |
Learning Modules Mapped to Curriculum
Excel
Solid Modeling
Biomechanics
Robotics
Excel
|
Module
Excel |
Course |
NCSCOS
Objective |
Content |
Resources |
|
Lesson 3: Introduction to Data Collection
|
|
|
|
|
|
|
Tech Math I |
1.01 Apply various techniques and strategies to
solve problems. |
Data collection
Organize data |
Excel |
|
|
AFM |
1.02 Summarize and
analyze univariate data to solve problems. |
|
|
Biology |
1.02 |
|
|
Chemistry |
1.01 |
|
|
Earth Science |
1.02 |
|
|
Physical Science |
1.02 |
|
|
Physics |
1.02 |
|
|
AP Biology |
1.02 |
|
|
AP Chemistry |
1.01 |
|
|
AP Environmental
Science |
1.02 |
|
|
AP Physics B |
1.02 |
|
|
AP Physics C |
1.07 |
|
Module
Excel |
Course |
NCSCOS
Objective |
Content |
Resources |
|
Lesson 4: Learning about Functions in
Excel
|
|
|
|
|
|
|
Tech Math I |
1.01 Apply various techniques and strategies to
solve problems. |
Data collection
Organize data
Interpret |
Excel |
|
|
AFM |
1.02 Summarize and
analyze univariate data to solve problems. |
|
Module
Excel |
Course |
NCSCOS
Objective |
Content |
Resources |
|
Lesson 5: Writing Formulas: Using
Equations to Calculate Data in Excel |
|
|
|
|
|
|
Tech Math I |
1.01 Apply various techniques and strategies to
solve problems. |
Displaying data |
Excel |
|
|
Biology |
1.02 |
|
|
Chemistry |
1.01 |
|
|
Earth Science |
1.02 |
|
|
Physical Science |
1.02 |
|
|
Physics |
1.02 |
|
|
AP Biology |
1.02 |
|
|
AP Chemistry |
1.01 |
|
|
AP Environmental
Science |
1.02 |
|
|
AP Physics B |
1.02 |
|
|
AP Physics C |
1.07 |
|
Module
Excel |
Course |
NCSCOS
Objective |
Content |
Resources |
|
Lesson 8: Graphing equations using
scatter plots |
|
|
|
|
|
|
Algebra I |
3.03 Create linear models for sets of data to solve
problems. |
Scatterplots
Trend lines |
Excel |
|
|
Algebra II |
2.04 Create and use best-fit mathematical models of linear,
exponential, and quadratic functions to solve
problems involving sets of
data. |
|
|
Tech Math II |
2.03 Create,
interpret, and analyze best-fit models of linear,
exponential, and quadratic functions to solve
problems. |
|
|
Biology |
1.02 |
|
|
Chemistry |
1.01 |
|
|
Earth Science |
1.02 |
|
|
Physical Science |
1.02 |
|
|
Physics |
1.02 |
|
|
AP Biology |
1.02 |
|
|
AP Chemistry |
1.01 |
|
|
AP Environmental
Science |
1.02 |
|
|
AP Physics B |
1.02 |
|
|
AP Physics C |
1.07 |
|
Module
Excel |
Course |
NCSCOS
Objective |
Content |
Resources |
|
Lesson 9: Using Excel to Explore and
Analyze Sequences |
|
|
|
|
|
|
Algebra I |
3.03 Create linear models for sets of data to solve
problems. |
Sequence
Recursion
Converge
Diverge |
Excel |
|
|
AFM |
2.05 Use recursively-defined functions to model and
solve problems. |
|
|
Discrete Math |
3.01 Use recursion to model and solve problems. |
|
Module
Excel |
Course |
NCSCOS
Objective |
Content |
Resources |
|
Lesson 10: Descriptive Analysis of Real
Data Using Range, Mean & Median |
|
|
|
|
|
|
Algebra I |
3.03 Create linear models for sets of data to solve
problems. |
Data collection
Analysis
Predict with data |
Excel |
|
|
Algebra II |
2.04 Create and use best-fit mathematical models of linear,
exponential, and quadratic functions to solve
problems involving sets of
data. |
|
|
Tech Math I |
1.01 Apply various techniques and strategies to
solve problems. |
|
|
Tech Math II |
2.03 Create,
interpret, and analyze best-fit models of linear,
exponential, and quadratic functions to solve
problems. |
|
|
Biology |
1.02 |
|
|
Chemistry |
1.01 |
|
|
Earth Science |
1.02 |
|
|
Physical Science |
1.02 |
|
|
Physics |
1.02 |
|
|
AP Biology |
1.02 |
|
|
AP Chemistry |
1.01 |
|
|
AP Environmental
Science |
1.02 |
|
|
AP Physics B |
1.02 |
|
|
AP Physics C |
1.07 |
Solid
Modeling
|
Module
Solid Modeling |
Course |
NCSCOS
Objective |
Content |
Resources |
|
Lesson 1: Introductory Part Modeling |
|
|
|
|
|
|
Geometry |
1.02 Use length,
area, and volume of geometric figures to solve
problems. Include arc length, area of sectors of
circles; lateral area, surface area, and volume of
three-dimensional figures; and perimeter, area, and
volume of composite figures. |
Volume
Surface Area
x, y, z axis
Center of mass
Symmetry
Revolve region
about the axis |
Solid Works |
|
|
|
2.04 Develop and
apply properties of solids to solve problems. |
|
|
Tech Math I |
2.01 Select and
use appropriate tools to measure two- and
three-dimensional figures; interpret and communicate
results with regard to precision. |
|
|
|
2.03 Use the
length, area, and volume of geometric figures to
solve problems. Include arc length, area of sectors
of circles; lateral area, surface area, and volume
of three-dimensional figures; and perimeter, area,
and volume of composite figures. |
|
|
Calculus |
3.04 Define and
use appropriate integrals in a variety of
applications. |
|
|
Physics |
2.04 |
Module
Solid Modeling |
Course |
NCSCOS
Objective |
Content |
Resources |
|
Lesson 2:
Introductory Assembly Modeling |
|
|
|
|
|
|
Algebra I |
4.01 Use linear
functions or inequalities to model and solve
problems; justify results. |
3-D construction
Problem solving
Solving equations |
Solid Works |
|
|
Tech Math I |
1.01 Apply various techniques and strategies to
solve problems. |
|
|
|
2.03 Use the
length, area, and volume of geometric figures to
solve problems. Include arc length, area of sectors
of circles; lateral area, surface area, and volume
of three-dimensional figures; and perimeter, area,
and volume of composite figures. |
|
Module
Solid Modeling |
Course |
NCSCOS
Objective |
Content |
Resources |
|
Lesson 3:
4-Bar Linkage Assembly |
|
|
|
|
|
|
Algebra I |
4.01
Use linear functions or inequalities to model and
solve problems; justify results. |
Solid
Works
4-Bar
Assembly |
|
|
Physical Science |
2.01,
2.02, 3.04 |
|
|
Physics |
2.02,
2.04, 3.01, 3.02, 3.04, 7.01 |
|
Module
Solid Modeling |
Course |
NCSCOS
Objective |
Content |
Resources |
|
Lesson 4:
4-Bar Linkage Analysis |
|
|
|
|
|
|
AFM |
2.04
Use trigonometric (sine, cosine) functions to model
and solve problems; justify results. |
Trig
ratios
Law
of Sine/Cosines |
Solid
Works
4-Bar
Assembly |
|
|
Pre
Calculus |
2.02
Use trigonometric and inverse trigonometric
functions to model and solve problems; justify
results. |
|
|
Physical Science |
2.01,
2.02, 3.04 |
|
|
Physics |
2.02,
2.04, 3.01, 3.02, 3.04, 7.01 |
|
Module
Solid Modeling |
Course |
NCSCOS
Objective |
Content |
Resources |
|
Lesson 5: Planes in Space |
|
|
|
|
|
|
Algebra I |
4.03
Use systems of linear equations or inequalities in
two variables to model and solve problems. Solve
using tables, graphs, and algebraic properties;
justify results. |
System of equations
Matrices |
Solid
Works |
|
|
Algebra II |
1.04
Operate with matrices to model and solve problems. |
|
|
|
2.10
Use systems of two or more equations or inequalities
to model and solve problems; justify results. Solve
using tables, graphs, matrix operations, and
algebraic properties. |
|
|
Tech
Math II |
2.04
Use systems of equations and inequalities to model
and solve problems using tables, graphs, matrix
operations, and algebraic properties; justify
results. |
|
|
Physical Science |
2.01 |
|
|
|
AP
Physics B |
2.01 |
|
|
Module
Solid Modeling |
Course |
NCSCOS
Objective |
Content |
Resources |
|
Lesson 6: Atomic Packing |
|
|
|
|
|
|
Geometry |
1.02
Use length, area, and volume of geometric figures to
solve problems. Include arc length, area of sectors
of circles; lateral area, surface area, and volume
of three-dimensional figures; and perimeter, area,
and volume of composite figures. |
Volume
Ratios
3-D
Problem solving |
Solid
Works
Jar
of marbles |
|
|
|
2.04
Develop and apply properties of solids to solve
problems. |
|
|
Tech
Math I |
1.01 Apply various techniques and strategies to
solve problems. |
|
|
|
2.03
Use the length, area, and volume of geometric
figures to solve problems. Include arc length, area
of sectors of circles; lateral area, surface area,
and volume of three-dimensional figures; and
perimeter, area, and volume of composite figures. |
|
|
Chemistry |
2.01,
2.02 |
|
|
Earth
Science |
2.01 |
|
|
Physical Science |
2.01,
5.02, 5.03 |
|
|
Physics |
3.01,
3.02, 3.03, 3.04 |
|
|
AP
Chemistry |
3.03 |
|
Module
Solid Modeling |
Course |
NCSCOS
Objective |
Content |
Resources |
|
Lesson 7: 3-D Mapping |
|
|
|
|
|
|
Tech
Math I |
2.01
Select and use appropriate tools to measure two- and
three-dimensional figures; interpret and communicate
results with regard to precision. |
Map
Contour lines
2-D
to 3-D images |
Solid
Works
Map
(optional) |
|
|
|
2.02
Interpret and construct maps and scale drawings to
solve problems. |
|
|
Earth
Science |
2.05 |
|
|
AP
Environmental Science |
2.03 |
|
Module
Solid Modeling |
Course |
NCSCOS
Objective |
Content |
Resources |
|
Lesson 8: Relative Motion |
|
|
|
|
|
|
Pre
Calculus |
1.03
Operate with vectors in two dimensions to model and
solve problems. |
Velocity
Angular velocity
acceleration |
Solid
Works |
|
|
Earth
Science |
6.02,
6.04 |
|
|
Physical Science |
2.02,
2.02 |
|
|
Physics |
2.01,
2.02, 2.04, 3.xx. 4.xx; |
|
|
AP
Environmental Science |
8.01,
8.02 |
Biomechanics
|
Module
Biomechanics |
Course |
NCSCOS
Objective |
Content |
Resources |
|
Coming Down |
|
|
|
|
|
|
Algebra II |
2.04
Create and use best-fit mathematical models of
linear, exponential, and quadratic functions to
solve problems involving sets of data. |
Data
collection
Analysis
Ball
drop
Conservation of energy |
Motion sensor
Ball |
|
|
Tech
Math II |
2.03
Create, interpret, and analyze best-fit models of
linear, exponential, and quadratic functions to
solve problems. |
|
|
AFM |
1.01
Create and use calculator-generated models of
linear, polynomial, exponential, trigonometric,
power, and logarithmic functions of bivariate data
to solve problems. |
|
|
Pre
Calculus |
2.03
For sets of data, create and use
calculator-generated models of linear, polynomial,
exponential, trigonometric, power, logistic, and
logarithmic functions. |
|
|
Physical Science |
2.02,
3.02 |
|
|
Physics |
2.xx,
4.xx, 6.xx |
|
|
AP
Physics B 2.xx |
2.xx |
|
Module
Biomechanics |
Course |
NCSCOS
Objective |
Content |
Resources |
|
Cool Your Newtons |
|
|
|
|
|
|
Algebra II |
2.04 Create and use best-fit mathematical models of linear,
exponential, and quadratic functions to solve
problems involving sets of
data. |
Data
collection
Analysis
Exponential functions
Relative temperature
Newton’s
law of cooling |
Temp
sensor
Ice
|
|
|
Tech
Math II |
2.03
Create, interpret, and analyze best-fit models of
linear, exponential, and quadratic functions to
solve problems. |
|
|
AFM |
1.01
Create and use calculator-generated models of
linear, polynomial, exponential, trigonometric,
power, and logarithmic functions of bivariate data
to solve problems. |
|
|
Pre
Calculus |
2.03
For sets of data, create and use
calculator-generated models of linear, polynomial,
exponential, trigonometric, power, logistic, and
logarithmic functions. |
|
|
Calculus |
2.06
Apply the derivative in graphing and modeling
contexts. |
|
|
|
3.04
Define and use appropriate integrals in a variety of
applications. |
|
|
Physical Science |
3.01,
3.03 |
|
|
Physics |
6.01,
6.02 |
|
|
AP
Environmental Science |
2.01 |
|
|
AP
Physics B |
3.02,
3.03 |
|
Module
Biomechanics |
Course |
NCSCOS
Objective |
Content |
Resources |
|
Flexibility Analysis |
|
|
|
|
|
|
Tech
Math I |
1.01 Apply various techniques and strategies to
solve problems. |
Data
collection
Univariate data Analysis
|
Goniometer |
|
|
AFM |
1.02
Summarize and analyze univariate data to solve
problems. |
|
|
Discrete Math |
2.01
Describe data to solve problems. |
|
|
Physical Science |
2.02,
3.02 |
|
|
|
Physics |
3.xx |
|
|
|
AP
Physics B |
2.05 |
|
|
Module
Biomechanics |
Course |
NCSCOS
Objective |
Content |
Resources |
|
Going Up |
|
|
|
|
|
|
Algebra I |
1.03
Model and solve problems using direct variation. |
Work
Power
Data
collection
Analysis
Angles |
Goniometer
Stairs
|
|
|
Algebra II |
1.05
Model and solve problems using direct, inverse,
combined and joint variation |
|
|
|
2.04
Create and use best-fit mathematical models of
linear, exponential, and quadratic functions to
solve problems involving sets of data. |
|
|
Tech
Math II |
2.03
Create, interpret, and analyze best-fit models of
linear, exponential, and quadratic functions to
solve problems. |
|
|
AFM |
1.01
Create and use calculator-generated models of
linear, polynomial, exponential, trigonometric,
power, and logarithmic functions of bivariate data
to solve problems. |
|
|
Pre
Calculus |
2.03
For sets of data, create and use
calculator-generated models of linear, polynomial,
exponential, trigonometric, power, logistic, and
logarithmic functions. |
|
|
Physical Science |
2.02,
3.01, 3.02 |
|
|
Physics |
2.xx,
4.xx, 6.03, 6.04 |
|
|
AP
Physics B |
2.xx |
|
Module
Biomechanics |
Course |
NCSCOS
Objective |
Content |
Resources |
|
Muscle Fatigue |
|
|
|
|
|
|
Algebra I |
3.03 Create linear models for sets of data to solve
problems. |
Data
collection
Analysis
Interpret the graph |
Dynamometer
Ice
water |
|
|
Tech
Math II |
2.03
Create, interpret, and analyze best-fit models of
linear, exponential, and quadratic functions to
solve problems. |
|
|
Biology |
2.xx |
|
|
Physical Science |
3.xx |
|
|
Physics |
2.xx,
6.xx |
|
|
AP
Physics B |
2.02,
2.03, 3.02 |
|
Module
Biomechanics |
Course |
NCSCOS
Objective |
Content |
Resources |
|
Where Ya Going |
|
|
|
|
|
|
Pre
Calculus |
1.03
Operate with vectors in two dimensions to model and
solve problems. |
Vectors
Velocity
Displacement
Speed |
Meter
stick
Stopwatch
|
|
|
Physics |
2.xx,
3.03 |
|
Module
Biomechanics |
Course |
NCSCOS
Objective |
Content |
Resources |
|
Polymer Power |
|
|
|
|
|
|
Algebra II |
2.04
Create and use best-fit mathematical models of
linear, exponential, and quadratic functions to
solve problems involving sets of data. |
Data
collection
Analysis
Trend
lines |
Boric
acid
Warm
water
White
glue
Ruler
Ziploc bags
|
|
|
Tech
Math II |
2.03
Create, interpret, and analyze best-fit models of
linear, exponential, and quadratic functions to
solve problems. |
|
|
AFM |
1.01
Create and use calculator-generated models of
linear, polynomial, exponential, trigonometric,
power, and logarithmic functions of bivariate data
to solve problems. |
|
|
Pre
Calculus |
2.03
For sets of data, create and use
calculator-generated models of linear, polynomial,
exponential, trigonometric, power, logistic, and
logarithmic functions. |
|
|
Chemistry |
2.03,
2.04, 2.07 |
|
|
AP
Chemistry |
2.xx |
|
Module
Biomechanics |
Course |
NCSCOS
Objective |
Content |
Resources |
|
Got Gait? |
|
|
|
|
|
|
Algebra I |
3.03 Create linear models for sets of data to solve
problems. |
Slope
as velocity
Interpret graph in context |
Large
roll of black paper
Baby
powder
Meter
stick
Stopwatch |
|
|
Physical Science |
2.01 |
|
|
Physics |
2.xx |
|
Module
Biomechanics |
Course |
NCSCOS
Objective |
Content |
Resources |
|
Gait Variety Pack |
|
|
|
|
|
|
Calculus |
2.06
Apply the derivative in graphing and modeling
contexts |
Linear velocity
Angular velocity
Application of derivative |
Goniometer
Meter
stick
Stopwatch
|
|
|
Physical Science |
2.xx |
|
|
Physics |
2.xx,
3.04 |
|
|
AP
Physics B |
2.01 |
|
Module
Biomechanics |
Course |
NCSCOS
Objective |
Content |
Resources |
|
Error and Variability in Muscle Force I |
|
|
|
|
|
|
AFM
|
1.02 Summarize and analyze univariate data to solve problems.
|
Data
collection
Analysis
Standard deviation
Coefficient of variation |
Dynamometer
|
|
|
Discrete Math |
2.01
Describe data to solve problems. |
|
|
AP
Stats |
1.01
Summarize distributions of univariate data by
determining and interpreting measures of center,
spread, position, boxplots, and effects of changing
units on summary measures. |
|
|
Physical Science |
2.xx,
3.02 |
|
|
Physics |
6.03 |
|
Module
Biomechanics |
Course |
NCSCOS
Objective |
Content |
Resources |
|
Error and Variability in Muscle Force II |
|
|
|
|
|
|
Tech
Math II |
2.03
Create, interpret, and analyze best-fit models of
linear, exponential, and quadratic functions to
solve problems. |
Data
collection
Analysis
Interpret a graph
Riemann sum |
Force
platform |
|
|
AFM |
1.01 Create and
use calculator-generated models of linear,
polynomial, exponential, trigonometric, power, and
logarithmic functions of bivariate data to solve
problems. |
|
|
Pre Calculus |
2.03 For sets of
data, create and use calculator-generated models of
linear, polynomial, exponential, trigonometric,
power, logistic, and logarithmic functions. |
|
|
Calculus |
3.01 Explore and
interpret the concept of the definite integral. |
|
|
Physical science |
2.xx, 3.02 |
|
|
Physics |
2.xx, 4,02, 4.03 |
Robotics
|
Module
Robotics |
Course
|
NCSCOS
Objective |
Content
|
Resources
|
|
Day 1:
Microcontrollers and robotics |
|
|
|
|
|
|
Physical Science |
1.04 |
|
|
|
|
|
2.01 |
|
|
|
|
|
2.02 |
|
|
|
|
|
3.01 |
|
|
|
|
|
3.02 |
|
|
|
|
|
3.03 |
|
|
|
|
|
3.04 |
|
|
|
|
|
4.01 |
|
|
|
|
|
4.02 |
|
|
|
|
|
4.03 |
|
|
|
|
Physics |
2.01 |
|
|
|
|
|
2.02 |
|
|
|
|
|
2.03 |
|
|
|
|
|
2.04 |
|
|
|
|
|
8.01 |
|
|
|
|
|
8.02 |
|
|
|
|
|
8.03 |
|
|
|
|
|
8.04 |
|
|
|
Module
Robotics |
Course
|
NCSCOS
Objective |
Content
|
Resources
|
|
Day 2:
Robot Construction |
|
|
|
|
|
|
Physical Science |
2.01 |
|
|
|
|
|
2.02 |
|
|
|
|
Physics |
2.01 |
|
|
|
|
|
2.02 |
|
|
|
|
|
2.03 |
|
|
|
|
|
2.04 |
|
|
|
|
|
3.04 |
|
|
|
|
|
5.02 |
|
|
|
|
|
8.01 |
|
|
|
|
|
8.02 |
|
|
|
|
|
8.03 |
|
|
|
|
|
8.04 |
|
|
Module
Robotics
|
Course
|
NCSCOS
Objective |
Content
|
Resources
|
|
Day 3:
Robot Programming |
|
|
|
|
|
|
Physical Science |
1.01 |
|
|
|
|
|
1.02 |
|
|
|
|
|
1.03 |
|
|
|
|
|
1.04 |
|
|
|
|
|
2.01 |
|
|
|
|
|
2.02 |
|
|
|
|
|
3.02 |
|
|
|
|
|
3.04 |
|
|
|
|
|
4.01 |
|
|
|
|
|
4.02 |
|
|
|
|
|
4.03 |
|
|
|
|
Physics |
1.01 |
|
|
|
|
|
1.02 |
|
|
|
|
|
1.03 |
|
|
|
|
|
1.04 |
|
|
|
|
|
2.01 |
|
|
|
|
|
2.03 |
|
|
|
|
|
2.04 |
|
|
|
|
|
3.04 |
|
|
|
|
|
4.06 |
|
|
|
|
|
5.02 |
|
|
|
|
|
5.03 |
|
