Study sheet: Productivity Software Fundamentals

📋 Course Outline

1. Core Productivity Applications
2. Installing Applications Safely
3. Updating Applications Regularly
4. Word Processing Software
5. Spreadsheet Software
6. Presentation Software
7. Choosing and Practicing Applications

📖 1. Core Productivity Applications

🔑 Key Concepts & Definitions

• Word processing : the creation, formatting, and editing of text-based documents such as essays, letters, resumes, and reports.
• Spreadsheet software : organizes data into rows and columns so users can calculate, analyze, and visualize it.
• Presentation software : creates visual slides that communicate ideas to an audience.

📝 Essential Points

• Microsoft Word and Google Docs are examples of word processing software, Microsoft Excel and Google Sheets are examples of spreadsheet software, and Microsoft PowerPoint and Google Slides are examples of presentation software.

💡 Memory Hook

WEP: Word, Excel, Presentations

📖 2. Installing Applications Safely

★ Must-know

• 🔄 Installing an application involves:
  1. obtaining it from an official source
  2. checking system requirements
  3. signing in or activating it
  4. running the installer

📌 Applications should be downloaded from the publisher's site, Microsoft Store, or Google Play rather than from an unknown link.

Further detail

• Before installation, the operating system version and available free storage must meet the application's minimum requirements.

• 🔄 The setup wizard usually requires:

  1. accepting the license
  2. choosing an installation location
  3. allowing the application to install

💡 Memory Hook

Source → requirements → activation → installer

📖 3. Updating Applications Regularly

★ Must-know

📌 Applications should be updated because updates fix bugs, patch security holes, and add new features.

• Manual update checks can be found under:
  • File → Account → Update Options
  • Microsoft Store → Downloads and updates
  • System Settings → Software Update on macOS

Further detail

• Most applications install updates automatically in the background by default.

📌 Some updates require closing and reopening the application before installation is complete.

💡 Memory Hook

Updates fix bugs and security holes → safer, more capable software

📖 4. Word Processing Software

★ Must-know

• Core word processing features include:
  • text formatting
  • styles
  • spell-check
  • page layout

📌 Using styles and headings is preferable to manually formatting every line because styles provide consistent headings and formatting in one click.

Further detail

• Word processing tools can provide:
  • tables
  • images
  • page breaks
  • headers
  • footers
  • word counts
  • tracked changes

💡 Memory Hook

A document built from headings, text, tables, and images

📖 5. Spreadsheet Software

🔑 Key Concepts & Definitions

• Cell reference : identifies a cell by its column and row, such as cell B2 at the intersection of column B and row 2.

★ Must-know

• Spreadsheet software supports:

  • cells arranged in rows and columns
  • formulas
  • functions
  • charts
  • sorting
  • filtering

• Spreadsheet formulas always start with =, and =SUM(A1:A10) totals the values from A1 through A10.

Further detail

• The formula =B2*1.12 calculates the value in B2 plus 12% tax.

💡 Memory Hook

A grid of cells turning data into calculations and charts

📖 6. Presentation Software

★ Must-know

• Core presentation features include:
  • slide layouts
  • transitions
  • animations
  • speaker notes

📌 Effective slides should remain simple, with a few words rather than a wall of text.

Further detail

• A simple slide usually contains a title, a few bullet points, and a visual.

📌 Speaker notes should be used to remember what to say rather than placing the entire speech on the slide itself.

💡 Memory Hook

Simple slides support the speaker, whereas text-heavy slides compete with the speaker

📖 7. Choosing and Practicing Applications

📝 Essential Points

• Typical application-task matches are: essays and resumes — Word processing, monthly expenses and grade calculators — Spreadsheets, project pitches and visual research summaries — Presentations

• 🔄 The hands-on practice sequence is to: install an office suite, check each application for updates, create a one-page Word document with at least two heading styles, build an Excel table that totals a column with =SUM(), make a three-slide PowerPoint presentation with a title slide and one chart or image

💡 Memory Hook

Install → update → create with Word, Excel, and PowerPoint

📊 Synthesis Tables

Choosing the Right Application

Application	Main purpose	Typical tasks
Word processing	Write and format text	Essays, letters, resumes, reports
Spreadsheets	Organize and calculate data	Budgets, grade trackers, inventories
Presentations	Communicate ideas visually	Pitches, portfolios, training decks