Spreadsheet Applications
CT 183--3 Credit Hours
(old from Fall 2006)

3 Contact Hours Per Week

PREREQUISITE: CT 114, MS 1023, or departmental approval

TEXT: Microsoft Excel 2003, Complete Concepts and Techniques, Shelly, Cashman, Quasney, Course Technology, ITP, 2006. (old version)

MATERIALS REQUIRED:
SAM (Skills Assessment Manager) CD for Training and Testing (old requirement)
Jump Drive (256 MB)
Pocket Folder
SAM ProGrader (old requirements)

STUDENTS FOR WHOM THE COURSE IS INTENDED:

This course is designed for students who are seeking an Information Systems, Business Management, or Office Technology degree.

PURPOSE:

The purpose of this course is to use Microsoft Excel to train students in developing and using spreadsheets.

CATALOG COURSE DESCRIPTION:

This course will teach the necessary concepts and tasks to prepare the student for the MOS (Microsoft Office Specialist) core exam. Students will use “Microsoft Approved Courseware”.  Topics include creating and manipulating spreadsheets and charts,  formulas, functions, formatting, web queries, what-if analysis, goal seek, OLE activities, solver, input technologies, data tables, amortization schedules, large worksheets, multiple worksheets and workbooks, and creating templates. Fall semester.

ATTENDANCE POLICY:

Regular class attendance and punctuality are expected. The instructor will call roll at the beginning of class and record those absent. 

*COURSES MEETING TWO TIMES PER WEEK:
	Students are permitted four (4) absences.
	Warning notice sent at four (4) absences.

Regular class attendance and punctuality are expected.  When you know you will miss class ahead of time, let the instructor know and make arrangements to make up any missed work.  Assignments missed must be made up on your own time.  The instructor’s web site for this course will list all materials covered and the assignments given.  It is the student's responsibility to initiate and complete missed assignments.

The instructor will warn a student in danger of becoming excessively absent by sending a warning notice to the Advisement Center so that the student can be contacted by an advisor either by phone or in writing.  If the student is absent more than allowed by the instructor, 5 points will be deducted from the student’s final grade for each 2 absences over the permitted number.  Exceptions to this policy may be made at the instructor's discretion, depending on student initiative in contacting the instructor and keeping course work current.  The instructor may also drop the student from the class roll with a grade of EW by notifying the Office of Admissions in writing.

Academic Honesty Policy:
Cheating Policy
Students are expected to uphold the school’s standard of conduct relating to academic honesty.  Students assume full responsibility for the content and integrity of the academic work they submit.  The guiding principle of academic integrity shall be that a student’s submitted work, examinations, reports, and projects must be that of the student’s own work.  Students shall be guilty of violating the honor code if they:

1.      Represent the work of others as their own.
2.      Use or obtain unauthorized assistance in any academic work.
3.      Give unauthorized assistance to other students.
4.      Modify, without instructor approval, an examination, paper, record,   or report for the purpose of obtaining additional credit.
5.      Misrepresent the content of submitted work.

Administrative Procedure Number: 404.05
Cheating in any form (including using unauthorized materials, information, or study aids in any academic exercise; plagiarism; falsification of records; unauthorized possession of examinations; any and all other actions that may improperly affect the evaluation of a student's academic performance or achievement; and assisting others in any such act) is forbidden. An instructor who has proof that a student is guilty of cheating may take appropriate action up to and including assigning the student a grade of "F" for the course and suspending the student from class. A description of the incident and the action taken will be reported through the dean to the Vice Chancellor for Instruction and placed in the student's file in the Office of Admissions and Records.  The student may appeal either the finding of cheating or the penalty, or both, as described in Administrative Procedure No. 404.06, Academic Appeal Procedure.

Cheating in this class:
Cheating will not be tolerated.  If you are cheating on one occasion, you will receive an “F” for the whole project’s work (not limited to that one assignment)If found cheating on a second occasion, you will be asked to drop the class.  If the cheating occurs after the drop date, or if you choose not to drop, you will receive an “F” for this class.  All work must be on your disk or in your portfolio unless the instructor directs you to destroy them.

The Computer Labs, Rooms A107 and A110, are open daily from 7:30 a.m. until 4 p.m. and may be used during those hours unless there is a class going on in one of them.

(old requirements)
GRADES:

Grades are based on the following criteria:

Attendance

Learn It!

SAM Training

10%

Project Assignments (WebCT E-Mail)

20%

Expand It!

Cases & Places Assignment (WebCT E-Mail)

Review It!

SAM Project Task Practice

SAM Project Objective Practice

Test It!

SAM ProGrader Exam

GRADING SCALE:

90 - 100

80 - 89

70 - 79

60 - 69

Below 60 

• Demonstrate the ability to use computer technology

• Develop a critical thinking approach in applying theory to application.

• Start Excel, create, save, and print a worksheet, and quit Excel.
• Select and copy a cell or range of cells.
• Use the Name Box to select a cell.
• Enter text and numbers
• Use AutoSum  to sum a range of cells.
• Apply font changes (appearance, size, and color).
• Center cell contents across a series of columns.
• Apply AutoFormat to format a range

• Enter multiple lines of text in the same cell, a formula using the keyboard, formulas using Point mode
• Identify arithmetic operators +,-,*,/,%
• Recognize smart tags.
• Apply the AVERAGE, MAX, and MIN functions.
• Determine a percentage.
• Verify a formula using Range Finder.
• Color the background of a cell.
• Add borders to a range; Format numbers; Add conditional formatting to a range.
• Align text within a cell and change the width of a column and the height of a row.
• Check spelling, use print preview, and distinguish between portrait and landscape orientation.
• Print a partial or complete worksheet; also, learn to use Print to Fit.
• Use a Web query to get real-time data from a Web site.
• Rename sheets.
• E-Mail active workbook from within Excel.

• Rotate text in a cell; create a series of month names.
• Use Format Painter to format cells, copy and paste, insert and delete cells.
• Use Smart Tags.
• Freeze titles, display and format the system date.
• Use and copy absolute cell references in a formula as opposed to the default relative reference when copying formulas.
• Use the IF function to perform a logical test within a formula.
• Create a 3-D Pie chart based on a worksheet.
• Rearrange sheets in a workbook.
• Preview and print multiple sheets.
• Use Excel to answer What-if questions.
• Goal seek.

• Assign a name to a cell and refer to the cell in a formula with that assigned name.
• Determine the monthly payment of a loan using the financial function PMT.
• Create a data table to analyze data in a worksheet.
• Add a pointer to a data table.
• Create an amortization schedule.
• Determine a present value of a loan using the PV function.
• Analyze worksheet data by changing values (what if analysis).
• Add a hyperlink to a worksheet element.
• Use names and the Set Print Area command to print sections of a worksheet.
• Set print options.
• Protect and unprotect cells in a worksheet.
• Use the formula checking features of Excel.

• Save an Excel workbook as a Web page.
• Publish an Excel workbook as a dynamic (interactive) Web page.

• Create, sort, and Query a worksheet database
• Display automatic subtotals
• Use VLOOKUP Function
• Use a data form to enter, view and change records
• Use Database functions.

• Create templates and work with Multiple worksheets and workbooks
• Create a workbook from a template
• Use WordArt
• Use the Drawing Toolbar
• Insert Comments
• Use Print Options
• Use Find and Replace
• Consolidate data by Linking Workbooks.