Popular Spreadsheet Lesson Plans for Grades 3-5

spreadsheet lesson plans

TechnoKids has spreadsheet lesson plans for Grades 3-5. These are a welcome addition to school curriculum. Not only because they are project-based, but also because they include helpful resources for classroom, digital literacy, and STEM teachers.

The TechnoKids projects, apply a problem-solving model. By completing the assignments, students learn data analysis techniques. As well, they develop critical thinking skills. These help learners to make informed decisions.

As a bonus, the spreadsheet lessons come in multiple versions. Every TechnoKids project has instructions for both Google Sheets and Excel. To start teaching, just pick the version you want from the TechnoKids library. It is that simple!

Integrate Spreadsheets into Curriculum

How can you include the TechnoKids projects in your school program? This depends on where you teach. Every school administration has different requirements.

However for the most part, spreadsheet learning objectives can be found in one of two places. The first, is the Mathematics curriculum. The second is a Technology Standards document.

Mathematics and Spreadsheet Learning Objectives

In general, most Mathematics curriculum includes expectations that are achievable using spreadsheets. Within these documents, the learning objectives are often in the financial literacy or data literacy strands. These publications typically recommend the use of spreadsheets as a tool for learning. For this reason, TechnoKids projects can integrate into Math instruction.

Spreadsheets in Computer Science or Digital Literacy Classes

Of course, the TechnoKids spreadsheet lessons can also be part of a specialty class. For example, it might be a ICT, STEM or computer science course. Often, these learning objectives are in a Information and Technology Standards document.

If your school does not have technology standards you use the ISTE standards as a guide. Or, you can refer to the Computer Science Teachers Association (CSTA) website. This organization provides a core set of computer science learning objectives.

In Grades 3-5 the CSTA Data & Analysis learning objectives that relate to spreadsheets are:

  • 1B-DA-06 – Organize and present collected data visually to highlight relationships and support a claim.
  • 1B-DA-07 – Use data to highlight or propose cause-and-effect relationships, predict outcomes, or communicate an idea.

Spreadsheet Lesson Plans for Grades 3-5

Undoubtedly, teaching spreadsheets to children should be fun. It is important that the lessons include a problem-solving scenario children can understand. This leads me to the two TechnoKids projects we recommend for Grades 3-5 students. These are TechnoCandy and TechnoSales.

Both curriculum units include spreadsheet lesson plans. As well, they contain valuable instructional materials. Each project comes with a teacher guide, student worksheets, templates, example files, and quizzes. In addition, if you want to teach Grades 6-8 you can! The extension activities are ideal for older students.

TechnoCandy

In TechnoCandy, the goal is to boost candy sales for a make-believe company. To start, students survey color preferences. Next, they investigate a the contents of a popular candy. To develop a solution, they compare the findings. Afterwards, they write a report explaining how to make the candy number one again.

technocandy
Do students prefer blue, red, or green candies? What colors are inside the candy package? Find out! Then, develop a turnaround plan for a candy company.

TechnoSales

In TechnoSales, students plan a bake sale. To begin, they survey dessert and flavor preferences. Next, they analyze past fundraiser data. This information helps to set a financial goal and pricing. Afterwards, students write a report. They explain how to make the event a success.

technosales
What desserts do students prefer? Are there differences between boys and girls? How many dessert items do you need? Find out! Then, make a plan for the bake sale.

Christa Love

Christa Love, Curriculum Developer & Teacher ~ I am passionate about blending technology into curriculum. Whether it is programming, video production, graphic design, or digital citizenship, I am interested in how apps and tools can be used to enhance learning. Throughout the years I have designed many TechnoKids technology projects. My favorite part of curriculum development is field-testing the ideas to determine the activities that work best in real classrooms. I write about what I have learned that can save teachers time in their own curriculum planning.

You may also like...