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.
Tag: Google Sheets
Mail merge is one of those great time-saving features that people love. That’s probably why we get heaps of questions about the best way to do it in Gmail and Google Drive. In this blog post we’ll share the top five mail merge add-ons available in G Suite and help you choose the best one for your situation.
By understanding what the spreadsheet is doing and learning a couple of handy hints, you will be creating spreadsheets quicker and using them more effectively to improve your workflow.
In Google Classroom, you can assign grades to question and assignment tasks given to your students. Although Classroom does not yet have an in-built gradebook, it is still possible to keep track of student grades across different tasks using a linked Google Sheet. This shows students’ grades for each task, as well as average grades for individual students and the class.
I have been speaking with Blake Seufert from Naavi about the development of this add-on for a while now, and am glad it is now available to schools. If you are using Google Classroom, you will enjoy this ad-on. Blake
You may have been to a workshop or conference, heard and learnt a vast array of new things and you head back to school full of enthusiasm to implement all that you have learnt. In your head you have all these ideas about how to revolutionise your classroom, until the reality of being back in the classroom hits home. Time tends to fly and good intentions slowly erode.
With Google sheets you can track student progress and easily visualise how students are progressing.
The most common ways for teachers to visually represent student progress is through graphing the data. However with conditional formatting in Google sheets, teachers have another option for graphically representing student progress.
Here is a step by step guide to easily using conditional formatting to tract student progress.