Download the Datalogger

Version 5.1.1: August 26th 2008

  1. Fixed cell reference error on the Data Charts page that failed to bring across a task label into the Charts section.

Version 5.1: August 2nd 2008

  1. Fixed bug in properly displaying scoring criteria on the DataCharts, Charts and Participant worksheets. Previously the optional 6th and 7th scoring categories did not display correctly on these sheets.
  2. Fixed the default formatting of chart labels.
  3. Changed task display behavior to allow blank rows on Tasks worksheet to be correctly displayed on individual worksheets.

Version 5.0: April 2nd 2008

  1. Bug fix: Fixed satisfaction chart error so that SUS scores accurately reflect the raw data entered into each participant sheet.
  2. Tasks and questions now combined into a single section of 50 items on the Tasks worksheet.
  3. Automatically shows/hides Participant worksheets based on # of participants listed on Admin worksheet.
  4. Automatically shows/hides tasks on each Participant worksheet according to the number of items listed on the Tasks worksheet.
  5. Automatically shows/hides satisfaction questions on each Participant worksheet according to one of three options (None, TAM, SUS) selected in the Scoring section of the Admin worksheet .
  6. Ability to select/deselect participants for inclusion in data tables and charts. Charts automatically redraw according to participant selection.
  7. Ability to select/deselect tasks for inclusion in data tables and charts. Charts automatically redraw according to task selection.
  8. Ability to select/deselect tasks for inclusion on printed TaskCards.
  9. Ability to select a single consecutive block of tasks for randomization within the 50 item section.
  10. Ability to record participants’ self-reported confidence rating for each task.
  11. Redesign of Admin, Tasks, and Charts worksheets for greater ease of use and improved comprehension.
  12. Reduction of previous printforms worksheets to a single printforms worksheet
  13. Increase in number of scoring criteria permitted (from 5 to 7).
  14. Opportunity to make a donation to say thanks for any time and energy saved during your research

Version 4.2

  1. Task numbers on Pilot2 worksheet correctly map to Pilot2 tasks.
  2. AutoFit macro properly formats rows when the workbook is protected.
  3. Fixed Confidence Interval bug where the outer error bar previously extended beyond 0% or 100% when the confidence interval exceeded the distance between the mean and the respective upper or lower limit. Now the outer error bar extends only as far as 0% or 100% regardless of how large the confidence interval is.
  4. Vertical formatting of all rows of Participant (P) data sheets set to display task numbers, and data now aligns at the top of each cell rather than the bottom.
  5. All cells on all data collection sheets set to word wrap properly.

Version 4.1

  1. Removed manual AutoFit buttons on Data pages. The logger now automatically autofits text in cells everytime you open these sheets.
  2. Increased all text that formerly appeared too small on the Mac.

Version 4: January 13th 2007

Enhancements in Version 4

  1. Satisfaction Data Collection. Added Satisfaction Questionnaire selection feature to "Admin" worksheet. You can now select your choice of either SUS or TAM questionnaires and have their respective questions automatically included in each participant worksheet for data collection.
  2. Profiles Worksheet. Added "Profiles" worksheet to permit capture and printing of additional demographic details. Includes tally and presentation of sample size.
  3. Additional Question Fields. Modified "Tasks&Qs" worksheet by merging previous pre and post questions into a single set of 30 questions available on each participant worksheet and summarized into a single data collection sheet (DataQs)
  4. Improved timer. Reduced multiple timer buttons to a single START button. When task is officially deemed complete, the task time is now available in a pulldown menu in the Time column for the task just completed.
  5. Improved Participant Data Collection. Revised "Participant" (P) worksheets:
    • removed project reference cell and replaced it with role/occupation
    • to include data entry of responses to 30 questions from Tasks&Qs sheet (automatically consolidated on the Data(Qs) sheet
    • to include satisfaction questions for either SUS or TAM based on selection from Admin sheet
  6. Improved Data Analysis. Introduced page breaks for each task and question on the Data(Observ) and Data(Qs) worksheets to help facilitate data analysis of printed pages. Introduced new charts to accommodate presentation of satisfaction data on Data(Charts) worksheet. Renamed data collection sheets from "Observations", "PreQ", "PostQ" and "Charts" to:
    • Data(Observ) - formerly Observations
    • Data(Qs) - combines what was formerly PreQ and PostQ
    • Data(Charts) - formerly Charts
  7. Reset Function. Introduced a "Reset" worksheet and transferred the "Clear Performance Data" and "Clear ALL Test Data" from their previous location on the DataSum worksheet. These features allow you to easily and quickly reuse a prior test configuration.
  8. Print Worksheets. Introduced two new (*) "Print" worksheets for a total of three:
    • PrintTasks - prints a task list and individual task cards for researcher/participant use
    • PrintQs - prints a compiled question list for researcher use
    • PrintSAT - prints the selected satisfaction questionnaire for participant use
  9. Print Area Formatting. Introduced "Print Area" formatting to all worksheets designed for printing. The following pages are now formatted specifically for effective printing:
    • Profiles
    • Data(Observ)
    • Data(Qs)
    • PrintTasks
    • PrintQs
    • PrintSAT
    • Improved Participant Referencing
    • Color-coded Worksheet Tabs. Worksheet tabs are now color-coded to make it easier to recognize and select the desired sheet.
    • Other changes. Summaries of qualitative data on Data(Obs) and Data(Qs) worksheets now only displays rows that have data in them, thereby allowing you to avoid printing empty rows that do not contain data. Revised layout of Data(Charts) worksheet to show collection of charts in horizontal fashion within worksheet rather than vertical orientation. Introduced new charts to help present satisfaction data on Data(Charts) worksheet.

Fixes in Version 4

  1. Task numbers on Pilot2 worksheet correctly map to Pilot2 tasks.
  2. AutoFit macro properly formats rows when the workbook is protected.
  3. Fixed Confidence Interval bug where the outer error bar previously extended beyond 0% or 100% when the confidence interval exceeded the distance between the mean and the respective upper or lower limit. Now the outer error bar extends only as far as 0% or 100% regardless of how large the confidence interval is.
  4. Vertical formatting of all rows of "Participant" (P) data sheets set to display task numbers and data align at the top of each cell rather than the bottom.
  5. All cells on all data collection sheets set to word wrap properly.

Version 3.1

  1. Resolved a missing set of cell references for P5 worksheet

Version 3.0

  1. Global Protect/Unprotect. This feature allows you to protect and unprotect all worksheets in the file with a single click. This makes it easy to customize your datalogger, making changes to any worksheet in the entire file, and then "locking them all down" again prior to your study so as to protect your formulas while entering your data.
  2. Automatic Task Ordering. What was once a manual activity is now automatic! This new feature on the Admin worksheet allows you to select whether you want to have your tasks presented in a consecutive (linear) pattern or a randomized pattern. You may still customize your task order manually if you wish to accommodate tasks that are dependent on one another.
  3. New and Improved Charting of Results. New task completion charts now provide options to view your task performance results in more ways, including by task performance categories that you have selected (e.g. easy, medium, hard, assisted, fail) or (pass, fail) or some other combination that you choose. by simple proportion of successful task completion to total tasks performed by adjusted proportion of successful task completion to total tasks performed and supported by 95% confidence intervals
  4. One-Word Task Labels Now Included in Summary Charts. Abbreviated one-word labels are now incorporated into the various summary charts for task performances, automatically pulled from the Tasks worksheet. These labels make it easier to interpret each chart, and prevent the need for cross-referencing a separate list of tasks.
  5. Sample Size Increased from 12 to 20 Participants. To better support summative usability studies that typically enlist a larger sample size, the datalogger now supports a total of 20 participants.
  6. Data Collection Sheets Added for Pilot Sessions. Two data collection sheets have been inserted to record the initial pilot sessions at the start of a study. The qualitative data (observations) from these sessions are included in the summary sheets for all participants. The objective data (task completion, time on task) are not included in the summary charts.
  7. Task Printout Option. Enter and edit your tasks in one place prior to the start of your study and then print out your task package from this predefined layout sheet, including a compiled table version for your test observers and reporting needs, as well as a task package for your participants. Global Data and Detail Resets Tucked away on the final DataSum worksheet, this feature allows you to reset your datalogger in two different ways: Clear all performance data from the pilot and participant sheets so that you may repeat a test using the tasks same tasks as in the original test Clear all test details (including performance data, as well as participant and task data). This allows you to keep any customizations you may have made to your datalogger during the course of the study, and effectively provides you with a new customized template for future studies.

Version 2.0

  1. Improved ‘task ordering’ method makes it easier to order your tasks for each participant and collect data in a top-to-bottom order on each Participant page.
  2. Improved pull-down menus for data on the Admin and Participant pages.
  3. Increased space for entering observations on each Participant page.
  4. Auto-Fit button added to each summary page makes it easier to view all of your qualitative data at the click of a button.

Version 1.2

  1. Corrected an error in the formula for calculating the satisfaction chart.
  2. The task order section of the Admin worksheet now includes the task letter references to help make it clear how the numbers relate to the task order.

Version 1.1

First public release.


Foundation Certificate in UX

Gain hands-on practice in all the key areas of UX while you prepare for the BCS Foundation Certificate in User Experience. More details

Download the best of Userfocus. For free.

100s of pages of practical advice on user experience, in handy portable form. 'Bright Ideas' eBooks.


Our services

Let us help you create great customer experiences.

Training courses

Join our community of UX professionals who get their user experience training from Userfocus. See our curriculum.