Today’s Plan:
- Working with Data
- Making Graphs
- Homework
I am going to ask that your upcoming report have at least three graphs showing the top 5-7 codes for Tools and Technologies, Professional Competencies, and Personal Characteristics. Today we are going to work on this by creating cleaner spreadsheet data that we can visualize in Google Sheets.
Working With Data
Here, again, is the link to the data sheet I provided you earlier. That sheet is, in some ways, a disaster with which to work. There’s too much packed into one space. To make clean graphs, we are going to need to clean that data up. Let’s decide to work on a Tools and Technologies data set together. I’ve put together a template to get us started.
The next step will require you do some math. It will also help to arrange your windows so that you can see both the template sheet and the master data sheet at the same time. Remember that, for your report, you can focus on certain types of jobs (or do all of them). For this step, we want to carefully complete the template spreadsheet for the job categories you want to highlight.
Generating a Graph
Here’s the good news–once we have generated a data, it is quite easy to transform that data into a graph. Google has some simple documentation in case you need a refresher at home.
After we generate the graph, we can play with the formatting options. We should:
- Give our graph a title (include Figure 1)
- Give our graph a legend
- Give our graph some data labels
Homework
For Friday, create two other graphs–one on Professional Competencies and the other on Personal Characteristics. In Friday’s class, I’m going to break you into groups to do some collaborative invention for the report (and I will finally give you an overview of the whole project). I tentatively have the final report due next Friday at midnight. This is negotiable.
For Monday’s class, read Corder’s “Argument as Emergence, Rhetoric as Love” and complete the Canvas assignment.
