InfoAccess

  

DATA VIEW NAME

IR_LTOP_ONEM_SURVEY_STOUT

OVERVIEW 

Contains survey information about how students use their laptops in and out of the classroom

LOAD FREQUENCY

Data will be loaded annually.

DATA CUSTODIAN

Budget, Planning and Analysis – Meridith Wentz

AUTHORIZATION

You must receive approval to access data from the data custodian. For information about how to get authorized for InfoAccess data views, connect to InfoAccess Home Page

SPECIAL CONSIDERATIONS

  

QUESTIONS

Contact:  Division of Information Technology Help Desk
Phone:  264-HELP (4357)

LAST UPDATED

10/03 Data view created
12/03 Data Dictionary created

DATA FORMATS

Primary Key Columns are identified with an asterisk(*)

Alphanumeric Data

VARCHAR2( N)  (N) = maximum length. Field contains letters and/or numbers. Trailing blanks are eliminated.
Example: VARCHAR2 (5) could contain ‘ABC12’ or  ‘ABC’ or ‘A’

Numeric Data

NUMBER (N) (N) = length. Field contains only numbers.
NUMBER (X,Y) =  format for numbers with decimal positions.
X = total number of digits
Y = the number of digits after the decimal
Examples: NUMBER (6) represents 250012 NUMBER (6,2) represents 2500.12

Date

DATE  - Date can be in various formats. Date functions available with your query tool can be used to format the date. 
Examples:  DATE (YYYYMMDD), DATE (YYDDD), DATE (DD-MM-YY)

Column Name

Format

Description

*SEQ_NO

Number(15)

Sequential number generated as a key.

PERSON_ID

Varchar2(7)

Student ID number

YEAR

Varchar2(11)

Year survey was conducted

INCLASSUSE

Varchar2(1024)

How do you use your laptop inside of class?

Q1C1

Number(2)

Question One Coded to Numbers
0 = No response
1 = School wok
2 = In-class assignments/labs/quizzes
3 = Writing/revising papers
4 = Taking notes
5 = PowerPoint
6 = E-mail
7 = No in-class use/ little in-class use
8 = Instructors do not  require laptop use
9 = Negative comments
10 = Other
11 = Personal use/ entertainment
12 = Research/access web                 

Q1C2

Number(2)

Question One Coded to Numbers
0 = No response
1 = School wok
2 = In-class Assignments/labs/quizzes
3 = Writing/revising papers
4 = Taking notes
5 = PowerPoint
6 = E-mail
7 = No in-class use/little in-class use
8 = Instructors do not require laptop use
9 = Negative comments
10 = Other
11 = Personal use/entertainment
12 = Research/access web

Q1C3

Number(2)

Question One Coded to Numbers
0 = No response
1 = School wok
2 = In-class assignments/labs/quizzes
3 = Writing/revising papers
4 = Taking notes
5 = PowerPoint
6 = E-mail
7 = No in-class use/little in-class use
8 = Instructors do not require laptop use
9 = Negative comments
10 = Other
11 = Personal use/entertainment
12 = Research/access web

Q1C4

Number(2)

Question One Coded to Numbers
0 = No response
1 = School work
2 = In-class assignments/labs/quizzes
3 = Writing/revising papers
4 = Taking notes
5 = PowerPoint
6 = E-mail
7 = No in-class use/little in-class use
8 = Instructors do not require laptop use
9 = Negative comments
10 = Other
11 = Personal use/ entertainment
12 = Research/access web

Q1C5

Number(2)

Question One Coded to Numbers
0 = No response
1 = School work
2 = In-class assignments/labs/quizzes
3 = Writing/revising papers
4 = Taking notes
5 = PowerPoint
6 = E-mail
7 = No in-class use/little in-class use
8 = Instructors do not require laptop use
9 = Negative comments
10 = Other
11 = Personal use/entertainment
12 = Research/access web

OUTOFCLASSUSE

Varchar2(1024)

How do you use you laptop outside of class?

Q2C1

Number(2)

Question Two Coded to Numbers
0 = No response
1 = Schoolwork
2 = Research tool/access web
3 = Personal use/entertainment
4 = E-mail/keeping in touch
5 = Negative comments
6 = Other
7 = Do not use it
8 = Organizational tool
9 = Learning tool
10 = Keeping up with campus events

Q2C2

Number(2)

Question Two Coded to Numbers
0 = No response
1 = Schoolwork
2 = Research tool/access web
3 = Personal use/entertainment
4 = E-mail/keeping in touch
5 = Negative comments
6 = Other
7 = Do not use it
8 = Organizational tool
9 = Learning tool
10 = Keeping up with campus events

Q2C3

Number(2)

Question Two Coded to Numbers
0 = No response
1 = Schoolwork
2 = Research tool/access web
3 = Personal use/entertainment
4 = E-mail/keeping in touch
5 = Negative comments
6 = Other
7 = Do not use it
8 = Organizational tool
9 = Learning tool
10 = Keeping up with campus events

Q2C4

Number(2)

Question Two Coded to Numbers
0 = No response
1 = Schoolwork
2 = Research tool/access web
3 = Personal use/entertainment
4 = E-mail/keeping in touch
5 = Negative comments
6 = Other
7 = Do not use it
8 = Organizational tool
9 = Learning tool
10 = Keeping up with campus events     

Q2C5

Number(2)

Question Two Coded to Numbers
0 = No response
1 = Schoolwork
2 = Research tool/access web
3 = Personal use/entertainment
4 = E-mail/keeping in touch
5 = Negative comments
6 = Other
7 = Do not use it
8 = Organizational tool
9 = Learning tool
10 = Keeping up with campus events

LAST UPDATE DATE TIME

Date

The date and time the data was last updated.
Format : YYYYMMDD HH24:MI:SS