ACC 162 Computerized Accounting


Campus Location:
Georgetown, Dover, Stanton, Wilmington
Effective Date:
2018-51
Prerequisite:
ACC 101, CIS 107 or OAT 152, SSC 100 or concurrent
Co-Requisites:
None
Course Credits and Hours:
3.00 credits
2.00 lecture hours/week
2.00 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.

Required Text(s):

Obtain current textbook information by viewing the campus bookstore online or visit a campus bookstore. Check your course schedule for the course number and section.

Additional Materials:

None

Schedule Type:
Classroom Course
Hybrid Course
Disclaimer:

None

Core Course Performance Objectives (CCPOs):
  1. Create a business’s account system using automated accounting software. (CCC 2, 5, 6; PGC ACT 2, 4, 5; GBT 1, 5; OAT 1)
  2. Create a balance sheet, an income statement, and supporting reports, and modify the presentation. (CCC 5, 6; PGC ACT 1, 2, 4; GBT 5; OAT 1)
  3. Set up and reconcile a company bank account and a company credit card for the recording of financial transactions. (CCC 2, 6; PGC ACT 1, 2, 4; GBT 5; OAT 1)
  4. Create payroll for a business using Excel and appropriate government-provided instructions. (CCC 2, 5, 6; PGC ACT 1, 2, 4; GBT 1, 3, 5; OAT 1)
  5. Create payroll for a business using automated accounting software, and prepare the appropriate quarterly and annual payroll reports. (CCC 2, 5, 6; PGC ACT 1, 2, 4; GBT 1, 3, 5; OAT 1)
  6. Create and manage customer invoices, record payments, and make deposits. (CCC 2, 6; PGC ACT 1, 2, 4; GBT 1, 4, 5; OAT 1)
  7. Create and manage vendors’ bills and credits, and pay bills. (CCC 2, 6; PGC ACT 1, 2, 4; GBT 1, 4, 5; OAT 1)

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:

  1. Create a business’s account system using automated accounting software.
    1. Create a new company file using automated accounting software.
    2. Set up company preferences within the new company file.
    3. Set up customers, vendors, and accounts within the new company file.
    4. Record business transactions classified as financing, investing, and operating activities within the new company file.
  2. Create a balance sheet, an income statement, and supporting reports, and modify the presentation.
    1. After financial transactions are entered, create a balance sheet, income statement, and supporting reports using automated accounting software reporting features.
    2. Use the reporting features to modify the financial statement presentation (e.g., modify specific dates, include comparative data, or change report titles).
  3. Set up and reconcile a company bank account and a company credit card for the recording of financial transactions.
    1. Create a bank account for use with operating funds from within the company file.
    2. Create a credit card account for recording financing activities from within the company file.
    3. Reconcile the company bank account using the automated accounting software reconciliation features, and print the appropriate report to support the transactions.
    4. Reconcile the company credit card account using the automated accounting software reconciliation features, and print the appropriate report to support the transactions.
  4. Create payroll for a business using Excel and appropriate government-provided instructions.
    1. Use Excel software to create payroll records for employees of a business.
    2. Expand the payroll spreadsheet to include the calculations for monthly, quarterly, and annual payroll deposits and related reporting.
    3. Explain the reporting requirements for federal and Delaware payroll cycles.
  5. Create payroll for a business using automated accounting software, and prepare the appropriate quarterly and annual payroll reports.
    1. Use automated accounting software to set up payroll for a business.
    2. Print weekly paychecks for employees using automated accounting software.
    3. Compute the monthly, quarterly, and annual payroll deposits and related reporting requirements using automated accounting software.
    4. Print monthly, quarterly, and annual payroll reports using automated accounting software.
  6. Create and manage customer invoices, record payments, and make deposits.
    1. Record sales on account using the Create Invoices window in automated accounting software.
    2. Record collections of accounts receivable using the Receive Payments window in automated accounting software.
    3. Record cash sales using the Enter Sales Receipt window in automated accounting software.
    4. Record deposits in the Make Deposits window in automated accounting software.
    5. Create customer-related reports.
  7. Create and manage vendors’ bills and credits, and pay bills.
    1. Record purchases on an account in the Enter Bills window of automated accounting software.
    2. Create credit memos in the Enter Bills window of automated accounting software.
    3. Record payments of accounts payable in the Pay Bills window of automated accounting software.
    4. Record cash purchases in the Write Checks window of automated accounting software.
    5. Create vendor-related reports.

 

Evaluation Criteria/Policies:

Students must demonstrate proficiency on all CCPOs at a minimal 75 percent level to successfully complete the course. The grade will be determined using the Delaware Tech grading system:

92 100 = A
83 91 = B
75 82 = C
0 74 = F

Students should refer to the 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

Exams (6) (Summative Assessments, 10% each)

Comprehensive Problem

60%

20%

Formative Assessments (Assignments/Activities/Quizzes/Serial Problems, etc.)

20%

TOTAL

100%

Core Curriculum Competencies (CCCs are the competencies every graduate will develop):
  1. Apply clear and effective communication skills.
  2. Use critical thinking to solve problems.
  3. Collaborate to achieve a common goal.
  4. Demonstrate professional and ethical conduct.
  5. Use information literacy for effective vocational and/or academic research.
  6. Apply quantitative reasoning and/or scientific inquiry to solve practical problems.
Program Graduate Competencies (PGCs are the competencies every graduate will develop specific to his or her major):

 

Accounting (ACC)

  1. Prepare and analyze financial statements in accordance with Generally Accepted Accounting Principles.
  2. Analyze data to process information for decision-making under a product and job costing system.
  3. Apply tax laws to the preparations of tax returns and to tax plans.
  4. Integrate professional, ethical and legal standards into business practice.
  5. Employ the various theories of management and marketing in a business.

General Business (GBT)

  1. Integrate professional, ethical and legal standards into business practice.
  2. Employ the various theories of management and marketing in a business.
  3. Apply the principles of human resource management to organizations.
  4. Evaluate the actions taken to acquire and retain customers.
  5. Measure and track financial performance of an organization.
  6. Analyze and apply the strategic management process to organizations.

Office Administration (OAT)

  1. Produce the documents necessary for a functioning business office.
  2. Exhibit the skills to produce a keyboarding timing that meets the minimum State requirements.
  3. Integrate office-related skills to function in a professional manner within the workplace.
  4. Use diverse research methods and information sources to complete a variety of business documents.
Disabilities Support Statement:

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. A listing of campus Disabilities Support Counselors and contact information can be found at the disabilities services web page or visit the campus Advising Center.

Minimum Technology Requirements:
Minimum technology requirements for online, hybrid, video conferencing and web conferencing courses.