ACTG 64B: COMPUTERIZED ACCOUNTING PRACTICE USING EXCEL
Foothill College Course Outline of Record
| Heading | Value |
|---|---|
| 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 |
| Grade Type: | Letter Grade (Request for Pass/No Pass) |
| 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
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.
E. Create spreadsheet reports.
F. Analyze spreadsheet reports.
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:
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
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
Lab Content
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
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
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.