| REQUIRED COMPUTER SKILLS
The Humphrey Institute Curriculum Committee has determined that it is essential for all Humphrey students to have a basic level of computer skills to do well in their Humphrey Institute studies and future career. To assess your skills, please review the Fundamental Computer Skills list below. If you do not feel that you have the basic knowledge of Windows, Word and Excel as described in the list, we suggest you take advantage of the resources list below prior to the start of fall classes:
- Before and immediately after Orientation, refresher courses are being offered in Excel Fundamentals and Excel Intermediate. The registration information will be sent out later this summer.
- The University Technology Training Center offers computer short courses and tutorials: http://uttc.umn.edu/training/
Fundamental Computer Skills for Windows, Word and Excel:
WINDOWS, do you know how to:
- Copy and Move files to a network drive
- Differentiate between the copy and cut commands
- Differentiate between inactive and active commands on a drop-down menu
- Identify a main directory (folder), subdirectory (subfolder), and a file
- Find a file using wildcard characters
- Arrange, rename, and delete folders and files
- Identify the local drive and a network drive
- Identify windows buttons - maximize, minimize, restore, close
- Define the Recycle Bin, Taskbar, shortcuts, Windows Explorer, hardware, software, Shut Down process, screen tips, toolbar, object, Desktop, scroll bar
- Select and open objects
- Tile and Cascade windows
WORD, do you know how to:
- Define word processing software
- Identify a word processing file
- Open a file from a network drive, hard drive, etc
- Save a file to a network drive, hard drive, etc.
- Differentiate between Save and Save As
- Insert the contents of file "x.doc" at the end of file "y.doc"
- Find, replace, select, align, copy, paste, move, bold, italicize, underline text
- Insert a graphic
- Differentiate between a bulleted and numbered list
- Create a table with specified number of rows and columns
- Set tabs (right, center, left, etc.), indents, margins, and hard page breaks
- Insert page numbers, headers, and footers
- Change font type and font size
- Use online Help, SpellCheck, Thesaurus, and Print Preview
- Undo and Redo an action
- Navigate in a document
- Identify buttons and the insertion point
- Define the clipboard and Format Painter
- Differentiate between copy and cut
EXCEL, do you know how to:
- Define spreadsheet software
- Identify a spreadsheet file
- Use the lookup function
- Use at least four basic formulas or functions
- Define and start a formula and function
- Resize and insert columns and rows
- Hide and unhide columns and rows
- Create, change, and format charts to analyze data (example: make a chart that shows the macroeconomic indicators over time
- Rename a worksheet
- Edit cell contents, including wrapping text within cells
- Apply text and number formatting (i.e. currency, percentage, etc.)
- Copy and move cell contents
- Define and use Autofill and AutoFit
- Define the difference between absolute and relative cell referencing
- Define a cell, row, column, worksheet, workbook, cell address, order of precedence, and range of cells
- Define what the letters across the top and the numbers down the left side are used for
- Freeze panes
- Use Page Setup, (example: set up a worksheet to print on one page
- Sort and filter data
Your adviser can give you more specific advice regarding the level of Excel knowledge (fundamental or intermediate) needed for your degree program.
We hope the list above helps you to assess your current level of knowledge and determine if and where you could use some additional instruction.
|
