Homework 8: A Tweeting President
The goals of this homework are:
- Demonstrate your ability to split text fields.
- Demonstrate your ability to draw graphs
- Demonstrate your ability to build a table.
- Demonstrate your ability to use a table to sort and filter data.
Start by downloading this file
I want to know about when the President was sending tweets
[2 points] break the data in column a into month, day, year, hour.
- There are functions which can do this, but I want to use the Text to Columns feature to accomplish this task.
- Start by splitting column A based on the /
- Make sure you insert columns for the split data.
- Format the new columns A and B as general.
-
- Next split column C as fixed fields.
- Split it into two parts.
- Format column C as general as well.
- Format column D as 24 hour time.
- Label the columns
-
[2 points] Build a table from the data.
- Sort this table based on retweets, largest to smallest.
-
[3 points] Build a frequency distribution based on time
-
- Make the graph look as close to the one pictured as possible.
- Copy these to a new worksheet.
- Label this worksheet Time
[3 points] Build a line graph driven by slicers
- Build a line graph showing replies and retweets.
- Add a slicer that allows the user to select the month.
- Add a slicer that allows the user to select the year.
-
Save the worksheet and upload it to the D2L assignment folder Homework 8