Assessment
Concord Consortium

Broken Spreadsheet I

For Students 8th - 11th Standards
There is power in spreadsheet formulas and learners use this power to model quadratic data. Given a scatterplot of a parabola, pupils create formulas in a spreadsheet to populate the data. The formulas they use lead to an understanding...
Lesson Plan
1
1
EngageNY

More on Modeling Relationships with a Line

For Teachers 9th - 10th Standards
How do you create a residual plot? Work as a class and in small groups through the activity in order to learn how to build a residual plot. The activity builds upon previous learning on calculating residuals and serves as a...
Assessment
Concord Consortium

Broken Spreadsheet II

For Students 11th - 12th Standards
Work in reverse with the product becoming the given. Using a spreadsheet image of the graph of a trigonometric function, young scholars investigate methods of creating spreadsheet data that results in the given graph. The catch? The data...
Assessment
Concord Consortium

Boards IV

For Students 7th - 9th Standards
Build a connection between algebraic sequences and spreadsheets. Learners examine a specific folding pattern and convert the pattern into a spreadsheet. The goal of the spreadsheet is to produce a sequence of a specific pattern modeled...
Assessment
Concord Consortium

Boards III

For Students 7th - 9th Standards
Learn to visualize mathematical patterns as a folded pattern. Beginning with a visual display, the task encourages pupils to view sequences as a folded table. The pattern of the table then becomes a formula in a spreadsheet that...
Assessment
Noyce Foundation

Ducklings

For Teachers 6th - 7th Standards
The class gets their mean and median all in a row with an assessment task that uses a population of ducklings to work with data displays and measures of central tendency. Pupils create a frequency chart and calculate the mean and median....
Assessment
Concord Consortium

Boards II

For Students 7th - 9th Standards
Build spreadsheet skills while investigating decimal multiplication. An open-ended task asks learners to edit a spreadsheet to create a multiplication table for decimals. Provided with a specific interval, pupils create formulas...
Assessment
1
1
California Education Partners

T Shirts

For Students 7th Standards
Which deal is best? Learners determine which of two companies has the best deal for a particular number of shirts. They begin by creating a table and equations containing each company's pricing structure....
Assessment
Inside Mathematics

Graphs (2006)

For Teachers 9th - 12th Standards
When told to describe a line, do your pupils list its color, length, and which side is high or low? Use a learning exercise that engages scholars to properly label line graphs. It then requests two applied reasoning answers.
Assessment
Concord Consortium

Boards I

For Students 7th - 9th Standards
Learners create patterns in a table to mimic the function of an electronic spreadsheet. The result is a table that creates an addition table for decimals in intervals of one-tenth. While creating the pattern, pupils must thoroughly...
Assessment
Inside Mathematics

Rugs

For Teachers 8th Standards
The class braids irrational numbers, Pythagoras, and perimeter together. The mini-assessment requires scholars to use irrational numbers and the Pythagorean Theorem to find perimeters of rugs. The rugs are rectangular, triangular,...
Assessment
Inside Mathematics

Aaron's Designs

For Teachers 8th Standards
Working with transformations allows the class to take a turn for the better. The short assessment has class members perform transformations on the coordinate plane. The translations, reflections, and rotations create pattern designs on...
Assessment
Houghton Mifflin Harcourt

Simple and Compound Interest

For Students 7th - 12th Standards
Your learners will get lots of practice calculating simple and compound interest by the end of this lesson. Simple explanations and examples lead learners through the concepts and steps of calculating simple and compound interest...