Foothill CollegeApproved Course Outlines

Business and Social Sciences Division
ACTG 64ACOMPUTERIZED ACCOUNTING PRACTICE USING QUICKBOOKSSummer 2014
4 hours lecture.4 Units

Total Quarter Learning Hours: 48 (Total of All Lecture, Lecture/Lab, and Lab hours X 12)
 
 Lecture Hours: 4 Lab Hours: Lecture/Lab:
 Note: If Lab hours are specified, see item 10. Lab Content below.

Repeatability -
Statement: Not Repeatable.

Status -
 Course Status: ActiveGrading: Letter Grade with P/NP option
 Degree Status: ApplicableCredit Status: Credit
 Degree or Certificate Requirement: AA Degree,   Certificate of Achievement
 GE Status: Non-GE

Articulation Office Information -
 Transferability: CSUValidation: 12/13/10; 11/15/13

1. Description -
Focus on using QuickBooks to record financial data. Reviewing the accounting cycle, processing business transactions and preparing financial statements.
Prerequisite: ACTG 1A or equivalent experience.
Co-requisite: None
Advisory: Not open to students with credit in CIS 64A.

2. Course Objectives -
The student will be able to:
  1. work independently and comply with written instructions on handling accounting information.
  2. establish and meet a time schedule.
  3. increase comprehension of accounting concepts.
  4. develop orderly habits for handling business papers and processing accounting transactions on the computer, using QuickBooks.
  5. print out financial statements.
  6. conduct research on the Internet.
3. Special Facilities and/or Equipment -
Access to computer lab and QuickBooks software. When taught as an online distance learning section, students and faculty need ongoing and continuous Internet and email access.

4. Course Content (Body of knowledge) -
  1. Set up a business accounting system
    1. Set up chart of accounts
    2. Set up company preferences
    3. Set up customers, vendors & accounts
    4. Set up payroll & employees
  2. Interpret and enter cash oriented financing, investing and operating business activities in order to evaluating a business's performance & financial position
  3. Interpret and enter non-cash investing & financing activities
  4. Interpret and enter adjusting entries
    1. Accrued expenses
    2. Accrued revenues
    3. Unearned revenues
    4. Deferred expenses
    5. Depreciation
  5. Prepare a bank reconciliation and record related adjustments
  6. Prepare the following budget related activities
    1. Budget revenues & expenses
    2. Budget balance sheets
    3. Prepare a budget versus actual report
  7. From data interpreted and entered, report on various business activities
    1. Create & memorize standardized and customized income statements
    2. Create & memorize standardized and customized balance sheets
    3. Create & memorize statements of cash flows
    4. Create graphs to illustrate financial information
    5. Create & memorize reports from the subsidiary journals such as accounts payable aging reports and accounts receivable aging reports
    6. Create comparative balance sheets
    7. Create comparative income statements
    8. Create comparative balance sheets
    9. Modify financial statements
  8. From data interpreted and entered, create and produce a trial balance
  9. From data interpreted and entered, create and produce a general ledger
  10. Print out information obtained from internet research
5. Repeatability - Moved to header area.
 
6. Methods of Evaluation -
  1. Midterm and final exams
  2. Computerized assignments using Excel spreadsheets to enter business transactions and prepare financial statements
  3. Computerized assignment using Excel spreadsheets to create general ledger, receivables and payable, payroll transactions, and bank reconciliation statement
  4. Computerized assignments using Excel spreadsheets to create various budgets
  5. Discussion posts
7. Representative Text(s) -
Glenn, Owen, QuickBooks Pro for Accounting 2013. Ohio: Thomson South-Western, 2013.

8. Disciplines -
Accounting
Computer Information Systems
 
9. Method of Instruction -
Lecture, Electronic discussions/chat, hands-on-assignments.
 
10. Lab Content -
Not applicable.
 
11. Honors Description - No longer used. Integrated into main description section.
 
12. Types and/or Examples of Required Reading, Writing and Outside of Class Assignments -
Assignments will be evaluated based on students' abilities to perform "hands on” operations/transactions on Excel software. Exercises and problems are designed to test students' skills at understanding different functions and tools within Excel, preparing budgets, using Excel formula function to build vertical, horizontal and ratio analysis, preparing budgets and presenting accounting reports and financial statements.
  1. Reading the required Excel text
  2. Reading of various accounting texts related to accounting terms, regulations, standards and procedures
  3. Visiting accounting websites to read on accounting theories and practices
  4. Internet research regarding best practices in Excel
  5. Reading of Wall Street Journal, Business Week, Fortune
13. Need/Justification -
This course is a required core course for the AA degree in Accounting.


Course status: Active
Last updated: 2014-07-22 06:44:55


Foothill CollegeApproved Course Outlines