Click to set custom HTML
Google Spreadsheets, Databases and Forms
Spreadsheets, databases and forms can be utilized in many ways in the primary classroom. Often, primary teachers think of math as they are thinking about using these google tools. However, these tools can beincorporated into literacy, lesson plans, science as well as social studies lessons very effectively. Here are
some examples of using these tools:
Data collection:
Spreadsheets have long provided a way to display data. Using this data in a way to track reading inventories by your students. Students record the information of the book they are reading in a google form stating the title and author. Then in the spreadsheet of information you can add comments or questions about your students’ book by selecting a cell and inserting a comment. This provides a great opportunity for interaction with the student about what they are reading.
Spreadsheets, databases and forms can be utilized in many ways in the primary classroom. Often, primary teachers think of math as they are thinking about using these google tools. However, these tools can beincorporated into literacy, lesson plans, science as well as social studies lessons very effectively. Here are
some examples of using these tools:
Data collection:
Spreadsheets have long provided a way to display data. Using this data in a way to track reading inventories by your students. Students record the information of the book they are reading in a google form stating the title and author. Then in the spreadsheet of information you can add comments or questions about your students’ book by selecting a cell and inserting a comment. This provides a great opportunity for interaction with the student about what they are reading.
Many educators are often inundated with paperwork of reading and writing conferences as they meet with each student. Some teachers create a very large detailed binder that they record in when meeting with students and student groups. Using a google form and knowing how you can organize the specific data by date or by category, there are easier ways to record conferences with students and to record the data effectively.
Creating a story with your class is another way of collecting ideas. Asking students their idea of character, feelings and attitudes of character, setting and problem can help the story editors put parts of the story together. This can be done as a story start for class writing, cooperative writing, as well as individual writing of stories. You can also collect ideas for good writing prompts that you can share the spreadsheet with students to give them a resource if they need one.
The collection of data in the form of a grade or rubric is another way for teachers to use spreadsheets in peer evaluation of participation in group work. Evaluating peers with 2nd grade is helpful and meaningful for some children to see and understand expectations. While partnering up to coach peers on revising a story, students were very honest about expectations and outcomes. Teaching the rubric first is important so all children will understand how they will be evaluated. Belief in peer review writing is important as well. Students often can be great evaluators of writing even if they don’t exactly know the correct terminology of the error.
Surveys
Creating surveys to collect information can be very helpful in getting to know your class or providing and helping make books available to students of their liking. Using this survey for reflection and goal setting would be extremely helpful as the teacher interprets the data. Finding information about confidence and ability and it’s relationship to the student is important as you begin teaching as well as mid-year comparisons or changes.
Creating surveys to collect information can be very helpful in getting to know your class or providing and helping make books available to students of their liking. Using this survey for reflection and goal setting would be extremely helpful as the teacher interprets the data. Finding information about confidence and ability and it’s relationship to the student is important as you begin teaching as well as mid-year comparisons or changes.
Create Lesson Plan Book
Using spreadsheets to store valuable information that can be easily accessed for teachers at home and school. Lesson plans and and all of the information that is needed for you to successfully record and follow can be placed in spreadsheets. In the month of January, there are 4 weeks, so during that month, there would be four sheets attached to each other titled January week 1, week 2, week 3, week 4. Because of ALL the links, videos and information that is used today in schools, having it all in one place can be extremely helpful. Here is the lesson template and a screenshot of it:
Using spreadsheets to store valuable information that can be easily accessed for teachers at home and school. Lesson plans and and all of the information that is needed for you to successfully record and follow can be placed in spreadsheets. In the month of January, there are 4 weeks, so during that month, there would be four sheets attached to each other titled January week 1, week 2, week 3, week 4. Because of ALL the links, videos and information that is used today in schools, having it all in one place can be extremely helpful. Here is the lesson template and a screenshot of it:
Sample Lesson Plan Framework:
Purpose of Lesson: The students will participate in typing words to describe characters from our read aloud in a google form. The students will then collaborate and write one character description using some of the words provided by their peers from the story.
Standards addressed in lesson
- CCSS.ELA-Literacy.W.2.8 Recall information from experiences or gather information from provided sources to answer a question.
- CCSS.ELA-Literacy.RL.2.3 Describe how characters in a story respond to major events and challenges.
- Using technology in the community
- Using electronic database to locate information
- Building word processing skills
- Collecting, sorting, and displaying data
When finished with their descriptions of the characters in this story, we will display these descriptions underneath a child drawn portriat of these characters of The Watsons Go To Birmingham. We can continue to add to our display with other characters in the story like the mother, father and friends, Buphead and Rufus.
Lewis, Jeff Using google spreadsheets and form to create a class reading log for accountability for reading: Retrieved from:
http://www.coetail.com/jefflewis9/2014/01/14/using-google-drive-for-a-class-reading-log/
Creating a reading survey to see how your class feels about reading and their specific interests Retrieved from:
https://spreadsheets.google.com/viewform?hl=en_GB&formkey=dDBPZWgwT0dzb2JiLVNXaHFXVVVmd2c6MA..#gid=0
Website evaluation and peer feedback Retrieved from:
https://docs.google.com/presentation/d/1f4HDe3dUGr4Ftx4d6EbkFzq_Ei7RjfweVp2DW2QLGmM/edit#slide=id.i169
Creating a story Retrieved from:
https://docs.google.com/presentation/d/1f4HDe3dUGr4Ftx4d6EbkFzq_Ei7RjfweVp2DW2QLGmM/edit#slide=id.i176
Excellent resource for using spreadsheets in the primary classrooms: Retrieved from:
https://blogs.glowscotland.org.uk/fa/ICTFalkirkPrimaries/2011/03/30/spreadsheets/
Bar graphs creation: Retrieved from: http://harcourtschool.com/activity/elab2004/gr3/26.html
Snails: Fact and Fiction. Retrieved from
http://www.learnnc.org/lp/pages/3349
Common Core Standards http://www.corestandards.org/
http://www.coetail.com/jefflewis9/2014/01/14/using-google-drive-for-a-class-reading-log/
Creating a reading survey to see how your class feels about reading and their specific interests Retrieved from:
https://spreadsheets.google.com/viewform?hl=en_GB&formkey=dDBPZWgwT0dzb2JiLVNXaHFXVVVmd2c6MA..#gid=0
Website evaluation and peer feedback Retrieved from:
https://docs.google.com/presentation/d/1f4HDe3dUGr4Ftx4d6EbkFzq_Ei7RjfweVp2DW2QLGmM/edit#slide=id.i169
Creating a story Retrieved from:
https://docs.google.com/presentation/d/1f4HDe3dUGr4Ftx4d6EbkFzq_Ei7RjfweVp2DW2QLGmM/edit#slide=id.i176
Excellent resource for using spreadsheets in the primary classrooms: Retrieved from:
https://blogs.glowscotland.org.uk/fa/ICTFalkirkPrimaries/2011/03/30/spreadsheets/
Bar graphs creation: Retrieved from: http://harcourtschool.com/activity/elab2004/gr3/26.html
Snails: Fact and Fiction. Retrieved from
http://www.learnnc.org/lp/pages/3349
Common Core Standards http://www.corestandards.org/