Computer Applications

Course Description

CGS2100C – Computer Applications is a 3-credit course covering the productivity software that essentially every professional role assumes competence in: word processing, spreadsheets, databases, and presentation software. It is a common general education or program requirement across business, health, and technical programs in Florida.

The course is frequently underestimated. Students arrive fluent with phones and web applications and assume that transfers to desktop productivity software. It does not — particularly for spreadsheets, where the gap between casual familiarity and genuine competence is large and professionally consequential.

Content typically covers word processing beyond basic typing: styles, sections, headers, templates, mail merge, tracked changes, and long-document management. Spreadsheets receive the heaviest emphasis — formulas and functions, absolute versus relative references, logical and lookup functions, charts, sorting and filtering, pivot tables, and data analysis. Databases cover tables, relationships, queries, forms, and reports, and the underlying idea that structured data is not a spreadsheet. Presentation software covers effective design as well as mechanics.

Most versions also cover file management, cloud storage and collaboration, digital literacy topics including security and privacy basics, and increasingly the integration between applications.

Instruction is hands-on and assessment is typically performance-based — students produce documents rather than answer questions about them. Many Florida institutions deliver the course through a training and assessment platform such as SIMnet or MyLab IT.

Offered at approximately 15 Florida institutions under this number, with related numbers widely used elsewhere.

Learning Outcomes

Required Outcomes

• Manage files and folders, and use cloud storage and collaboration tools effectively.
• Create and format professional documents using styles, sections, and templates.
• Produce long documents with headers, footers, references, and automated elements.
• Perform a mail merge and use collaboration features including tracked changes and comments.
• Build spreadsheets using formulas and built-in functions.
• Apply absolute and relative cell references correctly.
• Use logical, lookup, and statistical functions to solve business problems.
• Create and format charts appropriate to the data and the message.
• Sort, filter, and summarize data, including with pivot tables.
• Design a relational database with tables and relationships.
• Construct queries, forms, and reports to retrieve and present data.
• Create effective presentations applying design principles rather than defaults.
• Integrate content across applications appropriately.
• Apply basic digital security and privacy practices.

Optional Outcomes

• Use macros or basic automation.
• Apply data validation and spreadsheet auditing techniques.
• Describe accessibility requirements for documents and presentations.
• Prepare for a Microsoft Office Specialist certification examination.
• Use collaborative platforms such as Teams or SharePoint.
• Evaluate the use of AI assistants embedded in productivity software.

Major Topics

Required Topics

• Operating system and file management — organization, search, and cloud storage.
• Word processing fundamentals — formatting, styles, and document structure.
• Advanced word processing — sections, references, templates, mail merge, and collaboration.
• Spreadsheet fundamentals — structure, formatting, and basic formulas.
• Cell references — relative, absolute, and mixed; why this is where most errors originate.
• Functions — mathematical, statistical, logical (IF), and lookup (VLOOKUP/XLOOKUP).
• Charts and visualization — selection, construction, and honest representation.
• Data management — sorting, filtering, conditional formatting, and pivot tables.
• Database concepts — tables, fields, records, keys, and relationships.
• Database operations — queries, forms, and reports.
• Presentation software — slide design, hierarchy, and delivery.
• Integration — moving data between applications.
• Digital literacy — security, privacy, and appropriate professional use.

Optional Topics

• Macros and automation.
• Data validation and auditing.
• Document accessibility.
• Microsoft Office Specialist certification preparation.
• Collaboration platforms.
• AI assistants in productivity software.

Resources & Tools

• Microsoft Office 365 — Word, Excel, Access, and PowerPoint; most Florida institutions provide student licensing.
• Shelly Cashman Series: Microsoft Office 365 (Cengage) or Exploring Microsoft Office (Pearson) — the common text families.
• SIMnet or MyLab IT — training and assessment platforms used by many Florida institutions for hands-on grading.
• Microsoft Learn — free official training modules.
• Free alternatives — LibreOffice and Google Workspace, useful for practice, though coursework generally requires Microsoft applications.
• Microsoft Office Specialist (MOS) certification — several Florida institutions embed or offer it.

Career Pathways

This is a foundational competency course rather than an occupational one, but the skills are assumed in essentially every professional role:

• Administrative and office roles (SOC 43-6014, 43-9061) — where these are the primary tools.
• Business and financial roles — spreadsheet competence is a hiring screen in accounting, finance, and analysis.
• Health information and medical office roles — documentation and data handling.
• Data Analyst — Excel remains the entry point before specialized tools.
• Any supervisory or management role — budgets, reports, and presentations.

Employers routinely test spreadsheet skills at interview. A candidate who can build a lookup and a pivot table without help is measurably more employable than one who cannot, in fields with no other computing requirement.

Special Information

Course-code and title variation

The course appears as CGS2100 and CGS2100C, and under the titles Computer Applications, Microcomputer Applications for Business (Tallahassee State), and Introduction to Computer Applications. Under SCNS the same number at the same level is equivalent regardless of title. Related numbers — CGS1100, CGS1000 — exist at some institutions with overlapping content but are not automatically interchangeable; confirm which number a degree program requires.

General education and computer competency

At many Florida institutions this course satisfies a computer literacy or competency requirement, and some allow it to be met by examination instead. Students who already have strong skills should ask whether a proficiency examination or credit-by-exam option exists rather than sitting the course.

Spreadsheets are the part that matters, and the part students underestimate

Worth stating plainly. Word processing and presentation skills are broadly held; genuine spreadsheet competence is not, and it is what employers actually screen for. The specific things that separate competent users from casual ones are absolute versus relative references, lookup functions, and pivot tables — each of which is unintuitive on first encounter and each of which is routinely required in business roles. Students who focus their effort here get disproportionate return.

Assessment is performance-based

Most versions grade by having students produce actual files, often within a platform that checks the work automatically. This means the course cannot be passed by reading — it requires doing the exercises. Students who fall behind in a hands-on course of this kind find it hard to recover, because the skills are cumulative.