Get a direct link to files hosted in Google Drive

Update: I haven’t had trouble myself but some have reported that this no longer works now that Google has updated to the ‘New Google Drive’.

Imagine you want to use a QR code so guests at Parents’ Night can scan the code and stream video or audio straight to their mobile device. If you share the files in Google Drive, users will be taken to a Google page where they have to download the file first. But if you can create a link that points directly to the file, users can access the content right in their mobile browser.

Direct link files in Google Drive
Direct link to files in Google Drive

Turns out you can do this while still using Google Drive. Any public folder in Drive can host files and provide direct links to the files.

How to create the hosting URL:

This will provide a folder that will give direct links to files inside the folder.
Note: hosting view will not display files created in Google Docs.


Once in the hosting folder, you can right click on any of the files to get a direct link to the file.

Finding the right font with flipping typical

I’ve been looking at a lot of fonts lately. Like many others, I’m not a fan of the Comic Sans font. To me, it just looks sloppy. Since Comic Sans comes closer than other fonts to matching the look of handwriting, we see it used A LOT in elementary schools. Yet, I think there are even better choices.

While Handwriting Without Tears is a company popular for it’s handwriting teaching materials, they do not sell their font. At their website, they recommend using Century Gothic as a substitute. The lower case “a” is usually the first character I look at. There are only a handful of fonts that display this letter similar to the shape that is taught to kids. As you can see below, Comic Sans follows the shape in spirit but Century Gothic does a much better job.

Comparing fonts
Comparing fonts

If you want to search your computer for other font options, then visit the website flipping typical. It offers a perfect way to view all the fonts installed on your computer. Make sure to click “load more” at the bottom of the page to see all your options.



KG Primary Dots is another font I found online that is available for free if your use is non-commercial. It offers a dotted font for tracing and lined fonts for extra guidance.

Okay, I’ll admit it. I’m a bit of a font nerd. Check out the great documentary titled Helvetica (it’s on Netflix) and you will be too.

Add cover art and other extras to your mp3 files

Since 2007, I’ve been co-producing a podcast, titled Lab Out Loud, for the National Science Teachers Association (NSTA). With each episode, I like to have all the important details about the show saved right in the mp3 file.

podcast details
add cover art and more to your mp3 files

I use a free program called Mp3tag to add things like title, artist, and cover art to each mp3. Mp3tag allows you to copy the tag from a previous file right into the new file. This makes updating new files a breeze.

with Mp3tag – adding info to audio files in a breeze

Despite its name, Mp3tag supports a wide variety of audio files. Beyond its simply features, Mp3tag offers a few extra tricks for managing large collections of audio. I have been using this free tool for years and recommend that you give it a look.

Not all screen time is equal, or educational

When children and adolescents have unlimited and unsupervised access to media, evidence has shown that this exposure can lead to several health effects such as academic difficulties, obesity, substance abuse, and aggression. Yet, we live in a media-rich world where devices like tablets and smartphones can also provide many benefits. To acknowledge this need for balance, the American Academy of Pediatrics (AAP) has recently updated their guidelines for children and adolescents with new policy statements on screen time.

tablet userTo start the screen time conversation with parents, the AAP recommends that pediatricians begin asking these two questions at every well-child visit: How much recreational screen time does your child or teenager consume daily? Is there a TV set or an Internet connected device in the child’s or teenager’s bedroom?

The AAP recommends that parents limit entertainment screen time to less than one to two hours per day. They suggest that families create a media plan for their homes and keep televisions and other Internet connected devices out of a child’s bedroom.

Schools and teachers should be considering these guidelines too. How can parents make a media plan for their family without knowing what is being consumed at school? We must be careful not to contribute to a child’s entertainment screen time diet.

Many games and apps are labeled “educational” but have no measured effectiveness to support the claim. Some are simply just interactive toys. Dr. Ari Brown, pediatrician and lead author of policy provided by the AAP in 2011, questions the link between an interactive game and the learning it promises to provide. “There’s nothing wrong with a toy being fun, engaging a child for an amount of time. But to promote it as being educational we really need to do research to find out,” explains Brown.

Based on the new AAP guidelines and recommendations, there are many things for teachers to consider. Online games and touch-screen apps can be incredibly engaging for students. However, we must select tools that can demonstrate a targeted approach to student learning. Look for tools that have research to support their educational benefits and be critical of those that will only contribute to a child’s daily dose of entertainment screen time.

Hey Google, what about the children?

With Google’s new version of Android comes improved multi-user functionality. Google explains:

Share your tablet with friends and family – each person has a separate customizable space, including personal homescreens, wallpaper, apps, storage, and more. You can also manage access to apps and content to create an experience that’s appropriate for each member of the family.

Each member of the family? Really? What about those family members under 13 years old? Here’s what you get when you try to create an account for kids under 13:


Google does this because of COPPA, a U.S. law that requires online web sites and services to get parental consent for all children under the age of 13 before they can share any information with the web site.

At the press event announcing the new Nexus 7, Google demonstrates a child’s profile and how the access restrictions can be managed by parents. In this situation, the child user does not appear to be old enough to have a Google account. This child’s profile is sort of sub-account that lives within the tablet’s environment and does not need to be associated with a Google account.

Nexus7 for child

However, without a Google account, the child cannot manage his or her own content used in other Google services. Apps like Drive, Calendar, and Maps will need an account to save content. Many parents just let their child use a parent account for these other Google services. Other parents create an account for their child with a false birthday. I suspect that most parents don’t use the multi-user features at all.

I think Google could do more for families. We have Google Apps for business and education. Why not for families? Instead of prohibiting accounts for children under age 13, Google should redirect to a space where parents can create and manage accounts for their kids. Here parents could control access restrictions for the accounts and pass the account over once the child is old enough.

Google already has a plan for the death of Google accounts. It’s time they improve the process for the birth of Google accounts.

What most schools don’t teach

Another group is continuing the coding to learn theme. The non-profit foundation is hoping to increase computer programming education across the world. They’ve created a video with an impressive cast (Bill Gates, Mark Zuckerberg,, Chris Bosh…) but my favorite quote comes from Gabe Newell.

The programmers of tomorrow are the wizards of the future. You know, you’re going look like you have magic powers compared to everybody else.

Check out to get started immediately.

Trouble embedding YouTube in PowerPoint? Fixed!

I’ve heard from several people last week that they could no longer get their YouTube videos to play in PowerPoint. If you didn’t know, PowerPoint (starting with version 2010) allows you to easily embed online videos using the video’s embed code.

Here is a quick tutorial that explains how to set this up.

HOWEVER, last week this method seemed to stop working. After a little tinkering, I figured out how to get it working again.

It turns out that you need to remove a little bit of the YouTube embed code before you paste it into PowerPoint.

Delete a bit of the embed code
Delete the highlighted text before embedding in PowerPoint

For example, to embed the video (more…)

Coding to Learn with Scratch

Scratch is the perfect tool to help kids (ages 8 and up) learn how to write programs or code. But in a recent Ted Talk, Mitch Resnick expresses another good point- the importance of coding to learn.

Resnick explains:

As kids are creating projects like this, they’re learning to code, but even more importantly, they’re coding to learn. Because as they learn to code, it enables them to learn many other things, opens up many new opportunities for learning. Again, it’s useful to make an analogy to reading and writing. When you learn to read and write, it opens up opportunities for you to learn so many other things. When you learn to read, you can then read to learn. And it’s the same thing with coding. If you learn to code, you can code to learn. Now some of the things you can learn are sort of obvious. You learn more about how computers work. But that’s just where it starts. When you learn to code, it opens up for you to learn many other things.

I highly recommend watching Resnick’s talk.

He demonstrates how kid-friendly programing tools like Scratch are not just for teaching computers, math, science, or engineering. Coding to learn can apply to almost any subject.

For example, consider teaching kids storytelling with the book Super Scratch Programming Adventure!

Super Scratch Programming Adventure!
Super Scratch Programming Adventure!

Ruth Suehle at GeekMom writes:

Super Scratch Programming Adventure! helps your budding developer learn to use Scratch with a comic book story. Each section begins with a continuing piece of a story that ends by giving the reader a problem to solve with Scratch.

I got this book for my own kids and they were off in minutes. I think Super Scratch Programming Adventure! would be the perfect textbook to get your students off coding to learn.

BYOD in moderation

Below are two TEDTalks that made me think about our students and BYOD.

Joshua Foer: Feats of memory anyone can do

…our lives are the sum of our memories. How much are we willing to lose from our already short lives by losing ourselves in our Blackberries, our iPhones, by not paying attention to the human being across from us who is talking with us, by being so lazy that we’re not willing to process deeply?

Sherry Turkle: Connected, but alone?

When we don’t have the capacity for solitude, we turn to other people in order to feel less anxious or in order to feel alive. When this happens, we’re not able to appreciate who they are. It’s as though we’re using them as spare parts to support our fragile sense of self. We slip into thinking that always being connected is going to make us feel less alone. But we’re at risk, because actually it’s the opposite that’s true. If we’re not able to be alone, we’re going to be more lonely. And if we don’t teach our children to be alone, they’re only going to know how to be lonely.


Learning to learn with (and without) our cellphones

The decision to allow students to bring personal devices into the classroom is being made all across the nation. Many schools are adopting ‘bring your own device’ (BYOD) initiatives to engage our students in the classroom with the same tools they are using outside the classroom.

As a BYOD advocate, I look forward to seeing all the ways personal devices will help us transform teaching and learning.

Yet we must proceed carefully as we open the floodgates for BYOD. We must help our students learn how to work with and without our devices. Many argue we need to work harder on the ladder.

Joe Kraus, currently with Google Ventures, had this to say regarding our relationship with personal devices:

…we’re becoming like the mal-formed weight lifter who trains only their upper body and has tiny little legs. We’re radically over-developing the parts of quick thinking, distractable brain and letting the long-form-thinking, creative, contemplative, solitude-seeking, thought-consolidating pieces of our brain atrophy by not using them. And, to me, that’s both sad and dangerous.

Letting cellphones and iPads into our classroom is not a trade. We’re not exchanging our students’ ability to reflect and think critically for some quick-fix tech gadget that will give them an all-access pass to information. Those gadgets are important. Really important. However, let’s never forget to appreciate and use all the things our brains can do without the aid of of a gadget.

Our students aren’t alone. We adults are experiencing this transition with them. Are you happy with the relationship you have with your phone? Watch Kraus’ entire presentation on our “Culture of Distraction” before you answer.