If you have been using Gmail for some time then you must have seen Google Docs also. For a teacher spreadsheet can be used for evaluating students’ learning that too online.
You may be wondering how to go about it? Then follow these procedures.

Step 1: Open a new spreadsheet from Google Docs.

Sept 2: Rename it by clicking the default untitled spreadsheet and then click share button on the right of your screen.



Step 6: Click embed button and copy the code and then paste it on HTML widget/post in your blog or wiki. There you can resize it as per your requirement by changing height and width values.

Your form will automatically collect the information filled in the form and save them in the spreadsheet. Do not tamper with your spreadsheet because it is controlled by your form. Now you will have spreadsheet similar to this with name of each student who took the test, his/her school & answers to the questions.
If you want to show the scores then follow these instructions.
Step 7: You can see that A column shows the timestamp, B shows the Name of student and C & beyond show the answers of the students. Suppose the answers end at J column then at K write the score obtained by the students.

Step 9: See the link Insert Plugin or Gadget near Print button at the top right corner. Click it and select Column Chart draw a chart of scores.

Step 11: To embed it in your blog or wiki you must click the drop down arrow on the chart at top right corner and select Publish. Copy the code given in HTML and paste it in your blog.
By this way whenever there is any entry and you have given a score it will be shown in the Chart in your blog or wiki.

Now Enjoy your class! I have done it at my wiki. Have a look and comment.
exploringgeography
No comments:
Post a Comment