# ACTG 64B: COMPUTERIZED ACCOUNTING PRACTICE USING EXCEL

## Foothill College Course Outline of Record

Foothill College Course Outline of Record
Effective Term: Summer 2021
Units: 4
Hours: 4 lecture per week (48 total per quarter)
Corequisite: Completion of or concurrent enrollment in ACTG 1B or 1BH.
Advisory: Not open to students with credit in CIS 64B.
Degree & Credit Status: Degree-Applicable Credit Course
Foothill GE: Non-GE
Transferable: CSU
Repeatability: Not Repeatable

## Student Learning Outcomes

• Apply accounting principles and procedures by data entry of business transactions into a computerized spreadsheet program.
• Integrate knowledge of various accounting principles and the spreadsheet program into various accounting work papers and financial reports.

## Description

Practice in using an electronic spreadsheet program to organize and process financial and managerial accounting data. Includes research on the internet.

## Course Objectives

The student will be able to:
A. Work independently and comply with written instructions on handling accounting information.
B. Establish and meet a time schedule.
C. Increase comprehension of accounting concepts.
D. Understand the basic mechanics of an electronic spreadsheet.
G. Conduct research on the internet.

## Course Content

A. 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
B. Using a combination of preprogrammed and model building exercises create or complete a computerized spreadsheet version of the following:
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
C. Prepare a financial analysis model that incorporates many of the problems and models already prepared above, including written analysis
D. Print out and discuss information obtained from internet research

Not applicable.

## Special Facilities and/or Equipment

B. When taught as an online distance learning section, students and faculty need ongoing and continuous internet and email access.

## Method(s) of Evaluation

Methods of Evaluation may include but are not limited to the following:

Midterm and final exams
Computerized assignments using Excel spreadsheets to enter business transactions and prepare financial statements
Computerized assignment using Excel spreadsheets to create general ledger, receivables and payable, payroll transactions, and bank reconciliation statement
Computerized assignments using Excel spreadsheets to create various budgets
Discussion posts

## Method(s) of Instruction

Methods of Instruction may include but are not limited to the following:

Lecture
Electronic discussions/chat
Demonstration

## Representative Text(s) and Other Materials

Smith, Gaylord N.. Excel Applications for Accounting Principles. 2020.

## Types and/or Examples of Required Reading, Writing, and Outside of Class Assignments

A. Reading of internet articles and writing on accounting topics or accounting related current events and/or careers.
B. Written financial statement analysis accompanying various assignments.

Accounting