Course Number and Title:
ACC 162 Computerized Accounting
Campus Location
- Dover
- Georgetown
- Wilmington
Prerequisites
Prerequisite: ACC 101 and (BUS 107 or CIS 107 or OAT 152)
Course Credits and Hours
3 credit(s)
2 lecture hours/week
2 lab hours/week
Course Description
This course prepares students with the workplace skills necessary to use automated accounting software. Topics include data entry by interpreting accounting information, creating financial statements and other financial reports, creating payroll and the related payroll reporting requirements, and creating and managing customer invoices and vendors' bills. This course reinforces the concepts learned in Accounting I and applies these concepts to computer software used to make business decisions.
Core Course Performance Objectives (CCPOs)
- Create a business's account system using automated accounting software. (CCC 2, 5, 6; PGC 2, 3)
- Create a balance sheet, an income statement, and supporting reports, and modify the presentation. (CCC 5, 6; PGC 2, 3, 5)
- Set up and reconcile a company bank account and a company credit card for the recording of financial transactions. (CCC 2, 6; PGC 2, 3)
- Create payroll for a business using Excel and appropriate government-provided instructions. (CCC 2, 5, 6; PGC 1, 3, 5)
- Create payroll for a business using automated accounting software, and prepare the appropriate quarterly and annual payroll reports. (CCC 2, 5, 6; PGC 1, 3, 5)
- Create and manage customer invoices, record payments, and make deposits. (CCC 2, 6; PGC 3, 5)
- Create and manage vendors' bills and credits, and pay bills. (CCC 2, 6; PGC 3, 5)
See Core Curriculum Competencies and Program Graduate Competencies at the end of the syllabus. CCPOs are linked to every competency they develop.
Measurable Performance Objectives (MPOs)
Upon completion of this course, the student will:
- Create a business's account system using automated accounting software.
- Create a new company file using automated accounting software.
- Set up company preferences within the new company file.
- Set up customers, vendors, and accounts within the new company file.
- Record business transactions classified as financing, investing, and operating activities within the new company file.
- Create a balance sheet, an income statement, and supporting reports, and modify the presentation.
- After financial transactions are entered, create a balance sheet, income statement, and supporting reports using automated accounting software reporting features.
- Use the reporting features to modify the financial statement presentation (e.g., modify specific dates, include comparative data, or change report titles).
- Set up and reconcile a company bank account and a company credit card for the recording of financial transactions.
- Create a bank account for use with operating funds from within the company file.
- Create a credit card account for recording financing activities from within the company file.
- Reconcile the company bank account using the automated accounting software reconciliation features, and print the appropriate report to support the transactions.
- Reconcile the company credit card account using the automated accounting software reconciliation features, and print the appropriate report to support the transactions.
- Create payroll for a business using Excel and appropriate government-provided instructions.
- Use Excel software to create payroll records for employees of a business.
- Expand the payroll spreadsheet to include the calculations for monthly, quarterly, and annual payroll deposits and related reporting.
- Explain the reporting requirements for federal and Delaware payroll cycles.
- Create payroll for a business using automated accounting software, and prepare the appropriate quarterly and annual payroll reports.
- Use automated accounting software to set up payroll for a business.
- Print weekly paychecks for employees using automated accounting software.
- Compute the monthly, quarterly, and annual payroll deposits and related reporting requirements using automated accounting software.
- Print monthly, quarterly, and annual payroll reports using automated accounting software.
- Create and manage customer invoices, record payments, and make deposits.
- Record sales on account using the Create Invoices window in automated accounting software.
- Record collections of accounts receivable using the Receive Payments window in automated accounting software.
- Record cash sales using the Enter Sales Receipt window in automated accounting software.
- Record deposits in the Make Deposits window in automated accounting software.
- Create customer-related reports.
- Create and manage vendors' bills and credits, and pay bills.
- Record purchases on an account in the Enter Bills window of automated accounting software.
- Create credit memos in the Enter Bills window of automated accounting software.
- Record payments of accounts payable in the Pay Bills window of automated accounting software.
- Record cash purchases in the Write Checks window of automated accounting software.
- Create vendor-related reports.
Evaluation Criteria/Policies
The grade will be determined using the Delaware Tech grading system:
| 90-100 |
= |
A |
| 80-89 |
= |
B |
| 70-79 |
= |
C |
| 0-69 |
= |
F |
Students should refer to the
Catalog/Student Handbook for information on the Academic Standing Policy, the Academic Integrity Policy, Student Rights and Responsibilities, and other policies relevant to their academic progress.
Final Course Grade
Calculated using the following weighted average
Evaluation Measure | Percentage of final grade |
Summative Assessments |
4 – 6 Exams Equally weighted | 55% |
Comprehensive Problem | 15% |
QuickBooks Certiport Certification | 10% |
Formative Assessments |
The course will contain various formative assessments including but not limited to: - Assignments
- Activities
- Quizzes
- Problems
| 20% |
TOTAL | 100% |
Program Graduate Competencies (PGCs are the competencies every graduate will develop specific to his or her major)
- Integrate professional, ethical, and legal standards into business decision-making.
- Apply foundational business concepts that lead to strategic thinking and the ability to analyze complex problems.
- Use professional and technology based skills that are relevant to the dynamic business environment.
- Employ effective communication skills and collaboration strategies to promote positive organizational outcomes.
- Apply skills necessary to analyze and interpret business and financial data for decision-making purposes.
Core Curriculum Competencies (CCCs are the competencies every graduate will develop)
- Apply clear and effective communication skills.
- Use critical thinking to solve problems.
- Collaborate to achieve a common goal.
- Demonstrate professional and ethical conduct.
- Use information literacy for effective vocational and/or academic research.
- Apply quantitative reasoning and/or scientific inquiry to solve practical problems.
Students in Need of Accommodations Due to a Disability
We value all individuals and provide an inclusive environment that fosters equity and student success. The College is committed to providing reasonable accommodations for students with disabilities. Students are encouraged to schedule an appointment with the campus Disabilities Support Counselor to request an accommodation needed due to a disability. The College's policy on accommodations for persons with disabilities can be found in the College's Guide to Requesting Academic Accommodations and/or Auxiliary Aids Students may also access the Guide and contact information for Disabilities Support Counselors through the Student Resources web page under Disabilities Support Services, or visit the campus Advising Center.