Do your learners create graphs in your classroom? Perhaps after they undertake a survey, such as a traffic survey, favourite food, eye colour, or something related to an area of study in the curriculum? There’s a whole range of digital tools available to help create graphs and charts (have a look at this blogpost “Fun or fear? Spreadsheets for Problem Solving in the Primary Classroom – fun over fear!” for a host of ideas and links to digital tools for using spreadsheets in the classroom).
Microsoft Excel is one of the most well-known and widely used digital tools for creating spreadsheets, which can easily be used to create graphs and charts. Microsoft Excel Online is available to all Glow users in Scottish schools as part of Microsoft Office 365. Excel Online is available anytime, anywhere with online access so can be accessed at home or at school (it can also tie neatly into the desktop version and mobile apps for smartphones and tablets, so that information created on one device in one location, is accessible for editing and updating on another device elsewhere).
Excel Online can be used to create spreadsheets from the beginning (or you can upload an existing Excel spreadsheet from your computer to make it available to edit online thereafter). You can keep it private to you in your own OneDrive (the online cloud storage with massive capacity available to every Glow user in Scottish schools). Or you can, at any time, choose to make a Excel Online spreadsheet visible to other users of your choice – and you can choose whether to allow them to just be able to read it without being able to make changes, or you can give other users the access rights to be able to jointly edit the spreadsheet with you. If your class is using Microsoft Teams then a Microsoft Excel spreadsheet can be created in the shared files so that all members of the class can automatically collaborate without the need to find and add specific usernames.
Here’s how to create a table and bar chart for a class traffic survey in Microsoft Excel Online
Have a look at the Sway presentation here for a step-by-step guide for learners to create an Excel spreadsheet in Excel Online in their OneDrive in Microsoft office 365 via Glow and to share this with other Glow users to be able to jointly edit the same spreadsheet. This has steps outline for creating a table, into which the results of a class traffic survey can be entered. From this there are steps shown to guide as to how to create a bar chart, to sort the information in the table, to share with other users and for them to add comments so that questions can be asked about the information.
Want to know more about using Microsoft Excel Online?
Microsoft Excel – there is a wide range of resources online using Microsoft Excel as the tool to put spreadsheets in a context suitable for use by pupils in a primary classroom. Some links have been provided below. Some of these provide tutorials in the use of Excel while others provide the ready-made files along with classroom teaching notes. Excel Online is available for free to schools using Microsoft Office 365 (all schools in Scotland using Glow can access Microsoft Excel Online as part of Office 365. It’s available in OneDrive or as part of Microsoft Teams for classes so you can either create spreadsheets individually or collectively so that multiple learners can collaborate on the same Excel Online spreadsheet at the same time on different devices from anywhere).
Click here for some guides to undertaking basic tasks in Microsoft Excel Online
The Beginner’s Guide to Microsoft Excel Online – a handy guide by Matthew Guay describing with screenshot illustrations how to undertake a variety of tasks in Microsoft Excel Online, from starting a new spreadsheet file, looking at options in the menu ribbons, applying functions, adding charts and tables, using the survey tool, sharing and collaborating with others, using comments and more.
Pivot Tables in Microsoft Excel Online– while pivot tables are not a function of spreadsheets which beginners may likely use, it may be handy to know that Microsoft Excel Online has this feature and that this link provides a guide to how to use them in the online version of Microsoft Excel
Users of Glow can access Microsoft Excel Online from within Glow by clicking on the OneDrive tile on the Glow Launchpad (from where Excel Online can be accessed from the 9-square waffle), or via Microsoft Teams Files tab (for Excel Online spreadsheets shared with the rest of the class Team) or directly from the Microsoft Excel Online login https://office.live.com/start/Excel.aspx entering the Glow email address – which is usually something along the lines of the form gw17surnameforename@glow.sch.org which will then take you to the usual Glow login page.
Co-edit a Microsoft Excel Online spreadsheet – here a link to show the steps to collaborating on a Microsoft Excel Online spreadsheet with multiple users.
How to add a chart in Microsoft Excel Online
Excel Online within Office 365 tutorial – shared by Edinburgh University, with descriptions which apply also to Glow users
