February 29, 2016
Here they are, your group blog teams for 2016! I went through your existing blogs and the comments you left on last week’s assignment to sort you by complementary interests, styles, and so on. The more detail you provided, the better a fit I was likely to find. Regardless, you’re in this boat together now, so get to know each other!
- Kaitlin D.
- John Mark
- Emily E.
- Kaitlyn P.
- Caitlin W.
- Sarah E.
- Emily M.
In today’s class, you’ll be meeting to work out the initial details of whatever it is you’ll be doing for the final five weeks of the semester. Next Monday, March 7, your group will present its concept, along with a list of story pitches (at least two from each member) and a tentative schedule (don’t create an actual blog on WordPress yet – that comes later).
February 24, 2016
We’ve seen how to use spreadsheets to work with data, but what if that data is in a table, not a spreadsheet? You COULD type it all up … or you could write a simple data scraper! Relax – if you know a tiny bit about spreadsheets, it’s pretty easy.
Quick Review of Formulas (in Google Drive):
- Formulas here work just like in Excel
- Two parts: Formula (=SUM) and Parameters (in the parentheses)
- Can have one parameter (A1:A20) or more (B1:B10, “Y”)
- Parameters can be either strings (in quotes) or numbers
- Example: =SUM(A1:A20) will add up all the values in the range of cells from A1 to A20.
- Other formulas:
- There are also IF formulas (COUNTIF, SUMIF, AVERAGEIF) that take two parameters: =COUNTIF(A1:A?, >100) counts all cells in a range that have values greater than 100.
Recipe for a Simple Data Scraper (using Google Drive):
- Find a website of interest that includes data in a table (Wikipedia has lots)
- Anywhere you’d expect a table or list (e.g. Oscar winners, baseball stats, lists of prison)
- You can check in source code by searching <table, <ul, or <ol (don’t include the >)
- Note the following:
- The URL
- The index of the table (e.g., “1” for first table on the page, etc.)
- In new Google Docs spreadsheet, paste the following 3-parameter formula:
- url is the website’s URL [string]
- query is the HTML tag you want (e.g., “table” or “list”) [string]
- index is the ranking of that query on the page [number]
- Oscar winners example: =ImportHTML(“http://en.wikipedia.org/wiki/Oscars”, “table”, 2)
- You can customize it, too:
- Delete your formula from A1 and re-paste in B1
- Enter the three parameters in A1 (url), A2 (query), and A3 (index)
- Paste the formula in B1 and replace parameters with A1, A2, and A3
- This allows you to change parameters more easily and visibly
- ADVANCED: There’s an =ImportXML formula as well
- XML is heavily structured and uses more specific tags, like <book>
- Example from openlylocal.com, an open gov’t site: =importXML(“http://openlylocal.com/councils.xml”,”councils/council”) – Example drawn from Bradshaw’s book (see below)
- Want more? For $15, you can download Paul Bradshaw’s “Scraping for Journalists,” an excellent PDF book (first chapter is free): https://leanpub.com/scrapingforjournalists
- Don’t forget to start the formula with an = sign
- Check to see if you included quotes around your URL and query
- Try a different index
February 22, 2016
For the final third of the semester (weeks 11-15), you will be maintaining focused group blogs. In preparation, and to identify similar interests, each of you will propose a group blog concept and a list of potential stories. I’ll use these to determine group assignments, which we’ll go over next week. You’ll be reading through some group blogs on the sidebar for next week’s read and respond, so you might want to get a head start on those now.
Post a comment (to this post) with a pitch for a group blog concept by 10 a.m. Wednesday, February 24. This must contain the following:
- A one-paragraph description of a group blog concept focused on some aspect of Morgantown life (no activities calendar blogs!). Other regions (e.g., West Virginia; other cities) can also be your focus as long as you’re able to cover them.
- At least FIVE story ideas. Use complete sentences and address why this story matters. For example: “A few years back, downtown Morgantown saw an explosion of eCigarette shops, but today many of these have closed. Is vaping on its way out?”
In addition, read through the comments by 11:59 p.m. Friday, February 26. Post at least one comment to a description that you’d be interested in contributing to, and let them creator know what you’d bring to the table.
February 17, 2016
After blogging for several weeks, you should have a feel for what works, what doesn’t, and how to plan your attack. So far you’ve been doing sprints, but this week will be a 5K. Beginning on Monday, Feb. 22, you will post something EVERY day to your personal blog for a week (yes, this includes Saturday & Sunday). This will not be easy, but you can do it, and at the end you’ll have a newfound respect for those who do this every week.
Some rules and tips:
- The first rule of Blog-a-Day Week is: We do NOT talk about Blog-a-Day Week! This means no posting about how hard it is to post every day, or other such metacommentary.
- Likewise, no posting about how you don’t know what to post. Use the skills from previous challenges, ideas from your blogroll, synthesis posts, comments from other students … ANYTHING that leads to a substantive post!
- As always, good posts will have rich content (links, videos, images, maps, etc.) and be connective. Now might be the time to check out that “Add Poll” button up at the top of your New Post window.
- Scoring (10 pts total): Your Monday and Thursday posts count for your required weekly posts (5 pts each) and are NOT part of the assignment. The remaining five are worth 2 pts each.
DUE: Every day from Monday, Feb. 22 – Sunday, February 28 (seven posts in all)
So that’s it. Daunting, but I promise you’ll survive and learn some new skills. THIS is what a full-time blogger does. I strongly recommend writing a few posts in advance to keep from going insane. You might also want to check out the National Blog Posting Month website for advice and support – you can even sign up to win prizes.
February 11, 2016
Here’s a vivid thought from @GeorgeBray on that everpresent device in your hand.
The concept of Mobile First is informing considerable mass media practice. One of the up-and-coming areas in mobility is wearable technology, and its poster child was once Google’s Glass, whose “failure” we’ve discussed in class.
Do you find this fascinating, or do you want to slap the guy? The company pulled the plug on Glass in early 2015, but wearable technology is not going anywhere (get a load of the hedgehog-like iGel). Consider these perspectives:
Naturally, there are naysayers as well:
So how do you see wearable tech influencing the future of mobility? Be sure to post your response to Briggs and the readings as a comment to this post by 11:59 p.m. Sunday, February 14.
February 10, 2016
In Monday’s scavenger hunt, we used Twitter to report. Today, we’ll use another app, Storify, to condense that content into something that can accompany a news story or serve as a stand-alone narrative (this assignment is adapted from Dave Burdick’s tutorial)
Storify your scavenger hunt with the following:
- An introduction and informative text throughout
- All your own Tweets
- Your top three favorite Tweets from classmates
- Don’t just add all this content and think you’re done! You must also include a narrative (text) about the experience. Make it interesting, and make it worth reading.
Due: 10a Monday, Feb. 15. Publicize, adding the #WVUblogJ tag, and post link in a comment to this assignment post.
- Go to Storify.com and log in with your Twitter handle
- Browse through the stories there to get a feel for what’s possible
- Click the “Create Story” button at the top right of the screen and create a Storify page (choose Public Story) of your team’s scavenger hunt – each member creates one.
- This must be curated – not just a list of tweets – so include explanatory written detail, links, maps, and other information that fleshes things out
- In the left panel, add a title and description for your story in the blanks, then write some intro text in the main frame.
- In the right “Media” panel, click the Twitter icon (the little blue bird) and type in “#WVUblogJ”
- You can search users and keywords too, but start with this for now)
- Drag tweets and images from the right panel to where you want them in the left panel
- You can click “Images” to just display images to use, “Timeline” for tweets a single user sees, and “User” for tweets from that user
- You can also include elements from Facebook, YouTube, Flickr, Instagram & Google by clicking the relevant tab on the right panel
- You can embed links to specific sites as well – just click the little chainlink icon, enter the URL, and drag it to your story (OR highlight the text to link, click the chainlink icon, and paste in the URL)
- Add text by mousing over blank areas before or after your content links. A yellow bar will appear. Click on any of these to enter text
Publishing your story
- At the top right of the left-hand window is a big, friendly blue “Publish” button – click it
- You’ll get a window with a Publicity message that lets you send this to Twitter or Facebook and also inform people you quoted
- You can change these from their defaults to something better
- You can skip this and send it later by clicking “Notify” at the top of your story panel
- This is a great way to publicize what you’re doing to the people who helped you do it!
- If your Storify is associated with an actual news story (e.g., something in the DA or WVU News), and you’re embedding the Storify at the end, switch the default link to that of your story
- NOTE: You can’t embed this code in a WordPress-hosted blog, but you can post to there by clicking “Export” (at the top)
- To embed: Click “embed” (below the headline of your story) and copy/paste the resultant text to your story (or blog post).
February 8, 2016
It’s time! Every year, our class takes to the streets for a Twitter scavenger hunt. Thus far you’ve probably only used Twitter for personal posting, but it’s a powerful tool for reporting and newsgathering, and the best way to learn about this is to do it. For the remainder of class today (Monday, February 8), you’re heading out into the world in teams of two (at least one of you needs a phone with the Twitter app) to find 10 things. You’ll need to complete the bulk of this assignment by the end of class.
IMPORTANT: To count, each tweet MUST include:
- The number you are doing (e.g., 1. Joe Smith: “I love WVU”) – Without these, I can’t guess which entry you’re checking off!
- The hashtag: #WVUblogJ
- EXAMPLE: “3. Prof. Biggins (Econ): It’s made protesting easier, but also more identifiable. #WVUblogJ”
- Restrictions: No College of Media students, and please don’t all mob the same professor. No more than half can come from the same building, so don’t just hang around Evansdale Crossing or the Rec Center.
Post an introductory tweet or two and a selfie of your team so readers (and I) know what to expect. Don’t forget the course hashtag!
And now … the list!
- School spirit! Photo and quote from someone (not you or your partner) revealing school or civic spirit (what that means is up to you. Be creative.)
- Eating Up: Photo and quote (not you or your partner) from your favorite eating spot or watering hole on or near campus.
- Professor on the street. Photo and quote from a professor on campus. Ask them what role they think social media plays in our society today. Be sure you include the professor’s title and department.
- Student on the street. Photo and quote from a student. Ask them where they get their news and if they use social media to keep up on the news. Be sure you include their year in school and major.
- Academic excellence. Photo and quote that reveals (you are going to have to be creative) how your school contributes to cutting edge research and/or learning.
- Scenic spot. Photo of your favorite scenic spot on or near campus.
- Little-known fact. Photo and quote of something you think many people might not know about your school or campus or city.
- Fanatic fans – Photo/quote from somebody asking for their prognosis on the remainder of the basketball season, or other sport of your choice.
- Extracurricular extravaganza: Photo and quote that exemplifies some of the huge variety of clubs, organizations, etc. available to students at our university.
- Freestyle: Your very own final unique tidbit of information/photo about our campus or city. Be creative.
Extras! (for +0.5 each – only your first use gets the extra credit. These must also include both hashtags):
- Use a microvideo app like Vine to provide interesting/funny/relevant information about your school .
- Post 3-4 photos in a single tweet.
- Use Yik Yak to find something noteworthy to share from the CUNYJSchool surroundings or neighborhood community, or post a screenshot of something you’ve posted there.
We’ll start this in Wednesday’s class, but if you’d like to prepare in advance, it will include the following: a)All of your own Tweets, and b)Your top three favorite Tweets from your classmates. In this Storify, reflect on what you learned and observed from the experience.
- Scavenger hunt: Majority must be done by end of class today (one or two stragglers are acceptable)
- Storify: We’ll make this in class on Wednesday, Feb. 10.
A Few Tips:
- Think like a reporter. Have an eagle eye for the interesting, the important, the relevant, the unique, and the immediate. Double check your facts.
- Think like a public relations professional. Show other people what’s cool about WVU.
- Think like a storyteller. You may only have 140 characters in each tweet (actually 120, minus the 20 for your hashtags), but you can say a lot in a few words or using an image.
- You may use more than one Tweet for each of the items below. Don’t overdo it, though, and don’t forget the #WVUblogJ hashtag!
- 140 characters isn’t much. Try using other apps like Vine to make it easier.
This is going to seem a little strange to some of you, but the goal is to reveal to you the journalistic applications of Twitter. You need to be an observer, a reporter, and you can’t be afraid to accost people on the street for their opinions. You’ll provide perspective and voice, and you’ll tell a larger audience something about your subject (WVU, in this case) – make sure you’re thinking of them!