The following information is for a general spreadsheet for CFA data. This spreadsheet is organized by concepts. What that means is that this spreadsheet assumes that you will give your CFA on one day and you want to get percentages of student achievement based upon concepts. It gives the teacher the opportunity to reteach in a very targeted way.
The spreadsheet is partially set up for you currently. Since no teacher is the same, there are many changes that you will want to make as you use the spreadsheet over the year to match your preferences. Also, as you develop your CFAs, there are changes that will need to be made so that the sheet is set up to accept your data. There is a packet goes through the Excel basics and spreadsheet-specific formulas that will help you to be able to set it all up.
The sheet is currently set up for:
• 5 Teachers in the PLC
• Every Quarter has 2 CFAs
• Every CFA is given one day
• Each CFA has four assessed concepts
• Each concept has three questions on the test.
o Below (B): 0 Questions Correct
o Approaching (A): 1 or 2 Questions Correct
o Proficient (P): All 3 Questions Correct
There is a pdf file that goes with this spreadsheet. Make sure that you get it along with this spreadsheet as it will give you a lot of information on how to adapt it for use on your team.
Click here for the $1 Information Packet for the spreadsheet
Click here for the $5 spreadsheet organized by days