Objectives

CPSC 1105 Course Objectives
and
Exam Reviews

This page was last updated: 01/07/08

General Learning Objectives:

Students successfully completing this course will:

	gain knowledge of Technological Solutions and the Microsoft Office 2007 programs
	reinforce their knowledge of how to use Windows, Word, and PowerPoint
	learn how to use Excel, and Access
	be able to use these programs at a beginning and intermediate level to solve problems
	be able to locate, evaluate and use information using multiple sources including the Internet
	develop critical thinking and technical skills through study of texts and exams

In addition to the objectives listed below for Windows, Word, PowerPoint, Excel, and Access, you should be able to:

Navigate to the course Web site/access course information

With regard to e-mail:

	send/receive messages
	create a distribution list
	send/open attachments

With regard to CougarView (WebCT Vista):

	logon to the appropriate CougarView (WebCT Vista) course
	access discussion, upload assignments, send e-mail, download attachments

Use the search tools/procedures provided in Galileo/Gill

With regard to Windows (in a timed, simulated environment), you should be able to:

make a window active or inactive

maximize/minimize/move/resize/close a window

start Windows Explorer

create new folders, display folder contents, rename files, expand/collapse branch

With regard to Word (in a timed, simulated environment), you should be able to apply ribbon features that:

format text such bolding (and color)

copy/paste text

apply bullets/numbers

select all of the text using the Edit/Select all feature

set margins/orientation

open/save/print/close documents

open/close Word

display document in print preview

set tabs

apply undo/redo

apply Format Font “effects” such as strikethrough, etc.

insert clipart/page break/a table

set line spacing/first line and hanging indent

find/replace text

utilize Thesaurus/spell check/word count

view contents of clipboard

be familiar with various document Views such as Normal and Print Layout

utilize the Index feature of Word Help

format and edit text/paragraphs/photographs

open/save/print/close documents

set tabs/line spacing/first line and hanging indents

utilize templates, borders, font “effects,” sort/Thesaurus/spell check/word count

insert photos/clipart/page breaks/tables/headers/footnotes

find/replace text

view contents of clipboard

display document views

utilize the Index Word Help feature/manage hyperlinks/document properties

With regard to PowerPoint (in a timed, simulated environment), you should be able to refine a presentation:

open, view, edit, format, save, print a presentation

create headers/footers/tables, charts, add and format graphics

use slide sort, format slide elements

apply transitions/animation, reorganize presentation text

With regard to Excel (in a timed, simulated environment), you should be able to:

start new workbook

name, save, open, close a workbook

rename workbook/worksheet

enter/edit text in cells, align cell contents

display one or more worksheets in print preview

set print/page orientation, margins, center on page vertically or horizontally

add header/footer

print gridlines, set/clear print area, use various print preview options, i.e., zoom

apply undo/redo

delete cell contents/column/row/formatting

clear cell contents; copy to clipboard and paste from clipboard

delete information without saving to clipboard

move/copy sheet

apply find/replace/go to features

add/remove Excel toolbars

insert cell/row/column/worksheet/chart

work with Paste Function to insert date, perform calculations (such as sum and average) and other statistical information such as finding maximum and minimum

format cell with regard to number, alignment, font, border, pattern

format row/column/sheet with regard to width/height/hide/unhide

apply AutoCorrect, AutoComplete, AutoFormat, AutoSum

use AutoFill to create a series

utilize the AutoFit feature to automatically set column width

select the entire worksheet with a single action

navigate between worksheets; change color/font/pitch of text and objects

apply/remove split screen and freeze pane features

apply merge and center

With regard to Access (in a timed, simulated environment), you should be able to:

create new databases, tables, forms, reports, and queries

set data types

open/edit/modify databases including tables, forms, reports, and queries

set or edit field properties in a table

enter or edit data in datasheet view

navigate between and print in different views such as design or datasheet

use a calculated field in a query

establish “and/or” criteria in a query

establish validation rule and text

set the date using the Now function

establish a relationship between two tables and establish referential integrity

use the Wizard to create a form

sort a table on one or more fields

apply the find/replace command

define and set the primary key

set features such as orientation and margins

display document in print preview

With regard to OLE (Object Linking and Embedding; integration information), you should be able to:

Embedding/linking Excel charts and data

Linking Excel charts and graphic presentations

	make a window active or inactive
	maximize/minimize/move/resize/close a window
	start Windows Explorer
	create new folders, display folder contents, rename files, expand/collapse branch

	format text such bolding (and color)
	copy/paste text
	apply bullets/numbers
	select all of the text using the Edit/Select all feature
	set margins/orientation
	open/save/print/close documents
	open/close Word
	display document in print preview
	set tabs
	apply undo/redo
	apply Format Font “effects” such as strikethrough, etc.
	insert clipart/page break/a table
	set line spacing/first line and hanging indent
	find/replace text
	utilize Thesaurus/spell check/word count
	view contents of clipboard
	be familiar with various document Views such as Normal and Print Layout
	utilize the Index feature of Word Help
	format and edit text/paragraphs/photographs
	open/save/print/close documents
	set tabs/line spacing/first line and hanging indents
	utilize templates, borders, font “effects,” sort/Thesaurus/spell check/word count
	insert photos/clipart/page breaks/tables/headers/footnotes
	find/replace text
	view contents of clipboard
	display document views
	utilize the Index Word Help feature/manage hyperlinks/document properties

	open, view, edit, format, save, print a presentation
	create headers/footers/tables, charts, add and format graphics
	use slide sort, format slide elements
	apply transitions/animation, reorganize presentation text

	start new workbook
	name, save, open, close a workbook
	rename workbook/worksheet
	enter/edit text in cells, align cell contents
	display one or more worksheets in print preview
	set print/page orientation, margins, center on page vertically or horizontally
	add header/footer
	print gridlines, set/clear print area, use various print preview options, i.e., zoom
	apply undo/redo
	delete cell contents/column/row/formatting
	clear cell contents; copy to clipboard and paste from clipboard
	delete information without saving to clipboard
	move/copy sheet
	apply find/replace/go to features
	add/remove Excel toolbars
	insert cell/row/column/worksheet/chart
	work with Paste Function to insert date, perform calculations (such as sum and average) and other statistical information such as finding maximum and minimum
	format cell with regard to number, alignment, font, border, pattern
	format row/column/sheet with regard to width/height/hide/unhide
	apply AutoCorrect, AutoComplete, AutoFormat, AutoSum
	use AutoFill to create a series
	utilize the AutoFit feature to automatically set column width
	select the entire worksheet with a single action
	navigate between worksheets; change color/font/pitch of text and objects
	apply/remove split screen and freeze pane features
	apply merge and center

	create new databases, tables, forms, reports, and queries
	set data types
	open/edit/modify databases including tables, forms, reports, and queries
	set or edit field properties in a table
	enter or edit data in datasheet view
	navigate between and print in different views such as design or datasheet
	use a calculated field in a query
	establish “and/or” criteria in a query
	establish validation rule and text
	set the date using the Now function
	establish a relationship between two tables and establish referential integrity
	use the Wizard to create a form
	sort a table on one or more fields
	apply the find/replace command
	define and set the primary key
	set features such as orientation and margins
	display document in print preview

	Embedding/linking Excel charts and data
	Linking Excel charts and graphic presentations