TOPIC 1- INTRODUCTION TO WATER TREATMENT

SP 1C-POPULATION GROWTH PROJECTIONS AND DEMAND ESTIMATION

The Project Manager for the company you are working for has assigned you the task of

developing a population projection and a projection of the estimated water demand which is to be

the basis for a water supply project for a given city. You were told to "use the SCAG data set" as the

basis.

On "Brightspace" there is a spreadsheet that was obtained from the Southern California

Association of Governments (SCAG). They are a regional planning agency that makes projections

of population, land use and other demographic parameters for transportation and other infrastructure

planning. The spreadsheet contains, among other things, population data from 1970 through 2012.

The area includes Los Angeles, Riverside, San Bernardino, Orange, Ventura, and Imperial Counties.

You are looking for worksheet tab (red tab) "1-1 Add SCAG City Pop".

Each student is assigned a specific city to perform the population projection. The cities and

their 2020 census population are as follows:

County

Imperial

Los Angeles

Orange

Orange

Riverside

Riverside

Riverside

San Bernardino

San Bernardino

City

El Centro

Glendale

Anaheim

Yorba Linda

Beaumont

Lake Elsinore

Perris

Ontario

Victorville

2020 Census

Population

44322

196543

346824

6833

53036

70265

78700

175265

134810

Current per

capita

demand,

L/capita/day

310

290

290

290

440

310

310

330

460

A separate list for the city assigned to each student is on Brightspace.

a) For your assigned city, using the population data in the table for the Census Years Only

(1970, 1980, 1990, 2000, 2010, and 2020 from the table above) and using Excel, graph the

population over time. You will need to download the spreadsheet to avoid re-entering the

data. Notice there are two populations for the "decade" years; use the population

marked "census" which is the highlighted column since that is the most accurate. The

intervening years are just estimates. Add the 2020 population to your data. Make sure

you use the "x-y scatter graph" not the "line graph" option. Use the straight line option

between points, NOT the smoothed curve option. Label your axes and the plot. Set the x-

axis maximum value to year 2050. For the y-axis (population), you don't need to start at

zero. You can set the axis minimum value to a "round number" less than the smallest

population. Make sure there are no decimals in the population axis; we don't want "decimal

people" - ever.