Monday, December 17, 2018

How to Use a Spreadsheet to Create a Map

Last week when I posted about Google closing Fusion Tables I mentioned that some of the functions of Fusion Tables can be replicated in Google Sheets. An example of that is creating a map based on the data in a Google Sheet. Google's My Maps tool lets you import a Google Sheet and have the data from that sheet displayed as placemarkers on an interactive map. Watch this video that I created to learn how you can create a map based on data in a Google Sheet.

A Quick Tip About Changing Font Sizes in Google Docs

When it comes to formatting your documents Google Docs provides plenty of options. Some of those options are obvious and some are hidden deep in the menus of Google Docs. Here's one that falls somewhere in between those ends of the spectrum. When you're choosing a size for the font in your document, you don't have to use the sizes that are listed in the drop-down menu. You can enter any size that you want to use. As you can see in my one minute video, you can even use odd numbers for your font size.


And if you're wondering how to change the default font style in Google Docs, watch this short video.


Learn much more about Google Docs in my online course Getting Going With G Suite.

Kids World Atlas - An iPad App for Learning About Animals Around the World

Last week I wrote a review of the Kids U.S. Atlas iPad app. That app offers an interactive map of the United States that kids can tap on to learn about 25 animals that are indigenous to the United States. Kids World Atlas is the companion app to the Kids U.S. Atlas. Kids World Atlas uses the same format as Kids U.S. Atlas.

Kids World Atlas features a map of the world that students can tap on to learn about forty animals around the world. Students simply tap an animal on the map and new window pops-up with a picture of that animal and brief text passage about it. The app has videos about some of the animals on the map. Unfortunately, unlike Kids U.S. Atlas, Kids World Atlas doesn't offer narration of the text passages.

Like the Kids US Atlas app, the Kids World Atlas app is a freemium app. The animal map is free. There are other maps available through in-app purchases at $1.99 a piece.

Applications for Education
Just like the Kids US Atlas app the Kids World Atlas iPad app to learn some basic facts about animals. A follow-up activity to students exploring the app would be to have them chose a favorite animal on the map and then research the characteristics of that animal that make it suited to its habitat.

21 Places to Find Media for Classroom Projects

Yesterday, people who subscribe to the Practical Ed Tech newsletter received a copy of my guide to finding copyright-friendly media for use in classroom projects. The guide includes explanations of Public Domain, Creative Commons, and Fair Use. In the section on using self-created media I included an example of how I unintentionally committed a copyright violation when making a screencast video a few years ago. Finally, the guide includes 21 places to find copyright-friendly media to use in classroom projects. You can access the guide here as a Google Doc or here as a PDF.


Some of the resources featured in this guide are integral to my upcoming course Video Projects for Every Classroom.