Main »

Excel Statistics For Grading

Excel functions can be quite useful for analyzing statistical properties of exams and student grades for a semester.

1. First, some background on standardizing scores for analysis across a course. Calculating Z and T scores is a good place to start. See Grading students by Cross, Lawrence H. (1995) in Practical Assessment, Research & Evaluation for explanation.
   • Data Entry tips for efficiency and control
   • Histograms with Pivot Tables Excel Tips And Tricks and using CountIF
   • I've created a spreadsheet with a column chart displaying a histogram of student scores and a superimposed normal distribution line chart. (note: add example xls file) This example has a very skewed distribution! But the combination of histogram and distribution line charts are effective for visualizing the scores.
2. An Introduction to Excel's Normal Distribution Functions
3. How to Create Normal Curves In Excel, With Shaded Areas

No matter how big and tough a problem may be, get rid of confusion by taking one little step toward solution. Do something. George F. Nordenholt << | Trail Index | >> HomeLinks

  Notes
  Investments
  Research
  Teaching 
  ReadingList
  ClassicQuotes
  Computer Applications

 PmWikiUserInfo
 Skin Admin  
 Basic Editing
 Documentation Index
 pmwiki.org

Shelfari: Book reviews on your book blog