Accounting 6

Accounting 6
Spreadsheets for Accounting

INSTRUCTOR Cheryl Furbee
Spring 2012
Revised 1/5/12

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

College Accounting, Price, Haddock, and Brock,either 13th Edition, Chapters 1-30 (ISBN:0078025273) OR 12th Edition, Chapters 1-30 (ISBN:9780073401669).
Possible Reference Texts - Microsoft Office Excel 2007 or 2010, Kathleen Stewart, or Go! with Microsoft Excel 2007 or 2010, Volume 1, Gaskin, Preston and Vargas. These texts can be used for reference but are not required. Any other reference book you like, can be substituted.
User Name and Password in the Computer Technology Center OR off-campus access to the internet and to Excel.
Flash Memory Device to save your files if you will be working away from your home; or you can save your files in the "clouds" in the Computer Labs.

COURSE OBJECTIVES AND OUTCOMES

Objectives:

Critically assess, analyze, and interpret accounting information based on generally accepted accounting principles and prepare interactive spreadsheets that effectively present pertinent data.
Apply order of arithmetic operations and format rules to create professional, understandable, efficient, and interactive spreadsheets. This includes but is not limited to using various font styles/sizes, appropriate alignment, basic formulas, common functions, cell referencing, validations, customized headers/footers, and graphics.
Apply advanced formulas and functions such as IF, ROUND, LOOKUP, absolute, word wrap, nesting, etc. to create optimal efficiency and interactivity.
Prepare interactive spreadsheets to create accounts receivable aging schedules, and to calculate interest, present/future value, and depreciation.
Compare and contrast needed adjustments for doubtful accounts, depreciation, and promissory notes.
Critically assess results of operations for various companies using financial statement analysis techniques and ratios.
Analyze and allocate costs to departmentalized profit and cost centers to enable segment evaluations.

Learning Outcomes:

Construct fully interactive spreadsheets needed for an accounting department.
Solve novel problems by using cell references, functions, and embedded formulas.

COURSE REQUIREMENTS AND GRADING
Excel is the spreadsheet program of choice for Santa Cruz employers as well as elsewhere; you can use either the 2003, 2007, or 2010 version to complete the assignments. The Computer Technology Center, has the two newer versions. Instructor created videos 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.

Homework:
Certain chapters in the College Accounting text will be required. 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 your file with the .xls (97-03) or .xlsx (07/10) extension so the instructor can open it with a PC.

WARNING: There are videos created by the instructor that provide guidance and explanation to help you understand how to do some of the required formulas, functions, etc. These are based on using a PC. If you are using a Mac, the steps can be very different. This, of course, complicates the homework. The instructor does not have a Mac so little help can be given. If you have access to a PC or want to use the lab, you will save some time. Of course, it is good to learn to use Excel for Mac but expect to take more time and have more frustration.

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 one-week "window of opportunity" to complete the quizzes (12:01 a.m. Tuesday 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 and Misc.	40
College Accounting Exercises and Problems (approx)	220
Quizzes 7 @ 30	210
Payroll Project (approx)	100
Total Possible Points (approx)	570

Grading Scale:

Percentage of Possible Points	Grade
90%- 100%	A
80% - 89%	B
70% - 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. Excessive absences and/or failure to accurately complete five or more weekly assignments throughout the semester may result in being denied access to Blackboard. This denial may be followed by a drop from the course at the instructor's discretion. However, if the instructor does not initiate a drop, it is your responsibility to withdraw or receive an F grade. Pass/No Pass (P/NP) is available by making arrangements with the instructor.

Disabilities/Special Needs:
All students needing accommodations should inform the instructor ASAP. Veterans may qualify for accommodations. Wounded Warriors may have acquired injuries which, through the American with Disabilities Act (ADA), entitles the use of accommodations to ensure equal opportunity for students with verified disabilities. To determine if you qualify or need assistance with an accommodation, please contact Disabled Student Services, Room 810 479-6379, or the Learning Skills Program, Room 1073, 479-6220.