Video summary

OpenStax Workplace Software and Skills (Audiobook) - Ch. 2: Essentials of Software Applications...

Main summary

Key takeaways

Educational

Main Ideas and Lessons

1) What Software Is and Why It Matters

  • Hardware vs. software

    • Hardware is the computer’s “backbone,” but software is what enables work to get done.
    • Software programs allow people to interact with computers and perform tasks.

  • Terminology distinctions

    • Program: instructions that tell the computer how to run specific tasks.
    • Software: step-by-step instructions (a collection of programs) that operate the hardware and enable actions like printing, saving, or formatting.

  • Major categories

    • System software: supports the computer’s functioning (e.g., operating system, device drivers like printers/keyboard, antivirus).
    • Application software: task-oriented programs (e.g., word processing, presentations, internet browsers).

  • Core UI concepts found in most programs

    • GUI (Graphical User Interface): the part of software the user interacts with.
    • Ribbon / Tabs / Menu groupings
      • In Microsoft apps: tabs and a ribbon organize commands.
      • In Google Workspace: menus organize commands.
    • Menu bar / ribbon: top area with general commands (e.g., font changes, printing, adding objects).
    • Toolbar: row with icons for commonly used actions (e.g., copy, save).
    • Dialogue boxes: appear after actions; show extra options or request input.
    • Status bar: bottom area showing program status (e.g., page count).

2) Common Software Applications Used in Business

  • Task-oriented “core” applications

    • Word processing (text documents)
      • Examples: Microsoft Word, Google Docs
    • Spreadsheet (numeric data analysis)
      • Examples: Microsoft Excel, Google Sheets
    • Presentation (slideshows)
      • Examples: Microsoft PowerPoint, Google Slides
    • Database (organize/store/filter large datasets)
      • Example: Microsoft Access

  • Specialized applications

    • Examples:
      • QuickBooks (accounting/taxes-related use)
      • Engineering design tools (discipline-specific)
      • Tax preparation software
      • Desktop publishing (mix text + graphics)
        • Examples: Adobe InDesign, Microsoft Publisher

  • Mobile apps

    • Apps designed for phones/tablets (e.g., e-readers).

  • Social media applications

    • Used to create networks/communities and share content.
    • Example mentioned: LinkedIn (professional networking).
    • Social media supports virtual collaboration and marketing; legacy platforms referenced include MySpace, Facebook, Instagram, TikTok, Twitter/X.

3) Installing and Maintaining Software (Method + Key Cautions)

Installation: Basic Process

  • Where you obtain software

    • Usually start by visiting the software website and using a Download button/link.
    • Some software is free; some is cloud-based (you install/access an app rather than fully downloading).
    • Less common: installation via CD-ROM (insert disc triggers installer).

  • What happens during installation

    • Installation commonly begins after downloading a folder containing:
      • Readme file (installation steps + system requirements)
      • Actual installer file (often .exe on Windows)
    • Click the installer (e.g., .exe) to begin.
    • You’ll see approval prompts such as:
      • consent to make changes/add files
      • closing other programs
      • agreeing to usage of the software
    • You may choose basic vs. customized installation (basic is usually recommended).

  • Important safety guidance

    • Research and download only from trusted sites.
    • Watch for options that bundle additional software/features (often unnecessary and potentially harmful).

  • Platform note

    • .exe files are for Windows; Macs use formats like .dmg.

Maintenance: Updates and Troubleshooting

  • Maintenance

    • Developers regularly check for issues and release updates.
    • Updates improve:
      • security
      • functionality

  • Update options

    • Automatic updates or manual check.
    • Many programs notify you when updates are available.

  • Troubleshooting

    • Use built-in Help resources first.
    • If unresolved, contact the software company via:
      • registration support
      • email
      • phone customer service
      • in-program chat

4) Files and Folders: Organization and Best Practices (Checklist)

Why Organization Matters

  • Disorganized work causes:
    • lost productivity
    • wasted resources
    • reputational harm
  • A staffing study is referenced:
    • ~6 hours/week lost due to poor organization
    • potential annual employer cost up to ~$10,000 per employee earning $50,000

Definitions and Structure

  • File: a collection of data (documents/programs).
  • Folder: a container that holds files and subfolders; organizes files hierarchically.

Four File Types Commonly Used in the Course

  • Document files (word processing)
    • Examples: memos, letters, reports
  • Spreadsheet files (numeric analysis + recordkeeping)
    • Examples: chart/data sheets in Excel/Sheets
  • Database files (large organized datasets)
    • Example: Microsoft Access
  • Presentation files (slides/handouts)
    • Examples: PowerPoint/Slides

Steps/Methods for Organizing Files (Best Practices)

  • Choose a system that works for you.
  • Use descriptive folder names and stay consistent.
  • Use subfolders under main folders when helpful.
  • Put newly created files into the correct folder immediately.
  • Delete or archive files/folders you no longer need.
  • Possible organization approaches (pick one or combine):
    • by type (e.g., all Word docs together)
    • by date
    • by project
    • by client (workplace example)
  • Effective naming conventions:
    • use specific, informative names (avoid generic abbreviations)
    • keep version naming consistent (e.g., version number + date)
  • Desktop rule:
    • Desktop can help for quick access, but too many items reduce findability—prefer folders.

Opening Files (Navigation + Tools)

  • Locate via:
    • local storage (hard drive)
    • cloud storage
    • external drives (e.g., flash drive)
  • Windows: File Explorer / search
  • Mac: Finder / Documents tab

Creating Files

  • Usually start in an application (e.g., PowerPoint/Slides).
  • Or create via desktop shortcut:
    • Right-click desktop → New → choose file type
  • Mac equivalent uses Finder.

Saving Files (Methods and When to Use Each)

  • Save
    • first save or subsequent incremental saves in the same location/type.
  • Save As
    • rename and/or change format and location.
    • useful for maintaining revisions/versions and storing in different places.
  • AutoSave
    • continuously saves as changes are made (reduces need to remember).

Moving and Deleting Files

  • Delete
    • Right-click → Delete → confirm OK
    • Select multiple files:
      • Shift for a continuous range
      • Control (Ctrl) for non-adjacent selections
  • Mac deletion
    • Moves to Trash; permanent deletion requires emptying Trash.
  • Move
    • drag-and-drop, or cut/paste via menus (use caution during cut/paste).

Recovering Deleted Files (Options)

  • Check Recycle Bin/Trash and restore from the dialogue option.
  • Search for the file in File Explorer/Finder.
  • Windows File History (if enabled).
  • Mac Time Machine (if enabled).
  • Optional: third-party recovery apps (mentioned but not emphasized).

Compressing/Extracting Files (When Needed)

  • Use compression when a file is too large for email attachments.

  • Compression produces zipped files.

  • Compress (Windows)

    • Right-click file(s) → “Send to” → Compressed (zipped) folder
  • Extract (Windows)
    • Right-click zipped folder → Extract all
    • Or open one extracted file and drag it out
  • Mac compression
    • Control-click file → Compress

5) File Types and Extensions (Key Concepts + Examples)

  • Files have extensions that identify their format and intended application.
  • Examples highlighted:
    • TXT: plain text, minimal formatting
    • DOCX: Word documents
    • XLSX: Excel spreadsheets
    • PPTX: PowerPoint presentations

Other Formats Mentioned

  • RTF (Rich Text Format)
    • Older “exchange” format (often easier compatibility).
    • Less capable than DOCX (may not preserve all features).
  • PDF
    • Publishing format designed to preserve layout and formatting.
    • Less editable; consistent appearance across devices.
    • Common for resumes and annual reports.
  • HTML
    • Web page content format; Word can export as HTML.
  • Graphics/media formats
    • JPEG: common, smaller size, possible quality loss after repeated compression
    • PNG: higher quality, better for complex backgrounds (larger storage)
    • GIF: best for simple, limited-color graphics
    • SVG: vector illustrations; keeps quality when resized
    • MP4: video format; can include audio/subtitles

Best Practices for Versions and Format Choices

  • Save in appropriate formats for the audience/workflow:
    • PDF for publishing/preserving formatting
    • DOCX for editing
  • Use consistent versioning (change names reliably; don’t rely on memory).

6) Communication Software and Digital Collaboration

Types of Communication Technologies (3 Categories)

  • Email
  • Instant chat messaging
  • Video conferencing

Advantages and Limitations (Conceptual Comparison)

  • Email
    • good for formal communication
    • not great for emotion clarity
  • Instant messaging
    • fast, but may not preserve full conversation history
    • less formal; messages can be abbreviated
    • not ideal for critical/strategic discussions
  • Video conferencing
    • supports face-to-face feel virtually
    • engagement may drop if cameras are off
    • can be harder to interject in large groups

Digitized Workplace Collaboration Challenges

  • Building trust
  • Scheduling across time zones (multinational support noted)
  • Language/cultural barriers (translation capabilities and cultural/language training suggested)

Workplace Communication Best Practices (Checklist)

  • Know your audience (peer vs manager changes tone/approach)
  • Know your objective (inform vs persuade)
  • Use an appropriate formality level
  • Consider timing (avoid sending critical info at poor times)
  • Proofread/spellcheck; read aloud when needed
  • Be mindful of privacy/recording: communication on company equipment can be recorded and is company property

Email Structure and Features

  • Email components:
    • To
    • CC
    • BCC
    • Subject
    • Body
    • Attachments
  • CC meaning:
    • recipients can see who else was copied

  • BCC meaning:

    • recipients don’t see who else was BCC’d; used for confidential notifications (not casually)

  • Reply options:

    • Reply: to sender only
    • Reply All: sender + all CC/BCC recipients (use carefully)
    • Forward: send original email onward

  • Professional email style:

    • formal tone
    • concise body
    • descriptive subject line
    • greeting + closing + signature
    • attachments used for long content

Examples of Communication Applications

  • Email: Outlook (Microsoft), Gmail (Google)
  • Instant messaging: Microsoft Teams, Slack
  • Calendars: Outlook Calendar, Google Calendar
  • Video conferencing: Google Meet, Zoom, FaceTime
    • Also mentioned: Microsoft Teams meetings and Zoom as virtual collaboration tools

Calendar Features and Ethics (Privacy)

  • Use cases:
    • combine personal + business schedules
    • share availability
    • block unavailable time
    • schedule meetings with others
    • manage tasks + reminders
  • Privacy guidance:
    • adjust permissions so some people see only limited info (or nothing)
    • mark an appointment as private
  • Syncing:
    • link calendars across devices/apps (phone/work/personal)

7) Microsoft 365 and Google Workspace: Access + Menu/Navigation Concepts

Microsoft 365 Overview (Key Points)

  • Microsoft introduced Office in 1990; later versions evolved into Microsoft 365.
  • Microsoft 365 includes:
    • subscription-based access
    • cloud-enabled access from anywhere
    • OneDrive for storage and syncing
  • Apps mentioned: Word, Excel, PowerPoint, Access, Outlook, Teams (plus collaboration).
  • Ribbon UI concept:
    • organized into tabs and command groups
    • backstage view (“welcome screen” when no specific file is open) includes file properties/metrics

Microsoft App Menus/Tabs Commonly Described

  • Home: clipboard, font, paragraph, styles, etc.
  • Insert: images, tables, links, equations, symbols
  • Design: themes/custom looks
  • Layout / Page Layout: margins, spacing, orientation, print area
  • Review: spelling, comments, compare/track changes
  • View: display/layout/zoom modes
  • Help: search training/support
  • Keyboard shortcuts:
    • Windows: generally Ctrl-based
    • Mac: uses Command

Google Workspace Overview (Key Points)

  • Google Workspace is cloud-only (not installed locally).
  • It has free and paid tiers for business features and storage.
  • Strong auto-save behavior:
    • edits autosave to the cloud
    • version history allows restoring earlier versions
  • Access:
    • via Google account + web browser/Chrome
    • app launcher (9-dot menu)

Google Workspace Menu Structure (Conceptual)

  • Menus instead of ribbons:
    • File, Edit, View, Insert, Format, Tools, Add-ons/Extensions, Help
  • File menu highlights:
    • New, Open, Make a copy, Share, Email, Download, Rename, Move to trash,
    • Version history, Make available offline, Details, Page setup/print
  • Collaboration:
    • share with specific people and set permissions:
      • viewer / commenter / editor (plus restrictions like download/print/copy)
    • version history records changes
    • link sharing options: public vs restricted
  • Drive:
    • where files live; accessible via browser or sync as a local network drive

Main Speakers/Sources Featured (as Named in the Subtitles)

  • Wasant Techch (credited source)
  • Microsoft (credited source; cited for figures and UI)
  • Wintech Chat/Flicker CC (credited source)
  • IAEA Image Bank / Flickr (COP26 image credit)
  • IAEA staff (credited context for COP26 image)
  • Ray Tomlinson (credited as inventor of email; referenced in a history segment)
  • Google LLC (referenced as trademark/source for Google Workspace, Gmail, etc.)
  • Slack Technologies LLC (referenced as copyright/source)
  • Express Employment Professionals (referenced study for productivity loss due to poor organization)
  • Scientific American (referenced as a suggested viewing link about the cloud)
  • GoDaddy (example of hosting service)
  • Zoom / Zoom Video Communications (referenced as a video conferencing tool)
  • LinkedIn (mentioned as an example)
  • Facebook / Instagram / TikTok / Twitter (X) / MySpace (mentioned as examples/history of social media platforms)
  • Bolt Baneic and Newman (organizational reference tied to Ray Tomlinson’s work)
  • Department of Defense (credited as first email user organization)

Original video