|
InfoAccess |
|
|
DATA VIEW NAME |
IR_LTOP_PROF_SURVEY_STOUT |
|
OVERVIEW |
This table shows data from the Microsoft Office Proficiency Survey given to all new e-Scholar students before they start classes at UW-Stout. The survey assesses student proficiency with Microsoft Word, Excel, PowerPoint and e-mail. |
|
LOAD FREQUENCY |
The data is loaded annually in the fall |
|
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 |
<Are there any special considerations? > |
|
QUESTIONS |
Contact: Division of Information Technology Help Desk Phone: (608) 264-HELP (4357) |
|
LAST UPDATED |
10/03 Data view 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 |
|||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
|
YEAR |
Number (4) |
Year survey conducted |
|||||||||
|
PERSONID |
Number (7) |
Student id number |
|||||||||
|
P DELETESL |
Number (1) |
Delete slides (PowerPoint)
|
|||||||||
|
P CRETESLI |
Number (1) |
Create a specified type of slide (PowerPoint)
|
|||||||||
|
P CRATEPRE |
Number (1) |
Create a presentation from a template and/or a wizard (PowerPoint)
|
|||||||||
|
P NAVIGATE |
Number (1) |
Navigate among different views (slide, outline, sorter, tri-pane) (PowerPoint)
|
|||||||||
|
P CRATENEW |
Number (1) |
Create a new presentation from existing slides (PowerPoint)
|
|||||||||
|
P COPYSLID |
Number (1) |
Copy a slide from one presentation into another (PowerPoint)
|
|||||||||
|
P HEADER |
Number (1) |
Insert headers and footers (PowerPoint)
|
|||||||||
|
P CRATEBLA |
Number (1) |
Create a Blank presentation (PowerPoint)
|
|||||||||
|
P AUTOCONT |
Number (1) |
Create a presentation using the AutoContent Wizard (PowerPoint)
|
|||||||||
|
P CHANGORD |
Number (1) |
Change the order of slides using Slide Sorter view (PowerPoint)
|
|||||||||
|
P FINDTEXT |
Number (1) |
Find and replace text (PowerPoint)
|
|||||||||
|
P CHANGLAY |
Number (1) |
Change the layout for one or more slides (PowerPoint)
|
|||||||||
|
P MODFYSLI |
Number (1) |
Modify slide sequence in the outline pane (PowerPoint)
|
|||||||||
|
P APLYDESI |
Number (1) |
Apply a design template (PowerPoint)
|
|||||||||
|
P SPELLING |
Number (1) |
Check spelling (PowerPoint)
|
|||||||||
|
P REPLACET |
Number (1) |
Change and replace text fonts (individual slide and entire presentation) (PowerPoint)
|
|||||||||
|
P TRI_PANE |
Number (1) |
Enter text in tri-pane view (PowerPoint)
|
|||||||||
|
P IMPORTTE |
Number (1) |
Import text from Microsoft® Word (PowerPoint)
|
|||||||||
|
P TEXTALIG |
Number (1) |
Change the text alignment (PowerPoint)
|
|||||||||
|
P CRATETEX |
Number (1) |
Create a text box for entering text (PowerPoint)
|
|||||||||
|
P USEWRAP |
Number (1) |
Use the Wrap text in TextBox feature (PowerPoint)
|
|||||||||
|
P USEOFFIC |
Number (1) |
Use the Office Clipboard (PowerPoint)
|
|||||||||
|
P PROMOTE |
Number (1) |
Promote and Demote text in slide and outline panes (PowerPoint)
|
|||||||||
|
P PICTURE |
Number (1) |
Add a picture from the ClipArt Gallery (PowerPoint)
|
|||||||||
|
P GROUPSHA |
Number (1) |
Add and group shapes using WordArt or the Drawing Toolbar (PowerPoint)
|
|||||||||
|
P APLYFORM |
Number (1) |
Apply formatting (PowerPoint)
|
|||||||||
|
P ADDTEXT |
Number (1) |
Add text to a graphic object using a text box (PowerPoint)
|
|||||||||
|
P SCALE |
Number (1) |
Scale and size an object including ClipArt (PowerPoint)
|
|||||||||
|
P CRATETAB |
Number (1) |
Create tables within PowerPoint (PowerPoint)
|
|||||||||
|
P ROTATE |
Number (1) |
Rotate and fill an object (PowerPoint)
|
|||||||||
|
P AUTONUMB |
Number (1) |
Add AutoNumber bullets (PowerPoint)
|
|||||||||
|
P SPEAKNOT |
Number (1) |
Add speaker notes (PowerPoint)
|
|||||||||
|
P ADDGRAPH |
Number (1) |
Add graphical bullets (PowerPoint)
|
|||||||||
|
P TRANSITI |
Number (1) |
Add slide transitions (PowerPoint)
|
|||||||||
|
P ANIMATE |
Number (1) |
Animate text and objects (PowerPoint)
|
|||||||||
|
P PREVIEW |
Number (1) |
Preview presentation in black and white (PowerPoint)
|
|||||||||
|
P PRNTSLID |
Number (1) |
Print slides in a variety of formats (PowerPoint)
|
|||||||||
|
P PRNTHAND |
Number (1) |
Print audience handouts (PowerPoint)
|
|||||||||
|
P PRNTNOTE |
Number (1) |
Print speaker notes in a specified format (PowerPoint)
|
|||||||||
|
P STARTSHO |
Number (1) |
Start a slide show on any slide (PowerPoint)
|
|||||||||
|
P ONSCREEN |
Number (1) |
Use on screen navigation tools (PowerPoint)
|
|||||||||
|
P TRANSPAR |
Number (1) |
Print a slide as an overhead transparency (PowerPoint)
|
|||||||||
|
P USEPEN |
Number (1) |
Use the pen during a presentation (PowerPoint)
|
|||||||||
|
P SAVECHAN |
Number (1) |
Save changes to a presentation (PowerPoint)
|
|||||||||
|
P SAVENEW |
Number (1) |
Save as a new presentation (PowerPoint)
|
|||||||||
|
P ASSISTAN |
Number (1) |
Use Office Assistant (PowerPoint)
|
|||||||||
|
P HYPERLIN |
Number (1) |
Insert hyperlink (PowerPoint)
|
|||||||||
|
P COMMENTS |
Number (1024) |
Additional Comments |
|||||||||
|
P PROFICEN |
Number (8) |
Over all Proficiency in (PowerPoint) |
|||||||||
|
P DATE TIME TAKEN |
Date (19) |
Date and time PowerPoint Proficiency Survey was taken. |
|||||||||
|
X USEUNDO |
Number (1) |
Use Undo and Redo
|
|||||||||
|
X CLEARCON |
Number (1) |
Clear cell content
|
|||||||||
|
X ENTERTEX |
Number (1) |
Enter text, dates, and numbers
|
|||||||||
|
X EDITCELL |
Number (1) |
Edit cell content
|
|||||||||
|
X GO_TO |
Number (1) |
Go to a specific cell
|
|||||||||
|
X INSERTCE |
Number (1) |
Insert and delete selected cells
|
|||||||||
|
X CUT_COPY |
Number (1) |
Cut, copy, paste special and move selected cells
|
|||||||||
|
X USEOFFIC |
Number (1) |
Use the Office Clipboard
|
|||||||||
|
X USE_FIND |
Number (1) |
Use Find and Replace
|
|||||||||
|
X CLEARFOR |
Number (1) |
Clear cell formats
|
|||||||||
|
X HYPERLIN |
Number (1) |
Create hyperlinks
|
|||||||||
|
X TEMPLATE |
Number (1) |
Use templates to create a new workbook
|
|||||||||
|
X SAVE_WEB |
Number (1) |
Save a worksheet/workbook as a Web Page
|
|||||||||
|
X APLYFONT |
Number (1) |
Apply font styles(typeface, size, color, and styles)
|
|||||||||
|
X APLYNUM |
Number (1) |
Apply number formats (currency, percent, dates, and commas)
|
|||||||||
|
X MODFYSIZ |
Number (1) |
Modify size of rows and columns
|
|||||||||
|
X MODFYALI |
Number (1) |
Modify alignment of cell content
|
|||||||||
|
X ADJUSTED |
Number (1) |
Adjust the decimal place
|
|||||||||
|
X BORDER |
Number (1) |
Apply cell borders and shading
|
|||||||||
|
X MERGE |
Number (1) |
Merging cells
|
|||||||||
|
X ROTATE |
Number (1) |
Rotate text and change indents
|
|||||||||
|
X DEFINE |
Number (1) |
Define, apply, and remove a style
|
|||||||||
|
X PREVIEW |
Number (1) |
Preview and print worksheets and workbooks
|
|||||||||
|
X PRINT |
Number (1) |
Print a selection
|
|||||||||
|
X CHNGPAGE |
Number (1) |
Change page orientation and scaling
|
|||||||||
|
X MARGINS |
Number (1) |
Set page margins and centering
|
|||||||||
|
X PAGEBRAK |
Number (1) |
Insert and remove a page break
|
|||||||||
|
X SETPRINT |
Number (1) |
Set print, and clear a print area
|
|||||||||
|
X HEADERS |
Number (1) |
Set up headers and footers
|
|||||||||
|
X PRINTTIT |
Number (1) |
Set print titles and options (gridlines, print quality, row & column headings)
|
|||||||||
|
X INSERTRO |
Number (1) |
Insert and delete rows and columns
|
|||||||||
|
X ZOOM |
Number (1) |
Change the zoom setting
|
|||||||||
|
X MOVEWORK |
Number (1) |
Move between worksheets in a workbook
|
|||||||||
|
X SPELLING |
Number (1) |
Check spelling
|
|||||||||
|
X RENAME |
Number (1) |
Rename a worksheet
|
|||||||||
|
X INSERTWO |
Number (1) |
Insert and Delete worksheets
|
|||||||||
|
X COPYWORK |
Number (1) |
Move and copy worksheets
|
|||||||||
|
X LINKWORK |
Number (1) |
Link worksheets & consolidate data using 3D References
|
|||||||||
|
X ENTERRAN |
Number (1) |
Enter a range within a formula by dragging
|
|||||||||
|
X ENTERFOR |
Number (1) |
Enter formulas in a cell and use the formula bar
|
|||||||||
|
X REVISEFO |
Number (1) |
Revise formulas
|
|||||||||
|
X USEREFER |
Number (1) |
Use references (absolute and relative)
|
|||||||||
|
X AUTOSUM |
Number (1) |
Use AutoSum
|
|||||||||
|
X PASTE |
Number (1) |
Use Paste Function to insert a function
|
|||||||||
|
X BASICFUN |
Number (1) |
Use basic functions (AVERAGE, SUM, COUNT, MIN, and MAX)
|
|||||||||
|
X DATEFUNC |
Number (1) |
Use date functions (NOW and DATE)
|
|||||||||
|
X FINANCIA |
Number (1) |
Use financial functions (FV and PMT)
|
|||||||||
|
X LOGICAL |
Number (1) |
Use logical functions (IF)
|
|||||||||
|
X PRINTCHA |
Number (1) |
Preview and print charts
|
|||||||||
|
X CHARTWIZ |
Number (1) |
Use the Chart Wizard to create a chart
|
|||||||||
|
X MODFYCHA |
Number (1) |
Modify charts
|
|||||||||
|
X OBJECT |
Number (1) |
Insert, move and delete an object (picture)
|
|||||||||
|
X CREATE |
Number (1) |
Create and modify lines and objects
|
|||||||||
|
X COMMENTS |
Char (1023) |
Additional Comments | |||||||||
|
X PROFICEN |
Number (1) |
Over all Proficiency in Excel
|
|||||||||
|
X DATE TIME TAKEN |
Date (19) |
Date and time Excel Proficiency Survey was taken. |
|||||||||
|
W USEUNDO |
Number (1) |
Use the Undo, Redo, and Repeat command
|
|||||||||
|
W APLYFONT |
Number (1) |
Apply font formats (Bold, Italic and Underline)
|
|||||||||
|
W USESPELL |
Number (1) |
Use the Spelling feature
|
|||||||||
|
W USETHEAS |
Number (1) |
Use the Thesaurus feature
|
|||||||||
|
W PAGEBRAK |
Number (1) |
Insert page breaks
|
|||||||||
|
W HIGHLIGH |
Number (1) |
Highlight text in document
|
|||||||||
|
W INSERTTE |
Number (1) |
Insert and move text
|
|||||||||
|
W CUTCOPY |
Number (1) |
Cut, Copy, Paste, and Paste Special using the Office Clipboard
|
|||||||||
|
W SELECT |
Number (1) |
Select and change font and font size
|
|||||||||
|
W FINDTEXT |
Number (1) |
Find and replace text
|
|||||||||
|
W APLYCHAR |
Number (1) |
Apply character effects (Superscript, Subscript, Strikethrough, Small Caps and Outline)
|
|||||||||
|
W INSERTDA |
Number (1) |
Insert date and time
|
|||||||||
|
W INSERTSY |
Number (1) |
Insert symbols
|
|||||||||
|
W ALIGNTEX |
Number (1) |
Align text in paragraphs (Center, Left, Right and Justified)
|
|||||||||
|
W ADDBULLE |
Number (1) |
Add bullets and numbering
|
|||||||||
|
W SETCHARA |
Number (1) |
Set character, line, and paragraph spacing options
|
|||||||||
|
W USEINDEN |
Number (1) |
Use indentation options (Left, Right, First Line and Hanging Indent)
|
|||||||||
|
W USETAB |
Number (1) |
Use Tabs command (Center, Decimal, Left and Right)
|
|||||||||
|
W CRATEOUT |
Number (1) |
Create an outline style numbered list
|
|||||||||
|
W SETTAB |
Number (1) |
Set tabs with leaders
|
|||||||||
|
W PRINT |
Number (1) |
Print a document
|
|||||||||
|
W PRNTPREV |
Number (1) |
Use print preview
|
|||||||||
|
W NAVIGATE |
Number (1) |
Navigate through a document
|
|||||||||
|
W INSERTNU |
Number (1) |
Insert page numbers
|
|||||||||
|
W SETPAGE |
Number (1) |
Set page orientation
|
|||||||||
|
W SETMARGI |
Number (1) |
Set margins
|
|||||||||
|
W PAGENUMB |
Number (1) |
Create and modify page numbers
|
|||||||||
|
W HEADER |
Number (1) |
Create and modify headers and footers
|
|||||||||
|
W ALIGNVER |
Number (1) |
Align text vertically
|
|||||||||
|
W NEWSPAPE |
Number (1) |
Create and use newspaper columns
|
|||||||||
|
W REVISE |
Number (1) |
Revise column structure
|
|||||||||
|
W APLYSTY |
Number (1) |
Apply styles
|
|||||||||
|
W CRATESEC |
Number (1) |
Create sections with formatting that differs from other sections
|
|||||||||
|
W CLICKTYP |
Number (1) |
Use Click & Type
|
|||||||||
|
W SAVE |
Number (1) |
Use save
|
|||||||||
|
W OPEN |
Number (1) |
Locate and open an existing document
|
|||||||||
|
W SAVE_AS |
Number (1) |
Use Save As (different name, location or format)
|
|||||||||
|
W CRATEFOL |
Number (1) |
Create a folder
|
|||||||||
|
W CREATENEW |
Number (1) |
Create a new document using a Wizard
|
|||||||||
|
W SAVEWEB |
Number (1) |
Save as Web Page
|
|||||||||
|
W USETEMPL |
Number (1) |
Use templates to create a new document
|
|||||||||
|
W HYPERLIN |
Number (1) |
Create Hyperlinks
|
|||||||||
|
W USEOFFC |
Number (1) |
Use the Office Assistant
|
|||||||||
|
W EMAIL |
Number (1) |
Send a Word document via e-mail
|
|||||||||
|
W TABLES |
Number (1) |
Create and format tables
|
|||||||||
|
W BORDERS |
Number (1) |
Add borders and shading to tables
|
|||||||||
|
W REVISETA |
Number (1) |
Revise tables (insert and delete rows and columns, change cell formats)
|
|||||||||
|
W MODFYTAB |
Number (1) |
Modify table structure (merge cells, change height and width)
|
|||||||||
|
W DRAWING |
Number (1) |
Use the drawing toolbar
|
|||||||||
|
W INSERTGR |
Number (1) |
Insert graphics into a document (WordArt, ClipArt, Images)
|
|||||||||
|
W COMMENTS |
Char (1023) |
Additional Comments |
|||||||||
|
W PROFICEN |
Number (8) |
Over all Proficiency in Word
|
|||||||||
|
W PROFCAT |
Number (8) |
Proficiency Category
|
|||||||||
|
W DATE TIME TAKEN |
Date(19) |
Date and time Word Proficiency Survey was taken. |
|||||||||
|
E OPENNEW |
Number (1) |
Open a new email message
|
|||||||||
|
E IDENTIFY |
Number (1) |
Identify a proper email address
|
|||||||||
|
E ADDRESS |
Number (1) |
Know where the email address line is
|
|||||||||
|
E SUBJECT |
Number (1) |
Know what the subject line is
|
|||||||||
|
E ATTACH |
Number (1) |
How to attach a file to an email message
|
|||||||||
|
E SEND |
Number (1) |
How to send email
|
|||||||||
|
E DELETE |
Number (1) |
How to delete an email
|
|||||||||
|
E SAVE |
Number (1) |
How to save an email
|
|||||||||
|
E OPENSAVE |
Number (1) |
How to open and save an attachment
|
|||||||||
|
E CURRENT |
Number (1) |
What email program do you currently use
|
|||||||||
|
E COMMENTS |
Char (1023) |
Additional Comments |
|||||||||
|
E PROFICEN |
Number (8) |
Overall Proficiency in Email
|
|||||||||
|
E DATE TIME TAKEN |
Date (19) |
Date and time Email Proficiency Survey was taken. |
|||||||||
|
LAST UPDATE DATE TIME |
Date (19) |
Date and time of last update |