Student Learning Outcomes

Spring 2006
CIS100
Introduction to Computer Applications

The Union County College Mission and Philosophy (page 206 of UCC's 2005-2007 Catalog):

The College strives to promote in students a sense of responsibility for their own development and an understanding of their obligations as members of a democratic society. The college fosters in students the desire to learn, the ability to think clearly and express themselves effectively, the habit of analytical and reflective thought, and awareness of themselves, their heritage, other cultures, and their environment.

Thus, assignments are constructed to improve and assessment is designed to measure the improvement in a student's:

	Desire to learn
	Ability to think clearly
	Ability to express themselves effectively
	Habit of analytical and reflective thought

Goal I (page 206 of UCC's 2005-2007 Catalog), which is to provide relevant general education courses for all students, objectives of enabling students to develop:

	critical thinking and problems solving skills
	the ability to use modern technology
	the ability to become self-directed learners

are directly addressed.

After completing CIS100 - Introduction to Computer Applications the student should be able to:

Select the appropriate software application or suite of applications (word processing, spreadsheet, database, presentation or internet) to apply to a problem

Use the basic features of Windows Operating System and Computer Application software.
Specifically be able to use the most common computer application software

	Computer Concepts and vocabulary
	Microsoft Windows for File access
	Microsoft Word for Word Processing
	Microsoft Excel for Spreadsheet and Charting
	Microsoft Access for Database
	Microsoft PowerPoint for Presentation
	Microsoft Internet Explorer for Internet

Locate and use sufficient and appropriate resources to learn how to apply computer application software features specifically using the software's help facility and online tutorials and reference.

Use instructional resources to solve problems

Understand of basic computer vocabulary and technology or know where to lookup definitions

Analyze a problems and then select the appropriate features of the software required to solve the problem

Follow instructions precisely when using computer software features

Understand that computers only follow instructions and if given incorrect instructions will follow them producing invalid result and thus all work must be proofed.

Communicate results on paper and on the internet in a highly useable format.

Word Processing Student Learning Outcomes: (click anywhere on this line to expand/collapse detail)

After completing the 3 word processing assignments, the student will have shown that they are able to:

Create professional looking document using Microsoft Word including use of the following features:

Ribbon

Help, UNDO

Enter, Edit, Move vs. Copy (cut & paste, drag & drop) text and images

Save, Retrieve (find) Documents

Preview and Print Documents

Headers & Footers with auto date and page numbers

Page Setup - Margins, Orientation

Speller, Thesaurus, Find/Replace

Symbols for foreign characters and non-break spaces

Format Characters using toolbar and Format menu (Bold, Italic, Underline, Size, Typeface, Color, Highlight)

Borders & Shading

Bullets & Numbers

Formatting Paragraphs (Inheritance, Alignment, Indents, Leading, Keep Together)

Indent on the Ruler and Paragraph dialog box: Right, Left, First line, Hanging head

Tabs: Insert, move, remove, change position and type (left, right, center, decimal)

Manipulate Clip Art: insert, size, crop, position, obtain from Internet

Add, edit, move Footnotes

Tables (Insert, Delete Size, Format, rows and columns, Merge cells)

(Optional) Mail Merge (create, modify, selectively print)

	Form Letter
	Data Document

Database Student Learning Outcomes: (click anywhere on this line to expand/collapse detail)

After completing the database assignment the student will have shown that they are able to:

Create a Microsoft Access database that includes use of the following features:

	design a table using the table wizard and then use design view to add, delete or reorder fields and to modify their type or length.
	enter data and navigate in both datasheet and form view
	create a form using the form wizard
	understand the difference between form design and form entry and what is entered/modified with each
	modify the format of forms (change field sizes, change label and field appearance: colors, borders and effects)
	create a report using the wizard that groups data with subtotals

Spreadsheet/Excel Student Learning Outcomes: (click on this line to expand/collapse detail)

After completing the spreadsheet with charts assignments the student will have shown that they are able to:

Create a professional looking spreadsheet using Microsoft Excel including use of the following features:

Moving around the sheet

Entering and Editing Values

Formatting Cells: ($ % , Alt+Enter for multi-line headings)

Creating formulas with addition(=), subtraction (-), Multiplication, division and combination of these which require use of ()

Copying cells and lists

Naming Cells, Relative and Absolute reference

Printing

Headers and Footers

Formula

Selected Areas only

Functions

SUM and AVG

PMT (payment) function

VLOOKUP function

IF function

Charting

Type: Pie, Bar, Column

Reasons to use each

Sizing, moving and formatting chart elements

Printing. See Print Hints

Understand the critical importance of always specifying formula rather than manually computing cell contents

Create a properly formatted sheet and backup formula documentation.

See how to and why one must manually check values

Presentation/PowerPoint Student Learning Outcomes: (click on this line to expand/collapse detail)

The student will be able to use current presentation software (Microsoft PowerPoint XP) to create and deliver a slide show with multiple slides exercising the use the following features:

Views: Slide, Sorter, Show

Themes including add ional themes found on the web

Words (formatting same as Word:
color, font, bullets, tables)

Images

	From the web
	Clip Art
	Drawing (oval, rectangle, Autoshapes, color, border)
	WordArt

Hyperlinks

Slide Show (Pen Color, Web)

Animation (Effects, Order, Sound)

Slide Transitions

Paper Handouts (name, date, grayscale)

Save a PowerPoint presentation for inclusion on a web site

Internet Student Learning Outcomes: (click anywhere on this line to expand/collapse detail)

By completing the Internet assignments students will have shown that they are able to:

Explain the components of the Internet and how individuals use each

Use proper Netiquette

Understand the reason for and use Emoticons

Create proper Email messages that incorporate:

	Sending (to, cc bcc)
	Receiving (Reply, Reply All, Forward, Mark as new, Folder)
	Importance of subject
	Folders
	Signature
	Address Books
	Groups or Distribution Lists)

Use Internet Explorer Buttons

Use hyperlinks to browse

Use Search arguments to

Incorporate Text & Graphics into Word documents and PowerPoint presentations

Create a personal web site

Print and copy WWW info from IE