Software and Apps Flashcards
1
Q
programs that help you perform specific tasks when using your computer or smartphone
A
Application software (or software applications, or apps)
2
Q
Allow you to create documents for business and personal use
A
Productivity apps (word, PowerPoint, etc.)
3
Q
Allow you to interact with digital media
A
Graphics and media apps (photo, video, audio edit apps)
4
Q
Give you tools to pursue your interests
A
Personal interest apps
5
Q
Provide tools for sharing or receiving information
A
Communications apps
6
Q
Provide tools for maintaining your computer or mobile device
A
Device management apps (screen saver, cloud, etc)
7
Q
Apps that you install on your computer’s hard drive
A
Local applications
8
Q
Run from a removable storage device such as an external hard drive or flash drive, or from the cloud.
A
Portable apps
9
Q
You can access portable apps from
A
folder in your cloud storage
10
Q
useful when you have limited storage space on your computer.
A
Portable apps
11
Q
A portable open source productivity suite like those found in Microsoft Office
A
OpenOffice.org
12
Q
Apps that you access on a smartphone or tablet are called
A
mobile applications, or mobile apps
13
Q
You can…..data and activity between the web app and the mobile app, so your actions and information will be consistent across all your devices.
A
synchronize
14
Q
Optimize storage, delete unused or duplicate files, optimize device performance
A
Device maintenance apps (CCleaner, PhoneClean)
15
Q
Organize your address book
A
Contact management apps (Contacts)
16
Q
Search the Internet, set timers, add appointments to your calendar, make hands-free calls by speaking commands
A
Personal assistant apps (Siri, Cortana, Google Home, Amazon Alexa)
17
Q
An app written for a specific operating system and installed on a computer or mobile device
A
Native apps
18
Q
Can take advantage of specific features of the devices on which they are installed, such as a smartphone’s camera, microphone, or contacts list
A
Native apps
19
Q
Require an Internet connection to provide full functionality. Some apps can run offline and will store information on your device until they can synchronize with the cloud.
A
Native apps
20
Q
A web app that runs on a mobile device
A
A mobile app
21
Q
Optimized for display in a browser on a mobile device, regardless of screen size or orientation.
A
Responsive design (mobile web apps)
22
Q
Developers prefer it because it runs on all devices
A
Web apps
23
Q
Rely on HTML5 to display information, JavaScript to manage the app’s performance, and CSS (Cascading Style Sheets) to format information.
A
Web apps
24
Q
Pros of Mobile Apps
A
Quickly create, and access information on the go, and simplified interactions with voice input and on-screen keyboard.
25
Cons of Mobile Apps
Fewer features and not fast, can be poorly designed, and using a small on-screen keyboard can be cumbersome (or slow).
26
Mobile apps have an Android phone, you need to install the Android version of your app; if you have an iPhone, you need to download the iPhone version of your app which is called
platform-specific
27
Designers and developers start building apps to work on mobile devices first because these typically have more restrictions, such as smaller screens.
Mobile first design
28
Development tools, developers can build apps that work on multiple platforms, rather than writing different code for Android or iOS devices.
cross-platform
29
Writes apps in Swift or Objective-C
iOS developers
30
Writes apps in Java
Android developers
31
Rely on HTML5, JavaScript, and CSS
Cross-platform developers
32
Let you use your mobile device to make online purchases of goods and services
Mobile commerce, or m-commerce apps
33
Productivity suits are:
Windows 360 Office, Apple iWork, G suit, and Apache OpenOffice
34
Protect and organize files, and let you share your document with others.
Document management tools
35
Who and what to use to create agendas, memos, contracts, proposals, reports, letters, email, newsletters, personalized bulk mailings and labels?
Word - Business executives, office workers, medical professionals, politicians
36
Who and what to use to create letters, greeting cards, notes, event flyers, check lists?
Word - Personal users
37
Who and what to use to create essays, reports, stories, resumes, notes?
Word - Students
38
Who and what to use to create business cards, postcards, invitations, conference tent cards, name tags, gift tags, stickers?
Word - Conference promoters and event planners
39
Who and what to use to create documents for publishing to the web after converting them to HTML?
Word - Web designers
40
To format a text you
change its font type, size, style, color, and special effects such as reflection, shadows, and outlining.
41
The direction in which content is printed on the page, portrait or landscape
page orientation
42
You can change font and font sizes, change the color of text and backgrounds, add photos and shapes, and use provided templates to give a professional appearance to your documents.
Word
43
You can restrict access to a document by providing
A view-only link, or read-only access
44
You can share documents with several people who can read, edit, and comment on the same document at the same time if you store the document on the
cloud
45
Apps let you interact with numbers, charts, graphics, text, and data
Spreadsheet
46
To calculate taxes or payroll businesses often use
spreadsheets
47
Keeping to-do lists, creating a budget, tracking your personal finances, following the performance of your favorite sports teams, and calculating payments on a loan are all tasks you can accomplish using a
spreadsheet (manipulate numbers or display numerical data)
48
Allow you to organize data stored in rows and columns and perform simple or complex calculations on that data
spreadsheet
49
You use spreadsheet software to create, edit, and format
Worksheets
50
laid out in a grid of rows and columns; they use letters or pairs of letters, such as A or AB, to identify each column, and consecutive numbers to identify each row.
worksheets
51
in a worksheet is the location formed by the intersection of a column and a row
a cell
52
a collection of related worksheets contained in a single file
workbook
53
“+”, “-”, “*”, and “/”
arithmetic operators
54
Spreadsheet formulas always begin with an
equal sign (“=“)
55
a predefined computation or calculation, such as calculating the sum or average of values or finding the largest or smallest value in a range of cells.
A function
56
is a cell reference that does not change when the formula containing that reference is moved to a new location
An absolute reference
57
is a cell reference that changes when the formula containing that reference is moved to a new location.
A relative reference
58
What spreadsheet function to use to calculate the sum, average, or count of cells in a range
SUM, AVERAGE, COUNT
59
What spreadsheet function to use to calculate interest rates and loan payments
RATE, PMT
60
What spreadsheet function to use to obtain the current date, time, or date and time
DATE, TIME, NOW
61
What spreadsheet function to use to perform calculations based on logical conditions
IF, AND, OR, NOT
62
What spreadsheet function to use to calculate the largest and smallest values in a group of cells
MAX, MIN
63
What spreadsheet function to use to look up values in a table
VLOOKUP
64
What to use to highlight cells that meet specified criteria
conditional formatting
65
to arrange them in increasing or decreasing order
Sort data by values in a column
66
to display only the values you want to see
Filter worksheet data
67
to test multiple scenarios by temporarily changing one or more variables, to see the effect on related calculations
What-if analysis
68
to visually summarize changes in values over time with small graphs that appear in cells of the worksheet next to the values they represent
trendlines, or sparklines
69
to create meaningful data summaries to analyze worksheets containing large amounts of data
pivot tables
70
to perform steps you repeat frequently in a spreadsheet software you use
macros
71
represent data using bars, columns, pie wedges, lines, or other symbols.
Charts (sometimes called graphs)
72
Present data visually and make it easier to see relationships among the data on a spreadsheet software
charts
73
In a database software, it compares categories of data to one another, and a pie chart compares parts (or slices) to the whole.
column chart
74
shows how several values change over time in the same graphic
A stacked area chart
75
an overall template for a presentation formatted with a theme, customized title and text fonts, backgrounds, and other objects that appear on slides in the presentation.
slide master
76
What app should you use to keep track of contacts, addresses, and collections. Large enterprises use it to store vast quantities of data that enable us to shop online, execute web searches, or find friends on social media.
database software
77
a collection of data organized in a manner that allows access, retrieval, and reporting of that data
database
78
to track contacts, schedules, possessions, or collections.
database software for individuals
79
to process orders, track inventory, maintain customer lists, or manage employee records
database software for small business
80
to store customer relationship management data, such as interactions with customers and their purchases
database software for companies
81
a language that provides a standardized way to request information from a relational database system
SQL (Structured Query Language),
82
allow you to organize large amounts of data, and have many users update it simultaneously.
Oracle, Microsoft SQL Server, and MySQL
83
Data can be exported from a database into other programs, such as
a spreadsheet program
84
is a database that consists of a collection of tables where items are organized in columns and rows.
A relational database management system (RDBMS), or relational database,
85
provide advanced database solutions for enterprise use
SQL Server and Oracle
86
In a relational database, such as Microsoft Access, data is organized into tables of
records (rows of data)
87
Each piece of data in a database is entered and stored in an area called a
field
88
a column containing a specific property for each record, such as a person, place, object, event, or idea.
field
89
are a collection of records for a single subject, such as all the customer records, organized in grids of rows and columns, much like worksheets in spreadsheet applications.
tables
90
extracts data from a database based on specified criteria, or conditions, for one or more fields.
A query
91
You might ......... a sales database to find all the customers in Connecticut who made purchases of more than $1000 in January and sort the results in decreasing order by the purchase amount.
query
92
converts your query specifications to SQL
visual query builder tool
93
provides a series of keywords and commands that advanced users might type directly to create and run queries.
SQL
94
a user-designed layout of database content
report
95
You might prepare a monthly sales.......... listing top deals and agents, or an inventory report to identify low-stock items.
report
96
a screen used to enter data into a database
A form
97
provides an easy-to-use data entry screen that generally shows only one record at a time.
A form
98
A form is made up of
controls
99
elements such as labels, text boxes, list boxes, buttons, and graphics, that specify where content is placed and how it is labeled.
controls
100
What should you use to reduce data entry errors?
controls
101
a form might contain a text box in which a database user can type an email address, would it accept any other type of data?
No
102
help users navigate records and find specific information
form
103
refers to data collections so large and complex that it is difficult to process using relational database applications.
Big Data
104
What should companies do to easily increase storage or processing capabilities to store, access, or query the data?
storing large databases in the cloud
105
Digital images are stored either in
bitmap (raster), or vector format
106
Bitmap images are based on a grid of colored dots called
pixels
107
tend to be simple images composed of shapes, lines, and diagrams.
Vector graphics (does not lose quality)
108
use mathematical formulas instead of pixels to define their appearance.
Vector graphics
109
useful for images that can be shrunk or enlarged (e.q logos) and still maintain their crisp outlines and clarity.
Vector graphics (does not lose quality)
110
Most clip art images are stored as
Vector graphics
111
refers to premade pictures and symbols available on the web or included with your application’s image gallery.
Clip art
112
supports images with animation and transparent backgrounds
.gif
113
codes a value for each pixel. Files can be large (uncompressed)
.bmp
114
unprocessed data from a digital camera, usually used by professional photographers (uncompressed)
.raw
115
commonly used for print publishing because it maintains quality.
.tiff
116
let you create simple, two-dimensional images.
Drawing apps
