Google maps tutorial (part 3/5): How Fusion Tables map works

Usually there are two scenarios when creating a Google Fusion Tables map: 1. you have a file (e.g., a spreadsheet) that has both raw data and geographic data. 2. you have a file that only has raw data, and the geographic data is in separate file. Continue reading

Posted in Data journalism | 1 Comment

Google maps tutorial (part 2/5): How to work with Fusion Tables

This tutorial introduces you to three aspects of using Fusion Tables: How to start a new table, how to navigate the table interface and how to use filter. Continue reading

Posted in Data journalism | Leave a comment

Google maps tutorial (part 1/5): What Fusion Tables is and does

Google Fusion Tables (or simply Fusion Tables) is a free Web service provided by Google for data management. Data is stored in the form of tables that web users can view and download. Fusion Tables is a popular tool to store, visualize and share larger data tables. Continue reading

Posted in Data journalism | 5 Comments

How to do SEO: A sample SEO strategy by student in my web writing course

A participant in my open online course Writing for the Web did a good job developing an SEO strategy following guidelines in class lecture. I want to share with my blog readers this step-by-step SEO plan for a proposed online article. Continue reading

Posted in Writing for the web | 5 Comments

Telling a story using audio slideshow: Student works in my open online course

About 190 people from 46 countries and regions took the recent Audio Slideshow Storytelling class, a free online course offered by this blog. Here’s a recap of what they learned and two sample stories they produced. Continue reading

Posted in Audio slideshow | Leave a comment

A case study of writing for the web: How to rewrite for online readers

A participant in my open online course Writing for the Web did a good job rewriting an article following web-writing guidelines discussed in class. I want to share with my blog readers the analysis and rewrite by this participant. Continue reading

Posted in Writing for the web | 4 Comments

Google maps tutorial (part 5/5): How to create a free heat map with Google Fusion Tables

Tutorial goals: understand the ideas behind Google Fusion Tables heat maps; create an interactive map showing state-by-state U.S. population, as shown in the sample below.

(This post is part five of a 5-part tutorial on creating Fusion Tables intensity map; the other parts are listed as related posts at end of this post)

Continue reading

Posted in Data journalism, Digital tools and tips | 2 Comments

Advice for college media advisers: It’s time to go beyond reporting and writing

As student media adviser, you need to supervise a full-blown digital operation and help students learn all the best practices in content production and promotion. Continue reading

Posted in College media going digital | Leave a comment

Journalism schools need to teach web metrics as it sees increasing use in newsrooms

A survey of 114 top-level news editors shows widespread use of web metrics in U.S. newsrooms and this means j-schools need to add metrics and analytics as part of the changing journalism curriculum. Continue reading

Posted in Metrics & Analytics | Leave a comment

Suggestions and resources: Teaching web metrics and Google Analytics to communication students

Many communication instructors do not have prior expertise in web metrics, which is a new and increasingly important skill for today’s communication workers. Here’s some advice and resources that may help an instructor prepare, structure and teach courses in web metrics and Google Analytics. Continue reading

Posted in Metrics & Analytics | 2 Comments