Instructions for the Infant–Toddler Classrooms

TPITOS Excel Scoring Spreadsheet for PC

The TPITOS Excel Scoring Spreadsheet is a tool for summarizing and graphing TPITOS data. This tool is available for PC and for Mac. There are two versions of the PC spreadsheet available: one file has the capacity to enter up to 10 teachers, while the other has the capacity to enter up to 40 teachers. Each of the TPITOS Excel Scoring Spreadsheets functions in the same way, so these instructions apply to both the 10 Teacher and the 40 Teacher file.

The TPITOS Excel Scoring Spreadsheet is organized into tabs, which are found along the bottom of the Excel workbook. The first tab includes Instructions on how to enter data into the individual Teacher tabs and explains the different areas of the spreadsheet. You cannot enter data on the Instructions tab, as it is there to provide guidance on how to enter data. In addition to the Instructions tab, the TPITOS Excel Scoring Spreadsheet contains 3 types of worksheets:

1. Teacher Tabs: Teacher data are entered in the Teacher tabs. In the 10 Teacher file, these tabs are labeled Teacher 1, Teacher 2, and so forth. In the TPITOS Excel Scoring Spreadsheet 40 Teacher file, these tabs are labeled T1, T2, and so forth. You may enter up to three observations (i.e., waves or time points) for one teacher on one tab. Enter only one teacher per Teacher tab. Refer to the TPITOS Scoring Summary Profile on pages 22–23 of the TPITOS Scoring Form and enter the summary data from these tables. Once the data are entered, you may scroll down the worksheet to see two graphical displays of the data (Observational and Interview Items and Red Flags) for each wave for one teacher.

2. Item Table Graph and Red Flag Table Graph: The Item Table Graph tab will allow you to view the graphed data for TPITOS Observational and Interview Items. This graph shows the percentage of Indicators scored Yes for each Item. The Red Flag Table Graph tab allows you to view the Red Flag graphed data. Each of these graphs allows you to view data for one teacher or multiple teachers at one, two, or three time points (waves). These tabs also provide a table of the graphed data.

Individual Teacher Tabs

Observational and Interview Items

Enter data from the TPITOS Summary Scoring Profile into the gray areas only. Other cells are locked so that data cannot be entered elsewhere.

1. Enter the Teacher and Classroom name/ID (ex: Jane-Class 1) and Program name/ID.
2. Enter the Date of the TPITOS observation. You may enter up to 3 observations per teacher. Waves 1, 2, and 3 might represent three observations over the course of one year.
3. Enter the number of Yes and No scores for each Item.

You can enter up to 10 teachers in the TPITOS Excel Scoring Spreadsheet, and up to 40 Teachers in the TPITOS Excel Scoring Spreadsheet: 40 Teacher Capacity file. If you have multiple classrooms or programs, we suggest creating new files as a way of organizing observational data.

When using the 40 Teacher file, access the higher Teacher tabs (e.g., T20, T21) by clicking the right arrow button in the bottom bar (in the left corner of your screen) to scroll to the later tabs.

Red Flags

Enter Red Flag data from the Red Flag Scoring Summary Profile. Enter the number of Yes responses for Red Flags and total number of possible Red Flags for the teacher and the classroom.

Notes: To view the individual teacher graphs, scroll down the worksheet below the section where data is entered.

To refresh the data, click "Refresh All" under the Data menu any time you add or edit data to ensure that the data you just entered will show up on the graphs.

Observational and Interview Item and Red Flag Tables and Graphs

Item Table Graph and Red Flag Table Graph

Make sure you have entered all of your observational/interview scores and have clicked Refresh All under the Data menu.

Two tables are provided that allow you to filter which TPITOS observations are represented in the graphs. These two tables (Select Teacher ID and Select Date) allow you to select one or multiple teachers and one or multiple waves to be shown in the graphs.

To see the individual Item and total averages of multiple teachers and/or multiple waves, hold down CTRL and left-click to select multiple teachers/waves. Selected teachers or waves will be indicated by blue highlighting. To deselect multiple teachers/waves, simply click on one of the highlighted teachers and/or waves again.

System Requirements: Excel 2010 or newer on Windows OS.