Mike Kreicker
Ann
Zinyemba

Word
Access
Excel
Publisher
PowerPoint

 
 
 

Microsoft Excel Lesson #3- State Information Research & Graphs

Essential Question: How can I organize data and create visual support for the conclusion I have drawn using a computer?

NTES Standard:

6. Technology Problem-Solving and Decision-Making Tools

a. Students use technology resources for solving problems and making informed decisions

By the End of Grade 7-

Students know how to integrate data-gathering instruments (e.g., probes, electronic calculators, handheld devices) with spreadsheets, use data analysis tools within the spreadsheet to analyze the data, graph results, and inform conclusions drawn from the data.

6. Technology Problem-Solving and Decision-Making Tools

b. Students employ technology in the development of strategies for solving problems in the real world.

By the End of Grade 7-

Students know how to apply formulas, functions, and “what if” statements in spreadsheets and graphs or charts to analyze and interpret data for content assignments.

Resources: Senator's Letter, Copies of Rubric/Self Check, Research Sheet, State Info Example Chart

Points: 25 Points

Save As: “LastNameFirstIntial”State

Directions: Podcast


Day #1- Input Data Into State Excel Chart-

Step 1)  Go to Start<Programs<Microsoft Office<Microsoft Excel . In your new sheet, type the following column headings across Row #1.

  A B C D E F G
1 State Population Total Area Land Area Water Highest Point Lowest Point
2 Indiana 12,040,831 36,420 35,870 550 1257 320

Step 2 Highlighting Row- Highlight Row #1 by clicking on the number 1.

Step 3 Bold Column Headings- Go to BOLD (the big B)! It should bold your column headings.

Step 4 Data Input- Then fill in your information adding only the numbers. NO labels in the cells for your data and DO NOT type in commas. If it automatically adds commas, that is ok. Just don't type them.

Step 5 Center Align- Highlight the entire sheet from A1 to G6 and center align.

 

Step 6 Multi-Selecting- On the number 2 in the gray, click and it will highlight Row 2, hold down Control (Ctrl). While  still holding Ctrl, click in the gray area on rows 4 & 6 and on columns B, D, F and H. All these rows and columns should be highlighted. 

Step 7 Adding Color- Go to the Paint Bucket on the Home ribbon and select a light color.

Step 8 Row Height- Highlight all the cells in chart from A1 to G6. Go to Home Ribbon>Cells>Format>Row Height>Type 18 and hit Ok.

Step 9 Column Width- Highlight all the cells in chart from A1 to G6. Go to Home Ribbon>Cells>Format>Column Width>Type 14 and hit Ok.

Step 10 Adding Borders- Highlight all the cells in chart from A1 to G6. Right click>Format Cells>Border Tab>Outline and Inside>hit OK.

Step 11 Adding Header- Go to Insert Ribbon>Header and Footer> in the header text box type> Your Name and Period.

Step 12 Change View- Click outside of the header text box!  then, go to the bottom right hand corner by the 100% bar and 3 buttons to the left is the Normal button. Click on the Normal button and it will go back to the normal view.

Step 13 Changing Page Layout- Go to Page Layout on the ribbon>Orientation<Landscape

Step 14 Save- Save as “Last Name First Initial State”. DO NOT PRINT!

STOP FOR TODAY

Day #2- Creating the Charts

Step 15 Double Check- Double check your data in the cells. Besides your column and row headings, only numbers should be in the cells . NO labels in the cells for your data and DO NOT type in commas. 

Step 16 Creating Pie Chart- Click in cell B6, hold Ctrl, and drag up to B1. While still holding Ctrl, highlight from A6 to A1. Go to Insert Ribbon>Chart>Pie>3-D Pie>Exploded Pie Chart.

Step 17 Adding Data Labels on Pie Chart- Highlight/Select the Pie Chart. Look for the new ribbon under Chart Tools>Layout>Data Labels>Inside End.

Step 18 Creating 2-D Bar Graph- Click in cell C1, hold Ctrl, and drag up to C6. While still holding Ctrl, highlight from A1 to A6 Go to Insert Ribbon>Chart>Bar>2-D Column Graph

Step 19 Adding X & Y Axis Titles- Look for the new ribbon under Chart Tools>Layout>Axis Title>Primary Horizontal Title. Click in the text box that appears on graph and type "States."

Look for the new ribbon under Chart Tools>Layout>Axis Title>Primary Vertical Title Axis>Rotate Title. Click in the text box that appears on graph and type "# of Square Feet."

Step  20 Removing the Legend on Bar Graph- Look for the new ribbon under Chart Tools>Layout>Legend>None.

Step 21 Create Another Bar Graph- You have columns D-G left. Pick one other column and make a bar graph. You have to highlight the state column and the other column you choose. Make sure and add axis labels and chart titles. Also, clear the legend on it. YOU SHOULD BE ABLE TO DO THIS, BECAUSE WE HAVE MADE 3 CHARTS IN LESS THAN A WEEK.

Step 22 Resize and Arrange Charts to Fit on One Page- Resize you charts to fit on page like my example. Go to 1st button in lower right hand corner by the 100% bar called the Page Break Preview. This button will let you preview. To get back to Normal View, click to buttons to right of Page Break Preview.

Step 23 Save- Hit disk up by Office Button to save.

RUBRIC and SELF CHECKLIST!

Step Self Check List Teacher's Checklist
3rd Step-Bold Column Headings   1 Point
4th Step- Input Data   1 Point
5th Step- Center Column Headings   1 Point
7th Step- Adding Color   1 Point
8th Step- Row Height   1 Point
9th Step- Column Height   1 Point
10th Step- Adding Borders   1 Point
11th Step- Adding Header   1 Point
12th Step- Page Layout to Landscape   1 Point
16th Step- Create Pie Chart   3 Point
17th Step- Pie Chart Data Labels   1 Point
18th Step- Bar Graph Labels   3 Point
19th Step- X & Y Axis Labels   1 Point
20th Step- Remove Legend from Bar Graph   1 Point
21st Step- Create Your Own Bar Graph & Label It   5 Point
23rd Step- Print Preview & Fit on One Page   1 Point
 Print, Attached Rubric, Put in Tray   1 Point
  Total ____/25 Points

DMS Comp App Home ~ MSD Decatur Home Page ~ Decatur Middle School Home Page

 


Ann Rosborough

Decatur Middle School Computer Applications
5108 S. High School Rd.
Indianapolis, Indiana 46224