whom you would recommend this book to – boys, girls, boys and girls. Sort by genre, recommendation, etc.
Tip: Make sure you give students access to the spreadsheet of collected information. On the spreadsheet window, click on the Share button and set to Anyone with the link, then click the Save button. Post the link to the spreadsheet and students and parents can now view the book database.
5. Collect links and/or embed codes from all students. When my students create a Voki or Glogster, I have them copy the embed code and paste it into a simple form that includes a drop down list of homeroom teachers (so I can sort by class), a text box for their name (1st
+ last initial), and a
paragraph text box for their code. Once I have everyone’s embed code, I can copy and paste into a widget/plugin in a classroom collection wiki page.
Tip: Once I have collected all student information, I take the form off our class wiki page. I have found that strange but interesting things sometimes appear in the spreadsheet (submitted by students who might not be using their time wisely) if the form is left up after its usefulness is over.
6. Use as a peer evaluation of projects. This is especially good for group work. Students can evaluate each member of the group including themselves. Sort the spreadsheet by names of the group members to ‘clump’ students together. This will make it easier to evaluate group opinions of individuals.
Tip: When students click the Submit button, they will receive a default message which is pretty boring. Click the More actions button in the top right corner; then click Edit Confirmation. I like to ‘pat them on the back’ for finishing the Form and then give them directions. For example: Thanks for evaluating the Dream Vacation project. Now go play CarrotSticks or MultiFlyer!
Tip: Add a paragraph text box as the last ‘question’ on the Form to write individual comments.
10. Collect data – for example Science experiment data – in a Google form. Students can enter measurements of growing plants, the angle of incline + distance a marble rolls, or a list of what a magnet attracts and what it doesn’t. Students can export data to an Excel spreadsheet to sort, average, total, and create charts.
Tip: Students can access any Google Form via a link (which is a monster – use
bit.ly or tinyURL to shorten!), but I prefer to embed into the classroom wiki page which is super easy (and quite attractive!).
Marilyn Western is the 2008 MACUL Teacher of the Year, a former member of the MACUL Board of Directors, a Discovery Educator Network (DEN) scholar, and a Mt. Pleasant Public Schools 5th/6th grade computer lab teacher. Outside of the classroom, she has worked as the 1998-99 MDE Technology Using Educator on Loan, a MI Champions course designer and instructor, a technology trainer for Clare Gladwin RESD, Gratiot Isabella RESD and Bay Arenac ISD, a national presenter for the Bureau of Education & Research, and a district Tech Guru. She can be reached via mwestern@
edzone.net.
7. Survey what students already know about a topic before you begin the unit. Return to the Form page at the end of the lesson/ unit and have students answer the same questions again to show you what they have learned.
Tip: Sort by student name and the timestamp will show you the pre- and post-answers to what they know about the topic.
8. Individuals can use as a reading record. How many books can you read in a month? In a semester? This year? Sort by student names to see numbers of books read. Sort by genre to see what’s ‘hot’ in your classroom.
9. Rubrics can be created with a checklist form. Use the Scale Question Type (the default 1-5 works best) to create a rubric for a presentation. As students are presenting their work, simply add the student name and grade each category on the list. When finished, you’ll have a 1 page rubric spreadsheet. Export to Excel, add a formula to average all numbers for each student and you’ve got a presentation grade!
MACULJOURNAL
|
SPRING/SUMMER 2012
|
19
Page 1 |
Page 2 |
Page 3 |
Page 4 |
Page 5 |
Page 6 |
Page 7 |
Page 8 |
Page 9 |
Page 10 |
Page 11 |
Page 12 |
Page 13 |
Page 14 |
Page 15 |
Page 16 |
Page 17 |
Page 18 |
Page 19 |
Page 20 |
Page 21 |
Page 22 |
Page 23 |
Page 24 |
Page 25 |
Page 26 |
Page 27 |
Page 28 |
Page 29 |
Page 30 |
Page 31 |
Page 32