6 Tips for Teaching Spreadsheet Software to Elementary Students

Share:

6 Tips for Teaching Spreadsheet Software to Elementary Students

Teachers at every school I’ve ever worked have been intimidated when it comes to using spreadsheet software with students.

Even though our math standards have tons of graphing, something about doing it digitally gives people pause. No more!

Let me give you some tips and tricks that will open up this great option of using Microsoft Excel or Google Sheets with your students. It is totally doable!

Give the Task Meaning

Creating charts and graphs is pretty meaningless if they are just some random numbers to calculate. Give students engaging prompts (just like you would with word problems) so that they are invested in the outcome.

6 Tips for Teaching Spreadsheet Software to Elementary Students

It helps if you can make it colorful, too. This image is an example of a first or second grade project for either Excel or Sheets. There are 6 data points and the final graph is a column graph, which students are usually already comfortable creating on paper.

Allow Students to be Self-Paced

6 Tips for Teaching Spreadsheet Software to Elementary Students
Click this image for a free sample
It is a bit more work up front for you, but making a screencast of the project directions is a game changer. Your students can watch the video over and over if needed until they understand exactly what to do.
It isn’t easy to show students where the tiny little icons are when you’re demonstrating whole group. Were they definitely looking at your hand? Will they remember by the time they are at their devices? Probably not.
Having the directions in a video is going to help your students be independent and successful.
6 Tips for Teaching Spreadsheet Software to Elementary Students
I use a software called Screencast-o-matic to make all of my flipped classroom video recordings. I wrote this blog post: The Tools you Need to Flip Your Classroom if you’re interested in a walk-through of my process.
6 Tips for Teaching Spreadsheet Software to Elementary Students

Start with a Template for Your Students

Particularly at the elementary level, students benefit from working through a template. It is less intimidating for them.
It does add a layer to the logistics for you, though, because you have to figure out how to share the template file with them. Here are some suggestions:
It really depends on your setup. There are great tutorials out there for each of these
solutions.
Examples of internet hosting:
  • Google Classroom or other LMS that requires login
  • Private Symbaloo
  • Password protected page on your website
Examples of offline sharing:
  • Using a network shared folder
  • Make a desktop shortcut of the template or folder of the templates
  • Using a program like Lanschool to push the file to student computers
 

Once you’ve shared the template with your students, they work through the steps of the project independently. You can walk around and answer individual questions as they come up.

 

Teach Tech Skills that Translate to Other Programs

One of my favorite things about using multiple software programs (and across operating systems like Microsoft and Google) is that students build a set of skills that they can use anywhere. 
6 Tips for Teaching Spreadsheet Software to Elementary Students

I love to teach keyboard shortcuts because it makes students feel like they are magicians! This set of shortcuts work in Excel but many also work in any program, like Google Docs or any web pages.

Typing, highlighting, and navigating the program are other skills that are being developed simultaneously.

Grade Based on the Whole Process

6 Tips for Teaching Spreadsheet Software to Elementary Students
This is one of the rubrics I use for grading Spreadsheet projects in Excel or Sheets. Look how many skills students are mastering by working in these programs!
Students appreciate that there is freedom of expression with these projects. While the final outcome needs to follow some specific design constraints, there is also room for their creativity to come through.

Follow Similar Formats for K-2 and 3-5

Once your K-2 students master making charts and graphs in excel, they will be ready for more of a challenge. It is totally possible to teach the intermediate spreadsheet skills in the same way.
6 Tips for Teaching Spreadsheet Software to Elementary Students
For grades 3-5 I add about double the data points and then bring in skills like formatting, sorting, calculating, and customizing graphs.
Do you want to try these projects with your students?
Check out these units that already have everything you need (including the videos and templates) prepped for you:
Thanks for reading.
Happy TECHing,
Brittany Washburn

Brittany Washburn

Hi, I'm Brittany. I'm an educator obsessed with technology and passionate about teaching students 21st century skills. I'm so glad you came to visit my website.

Leave a Reply

Hi, I’m Brittany! I’m an educator obsessed with teaching with technology. Check out my free PD for technology teachers!

Click the image to learn more and sign up!

Disclaimer: this content is reader-supported, which means if you click on some of the links that I may earn a commission.

I'd love to connect with you! Find me on Social Media

Most Popular

On Key

Related Posts

How to Integrate Math into your Tech Class

What you need to know is how to integrate math into your lessons in tech class in a way that is accessible to your elementary, middle and high school students! Here are a few recommendations that will let you blend math practice into your tech lessons an authentic way.

Tips for Teaching Tech when it is not your Specialty

So, they asked you to cover the technology classes even though that is definitely not your specialty.  You may be thinking a lot of things in regards to this development, but most likely hovering above all of them is that pesky cloud of feeling unprepared.  So, how are you going to pull this off?

Wait! Your order is almost complete...

Add this offer to your order.

Add Student Created Bulletin Boards

Save 50% by adding this to your order today!

Original Price: $14.00 Discounted Price: $7.00

No thanks, I will pass!

Love tech lesson ideas?

Weekly Lesson Plans

Every week of the school year I send an email with visual lesson plans. Let me know where to send it by filling out the form here:

Weekly Newsletter

* indicates required