Reporting Data Collected by a Template - An Example

A template has four elements, which are described below in conjunction with the reported stats.

These stats are based on the data collected by twelve walk-throughs.

Element #1 is a drop-dow list named Use of technology.

The Use of technology drop-down list has three items:

  • High
  • Medium
  • Low

Only ten out of twelve walk-throughs made a selection using Element #1.

Two walk-throughs did not use this element. The lack of collected data by a drop-down list is referred to as no values or null values.

Element #1 Reporting [null vales excluded]

The table and pie chart are based on data collected by Element #1 in the ten walk-throughs that used this element.

The numbers of selections are included in the SEL column. High has been selected five times,

Medium has been selected three times and Low two times.

The total number of selections is shown beside Total, also in the SEL column.

The ratios of the three selection numbers to the total are expressed as percentages in the % column.

Thus, for example, 5 : 10 = 0.50, i.e. 50%.

In addition to being displayed in the table, the three percentages are also displayed as a pie chart.

The next table and pie chart are based on data collected by Element #1 in all twelve walk-throughs, including those two reported as having collected no values.

Element #1 Reporting [null values included]

A new item, No values, is added on the last line.

It shows the number of walk-throughs during which no selections were made using the drop-down list i.e. the number

of walk-throughs during which the default <n/a> selection was not replaced by a user-made selection. This number is 2.

The percentages in the % column are computed as ratios of the SEL values to the overall number of walk-throughs,

including the two walk-throughs that did not use the drop-down list to make a selection. This number is 12.

For example, 5 : 12 = 0.4166 i.e. 41.66% for the High item. This value is rounded off to the closest integer which is 42%.

The next table and bar chart is based on the checklist attached to Element #2.

Element #2 Reporting

Element #2, which is named Positive Emotional Climate, is a label.

Its name is displayed in the above image on the top line together with the number of walk-throughs.

To it, the Emotional Climate checklist (whose name is displayed on the second line from top) is attached.

It is the data collected by the attached checklist that is displayed, since labels do not collect data.

As you may remember, checklists are collections of related checkboxes.

The checklist was used here simply as a set of checkboxes, hence the Checklist as Checkbox header of this report.

The following checkboxes make up the Emotional Climate checklist:

  • All relationships are valued, respected and supported.
  • Recent student work is displayed.
  • Classroom environment is safe and non-threatening.
  • Physical structure of the room is inviting.
  • Shared enthusiasm for learning.

Every checklist element (i.e. checkbox) has been selected a number of times. The ratios of the selections’ numbers

to the number of walk-throughs, expressed as percentages, are displayed in tabular format and as a bar chart.

Thus, for example, 7 : 12 = 0.5833 or 58.33% which is rounded off to 58%.

To make the interpretation of the bar chart easier, checklist elements (i.e. checkboxes) are numbered and are assigned colors.

For easy reference, checklist elements are listed above the bar chart.

The numbering and coloring of the bars match those of the checklist elements.

The following stats of Element #3, a Manual Number Input element named Number of students off-task, are displayed:

Minimum, Maximum, Median, Average and Total.

All the stats are represented in tabular format.

All the stats except the Total are represented also by a bar chart.

NOTE: The minimum, being here zero, has no corresponding bar in the bar chart

Element #3 Reporting

The table and bar chart below display the stats for Element #4, a checkbox element named Are classroom rules posted in the room?

Element #4 Reporting

Checkboxes are simple controls that can be checked (to indicate yes) or can be left unchecked (to indicate no).

The checkbox has been checked ten out of twelve times.

Therefore, the number 10 is displayed in the table in the Selected column.

The % column displays the corresponding percentage that is calculated as follows: 10 : 12 = 0.8333 which is 83.33%.

This value is rounded off to the closest integer which is 83%.

The bar chart displays 83% on a scale of 0% to 100%.

A Note on Configuring Reports and Data Disaggregation

There are several ways of making a report more relevant to your needs and/or limit the amount of data on which the report is based:

  • If your initial selection includes more than one site, you may select next a subset of the sites that you selected initially.
  • If the template is not anonymous, consider generating a report that targets one subject, rather than all subjects.
  • You may adjust (e.g. narrow down) the reporting period to one which is meaningful.
  • If the template includes one or two filters, they can be used to retrieve disaggregated data
  • related to single entities or to pairs of single entities. For example, if the template
  • has a Grade filter and a Subject filter, you may create reports that describe
  • one single grade, or one single teaching subject, or one single grade and subject.