1 / 27

G A L L : Day 2

G A L L : Day 2. Introduction to Google Forms Collecting Student Data Quizzes. Instructor: Anthony Schmidt Website: www.AnthonyTeacher.com. Activity 1 – Take this fun quiz!. Congratulations You have just used Google Forms!

mikasi
Télécharger la présentation

G A L L : Day 2

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. GALL: Day 2 Introduction to Google Forms Collecting Student Data Quizzes Instructor:Anthony Schmidt Website:www.AnthonyTeacher.com

  2. Activity 1 – Take this fun quiz!

  3. Congratulations You have just used Google Forms! Google Forms allows you to build forms with multiple question types. You can view answer summaries as pie charts. Answers are also recorded in a spreadsheet. This is where the magic happens!

  4. Introduction to Google Forms So, what can we do with Google Forms?

  5. Create surveys / Collect student data / Graph results http://goo.gl/HVNji @lisegaluga http://goo.gl/JmYQH

  6. Collect and manipulate data Collect information related to student interests then groups students based on interests. @mbusicoflight @lisegaluga http://goo.gl/SsDSO

  7. Book Reviews Say goodbye to the boring traditional book report - Create Amazon style book reviews for your classmates using Forms and Sites @hollyedtechdiva http://bit.ly/ZsIHYS

  8. Teach Questionnaire Design Create a sample questionnaire with: • leading / biased / ambiguous questions • questions with incorrect scales / ranges / responses Ask students to improve the questionnaire, online - collaboratively! @petejbell @lisegaluga

  9. Create Assignment Checklists Create checklists that students complete to submit assignments.

  10. Collaborate with the World Students and teachers can share surveys they make with friends, families, and strangers!

  11. Create Collaborative Wordles Collect keywords from students then create a Wordle by copy pasting from the Google Spreadsheet. @lisegaluga http://goo.gl/vgy2w

  12. Add images to forms

  13. Speed with Forms Replace clickers by using the Timestamp function of Google Forms! Dotty Clark @lisegaluga http://goo.gl/hLTXA

  14. Text Walls Students can submit questions in real-time. You can address these at the end of the lecture. Students can submit example sentences which can be analyzed in class. You can simply hide the names of the students.

  15. Self-Grading Quizzes Students can take multiple choice quizzes and have the results emailed back immediatley. Search for "Self-Grading Quiz" in the Google Template Gallery. https://drive.google.com/templates Edit questions as required.

  16. Grade quizzes with Flubaroo (Advanced)

  17. Peer Grade Class Presentations Students grade while watching. Teacher takes average and emails comments to presenter with autocrat. bit.ly/11kEPHU @JenRoberts1

  18. Exit Tickets for Formative Evaluation Conditional Formating

  19. Playing With

  20. Making a form is EASY. Create your own quiz with multiple choice answers. You can include the following question types: Multiple choice Choose from a list Scale Grid Be sure to include a text field for NAME and a text field for EMAIL! Keep this practice quiz short (5 questions)

  21. Working with the Spreadsheet The spreadsheet is where the magic happens. It is also the tricky part. We will make our quiz self-grading. Follow my steps. Try to understand the formulae.

  22. Basic Excel Formulas = =A1 =A1+A2 This starts all formulas. This copies the cell A1. A is the column. 1 is the row. A1 is the specific cell. If you write this into the B1 cell, it will copy whatever is in A1. This says to add A1 and A2 together..

  23. Formula 1 =“StudentAnswers”!A1 This formula copies a cell from another worksheet. “StudentAnswers” is the sheet name ! means it is a different sheet A1 is the specific cell

  24. Formula 2 =IF(“FormResponses"!A1=“Answers"!$A$1,1,0) To check if the student answer matches the correct answer. Returns 1 or 0. IF sets up a conditional formula “FormResponses”!A1 looks at the FormResponses Sheet, cell A1. = shows what to compare “FormResponses”!A1 to “Answers”!$A$1 is the correct answer $ means that if this formula is pasted into another cell, the letter or number after the $ will not change 1,0 is the response of the computer. 1 means the answers are the same. 0 means the answers are different.

  25. Formula 3 =SUM(A1:Z1) To find the total points earned on this quiz. SUM means sum or addition A1:Z1 is the range of cells being added, similar to A1+B1+C1…

  26. Formula 4 =H3/5*100 To find the total percentage a student earned H3 is the cell with the SUM formula / means divided by 5 means the total number of questions * means multiplacation (x) 100 is used to give a percentage

  27. Formula 5 =AVERAGE($A$1:$A$50) To find the class average AVERAGE means average of scores $A$1:$A$50 represents a single column of class percentages A1 is the first student’s percentage A50 is the last student’s percentage You can use this formula after the PERCENT column.

More Related