Today’s Plan:
- Job Ad Analysis Report
- Creating a Graph in Excel
- For Next Class
Job Ad Analysis Report
Our first major assignment will be due on Monday, September 23rd at midnight. This will be the Job Ad Analysis Report. Please bring your ABO book to class on next Tuesday, where we will identify the organization or the report.
The purpose of the report will be to tell me about what tools/technologies, professional competencies, and personal characteristics show up in the job category you have selected. Thus, everyone needs to have coded all 20 of their selected jobs by Monday, September 16th at 11:59pm. Turn your jobs into a hyperlinked Google Doc like this (you can create a copy of this document to use as a template) and submit it to the Canvas assignment “Google Doc List of 20 Job Ads.” MAKE SURE ANYONE WITH THE LINK CAN EDIT. In fact, let’s just do that right now.
In case you haven’t located your 20 jobs yet, here is a link to the job folder. You can click on the folder name and choose to search within the folder.
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 Tuesday’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
You need to code your 20 jobs. You should have already done 12 jobs by today, so you have 8 more jobs to code this weekend. Once you have coded your jobs, you should synthesize and compile data into your own personal spread sheet. Simply make a copy of my sample spreadsheet from today.
Please bring a copy of your ABO book to class. We will crowdsource an assignment sheet for the report on Tuesday.
