I can build my own spreadsheets, or update existing ones, to analyze data for trends and conclusions. Here is one example:
Timeline: "Right to work comes to Michigan" • Lansing State Journal • March 28, 2013 • Within just one week in late 2012, Michigan Republican leaders announced their support for right-to-work legislation, introduced bills on the House and Senate floors, voted to approve them and the governor had signed them into law. The frenzied process drew thousands of demonstrators to the Michigan Capitol for rallies on Dec. 6 and Dec. 11, drawing national attention. This is how those events unfolded.
Produced using TimelineJS with content from LSJ.com, Freep.com and social media posts by State Journal staff members.
2012 Candidate Close-up • The Forum of Fargo-Moorhead • December 26-27, 2011 • As an introduction to the 2012 campaign season in North Dakota, I produced a multimedia project featuring the seven candidates for U.S. House and the four candidates for U.S. Senate. The project included Q-and-A interviews in print, with accompanying video interviews online.
Election 2010 wrap-up • The Forum of Fargo-Moorhead • November 4, 2010 • To conclude The Forum's 2010 election coverage, I produced an audio slideshow highlighting North Dakota's highly competitive U.S. House race. I shot the photos, captured the audio, edited the media, and built the slideshow by myself. Click to watch on inforum.com:
"Cultures in Conflict" • The Forum of Fargo-Moorhead • June 9-14, 2011 • This was a six-part series publishing in The Forum and Inforum.com, which included written stories, video interviews and an interactive map. I profiled five local individuals who were born in countries around the globe that face social unrest, political change and/or cultural conflict. Then, The Forum invited each of these individuals to participate in a roundtable discussion about international and cultural issues.
STATE CONTRACTORS • Lansing State Journal • August 2013 • Earlier in the summer, news broke that the state of Michigan had contracted out production of its "Pure Michigan" travel guide to an out-of-state agency. The original reports lacked context to showcase how much of the state's business actually was awarded to out-of-state firms. I obtained - and at times, fought for - state data, analyzed the numbers using spreadsheets, and published my findings in a series of reports:
STATE CONTRACTORS - DTMB
STATE CONTRACTORS - MDOT
STATE CONTRACTORS - MEDC
Timeline: "A history of K-Park in Wellington" • The Palm Beach Post • May 29, 2015 • Wellington bought a piece of vacant farmland, known as "K-Park" 12 years ago, but village leaders can't' agree on what it should be used for. They've made at least 6 attempts to develop all or part of it, but haven't been able to commit to seeing any of the options through. I produced this timeline to give readers a concise look at that history.
Produced using TimelineJS.