CCCOnline LogoCourse Snapshot for ACC135 - Spreadsheet Applications for Accounting

Course Competencies

The competencies you will demonstrate in this course are as follows:

  1. Apply basic spreadsheet skills to the accounting task of:
    • payroll
    • depreciation schedules
    • accounts receivable aging
    • inventory data and evaluation
    • interest calculations and payment schedules
    • fixed and variable cost analysis
    • cost, volume and pricing strategies
    • capital budgeting analysis
  2. Create and copy formulas
  3. Create standard financial statements using a spreadsheet
  4. Use descriptive accounting and financial functions
  5. Use large worksheet and multi-page worksheets for multiple period or multi-part analysis
  6. Create charts and graphs to analyze and illustrate business data
  7. Setup variables and formulas for what-if analysis of business data
  8. Troubleshoot spreadsheet problems
Learning concepts for this course are enchanced using websites, software examples, and online discussions.

Module Outcomes Mapped to Competencies

Module 1 Learning Outcomes

Mapped to Course Competencies (above)
Describe how Excel is used in accounting . 1, 8
Show how to start, navigate, and work with Excel files. 1, 3, 8
Explain Excel’s capabilities and use of the help function. 1, 3, 8

Module 2 Learning Outcomes

Mapped to Course Competencies (above)

Build an Excel worksheet. 1, 3, 5
Produce Excel formulas that manipulate data. 1, 2, 3, 5
Compose and print an Excel workbook. 1, 2, 3, 5

Module 3 Learning Outcomes

Mapped to Course Competencies (above)

Construct and Analyze vertical and horizontal financial analysis. 1, 2, 3, 4
Build different charts in Excel. 1, 2, 3, 4, 6
Apply Financial ratios to financial data. 1, 2, 4, 6

Module 4 Learning Outcomes

Mapped to Course Competencies (above)

Build and Describe Depreciation functions and charts. 1, 2, 5, 6
Construct a what-if analysis chart. 1, 2, 3, 5, 6
Modify charts to illustrate depreciation expense. 1, 3, 5, 6

Module 5 Learning Outcomes

Mapped to Course Competencies (above)

Differentiate between what-if and goal-seeking capabilities of Excel functions. 1, 3, 4, 5, 6, 7
Create loan and bond amortization schedules. 1, 3, 4, 6
Explain how to use Excel’s Scenario Manager function. 1, 4, 7

Module 6 Learning Outcomes

Mapped to Course Competencies (above)

Construct multiple budgets for an organization. 1, 4, 5, 6
Explain Excel’s grouping function. 5, 6
Assess what-if and goal seeking with a cash budget. 1, 5, 6, 7

Module 7 Learning Outcomes

Mapped to Course Competencies (above)

Prepare a present/future value analysis. 1, 4, 6, 7
Report how excel predicts costs. 1, 6, 7, 8
Calculate an allowance for uncollectible accounts. 1, 6, 8

Course Time Commitment and Expectations

For every credit hour, students should plan to spend an average of 2-3 hours per week for course-related activities in a 15-week course. For example, a 3 credit hour course would average an average 6-9 hours per week to read/listen to the online content, participate in discussion forums, complete assignments, and study the course material. For 10  and 6-week courses, the amount of time per week will be higher so all course competencies, module outcomes, and assignments will be covered.

Aside from typical reading assignments, this course has the following (Please Note: This list is subject to change based on the discretion of the instructor facilitating this course.):

Assignment

Points

Introduction Discussion 10
Discussion (5@25 points each) 125
Web Activities (4@15 points each) 60
Assignments(12@25 points each) 300
Comprehensive Problem 75
Exams (Midterm and Final; 60 points each) 120
TOTAL 690

 

CCCOnline Course Quality Commitment

CCCOnline goes to great lengths to assure the quality of your online learning experience. You can expect the following from our courses: