Spreadsheets for CIS100 Introdction to Computer Application

Student Learning Outcomes:

See Course Learning Outcomes

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

Round 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

Check out the resources for help

Microsoft Excel Help (Help menu or F1)

Tutorials

Do the Spreadsheet Assignments

	UCC Campus/Major Enrollment (Begun In Class)
	Carpet Store Invoice (Begun In Class)
	Profit and Loss Statement (Begun In Class)
	Car Loan Payback (In Class)
	Payroll (Independent)
	Simplified Personal Income Tax Calculation (Extra Credit)

	Vacation planner(Extra Credit)

Use the Hints to verify correctness

Review with a fellow classmate (see Learning Pyramid- you learn the most when you teach others)

Level of attainment of the Student Learn Objectives will be assessed via

	Completion of the 4 or 5 spreadsheet begin in class and the spreadsheet developed independently per the rubrix with each. See checklist for factors that show mastery of spreadsheets
	A quiz where a spreadsheet using Excel features (functions, formatting, etc) is created
	A similar problem on the final exam