• Blog
  • About
  • Digital Portfolio
  • Presentations
    • Ontario Summit 2019
    • Petaluma iOS Summit >
      • You Can Explain Everything and Your Students Can, Too!
      • Getting Going with Google Classroom
      • Capturing Student Ideas with Visual Apps
    • ISTE15 >
      • Connecting the Next Digital Leaders
      • Hacking the Daily 5
      • Passion-Based Learning: Genius Hour, 20% Time, and Innovation Day
    • DENapalooza Vancouver 2015
    • PITA15 Whistler >
      • Passion-Based Learning: Genius Hour & 20% Time
      • Screencasting for Visible Thinking & Learning
    • CUE15 >
      • Hacking the Daily 5 - Rockstar Jam Session
      • Digital Citizenship for the 21st-Century Citizen
    • Odyssey15
    • iOS Summit Vancouver 2015
    • 2014 Presentations >
      • ERAC IL4K12
      • CUEBC14 >
        • Learn How To Drive: Storage & Collaboration in the Cloud
        • SAMR: A Technology Integration Model for Educators
      • SFU14
      • Union SD Tech Innovation Summit
      • CUE Rockstar Manhattan Beach 2014 >
        • Learn How To Drive
        • Screencasting for Visible Thinking and Learning
        • Hacking the Daily 5
      • CA GAFESummit 2014 >
        • Learn How To Drive
        • SAMR: A Technology Integration Model for Educators
        • Passion-Based Learning
      • JET14
      • MERITCon14
      • ISTE 2014
      • CanFlip14 >
        • Screencasting for Visible Thinking & Learning
        • Passion-Based Learning
      • Vancouver GAFESummit 2014 >
        • Learn How to Drive
        • Passion-Based Learning
      • Walnut Grove - Genius Hour in Elementary
      • Odyssey 2014 >
        • SAMR: A Technology Integration Model for Educators
        • Explain Everything! Practical Uses and How-Tos for Screencasting on Your iPad
        • So You Want to Mystery Skype?
      • Roseville GAFESummit - Passion-Based Learning
  • Contact
A Tech Teacher on a Mission

Automating EdCamp with Google Add-ons, Part 2: DocAppender

5/15/2015

1 Comment

 
This is the second part to a three-part post detailing how we used Google Add-ons to make organizing easier for Edcamp35. To see the last post on using FormMule for confirmation emails and email updates, please click here.

Add-on #2: DocAppender

Picture
Picture
*Note: Designing your form well is really important when using the FormMule and DocAppender add-ons. While DocAppender is less likely to be used in the case of edcamp, it can be helpful!*

Basic Add-On Description:
DocAppender takes the data from multiple choice questions and populates corresponding information you specify into a Google Doc of your choosing.   This add-on for Google Forms is also written by the ever-amazing Andrew Stillman (like all the ones I use!).

An example question in a Google Form might be: Do you want cake? Answer options would include “Yes” or “No”. Google Docs named “Yes” and “No” would be used to store information as it was collected. You could choose to include all the names of people who wanted cake as well as the cake flavours they’d like, giving you a nice slick list after all of the forms are filled out. The document literally gets appended every time someone completes the form, thus the name “DocAppender”.

Add-on’s Function for EdCamp35: To collect data on who would be willing to facilitate sessions and what kinds of sessions they would be willing to facilitate. In edcamps past, we have lacked facilitators in several of our rooms, and new edcampers didn’t know where to start. With our DocAppender list of facilitators, we were able to identify which sessions didn’t have facilitators and we tapped those folks on the shoulder to step up and get those conversations started. This also could be used to track food allergies or requirements if you’re providing lunch, but we used food trucks instead.

Basic How-To:

Step 1: Find and install the DocAppender Add-on in your Google Form.
Picture
Step 2: Create your edcamp registration process through a Google Form - you’ll have to coincide this step with the original set-up of the Google Form from my first post.

To do this, we created a mandatory question asking, “Would you like to facilitate a session?”. Upon signing up, participants had to choose either
  • “Yes, I would be willing to moderate a session.” OR
  • “No, I’d rather not.”
Picture
Step 3: Create or choose a Google Drive folder that will hold your documents to be appended. After you select your folder, click the "Next" button on your DocAppender sidebar.
Picture
Step 4: Indicate which multiple choice question you would like to create documents for. Google Docs will be automatically populated for you within the folder you chose when you click the “Save” button. These Docs will be named exactly as the responses to the question you’d like to collect data on. Our answers were: “Yes, I would be willing to moderate a session.” or “No, I’d rather not.”, so our Google Docs were called the same thing. Click "Next" when you're done.
Picture
Step 5: Choose all of the data on your form you’d like appended to each document and how you would like it to appear. Every time a response is submitted, that information would get populated into each document. We only really needed data from one of the responses, but you have to collect both anyways. Click "Save Changes" to complete the set-up.
Picture
Step 6: Fill out your form to do a test run of whether or not it worked (remember which response you select!). Check by opening the Google Doc with the response you entered. It should have appended the data you indicated in the set-up!
Picture
Picture
For our use with Edcamp35, when a response was submitted, anyone who said “Yes” to facilitating a session would automatically have their name, email addresses, and suggested topics saved in a table on the “Yes” doc. Our organizing team could then contact specific attendees regarding anticipated sessions that might be harder to find facilitators for. 

After testing and tinkering to make sure it works, your form link should now be fully ready to send out to attendees! If you are looking for more geeky Google tricks for edcamp organizing, stay tuned on my blog for Part Three which will feature the use of the Autocrat Add-on for EdCamp35! 
Picture
1 Comment

How To Create Your Own Digitized Fonts (Students Can, Too!)

4/23/2015

6 Comments

 
One of my students has been tirelessly writing a book for her Genius Hour project. She has designed the entire layout through storyboarding and has rough illustrations and a manuscript ready to go. She has even hand-drawn her own typography which the story will be written in.

It gets better: One of her classmates’ parents took her typography and turned it into a digitized font. She showed me the file on her Google Drive which had a .ttf file extension name and looked like this:
Picture

Installing the Font

Picture
Finder > Go > Computer > Macintosh HD > Library > Fonts

First, I had to know how to put it on my own computer. On my Macbook Air, I downloaded the file and from my Finder window, I clicked on “Go” in the header menu and clicked on "Computer". In the menu that opened, I clicked on Macintosh HD > Library > Fonts. I then dragged the downloaded file into the Fonts menu, and voila! I was able to use it immediately as a choice in Pages, MS Word, and other OSX apps that allow you to choose your own font! 



Here is Lily’s font:
Picture

So then I got thinking: how hard could this be? Lily took care of the artistry, but could a teacher deal with the workflow that students would have to go through to digitize it? Or could students do it, too? I quickly found out that both are true because I made my own font using MyScriptFont.com too! 

How to Make Your Own Font Digitally

1. Go to MyScriptFont.com and download the available font creation template. You can move the file into the cloud to easily transfer to digital annotation apps, which is what I will outline here. (If you’re not confident with digital workflows, you can print the template, have students fill it out in pen, and scan it to upload to the website.)

2. I first saved the file in Google Drive and opened it using the UPAD app on my iPad.
Picture
Saved in Google Drive, tap on the "i" and "Open In..."
Picture
Select your .pdf annotation app of choice. I used UPAD.
3. UPAD allows me to pinch and zoom easily and use beautifully sleek pen tools to create my typography. Using a stylus for digital font creation is helpful, too! Note that the letters on the template will guide you to know which letters to draw in which boxes, but this can cause interference when drawing. I anticipate this would be a bigger problem in younger classes than in older classes.
Picture
Full view of typography I created in UPAD.
Picture
Pinching and zooming within UPAD allows me to draw with precision.
4. After my drawings were complete, I had to export my work back to Google Drive so that I could access it on my Macbook again. I took the file and uploaded it to MyScriptFont.com, where it converted the .pdf into .ttf format. As soon as I installed it on my Mac (using the same steps for installing a font as above), I could use it in Pages, MS Word, etc. WOW! So, so, so easy! 
Picture
So there you have it - teachers and kids could totally do this! Imagine the impact on a struggling writer as they see their own handwriting light up a screen. How motivating! 

Please share screenshots of any fonts your students create with me on Twitter! Happy designing!
Picture
6 Comments

    Author

    Victoria Olson
    A curious and passionate educator in Langley, BC

    Picture

    Picture

    Picture

    Picture

    Picture

    Picture

    Tweets by @MsVictoriaOlson

    Picture

    Picture

    RSS Feed


    Archives

    April 2020
    March 2020
    February 2016
    January 2016
    August 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    October 2014
    September 2014
    July 2014
    May 2014
    April 2014
    March 2014
    January 2014
    December 2013
    November 2013
    October 2013
    September 2013
    August 2013
    July 2013
    June 2013
    May 2013
    April 2013


    Categories

    All
    Assessment
    Augmented Reality
    Balance
    Blogging
    Camtasia
    Collaboration
    Communication
    Community
    Creativity
    Design
    Edcamp
    #EdFailFwd
    Education
    Efficiency
    Elementary
    Google Teacher Academy
    Guided Math
    Intermediate
    Ipads
    Multi Age
    Multi-age
    Pln
    Primary
    Pro D
    Pro D
    Pro-D
    Reflection
    Resource
    Screencasting
    Self Regulation
    Sharing
    Tech
    Things That Suck
    Think35
    Twitter
    Video
    #YourEduStory


    Want to subscribe to this blog? Enter your email address below for automatic email updates:

    Enter your email address:

    Delivered by FeedBurner

Powered by Create your own unique website with customizable templates.