Skip to main content

Calendars, the first five of two

As we continue to prepare for the coming academic year (we don't start classes until the week after Labour Day) I've begun to prepare the data for the Faculty.

One of the introductions last year was the "Duty Calendar" -- who does residential duty each night, both faculty and prefects (student leaders).  In the past, it was stored in five different spreadsheets, one for each house and then one for the entire campus (since on weekends, faculty members are assigned to the campus rather than specific houses during the day Saturday & Sunday).  No one from other houses knew who was doing duty in any other house and if swaps were made, folks were never really sure that the change had been made.  Now, although the data starts out on a spreadsheet (I configure a spreadsheet for the House Directors) it is then copy-and-pasted into a Sharepoint Calendar.  3 clicks and 2 key-presses for each spreadsheet and the information is available to all.

To be precise, it is pasted into five calendars, one for each house and one for the campus and then they are merged (using Sharepoint's Calendar Overlay) into one calendar. This has made the information visible to people that need it but also available to other applications on our system.  Faculty can now see who is on duty in each house and this information is fed into our weekly (printed) residential duty sheets.  Any changes are automatically updated and reflected on the calendars.  And, like all the other Sharepoint calendars, the House Directors can link their house's calendar into their own Outlook calendar so they know who is on duty each day without having to visit Sharepoint.



[Since I'm beginning a new academic year, and a new job, I'm re-starting blogging today, August 1st, and do my best to reflect, or at least comment on, something I've encountered each day.]
Post a Comment

Popular posts from this blog

Teacher Professional Development and Microsoft OneNote

During the first three weeks of July, I have the amazing opportunity to work at the Park City Mathematics Institute.  It is, without exaggeration, the best professional development opportunity for teachers of mathematics.  Participants spend three weeks thinking deeply about mathematics and mathematics education.

There are three main aspects of PCMI:

learning mathematicsreflection on practice (RoP)becoming a resource to others.I'm part of the team for RoP and in charge of the third aspect, in which participants consider a gap in professional development back at their home districts and work in small groups to help fill that hole by developing a rich PD seminar on that topic.

It is not easy to develop professional development.  Teachers who haven't written PD have to patiently learn how to write (essentially) lesson plans for someone else.

This year, I used Microsoft OneNote to facilitate the process.  We have a central OneNote Notebook through which I lay out the daily schedule…

Five reasons to learn Math with OneNote

So, Alice Keeler - @alicekeeler- who is an amazing blogger and an incredible resource for those using Google products, posted 60 Ways Math Teachers can use Google Classroom last April.  It came across my desk the other day and, since school hadn't started yet, I thought it might be a good reflection for me on how one could do similar tasks with OneNote Class Notebook.

I went through the list and checked that I could accomplish them all with OneNote and re-wrote her post with those modifications ... but it was looking a little "plagiarism-y" so, just to check, I emailed Alice to see if she was okay with it.  She was not, but encouraged me to do my own brainstorming.
So... Math Teachers & OneNote (including OneNote Class Notebook).  My top five... 
1) The Under-valued value of scribbles & notation
If you really want to be "paperless" (and that should never be a goal - you want to be digital so that content is no-cost) in a mathematics classroom, it's n…

Auto-Grading an Office365 Excel Survey Assessment

So it's pretty common that folks use Google Forms to create an automatically graded assessment.  Now, I have to admit, as a mathematics teacher I don't do a lot of fixed-response assessments like this that need automatic grading.  But that doesn't mean it isn't a useful option.

In fact this post arises not from automatic grading but rather a situation in our Psychology course.  The teachers were doing a study with their students and wanted to collect the data easily and run a T-Test with as little work as possible.  (A t-test, roughly speaking, determines whether two groups are different from each other.)

We set up an Excel Survey for the students to enter their results and then in a second sheet in the spreadsheet containing the Survey, we laid out the T-Test.  As the results came in, the T-Test continually re-evaluated.  Success!

I figured if it can work for a T-Test, it can work for a simple multiple-choice, True/False or simple word response. So I head over to my O…