Microcomputer Applications

Course Description

CGS1100C – Microcomputer Applications is a 3-credit, integrated lecture-and-lab course providing hands-on training in the productivity software most commonly required in business, healthcare administration, government, education, and other professional contexts. The course focuses on the Microsoft Office suite (Word, Excel, PowerPoint, and often Access), with significant time devoted to file management, advanced features, and the integrated use of multiple applications. Some institutions also cover Internet research, email, presentation skills, and current technology issues. The course is often subtitled "for Business and Economics" reflecting its workplace orientation.

The course sits within the Florida Statewide Course Numbering System (SCNS) under Computer and Information Sciences: General > Computer Applications and is offered at approximately 20 Florida public institutions. CGS1100C satisfies general-education or major-required computing requirements at many Florida programs in business, accounting, healthcare administration, allied health, and education. The course is widely available in face-to-face, hybrid, and fully online formats. Online sections typically deliver content via Cengage SAM (Skills Assessment Manager) or similar platforms with hands-on Office assignments graded automatically.

CGS1100C and CGS2100 are parallel SCNS codes for very similar content: CGS1100C is used at FSCJ, SPC, College of Central Florida, UNF, St. Johns River State College, and many Florida College System institutions following the 1xxx convention; CGS2100 is used at FSU, FIU, and other SUS institutions following the 2xxx convention. Both transfer cleanly between Florida institutions.

Learning Outcomes

Required Outcomes

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

• Apply file management skills: navigate the operating system; organize files and folders; manage cloud storage (OneDrive, Google Drive); back up data.
• Create, edit, and format professional-quality word-processing documents using Microsoft Word: text formatting; paragraph and page formatting; styles; tables; lists; headers and footers; references and citations; mail merge; document review and collaboration.
• Create, edit, and analyze spreadsheets using Microsoft Excel: cell formatting; formulas and functions (arithmetic, statistical, logical, lookup, financial); charts and graphs; conditional formatting; data sorting and filtering; PivotTables; data validation; what-if analysis.
• Create and deliver effective presentations using Microsoft PowerPoint: slide design and layout; themes; graphics and SmartArt; transitions and animations; speaker notes; presentation delivery and navigation.
• Apply integration skills across applications: linking and embedding objects; copying data between Word, Excel, and PowerPoint; mail merge from Excel data; preparing integrated business-style deliverables.
• (At many institutions) Create and use databases using Microsoft Access: tables and table design; relationships; queries; forms; reports.
• Apply effective workplace document conventions: business letter format; memo format; report format; resume and cover letter formats; presentation conventions for business audiences.
• Use cloud-based productivity tools: Microsoft 365 (cloud version); Google Workspace alternatives; collaboration features; version control.
• Demonstrate computer literacy concepts at a foundational level: basic hardware and software vocabulary; networks and Internet; computer security basics.
• Apply safe and ethical computing practices: password management; recognizing phishing and other threats; respecting copyright and intellectual property; appropriate workplace behavior with technology.
• Use online learning platforms effectively: Canvas, D2L, Blackboard navigation; submitting assignments through SAM or similar platforms; participating in online discussions.

Optional Outcomes

• Apply advanced Excel features: macros and basic VBA; advanced data analysis; financial modeling.
• Apply advanced Word features: long-document management; advanced styles and templates; document review with track changes.
• Apply advanced Access features: complex queries; relationship management; reporting.
• Engage with industry certifications: Microsoft Office Specialist (MOS) preparation.
• Engage with workplace AI tools: Microsoft Copilot integration; AI-assisted writing and analysis at workplace-appropriate level.

Major Topics

Required Topics

• Computing Basics and File Management: Operating system navigation; file and folder organization; file naming conventions; cloud storage (OneDrive, Google Drive); backup strategies.
• Microsoft Word — Foundations: Creating and saving documents; text formatting (font, size, color, emphasis); paragraph formatting (alignment, indents, spacing); page formatting (margins, orientation, breaks); spell check and grammar; printing and exporting.
• Microsoft Word — Intermediate and Advanced: Styles and themes; tables; lists (bulleted, numbered, multilevel); headers and footers; references and bibliographies; mail merge; collaboration with track changes and comments.
• Microsoft Excel — Foundations: Workbook and worksheet structure; entering and editing data; cell formatting; arithmetic operations; basic functions (SUM, AVERAGE, MIN, MAX, COUNT); copying and moving data; printing.
• Microsoft Excel — Intermediate: Relative vs. absolute references; logical functions (IF, AND, OR); statistical functions; lookup functions (VLOOKUP, HLOOKUP, XLOOKUP); date and time functions; conditional formatting; sorting and filtering.
• Microsoft Excel — Charts and Analysis: Chart types and selection; chart formatting; data tables; what-if analysis (Goal Seek, Scenarios); PivotTables and PivotCharts at an introductory level.
• Microsoft PowerPoint: Creating presentations; slide layouts and themes; text and content; images and SmartArt; transitions and animations; speaker notes and handouts; effective slide design principles; presentation delivery.
• Application Integration: Linking and embedding (OLE); copying between applications; mail merge from Excel to Word; chart integration into Word and PowerPoint.
• Microsoft Access (at Most Institutions): Database concepts; tables and field design; relationships between tables; queries (select, parameter, action); forms; reports.
• Workplace Document Conventions: Business letters; memos; reports; resumes and cover letters; presentation conventions; effective use of formatting for clarity and professionalism.
• Cloud-Based Productivity: Microsoft 365 cloud features; collaboration; OneDrive integration; Google Workspace alternatives.
• Computer Literacy Concepts: Hardware and software vocabulary; networks and Internet; security basics; copyright and intellectual property.

Optional Topics

• Advanced Excel: Macros and basic VBA; advanced data analysis; financial modeling and IRR/NPV functions; Solver.
• Advanced Word: Long-document management with sections; advanced styles and templates; advanced reference management; document protection.
• Advanced Access: Complex queries; advanced relationship management; advanced reports and forms.
• Microsoft Office Specialist (MOS) Preparation: Specific exam preparation for industry certification.
• AI-Augmented Productivity: Using Microsoft Copilot or other AI tools to enhance workplace productivity.

Resources & Tools

• Most-adopted textbooks and online platforms at Florida institutions: New Perspectives Microsoft Office series (Cengage) — used at FSCJ and many institutions; GO! with Microsoft Office series by Gaskin et al. (Pearson) — used at FSU and many institutions; Shelly Cashman Series Microsoft Office (Cengage) — older but still widely-used.
• Online learning platforms: Cengage SAM (Skills Assessment Manager) — the most widely-used auto-grading platform for Office; Pearson MyLab IT with Grader projects; SIMnet (McGraw-Hill); zyBooks Microsoft Office; institution Canvas modules.
• Software access: Most Florida institutions provide free access to Microsoft 365 (Office 365) for current students through institution accounts — students should not need to purchase Office separately. Public computer labs typically have Office installed. Mac users may face limitations with Grader projects; some institutions allow Boot Camp or VMware solutions, others require PC use for graded assignments.
• Practice resources: GCFLearnFree.org (free Office tutorials); Microsoft Learn (free); LinkedIn Learning (free via institution); YouTube Office tutorials (Leila Gharani, ExcelIsFun, Computergaga channels).
• Tutoring and support: Institution computer learning centers; library digital-literacy programs; faculty office hours; SAM/grader-tool technical support.

Career Pathways

• Administrative Assistant / Executive Assistant — Florida's substantial administrative workforce.
• Bookkeeper / Accounting Clerk — Florida small businesses and accounting firms.
• Medical Office Administrator / Medical Records — Florida's healthcare sector.
• Office Manager / Operations Coordinator — Florida small and mid-size businesses.
• Customer Service Representative — Florida's substantial service sector.
• Project Coordinator / Project Assistant — Florida construction, IT, healthcare.
• Real Estate Assistant / Transaction Coordinator — Florida real-estate sector.
• Hospitality and Tourism Office Roles — Florida's tourism economy.
• Government Office Roles — Florida state and local government clerks, technicians, and analysts.
• Education (K–12 Administrative Roles) — Florida school districts.
• Financial Services / Banking Operations — Florida banking and credit union sectors.
• Pathway into Business Bachelor's Programs — many Florida business programs require or recommend CGS1100C / CGS2100 as a foundation.

Special Information

Articulation and Transfer

CGS1100C articulates to all Florida SUS institutions. CGS1100C and CGS2100 are treated as equivalent for transfer purposes at most institutions. The course is required or strongly recommended in many Florida AA, AS, and BS programs in business, accounting, healthcare administration, and similar fields.

CGS1100C vs. CGS1060C vs. COP1000C

Florida offers three commonly-confused entry-level computing courses with distinct purposes:

• CGS1100C (this course) — Microcomputer Applications: deep hands-on practice with Microsoft Office (Word, Excel, PowerPoint, often Access). Best for students entering business, healthcare administration, office roles.
• CGS1060C — Introduction to Computers: broader conceptual literacy plus introductory Office practice. Best for general digital literacy.
• COP1000C — Introduction to Computer Programming: writing actual programs (typically Python). Best for students entering computer science, IT, or technical fields.

The three courses are typically not interchangeable for major requirements; students should confirm with their advisor.

CGS1100C vs. CGS2100

Florida institutions use parallel SCNS codes for essentially equivalent content:

• CGS1100C at FSCJ, SPC, College of Central Florida, UNF, and many Florida College System institutions.
• CGS2100 at FSU, FIU, and other SUS institutions.

Both transfer cleanly between Florida institutions; students should not assume their grade in one will automatically apply to the other for major requirements at the receiving institution.

Course Format and Workload

CGS1100C is typically a 3-credit integrated lecture-and-lab course meeting 3–4 hours per week, very widely offered in face-to-face, hybrid, and fully online formats. Expect: weekly textbook reading; weekly hands-on Office assignments graded through SAM or Grader (auto-graded based on file content); 4–10 SAM Projects per major application; 2–4 exams (often proctored). Out-of-class workload typically runs 5–8 hours per week. Hands-on practice is essential — students who only read about Office without practicing typically struggle with practical exams.

Software Compatibility Issues

Mac users sometimes face limitations with Grader-style assignments that require specific Office formatting checks. Some institutions allow Boot Camp / Parallels / VMware solutions; others require Windows-PC use for graded work; still others have moved to fully cloud-based assessments. Students should check the course technology requirements before purchasing equipment.

Course Code Variations

Florida institutions title this course "Microcomputer Applications," "Introduction to Microcomputer Applications," "Microcomputer Applications for Business and Economics," "Computer Applications," or "Information Systems." The course is consistently 3 credits across institutions.