| 1 |
<?php
|
| 2 |
// $Id: dpistudy.install,v 1.7 2008/04/16 06:25:56 deekayen Exp $
|
| 3 |
|
| 4 |
/**
|
| 5 |
* Implementation of hook_schema().
|
| 6 |
*
|
| 7 |
* @return array
|
| 8 |
*/
|
| 9 |
function dpistudy_schema() {
|
| 10 |
$schema = array();
|
| 11 |
|
| 12 |
$schema['dpistudy_answers'] = array(
|
| 13 |
'description' => t('Answer choices to questions on the DPI questionnaire.'),
|
| 14 |
'fields' => array(
|
| 15 |
'parent' => array(
|
| 16 |
'description' => t('{dpistudy_questions}.pkid'),
|
| 17 |
'type' => 'int',
|
| 18 |
'size' => 'medium',
|
| 19 |
'unsigned' => false,
|
| 20 |
'not null' => true,
|
| 21 |
'default' => 0
|
| 22 |
),
|
| 23 |
'weight' => array(
|
| 24 |
'description' => t('The order in which to display the answer choices. Smaller values should appear before larger values.'),
|
| 25 |
'type' => 'int',
|
| 26 |
'size' => 'small',
|
| 27 |
'unsigned' => false,
|
| 28 |
'not null' => true,
|
| 29 |
'default' => 0
|
| 30 |
),
|
| 31 |
'answer' => array(
|
| 32 |
'description' => t('Text of the answer choice, displayed next to a radio button or checkbox for form submission.'),
|
| 33 |
'type' => 'varchar',
|
| 34 |
'not null' => true,
|
| 35 |
'default' => '',
|
| 36 |
'length' => 250
|
| 37 |
)
|
| 38 |
)
|
| 39 |
);
|
| 40 |
|
| 41 |
$schema['dpistudy_keys'] = array(
|
| 42 |
'description' => t('Invitation keys so people who received an invitation have a way to be recognized.'),
|
| 43 |
'fields' => array(
|
| 44 |
'invite_key' => array(
|
| 45 |
'description' => t('Short string to identify a participant as a member of a certain group when they respond to a specially constructed invitation.'),
|
| 46 |
'type' => 'varchar',
|
| 47 |
'not null' => true,
|
| 48 |
'default' => '',
|
| 49 |
'length' => 50
|
| 50 |
),
|
| 51 |
'notes' => array(
|
| 52 |
'description' => t('Description of what the key should be used for. Only useful as a reminder to admins.'),
|
| 53 |
'type' => 'varchar',
|
| 54 |
'not null' => true,
|
| 55 |
'default' => '',
|
| 56 |
'length' => 255
|
| 57 |
)
|
| 58 |
),
|
| 59 |
'primary key' => array('invite_key')
|
| 60 |
);
|
| 61 |
|
| 62 |
$schema['dpistudy_login'] = array(
|
| 63 |
'description' => t(''),
|
| 64 |
'fields' => array(
|
| 65 |
'sessid' => array(
|
| 66 |
'description' => t('MD5 hash of the session cookie, created by PHP, used to recognize a visitor across page views.'),
|
| 67 |
'type' => 'char',
|
| 68 |
'length' => 32,
|
| 69 |
'not null' => true,
|
| 70 |
'default' => ''
|
| 71 |
),
|
| 72 |
'invite_key' => array(
|
| 73 |
'description' => t('Invitation key from {dpistudy_keys}.invite_key.'),
|
| 74 |
'type' => 'varchar',
|
| 75 |
'not null' => true,
|
| 76 |
'default' => '',
|
| 77 |
'length' => 50
|
| 78 |
),
|
| 79 |
'agent' => array(
|
| 80 |
'description' => t('Web browser identifier. May help define bots from people.'),
|
| 81 |
'type' => 'varchar',
|
| 82 |
'not null' => true,
|
| 83 |
'default' => '',
|
| 84 |
'length' => 250
|
| 85 |
),
|
| 86 |
'referer' => array(
|
| 87 |
'description' => t('Where the user came from. May be useful for identifying people that would re-type the URL instead of clicking from an email invite.'),
|
| 88 |
'type' => 'varchar',
|
| 89 |
'not null' => true,
|
| 90 |
'default' => '',
|
| 91 |
'length' => 4096
|
| 92 |
),
|
| 93 |
'irb_php_timer' => array(
|
| 94 |
'description' => t('Value of the time spent between when the IRB consent page was loaded versus when it was submitted according to the difference in PHP\'s microtime() function.'),
|
| 95 |
'type' => 'float',
|
| 96 |
'not null' => true,
|
| 97 |
'default' => 0
|
| 98 |
),
|
| 99 |
'irb_apache_timer' => array(
|
| 100 |
'description' => t('Value of the time spent between page loads according to the difference in timestamps from the Date HTTP headers sent between viewing pages when viewing the IRB consent page.'),
|
| 101 |
'type' => 'int',
|
| 102 |
'size' => 'medium',
|
| 103 |
'unsigned' => false,
|
| 104 |
'not null' => true,
|
| 105 |
'default' => 0
|
| 106 |
),
|
| 107 |
'irb_js_timer' => array(
|
| 108 |
'description' => t('Value of a form-submitted variable set by a javascript function that starts incrementing by 1 from 0 as soon as each page finishes loading in its entirety when viewing the IRB consent page. Values here depend on the client browser both supporting and allowing javascript while viewing each page.'),
|
| 109 |
'type' => 'int',
|
| 110 |
'size' => 'medium',
|
| 111 |
'unsigned' => false,
|
| 112 |
'not null' => true,
|
| 113 |
'default' => 0
|
| 114 |
)
|
| 115 |
),
|
| 116 |
'primary key' => array('sessid', 'invite_key')
|
| 117 |
);
|
| 118 |
|
| 119 |
$schema['dpistudy_questions'] = array(
|
| 120 |
'description' => t('Questions asked as part of the instructional intervention.'),
|
| 121 |
'fields' => array(
|
| 122 |
'pkid' => array(
|
| 123 |
'description' => t('Identifier to keep track of relations between this table and {dpistudy_responses}.question'),
|
| 124 |
'type' => 'serial',
|
| 125 |
'size' => 'medium',
|
| 126 |
'unsigned' => false,
|
| 127 |
'not null' => true
|
| 128 |
),
|
| 129 |
'weight' => array(
|
| 130 |
'description' => t('The order in which the question should appear in the DPI questionnaire. Questions with smaller weights should appear before larger weights. The default dataset loaded by the module install file has weights which correspond to the question numbers in the original DPI questionnaire by Kelsey Henderson.'),
|
| 131 |
'type' => 'int',
|
| 132 |
'size' => 'small',
|
| 133 |
'unsigned' => false,
|
| 134 |
'not null' => true,
|
| 135 |
'default' => 0
|
| 136 |
),
|
| 137 |
'qtype' => array(
|
| 138 |
'description' => t('Defines whether a question should display radio buttons for a single response or checkboxes to answer with more than one choice. Equivalent to MySQL enum since it will only have "radio" or "checkbox" as values as a format for answering the question.'),
|
| 139 |
'type' => 'varchar',
|
| 140 |
'not null' => true,
|
| 141 |
'default' => 'radio',
|
| 142 |
'length' => 8
|
| 143 |
),
|
| 144 |
'title' => array(
|
| 145 |
'description' => t('The prompt or text of the question.'),
|
| 146 |
'type' => 'varchar',
|
| 147 |
'not null' => true,
|
| 148 |
'default' => '',
|
| 149 |
'length' => 250
|
| 150 |
)
|
| 151 |
),
|
| 152 |
'primary key' => array('pkid'),
|
| 153 |
'indexes' => array(
|
| 154 |
'weight' => array('weight')
|
| 155 |
)
|
| 156 |
);
|
| 157 |
|
| 158 |
$schema['dpistudy_responses'] = array(
|
| 159 |
'description' => t('Possible answers to the questions asked during the instructional intervention from {dpistudy_questions}.'),
|
| 160 |
'fields' => array(
|
| 161 |
'sessid' => array(
|
| 162 |
'description' => t('See {dpistudy_login}.sessid.'),
|
| 163 |
'type' => 'char',
|
| 164 |
'not null' => true,
|
| 165 |
'default' => '',
|
| 166 |
'length' => 32
|
| 167 |
),
|
| 168 |
'question' => array(
|
| 169 |
'description' => t('See {dpistudy_questions}.pkid.'),
|
| 170 |
'type' => 'int',
|
| 171 |
'size' => 'tiny',
|
| 172 |
'not null' => true,
|
| 173 |
'default' => 0
|
| 174 |
),
|
| 175 |
'answer' => array(
|
| 176 |
'description' => t('See {dpistudy_answers}.weight.'),
|
| 177 |
'type' => 'int',
|
| 178 |
'size' => 'tiny',
|
| 179 |
'not null' => true,
|
| 180 |
'default' => 9
|
| 181 |
),
|
| 182 |
'php_timer' => array(
|
| 183 |
'description' => t('Value of the time spent between page loads during the instructional intervention according to the difference in PHP\'s microtime() function.'),
|
| 184 |
'type' => 'float',
|
| 185 |
'not null' => true,
|
| 186 |
'default' => 0
|
| 187 |
),
|
| 188 |
'apache_timer' => array(
|
| 189 |
'description' => t('Value of the time spent between page loads according to the difference in timestamps from the Date HTTP headers sent between viewing pages during the instructional intervention.'),
|
| 190 |
'type' => 'int',
|
| 191 |
'size' => 'medium',
|
| 192 |
'unsigned' => false,
|
| 193 |
'not null' => true,
|
| 194 |
'default' => 0
|
| 195 |
),
|
| 196 |
'js_timer' => array(
|
| 197 |
'description' => t('Value of a form-submitted variable set by a javascript function that starts incrementing by 1 from 0 as soon as each page finishes loading in its entirety during the instructional intervention. Values here depend on the client browser both supporting and allowing javascript while viewing each page.'),
|
| 198 |
'type' => 'int',
|
| 199 |
'size' => 'medium',
|
| 200 |
'unsigned' => false,
|
| 201 |
'not null' => true,
|
| 202 |
'default' => 0
|
| 203 |
)
|
| 204 |
),
|
| 205 |
'primary key' => array('sessid', 'question')
|
| 206 |
);
|
| 207 |
|
| 208 |
return $schema;
|
| 209 |
}
|
| 210 |
|
| 211 |
/**
|
| 212 |
* Implementation of hook_install().
|
| 213 |
*
|
| 214 |
* Loads the DPI questionnaire and some default invitation keys.
|
| 215 |
*/
|
| 216 |
function dpistudy_install() {
|
| 217 |
drupal_install_schema('dpistudy');
|
| 218 |
|
| 219 |
db_query("UPDATE {permission} SET perm = 'access dpistudy, access content' WHERE rid = 1");
|
| 220 |
|
| 221 |
db_query("INSERT INTO {dpistudy_answers} (parent, weight, answer) VALUES
|
| 222 |
(1, 1, 'at no time during the week.'),
|
| 223 |
(1, 2, 'weekly.'),
|
| 224 |
(1, 3, '2-3 days per week.'),
|
| 225 |
(1, 4, 'daily.'),
|
| 226 |
(1, 5, 'more than 3 times daily.'),
|
| 227 |
(2, 1, 'at no time during the week.'),
|
| 228 |
(2, 2, 'weekly.'),
|
| 229 |
(2, 3, '2-3 days per week.'),
|
| 230 |
(2, 4, 'daily.'),
|
| 231 |
(2, 5, 'more than 3 times daily.'),
|
| 232 |
(3, 1, 'at no time during the week.'),
|
| 233 |
(3, 2, 'weekly.'),
|
| 234 |
(3, 3, '2-3 days per week.'),
|
| 235 |
(3, 4, 'daily.'),
|
| 236 |
(3, 5, 'more than 3 times daily.'),
|
| 237 |
(4, 1, 'never.'),
|
| 238 |
(4, 2, 'monthly.'),
|
| 239 |
(4, 3, 'weekly.'),
|
| 240 |
(4, 4, 'daily.'),
|
| 241 |
(4, 5, 'more than 3 times daily.'),
|
| 242 |
(5, 1, 'never.'),
|
| 243 |
(5, 2, 'monthly.'),
|
| 244 |
(5, 3, 'weekly.'),
|
| 245 |
(5, 4, 'daily.'),
|
| 246 |
(5, 5, 'more than 3 times daily.'),
|
| 247 |
(6, 1, 'never.'),
|
| 248 |
(6, 2, 'monthly.'),
|
| 249 |
(6, 3, 'weekly.'),
|
| 250 |
(6, 4, 'daily.'),
|
| 251 |
(6, 5, 'more than 3 times daily.'),
|
| 252 |
(7, 1, 'at no time during the year.'),
|
| 253 |
(7, 2, 'annually.'),
|
| 254 |
(7, 3, '2-3 times per year.'),
|
| 255 |
(7, 4, 'monthly.'),
|
| 256 |
(7, 5, 'more than 3 times per month.'),
|
| 257 |
(8, 1, 'at no time during the week.'),
|
| 258 |
(8, 2, 'weekly.'),
|
| 259 |
(8, 3, '2-3 days per week.'),
|
| 260 |
(8, 4, 'daily.'),
|
| 261 |
(8, 5, 'more than 3 times daily.'),
|
| 262 |
(9, 1, 'at no time during the week.'),
|
| 263 |
(9, 2, 'weekly.'),
|
| 264 |
(9, 3, '2-3 days per week.'),
|
| 265 |
(9, 4, 'daily.'),
|
| 266 |
(9, 5, 'more than 3 times daily.'),
|
| 267 |
(10, 1, 'none this year.'),
|
| 268 |
(10, 2, 'once this year.'),
|
| 269 |
(10, 3, '2-3 times this year.'),
|
| 270 |
(10, 4, 'once during the past 6 months.'),
|
| 271 |
(10, 5, 'more than three times during the past 6 months.'),
|
| 272 |
(11, 1, 'at no point (never).'),
|
| 273 |
(11, 2, 'once only.'),
|
| 274 |
(11, 3, 'more than once during the ownership of the game.'),
|
| 275 |
(11, 4, 'once during the session.'),
|
| 276 |
(11, 5, 'more than three times during the session.'),
|
| 277 |
(12, 1, 'at no point (never).'),
|
| 278 |
(12, 2, '1-5 times.'),
|
| 279 |
(12, 3, '6-10 times.'),
|
| 280 |
(12, 4, '11-20 times.'),
|
| 281 |
(12, 5, 'more than 20 times.'),
|
| 282 |
(13, 1, 'never.'),
|
| 283 |
(13, 2, 'monthly.'),
|
| 284 |
(13, 3, 'weekly.'),
|
| 285 |
(13, 4, 'daily.'),
|
| 286 |
(13, 5, 'more than 3 times daily.'),
|
| 287 |
(14, 1, 'none this year.'),
|
| 288 |
(14, 2, 'once this year.'),
|
| 289 |
(14, 3, '2-3 times this year.'),
|
| 290 |
(14, 4, 'once during the past 6 months.'),
|
| 291 |
(14, 5, 'more than three times during the past 6 months.'),
|
| 292 |
(15, 1, 'none this year.'),
|
| 293 |
(15, 2, 'once this year.'),
|
| 294 |
(15, 3, '2-3 times this year.'),
|
| 295 |
(15, 4, 'once during the past 6 months.'),
|
| 296 |
(15, 5, 'more than three times during the past 6 months.'),
|
| 297 |
(16, 1, 'not at all.'),
|
| 298 |
(16, 2, 'weekly.'),
|
| 299 |
(16, 3, '2-3 days per week.'),
|
| 300 |
(16, 4, 'daily.'),
|
| 301 |
(16, 5, 'more than 3 times per day.'),
|
| 302 |
(17, 1, 'not at all.'),
|
| 303 |
(17, 2, 'weekly.'),
|
| 304 |
(17, 3, '2-3 days per week.'),
|
| 305 |
(17, 4, 'daily.'),
|
| 306 |
(17, 5, 'more than 3 times per day.'),
|
| 307 |
(18, 1, 'not at all.'),
|
| 308 |
(18, 2, '1-5 times per day.'),
|
| 309 |
(18, 3, '6-10 times per day.'),
|
| 310 |
(18, 4, '11-20 times per day.'),
|
| 311 |
(18, 5, '16 or more times per day.'),
|
| 312 |
(19, 1, '0% of the time.'),
|
| 313 |
(19, 2, '25% of the time.'),
|
| 314 |
(19, 3, '50% of the time.'),
|
| 315 |
(19, 4, '75% of the time.'),
|
| 316 |
(19, 5, '100% of the time.'),
|
| 317 |
(20, 1, '0% of the time.'),
|
| 318 |
(20, 2, '25% of the time.'),
|
| 319 |
(20, 3, '50% of the time.'),
|
| 320 |
(20, 4, '75% of the time.'),
|
| 321 |
(20, 5, '100% of the time.'),
|
| 322 |
(21, 1, 'not at all.'),
|
| 323 |
(21, 2, 'weekly.'),
|
| 324 |
(21, 3, '2-3 days per week.'),
|
| 325 |
(21, 4, 'daily.'),
|
| 326 |
(21, 5, 'more than 3 times per day.'),
|
| 327 |
(22, 1, 'not at all.'),
|
| 328 |
(22, 2, 'weekly.'),
|
| 329 |
(22, 3, '2-3 days per week.'),
|
| 330 |
(22, 4, 'daily.'),
|
| 331 |
(22, 5, 'more than 3 times per day.'),
|
| 332 |
(23, 1, 'not at all.'),
|
| 333 |
(23, 2, 'weekly.'),
|
| 334 |
(23, 3, '2-3 days per week.'),
|
| 335 |
(23, 4, 'daily.'),
|
| 336 |
(23, 5, 'more than 3 times per day.'),
|
| 337 |
(24, 1, 'not at all.'),
|
| 338 |
(24, 2, 'weekly.'),
|
| 339 |
(24, 3, '2-3 days per week.'),
|
| 340 |
(24, 4, 'daily.'),
|
| 341 |
(24, 5, 'more than 3 times per day.'),
|
| 342 |
(25, 1, 'at no point (never).'),
|
| 343 |
(25, 2, '1-5 times.'),
|
| 344 |
(25, 3, '6-10 times.'),
|
| 345 |
(25, 4, '11-20 times.'),
|
| 346 |
(25, 5, 'more than 20 times.'),
|
| 347 |
(26, 1, 'at no point (never).'),
|
| 348 |
(26, 2, '1-5 times.'),
|
| 349 |
(26, 3, '6-10 times.'),
|
| 350 |
(26, 4, '11-20 times.'),
|
| 351 |
(26, 5, 'more than 20 times.'),
|
| 352 |
(27, 1, 'at no point (never).'),
|
| 353 |
(27, 2, '1-5 times.'),
|
| 354 |
(27, 3, '6-10 times.'),
|
| 355 |
(27, 4, '11-20 times.'),
|
| 356 |
(27, 5, 'more than 20 times.'),
|
| 357 |
(28, 1, 'not at all.'),
|
| 358 |
(28, 2, 'weekly.'),
|
| 359 |
(28, 3, '2-3 days per week.'),
|
| 360 |
(28, 4, 'daily.'),
|
| 361 |
(28, 5, 'more than 3 times per day.'),
|
| 362 |
(29, 1, 'at no time during the week.'),
|
| 363 |
(29, 2, 'weekly.'),
|
| 364 |
(29, 3, '2-3 days per week.'),
|
| 365 |
(29, 4, 'daily.'),
|
| 366 |
(29, 5, 'more than 3 times per day.'),
|
| 367 |
(30, 1, 'at no time during the week.'),
|
| 368 |
(30, 2, 'weekly.'),
|
| 369 |
(30, 3, '2-3 days per week.'),
|
| 370 |
(30, 4, 'daily.'),
|
| 371 |
(30, 5, 'more than 3 times daily.'),
|
| 372 |
(31, 1, 'at no point (never).'),
|
| 373 |
(31, 2, 'weekly.'),
|
| 374 |
(31, 3, '2-3 days per week.'),
|
| 375 |
(31, 4, 'daily.'),
|
| 376 |
(31, 5, 'more than 3 times daily.'),
|
| 377 |
(32, 1, 'none at all'),
|
| 378 |
(32, 2, '1'),
|
| 379 |
(32, 3, '2'),
|
| 380 |
(32, 4, '3'),
|
| 381 |
(32, 5, '4 or more'),
|
| 382 |
(33, 1, 'at no time during the week.'),
|
| 383 |
(33, 2, 'weekly.'),
|
| 384 |
(33, 3, '2-3 days per week.'),
|
| 385 |
(33, 4, 'daily.'),
|
| 386 |
(33, 5, 'more than 3 times daily.'),
|
| 387 |
(34, 1, 'none at all'),
|
| 388 |
(34, 2, '1'),
|
| 389 |
(34, 3, '2'),
|
| 390 |
(34, 4, '3'),
|
| 391 |
(34, 5, '4 or more'),
|
| 392 |
(35, 1, 'none at all'),
|
| 393 |
(35, 2, '1-5 times per year.'),
|
| 394 |
(35, 3, '6-10 times per year.'),
|
| 395 |
(35, 4, '11-20 times per year.'),
|
| 396 |
(35, 5, 'more than 15 times per year.'),
|
| 397 |
(36, 1, '$0-9,999'),
|
| 398 |
(36, 2, '$10,000-19,999'),
|
| 399 |
(36, 3, '$20,000-39,999'),
|
| 400 |
(36, 4, '$40,000-59,000'),
|
| 401 |
(36, 5, '$60,000 or more'),
|
| 402 |
(37, 1, 'none at all'),
|
| 403 |
(37, 2, '1'),
|
| 404 |
(37, 3, '2'),
|
| 405 |
(37, 4, '3'),
|
| 406 |
(37, 5, '4 or more'),
|
| 407 |
(38, 1, '1'),
|
| 408 |
(38, 2, '2'),
|
| 409 |
(38, 3, '3'),
|
| 410 |
(38, 4, '4'),
|
| 411 |
(38, 5, '5 or more'),
|
| 412 |
(39, 1, 'not at all.'),
|
| 413 |
(39, 2, 'less than an hour.'),
|
| 414 |
(39, 3, 'approximately 1-2 hours.'),
|
| 415 |
(39, 4, 'approximately 3-5 hours.'),
|
| 416 |
(39, 5, 'all day long.'),
|
| 417 |
(40, 1, '50 and over'),
|
| 418 |
(40, 2, '40-49'),
|
| 419 |
(40, 3, '30-39'),
|
| 420 |
(40, 4, '20-29'),
|
| 421 |
(40, 5, '18-19'),
|
| 422 |
(41, 1, 'male.'),
|
| 423 |
(41, 2, 'female.'),
|
| 424 |
(41, 3, 'transgender.'),
|
| 425 |
(42, 1, 'Strongly agree'),
|
| 426 |
(42, 2, 'Agree'),
|
| 427 |
(42, 3, 'Neutral'),
|
| 428 |
(42, 4, 'Disagree'),
|
| 429 |
(42, 5, 'Strongly disagree'),
|
| 430 |
(43, 1, 'Strongly agree'),
|
| 431 |
(43, 2, 'Agree'),
|
| 432 |
(43, 3, 'Neutral'),
|
| 433 |
(43, 4, 'Disagree'),
|
| 434 |
(43, 5, 'Strongly disagree'),
|
| 435 |
(44, 1, 'Strongly agree'),
|
| 436 |
(44, 2, 'Agree'),
|
| 437 |
(44, 3, 'Neutral'),
|
| 438 |
(44, 4, 'Disagree'),
|
| 439 |
(44, 5, 'Strongly disagree'),
|
| 440 |
(45, 1, 'Strongly agree'),
|
| 441 |
(45, 2, 'Agree'),
|
| 442 |
(45, 3, 'Neutral'),
|
| 443 |
(45, 4, 'Disagree'),
|
| 444 |
(45, 5, 'Strongly disagree'),
|
| 445 |
(46, 1, 'Strongly agree'),
|
| 446 |
(46, 2, 'Agree'),
|
| 447 |
(46, 3, 'Neutral'),
|
| 448 |
(46, 4, 'Disagree'),
|
| 449 |
(46, 5, 'Strongly disagree')");
|
| 450 |
|
| 451 |
db_query("INSERT INTO {dpistudy_keys} (invite_key, notes) VALUES
|
| 452 |
('test', 'This is just for testing before the proposal is accepted.'),
|
| 453 |
('practice', 'Another testing key.'),
|
| 454 |
('drupal', 'Contacts who have a connection to the Drupal content management system.'),
|
| 455 |
('ugrd', 'Undergraduate students at University of Central Florida.'),
|
| 456 |
('grad', 'Graduate students at University of Central Florida.'),
|
| 457 |
('aa', 'Contacts who have a business relationship with Advanced Automation, Inc, in Lindale, TX.'),
|
| 458 |
('cg', 'Contacts who employees of Classic Graphics in Charlotte, NC.'),
|
| 459 |
('d', 'People referred from clicking a link on deekayen.net.'),
|
| 460 |
('g', 'Visitors of a site that clicked a Google AdWords banner.'),
|
| 461 |
('tfsbo', 'Customers of Timeshares for Sale by Owner, Orlando, FL.'),
|
| 462 |
('fb', 'People who clicked the questionnaire invitation on facebook.com.'),
|
| 463 |
('ms', 'People who clicked the questionnaire invitation on myspace.com.'),
|
| 464 |
('friend', 'Personal friend of David Norman.')");
|
| 465 |
|
| 466 |
db_query("INSERT INTO {dpistudy_questions} (pkid, weight, title) VALUES
|
| 467 |
(1, 2, 'I communicate with others using email'),
|
| 468 |
(2, 3, 'I communicate with others using instant messaging (IM)'),
|
| 469 |
(3, 4, 'I communicate with others using chat rooms'),
|
| 470 |
(4, 6, 'I read or contribute to Web blogs'),
|
| 471 |
(5, 7, 'I share images and pictures online'),
|
| 472 |
(6, 8, 'I share ideas, papers, information, and knowledge online'),
|
| 473 |
(7, 9, 'I make online purchases'),
|
| 474 |
(8, 10, 'I download music from the Internet'),
|
| 475 |
(9, 11, 'I download movies from the Internet'),
|
| 476 |
(10, 13, 'I have updated my website or personal web space (e.g. MySpace)'),
|
| 477 |
(11, 14, 'When playing video games, I customize the characters or scenes within the game'),
|
| 478 |
(12, 15, 'I initially meet or arrange meetings with new people online'),
|
| 479 |
(13, 16, 'I meet with people online'),
|
| 480 |
(14, 17, 'I have downloaded MP3 files from the Internet'),
|
| 481 |
(15, 18, 'I have downloaded videos and images from the Internet'),
|
| 482 |
(16, 19, 'I use email or the Internet to complete group assignments for school and/or work'),
|
| 483 |
(17, 20, 'I participate in group games (MMORPGS)'),
|
| 484 |
(18, 21, 'I use a portable digital assistant (PDA) (e.g. PocketPC, PalmPilot, Blackberry)'),
|
| 485 |
(19, 22, 'I review online evaluation systems (e.g. star rating system) before making online purchases'),
|
| 486 |
(20, 23, 'I contribute to online evaluation systems (e.g. star rating system) after making online purchases'),
|
| 487 |
(21, 24, 'I play video games'),
|
| 488 |
(22, 25, 'I play 1-2 player video games'),
|
| 489 |
(23, 26, 'I play games requiring more than 2 players'),
|
| 490 |
(24, 27, 'I use handheld game devices'),
|
| 491 |
(25, 28, 'I have taken courses online'),
|
| 492 |
(26, 29, 'I found information to complete school or work assignments online'),
|
| 493 |
(27, 30, 'I have gone online to learn about topics that interest me'),
|
| 494 |
(28, 32, 'I use the internet to communicate with the instructor, fellow classmates, or coworkers'),
|
| 495 |
(29, 33, 'I use search engines to locate information on the Internet'),
|
| 496 |
(30, 34, 'I use filtering tools (advanced search, directories, etc.) when locating information on the Internet'),
|
| 497 |
(31, 35, 'I search for information for entertainment and other personal reasons online'),
|
| 498 |
(32, 36, 'I have expertise in the following number of programming languages'),
|
| 499 |
(33, 37, 'I socialize with others online'),
|
| 500 |
(34, 38, 'When I am online, I can manage the following maximum number of conversations at the same time'),
|
| 501 |
(35, 39, 'I travel for business'),
|
| 502 |
(36, 40, 'My family''s annual gross income is'),
|
| 503 |
(37, 41, 'I have the following number of computers in my home'),
|
| 504 |
(38, 42, 'I have the following number of people in my household'),
|
| 505 |
(39, 43, 'I use a computer at work'),
|
| 506 |
(40, 44, 'My age group is'),
|
| 507 |
(41, 45, 'My gender is'),
|
| 508 |
(42, 46, 'I prefer training and/or educational materials that present graphics, rather than text first'),
|
| 509 |
(43, 47, 'I prefer training and/or education that allows me to randomly access various components of a lesson, rather than materials that step me through a lesson one component at a time'),
|
| 510 |
(44, 48, 'I prefer to complete multiple tasks (e.g. Instant Messaging, alternative activities, watching TV) rather than one task at a time while I''m learning'),
|
| 511 |
(45, 49, 'I prefer training and/or education that is play oriented, rather than work oriented'),
|
| 512 |
(46, 50, 'I prefer training and/or education that encourages me to communicate and learn with others rather than learning by myself')");
|
| 513 |
|
| 514 |
variable_set('site_frontpage', 'dpistudy');
|
| 515 |
|
| 516 |
variable_set('dpistudy_irb_text', '<p>A research project is being conducted by Mr. David Norman to study the impact of digital media in daily life. The purpose of this study is to observe whether there is any relationship between digital media interaction and student performance with different forms of instruction.</p>
|
| 517 |
|
| 518 |
<p>You are being asked to take part in this study by completing a questionnaire. Please be aware that you are not required to participate in this research and you may discontinue your participation at any time without penalty. You may also omit any items on the questionnaire you prefer not to answer.</p>
|
| 519 |
|
| 520 |
<p>There are no risks associated with participation in this study. Your responses will be analyzed and reported anonymously to protect your privacy.</p>
|
| 521 |
|
| 522 |
<p>Potential benefits associated with the study include finding new ways to teach students using different approaches based on how much they tend to use technology. There are no direct benefits or compensation for your participation.</p>
|
| 523 |
|
| 524 |
<p>Research at the University of Central Florida involving human participants is carried out under the oversight of the Institutional Review Board. Questions or concerns about research participants\' rights may be directed to the UCF IRB office, University of Central Florida, Office of Research & Commercialization, 12201 Research Parkway, Suite 501, Orlando, FL 32826-3246, or by campus mail 32816-0150. The hours of operation are 8:00 am until 5:00 pm, Monday through Friday except on University of Central Florida official holidays. The telephone numbers are (407) 882-2276 and (407) 823-2901.</p>
|
| 525 |
|
| 526 |
<p>For any other questions about this study, contact David Norman at <a href="mailto:da316305@pegasus.cc.ucf.edu">da316305@pegasus.cc.ucf.edu</a>. This research is being conducted with Dr. Atsusi Hirumi (<a href="mailto:hirumi@mail.ucf.edu">hirumi@mail.ucf.edu</a>), Associate Professor & Co Chair of Instructional Technology at the University of Central Florida.
|
| 527 |
|
| 528 |
<p>By participating in this survey you voluntarily agree to allow the researchers to use the information you provide for related presentations, publications, and future research. If you decide to participate in this research study, you must be at least 18 years old and click "I consent" at the bottom of this screen.</p>');
|
| 529 |
|
| 530 |
variable_set('dpistudy_score_screen', '<p>Your Digital Propensity Index score is <strong>@score</strong>. A score of 34 would represent the far extreme Digital Immigrant as opposed to the other extreme of 170 for a pure Digital Native.</p>
|
| 531 |
|
| 532 |
<p>According to <a href="http://www.marcprensky.com/">Marc Prensky</a>, Digital Natives are more likely to be used to receiving information quickly, like to parallel process and multi-task, prefer their graphics before text, and prefer random access like hypertext you see on websites. They function best when networked, thrive on instant gratification and rewards, and like games.</p>
|
| 533 |
|
| 534 |
<p>Digital Immigrants commonly did not grow up with digital media. They prefer linear, step-by-step tasks, perform best when doing one thing at a time, and are used to receiving information slowly. A comparison of Digital Natives and Digital Immigrants is as follows:</p>
|
| 535 |
|
| 536 |
<table border="1">
|
| 537 |
<tr><th>Digital Immigrants</th><th>Digital Natives</th></tr>
|
| 538 |
<tr><td valign="top">
|
| 539 |
<ul>
|
| 540 |
<li>Merely adopted aspects of new technologies</li>
|
| 541 |
<li>Turn to the Internet second rather than first</li>
|
| 542 |
<li>Print emails</li>
|
| 543 |
<li>Bring people physically to view websites</li>
|
| 544 |
<li>Call to confirm email receipt</li>
|
| 545 |
<li>Used to receiving information slow</li>
|
| 546 |
<li>Prefer text before graphics</li>
|
| 547 |
<li>Prefer linear, step-by-step tasks</li>
|
| 548 |
<li>Prefer serious work to games</li>
|
| 549 |
<li>Function best by doing one thing at a time, individually</li>
|
| 550 |
</ul>
|
| 551 |
</td><td valign="top">
|
| 552 |
<ul>
|
| 553 |
<li>"Spent entire lives surrounded by and using computers, videogames, digital music players, video cams, cell phones..."</li>
|
| 554 |
<li>"Process information differently from predecessors..."</li>
|
| 555 |
<li>Used to receiving information fast</li>
|
| 556 |
<li>Like to parallel and multi-task</li>
|
| 557 |
<li>Prefer graphics before text</li>
|
| 558 |
<li>Prefer random access</li>
|
| 559 |
<li>Function best when networked</li>
|
| 560 |
<li>Thrive on instant gratification and frequent rewards</li>
|
| 561 |
<li>Prefer games to serious work</li>
|
| 562 |
<li>Have short attention spans</li>
|
| 563 |
</ul>
|
| 564 |
</td></tr>
|
| 565 |
</table>
|
| 566 |
|
| 567 |
<p>For more information about Digital Immigrants and Digital Natives, read "<a href="http://www.marcprensky.com/writing/default.asp">Digital Natives, Digital Immigrants</a>" by Marc Prensky.</p>');
|
| 568 |
}
|
| 569 |
|
| 570 |
/**
|
| 571 |
* Implementation of hook_uninstall().
|
| 572 |
*/
|
| 573 |
function dpistudy_uninstall() {
|
| 574 |
drupal_uninstall_schema('dpistudy');
|
| 575 |
|
| 576 |
variable_set('site_frontpage', 'node');
|
| 577 |
variable_del('dpistudy_irb_text');
|
| 578 |
variable_del('dpistudy_irb_consent_active');
|
| 579 |
variable_del('dpistudy_add_form_num_questions');
|
| 580 |
variable_del('dpistudy_alt_irb_url');
|
| 581 |
variable_del('dpistudy_score_screen');
|
| 582 |
cache_clear_all('dpistudy-', 'cache', TRUE);
|
| 583 |
}
|