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.
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.
Coastal weather issues: Planning for a hurricane
The unit is designed for seventh grade students who have been studying Earth and its atmosphere. In this sequence, students are faced with the realistic issue of personal and social decision-making when planning for hurricane strikes, which includes classification, tracking, and monitoring hurricanes, as well as planning for evacuations. The inquiry-based approach involves a WebQuest in which the learner will assume the role of an emergency management team member who must create a preparation plan for the community.
Format: lesson plan (grade 7 Computer/Technology Skills, Information Skills, and Science)
By Karen Greene.
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.