Today’s Plan:
- Job Ad Analysis Report
- Creating a Graph in Excel
- For Next Class
Job Ad Analysis Report
Friday I will lay out the expectations for our first “major” assignment, the job ad analysis report. The purpose of the report will be to tell graduating high school seniors about what tools/technologies, professional competencies, and personal characteristics appear in contemporary writing ads.
Graph in Excel
I will ask that your report include 3 meaningful graphs. We’ll talk a bit about what makes for a meaningful graph in next Monday’s class.
Today, while we are in the lab, I wanted to give you the opportunity to teach yourself how to make a graph using Excel. The reason I’m asking you to teach yourself is that, as a professional writer, you are going to have to learn how to use a lot of different tools on your own. Whether it is a CMS interface, an invitation maker, an email marketing software, or a new presentation software, that’s often a large part of the gig. Today I’m here to help you if you get stuck.
The tutorial is how to make a graph in Google Sheets (note the Related Articles). Thinking ahead to your project, once we have collectively completed the Spreadsheet, then you will probably (nudge, nudge) want to create your own Google spreadsheet quantifying that qualitative data. That would look something like this [NOTE: these numbers are fake]. You can use those fake numbers to follow the Google Sheets tutorial.
For Next Class
Two things: if we do not finish the sample tutorial graph above, then finish that. This is due Friday.
The second thing is a bit more complicated. Assuming we have cleaned up our spreadsheet, I would like you to select one kind of job (if you select Design, then please do both Design and marketing). You are welcome to select a second kind of job if you wish.
You should then tally all of the codes that appear in each category (Tools and Tech, Prof Comp, Pers Char). To facilitate this, simply make a copy of my sample spreadsheet from today.
This second project is due on Monday. I also don’t mind if you work on this collaboratively.
