Technology Lessonsfor the Social Studies

1.Flash Cards in Word2. Statistical and Mapping Web Sites3. Screen Shots, Histograms, &

Graphs4. Slideshows and Quick Time Movies

Materials found at:houstonhs.scsk12.org/

~robinsonm

Flash Cards in Word•Type definitions in Microsoft Word

•Place a colon : between the term and the definition.

•Highlight all of the words.

•Go to Table > Convert > Text to Table

•Make the number of columns 2

•For Separate text at select Other and type :

•Click OK

Census Bureau Specialized Graphs

Click on:

Data Sets >

Decennial Census >

Detailed Tables

Population Reference Bureauprb.org

city-data.com

city-data.comGermantown, TN

city-data.comComparing Median Household

Income in Germantown, Bartlett, and Memphis

nationalatlas.com

Examples:

Precipitation

Congressional

Elections

redistrictinggame.org

Yahoo or Google Maps

Starbucks in:

Shelby County

Poplar and Germantown Road

Cordova

Screen Shots

•Full Screen PDF:

•Hold down: Shift + Apple + 3.

•Select a specific part of the screen:

•Hold down: Shift + Apple + 4.

Where will I find a Starbucks?

•Examining SCALE at a local, national, and global level

•Where will one find Starbucks in Shelby County, in the United States, and inthe World?

•Analyze data, create a graph (histogram), and map the data on a map of Shelby County, a map of the United States, and a map of the world.

Histogram•A graphical display of tabulated

frequencies.

•A table which shows what proportion of cases fall into eacho f several or many specified categories (referred to in Excel as bins)

•Differs from a bar chart in that it is the area of the bar that denotes the value, not the height.

Frequency

Frequency

Value

The number of states with a

specific number of Starbucks, e.g. 10

states have between 0 and 25

Starbucks.

Constructing Histograms

Between 700 and 725 Starbucks there

are 2 countries or states:

Japan - 701

Texas - 718

Percentage of Voters for President Bush, 2004

%

Percentage of Voters for President Bush, 2004

%

Percentage of Voters for President Bush, 2004

%

Population Pyramids

Directions for finding

Age and Sex Statistics

go to: www.census.gov

Go to www.census.gov and click on “American FactFinder”

Click on “PEOPLE” and select “Age and Sex”

Type in the name of the location andclick “GO.”

Type in the name of the location andclick “GO.”

Click on “2000”Click on “2000”

Click on “Age Groups and Sex”

Click on “Age Groups and Sex”

Use the statistics for the columns:

Male and Female

Use the statistics for the columns:

Male and FemaleUse the

Total Population

Use the Total

Population

Age and Sex Statistics for Countries

Around the Worldgo to: http://www.census.gov/ipc

/www/idbpyr.html

Select your countrySelect your country

Click “Submit”Click “Submit”

Scroll down to find the list of data and click

on “Extract data from IDB

Online Aggregation”

Scroll down to find the list of data and click

on “Extract data from IDB

Online Aggregation”

Country’s Total

Population

Country’s Total

Population

Statistics for Males and Females

Statistics for Males and Females

Directions for Constructing

Population Pyramids in

Microsoft Excel go to: www.prb.org

Population Pyramids in Excel

Download the Pyramids (Excel)

Print out this Direction Page

Download the Pyramids (Excel)

Print out this Direction Page

Type in the statistics from

the Census Bureaufor Males and

Females

Type in the statistics from

the Census Bureaufor Males and

Females

Type in thetotal population

Type in thetotal population

Open up a Microsoft Excel Workbook

and fill in the following…

Click in B2 and type in the

formula

Click in B2 and type in the

formula

Move the mouse to the bottom right corner of B2 and

when the box appears drag the box

down to B19

Move the mouse to the bottom right corner of B2 and

when the box appears drag the box

down to B19

***The statistics for Males will all be negative numbers.

Click in C2 and type in the

formula

Click in C2 and type in the

formula

Move the mouse to the bottom right corner of C2 and

when the box appears drag the box

down to C19

Move the mouse to the bottom right corner of C2 and

when the box appears drag the box

down to C19

Highlight

Highlight

Go to Insert and select “Chart...”

Go to Insert and select “Chart...”

Click on: “Custom Types” “User-defined”

“Population Pyramid”“Finish”

Click on: “Custom Types” “User-defined”

“Population Pyramid”“Finish”

Type in the location for

the population pyramid.

Type in the location for

the population pyramid.

Answers

•1. E

•2. D

•3. B

•4. A

•5. F

•6. C

Answers

•1. B

•2. A

•3. E

•4. C

•5. G

•6. H

•7. F

•8. D

Slideshows not in iPhoto•Place all images in a folder.

•Double click on the folder.

•Go to Edit > Select All (all the images in the folder should be selected) > Hold down the Control (ctrl) and click on any of the pictures selected (highlighted) > A popup menu will then appear and select Slideshow.

•Examples: New Orleans from National Geographic Magazine web site, a Banana Plantation in Guatemala, and Canadian antismoking advertisements on packs of cigarettes.

iPhoto Slideshow•Directions on how to create a

slideshow

•How to create a QuickTime Movie

•Examples: Oceania, Greenland, Iceland, Hurricane Katrina, and Walking In Memphis

Handouts and directions can be found at: http://houstonhs.scsk12.org/~robinsonm

Click on the link below…

Information on the Web Site: