Add Events from Google Sheets to Google Calendar Automatically from Thom Gibson

If you have a spreadsheet of your assignments for your students, then have all of the assignments automatically added to a Google Calendar, this post is for you!  This post will also help those who have MANY dates they need to enter onto a calendar at one time.

As a mom of three teenaged boys, I have many, many sporting events to attend this fall, 49 in all.  The though of adding ALL of these events to our family calendar was daunting, so I decided that I wanted to try to automate it all.  Yes, this took much longer the first time as I had to figure it all out.  But it was worth it as I’ve since used this method to add other events, en masse, to my google calendar.  So, it has saved me tons of time!  I’m blogging about it so I won’t forget how to do it the NEXT time (lol) and so you can try it too if you want!  I’m a newbie, so I probably won’t be able to answer technical questions if you decide to try it out.

I first tried a Google add on, but the creator was in Paris, so it took me hours to figure it out.  Then Thom Gibson tweeted me, so I used his script and it was much easier!  This is the one I will use from now on. Thank you Thom!  🙂

To learn how to add Google Calendar events from a Google Sheet, watch Thom’s video.


  1. Spreadsheet: You will need to copy his Google spreadsheet to get the FormMULE script.
  2. Permissions:  You will need to permit Google to let you use this.  It will say it’s unsafe bc it isn’t a Google Add on.
  3. Date Time:
    1. Be sure your cell is formatted in the Date Time format if it is not an all day event so you can add the start time.  Screen Shot 2018-09-01 at 2.27.04 PM
    2. I used the same end time as the start time.
  4. Updates:  There is a way to update it the calendar, but there is a different Update video.

Have fun!

Supporting Students – Homework

As I teach an accelerated math class, I feel that a small amount of homework is crucial for success for my students (and, not just “doing” homework, but doing it well).  I got closer to being happy with my homework system this year, but it still took too much time for me to  check and especially to record.

What I did this year:

  • Published solutions – This goes first because it is KEY and so amazing.  I published fully worked out solutions to homework every day by 3PM.  I encouraged students to check homework AS THEY WORKED instead of afterwards.  No-one learns well when they are practicing incorrectly.
  • Required students to check their completed homework against my solutions and mark the ones they missed or did not understand with a different colored pencil.  Kids really did this at the beginning of the year.  It made such a difference.  They knew which ones they had missed and we hit the ground running everyday.
  • Assigned a manageable amount of homework.  I aim for no more than 30 minutes each night.
  • “Lagged” the homework.  I assigned previous material each night and starter homework (easy, skills based) on new topics.  I only assigned tougher questions after we had been working with the material a couple of days.  This way there was no pressure to finish my lesson so they could do the homework.  Also, students didn’t complain as much about not understanding how to do the homework.
  • Checked the homework each day, 2 points per assignment, 1 point for incomplete homework.
  • Entered the grades in the grade book once a week.

What did not go well is that checking homework took up too much of my class time.  I walk around with my grade book, stop at each child, look at their homework, then take time to record the grade in my gradebook.  And, after Christmas I did not do a great job of checking it everyday.  As a result, many students stopped doing it.

Additionally, some students never checked their solutions online.  They did their homework as fast as possible, just to get the credit.  They had zero idea if they were doing it right.  They did not care if it was correct, as long as it was “complete”.  This did not help them and wasted my time looking at their barely complete work day after day, trying to decipher if they had actually done it or were just scribbling anything down.  This has to stop.

I loved Amy’s post about accountability.  And even though I hate taking the time, if I really want students to be accountable, I need to make sure they are actually doing their homework well, and be more systematic about checking it.  I also loved how Julia is planning to check homework next year.

Next Year:

So, here is what I am planning for next year.   I am still working on it though and any thoughts or ideas would be greatly appreciated.

My biggest change is that I am going to have students keep a Homework Journal.  I will require every student to do every homework assignment (even Delta Math problem sets) in a graphing composition book.

  • Lagging Homework and publishing the answers as I did last year.
  • Require students to check answers and mark ones they did incorrectly with a different color pen/pencil.
  • Homework Journal – Students will do all of their homework in a graphing composition book.  The only thing in this book will be homework.  Our calc teacher does this and loves it.  He talks about it all of the time so I have to try it next year.  He calls it a journal and encourages them to write in it.  He tells them to write what did they not understand, what questions they have, and so on.  I could even have them write about how well they felt they understood each assignment.  I do a red/yellow/green for each assessment and think this may be valuable for the homework assignments as well.
  • I will have a section in the back of the journal for their weekly Delta Math problem sets.  I want students working these problems out (and Photo-math is a problem).  Hopefully this will help with both things.  This will make it take longer to do some sets, so I will assign less problems per set.
  • Incorporate “Criteria for Credit” to illustrate to students what a well done math assignment should look like.  A teacher at my school has the students create and then follow this criteria at the beginning of the year.  It is great and I am going to adopt it.  I have also talked her into guest blogging about it now that school is out!
  • From Julia – Each day I will circle any questions they did not fully and correctly complete with a red pen.  I will walk around the room and do this, I will not take them up.
  • Students are encouraged to complete circled problems ( to earn partial credit) before the homework journal is graded.
  • On quiz/test day (or about once every week), I will take the journals up and grade them.  I will take off full credit for every problem not completed, and give half-credit back for any completed circled problems (problems that were incomplete before).
  • Absent students would need to write down each assignment in the book, and ideally complete them before taking any assessments.  I would like to check this, but it may be too hard to keep up with.

Last year I walked around recording their homework scores as I went around the room on my grade sheet.  This is such a pain.  It takes time to look at the work, then time to put a grade down.  And I don’t even mark on their paper.  With Julia’s new system,  I can just walk around the room circling without having to record anything.  So checking homework each day should go much faster.  Then I can take the time once  a week to get the grades down.  And, since incomplete homework is already circled, it should not take long to grade (hopefully).

I love the idea of homework quizzes, but I don’t know if I would keep this up.  Making, distributing, grading, and recording a quiz takes a ton of work, even if it is online.  And I don’t want to create more work for myself.

I am hoping that more work setting things up at the beginning of the year will make the rest of the year easier.


First Day with Make It Stick, Jo Boaler, and Plickers

I want students to be less stressed before math tests.  I do not want them cramming the day before, asking me how to do every review problem because they have already forgotten, then asking me for more review problems to work.  I want students to connect the ideas not only of the current unit, but of the previous math ideas that are also incorporated into the current material.  I would love if students saw math as connected ideas, rather than “a long list of procedures” to be memorized.  I want students to learn conceptually, not procedurally.

This is tough to accomplish, as many of their math classes have been taught procedurally.  I used to think that they would be so happy to have me as their teacher!  I throw the rules of math class out of the window, and help them discover concepts on their own!  However, I found last year that this was not the case with many of my students.  Many were uncomfortable with the fact that I was disrupting their flow.  These honors math students have been successful for many, many years learning the formulas and practicing, practicing, practicing until it was perfect.  And their grade was perfect.  They didn’t want to struggle to “discover the formula”.  Struggling and not knowing make them feel insecure.  Instead, they wanted the formula right away – so they could have more time to learn it, practice it, and get a jump start on tonight’s homework!  They did not want me wasting their time.  I kept telling them this was not the best way, but they did not believe me.  So instead of telling them this year, I am going to have them read the research for themselves.

For the first day this year, the students will enter the room and then write their thoughts to these questions. (questions are a work in progress)

  1. What is math?
  2. Finish these sentences:
    1. The people that are the best math students….
    2. The best way to learn a new math concept is to…
  3. How do you study for a math test?

I will then give them a Plickers survey to find out their thoughts on math as a class. I use Plickers the first day because a few students will not have their technology ready. Screen Shot 2015-08-08 at 8.46.54 AM

We will briefly discuss their answers and then I am going to show them this four minute video by Jo Boaler.

Screen Shot 2015-08-08 at 8.47.21 AM

I need to ask them to write after seeing this video.  I’m still working on that and would love any thoughts or suggestions.

For homework, I am going to have them read excerpts from Make It Stick, The Science of Successful Learning by Peter C. Brown.

This fabulous book talks about how people learn, and what you can do to make learning stick.  It is full of real life examples and specific strategies.  The ideas and strategies are summarized in one of the last chapters of the book.  After having them write and discuss how they think they learn best, I am going to have my students read some excerpts of this chapter, then discuss it as a class.  This should benefit them not only in math class, but in most of their other classes as well.

The next day in class, students will pick out what they felt was the most important ideas from the reading and share them.  From this, they will decide on a learning goal for the year.  I then had them fill out  a Google Form to record their “one thing” they wanted to try from “Make It Stick”.


I will keep doing discovery and conceptual learning in my classes.  I am also replacing “massed practice” with interleaving practice and lagging homework this year.  I am hopeful that having knowledge about how people learn will open their minds to this new style of homework.  Winning over their mindset is half the battle!

This is all still a work in progress!  And if you want to join in on the planning, I’d love to have you!  I will also be talking about my first day plan at the Global Math Department Webinar this Tuesday evening at 9pm EST.  Please join in the conversation!  I hope to have it more polished by then, as I start school August 17th!

Screen Shot 2015-08-08 at 8.47.46 AM

Julie Reulbach

The Files:

The amazing Meg Craig made a booklet foldable that is the entire activity in one!    I love collaboration!  (I pretty much copied hers for my one sheet).  🙂
Screen Shot 2015-08-10 at 7.25.06 PM

Print Your Own Homework Passes – #myFavFriday

Screen Shot 2013-08-15 at 4.17.05 PM


Last year I created, laminated, and then cut out homework passes to give out for a Halloween treat instead of candy.  I intended to do this for Christmas as well, but it was so much work that I never got around to making anymore.  I hate laminating and cutting things out.  But, I did all of this work because I thought, “Once they turn them in, I can use them again!”  This did not work!  Some kids lost or did not use them.  Many of the ones that came back had been stored in their pencil cases and were pretty banged up or kinda – gross.  Plus, without names on them I sometimes forgot who had given them to me.  Yikes!  So, this summer, I got smarter!

I bought a pack of Avery Business Cards for just $8.79.  It has 250 cards in it!  Then, I just printed homework passes on them.  These cards were already precut, so I just had to break them apart.  This was effortless as they pretty much fell right apart.  I found a really cute font here.  I will have each student write their name on it when I give it to them.  I’m hoping this will work better!  They were about one hundred times easier for me to make!

I designed mine in Word.  I wanted them short and simple so I wouldn’t use up too much precious printer ink.  I did a Happy Birthday one bc I think that no one should have to do any work on their birthday!  And, it’s a pretty cheap gift for me to give out.  Here is the pdf if you just want to download it and print your own without having to design it.

Happy Birthday HW Pass


To Grade or Not To Grade: Homework in Math Class

Click here to submit your MS Sunday Funday post!


Next week:  Blog about Spiraling Review from Past Math Topics

I Just Can’t Grade Homework

My homework LIFESAVER this year has been my “No Homework – Responsibility Notebook“.  Students who do not do their homework sign this binder.  Every time they sign it deducts 2 points from their trimester homework grade.  It’s so easy to keep up with and the students now know to just go and sign it when they come in class.  It is zero maintenance for me!  I do not “grade” homework right or wrong, but they do get a trimester  grade for homework.

  • I usually assign about 10-20 minutes of homework a night, Monday – Thursdays.
  • I do not give homework on the weekends, but do expect students that are behind to spend some time catching up.
  • I give students the answers to their homework before they do it.  I expect them to check each answer as they work, so they don’t do 15 practice problems incorrectly.
  • The homework is always easier than the work we do in class.  I do not want them to struggle at home where I can’t help them.  I just want to reaffirm the main ideas in class.
  • I have created Concept Help Pages for students to go if they are confused.  If they email me and then work on these pages I do require them to have completed homework.  In this case they must come visit me before school for extra help.
  • I do not collect and grade homework.  I would rather spend my time planning engaging lessons!
  • Each day I walk around and really examine everyone’s homework while they do the warm-up.  I sometimes make students redo it.
  • I do not grade their answers right or wrong since I give them the answers in advance.
  • Students who do not complete their homework must sign the “No Homework – Responsibility Notebook“.  This deducts 2 points from their trimester homework grade.
  • About half-way through the year I have an increasing number of 7th graders that start skipping their homework.  This year I started having them come in at lunch to complete it.  Next year, I am going to put this rule into effect day one.

I think independent practice is so important in math.  Especially since our classes are 50 minutes long.  Since I do many discovery lessons, we barely have time to get to the main ideas much less give them time to practice enough.  Their homework score adds up to a major test grade.  Next year I am going to reduce it’s worth however to equal a quiz grade.  I would also like my students to do their homework more “neatly” next year but I haven’t figured out how to frame that yet.

I actually switched up homework this week in 7th and it was a nightmare.  I did not give them the answers and I we checked it together.  I had them mark what they missed and then I collected it so I could look at it.  So now I have 5 giants stacks of “graded” homework on my desk that I have barely glanced at.  I don’t know how teachers that actually grade homework get it all done!

Differentiating Math Homework

Click here to submit your MS Sunday Funday post!


Next week will be:  Post Your “Official” Lessons Plans That Were Used for Observation

We have blogged about Homework Policies before in MS Sunday Funday, but this week I wanted to focus on differentiated homework.  I found some great posts about homework in my Google Reader this week so I am adding these here as well!  Additionally, Sam Shah surveyed teachers about homework a couple of years back that I analyzed and summarized in this post.  Those results changed my thoughts about grading homework – and I’ve never looked back!  Thanks for great posts about homework.

Homework Choice Allows Differentiation and Encourages Creativity

Listen to me present this live at Global Math (recording will be up 2/6/13).

I have recently started offering “choice” homework assignments – and my students LOVE them.  Last week in a survey, many of them said that they loved working on the choice assignments and requested to do more of them.


For the choice assignment, students can do traditional homework (workbook problems only) OR they can do half of the workbook problems and then create their own word problem (with solution) based on that concept.  They can write their problem on paper or create a Google Document and share it with me.

The next day, I have the students work each other’s problems in class.  The students like to share their fun problem.  Plus, they help each other solve their problems when they get stuck or have a question.  It is also great because sometimes they find mistakes in a problem and will help that person understand what they did wrong.  They love working each other problems and teaching (and helping) each other.  I walk around the room looking at their problems and helping as needed.

Choice assignments are automatically differentiated.  Students having trouble with a concept often chose to do the workbook problems so they can check their answers.  Most students who make up problems create ones that are similar to ones that we have done in class.  However, some students make up more difficult problems or go above and beyond with their creativity.

IMG_4702 IMG_4701 IMG_4722

They are having so much fun making up their own math word problems – and spending so much more time thinking about math.  Students usually dread working word problems but when they are creating their own and solving their friends problems they love them!  I love how excited they are about their math homework and that they have asked me if they can do more choice assignments in the future.  Another benefit for me is that I can use their problems in the future for subsequent classes.  My students are creating creative and engaging word problems for future students!

Here are some examples of the work they have created.

The No Homework, “Responsibility Binder”

The homework discussion came up over and over at #TMC12. No one is totally happy with their system, but here were some common themes.

We were all more concerned that students attempted the problems.  Several of us give the students the answers when assigning homework.  I’m in this category. I like them to check their answers as they work so they know when if they are doing it correctly.  It also allows me to tell them that I all already know the answer, I want to see HOW they came up with that answer.

As they already have the answers,  I do not grade homework. I just check it for completion as they are doing a “bell ringer” activity. For their grade, I start them out with 50 points at the beginning of the trimester and dock then two points everytime they miss an assignment. For most kids, this is a real grade booster as 50 points is equivalent to a test grade in my class.

Last year, I saw an amazing Student Responsibility Card on Hedge’s blog.  I totally stole it, but but made it into a half page to save paper and made it YELLOW.  Then, I had students fill out this yellow slip when they didn’t do their homework.  This was a great idea, as I never had to “record” who didn’t do their homework.  I just collected the yellow sheets and then recorded it at the end of the trimester. This took almost no time and was a record, in their own handwriting, of who had not done their work.  The biggest problem was that I just stacked these in a pile and didn’t really look at them until the end of the trimester.  So, unless a student was very obvious (no homework several times in a week), I missed accumulating homework incompletion.

My second problem was that I thought that filling out yellow sheets would thwart most of my errant homework kids, but it did not.  Seventh graders can be quite persistent, and homework incompletion was no exception.

In a discussion with Sean Sweeny at the airport (yes, we were all still talking math right up until we got on the plane), he told me that if one of his students doesn’t do their homework they have to stay after school or to do a study hall to make it up. I believe he said that this was a school wide policy. Sean said that this was pretty effective in getting the kids to do homework on the night it was assigned.  They knew they had to do it anyway, and no one wants to sit after school doing homework.  So, his students were pretty good about doing their homework.

This year I would like to do something similar, but more organized. And, I would like to make the students more accountable for completion of their homework.  My fabulous director always says that if we are assigning homework, then it should be important enough for every student to complete.

After seeing this great idea on Pinterest from Leslie at Jack of all Trades, I made a no homework binder.  I call it a “Responsibility Binder”.  I still want students to fill out a sheet when they don’t do their homework. It was so valuable to see their reason WHY they didn’t do their homework in their own words.   But instead of loose half sheets, it will be organized alphabetically in a binder.  Another improvement is going to be the addition of a “date completed” column on this sheet.  I want to give the students ownership over completing their homework.

Even if students don’t do their homework initially, they will still be required to complete it.  And this should be an easy way to have the student keep track of it. If they don’t complete two or three in a row, I’ll intervene.

There has been much discussion on Twitter about having an electronic GDoc Form that students filled out when they did not do their homework.  I really liked this but I can’t make it work because I want students to go back and fill in the date when the homework is completed.  I don’t want them to have access to the GDoc as they could change it, or get confused about which column to write it in.  I could have them fill out another GDoc when they complete their homework but I’m afraid they won’t be able to keep up with this.  I am thinking that a hard copy record in a binder is going to work best for me right now.  I am still working on this in my mind however because I do love all things electronic.
Here is my proposed sheet. I would love any suggestions!

Read other #made4math posts here!

Google Spreadsheet and the Wiki for Assigning Homework

I used to keep a plan book.  It was ok.  But, I never actually wrote my plans in it bc those squares were too small.  I just wrote down the lesson title and the homework assignment.   As I got busy, I would often forget to write things down it in.  Especially when I made changes in assignments.  The plan book was one more thing to keep up with and drag back and forth to school every day.  The idea was to use the plan book for the next year as a guide.  But I did not refer to it as often as I should have (only about once a unit) because then I would have to take TWO plan books (one for last year and this year) home every night.

Now, I’m all electronic when I plan.  I made a Google Spreadsheet that lists the date, lesson, homework, and any important links the students will need.  I love this way of giving homework, because then students can easily find the links I want them to access.

I then embedded it into my class wiki.  I only embed one week at a time so my students won’t get confused when looking at the whole document.  (It is blank right now because I still haven’t planned week 1 for this year yet – ACK!)

At the bottom, I provide a “6th Math Archives Page” link so absent students can refer back to the previous week(s).

To make things easier for me when updating and going to a new week, I have two separate tabs in the GDoc spreadsheet.   One is the current week and the other is the archive page.

I put the current week’s assignments into the 6th and 7th tabs.  These are the tabs that I had embedded into the class wiki.  6th 2011 is the entire year and it is what I use for the archives.  I start a new tab for each year (you can see the 6th 2010 and the 7th 2010 from two years ago).  This way I have a record of multiple years of plans and homework all in one place.

Read about other teacher’s Favorite Fridays here!