Marketing Students, Data & Looker Studio

Recently, I had the opportunity to work with the marketing teacher in school, Mrs. Wilczewski, where we wanted to help students analyze their data collection. In groups, students were asked to research a particular restaurant that could be opened in town. Students organized focus groups to gather some information. Additionally, each group created a Google Form to gather feedback through survey questions. Students were then asked to create a presentation about their findings for a new restaurant in town. 

In talking more with Mrs. Wilczewski, we decided to curate all of the data from each of the 15 different restaurant groups and pull them into a Looker Studio (formerly known as Google Data Studio). To take a look at the Looker Studio, click HERE. A quick sample of what three of the pages look like can be seen below without launching the Looker Studio. NOTE: It is important to note that no PII is included with this Looker Studio. There is absolutely no student information being shared.

Continue reading “Marketing Students, Data & Looker Studio”

Flip Your Content in 90 seconds?

As a society, we are obsessed with consuming and creating content in short videos. As a digital learning specialist, I am wondering if we are reaching our learners and those that support our learners in the most effective way. Do we need to start thinking differently with how we present information? How can we do this in a safe manner that is efficient?

I co-teach a couple of graduate level courses for educators, and decided to start exploring alternatives to using TikTok. (Yes, our high school students are using the tool daily. Some of our teachers also use the tool for their own purposes or personal interests.) I decided to create a TikTok like video with Flip, using the mobile app. I have to be honest, I have been using Flip for years now, but I have not really focused much of my attention with the mobile app. While you don’t get all of the filters, songs and features that TikTok has to offer, Flip does do a good job in helping content creators make TikTok like videos.

Below are the norms from the class. You decide which you would prefer to interact or consume with:

Visual/Auditory Example: I decided to create a short video highlighting the class norms for the course I taught. In less than 90 seconds, students were able to understand what was expected of them in class. Click HERE to view the Flip video or click HERE to view on YouTube.

Traditional Google Doc Example: Below is a screenshot of what the Google Doc looked like that was posted in Google Classroom.

Image of Google Doc Format

Some advantages:

  • One could argue that a video is more engaging than reading a list off of a google document
  • Ability to add humor or show some creativity
  • Mimics similar style videos students and parents are viewing on social media apps
  • Flip is a safe space where students (and teachers) can create without needing a ‘TikTok’ account
  • Eliminates a user name on the video (as seen on TikTok videos)
  • In less than 90 seconds, students were able to understand what was expected of them in class.

Some issues:

  • It could take way more time creating a 90 second video instead of typing a list in a google doc
  • Not all creators enjoy hearing their voice in play back in class
  • Not all creators are willing to use their own personal mobile device to make a video (mobile app)

I enjoyed exploring around with this idea. I plan to continue making similar style videos when I need to share out content with students this year. Perhaps we will get more students paying attention to information being shared with them? Perhaps not. Only time will tell.

If you yourself have been exploring around with this format, I would love to hear from you. And that is my Spiel…

Streamline Daily Data Collection

Our special educators at our high school have been asked to formally keep track of the services that they are giving students under their caseload next school year. My colleague, Kerri Lunn, and I sat with one of the case managers to truly understand all that they are being asked to document. We wanted to make sure that they will not spend hours each week documenting the necessary information.

Based on the conversation, we landed on creating a spreadsheet template that each case manager can make a copy of. Things we considered:

  • Streamlined workflow so that they are making selections from as many drop down columns as possible – less typing the better
  • Each student has its own sheet tab so that finding information later in the year can be found easily
  • Use of column stats can give a quick overview of each student when meetings arise or questions are asked in an email throughout the school year
  • Workflow that all special education case managers can work with – we met with the whole team to get feedback and made adjustments based on their suggestions
Visual showing the spreadsheet view

Continue reading “Streamline Daily Data Collection”

Group Playlist Concept

Our Wellness II teachers wanted to give their Mental Health unit a ‘refresh’ look and feel. In the past, students were lectured about the topic as well as participated in class discussions. Recently, I had heard Amanda Sandoval’s keynote at the Spring CUE conference where she talked about how she has designed activities for students based off of Catlin Tucker’s playlist concept. Hence, where Group playlist comes from. 


In the keynote, Amanda talks about how she loved station rotations, pre-COVID times, where students would participate in different activities at the same time. Then when the timer goes off, students moved from one station to the next. This was an approach that we used pre-covid times as well (In fact, I wrote a blog post about this in Feb 2020). Amanda shared how she feels Group Playlist works a bit better because:

  • Not all stations use up the same amount of time based on the activity.
  • Groups can complete tasks in any order that they want to complete them in.
  • Teacher is able to assess work as students complete tasks. Groups let the teacher know when they are done to do the ‘assessing’. This saves time on the teacher not having to look at the work after hours and it also gives students immediate feedback. Win for both parties!
Continue reading “Group Playlist Concept”

Google Meet for Full Class Meetings

In our district, we have been in person all year with our students. It has been nice that we have not had to have learning happen through virtual meetings all day, every day. I have however appreciated the fact that this resource is still available in the back pocket for when it makes sense.

There have been a couple of times now where I have needed to meet with a particular graduation class. Rather than having over 300 students all pile into the theater, ran a Google Meet session. Advisors of that particular class were sent a Google Meet link to join and projected me into their classrooms. Students then had the ability to follow along and complete the task at hand that I was demonstrating. What also helped was the fact that these students were spaced out throughout the school building. So, having 300 students complete tasks at the same time throughout the building is more successful than having 300 students in the theater accessing one access point.

I also appreciated the fact that I was able to record the sessions as well. Advisors were told ahead of time to mute their camera and their microphone. Once the session was completed, I was able to follow up with the link to the recording that could be shown again at a later time. This way if an advisor was absent and a group of students missed the message, that advisor could play it at a time that made sense for them.

While many of us want to forget some of the experiences that we were faced with the past few years, it is important to recognize that some of the tools that we used then can still be used in creative ways moving forward. This is one of them.

If you have any questions about this idea or process, you know how to find me.

And that is my Spiel…