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”

Day 7 of Google 2019 – Google Sheets

Screen Shot 2019-12-01 at 6.53.26 AM.pngOn this seventh day of Google, we will be taking a look at a couple of Google Sheet features.

Images in a Cell

I will have to admit, in the past, I always struggled with fitting images in a cell of a Google Sheet. For whatever reason, I was not able to get things where I wanted them on a first try. Well, Google has solved this problem. Under the “Insert” menu, you will now find “Image in a Cell” when you hover over “Image”.

Screen Shot 2019-12-13 at 9.10.04 AM.png

Customize Graphs

Next, we will take a look a graphs. In the past, you did not have the freedom to truly customize the looks of your graphs or charts. You now can click on items to move around, change font, style, etc. To initiate any changes, click on different areas of the graph. Then, a column on the right side will show up for you to make the edits that you want to make.

2019-11-05_07-50-12-1

If you have any questions with the items listed above, you know where to find me. And that is my Spiel…

Teacher Tip – Flippity: On the Fly vs. Planned Groups

Screen Shot 2019-02-21 at 8.50.38 PM

There are many elements to my job that I absolutely love. Today was another reminder! Seeing as though I help support curriculum in the classrooms, I am able to observe great teaching strategies from the high school staff. We all do great things and have great skills that are unique to us as an individual.

Continue reading “Teacher Tip – Flippity: On the Fly vs. Planned Groups”

Day 3 of Google 2018: Checkboxes in Google Sheets

Screen Shot 2018-12-04 at 8.46.14 PMUse spreadsheets from time to time? Google Sheets now allows users to have checkboxes in a column. It might seem like a small feature but in all honesty, it can be a great visual cue to know who has and has not done a particular task.

Continue reading “Day 3 of Google 2018: Checkboxes in Google Sheets”

Chromebook Challenge #hyperdoc

Inspiration
Inspiration #1
Over the summer, I was introduced to a new term/concept known as a #hyperdoc. You might say well isn’t a hyperdoc just a Google Document that has hyperdocs in it? Well, the answer is no. A hyperdoc is a document that has links to other artifacts, videos, articles, games, reviews, etc. Through these links students learn about a concept as well as share their own learning and thoughts with others. To learn more about #hyperdocs, and the work that Lisa Highfill, Kelly Hilton, and Sarah Landis have done, click HERE. I decided to make an attempt with creating a Chromebook challenge hyperdoc (even though it leans more on the side of students mostly learning information and not sharing as much information).

Inspiration #2
I was inspired to produce a Chromebook challenge after hearing about how Lee’s Summit R-7 School District created a Chromebook challenge for their students. Their great resource can be found on their technology website HERE. What I like about what they accomplished is that depending on the grade level, different tasks/reminders were given to the students.

Designing the Challenge
Seeing as though this is our second year as a 1:1 Chromebook school, I thought it made sense to do something similar at the high school level however I tried to gamify it a bit. I tried to keep the design of the challenge in mind when creating it as I did not want students to just watch a video explaining everything. I also knew I wanted to make it interactive and include some teachers in the challenge to put a smile on students faces. I also wanted to make it as easy as possible to follow along.

BHS Chromebook challenge was created using a Google Drawing. You can find the actual file HERE. You will notice that there are 8 different tasks for students in advisory to complete.

  • Chromebook Reminders
  • Chromebook Printing
  • Organizing Digital Life
  • Self Management
  • Chromebook Shortcuts
  • Planning Your Days
  • Google Classroom
  • Chrome Settings

The advisor decides the order of the tasks that they complete as a whole group. Whatever the task, the advisor follows along with the bulleted list. Tasks could involve students:

  • watching a video or two
  • looking over instructions in a Google Slide
  • playing a game
  • providing feedback in a padlet wall
  • organizing their own Google Drive
  • personalizing their own Chrome preferences
Documenting Tasks
Once an advisory completes a task, the advisor clicks on the master Google Spreadsheet link in the middle of the Google Drawing. This is where all advisors keep track of what has and has not been accomplished. The advisor finds their name and the turns the ‘red x’ to a ‘green check mark’. 
 
When all 8 tasks have been completed, the advisory earns a Chromebook challenge badge. Gamifying things makes learning that much more fun. 
As a side note, for every task an advisory completes, their name gets entered in for a free breakfast. There will be a winner for each grade level. Oh and the advisory has the entire month of September to complete the challenge.

Here is to learning while having fun at the same time…