If you’re needing to get up to speed quickly in using Google Classroom then this is both an excellent place to start or a good place to return to for help.
The Assistive Technology Support Service (ATSS) will be available for online help and support during the school closure period.
ATSS can help with advice and practical support around Highland’s School technology (Google Classroom, etc.) but also more specialised access around reading and writing supports for all the digital material that’s many pupils have difficulty with and that are likely to be flowing your child’s way over the coming weeks, perhaps months.
We can help with, amongst other things, reading support apps for iPad, PC, and Chrome. We can also help with supportive writing tools for iPad, Chrome, and PC.
Get in touch by emailing myself (Alan Stewart) and we can take things from there.
This latest iteration of Clicker is a huge step forward in accessibility and interoperability across platforms. So, where teachers still use PCs in class while pupils use Chromebooks in school and possibly iPads at home there are now no barriers between these tools.
The individual apps for Chrome and iPad left many unsure about what specific app they needed at any given time. Clicker 8 overcomes this by including all the apps as well as a range of other features (old and new) all within the umbrella package.
In addition to the writing and associated support tools for pupils, Crick has added a fantastic automated picture attachment tool (Picturize) for most text; resurrected and included an application from a few years ago that allows for the creation of Cloze passages; and there is also a comprehensive analytics system built into the software to help teachers tracking, reporting, and planning.
National Digital Learning Week is back! This year the event will take place Monday 13 until Friday 17 May.
For this year’s even all Early Learning and Childcare Centres and Schools across Scotland are invited to take part in 5 Curriculum focused challenges in: STEM, Social Studies, Expressive Arts, Numeracy and Literacy.
Here’ a 2 minute video that tells you everything you need to know about the event.
Visit the Glow Blog today and get started. https://bit.ly/2PfR0Go
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).
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 email@example.com 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.
Excel Online within Office 365 tutorial – shared by Edinburgh University, with descriptions which apply also to Glow users
You’re getting old! This a an online tool where you enter a date, such as a birthdate, and the site presents a whole range of calculations related to that day by comparison to the current date and time.
The calculations presented include (if it’s for a birthdate) exactly how old at that moment in time that person would be in years, months and days, then presents that as a total number of days, as well as the total number since birth for that date of candles on a birthday cake, the approximate number of times that person’s heart would have beaten, total number of breaths, number of times the moon has orbited the earth in that time, and the number of people who were alive on earth on that birthdate compared to the number today.
As a bit of fun it has some entertainment value, but for a classroom it can also help introduce the concept of comparisons of time in history, or other curricular areas related to specific pieces of information (such as science when looking at heartbeats, breaths or moon orbits).
Another calculation included is in making a comparison to the length of time elapsed from the birthdate until today compared to something in history from that same birthdate but going backwards in time by nearly as far back. Thus as an example for a child in a class whose birthdate might have been 29 January 2010, thus comparison calculation on that date in 2019 would be “When you were born was nearer to the 9/11 terror attacks than today.” This can highlight something that to people who have that earlier event in their own lifetime perhaps reflecting the passage of time between people of different ages and their perceptions of how long ago something happened.
There are links to social subjects when it comes to comparing, for the length of time which has elapsed since the birthdate selected, how far a single location on the planet has travelled as it rotates, the distance travelled as the Earth revolves around the Sun, and more.
Then the site picks out selected historical events from the birth year, from early childhood, later years as appropriate. And it notes the dates on which that child will reach certain milestones – in a classroom context when numbers start to get large when you can no longer actually picture them in your mind, this site can be used to get children to try to guess the number of days until certain landmark dates before revealing the site’s calculations.
For birthdates of adults (you can use those of celebrities known to pupils) there are additional comparison calculations (they won’t appear for children’s ages since it relies on information comparing the ages of two other well-known people) – such as taking an adult’s age and showing it as the sum of two younger people (so that could be an older named actor being the same age as two other named child-actors.
One last comparison displayed is a pie chart showing the number of people born on the same birthdate as that selected and highlighting the number who are still living. This, like many of the other calculations, can provide the starting point for discussions for social studies subjects.
Give it a go http://you.regettingold.com and please do share in the comments below how you’ve used this tool in the classroom,
Doorway Online Interactive and Accessible Learning – http://www.doorwayonline.org.uk/– an array of free online teaching resources which can be used by early learners independently or as classroom activities led by a teacher on an interactive whiteboard.
These support learning and teaching in literacy (letter and number formation, first sounds, first words, first blends, spelling using look, say, cover, write and check), numeracy (odd and even, counting to 10, number table, number sequencing, station of the times tables, addition and subtraction to 10 and to 100, telling the time, and handling money), touch-typing games to learn keyboarding skills, and matching and memory games.
We at ATSS have always loved Book Creator and have suggested its use and trained numerous folks to use it and embed it into all sorts of curricular areas over a number of years. Book Creator has continuously developed over time onto different platforms and to offer additional tools and features.
This most recent development opens up an new world of possibilities for teachers to create interactive resources for their students while providing pupils with a fantastic work space in which they can showcase their work no matter (almost) what format it exists in.
MathsBot.com – a series of free online tools which will support a teacher in teaching mathematics. These are designed to be used in a teaching situation where a teacher is using the tools directly with learners to help explain concepts, or to provide interactive activities with a class, a group or individual learners.
There are tools to support mathematics teaching at all stages whether primary school or high school. They can be used in different ways to suit the level of understanding of the learners at any stage.
There are a number of these tools which would work particularly well in a primary classroom, perhaps used projected onto an interactive class screen and manipulated by learners under the direction of a teacher as they explore mathematical concepts together. So in the manipulatives section you’ll find a fraction wall, counters, counting stick, Cuisenaire rods, Dienes blocks, Geoboard, pentominoes, place value counters, ten frame and unit box. Then tools like Venn Diagrams can let pupils explore a whole range of different aspects whether properties of numbers (such as even/odd, 1-digit/2-digit, less-than/more-than), area of rectangles, co-ordinates. and more. The Number of the Day interactive tool can be used to display a range of random questions based on a teacher’s choice of difficulty and the range of number answers as well as difficulty level. So for quick-fire mental maths classroom activities it could be useful as a daily routine for a few minutes. Likewise there is the AfL Checkup tool which a teacher can set at whatever level of difficulty would best support and challenge learners, within choices of arithmetic, converting time units, fractions, measure, money, and more. And within each choice you can choose the aspects of these which match what is being taught and learned in the classroom at the time to consolidate and challenge learners in a fun interactive way.
There’s Manipulatives, Printables, Starter Drills, Tools, Question Generators, Puzzles and specific resources to support a maths curriculum.
This a very useful set of resources, adaptable to so many classroom situations to be used in whatever way a teacher can see will best support, challenge and motivate their learners.