Records & Reports

 

There are 8 reports provided for analysis of data from the logged-in Test Area:

Group Tracking Records

This report lists either tests and all the students who took them or students and all the tests they took. It produces tables that can be easily exported to other programs such as an Excel spreadsheet.

  • If you want to specify the student, click the Selected Students option.
  • List by STUDENT:
    • Display test titles: If you select this option, each test name, date taken, number correct, test score, and whether the student passed it or not, will be displayed below the student's name.
      • Include employee answers below each test: If you check this box, then the report will show the answer each student gave to each question in the test and indicate whether it was correct or incorrect.
      • If a test was taken more than once, display only the highest score: If you uncheck this box, then everytime the student took the test will be displayed.
    • Show ONLY the Combined Average: If you select this option, then individual tests taken will not be displayed.
      • If this option is selected, then all tests taken, not just the highest, are included in the combined average and employee answers cannot be displayed.
    • Assign a 0 in the Combined Overall Average to tests not taken:  If students were required to take certain tests and did not take some of them, check this box. They will be given a 0 on all tests not taken.
      • Note, if this option is selected, then only the highest test scores are displayed.
  • List by TEST:
    • List ALL employees who took the test and show their highest scores: If you select this option, everyone who took the test, whether they passed or failed it, is listed.
    • List only employees who PASSED the test and show their highest scores: If you select this option, only those students who passed the test are listed with their highest score.
    • List only employees who FAILED the test and show their highest scores: If you select this option, then only students who failed the test are listed along with their highest failing score. All lower failing scores are not listed. 
      • Include employees who never took this test, but who took other selected tests: If you check this box, then students who never took the test, but did take other tests in this Test Area, are listed and given a score of 0. 
    • Include ALL names or Only the Combined Average:
      • If you select Include ALL names, then the name of every student, password, date the test was taken, the time spent taking the test, the number correct, the score, and whether the student passed the test or not, are all listed.
      • If you select Only the Combined Average, then the name of the test, the number of students who took it, the percent that passed the test, and the average score are listed. The names of the students who took the test and their individual scores are not listed.
    • Calculate totals on questions answered & ignore questions unanswered: If you check this box, then in addition to the number correct and the score (which is the number correct divided by the number of questions in the test), two new fields appear: Answered (which shows the number of questions actually answered), and Percent (which shows the % correct based on those answered and not the total number of questions in the test). The Combined Average Scores are based on the questions answered rather than all the questions in the test.
      • If you do not check this box, then the Combined Average Scores are based on ALL questions in the test, including those not answered which are marked wrong.
    • Include employee answers below each test: If you check this box, then the report will show the answer each student gave to each question in the test and indicate whether it was correct or incorrect.
  • The Date Range, if filled in, restricts the analysis to tests taken during those dates. If you enter just a start date, then it is everything after that date.

  • Optional Fields refer to the drop down menus that can be setup to appear at the top of tests that list Teachers, Courses, etc. If there are any optional fields setup in the database, they will automatically appear.

    • To track students for a specific teacher, select that teacher from the Optional fields.

    • To track students for a specific period of a specific teacher, select both of these criteria in the Optional Fields.

Exporting Reports:

  • If you want to export your student data to use in other software, such as a grading program, spreadsheet, etc., here are 9 simple steps to follow:

    1. Select Group Tracking and then click the List by TEST option.

    2. Click the Selected Students button at the top if you want to pick the students.

    3. Click the Selected Tests button at the top if you want to select the tests.

    4. Do NOT click the Show Student Answers box under List by Test.

    5. Click Submit at the bottom. The Report is generated.

    6. Scroll down to the test you want and select everything from the Test Title to the Combined Average Score.

    7. Go to Edit > Copy and copy it.

    8. Now open Microsoft Excel or another spreadsheet program.

    9. Go to Edit > Paste Special, select HTML and paste it into the spreadsheet. If the only option presented is bitmap, repeat until you see the HTML option.

  • To import the test records into another program:

    1. Go to the Help menu in your grading program and print out the instructions on the format you need to import from another program.

    2. Modify the RoboTutor data you imported into the spreadsheet to match the grading program. You may need to add and delete rows or columns.

    3. Use File > Save As to export it in the format your grading program requires.

Individual Tracking Records

This report provides detailed information about tests a specific student has taken in this Test Area.

  • You need to first select the student.
  • If there are a limited number of students in the database, a drop down menu will appear with their names in it. Select the student you want.
  • If there are many students in the database, a form will appear where you can enter the student's last name.
    •  Enter the first few letters of the students last name followed by the % sign. Click Submit.
  • The individual Tracking page will appear where you can select the tests to view the student's record.

The next page lets you select a student, a test, and then view the record.

  • First, select the student from the drop-down menu.
  • Second, select what you want the report to include.
    • check if you want include the answers the student chose when taking the test.
    • check if you want the highest score only when a student took a test more than once.
    • check if you want to show any comments the student may have added to the end of the test.
  • Third, check the tests you want to include in the report. Then click Submit.

Question Analysis Report

This report lets you analyze how students responded to the questions in any specific test:

  • Students/Employees: You have the option to select all or specific test takers

  • .
  • The Date Range, if filled in, restricts the analysis to tests taken during those dates. If you enter just a start date, then it is everything after that date.

  • Display Report uses tables or bar graphs every question and how many times each option was selected.

    • For multiple choice question types 1, 2, 3, 4 and 10, the number of times each option was chosen is presented.

      • Correct answers for question types 1, 2, 3, 4 (multiple choice) and 10 (sliding continuum) are marked in green.

      • For Fill-in-the-blank and Essay questions, it displays the number of times each of the correct answers (key words) was selected.

      • For question types 7 to 9, it only shows the number of times each answer was chosen.

    • The number before the dash is the number of times that option was chosen by the students selected. The percentage following the dash is the percentage of total for that question which that number represents. For example, if you get this: 3-45%, it mean that the option was selected 3 times by the students selected and that 3 represents 45% of all answers selected for that question.

    • If "Display everything written in fill-0in-the-blank and essay questions" is selected, then

      • The report displays in tables every question and how many times each option was selected.

        • For multiple choice question types 1, 2, 3, 4 and 10, the number of times each option was chosen is presented. Since it is possible to have a "Correct" response, that is shown in green and can be used or ignored if not relevant.

        • For Fill-in-the-blank and Essay questions, it displays whatever participants write in the fields.

        • For grouped question types 7 to 9, it shows the number of times each option was chosen.

  • Click Enter and a page appears where you can select the specific test from this database that you want analyzed.

  • Optional Fields refer to the drop down menus that can be setup to appear at the top of tests that list Teachers, Courses, etc. If there are any optional fields setup in the database, they will automatically appear.

    • To track test takers for a specific teacher, select that teacher from the Optional fields.

    • To track test takers for a specific period of a specific teacher, select both of these criteria in the Optional Fields.

  • Printing: To print the colors which show the correct answers, you must turn on the Print Background features in your browser.

    • In IE this is done by selecting Tools > Internet Options. Click the Advanced Tab and scroll down to Printing. Then check the box that says "Print Background Colors and Images."

    • You can also select the entire page, copy it, and then paste it into Word and then print it there. This resolves the issue of background colors.

Note: For analytical purposes, answers greater than 255 characters are truncated.

Test Analysis Report

This report produces a statistical summary for a specific test:

  • You have the option to select all or specific students

  • .
  • The Date Range, if filled in, restricts the analysis to tests taken during those dates. If you enter just a start date, then it is everything after that date.

  • Optional Fields refer to the drop down menus that can be setup to appear at the top of tests that list Teachers, Courses, etc. If there are any optional fields setup in the database, they will automatically appear.

    • To track students for a specific teacher, select that teacher from the Optional fields.

    • To track students for a specific period of a specific teacher, select both of these criteria in the Optional Fields.

  • The results can be sorted by date, alphabetical order, or score.

  • Click Enter and a page appears where you can select the specific test from this database that you want analyzed.

  • A report is produced that lists each student, date of test, time spent taking the test, the number right and wrong, and score.

  • Statistical information is produced at the bottom of the report that gives the class mean, median, mode, and standard deviation.

Group Profile Analysis

This report makes it possible to compare groups of students on any or all tests. It produces a summary of student tests based on Sorting Codes identifying gender, races, age, or any other defined variables.

  • Choose All, Selected, or Transcript Tests.

    • If All is chosen, then every test in this Test Area that students have taken and PASSED will be used in the report.

      • It is says "A test could not be found with the selected parameters!", this may result from the fact there are no students with a passing score.

    • If Selected is chosen, then only those tests will be listed which students in this Test Area have actually taken and received a final score.

    • A Transcript test is any test marked as such in Advanced Features in Test Administration.

  • Check Box: Check to include every time a student took a test.  Uncheck to include only a student's highest score.

  • The Date Range, if filled in, restricts the analysis to tests taken during those dates. If you enter just a start date, then it is everything after that date.

  • Sorting Codes are used to select the students.
    • Use of Sorting Codes is optional and if left blank, then all students who took the specified tests are selected.
    • Sorting Codes can be names that can be assigned groups of students such as male, white, and Age 56
    • Sorting Codes can be numbers like 1034 which is assigned a meaning such as Mr. Smith's 4th Period Algebra class.
    • Sorting Codes can be entered on the Student List page or when editing individual student records.
      • A student can have any number of Sorting Codes.
      • To use 2 or more Sorting Codes for selecting students, use + or |
        • For example: "white + female" means: find all students that are both "white" AND "female"
        • For example: "white | female" means: find all students that are both "white" OR "female"
      • A single Sorting Code can consist of more than one word.
        • For example: "brown hair" can be one and "black hair" can be another.
        • To select both, enter it like this: "brown hair + black hair"
  • The Report Heading is the title that appears at the top of the report.
    • For example, if sorting for white males, then the report title might be White Males.

Student Comments

This report produces a list  of Comments given by selected students on selected tests:

  • You have the option to select specific students and tests.

  • The Date Range, if filled in, restricts the analysis to tests taken during those dates. If you enter just a start date, then it is everything after that date.

  • Optional Fields refer to the drop down menus that can be setup to appear at the top of tests that list Teachers, Courses, etc. If there are any optional fields setup in the database, they will automatically appear.

    • To track students for a specific teacher, select that teacher from the Optional fields.

    • To track students for a specific period of a specific teacher, select both of these criteria in the Optional Fields.

  • Click Submit and the report is displayed.

    • It lists each test selected.

    • Under each test are the names of students with their comments.

Academic Games Report

This report displays games played by teams and individual students:

  • You have the option to select Team Comparison Records or Individual Records.

    • Team Comparison Records show the date, team members and overall score for each of the top games listed.

      • You have the option to select which game is listed, the number of teams listed, and the number of previous days to search and include.

    • Individual Records lets you select specific student and then display the games they have played.

      • You have the option to select the dates of games taken to display

      • You have the option to show all games played or only the highest score for each game played

      • Under each student name you have the name of the game, the date, the number of questions answered, the number answered correctly, and the individual student score for this game.

Print Tests & Answer

See Test Admin > Print Test & Answers.

Display Test Setup

See Test Admin > Display Test Setup.