1 / 28

Analyzing the Online Test

Analyzing the Online Test. Testing, Testing: Using Google Docs for Assessment Roberta L. Tipton and Ma Lei Hsieh NJLA Annual Conference April 28, 2010. Google Docs Pie Charts From Roberta Tipton Rutgers-Newark. 5-Point Plagiarism Quiz Based upon the Camden Plagiarism Tutorial

tatyana-valdez
Download Presentation

Analyzing the Online Test

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Analyzing the Online Test Testing, Testing: Using Google Docs for Assessment Roberta L. Tipton and Ma Lei Hsieh NJLA Annual Conference April 28, 2010

  2. Google Docs Pie ChartsFrom Roberta TiptonRutgers-Newark 5-Point Plagiarism Quiz Based upon the Camden Plagiarism Tutorial 113 responses

  3. Using CountblankFrom Roberta TiptonRutgers-Newark =COUNTBLANK(First cell:Last cell)

  4. Using an Array Formula to Self-GradeFrom Roberta TiptonRutgers-Newark =SUM(IF((B2:B112=B2), 20%, 0))+ (IF((C2:C112=C2), 20%, 0))+ (IF((D2:D112=D2), 20%, 0))+ (IF((E2:E112=E2), 20%, 0))+ (IF((F2:F112=F2), 20%, 0))

  5. Counting the Correct Answers with COUNTIFfrom Ma Lei HsiehRider University =COUNTIF(c2:c20, “a*”)

  6. Column C has answers to question 1, Column D for question 2, etc. Each row contains the answers to all questions for each student. By Ma Lei Hsieh

  7. How many students from row 2 to row 20 chose a or b or c or d for an answer? Excel function: By Ma Lei Hsieh

  8. Making an Absolute FormulaFrom Ma Lei Hsieh Rider University =B887/$B$885

  9. What’s the percentage of students from row 2 to row 20 choosing each answer for Question 1? Click Cell B887 divided by Cell B885 (total number of students) and press Function 4 (F4) on the keyboard. F4 will add $ at the right places in the function to make B885 an absolute number. When you scroll down to repeat the function for answer b, c, and d, the divisor remains the same. Format Cell C887 into percentage figure. By Ma Lei Hsieh

  10. Thank you! Questions? Ma Lei Hsieh, mhsieh@rider.edu 609-896-5241 Roberta L. Tipton, tipton@rutgers.edu 973-353-5910

More Related