Foothill CollegeApproved Course Outlines

Business and Social Sciences Division
ACTG 64BCOMPUTERIZED ACCOUNTING PRACTICE USING EXCELSummer 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; 10/2013

1. Description -
Practice in using an electronic spreadsheet program to organize and process financial and managerial accounting data. Includes research on the Internet.
Prerequisite: ACTG 1B or equivalent experience.
Co-requisite: None
Advisory: Not open to students with credit in CIS 64B.

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. understand the basic mechanics of an electronic spreadsheet.
  5. create spreadsheet reports.
  6. analyze spreadsheet reports.
  7. conduct research on the Internet.
3. Special Facilities and/or Equipment -
Access to a computer lab and Excel 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. Using a combination of pre-programmed and model building exercises learn or review the following Excel functions
    1. SUM
    2. IF
    3. DDB
    4. SLN
    5. NOW
    6. PMT
    7. PV
    8. NPV
    9. FV
    10. ROUND
    11. VLOOKUP
    12. Pivot Tables
  2. Using a combination of preprogrammed & model building exercises create or complete a computerized spreadsheet version of the following:
    1. Business transactions
    2. Trial balance worksheet
    3. Income statement
    4. Balance sheet
    5. Statement of owner's equity and/or statement of retained earnings
    6. Statement of cash flows
    7. Bank reconciliation
    8. Inventory cost flow schedules (FIFO/LIFO)
    9. Depreciation schedules
    10. Loan payment schedule
    11. Bond amortization schedules
    12. Vertical analysis
    13. Horizontal analysis
    14. Payroll register
    15. Cash budget
    16. Ratio analysis
  3. Prepare a financial analysis model that incorporates many of the problems and models already prepared above, including written analysis
  4. Print out and discuss information obtained from internet research
5. Repeatability - Moved to header area.
 
6. Methods of Evaluation -
Final review of printout copy of all problems assigned.
7. Representative Text(s) -
Smith, Gaylord N. Excel Applications for Accounting Principles. Ohio: Thomson South-Western, 2012.

8. Disciplines -
Accounting
Computer Information Systems
 
9. Method of Instruction -
Lecture, Electronic discussions/chat, Demonstration.
 
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 -
  1. Reading of internet articles and writing on accounting topics or accounting related current events and/or careers.
  2. Written financial statement analysis accompanying various assignments.
13. Need/Justification -
This course is a required core course for the AA degree in Accounting.


Course status: Active
Last updated: 2014-02-26 15:31:27


Foothill CollegeApproved Course Outlines