Copy CS008 Quiz 2 (ch2/3)

Programming

The process that makes a computer a flexible general-purpose and powerful tool

Application Software

A program that performs a useful task for the user

Business productivity software

Software designed to help users perform business-related tasks efficiently

Office application suite

A collection of applications designed to work together with a common interface

Name three office application suites

Microsoft Office G Suite Google Drive

Word processing software

Software used to create edit and format text documents

Name common word processing features

Font formatting spell check grammar check comments change tracking

Name three word processing programs

Microsoft Word Pages Google Docs

Spreadsheet software

Software that creates electronic worksheets made of rows and columns

What are spreadsheets commonly used for?

Budgeting grade books inventory mathematical calculations

Name three spreadsheet programs

Microsoft Excel Numbers Google Sheets

Spreadsheet cell

The intersection of a row and a column

What can a spreadsheet cell contain?

Text numbers or formulas

Spreadsheet formula

A calculation that usually begins with an equals sign

Automatic recalculation

Results update automatically when data changes

Presentation software

Software used to create electronic slide presentations

Design template

Predefined colors fonts and layouts

Name three presentation programs

PowerPoint Keynote Google Slides

Database software

Software used to create and manage databases

Database

A collection of information organized for efficient retrieval

What is a table in a database?

A collection of related records arranged in rows and columns

What is a field in a database?

A single piece of information in a record

What is a record in a database?

One complete entry made of multiple fields

What can databases generate?

Queries and reports

PIM software

Personal Information Manager- Software used to manage email calendars and tasks

Name two PIM programs

Microsoft Outlook Google Calendar Gmail

What is accounting software used for?

Tracking finances invoicing payroll and reports

Name two accounting software programs

QuickBooks FreshBooks

Document management system

Software that stores manages tracks and audits documents

Why is storage important in a DMS?

Files are stored on servers or the web for access and security

What does checking out a document mean?

Locking it so only one user can edit

Name two DMS examples

SharePoint Dropbox Google Drive

Project management software

Software used to plan schedule and manage projects

Gantt chart

A chart showing project schedule and progress

CRM system

A system that tracks customer information and interactions

Why are CRM systems expensive?

They are highly customized and use analytics

Personal software

Software used by individuals often free or low cost

What does personal finance software do?

Tracks budgets bank accounts and investments

Name two personal finance programs

Quicken YNAB

Tax preparation software

Software for filing income taxes

Name two tax prep programs

TurboTax TaxAct

What is image editing software used for?

Editing photos such as cropping resizing and effects

Name two image editing programs

Photoshop GIMP

Media management software

Software that organizes and plays multimedia files

System requirements

Minimum hardware and software needed to run a program

What happens if system requirements are not met?

The software may not work properly or at all

Software license

Legal permission to use software

EULA

End User License Agreement

Retail commercial software

Software users pay to license

Open source software

Software with freely available source code that users can modify

Subscription software

Software paid for monthly or yearly

Freeware

Software that is free to use indefinitely

Shareware

Software that is free for a trial period

Freemium software

Free software with paid premium features

Web based application

Software that runs in a web browser without installation

Platform neutral

Works on any device with a supported browser and internet

Cloud computing

Processing and storage done over the internet

IaaS

Infrastructure as a Service providing hardware resources online

PaaS

Platform as a Service for building applications

SaaS

Software as a Service delivering applications over the internet

File management

Managing digital files by saving naming copying moving deleting and organizing

Folder

A container used to store and organize files

Sub folder

A folder stored inside another folder

Folder hierarchy

The folder structure created by an operating system

Path

The sequence of folders leading to a file or folder

Windows root folder?

C backslash

Mac or Linux root folder

Forward slash

File Explorer

The Windows tool used to navigate files and folders

Finder

The Mac OS tool used to navigate files and folders

User home folder

A personal folder created for each user account

Why cant users see other users folders?

Privacy and security

What storage options do mobile devices use?

Internal storage external storage and cloud storage

What are the two main file types?

Program files and data files

Program file

An executable application file

Data file

A file created by users such as documents images or videos

File extension

The part of a file name that identifies its type

In homework.docx what is docx?

The file extension

Default program association

The program the OS uses to open a file type

What happens when you double click a data file?

The associated program opens the file

File properties

Metadata such as size dates owner and permissions

What does backing up files mean?

Copying files to another storage device or the cloud

Name a Windows and Mac backup utility

File History and Time Machine

How is cloud backup different from cloud storage?

Backup stores copies storage holds working files

File compression

The process of making a file smaller

What is the difference between lossless and lossy compression?

Lossless keeps all data lossy removes some data