Sunday, April 11, 2010

Share an entire folder of documents

So if you want to share MANY documents with students, all at once, just load all the docs into a folder in google docs and share the entire folder.  Here is how you do this:

Friday, April 9, 2010

Online Grading

Sign up for a free account on engrade.com.  Your grades will be hosted online, so you can grade on any computer with internet.  The best part is that your students and their parents can access grades at any time.

See a sample student's grade report here using the following username and password:

username:    ProfSat
password:    sample

Google Account & Google Documents

Sign up for a Google account.  This is a no-brainer.  Google offers a variety of powerful tools, from e-mail, document creation, internet searching, and web hosting.  You will need a Google account to take advantage of many of the features I show you today.

Google documents is a great resource for creating and sharing documents online.  Google Docs is not as powerful as MS Office or OpenOffice, and the formatting can be tricky if you plan to print the documents, but it's free and hosted online.  You can also host your MS or OO files on Google Docs without changing the format.

Once you host a document online, you can make a link to the document that anyone can click on.  This is powerful because YOU DON'T HAVE TO MAKE EXTRA COPIES FOR STUDENTS WHO WERE ABSENT OR LOST THEIR WORK.  Just tell them to go to the library, find the document they need, and print it out!  Here is an example:  Blue Planet Video Notes

Here's how to sign up for a google account:



Here's how to create a new document:

Tuesday, March 30, 2010

Online Test - Automatic Grading :)

Spreadsheets are a beautiful thing.  For us computer nerds.

For everyone else, they can be scary.  I will show you why you need to stop worrying and love the spreadsheet.

Take this test, and please hit "Submit" when you finish:




Good job!  Now check this out:

Here are the test results.  Use the formula under the "score" column to grade your OWN tests.

Here is that formula again:

=if(B3="","",(100*ARRAYFORMULA(SUM(C$2:E$2=C3:E3))/3))


Here is what the different parts DO:

=if(B3="","",(100*ARRAYFORMULA(SUM(C$2:E$2=C3:E3))/3))


The SUM function adds up all of the answers that are equal to those in row 2, where I put my response to the form. The ARRAYFORMULA function tells the computer to match complicated text answers, as opposed to simple numbers. This is limiting in that it cannot grade open-ended essays or short answers. I answered the quiz before any students, and they can't see the answers, so I tell the computer that the correct answers in row 2. You need to do the same.

I divide by three (/3) because there are 3 questions, and I multiply by 100(100*) to get a percentage value.  I use the nested "if" function to tell the spreadsheet NOT to grade a row if it is blank ("").  This part is not strictly necessary, but it makes things easier for me.  The if function works like this: =if(something is true, do this, if false do this), so my if function checks to see if the answer is blank, if it is then it leaves the score blank, if it is NOT blank then it grades test and enters a score.

And, of course, a voicethread to show you how to assemble your test and grade it:

Monday, March 29, 2010

Embedded Video

You can imbed video clips into your website.

For example, a youtube video:



(BTW, youtube is blocked on HIDOE networks.  You can download a video at home at keepvid.com and show it from your hard drive during your lesson to get around this.

Another example:



Here's how I do it:


Voicethread

Do you use powerpoint presentations in your classroom? Upgrade to voicethread for free.  Visit voicethread.com to sign up.

Here is a voicethread on how to use voicethread.  You can click here to watch the presentation in full screen or watch it in the embedded window below:

Followers