### week of 06 April 2021

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

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 18-Chart 1 Data, and place it in order, near the end of your worksheets.

#### 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).

#### 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.