There are many uses for Google Sheets in the classroom. I like to be able to have my own class list where I can keep track of my students. I would use a sheet for attendance, recording homework, anecdotal notes and marks. Many LMS’s can do this, but I like the ability to customise what I see and enter, Google Sheets allow me to do this easily.
A major sticking point with moving from Excel to Google Sheets was the lack of ability to use macros. A macro will let you automate calculations and other aspects in spreadsheets. For instance, if you regularly tally up marks, allocate a grade and then draw a graph or chart of the results for your class, the you can create a macro to do this for you. Google Sheets now have the capacity to write and run you own macros. This will increase your efficiency and save you time.
With more documentation being digital, occasionally the need arises to be able to add notes or sign a PDF. Previously this involved printing the document, signing it, uploading it and then scanning it before sending it. Markup solves this problem and can be used easily on an iPad or iPhone.
Before laptops were common, when I was working on a project I would have several books open and many pieces of paper all on a big table. Nowadays we can have the same experience by using multiple desktops to multi task.
Split-screen mode divides your computer screen into two halves so you can view two different windows at the same time. Not only does this allow more screen real estate but it makes your workflow more efficient.
It is good to spring clean your device every now and then. With memory being cheap and being able to search for anything, we tend to be a bit lazy saving files and installing apps. Before we know it, our desktop is a mess and we have a stack of apps that we may have used once but now just take up room, so where do we start?
Change that leads to new learning opportunities and improved outcomes must utilise the human resource in schools, embrace technology that redefines learning and engages the wisdom and experience of others. If we were to think more like bees when doing the buzziness, we’d actually manage the change organically just like they do
We can get frustrated with spreadsheets because they don’t do what we want them to do, or we just think that they are used by statisticians. With more data around than ever before, especially in schools, it can be hard to use the data well. Here are three simple hints in Google Sheets that allow you to be able to analyse and display your data like an expert.
The start of the school year with technology can be messy, but by following these five steps your journey may be easier ! The relationships they help build with students will create a sense of community and belonging with technology assisting learning.
[podcast] Download PDF Transcript Transcript: Apple Shorts – Episode 1 – Notes Good day and welcome to this episode of Apple shorts. I’m Adrian from Using Technology Better and in under four minutes you’re going to learn some new tips or tricks that you can use straight away. That’s right, in less time
With mobile phones and many cameras now being able to shoot video in 4K, should you jump in and join the crowd?
The functionality of Apple Notes has been improved and it is now a great tool that integrates seamlessly with all the other native Apple apps.
