lesson4

Title: Lesson 4: "What Is Your Piece of the Pie Graph?"

Grade Level(s): 7th & 8th

Subjects: Mathematics: Computer/Technology, English/Language Arts

Learner Outcomes: The students will:

Interpret and organize data collected during research.
Create, save to a disc, and print a computer pie graph.
Recognize and understand that different careers offer a variety of salaries.

Duration of Lesson: One 45-minute class period

Materials:

Sample of completed pie graph
Teacher-created handout with pie graph instructions

Technology Tools:

Multimedia computer
Computer projector and screen
Computers with printer access
Microsoft Excel software
One floppy disc per student

Teacher Notes:

A signed Acceptable Use Policy for each student
Instructor should have a sound knowledge of Microsoft Excel software and graphs. They will insert completed pie graph into their PowerPoint presentation in Lesson 5.

Procedures:

Students will view via large group instruction, the step by step procedure in creating a pie graph using Microsoft Excel. After the instructor has modeled the procedure, questions will be answered. A previously printed pie graph created by the teacher comparing five salaries will be displayed for students to view. Teacher will distribute the graph instructions.
Students will use information they acquired from their research in lesson 1 and 2 to use in constructing their pie graph.
Assist students as needed.

Modifications: Peer assistance as needed

Enrichment Activities: Students who complete the pie graph early, can practice further by inputting the same or different information to make other types of graphs, e.g., bar, column, or doughnut graph, etc.

Evaluation/Assessment: Each student will turn in a printed, computer generated pie graph and floppy "a" disc containing their graph.

West Virginia IGO's:

Mathematics: Computer/Technology 7.46, 7.54, 7.55, 7.56 8.28,8.46, 8.57, 8.58

English/Language Arts 7.163,7.164,7.165, 7.169, 7.170, 7.171, 7.172, 7.173,7.3, 7.64,7.65 8.145,8.147, 8.150, 8.153,8.154,8.155,8.30,8.5,8.63,8.64,8.82

National Standards:

Mathematics

Standard 6 Level III 6.1 Understands basic characteristics of measures of central tendency (i.e., mean, mode, median)

Standard 6 Level III 6.6 Organizes and displays data using tables, graphs (e.g., line, circle, bar), frequency distributions, and plots (e.g.,stem-and-leaf, box-and-whiskers, scatter)

Standard 6 Level III 6.8 Understands that the same set of data can be represented using a variety of tables, graphs, and symbols and that different modes of representation often convey different messages (e.g., variation in scale can alter a visual message)

Technology

Standard 1 Level III 2. Types with some facility, demonstrating some memorization of keys

Standard 1 Level III 3. Connects via modem to other computer users via the internet, an on-line service, or bulletin board system

Standard 1Level 1V 2 Uses a variety of input devices (e.g., keyboard, scanner, voice/sound recorders, mouse, touch screen)

Standard 2 Level III 2. Knows the common features and uses of desktop publishing software (e.g., documents are created, designed, and formatted for publication; data, graphics, and scanned images can be imported into a document using desktop software)

Standard 2 Level III 3. Knows the common features and uses of spreadsheets (e.g., data is entered in cells identified by row and column; formulas can be used to update solutions automatically; spreadsheets are used in print form, such as look-up tables, and electronic form, such as to track business profit and loss)

References:
Microsoft Excel software

Authors:

Susan Boore
Paulette Trimble
Monica Zanussi
Barrackville School

Overview	Lesson 1	Lesson 2	Lesson 3	Lesson 4	Lesson 5
"Workin' 9 to 5"	"And It Says I Like What Job!?_______"	"Reality Check, Proceed If You Dare"	"Video Venture"	"What Is Your Piece of the Pie Graph"	"Powering Up Your Future"

Mathematics: Computer/Technology	7.46, 7.54, 7.55, 7.56	8.28,8.46, 8.57, 8.58
English/Language Arts	7.163,7.164,7.165, 7.169, 7.170, 7.171, 7.172, 7.173,7.3, 7.64,7.65	8.145,8.147, 8.150, 8.153,8.154,8.155,8.30,8.5,8.63,8.64,8.82