The 25 students in your class have used a Google Form to give peer feedback on presentations that they are doing. The questions are based on a rubric that you created. The first question asks, ‘Who is presenting?” and there is a dropdown list of all students in the class. The other questions are based on the rubric. After the class you want to see all the feedback that was given for Jimmy Wong. The responses for “Who is presenting?” are listed in column C on the Form Responses sheet. Columns D, E, and F have the peer feedback. Select the formula that could be used to show only the peer feedback from columns D, E, and F for Jimmy Wong.

The 25 students in your class have used a Google Form to give peer feedback on presentations that they are doing. The questions are based on a rubric that you created. The first question asks, ‘Who is presenting?” and there is a dropdown list of all students in the class. The other questions are based on the rubric. After the class you want to see all the feedback that was given for Jimmy Wong. The responses for “Who is presenting?” are listed in column C on the Form Responses sheet. Columns D, E, and F have the peer feedback. Select the formula that could be used to show only the peer feedback from columns D, E, and F for Jimmy Wong.

1. “=filter(D:F,C:C=”Jimmy Wong”)”
2. “=SUM(D:E,D:F)”
3. “=sum(D:F,C:C=Jimmy Wong”)”
4. “=FILTER(D:E,D:F)”

Browse More Categories:

Google

Google Advance Training,

Google Certification Level 1

Google Certification Level 2