ACCT 136 Excel for Accounting (5 credits)

2. Calculate inventory cost under different methods by using analysis tools in Excel such as data bars and pivot tables.

3. Prepare data that is used in establishing and verifying backup documentation for audit trails.

4. Use built-in functions of Excel to determine depreciation, depletion, amortization, and impairment expense for Balance Sheet accounts.

5. Design Excel spreadsheets, tables, and graphs to effectively communicate accounting records.

6. Use Excel to conduct budgeting and cost analyses using vertical and horizontal analyses on financial statements.

Degree Outcomes
Program Outcome:  Use computer and related tools to perform financial reports and management reports.

Critical, Creative, and Reflective Thinking: Graduates will evaluate, analyze, synthesize, and generate ideas; construct informed, meaningful, and justifiable conclusions; and process feelings, beliefs, biases, strengths, and weaknesses as they relate to their thinking, decisions, and creations.

Global Citizenship: Graduates will be able to critically examine the relationship between self, community, and/or environments, and to evaluate and articulate potential impacts of choices, actions, and contributions for the creation of sustainable and equitable systems.

Effective Communication: Graduates will be able to exchange messages in a variety of contexts using multiple methods.

Lecture Contact Hours 50
Lab Contact Hours 0
Clinical Contact Hours 0
Total Contact Hours 50

Potential Methods
A.Case Studies B.Objective testing C.Project D.Assignments