This spreadsheet is a CFA sheet organized by days. What that means is that this spreadsheet assumes that you will give your CFA in smaller chunks over a series of three days. That is, a 9-question quiz turns into small, 3-three question quizzes that you could give over a 3-day period. This is beneficial as it has embedded intervention where students get to see daily, after the CFA, what they did incorrectly and let that inform them on what they need to study for the next day. Also, 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. This 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:
• 6 Teachers in the PLC
• Every Quarter has 2 CFAs
• Every CFA is given over three days
• Each CFA day (day1,2,3) is a 3-question assessment.
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. It is $1 in the store.
Click here for the $1 Information Packet for the spreadsheet
Click here for the $5 spreadsheet organized by concepts