Jul 25 2023
Share this post
Although there are many educational tools out there, Microsoft Office is still a staple in the classroom.
Excel charts, for instance, can provide a visual impact, making it easier for students to remember lesson material, especially when you’re teaching a class virtually.
Looking for ideas? We cover a few different types of charts you can create in Excel to help you with your lessons online.
Below are some basic charts in Excel that you can use creatively in your virtual lessons. You can also check out all the available chart types in Office if you’re looking for something different.
Anchor charts are a powerful learning tool that helps teachers keep track of the lesson and help students remember the most important things on a certain topic.
They’re usually printed out and displayed in the classroom for future revision. However, a digital SmartArt version in Excel can be just as or even more effective as students can save it as a reference sheet for when studying offline outside of class hours.
Because anchor charts are usually general when it comes to formatting and content, they can be used for any purpose. Somethings you can try:
When covering a major subject or topic, you can use an anchor chart to help students keep facts straight, cover researching tips, list division or multiplication rules, or outline the steps to writing an essay. The possibilities are endless and can save time spent going over main concepts again.
You can use Excel to easily organize and visualize your chart with the simple formatting tools available. Use Excel to insert images, Smart Art, text boxes, and tables as needed.
Bar charts and column charts are one of the most common graphs you see when values are compared to one another. Both are essentially the same, but the categories appear horizontally in bar charts rather than vertically.
Because Excel lets you turn raw data into graphs, these kinds of chart types can make it easier for students working online to interpret that data. They can help students analyze cause and effect between values, understand relationships between values, and encourage conceptual thinking in a remote learning environment.
Excel can also be a great way to showcase any online research you do for lessons. For information you find in PDFs, a simple PDF to Excel conversion will do the trick. Adding that data to a bar graph or column chart is a quick way to include in-depth details to your lesson plan in a way students can understand.
Inserting a bar graph or column chart in Excel is straightforward. In Excel, select your data and use the Insert menu to select a bar or column chart in the options provided. Once you select the one you want, Excel will automatically pull in and format your data.
Pie charts are one of the most popular types of charts to use because of their visual nature. They're great at visually breaking down total amounts into smaller parts. Applying this kind of visual to different topics can be very effective.
Some advantages of using pie charts in lessons:
If you’re using this type of chart, you can set up a dynamic pie chart and illustrate real-time changes when a value or variable changes.
Another idea? Include pie charts side by side to illustrate any findings, statistics, or different perspectives on the topic at hand.
Or, if students are working on a project in a group, have each one responsible for researching one portion of the project and report and include each of their quantitative findings in a pie chart.
You can create a pie chart in Excel by first selecting your data and then inserting the Pie Chart you want. If you need some tips on creating or troubleshooting as you go, Microsoft’s resource, Beyond pie charts tutorial, can offer some pointers.
A low chart is an explanatory type of chart that displays and outlines the steps that occur in a process. These types of charts are great at laying out and visualizing individual components.
You can use them to further explain complex processes in physics, biology, and history – any type of process where one component is connected to another. Moreover, a flow chart can translate better in virtual classrooms where students need to grasp processes and study on their own.
Flow charts can help improve students’ organization skills and understanding the relationship between different steps in a process, such as:
If you’re using a flow chart, you can easily test students’ understanding by leaving some of the steps blank. You can then have the students fill in the blanks to see if they’ve understood the lesson.
In Excel, you’ll have several options to customize your chart. You can create a flow chart with SmartArt and choose from different shapes, colours, layouts and flowchart symbols.
With remote learning and communication as the growing trend, you can present your Excel chart online in Xodo’s free Office Document Reader which allows you to edit, crop, and annotate your documents in real-time for your students to see.
Other free online Xodo tools give teachers the flexibility to not only convert and view your documents, but also prep and customize any digital document content you need to teach your lesson.
From editing and cropping to merging and annotating PDF content, you get a wide range of free PDF tools for education that allow you to assemble handouts, reuse PDF images, or help organize your teaching material saved all in one secure place.
Try Xodo to see how our 30+ online tools can help take your lesson planning to the next level!
Teaching with Technology - Top PDF Tools for Teachers
Xodo is the ultimate PDF suite of tools for teachers and students. Unlock advanced features like annotation, forms, digital signatures and more to boost student engagement and drive learning results. Check out our post as we show you how!
Excel Efficiency Hacks: Save Time and Excel like a Pro
If you're tasked with analyzing data on a daily basis, you know the frustration that comes with those never-ending rows and columns of numbers. To help navigate around Excel, we'll show you quick tips and provide you with a few resources to help you out.
How to Create a Digital Photo Album in Microsoft PowerPoint
Looking for a creative way to showcase your photos? Create a digital photo album in PowerPoint! Whether you're creating a keepsake of an event or storing digitized photos, our guide will help you create a stunning digital photo album.