Joining two tables together is a very common task for data analysis. Imagine you have these two tables Let’s say that the first table came from a Google Quiz you did, while the second came from your existing data. You’d like a quick way of adding each students score next to their name. VLOOKUP will […]
If you’re on any teaching-related social media, you’ve been inundated by posts related to ChatGPT. This week, I decided to jump on the bandwagon and try a few lessons using the new tool. What is ChatGPT? ChatGPT is an artificial intelligence chatbot. The premise is that you can ask ChatGPT a question, and it will
Health warning: this post is pretty technical! One of the key goals for our Data Dashboard was to have up-to-date information. Initially, we were dealing with just GL standardised data (CAT4 and PASS). However, as time went by we started to want to use our internal reporting data, logged concerns, and merits / behaviour data.
How we used PowerBI to enhance our behaviour reports, taking us from massive Google Sheets to a clean, intuitive graphical interface.
This post is the first in a series of entries I plan to make showing how we designed a bespoke data dashboard for our school. I’ll post links here to show how each aspect of our dashboard was created, leaving us with something that looks like this: The Problem At our school, we have a
Welcome to WordPress. This is your first post. Edit or delete it, then start writing!
