SILS iSchool

week of  02 April 2020 

thinking about what kind of charts | compare value to categories | compare value percentages to categories



Value Added | daily

Class Schedule

Basics | sessions 01-03
  1. 09 Jan intro and clients | lecture | labs
  2. 16 Jan servers and command line | lecture | labs
  3. 23 Jan networks and protocols | lecture | labs
Web Development | sessions 04-07

  1. 30 Jan structural layer | lecture | labs
  2. 06 Feb presentational layer | lecture | labs
  3. 13 Feb using a structure | lecture | labs
  4. 20 Feb behavioral layer | lecture | labs
Document Markup | sessions 08-09
  1. 27 Feb control objects and display | lecture | labs
  2. 05 Mar tools that read markup | lecture | labs
Working with Data | sessions 10-13
  1.  26 Mar  formulas, functions, vectors | lecture | labs
  2.  02 Apr  data display | lecture | labs
  3.  09 Apr  manipulate data sets | lecture | labs
  4.  16 Apr  relational data bases | lecture | labs
Presentation | session 14
  1.  23 Apr  designing and delivering a presentation | lecture | labs


Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.

home & schedule | syllabus | contact | grades
Create a chart that compares one data set by states

prepare a worksheet to use to select the data

Copy the 10-KoreanWar_State worksheet, rename it 16-Chart 1 Data, and place it at the end of your worksheets.

back to top

Prepare the data

  1. Using the data on the 16-Chart 1 Data worksheet, create a chart to look at the US Military Serving and Battle Casualties by State of Pre-Service residence (column G).
  2. Arrange the data from lowest number on the left to highest on the right (this will require sorting).

back to top

Generate the chart

  1. Use a chart that compares values (Estimated Number Serving) to categories (State).
  2. Place the chart on a separate worksheet. This means the chart stands alone on a worksheet and does not float above a grid of cells on a worksheet.
  3. Name the standalone chart Numbers of Persons Serving in the Korean War
  4. Insert the sheet right after the 16-Chart 1 Data worksheet.  

You may use the chart wizard, but do not use the defaults.

back to top

Demonstrate facility with the chart formatting tools

  1. You will need to work with the chart tools to ensure that the X or Y axes (depending on whether you use a column or a bar chart) are labeled. 
  2. Include a chart title and modify the display in some fashion to make it unique to your style. 

back to top

week of 02 April labs | thinking about what kind of charts | compare value to categories | compare value percentages to categories