|
|
 |
||
 |
||
 |
||
 |
||
 |
||
 |
||
|
|
||
 |
||
 |
||
|
|
||
|
|
||
|
|
||
|
| ||
|
|
||
 |
||
 |
||
 |
||
 |
||
 |
||
 |
||
 |
||
 |
||
 |
||
|
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.
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
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.
DMS Comp App Home ~ MSD Decatur Home Page ~ Decatur Middle School Home Page
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
center align. 