Groups | Search | Server Info | Login | Register


Groups > comp.apps.spreadsheets > #56

Excel for Longitudinal Score Analysis

Newsgroups comp.apps.spreadsheets
Date 2014-10-20 15:30 -0700
Message-ID <bda963d8-8a01-4dc0-8120-bceb3ab25481@googlegroups.com> (permalink)
Subject Excel for Longitudinal Score Analysis
From trevor.hancey@gmail.com

Show all headers | View raw


Greetings,

I am a 3rd grade writing teacher that has to assess student writing on 11 different criteria (pause for a moment to consider how much of my weekends live here).

I want to create a spreadsheet in which I can input all student scores on each criteria for each assessment period, and that will output to me a measure of whether each student is growing or not in each category.

(Example: I want to know if Julia is making progress in the structure row of the rubric as well as if she's growing in the word choice row and the sentence fluency row etc. etc.)

Any thoughts on what excel function would best help me accomplish this?

Thanks in advance

Back to comp.apps.spreadsheets | Previous | Next | Find similar


Thread

Excel for Longitudinal Score Analysis trevor.hancey@gmail.com - 2014-10-20 15:30 -0700

csiph-web