formative assessment, Google Sheets, pixel art, Wakelet

Turkey Pixel Art Activity

You know I love to make pixel art review activities. This week, another teacher in my building came to me and wanted to create one for Thanksgiving, so we sat together and created this. With her permission, I’m sharing the template with you.

  • Type your questions and insert any images on Sheet 1
  • Type your answers on Sheet 2
  • Change the font color to white on Sheet 2 so the answers become invisible
  • Hide sheet 2
  • Set the activity to make a copy for each student
  • ENJOY!

If you would like to create a pixel art activity of your own, you can follow the instructions in my original post.

I have created a Wakelet containing all my templates for Google Sheets activities. Click the link below to check it out.

Enjoy and Happy Turkey Day. I hope you enjoy time with family and friends.

Tech or Treat

Tech or Treat 2021

It’s BAAACK!

Tech or Treat, year 3. Spooky season is my favorite and I love putting these together for you. I hope you enjoy the ideas and fun that come out of the cauldron each day.

I changed things up this year by creating Tech or Treat in a website because it worked well for 12 days of Techmas. Don’t forget to check back EVEY DAY this week. The cauldron provides techs and treats daily.

click to visit site

Here are the links to Tech or Treat from previous years.

Happy Spooky Season!!!

Google Sheets

Fun with Google Sheets, Part 4

I’m back today with more tips and tricks to make Google Sheets fun and amazing.

Filter by Color

If you have set up your sheet to change colors using conditional formatting (Fun With Sheets 2), then you can filter by color to see entries that are a certain color.

Highlight the cells you want to sort, then select the funnel looking tool on the right of the toolbar. Select Create new filter view.

The view changes and these little upside down triangles show up on the first line.

I’m going to click the triangle on House to filter.

I selected dark red 1 to get my Gryffindor students.

*Note that you can also filter by text color if you prefer colored text instead of colored cells.

A now I have just my Gryffindor students.

Hiding Cells/Sheet

If you’ve been following along with the Google Sheets activities I’ve been creating, then you may already know these tricks. I use them in my activities all the time.

Hiding Cells

Sometimes you don’t want part of your cells to show. Maybe you have some calculations happening, maybe some answers. You can hide those sheets so students can’t see them. Now, a tech savvy student might notice, but we will get to that in the next step.

Highlight the rows you want to hide (works for columns too), right click and select hide rows.

Once the rows (or columns) are hidden, you can see the arrows indicating there are hidden cells.

Hide Sheet

You can also hide an entire sheet from view. If you create an activity and put the images and answers on Sheet 2, you don’t want students to be able to see that.

Once the sheet is ready, right click and hide sheet.

Protect Cells/Sheets

Once you have hidden your cells and sheets, you want to prevent tech savvy students from unhiding them. You can protect these so you are the only person with access.

Highlight the cells you want to protect, right click, and select protect range.

You can do the same thing with the sheet, by right clicking on the sheet and setting protection.

The only caveat with this is once a student makes a copy, like they have to do when they solve a puzzle, the YOU in “only you can make a change” is THEM. So they can now see your Sheet 2 and hidden cells if they know how to unhide. For this reason, I like to make my font color white so it disappears and I place the answers where they have to scroll a lot to find them. Is it perfect? No. But these activities are fun and work well for digital escape rooms or review so I will continue to make them.

I hope this series is helping you embrace the amazingness that is Google Sheets!

See previous Fund with Google Sheets posts:

ramblings

Is Education Broken?

I’ve been teaching for over 20 years. I’ve seen education change, A LOT! But the pandemic has highlighted the parts of education that is not working. How much more will the system take before it implodes? I’ve been saying for at least 8 years now that we are headed for change. We are now at a point that if we don’t change we are going to fail.

I am all about building relationships with students. I write about it in my book, I model it in my classroom, and I talk to others about it. Do we still have some teachers on a power trip? Yes! Are there fewer teachers on a power trip? Yes! Do the teachers who want compliance of behavior over relationship still have the most issues? Usually. But what I have been seeing lately is a systemic issue of general lack of respect which makes relationship building more difficult. Students are pushing the societal boundaries of acceptable behavior. Maybe some of these boundaries need to change, like our view on dress code which is historically sexist. But what is acceptable? How much of the human body should be exposed in school? What does our society say is acceptable? What are some boundaries that shouldn’t be pushed?

Some behaviors disrupt what our government and court systems have told us is the pubic schools responsibility to deal with: students refusing to be in class, hiding in bathrooms, vandalizing, fighting (like a lot of fighting), and using illegal substances (not just vaping). I know some of you are thinking, relationships will fix this. In a theoretical world where we have unlimited time, yes, relationships and programs like Restorative Justice will fix the issues. We don’t have unlimited time. We don’t have ENOUGH time, period. Behavior issues keep increasing and the number of people able to build relationships and deal with the issues keep decreasing.

My husband is an administrator and I see the amount of time it takes to deal with issues. A minor infraction like a student saying “F#*K” in class takes about 40 minutes from talking with the student to writing up the report. He has 550 students he is responsible for each day. Now imagine in a day he has a fight, a report of bullying, 3 students sent to him for using inappropriate language, a student refusing to stay off their phone during class, 5 students vaping in the bathroom, and 4 parent emails or phone calls. A bullying report takes 2-3 days to investigate, fights take about 2 hours to complete the investigation, make calls, and complete paperwork, and phones and vaping taking 30-40 minutes. Also during the day he is responsible for bussing, all standardized testing (our school has A LOT of “required” testing throughout the year), lunch shifts, supervising and evaluating about 20 teachers, and IEP meetings for his own students. He is also supposed to look at the grades for all of his students and call in students who are not doing well. Now last I checked, we are in school from 7-3, not even close to the amount of time needed to deal with these issues. He supervises an athletic even 2-3 nights a week so he has to leave right after school. THERE IS NOT ENOUGH TIME! The number of behavior issues is insane and administrators are being told to spend MORE TIME building relationships. Where? Where does this time come from? They want to, but they don’t have time. When they ask for more help, more administrators, counselors, and teachers, they are told we don’t have the money. They, just like teachers, are told to FIGURE IT OUT!

We are told, don’t suspend as many students. Ok, are we supposed to say, “Hey friend, next time you are angry, instead of taking someone to the ground and kicking them repeatedly in the kidney because they said your girlfriend is hot, maybe try a different approach. I’ll let you off with a warning this time.” Or “Next time someone calls you messy (this means a promiscuous person with STDs), don’t grab her by the hair and bash her head into the wall and pull her hair out, just say those words are hurtful. Now go back to class and do better.” If it was outside of school they would be arrested for assault and it should be the same in schools. You can’t harm another person and say it’s ok. Do we need to talk to them about their actions and help them make better choices? YES! Do they need to experience consequences for the actions? ABSOLUTELY!!!

On top of the behavioral issues that are getting worse, we have all of the non-academic things schools now have to deal with according to cases adjudicated by the courts and laws passed by the government. We have to teach students how to spot a sexual predator, teach about and deal with bullying, keep students in the school and know where they are at all times but give them more freedom, educate them on suicide, teach about sexual health without promoting an agenda, teach about history without promoting an agenda, and create an inclusive environment for all students without promoting an agenda.

Then we have the issue of academics. We are still operating under an antiquated system from over 100 years ago. Standardized testing started with the first authorization of the Elementary and Secondary Education Act. It was an attempt to remedy inequity in education. I DOESN’T fit our society now and actually increases inequity. We are encouraged to differentiate education for our students but then we measure it with a standardized test. Then, we base the limited funding for our schools on these tests results. We know students are in different places, we know they don’t all learn at the same pace. We say it’s ok to learn at different paces, BUT WE TEST THEM ALL THE SAME!!!! And then we shame students, teachers, and schools because on this one measure we didn’t do well.

Most teachers give their heart and soul to help their students be successful. But just like administrators, they simply do not have enough time in the day to do all that is asked of us. The “programs” that are purchased to “fix” the issues actually create more issues and take more time away from students. We take teachers out of the classroom to learn about this new program, to discuss our findings for that new program, and we leave students in the classroom with a substitute and a lesson plan to learn on their own, which by the way, took that teacher more time to prepare than if they had stayed in the classroom with a better lesson. We tell teachers to not take work home and care for themselves and then we tell them to create better lessons, find better resources, spend more time evaluating data, spend more time remediating students, but make sure you teach all of the standards and make sure all of our students are successful. Oh, and that list of non-academic things from earlier, make sure you are addressing all of that too.

I call it the hamster wheel. We keep running and chasing the goals and we just don’t get anywhere.

Is education broken? We are at a point where the requirements and expectations of public schools are more than can be accomplished. We know teachers don’t get paid enough. Yes, administrators get paid more, but what they deal with is unbelievable and they don’t get paid for what they deal with. Educators are going to continue to leave the profession and fewer and fewer students are going to choose education as a career because they see the stress teachers are under and the bullshit they deal with daily.

It’s time to stop the hamster wheel and reevaluate what education looks like in the United States. If we don’t, the system is going to implode, it’s going to FAIL in a miserable way leaving the US wondering what happened.

How do we fix it? I don’t know. Since government dictates a lot of what we do and government is also broken, we may not be able to find a solution. We are so divided as a nation on EVERY ISSUE, why should education be different? I don’t have a solution but I’m the type of person that wants to find a solution. This is why I’m frustrated and standing on my soapbox today! You have to talk about the issues to start fixing the issues.

As I step off my soapbox I want to say to my fellow educators, thank you for showing up every day and giving more of yourself than you have to give. And don’t feel bad if it gets to the point that you can’t do it anymore. Encourage each other and keep doing what you are doing until you can’t do it anymore. I’m not going to tell teachers to stay because students need you. I want to fix the situation so you want to stay! You are making a difference, even if the system is broken. If your test scores aren’t what they should be, ask yourself, “Did my students leave as better people than when they entered?” That should be our goal!

At the end of the day, we teach students, not subject matter. Take care of yourself, take care of your students, and let’s find a way to make our education system better. If you have a solution, I’m ready to talk about it!

Digital Escape Rooms, formative assessment, Geometry, Google Sheets, Self-Checking

Self-Checking Magic Squares Sheet

This tutorial is combining two ideas together that I have previously shared. This first is a Magic Squares sheet by Jason Pullano, and the other was a recent post about self-checking sheet. This activity is great for a self-checking activity or as a clue in a digital escape room.

Many of the steps are the same, so I am just reposting them below so you don’t have to flip screens.

Create your Questions

I find it’s easier to have my questions and images (if needed) ready to go before I begin building the spreadsheet.

I’m using this for a Geometry review so I’ve created my images in advance in a Google Slide and I changed the page size to the standard 4:3. I can download each card as a PNG or JPG image to use in my self-checking activity.

Create the image

This activity loads an image into squares one at a time as a correct answer is entered. You will need to decide how many squares you want. I went with a 4×4 grid.

I used Google Drawing. In page set-up I set the size to 10 x 10.

Once your image is designed, place a table on top of it and drag it to fill the screen. I learned this trick from Jason Pullano. The table creates a perfect grid and you don’t have to worry about placement of the lines.

Now you crop your image. There is more than one way to do this but I chose to use my snipping tool and just snip each section. I found it helpful to zoom in to get a good snip.

Open Sheets

Now we will put this all together.

I start with my blocks of information. I merged cells to create the sections for instructions, question images, and also to create my grid. By selecting columns G-J and right clicking, I can resize my columns to 99. Do the same for rows 2-3 and resize to 33. This should give us squares.

I just typed in my header this time, but you could always create a colorful header like we did the last time. If you create the header image, insert instructions are below.

Place images and answer in a new tab.

Click the plus button in the bottom left corner of your spreadsheet. This will create a new tab in Sheets. This will be the location for out images and answers.

Place the images (insert image) for the questions and for the square reveal. They can be VERY TINY. It’s ok. It will scale to fit the size we allow it.

We also want to place the answers to our questions here. We are going to hide the tab later so students don’t see it.

Dropdown menu

Start with the dropdown menu where you have the word instructions. Place the same words, Choose a Question, Question 1, etc. in your list. You can view a tutorial here.

Now right below that, you will enter a vlookup code.

=vlookup(A4,Sheet2!A1:B13,2,0)

This is telling sheets to see what word is selected in A4 (Choose a question, Question 1, etc., then go to sheet 2 and select the image that matches my words that are in column A starting at A1 and my images are in column B ending at B13.

Answers

Now let’s set the conditional formatting for our answers. There is a tutorial for conditional formatting in the link above as well.

I’m going to have three rules for each cell. If the cell is empty, I want it to be transparent. If the cell has an entry it will be gold for correct or red for incorrect.

It’s a little tricky to get conditional formatting from another sheet.

Here is what you would type in:

We will do the same thing to get a wrong answer but select text does not contain and type in the same formula and change the color to red.

Repeat for the remaining answers.

*This seems like a lot of work, but this process allows you to use this template again simply by changing the images and answers in Sheet 2.

Load Image

Now we need to load an image square. When an answer is correct, we want a square to load in an image space.

Below the fun stuff in Sheet 1, I have the sheet respond with 1 if an answer is correct and 0 if it’s incorrect using the following formula:

Once you return, there will be a little blue box in bottom right corner. You can drag that box down 10 spaces and it will auto fill the formula for you.

Choose a square you want to load. For this example, if the answer is correct it will go to sheet 2 and load the image in D1. You just need to make sure you load them in random order and that you include each one.

I have 16 boxes and only 12 questions so a few of my questions load to squares.


Clean it up and Assign

I like to hide the parts of the sheet we don’t need.

I’m going to highlight columns K-Z and right click and hide those cells

You can also hide the rows that have your adding trick on them by doing the same thing.

I’m also going to hide the sheet with my answers on it. Now a spreadsheet savvy student will now how to unhide this so you can always password protect the sheet so they can’t access it.

Don’t forget to set it to make a copy for every student in your LMS.

Here is the final result with all of the answers filled in:

These are so much fun. You can even get more advanced and have one image load and it changes to another image as you get the answer correct.

You can always just use the created spreadsheet below as a template if you don’t want to make your own. Just switch out the images and answers on Sheet 2.

If you make one, please let me know. I love to make these and my students love to complete these.

animated gif, Keynote, Stop Motion

Transparent Stop Motion

A few years ago, I posted about how to make Stop Motion animated GIFs using Google Slides and Tall Tweets. You can see that tutorial HERE.

Tall Tweets Update (not transparent)

Since that time, Tall Tweets has made some updates. So before I launch into how to make TRANSPARENT stop motion animations, let me show you the Tall Tweets update. Google Slides and Tall Tweets, as of this post, will not allow for transparent gifs. Maybe that is an update they can make soon (I did reach out on Twitter, so we’ll see if they can make it happen!). Tall Tweets did update with an add-on so you no longer have to go to the TallTweets site once you install.

Go to TallTweets and click Creator Studio (see image below). It will ask you to install.

Once installed, open a previous Stop Motion Google Slide or create a new one. When you are ready to create your animated GIF, go to add-ons and click Creator Studio. It will ask you to authorize the first time. Once you authorize, you will have to go to add-ons and click it again to make it run.

A panel will open on the right. Set your slide time. In Tall Tweets I started with .2 so that’s what I will try here.

Scroll to the bottom and click GO. You will have the option to download or view. You can view it to see if you need to adjust the time. When you are ready, click the download button and use the image like before. Notice that in Creator Studio you also have the option to make a video instead of a gif if you want to.

It’s a nice little update and added a few features. But sometimes you just need a transparent gif. I wanted to create a bubbling cauldron that I could use in an escape room but also in a presentation. I also wanted to create some googley eyes to use in a presentation. I created both in Keynote.

Keynote for Transparent GIFs

Open a new Keynote document and set the size you want. I like to make mine square but it can be any size. Go to document in the top right corner and change widescreen to custom size and change it to 500 pts by 500 pts.

Now create your animation, just like we did in Google Slides. Duplicate, change a little, duplicate, change a little,… Once your creation is ready, now we want to change the background to transparent. We don’t want to do this until the end because it turns black which is difficult to work on.

Under format (top right corner) switch background to no fill.

Your image will go from the first to the second.

If you have a lot of slides, you might want to make this change is slide layout, it will change all of the slides at once. If not, you can just change slide by slide.

Now we are ready to export our animation. Go to file, export to, animated GIF.

I choose these settings, but you can adjust the slider to make your gif work the way you want. I ended up sliding the slider to 3 for my cauldron. Also make sure you you start at slide one and include all of your slides. It will default to the one slide you are on.

Now you have a transparent image to use anywhere an animated gif can be used.

PowerPoint

PowerPoint will also export to an animated gif. I used to change my speed below one frame per second, but recently I haven’t been able to do this. This makes your animation SOOOO SLOOOOOW. For this reason I will no longer be able to recommend PowerPoint to make animated GIFS. If you know a work around for this, please let me know!!!!

I hope this helps you up your animated gif game! Please tag me on Twitter or Instagram if you make something! I LOVE LOVE LOVE to see them!

differentiation, Geometry, Google Sheets

Self-Checking Google Sheets

This is not the first self-checking Google Sheet tutorial I’ve shared. This is just ANOTHER example of what you can do with Google Sheets. You can see the Pixel Art tutorial here. I’ve learned a few new tricks since then and have improved the process making it harder for students to find the answers in the code. It’s still possible, just more difficult.

Create your Questions

I find it’s easier to have my questions and images (if needed) ready to go before I begin building the spreadsheet.

I’m using this for Angle Addition Postulate so I’ve created my images in advance in a Google Slide and I changed the page size to the standard 4:3. I can download each card as a PNG or JPG image to use in my self-checking activity.

Progress Bar

For this type of self-checking activity you can have a progress bar or progress circle to tell students how many they have correct. Or you can just have the number of correct answers in the corner. For this tutorial, I’m going to use the progress bar

I drew my own, just for fun, but you could create these in Google Drawing or Google Slides. You will need one image for each increase in the bar or circle.

Open Sheets

Now we will put this all together.

I start with my blocks of information.

I created my header in Google Drawing. I will insert the image in the cell.

Place images and answer in a new tab.

Click the plus button in the bottom left corner of your spreadsheet. This will create a new tab in Sheets. This will be the location for out images and answers.

Place the images (insert image) for the questions and for the progress bar. They can be VERY TINY. It’s ok. It will scale to fit the size we allow it.

We also want to place the answers to our questions here. We are going to hide the tab later so students don’t see it.

Dropdown menu

Start with the dropdown menu where you have the word instructions. Place the same words, Choose a Question, Question 1, etc. in your list. You can view a tutorial here.

Now right below that, you will enter a vlookup code.

=vlookup(A3,Sheet2!D1:E12,2,0)

This is telling sheets to see what word is selected in A2 (Choose a question, Question 1, etc., then go to sheet 2 and select the image that matches my words that are in column D starting at D1 and my images are in column E ending at E12.

Answers

Now let’s set the conditional formatting for our answers. There is a tutorial for conditional formatting in the link above as well.

I’m going to have three rules for each cell. If the cell is empty, I want it to be transparent. If the cell has an entry it will be green for correct or yellow for incorrect.

It’s a little tricky to get conditional formatting from another sheet.

Here is what you would type in:

We will do the same thing to get a wrong answer but select text does not contain and type in the same formula and change the color to yellow.

Repeat for the remaining answers.

*This seems like a lot of work, but this process allows you to use this template again simply by changing the images and answers in Sheet 2.

Progress Bar

Now we need to add the progress bar. When an answer turns green, we want the progress bar to advance. Basically, you are adding the amount of correct answers together and telling the progress bar to load an image based on the number of correct answers.

I have the number of correct answers add somewhere hidden on sheet 1 (below or to the right of the current content) using the following formula:

Once you return, there will be a little blue box in bottom right corner. You can drag that box down 10 spaces and it will auto fill the formula for you.

Now we will add the columns. We will use this sum to load the correct images. I will hide these rows (or columns) later so students don’t see it.

Usually the =sum feature will work but for some reason it didn’t, so I just added each cell.

In the cell where the progress bar goes, we are going to use that same vlookup that we used earlier to load the correct image:


Clean it up and Assign

I like to hide the parts of the sheet we don’t need.

I’m going to highlight D=Z and right click and hide those cells

You can also hide the rows that have your adding trick on them by doing the same thing.

I’m also going to hide the sheet with my answers on it. Now a spreadsheet savvy student will now how to unhide this so you can always password protect the sheet so they can’t access it.

Don’t forget to set it to make a copy for every student in your LMS.

Whew! That was a lot of work! Here is your final product. You also now have a template to use if you want to create future projects. You can change out the progress bar, the questions, and the answers in Sheet 2. Yay!

I hope you find use for this tutorial. I know you can buy other templates like this on TPT, so if that’s how you roll, head on over to TPT. I personally like to create my own. It did take quite a bit of time, but now that the template is created, I can change it up with minimal effort.

And, because I’m nice, here is my completed activity if you want to use it as a template.

Spreadsheet

Slides with questions

Classroom Decor

Classroom Decor

I went to my classroom this week to put my desks in #thinkingclassroom pods and to organize a bit. I still don’t have much up on my walls from the great black mold purge of 2020 so I decided to make a few things. Since I made them, I’m free to share them.

I made 3 BIG quotes to put on my walls near the ceiling. One is a quote you’ve seen often if you visit my Make Math Not Suck site. It’s sums up my belief in learning well.

“Education is not the learning of facts, but the training of the mind to think.” – Albert Einstein

The next quote is to replace a quote that was on my wall for years. I had a giant Albus Dumbledore poster with this quote next to it. My son had the poster remade for me as a Christmas gift (the original not survive the great black mold purge of 2020) and I’m just getting around to making the quote again.

“It is not our abilities that show what we truly are, it is our choices.” – Albus Dumbledore

And the last one I put on the wall is from Eleanor Roosevelt, but I may change it to Maya Angelou. Still not sure about this last one.

“Great minds discuss ideas. Average minds discuss events. Small minds discuss people.” -Eleanor Roosevelt

“Do the best you can until you know better. When you know better, do better.” – Maya Angelou

This last one hasn’t been created yet, but I love the quote and hope to find a place for it in my room if I don’t replace the Eleanor Roosevelt one.

Here is a link to PDFs of each of these quotes. I created them in PowerPoint because I had a specific font I wanted to use and I wanted a pattern fill. You could easily make these in Google Slides if you want solid colors or gradients. I printed, laminated, and cut them out. I do own a cutting machine, but sometimes its faster to cut by hand.

To Create Custom Letters in PowerPoint

  1. Open PowerPoint and go to the Design Tab. In Slide Size, set your page to 11×8.5

2. I used word art, but you can also just use a text box. Type in the letter you want. I set my size to 600 px. Pick the size that fits your space. I used 3 fonts from dafont.com. The KG font series is one of my favorites but I recently found the KB series too.

3. I open the format pane so I can get all the options in one place.

I upload my pattern and select tile picture as textue.
I add the border using a solid line. I set my border to 10 pt but select what looks best.

Here are some patterns I created that you can use for free. This link takes you to a folder with all of them.

I also made some cute little labels for my whiteboard. I laminated them at school and put magnets on the back.

I made these in Google Slides. You can update the words to fit your needs. Click here for template.