ࡱ> CEB` bjbj $ $$ =)2L L L L L    ((((((($o*h,( " (L L ( L L ( (%'L @ #1 &( )0=)&\_-_-0'_-' "1 I ]    ((    =) < <  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. Seat students in the lab. Login to the network. Open Microsoft Excel spreadsheet software. 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. Enter data using the 1/3 sheet handout from your teacher, continue to type data into the spreadsheet. Save spreadsheet. Route to H drive. 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. 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. Click Save. 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. 0CDI[q     , 1 N Q |     . 0 1 2 L ٽŹũ|uqhv hK$hA hQUh+; h%5 htr5 hG5 hg$5 hv/5 h5h!h!5h0sh+hrEh:&nhM{hvhQU5hQUhWDhqh\hm# hQUhQU hQUhAhrEhrE5hrEha)5hrEhw i5,0Jr  0 2 L b 8^8gdv/ & F 88^8gd!h^hgd0s & FgdM{ & Fgdv !gd+gdgdrEL Q a f v  " & 7 = K \ m  B F m n z ̾̾̾ӯӯӧh8!hv5hK$h%5 h:&n5 h!5 hwB5hK$hA5h!h!5 h%h8!h8!h!h+5>* h%h+h!jh%UmHnHuhwBh0sh+hM{h:&n hK$hA2 1 m n  1 L V   ! & F & Fgdv & Fgdv & Fgd% & Fgd\gd0s & F 88^8gd8! & F 88^8gd!     ! " . / 0 1 7 8 C D E F K L M ] m n   .>GT]mo۵Ԧ{ hK$h%h%hK$h/h/5hv/h/ h/h/ h/5h/hA5>* hv5hNhv5 jhNhK$h+;5hK$hA5 hK$hA hK$h+;hNhtr h8!h0shvhm# hvhv0!?Uo{/ & F gd%h^hgd0s & F & Fgd^q & F & Fgdv ouz{./AZb񽶽~~h% h0sh0sh0sh0s5 h%5 h0s5 h0shA hq5 h8!5 hv/5 hN5 hvh^q hv5 hK$h/ h/5>*h/h/5>* h/5h/ h/h/ h/h+;hK$h+;5 hK$h+;21h:p%/ =!"#$% nS[U3C4PNG  IHDRM[sRGB pHYs+IDATx^휽n@m "H4"6BGEjrQh.4К,w흙]Xηo?II|iXUUsnoƇ;Wu:&_ E$@&V`zÅk 7`[d %:c`a+JrGU ǔ7XpK70>ZR' >|ؽJQwRէ$sr2:} j F{?cSoiݢէǁ~`7D!ikyUp˚{c0t 7 ꣠tcV΀.KSh$P{e~|,'g TvҞI?gykK뾽Wah`nx$p}}`C@"@9$uCa!V>JE3x9u=Wgl]MDUJ !Om0^ܫ,η ͷ|9wauS}AyNX!5,H.[M? gw6Tp0Ѝͯkcd)da2Ϸ֒  xM\?gȲ,KH9P <)G=MчTM($&OTsF7"T1#BpUY`pyG ?<2YXMa l 靼^q0L^!049#_Q`#83ͥU1SPp<жV`}~XޯT`C4#ChHMDG0LEݔQ6$P)fx&Fl~a`qAKd#>fחLF0M44~6e5SIENDB`@@@ NormalCJ_HaJmH sH tH DA@D Default Paragraph FontRi@R  Table Normal4 l4a (k@(No List 0Jr02Lb1mn1LV  !?Uo{/0000000000000 0 0 00 0 00 0 0 00 00 00 0 0 0 0 0 0 0 0 000 0 0 0 0 0 0 0 0 0 00 0 0b{00ĕ"{00{00fXd2XdXdXd{00{00L o  !  l,b$[U3C4[4 @$(    S L CA. ==R`TR`T="`B S  ? $`@HDI ..339*urn:schemas-microsoft-com:office:smarttagsplace9*urn:schemas-microsoft-com:office:smarttagsState m3  VZ 5N 6Vw j" |X?f%BJ=`*jrj k:Lox/|\`h88^8`OJQJo(hHh^`OJQJ^Jo(hHoh  ^ `OJQJo(hHh  ^ `OJQJo(hHhxx^x`OJQJ^Jo(hHohHH^H`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHhpp^p`OJQJo(hHh @ L@ ^@ `LhH.h ^`hH.h ^`hH.h L^`LhH.h ^`hH.h PP^P`hH.h  L ^ `LhH.h ^`hH.h ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.h ^`hH.h ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.^`o(. ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH.h^`OJQJo(hHhpp^p`OJQJo(hHh @ L@ ^@ `LhH.h ^`hH.h ^`hH.h L^`LhH.h ^`hH.h PP^P`hH.h  L ^ `LhH.^`o(. ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH.h^`OJQJo(hHh^`OJQJo(hHh pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.h ^`5hH.h^`OJQJo(hHh pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH. J=k| w jrjf%Lo+5N                                                                         VXx        *)N8!U"#9#m#m9-v/wBWDrEQUeOgw i:&np^qtrv0+x/\q+R<&Y0sG+;AK$!%a)M{G\K:g$@ !h+  `@UnknownG: Times New Roman5Symbol3& : Arial;Wingdings?5 z Courier New"qhD*_+ɩ& ((!24d2QHP)?A2(Spreadsheet lesson for 7th Grade HistoryFMSLISD0         Oh+'0 $0 P \ h t,Spreadsheet lesson for 7th Grade HistoryFMSNormalLISD12Microsoft Office Word@x@@00@21(՜.+,0 hp  LISD )Spreadsheet lesson for 7th Grade History Title  !"#$%&'()*+,-./013456789;<=>?@ADRoot Entry Fh#1FData 1Table-WordDocument$SummaryInformation(2DocumentSummaryInformation8:CompObjq  FMicrosoft Office Word Document MSWordDocWord.Document.89q