LEARN NC

K–12 teaching and learning · from the UNC School of Education

Additional related resources

We’re in the process of aligning our content for students to the Standard Course of Study. As we do, you’ll find it here.

General resources

Aligned lesson plans

Spreadsheet formulas
This lesson will provide practice using formulas, print options, functions, and adjusting column widths.
Format: lesson plan (grade 6–8 Computer/Technology Skills and Information Skills)
By DPI Integration Strategies.
Planets' relative gravity spreadsheet
The students use online resources to find information about the eight planets in our solar system. Then, using the relative gravity of each planet, they will create a spreadsheet to calculate what the weight of an average man and woman (possibly their own weight or the weight of other objects) would be on each of the planets.
Format: lesson plan (grade 6 Mathematics and Science)
By Susan Blevins.
Holiday shopper
This activity uses a prepared spreadsheet and the grocery sales paper from the newspaper to figure the cost of a holiday meal for a certain number of people.
Format: lesson plan (grade 6–7 Computer/Technology Skills and Information Skills)
By Stephanie Hurley.
ACC basketball
The students will use ACC basketball statistics to practice the process of converting fractions to decimals then to percents and will learn how to create and edit a spreadsheet. They will then use this spreadsheet to analyze their data. This unit is done during the basketball season.
Format: lesson plan (grade 6–8 Information Skills and Mathematics)
By Susan Dougherty.