Presentating at CCA in Wilmington

Getting ready to go to participate in a panel discussion at the CCA conference in Wilmington, NC. entitled “What the Tech?” about using blogs in teaching communication.  I have collected resources for the talk including some really great articles on ways to use blogs in classes including some good grading ideas.  Check out my Diigo site at http://www.diigo.com/list/benignim/caa

Hey all you CofC Bloggers…

We had to make a minor upgrade to the blog server this weekend.  All looks good to me so far but if you have any problems with your blog please email the webmasters (webmaster@cofc.edu) and let them know.  Hope everyone had a great weekend.

New features added to Google Docs

I have no idea how long some of these things have been in Google Docs but I just discovered them today so I thought I’d pass them on to you.  There has actually be a bunch of features added but these are the things I think may be of the most use (at least to me :)

  • Translate document
    You can now translate an entire document into over 40 languages. Learn more
  • Drawings and diagrams
    Create your own drawings and diagrams in Google Docs and use them in your text documents, spreadsheets and presentations. As with the rest of Google Docs, your drawings are auto-saved and you can edit them collaboratively. To get started, open a document and select Insert > Drawing. Learn more
    Drawings and diagrams
  • Find and replace toolbar for text documents
    The “Find and replace” feature in the text document Edit menu has gotten a makeover and an upgrade. Now it’s a slick toolbar that sports case matching, whole word matching as well as regular expression-style matching. Learn more
    Find and replace toolbar for text documents
  • Plus the ever awesome Forms feature but that’s for a later post (mmwa ha ha)

How to make great Excel gradebooks

Seth Anderson just turned me on to this great link from Penn State.  This page gives you all the formulas you would need to make a great and effective gradebook using Excel. Some of the examples it covers are:

  • Summing Up Scores
  • Calculating a Numeric Percentage
  • Convert Numeric Percentage to Letter Grades
  • Weighting Assignments by Points
  • Weighting Assignments by Percentage
  • Dropping Lowest Score
  • Dropping the Lowest Two (or More) Scores
  • Keeping the Highest Score
  • Keeping the Highest Two (or More) Scores
  • Maintaining a Running Grade