Spreadsheet lesson for 7th Grade History
7_SS_SS_Population_Directions
Class Periods: 2
Software: Microsoft Excel
Technology TEKS: 1C, 8E, 1A, 1B, 1F, 7B
Subject Area TEKS: 11B, 11D
Brief Description: Seventh grade Texas History students will create a spreadsheet and create a clustered column graph from the data.
Note – Materials Needed: Teacher will need to make copies of the info sheet prior to coming to the lab. This handout is saved as 7_SS_SS_Population_wksheet and can be located in Scommon/MS Tech Templates/ Grade 7 folder.
Cut info sheets in 1/3 for students to use at the computer.
1. Seat students in the lab.
2. Login to the network.
3. Open Microsoft Excel spreadsheet software.
4. Set up spreadsheet:
• Resize Column A, Column B and Column C:
Place mouse between Column A and B on the line. When the arrow changes, click mouse, hold and drag to the right about 2 inches to increase size. Resize column B and column C the same way.
• Click in cell A1 and enter Ethnic Groups. Click on Column A and set the font size to 14 and style to Bold.
• In cell B1 enter 2000. Set size to 14 and set style to Bold.
• In cell C1 enter 2010 and size to 14 and set style to Bold.
5. Enter data using the 1/3 sheet handout from your teacher, continue to type data into the spreadsheet.
6. Save spreadsheet. Route to H drive.
7. Create the Bar Chart/Graph:
• Highlight: Cell A2 – C6.
• Insert in the menu ( Chart
• Click OK.
• Choose clustered column that is already selected.
• Click Next.
• Click Series Tab – Type 2000 in the Name space.
• Click Series 2.
• In the Name space click and enter 2010.Click Next.
8. Type in the following:
• Chart title: Texas Population
• X Axis: Ethnic Groups
• Y Axis: Number of People
• Click Next.
• Click in the radio button beside: As new sheet.
• Click Finish.
9. Click Save.
10. Print 1 copy per teacher instructions. Be sure to choose page orientation - Landscape.
If time permits,
• Students can make color changes to the bars, format text to other sizes and fonts.
• Students may make another chart type that they choose – pie, etc.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- how to create accessible excel documents
- introduction to microsoft excel
- indiana university northwest a106 dorin
- ms excel mcq quiz set 1 e library wcl
- step 1 open microsoft excel information technology
- excel course part one formatting a database
- spreadsheet lesson for 7th grade history
- microsoft excel 2013 formulas and functions
- personal budget excel assignment
Related searches
- 7th grade history curriculum homeschool
- 7th grade history worksheet
- 7th grade history worksheets free printable
- 7th grade history textbook
- 7th grade history worksheets free
- 7th grade history worksheets
- california 7th grade history standards
- 7th grade history lesson plans
- 7th grade history book pdf
- 7th grade history textbook free
- 7th grade history textbook online
- 7th grade history book california