Print

Print


Thanks everyone!  I ended up going with a Google form per student, and then
mentors just have to fill out the form once per student.  That dumps into a
spreadsheet that we can use to grab the data and reformat into a friendly
format.

Happy Monday!

On Mon, Mar 2, 2020 at 10:31 AM Elizabeth McCarthy <
[log in to unmask]> wrote:

> Another option is to use Google Data Studio , it's free.
> https://datastudio.google.com/overview
>
>
> *Elizabeth McCarthy, MAT*
> *Digital Learning Specialist - retiredGoogle for Education Certified
> Trainer*
> Google+google.com/+ElizabethMcCarthy
> <https://www.google.com/+ElizabethMcCarthy>
>
>
>
>
> On Mon, Mar 2, 2020 at 10:21 AM Elizabeth McCarthy <
> [log in to unmask]> wrote:
>
>> try using an  add-on like rowCall or EZQuery to create individual tabs
>> for each student from the master form/sheet.
>> https://gsuite.google.com/marketplace/app/ez_query/388117003720
>> https://gsuite.google.com/marketplace/app/rowcall/626140973806
>>
>>
>> *Elizabeth McCarthy, MAT*
>> *Digital Learning Specialist - retiredGoogle for Education Certified
>> Trainer*
>> Google+google.com/+ElizabethMcCarthy
>> <https://www.google.com/+ElizabethMcCarthy>
>>
>>
>>
>>
>> On Mon, Mar 2, 2020 at 10:03 AM Karen McCalla <
>> [log in to unmask]> wrote:
>>
>>> My goal was to not have to rate each student or proficiency in a
>>> separate form (so instead of checkboxes the Google form would have to
>>> accept 1-4 ratings for each student/proficiency), but that turns it from
>>> something that can be reported out in a spreadsheet into something that has
>>> to be reported out in a database, I think.  I may just end up going with
>>> the Google Form, and ask the mentors to just fill it out separately for
>>> each student.
>>>
>>> Thanks!
>>>
>>> On Mon, Mar 2, 2020 at 9:52 AM Tim O'Leary <[log in to unmask]> wrote:
>>>
>>>> If you use the "checkbox grid" in a form, you might be able to
>>>> accomplish this. I created a simple one in just 20 seconds that looks like
>>>> this:
>>>>
>>>> [image: image.png]
>>>>
>>>> So, you might create one checkbox grid with all students in the ROWS
>>>> and the proficiency ratings in the COLUMNS. Then, just copy that one and
>>>> edit the proficiency for the next one, and so on...
>>>>
>>>> Will that work?
>>>>
>>>> On Mon, Mar 2, 2020 at 9:40 AM Karen McCalla <
>>>> [log in to unmask]> wrote:
>>>>
>>>>> Hi all,
>>>>>
>>>>> Looking for some suggestions for an online tool I can use to gather
>>>>> and organize feedback for my high school level robotics team.
>>>>>
>>>>> Here's the scenario:  I mentor a team, along with a group of about 10
>>>>> other mentors (some of these are super involved and some not, but we want
>>>>> to give everyone the chance to weigh in).  We have 28 students in the
>>>>> program.  We just returned from a competition this weekend and want to
>>>>> provide feedback to students about their performance in their team roles.
>>>>> We have 7 proficiencies, and want to have each mentor provide ratings for
>>>>> each student using a 1-4 scale, along with some brief narrative comments.
>>>>> I thought that I could achieve this with a Google Form, but I would like to
>>>>> provide the mentors with a single form, instead of having them complete the
>>>>> form 28 times, 1 for each student.  Do you know of a tool that would allow
>>>>> me to send mentors to enter feedback, and then we could use to analyze that
>>>>> feedback per student?  Essentially, it's like creating a tiny Student
>>>>> Information System with 10 teachers and 28 students, but I want to keep it
>>>>> super simple.
>>>>>
>>>>> Thoughts?  I almost guarantee there is a super simple way to do this,
>>>>> but my brain is not working very well this morning (competitions don't
>>>>> allow a lot of sleep!), so I'm counting on you to be my surrogate brain!
>>>>>
>>>>> Thanks!
>>>>>
>>>>> -----------------------------------------------------------------------
>>>>>
>>>>> Search <http://list.uvm.edu/archives/school-it.html> the SCHOOL-IT
>>>>> Archive
>>>>>
>>>>> Manage <http://list.uvm.edu/cgi-bin/wa?SUBED1=SCHOOL-IT&A=1> your
>>>>> Subscription to SCHOOL-IT
>>>>>
>>>>
>>>>
>>>> --
>>>> *Tim O'Leary  *(he/him)
>>>> Digital Learning Leader
>>>> Shelburne Community School
>>>> Champlain Valley School District (VT)
>>>>
>>>> (802) 985-3331 Ext. 184 (office)
>>>> CVSD Digital Learning Website
>>>> <https://sites.google.com/cvsdvt.org/digital-learning>
>>>>
>>>>
>>>>
>>>> -----------------------------------------------------------------------
>>>>
>>>> Search <http://list.uvm.edu/archives/school-it.html> the SCHOOL-IT
>>>> Archive
>>>>
>>>> Manage <http://list.uvm.edu/cgi-bin/wa?SUBED1=SCHOOL-IT&A=1> your
>>>> Subscription to SCHOOL-IT
>>>>
>>> -----------------------------------------------------------------------
>>>
>>> Search <http://list.uvm.edu/archives/school-it.html> the SCHOOL-IT
>>> Archive
>>>
>>> Manage <http://list.uvm.edu/cgi-bin/wa?SUBED1=SCHOOL-IT&A=1> your
>>> Subscription to SCHOOL-IT
>>>
>> -----------------------------------------------------------------------
>
> Search <http://list.uvm.edu/archives/school-it.html> the SCHOOL-IT Archive
>
> Manage <http://list.uvm.edu/cgi-bin/wa?SUBED1=SCHOOL-IT&A=1> your
> Subscription to SCHOOL-IT
>