SILS iSchool

week of 06 April 2021

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. 19 Jan intro and clients | lecture | labs
  2. 26 Jan servers and command line | lecture | labs
  3. 02 Feb networks and protocols | lecture | labs
Web Development | sessions 04-08

  1. 09 Feb structural layer | lecture | labs
  2. 16 Feb presentational layer | lecture | labs
  3. 23 Feb using a structure | lecture | labs
  4. 02 Mar behavioral layer | lecture | labs
  5. 09 Mar design thoughts | lecture | labs
Dealing with Markup | sessions 09-10
  1. 16 Mar control objects and display | lecture | labs
  2. 23 Mar tools that read markup | lecture | labs
Working with data | sessions 11-14
  1. 30 Mar formulas, functions, vectors | lecture | labs
  2. 06 Apr data display | lecture | labs
  3. 13 Apr manipulate data sets | lecture | labs
  4. 20 Apr relational data bases | lecture | labs
Presentations | sessions 15-16
  1. 27 Apr designing a presentation | lecture | labs
  2. 04 May 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

Still using your downloaded workbook ...

prepare a worksheet to use to select the data

Copy the 10-KoreanWar_State worksheet, rename it 18-Chart 1 Data, and place it in order, near the end of your worksheets.

back to top

Prepare the data

  1. Using the data on the 18-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 Persons Serving in the Korean War
  4. Insert the sheet right after the 18-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 06 April labs | thinking about what kind of charts | compare value to categories | compare value percentages to categories