Subdomain 5.1 Create charts
5.1.1 Create charts
Directions:
1.) Download the file (above).
2.) Select Tuesday's data (G4:G9).
3.) Go to "Insert" tab and "Charts" group.
4.) Select "Recommended Charts" and go to the "All Charts" tab.
5.) Select "Clustered Column Chart" and hit OK.
6.) Go to the "Design" tab (Note: you have to click the chart to see the design tab) and "Data" group.
7.) Click "Select Data"
8.) Click "Edit" (Horizontal Axis Labels).
9.) Select range A5:A9.
10.) Click OK
To Get Credit: See next step.
1.) Download the file (above).
2.) Select Tuesday's data (G4:G9).
3.) Go to "Insert" tab and "Charts" group.
4.) Select "Recommended Charts" and go to the "All Charts" tab.
5.) Select "Clustered Column Chart" and hit OK.
6.) Go to the "Design" tab (Note: you have to click the chart to see the design tab) and "Data" group.
7.) Click "Select Data"
8.) Click "Edit" (Horizontal Axis Labels).
9.) Select range A5:A9.
10.) Click OK
To Get Credit: See next step.
5.1.2 Create chart sheets
Directions:
1.) Use the SAME file from 5.1.1
2.) Right Click on the chart from 5.1.1
3.) Move the chart to a new sheet.
To Get Credit: Show me the chart showing Tuesday's data with the employee names below the data. To get credit, this chart must be in a new sheet.
1.) Use the SAME file from 5.1.1
2.) Right Click on the chart from 5.1.1
3.) Move the chart to a new sheet.
To Get Credit: Show me the chart showing Tuesday's data with the employee names below the data. To get credit, this chart must be in a new sheet.
Subdomain 5.2 Modify charts
5.2.1 Add data series to charts
Directions:
1.) Download the file (above).
2.) Click on the chart and the data will be highlighted.
3.) Put the cursor in the bottom right until you get the sideways double arrow.
4.) Pull the data in to Friday.
To Get Credit: Show me the chart with Friday's data included.
1.) Download the file (above).
2.) Click on the chart and the data will be highlighted.
3.) Put the cursor in the bottom right until you get the sideways double arrow.
4.) Pull the data in to Friday.
To Get Credit: Show me the chart with Friday's data included.
5.2.2 Switch between rows and columns in source data
Directions:
1.) Download the file (above).
2.) Click on chart.
3.) Go to Design Tab.
4.) Click "Switch Row Column".
To Get Credit: Show me how to switch rows and columns. Demonstrate it.
1.) Download the file (above).
2.) Click on chart.
3.) Go to Design Tab.
4.) Click "Switch Row Column".
To Get Credit: Show me how to switch rows and columns. Demonstrate it.
5.2.3 Add and modify chart elements
Directions:
1.) Download the file (above).
2.) Click on chart.
3.) Notice the + button thingey that appears in the upper right corner. Click it.
4.) Add "Data Table" and "Data Labels"
To Get Credit: Show me the chart with "Data Table" and "Data Labels" added.
1.) Download the file (above).
2.) Click on chart.
3.) Notice the + button thingey that appears in the upper right corner. Click it.
4.) Add "Data Table" and "Data Labels"
To Get Credit: Show me the chart with "Data Table" and "Data Labels" added.
Subdomain 5.3 Format charts
5.3.1 Apply chart layouts
Directions:
1.) Download the file (above).
2.) Click on chart.
3.) Click on Design.
4.) Choose the "Quick Layouts" dropdown.
5.) Choose "Layout 9".
To Get Credit: Show me the chart with Layout 9 applied.
1.) Download the file (above).
2.) Click on chart.
3.) Click on Design.
4.) Choose the "Quick Layouts" dropdown.
5.) Choose "Layout 9".
To Get Credit: Show me the chart with Layout 9 applied.
5.3.2 Apply chart styles
Directions:
1.) Download the file (above).
2.) Click on chart.
3.) Go to Design tab.
4.) Look in "Chart Styles" group and hit "more" button.
5.) Apply "Style 8"
To Get Credit: Apply Style 8 to the chart.
1.) Download the file (above).
2.) Click on chart.
3.) Go to Design tab.
4.) Look in "Chart Styles" group and hit "more" button.
5.) Apply "Style 8"
To Get Credit: Apply Style 8 to the chart.
5.3.3 Add alternative text to charts for accessibility
Directions:
1.) Download the file (above).
2.) Right Click on the chart.
3.) Choose "Edit All Text"
4.) Describe the chart in the Alternative Text box. (Just make it up)
5.) Change the colors (as shown in the video)
To Get Credit: Show me that you know how to change colors on the chart. Show me that you added alternative text.
1.) Download the file (above).
2.) Right Click on the chart.
3.) Choose "Edit All Text"
4.) Describe the chart in the Alternative Text box. (Just make it up)
5.) Change the colors (as shown in the video)
To Get Credit: Show me that you know how to change colors on the chart. Show me that you added alternative text.