Accounting 6
Spreadsheets for Accounting

INSTRUCTOR Cheryl Furbee
Spring 2008


Tentative Schedule

Acctg Publisher's Website

COURSE DESCRIPTION
An introduction to the creation, evaluation, and use of electronic spreadsheets. Includes spreadsheet design, management, formulas, functions, and charts. Emphasis will be placed on the effective analysis and presentation of accounting data. It is assumed that you have completed either BUS 5 (Business Information Systems) or CABT 41 (Excel for Windows) or have basic knowledge of how to use spreadsheets.

TEXTBOOKS AND SUPPLIES


1. TEXTS
   1. College Accounting, 11th Edition, Chapters 1-32, Price, Haddock, and Brock, ISBN 0-07-322936-9 (this includes the Annual Report) or ISBN 0-07-3029920 OR same text, 10th Edition
   2. Optional - Excel 2003, Comprehensive, A Professional Approach, Kathleen Stewart and Deborah Hinkle, McGraw Hill (ISBN = 0-07-225448-3), Microsoft Office Excel 2007, Kathleen Stewart (ISBN = 0-07-351921-9), or Go! with Microsoft Excel 2007, Volume 1, Gaskin, Preston and Vargas (ISBN = 0-13-512986-9). These texts can be used for reference but are not required. Any other reference book you like, can be substituted.
2. Hand-held calculator
3. User Name and Password in the Computer Technology Center OR off-campus access to the internet and to Excel
4. Print Card, if using the Computer Technology Center

COURSE REQUIREMENTS AND GRADING
Excel is the spreadsheet program of choice for Santa Cruz employers. The texts provide data files for either Excel 2003 or 2007; you can use either version you have available to complete the assignments. The Computer Technology Center, has both versions. Instructor created videos will demonstrate the 2007 version.

Communication:
Blackboard will be used for communication. It is required that you log on the website at LEAST twice a week and participate in discussions and questions. It is also the site where you will complete the online quizzes. Lack of participation may result in being denied access to Blackboard.

Homework:
College Accounting text:

Certain chapters in the College Accounting text will be discussed. Selected exercises and/or problems will be assigned and must be completed using Excel. Some will be revised to allow the use of special Excel functions. Be sure to make these revisions. Complete the assigned exercises/problems using an interactive spreadsheet. Submit your solutions via the Blackboard assignment tool. These must be completed using Excel (MS Works will NOT work. If you are using a Mac, be sure to save it so I can open it with a PC).

Excel text:

An Excel text is totally optional. They are available at online bookstores. You should complete as many of the exercises and application problems as you need to learn to use the program. Some of you have a great deal of experience with spreadsheets while others will have to spend more time learning the applications. Therefore, no specific exercises will be assigned or collected. The purpose is to LEARN to use the program. Please don't short change yourself by not completing as many exercises as you need to improve your knowledge of this exciting program. Any resource text can be used.

Quizzes:
There will be a quiz for each chapter covered in College Accounting. These quizzes will be completed online via Blackboard. You will be given a five-day "window of opportunity" to complete the quizzes (12:01 a.m.Thursday through 11:59 p.m. Monday). There will be no make up of a quiz so be sure to plan your schedule.

Grading:
 

Assignment	Points Possible
Demonstration Exercises (approx)	50
College Accounting Exercises and Problems (approx)	200
Quizzes 7 @ 50	350
Payroll Project (approx)	100
Total Possible Points (approx)	700

Grading Scale:
 

Percentage of Possible Points	Grade
90%- 100%	A
80% - 89%	B
80% - 79%	C
60% - 69%	D
Below 60%	F


If you decide to drop this class, it is your responsibility to officially withdraw to avoid a letter grade (denial of access to Blackboard is NOT the same as a drop from the class). CR/NC is available by making arrangements with the instructor.

Disabilities/Special Needs:
As required by the Americans with Disabilities Act (ADA), accommodations are provided to ensure equal opportunity for students with verified disabilities. If you have a disability that requires accommodations for this class, please contact the Learning Skills Program at 479-6220 (for students with learning disabilities and attention deficit disorder) or Disabled Student Services at 479-6379, to make arrangements as soon as possible.

back to Cheryl Furbee's Homepage