Accounting Assistant - Technical Diploma

Students gain skills that lead to success in college, employment, and life. Students should take this course in their first semester. (Pre-requisite: None.)

All college students, regardless of their college major, need to be able to make reasonable decisions about fiscal, environmental, and health issues that require quantitative reasoning skills. An activity based approach is used to explore numerical relationships, graphs, proportional relationships, algebraic reasoning, and problem solving using linear, exponential and other mathematical models. Students will develop conceptual and procedural tools that support the use of key mathematical concepts in a variety of contexts. This course may be used as the first of a two part sequence that ends with Quantitative Reasoning as the capstone general education math requirement. (Prerequisite: Next Gen Arith score greater/equal to 250 AND Rdg score greater/equal to 250; OR ACT Math score greater/equal to 15 AND ACT Reading score greater/equal to 16; OR prep courses-contact an academic advisor 920-498-5444).

Accounting principles, financial statements, business transactions, accounting cycles/systems, accounting for cash and receivables for sole proprietorships in service or merchandising businesses.

Creating worksheets; enter data, make modifications, work with formulas and functions, create and enhance charts, manage data, transform data, conditional formatting, importing/exporting data, introduction to PivotTables and PivotCharts.

Use of financial calculator, purchasing, shipping/receiving, A/R, and A/P systems, markups, discounts, credit charges, time value of money, depreciation methods, and inventory methods.

Creating and editing documents, formatting and customizing documents, collaborating with others and working with reports, using tables, columns, and graphics.

Covers working with data tools, advanced formatting techniques, advanced functions, evaluating formulas, collaboration tools, data validation, form controls, macros, working with templates, and collaborating with multiple Excel users. (Pre-req: 10-103-131, MS Excel Intro)

Learners develop knowledge/skills in planning, organizing, writing, editing. Students will also analyze audience/purpose, use elements of research, format documents using standard guidelines, and develop critical reading skills. (Prerequisite: High school GPA greater/equal to 2.6; OR ACT Reading score greater/equal to 16 AND English greater/equal to 18; OR Next Gen Reading score greater/equal to 250 AND Writing score greater/equal to 260; OR "preparatory course(s)", contact academic advisor at 920-498-5444)

Applying Excel spreadsheet functionality to prepare accounting financial reports, business analysis of financial performance and optimizing accounting processes for evaluation and decision making. (Prerequisites: 10-101-110, Accounting 1; 10-103-132, MS Excel Part 2 )

Inventories, fixed assets, current liabilities including payroll and notes payable, business formations, capital stocks, dividends, bonds, cash flow statements, and financial statement analysis. (Prerequisites: 10-101-110, Accounting 1)

Payroll and personnel records, social security, withholding tax, unemployment compensation, time sheets and time-keeping records, and legal aspects of payroll. (Prerequisite: 10-101-110, Accounting 1)

This course focuses on developing effective listening techniques and verbal and nonverbal communication skills through oral presentation, group activity, and other projects. The study of self, conflict, and cultural contexts will be explored, as well as their impact on communication. (Prerequisite: Next Gen Rdg score greater/equal to 250 AND Writing score greater/equal to 237; OR ACT Rdg score greater/equal to 16 AND English score greater/equal to 16; OR preparatory course-contact an academic advisor at 920-498-5444)

Learners will be introduced to basic and advanced features of QuickBooks and will apply skills in realistic business simulations including creating accounts, invoicing, budgeting, preparing statements, journalizing and graphing. (Prerequisite: 10-101-110, Accounting 1)