KDQOL-SF™ 1



KDQOL-36™ Scoring Program (v1.0)

Copyright © UCLA Division of General Internal Medicine and Health Services Research, 2000.

12/27/2000

kdqol36-1-template.xls – template to use for entering your data.

kdqol36-1-sample.xls – example with 20 cases.

Instructions for use:

The KDQOL-36™ scoring program (v1.0) is an Excel 97 spreadsheet consisting of 5 sheets: RAW, CONVERT, SCORE, SCALE, and STATS and assumes a basic knowledge of how to get around in Excel. It currently handles up to 1000 cases and with some small adjustments, can handle more.

RAW: all data entry is done here with each row representing a unique case. There is room for the date of administration and a case ID plus each item in the KDQOL-36™. Rules have been set up to only allow valid data for the KDQOL-36™ items. Out-of-range values are met with an error message and an opportunity to correct the value. Missing or invalid data defaults to the missing value ‘.’ which is necessary so that these cases are handled properly in subsequent computations.

CONVERT: static table that lists items from the KDQOL-36™ and how they get rescored.

SCORE: an intermediate table between RAW and SCALE. It is a dynamic table that shows how the data from RAW was rescored using the rules in CONVERT.

SCALE: computes and displays scale scores for each patient.

STATS: computes and displays descriptive statistics for KDQOL and SF-12 composite scores across all patients.

Note that when printing any of these sheets you must adjust your print area (File/Print Area) to reflect the number of cases you have. The template program is currently set up to print 20 cases.

Some details in computations:

• The symptoms scale reflects the average of the 12 kidney disease symptom items. Item 28a should only be answered if the patient is on hemodialysis and item 28b should only be answered if the patient is on peritoneal dialysis. In some cases patients give answers to both items. In our scoring program, we take the most extreme response of the two and use that in the computation of the symptom scale. We feel that this will ensure we obtain the intended response.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download