Gavin W. Off 9220 Sardis Forest Drive
(941) 223-8346
DATA SKILLS:
• SQL ● R ● Tableau ● ArcGIS
• Text editors ● Datawrapper ● Excel ● Caspio
EDUCATION:
• University of North Carolina at Chapel Hill School of Journalism and Mass Communication: B.A. 2002
• University of Missouri at Columbia School of Journalism: M.A. 2008
TEACHING EXPERIENCE
• Adjunct professor, Queens University of Charlotte
o Data-Driven Stories (2019, 2020)
o History and Principles of Journalism (2020)
• Adjunct professor, East Carolina University
o Data-Driven Stories (2019)
• Teaching assistant, University of Missouri
o Agricultural Journalism (2007)
JOURNALISM EXPERIENCE:
Charlotte Observer, Data reporter, Charlotte, NC, Sept. 2011 to present
• Request, clean and analyze data for investigative and daily stories, maps and online databases
• Use data for watchdog journalism and to spot trends, perform calculations and pinpoint story leads
• Wrote stories on the state’s court system, medical examiner’s office, prisons and lottery
Tulsa World, Data editor, Tulsa, OK, July 2008 to Aug. 2011
• Used database managers and mapping software to analyze data for investigative stories
• Wrote stories on pollution, school violence, nursing home abuse and tornado siren coverage
Scripps Howard News Service, Data reporter, Washington, DC, Jan. 2008 to July 2008
• Used SPSS to search and join variables to write national stories
• Gathered data from various formats, ran cross tabulations, linear regressions and frequency searches
National Institute for Computer-Assisted Reporting, Data analyst, Columbia, MO, Aug. 2007 to Dec. 2007
• Gathered, formatted and cleaned data from various government agencies
• Worked data using FoxPro and provided them to reporters nationally and internationally
The Columbus Dispatch, Intern, Columbus, OH, May 2007 to Aug. 2007
• Used data skills to cover state environmental news
The Columbia Missourian, Statehouse reporter, Jefferson City, MO, Jan. 2007 to May 2007
• Covered state government news about the environment, agricultural, transportation and the elderly
• Worked under deadline to cover Senate and House of Representatives sessions and hearings
The Charlotte Sun, Assistant editor/Staff writer, Port Charlotte, FL, Nov. 2002 to July 2006
• Reported on the towns of Port Charlotte and Englewood
• Covered police, county government, spot news and the local water district
The Daily Tar Heel, Staff writer, Chapel Hill, NC, Aug. 1999 to May 2002
• Wrote sports stories and stories concerning the state of North Carolina
The Cape May County Herald, Intern, Rio Grande, NJ, May 16, 2001 to July 25, 2001