Help, I am not very adept with Excel but I need to create a sheet that will take student reading fluency data and compare the score against two criterion and then place it into one of four categories.
A student is either High Fluency and High Accuracy, High Fluency and Low Accuracy, Low Fluency and High Accuracy or Low Fluency and Low Accuracy
I know sort of how I need it to compare info. The student score should be compared against the cut score for fluency target and a set accuracy percentage. I just don't know how to take the raw data from my spreadsheet and make get it to sort into a table that will show me which kids are in which group. HELP
A student is either High Fluency and High Accuracy, High Fluency and Low Accuracy, Low Fluency and High Accuracy or Low Fluency and Low Accuracy
I know sort of how I need it to compare info. The student score should be compared against the cut score for fluency target and a set accuracy percentage. I just don't know how to take the raw data from my spreadsheet and make get it to sort into a table that will show me which kids are in which group. HELP
