Advanced Computer Software Applications

Course Description

Advanced Computer Software Applications examines sophisticated capabilities and features of personal computing software. Students develop proficiency with advanced functionalities in word processing applications, spreadsheet programs, and database management systems.

Within the SCNS taxonomy, OST is the Office Systems Technology prefix. Daytona State publishes this as OST2713 at 3 credits, offered spring. ⚠ The single term of offering is worth planning around.

Of the three applications in this course, the spreadsheet is the one with real labour-market value, and it is the one most people are worst at. Nearly everyone can enter numbers and total a column; very few can build a model someone else can audit, or diagnose why a workbook that worked for three years suddenly produces a wrong figure. That gap is where the pay difference sits — and the note below on why spreadsheets fail is the most useful content in this guide.

⚠ Two contact-hour figures apply here — make sure you use the right one

Daytona State publishes the unsuffixed form of this course at 3 credits, which at its lecture convention of 15 contact hours per credit gives approximately 45 hours — CEN4010, CEN3722, CNT2402, OST2401 and CGS1570 are all live at 3 credits and 45 hours.

The queued number carries a C suffix, which marks a combined lecture-and-laboratory course and normally implies scheduled laboratory time on top of the lecture. The figure shown in this guide is therefore priced at the combined-course convention of 20 contact hours per credit, giving 60 — the ratio this repository records consistently for C-suffixed courses across ETD, ETS, CTS and other prefixes.

⚠ Both figures are given deliberately. If you are looking at Daytona State's unsuffixed course, 45 is the figure; if you are looking at the C-suffixed course at another institution, 60 is the estimate and the offering institution's own catalog is authoritative. Confirm before relying on either.

Learning Outcomes

Required Outcomes

• Use advanced word processing features to produce long documents.
• Apply styles and manage document formatting consistently.
• Generate tables of contents, cross-references, and indexes.
• Use sections, headers, footers, and page numbering correctly.
• Use track changes, comments, and document comparison.
• Perform a mail merge from a data source.
• Create and use templates and forms.
• Protect and share documents appropriately.
• Structure spreadsheet data so that it can be analysed.
• Write formulas using absolute and relative references correctly.
• Use lookup and reference functions.
• Use logical, text, and date functions.
• Build and interpret pivot tables.
• Apply conditional formatting and data validation.
• Use named ranges and structured tables.
• Audit a workbook and trace formula dependencies.
• Diagnose and correct spreadsheet errors.
• Protect worksheets and control input.
• Import, clean, and transform external data.
• Create charts that represent data honestly.
• Design a database table structure appropriate to the data.
• Build queries, forms, and reports in a desktop database.
• Describe when a spreadsheet should become a database.
• Integrate data between applications.

Optional Outcomes

• Describe macros and introductory automation.
• Describe collaboration and cloud versions of the applications.
• Describe accessible document and spreadsheet design.
• Describe advanced data analysis add-ins.
• Describe version control practice for documents and workbooks.
• Prepare for a Microsoft Office Specialist examination.

Major Topics

Required Topics

• Advanced word processing
• Styles and consistent formatting
• Tables of contents and cross-references
• Sections, headers, and pagination
• Track changes and comparison
• Mail merge
• Templates and forms
• Document protection and sharing
• Spreadsheet data structure
• Absolute and relative references
• Lookup and reference functions
• Logical, text, and date functions
• Pivot tables
• Conditional formatting and validation
• Named ranges and tables
• Formula auditing
• Error diagnosis and correction
• Worksheet protection
• Importing and cleaning data
• Honest charting
• Database table design
• Queries, forms, and reports
• When a spreadsheet should become a database
• Integration between applications

Optional Topics

• Macros and automation
• Cloud collaboration
• Accessible design
• Analysis add-ins
• Version control for documents
• Microsoft Office Specialist certification

Resources & Tools

• The software itself, and daily use of it — office application fluency comes from hours, and students frequently have free or heavily discounted access to the full professional suite through the college.
• Microsoft Learn and the application's own help — free, current, and better than most tutorials.
• Microsoft Office Specialist certification — employers name it in advertisements, testing centres are widely available, and it is one of the cheapest credentials that demonstrably affects hiring for administrative roles.
• Purdue OWL (owl.purdue.edu) — free; the best available reference on business and professional writing.
• Your college writing centre — free, and business writing is a skill that responds quickly to feedback.
• Real documents. Volunteer to produce a newsletter, a report, or a presentation for a club or a community organisation — a portfolio of real work beats any exercise.

Career Pathways

• Executive secretary and executive administrative assistant — SOC 43-6011.
• Secretaries and administrative assistants — SOC 43-6014; a very large occupation, and one where demonstrated software fluency separates candidates immediately.
• Medical secretary and administrative assistant — SOC 43-6013; a substantial Florida sector.
• Legal secretary and administrative assistant — SOC 43-6012.
• Office and administrative support supervisor — SOC 43-1011; a realistic progression.
• Office manager and business operations support.
• Human resources, accounting, and project support roles — administrative experience plus software fluency is a common route into all three.
• Data entry, records, and information management.
• Customer service and client-facing coordination roles.
• ⚠ The pathway upward runs through added skill, not through time served. Certification, advanced spreadsheet ability, and specialised terminology — medical or legal — are what move people from entry-level administrative work into better-paid roles.

Special Information

⚠⚠ Spreadsheet errors are endemic, consequential, and structural

• Studies of working spreadsheets consistently find errors in a large majority of them, and real organisations have lost enormous sums to spreadsheet mistakes that nobody caught because nobody could audit the workbook.
• ⚠⚠ The root cause is almost always data structure, not formulas. One row per record, one column per field, no merged cells, no blank rows as separators, and no formatting carrying meaning — a workbook built that way can be sorted, filtered, pivoted and checked; one that is not cannot be.
• ⚠ Never let colour or bold be the only record of something. If a highlighted row means "approved", put "approved" in a column — formatting is invisible to every formula and is lost the moment anyone copies the data.
• Separate inputs, calculations, and outputs. A number typed into the middle of a formula is a value nobody will ever find again — put assumptions in labelled cells and refer to them.
• Do not repeat a formula that could reference one cell. The same constant in forty places will be updated in thirty-nine.
• ⚠ Use lookups rather than manually aligning two lists. Sorting one list and not the other is a silent, devastating error and it is extremely common.
• Check the totals independently. Recompute a figure a different way and compare — and be suspicious when a number changes and you do not know why.
• ⚠ Watch the ranges when you insert rows. A sum that stops one row short of the data is the classic error, and it looks perfectly plausible.
• Protect input cells and validate entries so users cannot overwrite formulas or enter impossible values.
• Document what the workbook does, on a sheet inside it. The person maintaining it will be someone else, or you having forgotten everything.

⚠ Know when a spreadsheet has stopped being the right tool

• Spreadsheets are excellent for analysis and modelling and are poor as databases, and a great deal of organisational pain comes from one being used as the other for years.
• ⚠ The warning signs: multiple people needing to edit at once; the same entity appearing in several sheets; a file that has become slow; copies circulating by email; and anyone asking "which version is the current one?"
• Duplicate data is the fundamental problem. The same customer in three sheets will eventually disagree with itself, and nothing in a spreadsheet prevents that.
• A database enforces rules; a spreadsheet asks politely. Constraints, required fields, and referential integrity are exactly what a workbook cannot give you.
• ⚠ Version control by filename does not work. "Budget_final_v3_REVISED_new.xlsx" is a system that has already failed — use a shared location with real version history.
• Keep one authoritative copy. Emailing workbooks around creates parallel truths immediately.
• Structure the data as though it might become a database, because it might — and a clean flat table imports in minutes while a formatted report does not import at all.
• ⚠ Do not put personal or sensitive data in a workbook that will be emailed. Spreadsheets are forwarded without thought, and hidden rows, hidden sheets, and filtered-out data are all still in the file.

⚠⚠ The queued number carries a C suffix that Daytona State does not

• The statewide inventory carries this course as OST2713C. Daytona State publishes it as OST2713, titled "Advanced Computer Software Applications", with no C suffix — and the C-suffixed URL does not resolve in its catalog.
• ⚠⚠ Under Rule 22 the C suffix is part of the course number, and equivalency does not cross it. OST2713C and OST2713 are distinct SCNS numbers, so credit for one does not automatically satisfy a requirement written for the other.
• The suffix normally signals a combined lecture-and-laboratory structure. An institution publishing the C form may therefore run it with scheduled laboratory time and a different credit or contact-hour value from Daytona State's.
• The figures in this guide are Daytona State's. Confirm the credit value, structure, and prerequisites with the institution you are actually enrolling at or transferring to.
• Raise it in advance if you are transferring in either direction. Departments resolve this routinely when asked early and badly when asked at registration.

How Florida course levels affect transfer

The first digit of an SCNS number denotes the year of offering, not transferability. Courses at the 1000 and 2000 levels transfer transparently between Florida public institutions, and 3000 to 4000 is unproblematic since both are upper division. The boundary that actually matters is 2000 to 3000, where lower-division credit generally cannot satisfy an upper-division requirement — and it is live here, since Daytona State offers both associate-level and bachelor of science coursework in these prefixes.

OST2713C is published by Daytona State as OST2713 at 3 credits and approximately 45 contact hours, offered spring.

⚠ Note the suffix divergence — see the note above.