This easy to use, editable Excel spreadsheet provides a basic, quick visual on an individual's or a whole classes knowledge of letters and/or sounds. It does not populate data for you.
After testing each student on their alphabet letters and sounds, simply enter their name and apply the fill colour or pattern to each cell.
Two spreadsheets are provided to separately compile data on Upper Case Letters and Sounds and Lowercase Letters and Sounds. This spreadsheet provides valuable information on which letters of the alphabet prove difficult or are mastered by your students (i.e., 19 students know the letter and sound of "O". 17 students do not know the letter "e"). It is also a valuable assessment sheet to provide to your administration on the progress of your students.
Students can be separated by gender or by grade (Junior Kindergarten and Senior Kindergarten) or not at all.