Prerequisites

None

Offered

Fall, Spring, Summer

Software

Windows 2000

Microsoft Office XP

Internet Explorer 5.5+

Credit By Exam

Yes

Coordinator

N. Evans

Back to Course Description

Computer Concepts

Define CPU
Define backup
Define RAM
Define antivirus software
Define computer hardware
Define application software
Define system software
Define a network
Define server
Define permanent storage
Explain the role of UITS (University Information Technology Service)
explain the role of CNC (Computer Network Center)
Use university email

Oncourse

Acquire a username and password
Navigate through Oncourse
Access course syllabus, schedule, and grade book
Access Oncourse announcements
Use Oncourse file manager
Use Oncourse mail
Attach files to Oncourse mail
Copy a shortcut for a file and paste into an email
Upload a file to drop box

Operating System (Windows and File Management)

Identify objects and icons on the Windows desktop
Open icons into windows
Identify common Windows components
Define a common user interface and explain why it is so important
Open multiple windows onto the Windows desktop
Use the taskbar to task switch between multiple open windows
Move and size windows
Format a diskette
Shut down the computer
Identify the root directory
Create folders and subfolders
Move, copy, delete and rename files and folders
Display file extensions
Search for files by file name and text within a file
Select multiple files or folders in one window
Use the recycle bin
Access files from diskette, zip disk, network drive, hard drive, or other pertinent storage device
Compress or zip and decompress or unzip files and folders
Use Windows Help

Word Processing

Identify the screen parts
Create a new document
Use word wrap
Use insert &overtype mode
Use undo &redo to reverse actions
Use spell check, thesaurus, and grammar check
Use autocorrect
Select text and objects
Find and replace text
Print documents and use print preview
Save, open and close a file
Format text using character formats such as bold, italic, underline, shading, borders, font, font size, bullets/numbering
Use the format painter to format text
Use paragraph formatting to set line spacing, left, right, hanging indents, and tab stops
Use Undo/Redo to reverse actions
Use spell check, thesaurus, and grammar check
Use page setup to change margins
Find and replace text
Move (cut & paste) text
Copy (copy & paste) text
Convert text to newspaper-style columns
Insert symbols
Insert clip art and pictures
Use the drawing toolbar
Download files from a website
Insert downloaded files into an application
Copy from internet to an application
Copy a url to an application and create a hyperlink
Cite Internet resources in observance of copyright laws and understand "fair use"
Save a file in html format
Insert a footnote
Format text using bulleted, numbered, and outline numbered lists
Use page setup to change page layout
Insert headers and footers with auto codes for file names, page numbers, dates, etc
Create and edit tables: insert and delete rows and columns, set table properties, merge & center a row
Insert page breaks and section breaks
Insert footnotes

Spreadsheets

Identify the screen parts
Provide worksheet documentation identifying the creator, date of creation, and purpose of spreadsheet
Navigate workbooks and worksheets using keyboard and mouse
Distinguish between workbooks and worksheets
Create and edit labels and values
Use arithmetic expressions (formulas)
Use functions: sum, average, min, max, today
Write a formula or function using cell address and no raw numbers
Use print and print preview commands
Change page setup to include gridlines, row and column headings, portrait or landscape, fit to 1 page, headers and footers
Change column and/or row width and height
Format cells for number, alignment, font, border and pattern, etc.
Write a formula or function using cell address and no raw numbers
Create an assumptions area for raw numbers so no raw numbers appear in formulas
Use relative and absolute references effectively
Use the fill handle to copy cells to adjacent area
Use the math order of operations to write percent-of-change formulas
Save Excel files in a different file format
Freeze and unfreeze window panes
Hide and unhide rows and columns
Use the function wizard to create an IF function with text responses
Use statistical function =max to find maximum value in a range
Use statistical function =min to find minimum value in a range
Use statistical function =average to find average value in a range
Merge and center text across a range of cells
Display formulas on the worksheet
Create a graph that could stand alone on its own if the spreadsheet were not present as supporting documentation
Create a graph using the chart wizard
Select spreadsheet data in adjacent and nonadjacent ranges
Use the column, line, pie or bar chart types
Move and size the graph
Edit a graph and change features such as line color, column style, background, etc.
Update spreadsheet numbers so it is reflected in the graph

Internet/World Wide Web

Use Internet Explorer as the browser in class
Use hyperlinks
Use favorites and history
Conduct Internet searches using search engines
Refine Internet searches using Boolean logic including the operators AND, OR, and NOT, plus (+) and minus (-)
Identify these abbreviations: isp, url, html, http, https, and www
Identify and evaluate reliable Internet resources for research
Locate resources for virus protection
Explain the differences between a web page, home page, website, and domain name
Download files from a website
Identify public domain sites
Explore copyright issues and understand "fair use"

Presentation Graphics

Identify PowerPoint screen parts
Use good design principles
Use slide, notes, outline, slide show, and dual pane views
Move, copy and delete slides
Promote and demote text
Create a new slide
Choose slide layouts
Change templates
Use multiple templates in a file
Print black and white, slides, handouts, notes, and outlines
Insert, create edit, format, move, delete and size objects including pictures and clip art
Use drawing toolbar
Align and group objects
Apply animation to text and objects
Apply transitions
Use good design principles
Cdit a slide master to make global changes to a presentation
Create and edit a PowerPoint table
Navigate a slide show
Import a Word outline
Save a file in web page format
Create headers and footers
Create a hyperlink to another file or an Internet website
Add speaker notes to the notes pages

Databases

Add, delete, move and edit fields and records in existing table and form objects
Navigate to and through existing table, form, query, and report objects
Create relationships between 2 existing tables, enforce referential integrity and cascade updates and deletes
Sort data in a table in both single and multiple columns
Filter by selection and form
Create a flat database known as one-table database
Create a table using the design view
Create a table using the wizard
Name tables and forms
Define field properties
Identify a primary key
Add a validation rule to enter data
Create an input mask to enter data
Create a form using the wizard
Edit the form layout in design view
Understand the difference between data and information
Create queries from one or more tables in a database
Create queries using design view
Create queries using the query wizard
Create queries with multiple criteria
Create queries using Boolean logic
Sort data in query
Filter data in a query
Create reports using the report wizard
Add headers and footers to a report
Name queries and reports
Get external data from an Excel spreadsheet
Convert the database to another format
Compact and repair a database

Integrating Applications

Copy material within and between applications
Link material within and between applications
Hyperlink material within and between applications
Copy a URL to an application
Downloading a graphic from the Internet and insert it into an application