Welcome, everyone. Today we are going to create AI-powered publications and dashboards. Educators are reading about three times more digital content than they were five years ago, so the problem is not finding information, it is turning it into something a learner or a colleague can actually use. My goal is for you to leave as a Learning Loop Architect, someone who turns chaotic content curation into clean, professional digital work. I am going to show you how to make KPI dashboards, how to save web data into Google Sheets with AI-generated Apps Script, and a lot more, all with tools you already have.
Before we dig in, let us do a quick icebreaker that doubles as a demo. This is an Oreo Cookie Personality Quiz, and it tells you your teaching personality by how you eat an Oreo. The whole thing was vibe-coded with AI, the live results save to a Google Sheet, and you share it with one link. So while you are having fun picking whether you twist it apart or dunk it, you are also seeing exactly the kind of self-contained, shareable tool we are going to build today. Pull out your phone, go to the link on the screen, and pick the option that matches how you really eat an Oreo.
Here is a second quick one, and it is how we will move through the ideas in this session. This is iBINGO Game Maker. Each square is a concept we are going to touch today, things like Card Flip, Self-Contained HTML, Raindrop, the Learning Loop, ACE It, KPI Dashboard. As I cover each one, you mark the square. The goal is to cover a full diagonal. Like the Oreo quiz, it was built by pasting terms, generating a card, and sharing one link. So the game itself is another example of the workflow. Go to the link on the screen and grab your card.
A quick word about who is leading this. I am Miguel Guhlin, and I have spent my career transforming work through technology, from the classroom up to the district level. I have been a District Technology Director, an Instructional Technology Director, an online master's on-site coordinator and professor of record, and a K-12 classroom teacher. These days I serve as Director of Professional Development for TCEA. In that role I write a lot, blog posts and online courses, with a recent focus on AI in education. Everything I am showing you today comes out of that day-to-day work, not theory.
Here are your session resources, and I want you to grab this link now so you have everything for later. Behind this one link you will find the slide deck, a Google Doc with supplemental documents, and a copy of the Google Sheet for version four. There is a companion blog entry on making data displays without writing code. You also get the KPI dashboard materials, the AI interactive newsletter, a NotebookLM audio overview, and example newsletters. Do not try to write all this down. Just save the link on the screen and you will have the whole kit when you get back to your campus.
This is the heart of where we are going, captured in one image. Make data displays without writing code. The path is ACE It, then vibe-code it, then share it. You curate, draft with AI, publish, and share, using the VIBES steps you see at the bottom: Vision, Input, Build, Evaluate, Ship. On the right is the kind of result you can produce, a clean dashboard, a newsletter, and the data display patterns field guide. The chart shows the top five high-effect-size instructional strategies from the latest Visible Learning MetaX data, because the goal is never just a pretty display, it is moving student learning. The companion blog at this link walks through all of it.
Let me set up the real problem. We are not short on information. Educators are consuming about three times more digital content than we were five years ago, which you see in the number on the right. The challenge is what we do with all of it. Turning that flood into a meaningful learning experience for someone else is the hard part, and it is where most of our time goes. So this session is really about workload. I want to show you workflows that make your information accessible and interactive for other people, even in situations where AI is not available or is not the right tool to reach for.
Here is the spine of the whole session. ACE comes out of my work with SOLO Taxonomy and Hattie's surface, deep, and transfer learning phases. The idea is one anchor word you can actually remember. Articulate, Connect, Extend. I use the same three moves for building things. Articulate It is naming what you want in plain words, which is surface learning. Connect It is fitting that into the work you already do, the deep phase. Extend It is taking it somewhere new, the transfer phase. Everything in the rest of this session hangs on these three cards, so keep them in mind as we go.
Articulate It starts with realizing you can build solutions yourself, even if you do not code. This is a blog series on vibe-coded solutions for educators, free classroom tools for sharing, brainstorming, questions, and markdown cleanup. On the right you can see three of them in action. ShareSpace is a collaborative showcase gallery. WonderWall is a moderated classroom question board. StickyBoard is a shared sticky-note canvas for brainstorming and exit tickets. None of these required me to be a developer. I described what I wanted and the AI built it. That is the whole promise of Articulate It.
Let me make Articulate It concrete. The problem is making your information accessible and interactive for other people, even when AI is not in the room. The solution is vibe-coding. You describe what you want in plain language and let the AI shape it into working code. You do not need to be a coder. With that, you can create visual displays, self-contained websites, online tools, and information-rich KPIs, which you see in the row at the bottom. One example from my own life is a tool I built called DrawSplat. The point is that what you build reflects your expertise, not the AI's.