Test Data Spreadsheet for Teachers #SpreadsheetsForTeachers #UsefulTeacherTools
Test Data Spreadsheet for Teachers by custom spreadsheet designer and dual certified teacher Rick Kirkham #SpreadsheetsForTeachers #UsefulTeacherTools
As most of you know I write and customize software and spreadsheets for individuals and businesses. I've been doing looonnnnnggggggg term substitute teaching here in Honolulu Hawaii for 7th grade math. We have to do a pretest and crunch a bunch of numbers. So I utilized my God given skills with spreadsheets and wrote a Google Sheet to crunch ALL the possible data we may need from a test.
What The Spreadsheet Does for Teachers
The Test Data Spreadsheet for Teachers will
Show whether each test score is 90%, 80%,70%,60% and below 60%
Total the number of students who took the test
Total the number of scores in each percentile
Give the percentage of students in each percentile
What Does The Teacher Do to The Test Data Spreadsheet for Teachers?
Type in the possible score in just one cell C3
Put the scores in of each test in column D starting with D3
That's all YOU have to do. The spreadsheet will do the rest
What Software Do I Need for The Test Data Spreadsheet for Teachers?
I started out with a Google Sheet. All you need to use a Google spreadsheet is a free Gmail account which is also a Google account. I then saved the spreadsheets as Excel and OpenOffice. The CD can be ordered here for only 8.95 or can be downloaded for free here. OpenOffice will also work with LibreOffice in case you're using Ubuntu which is a free fast virus free operating system more stable than Windows.
How Do I Download The Test Data Spreadsheet for Teachers?