sol_data_revsp10

sol_data_revsp10 - U se this file as a template, and adjust...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: U se this file as a template, and adjust the file as descr ibed below : This is a modified copy of r esult s for a 3r d gr ade SOL Social St udies exam fr om a Vir ginia school dist r ict (an infor mat ion has been changed or delet ed). St udent s ar e indent ified by a gener ic number and t eacher name alt er ed. The act ual dat a is accur at e. 1. Comput e t he aver age number of cor r ect r esponses for all st udent s using t he funct ion AVERAGE (i.e. =av t his comput at ion cell B50. 2. Sor t t he infor mat ion by Teacher 's names. L eave your work in sor t ed alphabet ic or der. (See H ow t o Sor t b cr eat e using symbols for addit ion, subt r act ion et c., i.e. =(b4+c4+d4)/3]. Place t his comput at ion in cell B51. 3. Comput e t he aver age number of cor r ect r esponses for K er mit t he Fr og's class using a f or mula [ an ar it hm f ollow or der of oper at ions when you cr eat e t he comput at ion! 4. Use color t o make t he spr eadsheet easier t o r ead by color ing t he differ ent t eacher s infor mat ion and colum differ ent backgr ound color (i.e. color K er mit t he Fr og's class scor es gr een, M r. Snufalufagus's class scor es ye 5. Edit cells A50 and A51 so t he t ext wr aps and you can r ead t he ent ir e cont ent s of each cell wit hout makin t his: r ight click on t he cell and select For mat Cells - Alignment - Wr ap Text . 6. Filt er s allow viewing of infor mat ion t hat fit a cer t ain cr it er ia. Cr eat e a filt er t hat allows you t o view onl class infor mat ion. (See H ow t o Cr eat e a Filt er box). 7. Char t s and gr aphs pr ovide a gr aphic display of t he dat a. Cr eat e a column char t wit h st udent number s f Add a Char t Tit le: Social St udies SOL Dat a for M r. Snufalufagus, and delet e t he legend (Ser ies 1). I nclude t he x and y axis in t he char t . class on t he x-axis (hor izont al), and t he number of cor r ect r esponses on t he y-axis (ver t ical). (see H ow to Cr 8. Click on t he D ATA TABL E tab at t he bot t om of t he scr een. L ook at t he for mulas used t o count r esponse fr om F10 t o I 25). The cor r ect r esponses ar e coded in r ed for each quest ion. How To Sort: How To Create a Filter: Version 2003 a in t he t able. Which quest ions did st udent s have t he least success on? Complet e t he t ab or earlier 9. Analyze t he dat Ver sion 2003 or ear lier 1. Highlight the data controlling the sort. In this example 1. Select cell S3 SOL # highlight the Teacher'sr ect . (just highlight the data, not and per cent age cor names 2. Select the Data Menu, F column headings or totals). Select the Data menu, Sort. 3. A dropbox will appear ne 2. A dialog box will tell you that there is data in other 4. and the dropbox next Save your -final ver sion theith the Teacher 'sthe data sor ted in alphabetic or der, Select the filt er show w selection" so that all names rows select "expand Snafalufagus. "stays together", sort in alphabetical order. Snufalufagus's class infor mation along w ith a char t show ing the data for M r. Snufalufagus's clas Note: You can turn autofilte 3. Click OK Ver sion 2007 1. Click in the area (column ) of the data controlling the sort. In this example click in the column of the Teacher's names. On the HOME tab in the Editing section (usually far right) click the Sort & Filter button. 2. From the dropdown menu choose the A to Z or Zto A per the directions. If prompted to "expand the selection" do so, this will ensure that all the data "stays together". Ver sion 2007 1. Select cell S3. 2. From the HOME tab in th Filter button, Click Filter. 3. This will turn the column boxes. 4. Select the dropdown box choices EXCEPT Mr. Snafa i r ginia school dist r ict (any ident ifiable m ber and t eacher names ar e, obviously, t ion AVERAGE (i.e. =aver age(b4:b11). Place or der. (See H ow t o Sor t box) ing a f or mula [ an ar it hmet ic expr ession you comput at ion in cell B51. H I NT: be sur e t o s i nfor mat ion and column headings using a alufagus's class scor es yellow, et c.). each cell wit hout making t he cell wider. To do at allows you t o view only M r. Snafalufagus's t w it h st udent number s for M r. Snufalufagus' ver t ical). (see H ow to Cr eat e a Char t box). gend (Ser ies 1). I nclude appr opr iat e labels for s u sed t o count r esponses (click in t he cells How To Create a Filter: ss sion 2003 or ear lier Veron? Complet e t he t able wit h t he quest ion #, 1. Select cell S3 2. Select the Data Menu, Filtering, Autofilter. 3. A dropbox will appear next to each column heading in row. 4. and the dropbox next ing only select er, Select the filter show to Teacher,M r. Mr. Snafalufagus. r . Snufalufagus's class. Note: You can turn autofilter off and on by repeating Step 2. Ver sion 2007 1. Select cell S3. 2. From the HOME tab in the Editing section click the Sort & Filter button, Click Filter. 3. This will turn the column heading labels into dropdown boxes. 4. Select the dropdown box next to Teacher, uncheck all choices EXCEPT Mr. Snafalufagus. How To Create a Chart: Ver sion 2003 or ear lier 1. Highlight the data to be included on the chart. 2. Select the Insert Menu, Chart, Column. 3. Using the Chart Wizard options (step 3), enter a chart title and labels for the x and y axis as directed, delete the legend. 4. In the final step of the chart wizard select the option to display the chart "as on object" on the same page. Ver sion 2007 1. Highlight the data to be included on the chart (data should STILL be filtered). 2. On the INSERT tab click the COLUMN button in the Chart section. Choice a column chart. 3. As long as the correct data was chosen your chart should appear. The tab in the toolbar should now reflect various editing tools for the chart as long as the chart is still selected (active). ed on the chart. , Column. ns (step 3), enter a d y axis as izard select the object" on the ed on the chart OLUMN button in mn chart. s chosen your he toolbar should for the chart as (active). SOL Results for Social Studies Student # sn 28392 sn 109977 sn 105028 sn 12479 sn 54633 sn 19054 sn 54282 sn 23755 sn 104847 sn 93554 # Correct 3.22 3.21 F F F F F F H F F H 3.22 C C C C C C C C C C 3.21 F J J J J J G F F G B B B B B B B B A D 3.3 3.23 G G G G G F F G J J 3.23 D D D D D D D D D D 3.14 G J G G G G G G F G 3.14 D B A D D D A D D A 9D 8B 14 B 14 B 13 B 10 B 9B 9A 8B 7C Average Score for all classes average score for Kermit The Frog's Class 12 12.25 cial Studies 3.15 G F J J J J J G F;J J 3.15 C A D D C C A A C B 3.16 F J J G G G G G J H 3.16 D A C C C A D B C C 3.16 F F;J F G F G F F G J 3.16 B B A C B A B D A 3.24 Teacher G F G G G G G G G G Mr Snufalufagus Mr Snufalufagus Mr Snufalufagus Mr Snufalufagus Mr Snufalufagus Mr Snufalufagus Mr Snufalufagus Mr Snufalufagus Mr Snufalufagus Mr Snufalufagus Social Studies SOL Data for Mr. Snufalufa Number of Correct Responses 15 10 5 0 10 50 28 54 63 3 54 28 2 28 39 2 10 48 47 sn sn sn Student Numbers sn sn r Mr. Snufalufagus 54 28 2 sn bers sn 10 48 47 Math Quarterly Assessment Marking Period 1 School Name: Sesame Street Elementary **Correct answer in Red Bold font** SOL Question 1 Question 2 Question 3 Question 4 Question 5 Question 6 Question 7 Question 8 Question 9 Question 10 Question 11 Question 12 Question 13 Question 14 Question 15 Question 16 3.22 3.21 3.22 3.21 3.23 3.23 3.14 3.14 3.14 3.15 3.15 3.16 3.16 3.16 3.16 3.24 A/F 3 38 1 7 1 2 1 4 6 10 8 1 6 27 17 5 B/G 31 3 0 3 42 40 1 38 4 5 2 11 1 9 10 37 C/H 4 2 43 0 0 0 1 0 3 3 14 2 34 3 11 1 D/J 6 1 0 34 1 2 41 2 31 25 20 30 3 3 5 0 % Correct 70% 86% 98% 77% 95% 91% 93% 86% 70% 57% 45% 68% 77% 61% 39% 84% Students Tested Top 3 Missed Questions Question# % Correct 15 39% 11 45% 10 57% Grade: 3rd 44 sed Questions SOL 3.16 3.15 3.15 ...
View Full Document

Ask a homework question - tutors are online