Spreadsheet Applications Syllabus
CT 183 - 3 Credit Hours
New for Fall 2007

Course Name:

Spreadsheet Applications

Instructor:

Georgia Lynn

Course Number:

CT 183

Office:

A129

Academic Year:

2007/2008

Phone:

870-338-6474
X 1129
   

Email:

glynn@pccua.edu
   

Office Hours:

8 a.m. – 3 p.m. except when in class (see office door)

Class Time & Place:

4 – 6:20 p.m., Room A110    

Prerequisites:

CT 114, MS 1023, or departmental approval    

Required Labs:

Rooms A110 & A107 are used for assignments not completed in class. Please note that Deep Freeze software is in effect in our labs, which means that all computers in those labs will be reset upon shut down each day.

Note:

Home computers with Excel 2007 may be used to do homework.

A110
Designated "Business Student Success Center"

Credit Hours:

3    

Clock Hours:

3    

Revision Date:

8/12/07    

 

COURSE DESCRIPTION:
This course teaches the necessary concepts and tasks to create and manipulate spreadsheets, charts, graphics with hyperlinks, reports, complex math functions, limited database manipulation.

EXPECTED LEARNING OUTCOME
Create spreadsheets to manipulate numeric data in preparation for personal, business, or the Internet
Develop a critical thinking approach in applying theory to application

INSTRUCTIONAL GOALS & OBJECTIVES:

Goals:
Demonstrate the ability to use computer technology.

Students will analyze, interpret, and evaluate data necessary to solve problems and support business decisions.

Course Objectives:

Upon completion of Project 1, students will be able to:
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
Upon completion of Project 2, students will be able to:
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.
Upon completion of Project 3, students will be able to:
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.
Use Goal seek.
Upon completion of Project 4, students will be able to:
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.
Upon completion of the Web Feature, students will be able to:
Save an Excel workbook as a Web page.
Publish an Excel workbook as a dynamic (interactive) Web page.
Upon completion of Project 5, students will be able to:
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.
Upon completion of Project 6, students will be able to:
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.

PCCUA CORE COMPETENCIES ADDRESSED IN THIS COURSE:

Technology Utilization
Critical Thinking

TEXT & OTHER MATERIALS:
Microsoft Excel 2007, Complete Concepts & Techniques, Shelly Cashman Quasney, 6 Projects (new text, new software)
Turning Point Clicker Technology (new fall) 2007
Pocket Folder
Flash Drive (256 MB)

Publisher:
Course Technology

GRADING POLICY: (new grading procedures)
Grades are based on the following criteria:

Learn It!

Clicker Quizzes

10%

Project Assignments (Student E-Mail)

20%

Expand It!

Extend Your Knowledge, Make It Right

20% (new exercises added with the new text)

Review It!

Case Problem

20%

Test It!

Objective testing (online) & Hands-On Exams

30%

 

GRADING SCALE:

 

90 - 100

A

 

 

 

 

80 - 89

B

 

 

 

 

70 - 79

C

 

 

 

 

60 - 69

D

 

 

 

 

Below 60

F

 

 

 


NEW “EARLY ALERT” & ATTENDANCE POLICY:

A new policy called “Early Alert” will be implemented this Fall. It is described below.  Please note that regular class attendance and punctuality are expected for success in this course. The instructor will call roll at the beginning of class and record those absent. 

First Absence:
Upon return to class, student will be given a blue card identifying the class missed, with any missed assignments attached. Discussion with student may follow.

Second Absence:
Instructor will use the college's referral system to generate a notice of the student's absence to the advisor and the student through student e-mail.

Third Absence:
A notice is sent to the advisor through the college’s referral system and the student via email. The advisor will refer the student to the Student Success Coordinator who intervenes at this point.  The student is considered “at risk” of losing college credit for this course.

Fourth Absence:
Student may be considered “excessively” absent and could be dropped from the class by the instructor.  An exception may be made by the instructor, after due consideration, upon the initiation of the STUDENT with the instructor. Factors considered are:
(1) student initiative and dependability with course work
(2) exceptional, sudden personal circumstances of the student
(3) transportation problems.
NOTE: No exceptions will be made for doctor’s appointments for self or children nor for court dates

 

EXCEPTION!!

Classes meting once a week, such as extended day or evening classes, will follow the same guidelines as above, except that upon the first absence, the student will be referred to the Student Success Coordinator and is considered "at risk".  Upon the second absence, the student may be considered “excessively” absent and dropped from the course with possible exceptions using the guidelines above.

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.


PARTICIPATION:
An essential component of any computer class is participation. Students are expected to take an active part in each class by preparing for each class by reading the text and being prepared for quizzes, actively listening, working along with instructor when asked, completing all text assignments, taking advantage of the training, review, etc offered in SAM.


COURSE EVALUATION & ASSESSMENT:
LEARN IT!
Component—project lab assignments, SAM Quizzes and/or other technological tools.
EXTEND IT! Component—case assignments and/or other critical thinking activities that challenge the student to think
REVIEW IT! Component—SAM and/or other technological tools
TEST IT! Component—SAM, other technological tools, and/or hands-on exams.

NOTE!! Check your student email every day!!!  Student email accounts will be widely used for informational purposes, for turning in assignments as instructed, for communicating with instructor, etc.

MISSED ASSIGNMENTS OR EXAMS: The instructor's Web Site (shown above) for this course will list all materials covered, the assignments given, along with due dates, and exam dates. 
When you know you will miss class ahead of time, let the instructor know and make arrangements to make up any missed work or exam. Assignments missed must be made up on your own time, not in class.
It is the student's responsibility to initiate and complete missed assignments by the next class meeting. Assignments will still be considered late if not turned in on the due date. Exams missed must be made up by seeing the instructor and making arrangements. The make-up exam will be more difficult than the exam taken in class.
LATE ASSIGNMENTS:
Assignments turned in late (not turned in by the end of the day of the due date) will suffer an automatic 10-point deduction per day late taken from the grade. Five days late will be an automatic 50-point deduction, which means a failing score before it is even graded.

STUDENT RESPONSIBILITIES:
If a student is unable to adhere to the attendance policy, or undue circumstances prevent the completion of the course, it is the student’s responsibility to withdraw from this class and receive a  W. Other student responsibilities are addressed in the section above concerning missed assignments or exams & late assignments.

CELL PHONES:
Cell phones have become a problem and therefore must be turned off in class.  The exception to this rule will be that the student may set the cell phone to vibrate only and must leave the class room to answer the phone if it is perceived to be an emergency.

Academic Honesty 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.      Represents the work of others as his own.
2.
      Uses or obtains unauthorized assistance in any academic work.
3.
      Gives unauthorized assistance to other students.
4.
      Modifies, without instructor approval, an examination, paper, record, or report for the purpose of obtaining additional credit.
5.
      Misrepresents 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 folder unless the instructor directs you to destroy them.
 

 

CAMPUS SUPPORT POLICIES:
PCCUA provides student support services that assist students in achieving their educational objective.  Those services include advising, financial aid, counseling and guidance, and safety and security.

 

ADA POLICY:
Lynn Boone, the Vice Chancellor for Student Services serves as the ADA Compliance Officer. If you reside in Arkansas County you may contact Vice Chancellor Carolyn Turner (DeWitt) or Dr. Susan Luebke (Stuttgart). The process of student referral under the Americans with Disabilities Act can be found in the Student Handbook.
 

FERPA POLICY:
Phillips Community College of the University of Arkansas complies with the Family Educational Rights and Privacy Act (FERPA) of 1974. A student has the right to inspect and review all of his/her records that meet the definition of educational records. No third party has the right to review student records. Directory information can be provided unless the student request that it be withheld.

INSURANCE:
PCCUA does NOT provide insurance for its students. The college does encourage each student to secure his/her own insurance, and for that reason, the college has contacted United Healthcare Student Resources. Forms for this insurance are available in the Registrar’s office.

ACTS:
The Arkansas Course Transfer System (ACTS) contains information about the transferability of courses within Arkansas Public Colleges and Universities. Students are guaranteed the transfer of applicable credits and the equitable treatment in the application of credits for the admission and degree requirements. Course transferability is not guaranteed for courses listed in ACTS as “No Comparable Course.” Additionally, courses with a “D” frequently do not transfer and institutional policies may vary. ACTS may be accessed on the internet by going to the ADHE Website and selecting Course Transfer.  Here is the link: http://acts.adhe.edu/secure/institutiontransferinfo.aspx

The syllabus and the policies, guidelines, and dates included are subject to change at the instructor’s discretion.