This page contains my portfolio of work for EDMT632, part of my coursework for the Educational Media & Technology graduate program at Eastern Michigan University.

The focus of EDMT632 is on advanced productivity tools for education. As such, the links below are organized according to the category of productivity tool into which they fall.

Word Processing

  • Apple Pages: Raspberry Pi Computing paper

    I wrote a lengthy article for submission in the MACUL journal using Apple’s Pages software (part of the iWork suite). This article will be submitted to the MACUL journal, and a presentation based on the topics raised in the paper has already been accepted for presentation at the 2014 MACUL conference in Grand Rapids, Michigan.

    You can download this as PDF file [KB] or a ZIP file containing the original Pages document [KB].

  • Apple Pages: About Me overview

    Using Pages I created a one-page overview which briefly described me, my skills using productivity software, and my goals for the course.

    You can download this as a PDF file [121KB] or a ZIP file containing the original Pages document [247KB].

  • Google Docs: Honey Creek 2012-2015 Technology Plan

    As the Technology Specialist for Honey Creek Community School, I am responsible for creating and submitting the school’s 3-year technology plan to the State of Michigan’s Department of Education. For the 2012-2015 technology plan, I assembled a group of parents, teachers and administrative staff to update our previous plan. We used Google Docs to collaboratively update and share this lengthy (45 page) document during its creation and editing process.

    You can download the 2012-2015 Technology Plan [999 KB] from the Honey Creek web site as a PDF file.

Spreadsheets & Databases

  • FileMaker Pro: Student Information Database

    During my time as the Technology Specialist for Honey Creek Community School, I have maintained and updated the school’s student information database using FileMaker Pro. This has gone through several iterations, and my work has involved adding fields, creating scripts for data exports, and managing the creation of a new user interface for administrative staff to maintain the student data.

    Due to the sensitive nature of this data, I am unable to share this work example.

  • Google Spreadsheet: Student Reading Scores form / pivot table

    I created a sample spreadsheet that collects student reading score information from teachers and organizes it by teacher using cross-sheet lookups in a pivot table. This spreadsheet uses all sample data, so it is appropriate to share.

    Student Reading Scores form

  • Google Forms: Staff technology survey

    Several years ago, I needed to survey our teaching staff’s current understanding and use of technology as part of updating the 3-year technology plan for Honey Creek. I created the initial version of this survey, and a fellow teacher helped update it, using the collaborative functions of Google Docs. After data was gathered, we used the “Show Summary of Responses” function to analyze the data submitted and help plan for future professional development and purchases.

    You can view the Staff Technology Survey.

Presentation Tools

  • Apple Keynote: Designing Real-World Interfaces

    I presented at the International Technology and Engineering Educators (ITEEA) national conference in March, 2010. I build my presentation using Apple Keynote, my favorite presentation software ever. I controlled this using Pointer Remote, an iOS application that allowed me to wirelessly control the presentation while walking around the room. This enabled me to make eye contact, focusing on audience engagement instead of clicking buttons.

    You can download my presentation as a PDF file [3.5 MB] or a ZIP file containing the original Keynote file [2.9 MB].

  • NeoOffice Present: Ignite Ann Arbor Presentation

    Using the open source NeoOffice software, I designed a slide deck to support my presentation at Ignite Ann Arbor in November, 2009. Ignite is a highly compressed format in which each presenter gets five minutes to present. Each presenter creates 20 slides, and they rotate automatically after 15 seconds.

    You can view a video of me delivering this presentation via UStream. You can also download my slide deck as a PDF file [5.5 MB] or a ZIP file containing the original NeoOffice ODP file [21.8 MB].

  • Other Presentations

    You can also see other, older presentations in the Presentations section of my teaching web site.

Web 2.0 Tools

  • Twitter: @billvanlooteach

    I have been an active Twitter user since March 2011, tweeting as @billvanlooteach. I began using Twitter the day after attending the Thursday session of the MACUL conference in 2011. Since I was unable to attend the Friday session, I signed up for Twitter to stay connected to the happenings at the conference, and have been actively using it since.

    I often tell other educators that Twitter has, to some degree, replaced Google Reader (itself now replaced by Feedly) and RSS feeds as my primary Professional Learning Network (PLN). It has become essential to how I grow my teaching practice, and I constantly rely on the resources and professional connections it offers.

  • Google Sites: Minecraft Pi summer camp site

    Using Google Sites, I built a website for the Minecraft Pi summer camp I ran in the summer of 2013. I used this site during the camp as a way to post student work, such as Python programs written by campers. After the camp was over, I posted a comprehensive set of daily reflections, containing writing, photos, and videos from the week.

  • WordPress: Technology Class website

    My class website for the technology courses at Honey Creek is maintained using WordPress, the open source blogging and content management system. I use it to inform parents and students, and display monthly updates on my technology classes.

  • Flickr: Honey Creek Community School photo sharing site

    I created the Honey Creek Community School’s Flickr account in 2009. Over the years, it has become an invaluable resource for sharing photos of the life of our school community.

    Check out the Honey Creek Community School Flickr site.