1. Go to the Administration workspace>Standardised testing management>Instruments statistics entry. 
2. Select the Instrument, instrument Item, Series and Jurisdiction, then enter the required statistics.
3. Enter the following statistical information in whole numbers.  The steps for obtaining these values can be found below.
   • Min: The lowest score achieved by any student in the result set.
   • Q1: Quartile 1. The median score of the bottom half of the result set.
   • Median: The median of the entire result set (also called Q2).
   • Q3: Quartile 3. The median score of the top half of the result set.
   • Max: The highest score achieved by any student in the set.
4. Click SAVE.
   
   

How to calculate the required statistics

NOTE: The statistics for National, Organisation or State will need to be obtained from the relevant body. School statistics can be formulated using a spreadsheet of your data. 

The following formulae can be copy-pasted into Excel, where X1:Xn is the range of the cells in which the results are stored. Similar formulae are available for other spreadsheet programs.

• Min: =MIN(X1:Xn)
• Q1: =QUARTILE(X1:Xn,1)
• Median: =MEDIAN(X1:Xn)
• Q3: =QUARTILE(X1:Xn,3)
• Max: =MAX(X1:Xn)

Your spreadsheet data may need to be sorted and filtered to allow you to easily calculate the statistics. A simple example spreadsheet is available here, which contains a subset of some NAPLAN data.

Add in the formulas

1. Choose a convenient place to enter the above formulas, depending on how your data is set out.
   1. Ensure you select the correct cell range. Save the spreadsheet if you want to keep it for reference.
2. Format the values to whole numbers:
   1. Select the cells with the formula
   2. Right-click on the selected area
   3. Select Format cells.
   4. Select Number and set Decimal places to 0 and click OK
3. Copy and paste the numbers into SEQTA Teach

What are the Min, Q1, Median, Q3 and Max values?

The median is the middle point of a number set, in which half the numbers are above the median and half are below. If there are an even number of numbers in a set, to establish the median add the two middle numbers and divide by 2.

Quartile 1 is the point where 25% of all recorded values are are below that point. It is the median of the lower 50% of the values.

Quartile 3 is similar but 75% of the recorded values are below the Q3 point. It is the median of the upper 50% of the values.

Related articles:

• Standardised testing: Support information and FAQs