Common Course Outline
Course discipline/number/title
ACCT 2234: Computerized Accounting and Business Applications
Catalog Description
| Credits | 3 |
|---|---|
| Hours/Week | 3 |
| Prerequisites (Course discipline/number) | None |
| Other requirements | None |
| MnTC Goals (if any) | NA |
Course Description
This course covers the use of spreadsheet, database, presentation, word processing, and data analytics software to solve accounting and business related problems. Topics include designing, creating and enhancing worksheets and charts, using formulas and functions to perform calculations, printing, merging, and file management. There is an introduction to use financial statement and data analysis within the decision-making process.
Date Last Revised (Month, year)
May, 2023
Outline of Major Content Areas
- Computer file management
- Profitability and financial ratios (using spreadsheet functions and formulas)
- Customer and sale records (using database tables, queries, forms, and reports)
- Financial statements and reports
- Presentation of accounting and business reports, graphs, slides, and data
- Multiple software application
Learning Outcomes (General)
The student will be able to:
- Use the terminology of spreadsheet software.
- Solve business and accounting problems using spreadsheet formulas and functions.
- Organize and manage computer files including creating, saving, and backup versions.
- Create and maintain customer sales and receivable balances through queries, forms, and reports using database software.
- Present financial statement and accounting data using presentation software.
- Calculate cost per unit and cash flow valuation using computerized applications.
- Describe ethical conduct for accountants and managers.
- Use financial statement analysis to make business decisions.
- Use course management software to manage files.
- Transfer data to other software applications to use the data to make reports.
- Prepare ratio and financial statement reports.
Learning Outcomes (MnTC)
NA
Methods for Evaluation of Student Learning
Methods may include but are not limited to:
- Daily assignments
- Written tests
- Written homework
- Group activities
- Case studies
RCTC Core Outcome(s)
This course contributes to meeting the following RCTC Core Outcome(s):
- Critical Thinking
- Students will think systematically and explore information thoroughly before accepting or formulating a position or conclusion.
Special Information (if any)
None