Friday, March 30, 2018

Make the most of your data


Using Conditional Formatting with your classroom data

You probably collect so much data in your classroom and you don't even realize it.  It could simply be assignments grades or surveys that you have students fill out or something more complex.  If you do any of this electronically you will most likely have an Excel spreadsheet or Google Sheet.  When you have data in this file type there is so much you can do with it!  I think that Excel is one of the least understood program out there and it can really do so much (I'm trying to convince my students of this now!).

One of the great things you can do with a spreadsheet is to use conditional formatting.  This allows you to change the look (formatting) of a cell based on its content.  One easy way to use this is to color code your gradebook.  I set up conditional formatting in my gradebook so that all kids who were failing would show up in red, those one the boarder line (which I determined to be 65-75) show up in yellow and those doing fine (over 75) to show up in green.  There are so many different ways to use conditional formatting.  What's one way you think you can use it in your classroom?

If you want see more details on how to do this, check out this blog post by Alice Keeler.

Saturday, March 10, 2018

Opportunities for NYS Teachers

I often get opportunities for technology pilots for New York State teachers.  If you are a teacher in NYS and would like to be notified of these pilots, please click this link to join an e-mail list I am forming to share these opportunities.

If you have any questions, please feel free to send me an e-mail.

Wednesday, January 24, 2018

Quickly Summarize a Passage of Text

SummarizeThis is a website that will summarize the main point(s) of articles and passages.  All you need to do is to paste in a block of text and a summary will be generated.  This can be helpful when students are doing a research paper and want to know if a specific article will be relevant.  It can be a great time saver so that you don't have to read a long passage only to find that it's not relevant to what you need.


Friday, December 22, 2017

Getting Started with OneNote

For the past year I have been at a Microsoft School.  One of my jobs is teaching students and teachers how to use OneNote.  OneNote is the digital binder system that we use.  It can be difficult when you have many teachers who are at different technology levels.  I always like to provide something for the teachers to do on their own after they leave the pd.  I found this post by a fellow tech coach named Stephanie Elliot with 8 tasks to help you use OneNote.

Click on the image below to be brought to Stephanie's post.
https://www.smore.com/r3zmh-getting-started-with-one-note

Monday, December 11, 2017

Online planning just got easier


I have talked before about different websites that have online planbooks, but I just came across another site and I love it!  The first reason I love it is the it's FREE!  Plus, it's very simple to use, looks appealing and makes it very easy to adjust plans and move them in case of events like snow days or sick days and lastly allows you to copy over plans from previous years.  Did I mention that it's free?!?  To me, it reminds me of PlanbookEdu, but the premium features you have to pay for with them are free with this site.  What is this site you ask?  It's called Planboard.


Honestly, the best thing that you can do is to play around with it yourself, but just so you know a few things about it let me share some for you. 

  • Set your rotation schedule from daily up to six day cycles
  • Create a timetable (that is color coded) for the various classes that you teach and the sections of each
  • Lesson templates can be set up so that every time you go to type in a lesson a template is already there for you to fill out
  • You can easily collaborate with colleagues to share plans
  • It is easy to add in off days for school holidays and vacations
  • You can easily shift plans forward a day for things like snow days.  Nothing gets lost, everything just moves a day forward
  • Attach documents from your computer or Google Drive
  • Copy some or all of your plans over to the following year
  • Attach standards
What do you like to use for your planning?  Do you think you'll check out Planboard? 

Monday, November 27, 2017

Individual student feedback in Google Forms

Google is always listening to feedback from teachers on how we can better use their tools in our classrooms.  One change Google had made is the addition of individual feedback in Google Forms.

Once you are in a Google Form, click on Responses and the Individual.  When on an individual's responses you can grade questions and assign points.  Under the answer, there will be something that says Add individual feedback.  Enter your feedback and click save.  Be sure to click save once more before you exit and you can then proceed to e-mail scores and feedback to the students.

How do you provide feedback to your students?