view: full | short | titles only
from Malcolm Wilson @ Digital Learning & Teaching in Falkirk
from Malcolm Wilson @ Digital Learning & Teaching in Falkirk
from Malcolm Wilson @ Digital Learning & Teaching in Falkirk
from Malcolm Wilson @ Digital Learning & Teaching in Falkirk
from Malcolm Wilson @ Digital Learning & Teaching in Falkirk
from Malcolm Wilson @ Digital Learning & Teaching in Falkirk
from Malcolm Wilson @ ICT for Learning & Teaching in Falkirk Schools
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.
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.
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
from Malcolm Wilson @ ICT for Learning & Teaching in Falkirk Schools
The go-to presentation-creation tool for many teachers and pupils is PowerPoint. So as your pupils are already familiar with using Microsoft PowerPoint then consider using Microsoft PowerPoint Online available to all Glow users in Scottish schools as part of Microsoft Office 365. PowerPoint Online is available anytime, anywhere with online access so can be accessed at home or at school.
You can upload an existing PowerPoint presentation from your computer or other device to your OneDrive in Office 365 in Glow (and then edit online from then onwards) or you can simply log into your OneDrive and create a new PowerPoint presentation completely online. You can choose to keep the presentation 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 PowerPoint Online presentation visible to other users of your choice – and you can choose whether to allow them to just be able to view it or show it without being able to make changes, or you can give other users the access rights to be able to jointly edit the presentation with you, either at exactly the same time as you or at different times to suit each user.
Have a look at the Sway presentation here for a step-by-step guide for learners to create a PowerPoint presentation in PowerPoint 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 presentation.
The link below take you to a classroom activity for pupils to use PowerPoint Online to create (jointly with other pupils on different devices at the same time) a robot character. The step-by-step guide to this activity can be adapted for other curricular-specific tasks which would benefit from a group of pupils working collaboratively on the same PowerPoint presentation, whether simultaneously or at different times:
from Malcolm Wilson @ ICT for Learning & Teaching in Falkirk Schools
So are your pupils are already familiar with using Microsoft Word? Then why not consider using Microsoft Word Online available to all Glow users in Scottish schools as part of Microsoft Office 365. Word Online is available anytime, anywhere with online access so can be accessed at home or at school.
Word Online can be used to create document from the beginning (or you can upload an existing Word document 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 Word Online document 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 document with you.
Have a look at the Sway presentation here for a step-by-step guide for learners to create a Word document in Word 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 document.
from Malcolm Wilson @ ICT for Teaching & Learning in Falkirk Primary Schools
What is Microsoft Classroom?In a nutshell, it’s an online environment where a teacher can assign tasks, track who’s completed tasks with ease, or provide feedback to support learners, share in seconds OneNote pages to every individual pupil’s section which can only be seen by the teacher and that individual pupil, have peer-to-peer conversations for collaborative work between learners or for teachers to provide individualised support to learners through teacher-pupil discussions. It joins up features available in Office 365 for Education – the OneNote Class Notebook, messaging, calendar, feedback, groups and email especially for classrooms. It works via a browser, or computer or mobile app for smartphone or tablet.
Click on this link for an interactive step-by-step guide to Microsoft Classroom, what it looks like, how it works and how a teacher might use it with their learners. This interactive guide takes you through the steps combining video, audio, screenshots as well as inviting you to click on the sections to see what happens and move to the next step to find out how Microsoft Classroom works for a teacher.
https://classroom.cloudguides.com/en-us/guides/Introducing%20Microsoft%20Classroom#
Teachers and pupils in Scottish schools have access to Microsoft Classroom using their Glow login details. Just log into Glow, choose any Office 365 tile then, from any part of Office 365, just click on the 9-square waffle and choose the Classroom tile. Alternatively go to Microsoft Classroom website and use your Glow login details to log in straight from there https://classroom.microsoft.com/
The video below is to the first in a playlist created by Microsoft Education of a series of short videos showing how to get started with Microsoft Classroom and how to undertake a variety of tasks a teacher may wish to do with their class.
Microsoft has an online support section for Microsoft Classroom – Getting Started with Microsoft Classroom – click on the links which best suit what you need for step by step guides.
The Microsoft Educator Community has an introduction to Microsoft Classroom guiding users through the features, setup and management of Microsoft Classroom. Educators are encouraged to sign up on the Microsoft Educators Community as recognition is then given for completion of a course and assessment in the form of badge and certificate https://education.microsoft.com/GetTrained/introduction-to-microsoft-classroom
Miguel Guhlin has created a playlist of videos exploring different features of Microsoft Classroom and how different parts can be used in a classroom situation by a teacher with their class of learners. There’s videos showing the learner view, including on a tablet device, as well as examples showing how teachers might share different kinds of resources, how learners might complete tasks, and how a teacher might provide different forms of feedback.
Scott Letts has created some tutorial video guides to using Microsoft Classroom, How to set up Microsoft Classroom and Creating an assignment in Microsoft Classroom.
When setting up the app on a mobile device it will usually ask for the Office 365 for Education – that will be the full Glow email address.
Schools which have already been using Microsoft OneNote and have existing OneNote Class Notebooks can associate Microsoft Classroom with existing Class Notebooks. To do this ensure you have the desktop version of OneNote installed on your computer, and have added the Class Notebook Add-in. Then to associate an existing Class Notebook with a Microsoft Classroom click on > Connections > Map Class Notebooks.
Microsoft Classroom has a user voice forum where users can feed back on features they’d like to see modified or added in future releases to better support the use of Microsoft Classroom by teachers and learners. Click on this link to see what others have requested and add your voice if there’s something which would make this even better for your classroom use.
https://edu.uservoice.com/forums/289447-general/category/165585-microsoft-classroom