Using excel 2 nd Grade Excel Project Graphing

Using excel 2 nd Grade

§ Excel Project- Graphing § Susie Fjeldal § Audience: 2 nd Grade § NJCCC Standard 2. MD. 10 (Measurement and Data: Represent and Interpret Data)- Draw a picture graph and a bar graph to represent a data set up to four categories. Students will solve simple put together, take apart, and compare problems using information presented in a bar graph. § Time Line- 4 days § Objective: SWDAT create a tally, spreadsheet grid, collect and analyze data and create a simple vertical bar graph to show results § Day 1: After review of: tally marks, survey, data, and table, as whole group instruction, we will ask the survey: What is your favorite candy? Choices including M&M’s, Swedish Fish, 3 Musketeers, Milky Ways. Teacher will ask each student the survey one at a time, recording their responses using tally marks. Students will also record the data on their paper. Teacher will model and show to use excel to transfer the responses in a table. Last teacher will show to take the information from the table and create a bar graph in excel. § Day 2 - Students will work with a partner to create a survey containing four choices. Partners will brainstorm and write out a question containing four choices. Students will the choices. They will collect data by walking around the classroom, asking their question and collecting answers given by their peers. They will collect the data in the form of tally marks. § Day 3 - Partners will use excel to enter their choices and data collected into a table with a predetermined formula. Then students will create a graph using a spreadsheet. Partners will create a bar graph using excel including a title for the graph and labels for the y and x axis. § Day 4 - Share information gathered. § Assessment/Evaluation: rubric and completed excel project

Teacher will ask the survey: What is your favorite candy? Choices: • M & M’s • Swedish Fish • Milky Way • 3 Musketeers Teacher will ask the survey to one student at a time and record their responses using tally marks. Students will follow along on their paper. Next Step: Transfer the data collected from the survey into a table using formulas. Survey: What is your favorite candy? Choices Swedish Fish Milky Way M & Ms 3 Musketeers Tally Marks

Survey: What is your favorite candy? Choices Swedish Fish Milky Way M & Ms 3 Musketeers Tally Marks

First: Teacher will model step by step directions on how to select a graph using excel. Next: Students will be shown how to: • Title the Graph • Last: Teacher will show to change graph styles once students input their data on a group level basis. Name the x and y axis.

Survey: What is your favorite animal? Survey: What is your favorite football team? Choices Tally Marks fish NY Giants NY Jets New England Patriots Miami Dolphins Survey: What is your favorite special class? Choices Art Gym Music Spanish Tally Marks cat dog bird Tally Marks

Students enter their survey choices and data collected from the survey into an excel table. The table will include a predetermined formula adding the total sum of the entered data. A bar graph will be created as students enter the data.

Category 4 3 Title relates to the information being graphed and is printed at the top of the graph. 2 A title is present at the top of the graph but is reflected of the data. . 1 Title clearly relates to the information being graphed. It is at the top of the graph with proper capitalization. A title is not present. Axis Labels clearly relate to Labels are clear but The labels are present, Labels are not present. the information on each labeled in the wrong axis. but may not describe axis with proper the information capitalization. . Presentation of Graph Students use All bars are correct customized bar designs. size and are easy to see with some customized bar designs. All bars are correct size All bars are correct with little customized bar size with no designs. customized bar design