Computer Applications (Office Software Intermediate)

Course Description

OTA0043C – Computer Applications (Office Software Intermediate) is a Postsecondary Adult Vocational (PSAV) clock-hour integrated lecture-and-laboratory course delivered as an intermediate module within the Florida Department of Education (FLDOE) Administrative Office Specialist Program (B070330). Building on the foundational computing literacy established in OTA0030C, OTA0043C provides intermediate-to-advanced instruction in the Microsoft Office productivity suite — Word at intermediate-to-expert level, Excel at intermediate-to-expert level, PowerPoint at intermediate level, and Access (database) at introductory-to-intermediate level. The course substantially advances students toward Microsoft Office Specialist (MOS) Specialist and Expert certifications across multiple Office applications. The "C" indicator denotes integrated lecture-and-laboratory instruction with substantial hands-on practice.

The course sits within the Florida Statewide Course Numbering System (SCNS) under Office Technology Administration > Computer Applications and is offered at approximately 27 Florida public institutions providing the Administrative Office Specialist PSAV program. The FLDOE Administrative Office Specialist Program (B070330) totals approximately 1,050 clock hours — see the OTA0030C guide for the comprehensive program structure overview.

For comprehensive overview of the FLDOE Administrative Office Specialist program structure, Florida administrative-office employer landscape, training-center delivery, and articulation pathways, see the OTA0030C (Computing for College and Careers / Office Technology Foundations) guide in this corpus.

Note: Specific course-level details (precise hours, exact subtopic emphasis) within the FLDOE Administrative Office Specialist PSAV program may vary by institution. Students should verify specific course content with their institution's program advisor. The general course-level description in this guide reflects typical Florida institutional implementations of the intermediate-software module within the FLDOE-framework Administrative Office Specialist program.

Learning Outcomes

Required Outcomes

Upon successful completion of OTA0043C, students will be able to:

• Apply principles of intermediate-to-expert Microsoft Word: advanced document formatting (styles, themes, page layout, sections, columns, headers and footers, page numbers); table creation and formatting; substantial use of styles for consistent document formatting; mail merge for substantial-volume document production; advanced page-layout for professional documents (letters, reports, newsletters, manuals); collaboration features (track changes, comments, document protection); the substantial role of advanced Word competence in office document production.
• Apply principles of intermediate-to-expert Microsoft Excel: substantial range of formulas and functions (logical functions — IF, AND, OR, IFS; lookup functions — VLOOKUP, HLOOKUP, INDEX/MATCH, XLOOKUP at current versions; statistical functions — COUNTIF, SUMIF, COUNTIFS, SUMIFS, AVERAGEIF; date/time functions; text functions); data analysis features (sorting, filtering, conditional formatting, data validation); pivot tables (substantial — among the most-substantial Excel productivity tools); charting (substantial range of chart types and chart formatting); macros at introductory level; the substantial role of Excel competence in contemporary office data work.
• Apply principles of intermediate Microsoft PowerPoint: advanced slide design (themes, layouts, slide masters); animations and transitions (with substantial restraint — professional-presentation conventions); embedded multimedia (images, audio, video); chart and diagram integration; presenter view; the substantial role of PowerPoint competence in office presentations.
• Apply principles of introductory-to-intermediate Microsoft Access: database concepts at introductory level; table design (fields, data types, primary keys); relationships between tables; basic forms; basic queries (select queries, parameter queries); basic reports; the substantial role of database awareness in office work; introductory awareness of when Access is appropriate vs. Excel for data work.
• Apply principles of integration across Microsoft Office applications: copying and pasting between applications; embedding and linking objects; mail merge between Word and Excel/Access data sources; the substantial productivity gains from cross-application integration.
• Apply principles of cloud-based productivity at intermediate level: Microsoft 365 cloud features (OneDrive integration, real-time collaboration, version history); SharePoint at introductory level; the substantial growth of cloud-based collaborative office work.
• Apply principles of advanced keyboarding and document production: advanced keyboarding speed and accuracy (target speeds typically 45+ net words per minute at this stage); the substantial role of efficient keyboarding in productivity.
• Apply principles of document templates and standardization: creating and using document templates; document standardization; the substantial role of templates in efficient office document production.
• Apply principles of professional document design: design principles (alignment, contrast, repetition, proximity); typography fundamentals; the substantial role of document design in professional communication; introductory awareness of brand-standardized document production.
• Apply principles of responsible computing in office settings (continued): continued attention to confidentiality, appropriate computer use, data security; introductory awareness of records-retention requirements; the contemporary considerations regarding generative AI use in office software (the substantial growth of AI-integrated office tools — Microsoft Copilot, Excel AI features — and the substantial considerations regarding when/how AI use is appropriate in office work).
• Successfully complete laboratory exercises developing intermediate-to-advanced office software skills.
• Prepare for and (where pursued) pass Microsoft Office Specialist (MOS) certifications: typically MOS Word Expert, MOS Excel Expert, MOS PowerPoint, and MOS Access at this stage of the Administrative Office Specialist program.

Optional Outcomes

Depending on institutional emphasis:

• Engage with specific industry-context emphasis: medical office context (medical-record-systems and EHR-adjacent work); legal office context (legal document formatting and management); accounting context (Excel-intensive accounting applications).
• Engage with introductory awareness of contemporary office productivity tools: Microsoft Power Automate (workflow automation); Microsoft Power BI (business intelligence); the substantial growth of contemporary productivity tools beyond core Office.
• Engage with introductory awareness of generative AI in office work: Microsoft Copilot integration; appropriate AI-tool use in office settings; the contemporary professional considerations.
• Engage with introductory awareness of cross-platform office productivity: Google Workspace alternatives; macOS/iOS office productivity.

Major Topics

Required Topics

• Intermediate-to-Expert Microsoft Word: Advanced document formatting (styles, themes, page layout, sections, columns, headers and footers, page numbers); table creation and formatting; styles for consistent document formatting; mail merge for substantial-volume document production; advanced page-layout for professional documents; collaboration features (track changes, comments, document protection); advanced Word competence in office document production.
• Intermediate-to-Expert Microsoft Excel: Substantial range of formulas and functions (logical — IF, AND, OR, IFS; lookup — VLOOKUP, HLOOKUP, INDEX/MATCH, XLOOKUP; statistical — COUNTIF, SUMIF, COUNTIFS, SUMIFS, AVERAGEIF; date/time; text); data analysis features (sorting, filtering, conditional formatting, data validation); pivot tables; charting; macros at introductory level; Excel competence in contemporary office data work.
• Intermediate Microsoft PowerPoint: Advanced slide design (themes, layouts, slide masters); animations and transitions (with restraint); embedded multimedia (images, audio, video); chart and diagram integration; presenter view; PowerPoint competence in office presentations.
• Introductory-to-Intermediate Microsoft Access: Database concepts at introductory level; table design (fields, data types, primary keys); relationships between tables; basic forms; basic queries (select queries, parameter queries); basic reports; database awareness in office work; Access vs. Excel for data work introduction.
• Cross-Application Integration: Copying and pasting between applications; embedding and linking objects; mail merge between Word and Excel/Access data sources; productivity gains from cross-application integration.
• Cloud-Based Productivity (Intermediate): Microsoft 365 cloud features (OneDrive integration, real-time collaboration, version history); SharePoint at introductory level; growth of cloud-based collaborative office work.
• Advanced Keyboarding and Document Production: Advanced keyboarding speed and accuracy (45+ net words per minute target); efficient keyboarding in productivity.
• Document Templates and Standardization: Creating and using document templates; document standardization; templates in efficient office document production.
• Professional Document Design: Design principles (alignment, contrast, repetition, proximity); typography fundamentals; document design in professional communication; brand-standardized document production introduction.
• Responsible Computing in Office Settings (Continued): Confidentiality, appropriate computer use, data security; records-retention requirements introduction; generative AI use considerations in office software (Microsoft Copilot, Excel AI features).
• Laboratory Exercises: Intermediate-to-advanced office software skills development.
• Microsoft Office Specialist (MOS) Certification Preparation: MOS Word Expert, MOS Excel Expert, MOS PowerPoint, MOS Access.

Optional Topics

• Industry-Context Emphasis: Medical office (medical-record-systems and EHR-adjacent work); legal office (legal document formatting and management); accounting context (Excel-intensive accounting applications).
• Contemporary Office Productivity Tools (Awareness): Microsoft Power Automate (workflow automation); Microsoft Power BI (business intelligence); productivity tools beyond core Office.
• Generative AI in Office Work (Awareness): Microsoft Copilot integration; appropriate AI-tool use in office settings; professional considerations.
• Cross-Platform Office Productivity (Awareness): Google Workspace alternatives; macOS/iOS office productivity.

Resources & Tools

• FLDOE Curriculum Framework: Florida Department of Education Administrative Office Specialist PSAV framework (program code B070330) documents.
• Most-adopted textbooks at Florida institutions: See the OTA0030C guide for foundational office-suite texts. Additional intermediate-level texts: Microsoft Office 365 In Practice by Nordell (McGraw-Hill — covers Office at intermediate-to-expert level); GO! with Microsoft Office Comprehensive by Gaskin (Pearson); Shelly Cashman Series Microsoft Office (Cengage); New Perspectives Comprehensive Microsoft Office by Shaffer, Carey, Parsons (Cengage).
• Microsoft Office Specialist (MOS) certification preparation: Microsoft official MOS exam preparation materials; LearnKey GMetrix MOS preparation (the most-widely-used dedicated MOS preparation platform); Microsoft Learn (free Microsoft training resources at learn.microsoft.com).
• Lab equipment (institution-provided): Computers with Microsoft Office (current version); printers and scanners; Microsoft 365 licensing for cloud-based collaboration practice; institutional access to MOS exam vouchers (where program supports certification testing).
• Online learning platforms: McGraw-Hill SIMnet (substantial — among the most widely-used office-software practice platforms); Cengage MindTap; Pearson MyLab IT; LearnKey GMetrix MOS preparation.
• Industry credentials sought during/after the program: Microsoft Office Specialist (MOS) Word Expert; MOS Excel Expert; MOS PowerPoint; MOS Outlook; MOS Access; Microsoft Office Specialist Master (achieved by passing Word Expert, Excel Expert, PowerPoint, plus Outlook or Access — the substantial Master credential many Administrative Office Specialist program graduates pursue); QuickBooks Certified User for accounting-track students.
• Career and Technical Student Organization: BPA (Business Professionals of America) — substantial Florida participation; FBLA (Future Business Leaders of America) for high-school career-cluster students.
• Online resources: Microsoft Learn (free Microsoft training); GCFLearnFree.org (substantial free office-software tutorials); LinkedIn Learning office-software courses; YouTube Excel/Word/PowerPoint tutorial channels (ExcelIsFun, MyOnlineTrainingHub, Leila Gharani for Excel; Microsoft Office YouTube channels).
• Tutoring and support: Institution business-program tutoring; faculty office hours; institutional BPA chapters; peer practice partnerships.

Career Pathways

OTA0043C plus prior OTA0030C completion provides intermediate-to-advanced office-software competencies supporting employability for substantial range of administrative office positions. Direct career pathways are typically realized at full Administrative Office Specialist program completion. See the OTA0030C guide for comprehensive career-pathway overview. Specific considerations for OTA0043C content:

• Administrative Assistant (Mid-Level Entry) — direct administrative office work at major Florida employers.
• Office Coordinator — coordination roles requiring substantial office software competencies.
• Data Analyst (Entry-Level) — substantial Excel competencies developed in OTA0043C support entry-level data-analyst roles, particularly when combined with strong analytical skills.
• Microsoft Office Specialist Master — students who complete the comprehensive MOS examination suite (Word Expert, Excel Expert, PowerPoint, plus Outlook or Access) earn the MOS Master credential — a substantial differentiator in administrative-office hiring.
• Continued Progression Through Administrative Office Specialist Program — students continue through subsequent program courses for full Administrative Office Specialist credentials and the comprehensive 1,050-hour program completion.

Special Information

Program Position

OTA0043C is an intermediate-software module within the FLDOE Administrative Office Specialist PSAV program (B070330). See the OTA0030C guide for the comprehensive program structure overview.

Articulation

OTA0043C articulates within the Florida public-college system per SCNS conventions. Florida AS-Office Administration and AS-Business Administration programs typically award articulation credit for completed Administrative Office Specialist program courses. Combined with substantial MOS certifications, articulation credit at AS-Office Administration programs is typically substantial.

Course Format and Hours

OTA0043C is delivered as a clock-hour PSAV integrated lecture-and-laboratory course. Specific contact hours vary by institutional implementation but typically reflect a substantial intermediate-software module within the comprehensive 1,050-hour Administrative Office Specialist program — commonly in the range of 150-200 contact hours. The course is widely offered in face-to-face, hybrid, and fully online formats.

Credits

OTA0043C is a 0-credit PSAV clock-hour course. Per Florida convention, PSAV courses are measured in clock hours rather than college credits.

Course Code Variations

Florida institutions consistently use OTA0043C for this PSAV course. Some institutions use the format "OTA 0043C" or "OTA0043" with or without the "C" suffix. Course titles include "Computer Applications," "Office Software Applications," "Advanced Office Applications," and similar variations. Students should verify specific institutional course title and content with the program advisor.

Office Software Versions

Microsoft Office software versions update regularly; OTA0043C content reflects the most-currently-supported version at delivery time. The substantial cross-version skill transfer in Microsoft Office means students develop competencies that transfer across versions.