Office Technology Assistant Curriculum

Students will learn the QuickBooks accounting software by performing tasks that involve the general ledger, accounts payable, accounts receivable, inventory, payroll, and financial statements. Students will be responsible for finding and correcting errors in the QuickBooks program. PREREQUISITE: 10101101 Financial Accounting 1 or 10101176 Financial Accounting 1A.

Financial Accounting 1A

10101176

UGRD

| 2 CR

This is a basic accounting course for non-accounting program students. The scope of study focuses on an introduction to business and accounting, analyzing and recording accounting transactions, performing the adjusting process, and completing the accounting cycle. Understanding is based both on theory and application.

MS Outlook

10103125

UGRD

| 1 CR

This course introduces the basics of Microsoft Outlook. Participants will use e-mail, calendar, files, and other features to effectively manage business and personal information.

MS Word A

10103146

UGRD

| 1 CR

This is the first course in a sequence that develops foundational skills in the use of Microsoft Office Word features to efficiently and effectively produce business documents. Students will apply Microsoft Word skills to solve practical problems in a project-based format. Explore best practices in document layout, collaboration, tables, reports, desktop publishing basics, themes, sort, styles, and references. Recommended computer foundations: Windows competency, including solid file management skills; ability to key 30 WPM. This course will use Microsoft Office 2019 or Office 365.

MS Excel A

10103151

UGRD

| 1 CR

This is the first course in a sequence that develops foundational skills in the use of Microsoft Office Excel features to efficiently and effectively produce business spreadsheets. Students will apply Microsoft Excel skills to solve practical problems in a project-based format. Activities will work on creating a spreadsheet, incorporate appropriate formulas and functions to report accurate data, and chart results. Recommended computer foundations: Windows competency, including solid file management skills; basic math fundamentals. This course will use Microsoft Office 2019 or Office 365.

Advanced Document Applications

10103184

UGRD

| 2 CR

This is the second course in a sequence that develops advanced skills in the use of Microsoft Office Word features to efficiently and effectively produce business documents. Students will apply Microsoft Word skills to solve practical problems in a project-based format. Explore best practices in document layout, collaboration, tables, mail merge, desktop publishing, themes, templates, forms, sort, styles, references, captions, and macros. Recommended computer foundations: Windows competency, including solid file management skills; ability to key 30 WPM. This course will use Microsoft Office 2019 or Office 365. COREQUISITE: 10103146 MS Word A

Document Formatting

10106110

UGRD

| 2 CR

This hands-on course covers formatting styles of business letters, business and academic reports, memos, tables, and business documents. The course also includes drill work for improving keying speed and accuracy. Students should be able to key 40 words per minute.

Meeting and Event Planning

10106123

UGRD

| 3 CR

In this course students will deepen their understanding of planning meetings and project management. Students learn about event planning and budgeting, negation and contracts, income projections, food and beverage coordination, technology utilization, and logistics management.

Proofreading for the Office

10106146

UGRD

| 3 CR

This course provides the learner with techniques used in proofreading office documents from both hard and soft copy (computer screen). Learners will incorporate the use of office reference manuals. This project-based course uses individual and group activities as well as in-class and out-of-class work.

Business Technology and Success

10106199

UGRD

| 1 CR

Designed to explore the impact of digital technology, communication, and media. Course learners will be able to apply organizational techniques and manage electronic files; explore computer hardware and the web using various software and apps while practicing security and safety techniques. Improve skills in critical thinking, innovation, and personal responsibility through experiential and problem-solving approaches for a workforce-ready mindset.