*** IPAQ-VC ***
*** Cálculo das Dimensões do IPAQ(Pre-Test)***
1# Data Cleaning
I. Responses shouldbeconvertedfromhoursand minutes into minutes.
II. Valuesof ‘15’, ‘30’, ‘45’, ‘60’ and ‘90’ inthe ‘hours’ columnshouldbeconverted to ‘15’, ‘30’, ‘45’, ‘60’ and ‘90’ minutes, respectively, inthe minutes column.
III. In some cases duration (time) willbereported as weekly (notdaily). These data shouldbeconvertedintoanaveragedaily time bydividingby 7.
IV.If ‘don’tknow’ or ‘refused ‘ or data are missing for time ordaysthenthat case isremovedfromanalysis.
2# MaximumValues for ExcludingOutliers
All cases inwhichthesum total ofallWalking, ModerateandVigorous time variablesisgreaterthan 960 minutes (16 hours) shouldbeexcludedfromtheanalysis. This assumes thatonaveragean individual of 8 hours per dayisspentsleeping.
The ‘days’ variables can takethe range 0-7 days, or 8, 9 (don’tknoworrefused); valuesgreaterthan 9 shouldnotbeallowedandthose cases excludedfromanalysis.
3#MinimumValues for DurationofActivity
Responses oflessthan 10 minutes [andtheirassociateddays] shouldbere-coded to ‘zero’.
4#Truncationof Data Rules
ItisrecommendedthatallWalking, ModerateandVigorous time variablesexceeding ‘ 3 hours’ or ‘180 minutes’ are truncated (thatisre-coded) to beequal to ‘180 minutes’ in a newvariable. This rule permits a maximumof 21 hoursofactivityin a week to bereported for eachcategory (3 hours * 7 days).
5#Calculating MET-minute/week Scores
Usingtheresultingvariables, convert time anddays to MET-minute/week scores
MET Valuesand Formula for Computationof MET-minutes/week
The selected MET values were derived from work undertaken during the IPAQ Reliability Study undertaken in 2000-20013. Using the Ainsworth et al. Compendium (Med Sci Sports Med 2000) an average MET score was derived for each type of activity. For example; all types of walking were included and an average MET value for walking was created. The same procedure was undertaken for moderate-intensity activities and vigorous-intensity activities. The following values continue to be used for the analysis of IPAQ data: Walking = 3.3 METs, Moderate PA = 4.0 METs and Vigorous PA = 8.0 METs.
***Walking***
Walking MET-minutes/week = 3.3 * walking minutes * walkingdays
COMPUTE PreTest_IPAQ_WalkingMETWeek=3.3*PreTest_IPAQ_1b*PreTest_IPAQ_1a.
EXECUTE.
***Moderate***
Moderate MET-minutes/week = 4.0 * moderate-intensityactivity minutes * moderatedays
COMPUTE PreTest_IPAQ_ModerateMETWeek=4*PreTest_IPAQ_2b*PreTest_IPAQ_2a.
EXECUTE.
***Vigorous***
Vigorous MET-minutes/week = 8.0 * vigorous-intensityactivity minutes * vigorous-intensitydays
COMPUTE PreTest_IPAQ_VigorousMETWeek=8*PreTest_IPAQ_3b*PreTest_IPAQ_3a.
EXECUTE.
***Total PhysicalActivity***
Total physicalactivity MET-minutes/week = sumofWalking + Moderate + Vigorous MET- minutes/week scores.
COMPUTE
PreTest_IPAQ_TotalPAMETWeek=PreTest_IPAQ_WalkingMETWeek+PreTest_IPAQ_ModerateMETWeek+PreTest_IPAQ_VigorousMETWeek.
EXECUTE.
6#Calculating Total Days for PresentingCategorical Data onModerateandHighLevels
Presenting IPAQ data usingcategoricalvariablesrequiresthe total numberof ‘days’ onwhichallphysicalactivitywasundertaken to beassessed. Thisisdifficultbecausefrequencyin ‘days’ isaskedseparately for walking, moderate-intensityandvigorous- intensityactivities, thusallowingthe total numberof ‘days’ to range from a minimumof 0 to a maximumof 21’days’ per weekin IPAQ shortandhigherin IPAQ long. The IPAQ instrument does not record ifdifferenttypesofactivity are undertakenonthesameday.
Categorical Score- three levels of physical activity are proposed
- Low
•No activity is reported
OR
•Some activity is reported but not enough to meet Categories 2 or 3.
- Moderate
- Either of the following 3 criteria
•3 or more days of vigorous activity of at least 20 minutes per day OR
•5 or more days of moderate-intensity activity and/or walking of at least 30 minutes per day
OR
•5 or more days of any combination of walking, moderate-intensity or vigorous- intensity activities achieving a minimum of at least 600 MET-minutes/week.
- High
Any one of the following 2 criteria
•Vigorous-intensity activity on at least 3 days and accumulating at least 1500 MET-minutes/week
OR
•7 or more days of any combination of walking, moderate- or vigorous-intensity activities accumulating at least 3000 MET-minutes/week
=IF(OR(CO111=9999;CQ111=9999;CS111=9999;CU111=9999;CW111=9999;CY111=9999);9999;IF(OR(AND(CW111>=3;DH111>=1500);AND(CO111+CS111+CW111>=7;DH111>=3000));3;IF(OR(AND(CW111>=3;CY111>=20);AND(CO111+CS111>=5;CQ111+CU111>=30);AND(CO111+CS111+CW111>=5;DH111>=600));2;1)))
***Highactive***
IF(PreTest_IPAQ_3a >= 3 & PreTest_IPAQ_TotalPAMETWeek >= 1500) OR (PreTest_IPAQ_1a + PreTest_IPAQ_2a + PreTest_IPAQ_3a >= 7 & PreTest_IPAQ_TotalPAMETWeek >= 3000) PreTest_IPAQ_Categoria=3.
EXECUTE.
***Moderateactive***
IF(PreTest_IPAQ_3a >= 3 & PreTest_IPAQ_3b >= 20) OR (PreTest_IPAQ_1a + PreTest_IPAQ_2a >= 5 & PreTest_IPAQ_1b + PreTest_IPAQ_2b >= 30) OR (PreTest_IPAQ_1a + PreTest_IPAQ_2a + PreTest_IPAQ_3a >= 5 & PreTest_IPAQ_TotalPAMETWeek >= 600) PreTest_IPAQ_Categoria=2.
EXECUTE.
***Lowactive***
IF(PreTest_IPAQ_Categoria~=2 OR PreTest_IPAQ_Categoria~=3) PreTest_IPAQ_Categoria=1.
EXECUTE.
SittingQuestionin IPAQ ShortForm
The IPAQ sittingquestionisanadditionalindicatorvariableof time spentinsedentaryactivityandisnotincluded as partofanysummary score ofphysicalactivity. Data onsittingshouldbereported as medianvaluesandinterquartile ranges. To-date there are few data onsedentary (sitting) behavioursand no well-acceptedthresholds for data presented as categoricallevels.
***Sitting minutes in a week***
COMPUTE
PreTest_IPAQ_Sitting_Week = PreTest_IPAQ_4a*5 + PreTest_IPAQ_4b*2.
VARIABLE LABELS PreTest_IPAQ_Sitting_Week'IPAQ Min Sentado Total (por semana)' .
EXECUTE .
*** Cálculo das Dimensões do IPAQ(Post-Test)***
***Calculating MET-minute/week Scores***
***Walking***
COMPUTE PostTest_IPAQ_WalkingMETWeek=3.3*PostTest_IPAQ_1b*PostTest_IPAQ_1a.
EXECUTE.
***Moderate***
COMPUTE PostTest_IPAQ_ModerateMETWeek=4*PostTest_IPAQ_2b*PostTest_IPAQ_2a.
EXECUTE.
***Vigorous***
COMPUTE PostTest_IPAQ_VigorousMETWeek=8*PostTest_IPAQ_3b*PostTest_IPAQ_3a.
EXECUTE.
***Total PhysicalActivity***
COMPUTE
PostTest_IPAQ_TotalPAMETWeek=PostTest_IPAQ_WalkingMETWeek+PostTest_IPAQ_ModerateMETWeek+PostTest_IPAQ_VigorousMETWeek.
EXECUTE.
***Calculating Total Days for PostsentingCategorical Data onModerateandHighLevels***
***Highactive***
IF(PostTest_IPAQ_3a >= 3 & PostTest_IPAQ_TotalPAMETWeek >= 1500) OR (PostTest_IPAQ_1a + PostTest_IPAQ_2a + PostTest_IPAQ_3a >= 7 & PostTest_IPAQ_TotalPAMETWeek >= 3000) PostTest_IPAQ_Categoria=3.
EXECUTE.
***Moderateactive***
IF(PostTest_IPAQ_3a >= 3 & PostTest_IPAQ_3b >= 20) OR (PostTest_IPAQ_1a + PostTest_IPAQ_2a >= 5 & PostTest_IPAQ_1b + PostTest_IPAQ_2b >= 30) OR (PostTest_IPAQ_1a + PostTest_IPAQ_2a + PostTest_IPAQ_3a >= 5 & PostTest_IPAQ_TotalPAMETWeek >= 600) PostTest_IPAQ_Categoria=2.
EXECUTE.
***Lowactive***
IF(PostTest_IPAQ_Categoria~=2 OR PostTest_IPAQ_Categoria~=3) PostTest_IPAQ_Categoria=1.
EXECUTE.
***SittingQuestionin IPAQ ShortForm***
***Sitting minutes in a week***
COMPUTE
PostTest_IPAQ_Sitting_Week = PostTest_IPAQ_4a*5 + PostTest_IPAQ_4b*2.
VARIABLE LABELS PostTest_IPAQ_Sitting_Week 'IPAQ Min Sentado Total (por semana)' .
EXECUTE .
*** Cálculo das Dimensões do IPAQ(Follow-Up)***
***Calculating MET-minute/week Scores***
***Walking***
COMPUTE FllwUp_IPAQ_WalkingMETWeek=3.3*FllwUp_IPAQ_1b*FllwUp_IPAQ_1a.
EXECUTE.
***Moderate***
COMPUTE FllwUp_IPAQ_ModerateMETWeek=4*FllwUp_IPAQ_2b*FllwUp_IPAQ_2a.
EXECUTE.
***Vigorous***
COMPUTE FllwUp_IPAQ_VigorousMETWeek=8*FllwUp_IPAQ_3b*FllwUp_IPAQ_3a.
EXECUTE.
***Total PhysicalActivity***
COMPUTE
FllwUp_IPAQ_TotalPAMETWeek=FllwUp_IPAQ_WalkingMETWeek+FllwUp_IPAQ_ModerateMETWeek+FllwUp_IPAQ_VigorousMETWeek.
EXECUTE.
***Calculating Total Days for PostsentingCategorical Data onModerateandHighLevels***
***Highactive***
IF(FllwUp_IPAQ_3a >= 3 & FllwUp_IPAQ_TotalPAMETWeek >= 1500) OR (FllwUp_IPAQ_1a + FllwUp_IPAQ_2a + FllwUp_IPAQ_3a >= 7 & FllwUp_IPAQ_TotalPAMETWeek >= 3000) FllwUp_IPAQ_Categoria=3.
EXECUTE.
***Moderateactive***
IF(FllwUp_IPAQ_3a >= 3 & FllwUp_IPAQ_3b >= 20) OR (FllwUp_IPAQ_1a + FllwUp_IPAQ_2a >= 5 & FllwUp_IPAQ_1b + FllwUp_IPAQ_2b >= 30) OR (FllwUp_IPAQ_1a + FllwUp_IPAQ_2a + FllwUp_IPAQ_3a >= 5 & FllwUp_IPAQ_TotalPAMETWeek >= 600) FllwUp_IPAQ_Categoria=2.
EXECUTE.
***Lowactive***
IF(FllwUp_IPAQ_Categoria~=2 OR FllwUp_IPAQ_Categoria~=3) FllwUp_IPAQ_Categoria=1.
EXECUTE.
***SittingQuestionin IPAQ ShortForm***
***Sitting minutes in a week***
COMPUTE
FllwUp_IPAQ_Sitting_Week = FllwUp_IPAQ_4a*5 + FllwUp_IPAQ_4b*2.
VARIABLE LABELS FllwUp_IPAQ_Sitting_Week 'IPAQ Min Sentado Total (por semana)' .
EXECUTE .