Your form is complete and now you just need to add the line graph itself to the linked spreadsheet. You will see in your spreadsheet that the header (top) row is filled in with the different events from left to right. Under each column heading add the average =AVERAGE(Range) formula for the cells below, say down to 100 cells below. This will average out the different responses from your form and return a single figure. Don’t worry the survey results should always be added below your average row. I like to add the “Rounded” formatting to these cells as well. Select these average figures and click the “Chart” tool and create a line graph from this data. (These average cells could also be hidden, select the row from the left and click hide row) Find some more detailed steps to making a chart here.
1More
Youtube Guitar Lessons - The Top 10 Channels On The Tube - 0 views
1More
Counting By Twos Song - YouTube - 0 views
1More
Cool Online Instruments and Games for the Music Classroom « musictechtips - 0 views
1More
Cool Math & Physics Blogs | Degrees of Freedom, Scientific American Blog Network - 0 views
1More
25 Incredible TED Talks for Educators - Learn-gasm - 0 views
4More
Ten Sites Supporting iPads In Education… A Post Of Resources! | 21 st Century... - 0 views
1 - 18 of 18
Showing 20▼ items per page