1st data on stanford

8/3/2019 1st Data on Stanford

http://slidepdf.com/reader/full/1st-data-on-stanford 1/344



8



16



25



33



QUESTION

1 study_id text Study ID

Instructions:

1. Do not sort, copy, or move any of the cells or rows in the Ex

sorted, copied or move. Please begin entering data in a new E

2. Do not move or touch any rows in yellow after 400. All valid

3. Click on cells in column I to see dropdown options

4. Click on cells in column J for dropdown values



29 t2 dropdown

23. Do you CURRENTLY smoke

products DAILY?

30 t32_5c9 text

24. How old were you when you f

smoking DAILY?

31 t4a text

25a. Do you remember how long

smoking in YEARS? (If not know

to question 25b.)

32 t4b text

25b. Do you remember how long

smoking in MONTHS? (If not kno

go to question 25c.)

33 t4c text

25c. Do you remember how long

smoking in WEEKS?

34 t5a text

26a. On average, how many MAN

(e g Marlboro) cigarettes do you43 D i th t 30 d h



59 a7 text

43. During the past 30 days, how

you have (for men: five or more, f

or more) STANDARD ALCOHOL

single drinking occasion? (Intervi

of standard alcoholic drink).

60 a8 radio

44. During the past 30 days, when

an alcoholic drink, how often was

(do not include snacks)?

61 a9a text

45a. During the past 7 days, how

alcoholic drinks did you have on M(Interviewer: show card of stan

drink).

62 a9b text

45b. During the past 7 days, how

alcoholic drinks did you have on T

(Interviewer: show card of stan

drink).

45c. During the past 7 days, how

61 D d VIGOROUS IN



98 p10 dropdown

61. Do you do any VIGOROUS-IN

SPORTS, fitness or recreational a

cause large increases in breathin

at least 10 min continuously? (Inte

vigorous-intensity card).

99 p11 text

62. In a typical week, on how man

do VIGOROUS-INTENSITY SPO

recreational activities?

100 p12 text

63. How much TIME do you spen

VIGOROUS-INTENSITY SPORTrecreational activities on a typical

101 p13 dropdown

64. Do you do any MODERATE-I

SPORTS, fitness or recreational a

cause a small increase in breathin

(e.g. brisk walking)?

65. In a typical week, on how man

do MODERATE-INTENSITY SPO

144 4 lbk l 83d C l l t i ht i d (



144 m4_lbkg calc 83d. Calculate weight in pounds (

m5 dropdown 84. For women: Are you preg

145 m6 text 85. Device ID for waist

146 m7 text 86. Waist circumference (in cm)

147 m8 text 87. Interviewer ID

148 m9 text 88. Device ID for blood pressure

149 m10 radio 89. Cuff size

150 m11a text 90a. BP 1st Juncture: Systolic (m

151 m11b text 90b. BP 1st Juncture: Diastolic (m

152 m12a text 91a. BP 2nd Juncture: Systolic (m153 m12b text 91b. BP 2nd Juncture: Diastolic (m

154 m13a text 92a. BP 3rd Juncture: Systolic (m

155 m13b text 92b. BP 3rd Juncture: Diastolic (m

m14 dropdown

93. During the past 2 weeks,

treated for raised blood press

medicines?

156 m15 text 94. Hip circumference (in cm)



212 weight_1 dropdown 23. Are you currently taking steps

213 weight_2 dropdown

24. If you're taking steps to lose w

steps are you taking?

214 smoke_1 dropdown 25. Do you smoke?

215 smoke_2 dropdown

26. If you smoke, are you currentl

stop smoking?

216 smoke_3 text

27. If you're taking steps to stop s

steps are you taking?

217 exercise dropdown 28. Have you ever been advised tcontrol you blood pressure?

218 exercise dropdown

29. Have you ever been advised t

control your diabetes?


30. Are you currently taking steps

blood pressure by exercising?


31. Are you currently taking steps

diabetes by exercising?

270 v1 30 text Fasting blood glucose mg/dl



270 v1_30 text Fasting blood glucose-mg/dl

271 v1_32 text Glucose strip

272 v1_34 text Device ID

273 v1_35 text Total cholesterol-mmol/l

274 v1_36 text Total cholesterol-mg/dl

275 v1_38 text Triglycerides-mmol/l

276 v1_39 text Triglycerides-mg/dl

277 v1_40 text HDL Cholesterol-mmol/l

278 v1_41 text HDL Cholesterol-mg/dl

279 v1_ldl text LDL Cholesterol-mmol/l280 v1_ldl_m text LDL Cholesterol-mg/dl

281 v1_42 text SGOT(ALT)

282 v1_43 text Creatinine-mg/dl

283 v1_44 text Uric acid

284 c_hem text Hemoglobin

285 p_1 dropdown Explained purpose of study?

286 p_2 dropdown Explained how to use diet diary?

349 v4 6 calc Calculate weight in kilograms (kg



349 v4_6 calc Calculate weight in kilograms (kg

350 v4_7 text Enter Weight in kilograms (kg)

351 v4_8 calc Calculate weight in pounds (lbs)

352 v4_9 text Calc BMI

353 v4_10 text Device ID for waist

354 v4_11 text Waist circumference

355 v4_12 text Interviewer ID

356 v4_13 text Device ID for blood pressure

357 v4_14 radio Cuff size

358 v4_15 text Reading 1: Systolic

359 v4_16 text Reading 1: Diastolic





During the past two weeks, have

v6 26 text Technician ID



v6_26 text Technician IDv6_27 text Device ID

v6_28 text Time of day blood specimen

v6_29 text Fasting blood glucose-mmol/l

v6_30 text Fasting blood glucose-mg/dl

v6_31 text Hemoglobin A1C

v6_32 text Glucose strip

v6_33 dropdown

Today, have you taken insulin or

for raised blood glucose?

v6_34 text Device ID

v6_35 text Total cholesterol-mmol/l

v6_36 text Total cholesterol-mg/dl

v6_37 dropdown

During the past two weeks have y

for raised cholesterol with medica

v6_38 text Triglycerides-mmol/l

v6_39 text Triglycerides-mg/dl

6 40 t t HDL Ch l t l l/l



Record Record Record

SG_2 SG_3 SG_4



1

31

7



2 2

2 2



2 2

Tape measure Tape measure Tape measure

73cm 97cm 90cm

Shu-Jen Shu-jen Shu-jen

Omron BP Monitor Omrom BP Monitor Omron BP Monitor

2 2

158 205.5 14

93 147 5

156 184 141.88 116.5 70.

151 188.5 14

89 124.5 6

2 1

79cm 98cm 88cm



2 1

2

2 2

1 1

2 2

1 1

2 2



Record Record



Variabl Form NField U Sectio Field T Field Label Choic

142 m4_kgl physica lbs calc 83b. Calculate w [m4_k

144 m4_lbk physica lbs calc 83d. Calculate w [m4_l

197 v1_6 visit_on lbs calc Calculate weight [v1_5

199 v1_8 visit_on lbs calc Calculate weight [v1_7

245 v2_6 visit_tw lbs calc Calculate weight [v2_5

247 v2_8 visit_tw lbs calc Calculate weight [v2_7

273 v3_6 visit_th lbs calc Calculate weight [v3_5

275 v3_8 visit_th lbs calc Calculate weight [v3_7300 v4_6 visit_fo lbs calc Calculate weight [v4_5

302 v4_8 visit_fo lbs calc Calculate weight [v4_7

328 v5_6 visit_fiv lbs calc Calculate weight [v5_5

330 v5_8 visit_fiv lbs calc Calculate weight [v5_7

356 v6_6 visit_si lbs calc Calculate weight [v6_5

358 v6_8 visit_si lbs calc Calculate weight [v6_7



114 h_weig behavioral_measuremedropdo 71ddd. If you ar 1, Die

129 h_dw behavioral_measuremedropdo 77ee. If you are 1, Die

8 i6 survey information dropdo 6. Interview lang1, En

184 q9 study_screen dropdo 10. Interviewer: 1, No




236 p_1 visit_one Behavi dropdo Explained purpo 1, No

237 p_2 visit_one dropdo Explained how t 1, No

238 p_22_a visit_one dropdo Explained how t 1, No

239 p_22_a visit_one dropdo Scheduled visit 1, No

265 dd_1 visit_two Behavi dropdo Diet Diary Chec 1, No266 dd_2 visit_two dropdo Activity Diary Ch 1, No

267 dd_3 visit_two dropdo Scheduled visit 1, No

292 v3_25 visit_three Behavi dropdo Diet Diary Chec 1, No

293 v3_26 visit_three dropdo Activity Diary Ch 1, No

294 v3_27 visit_three dropdo Scheduled visit 1, No

320 v4_26 visit_four Behavi dropdo Diet Diary Chec 1, No



321 v4_27 visit_four dropdo Activity Diary Ch 1, No

322 v4_28 visit_four dropdo Scheduled visit 1, No

348 v5 26 visit five Behavi dropdo Diet Diary Chec 1, No

58 a6 behavioral_measuremetext 42. During the past 30

59 a7 behavioral_measuremetext 43. During the past 30

61 a9a behavioral_measuremetext 45a. During the past 7

62 a9b behavioral_measuremetext 45b. During the past 7

63 a9c behavioral_measuremetext 45c. During the past 7

64 a9d behavioral_measuremetext 45d. During the past 7

65 a9e behavioral_measuremetext 45e. During the past 7

66 a9f behavioral_measuremetext 45f. During the past 7

67 a9g behavioral_measuremetext 45g. During the past 768 d1 behavioral_me CORE: text 46. In a typical week, o

69 d2 behavioral_measuremetext 47. How many serving

70 d3 behavioral_measuremetext 48. In a typical week, o

71 d4 behavioral_measuremetext 49. How many serving

73 d6 behavioral_measuremetext 51. On average, how m

74 d6_wr behavioral_measuremetext 51_a. How many cups



75 d6_b behavioral_measuremetext 51_b. How many cups

76 d7 behavioral_measuremetext 51_c. How many slices

77 d8 behavioral measuremetext 51 d. How many bowl

208 v1_15 visit_onmmHg text Reading 1: Systolic

209 v1_16 visit_onmmHg text Reading 1: Diastolic





214 v1_22 visit_on bpm text Reading 1 Heart Rate

215 v1_23 visit_on bpm text Reading 2 Heart Rate

216 v1_24 visit_onbpm text Reading 3 Heart Rate 217 v1_26 visit_one Blood text Technician ID

218 v1_27 visit_one text Device ID

219 v1_28 visit_one text Time of day blood spe

220 v1_29 visit_onmmol/l text Fasting blood glucose-

221 v1_30 visit_onmg/dl text Fasting blood glucose-

222 v1_32 visit_one text Glucose strip



223 v1_34 visit_one Blood Ltext Device ID

224 v1_35 visit_onmmol/l text Total cholesterol-mmo

225 v1 36 visit onmg/dl text Total cholesterol-mg/d

312 v4_18 visit_fo mmHg text Reading 2: Diastolic

313 v4_19 visit_fo mmHg text Reading 3: Systolic

314 v4_20 visit_fo mmHg text Reading 3: Diastolic

316 v4_22 visit_fo bpm text Reading 1 Heart Rate



319 v4_25 visit_four text Glucose strip

323 v5_1 visit_five Height text Interviewer ID

324 v5_2 visit_five text Device ID for height325 v5_3 visit_five text Device ID for weight

326 v5_4 visit_fiv cm text Height

327 v5_5 visit_fiv kg text Enter Weight in pound

329 v5_7 visit_fiv kg text Enter Weight in kilogra

331 v5_9 visit_five text Calc BMI

332 v5_10 visit_five Waist text Device ID for waist

333 5 11 i it fi t t W i t i f



333 v5_11 visit_fiv cm text Waist circumference

334 v5_12 visit_five Blood text Interviewer ID

335 v5 13 visit f ive text Device ID for blood pre



ompatibility Report or DATA ENTRY_Blan

Run on 9/10/2011 11:24

The following features in this workbook are not

Excel. These features may be lost or degraded

in an earlier file format.

Minor loss of fidelity

Some cells or styles in this workbook contain fo

by the selected file format These formats will b



by the selected file format. These formats will b

format available.

1st data on stanford

Documents