Thursday, May 16, 2019

Did You Know? Numbers is More Than a Spreadsheet!

I'm taking some time to take a closer look to options available in Numbers and how these can be used within a classroom.  I ❤️having multiple tabs to have lots of information all housed in one document.  But what about the tables?  Did you realized you can delete a table and Numbers becomes a whiteboard that goes on and on and on?  Well, maybe not that far, but you get my point!  A blank space to start creating!  Combine a blank space with smaller tables for a specific purpose and you have a winner in my opinion! 

Not sure what I'm talking about yet?  Let's discuss about a couple of examples.  For starters, I like to have lists so I know exactly what I need to do.  And I love when there is a checkbox with the list so I can check it off when the deed is done!  Did you know you can create your own checklists in Numbers?  For example, you can have a list of steps where learners can track their progress throughout a learning experience. Or, maybe the table becomes a Choice Board and learners are given a variety of options and must checkoff a certain number of options.  I bet you can think of ways you could incorporate checkboxes on a document.

Then there is the Star Rating option.  In the example, I have included in the video below the Star Rating is part of the Peer Feedback portion of a project.  I have created a table so there is a pre determined number of peers to interact with to gather feedback.  In this case, the document would be shared with these learners and the learner would record their thoughts.  The 3rd column is what makes this part unique.  By adding a Star Rating you are allowing the learner who is receiving the feedback to rate how helpful the feedback is to improving the product.  Imagine how this could help learners grow in how they give feedback!


There is also a Slider option!  By using this option the creator can set the range of numbers to be applied to the slider.  In the video example below I used a rubric for setting up the slider.  I then set the final cell to calculate the sum from the different categories.  The total is then automatically calculated for me!  This particular idea could be used for self-assessment of learning.  What other ways can you think of to use a slider?

Watch this video to see how to use these 3 different cell formatting options in Numbers.


Which option do you want to try in your next lesson design?


No comments:

Post a Comment