Agenda
–Prepare for export to Razorback Reporter
–Edit and fix final projects
–Delete outdated projects from the page
–All material will be ready by the end of tomorrow. Publishing Friday.
–I will be back in class at 4 p.m. Wednesday and 9:30 a.m. Thursday for last minute questions.
–Final project and course grades will be posted by next week
Punchlist:
- Review your work. Everyone please review the site. Look at your post.
- Peer edit. Examine your colleagues’ posts. Point out any issues to me and I’ll decide if they need to be fixed
3. Need to illustrate the two sidebars and need featured images for Explainer and How We Did It: Caitlin
4. Fact check Collegescorecard data in text. Halie checks Gender story numbers. Elizabeth checks HBCU numbers. Kris checks For-Profit numbers. Samantha checks Mainbar numbers. Grant checks Beauty school numbers.
WHAT YOU HAVE LEARNED:
End of Semester Review
You can put this on your resume and in your job cover letters. You have learned:
–Basic data analysis. Continuous vs discreet variables. Managing versions of complex government datasets. Understanding data dictionaries.
–Excel, file types, cleaning, intermediate functions such as pivot tables and =vlookup
–Tableau. Static graphics. Interactive graphics. Calculated fields. Grouping. Workbooks. Story books. Exporting multiple file types to web. Using source code for blogs
–Data visualization. Best practices in design, labeling and data presentation.
–R. Introduction to R. Importing data. Joining datasets. Creating basic visualization. Basic calculations. Exporting calculations to Excel, WordPress
–WordPress. Managing posts, projects. Building interactive graphics using embed code. Creating multimedia presentations using text, data and graphics. Divi builder
–In sum, you have learned the basic workflow in a modern digital newsroom.