Coordinate PracticeI am always looking for ways that students can create to demonstrate their understanding of a concept or skill. To level up the creation process, I also strive to empower students to collaborate with each other. What do I mean by this? I strongly believe students are born with a knack for creating, tinkering and hacking. Unfortunately, the traditional model of learning is driven by consumption and regurgitation of information. Why not have students create something that not only demonstrates their understanding, but also creates a challenge for their peers to solve? Students are exploring coordinates in math. In an effort to allow students an opportunity to showcase their understanding of coordinates, I thought of Alice Keeler's Pixel Art Google Sheet Template. Her template uses conditional formatting to change cell colors. This got me thinking about the idea of a hidden picture that would be revealed if coordinates were successfully marked. The picture below represents the hidden smiley face that I created. I numbered the cells in column A from 20 back to 0. The cells in row 21 are numbered from 0 up to 20. A key of coordinate pairs is provided for students to type an "x" which in turn changes the specified cell to the color black. If done correctly, the hidden picture will be revealed. Student as Creators and CollaboratorsWhile the hidden smiley face is a challenge for all my 5th graders, it also serves as an introduction to designing their very own. After they have explored the hidden smiley face, they will be using Google Sheets to create their very own hidden picture. They will use this paper template to plot their hidden picture. Once they have it plotted on paper, they will then move onto creating their Google Sheet version with conditional formatting. Check out the video below for a quick tutorial. Once students complete their Google Sheet version of their hidden picture, they are going to change the sharing permissions so that anyone with the link can view it. They will copy this link and share it to a Google Form. However, they will change the end of the URL to "copy" so that whoever clicks the link will be forced to make a copy of the Sheet. I will share the submissions to the Google Form with the students.This will allow students to try and solve the hidden picture challenges that their classmates created. Level UpStudents can get really creative with this challenge. You can set multiple conditional formatting rules. I wonder how many students might add multiple colors to their hidden pictures to add even more layers of detail. I could have changed the conditional formatting on my smiley face so that the cells representing the eyes would change to blue instead of black. The nose could have stay black, but the mouth could have been changed to red. I am excited to see what my students come up with. #coordinatechallengeIf you have students that create their own hidden picture challenges with conditional formatting in Google Sheets, have them share their URL on twitter with the hashtag: #coordinatechallenge
Make sure they change the end of the URL to copy so that it forces users to make a copy of the #coordinatechallenge Below is a sample. Change the red portion to the word copy. ...................0XLbCGTXWzEECT7nSOycbLzIGizdzxGt74/edit?usp=sharing ...................0XLbCGTXWzEECT7nSOycbLzIGizdzxGt74/copy
0 Comments
|
Andrew FenstermakerInstructional Technology Coordinator | Innovation Coach | Google Certified Innovator | Presenter | Blogger | Adjunct @UiowaEducation | Owner @kids_f_i_r_s_t |