Software and Apps Flashcards
programs that help you perform specific tasks when using your computer or smartphone
Application software (or software applications, or apps)
Allow you to create documents for business and personal use
Productivity apps (word, PowerPoint, etc.)
Allow you to interact with digital media
Graphics and media apps (photo, video, audio edit apps)
Give you tools to pursue your interests
Personal interest apps
Provide tools for sharing or receiving information
Communications apps
Provide tools for maintaining your computer or mobile device
Device management apps (screen saver, cloud, etc)
Apps that you install on your computer’s hard drive
Local applications
Run from a removable storage device such as an external hard drive or flash drive, or from the cloud.
Portable apps
You can access portable apps from
folder in your cloud storage
useful when you have limited storage space on your computer.
Portable apps
A portable open source productivity suite like those found in Microsoft Office
OpenOffice.org
Apps that you access on a smartphone or tablet are called
mobile applications, or mobile apps
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.
synchronize
Optimize storage, delete unused or duplicate files, optimize device performance
Device maintenance apps (CCleaner, PhoneClean)
Organize your address book
Contact management apps (Contacts)
Search the Internet, set timers, add appointments to your calendar, make hands-free calls by speaking commands
Personal assistant apps (Siri, Cortana, Google Home, Amazon Alexa)
An app written for a specific operating system and installed on a computer or mobile device
Native apps
Can take advantage of specific features of the devices on which they are installed, such as a smartphone’s camera, microphone, or contacts list
Native apps
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.
Native apps
A web app that runs on a mobile device
A mobile app
Optimized for display in a browser on a mobile device, regardless of screen size or orientation.
Responsive design (mobile web apps)
Developers prefer it because it runs on all devices
Web apps
Rely on HTML5 to display information, JavaScript to manage the app’s performance, and CSS (Cascading Style Sheets) to format information.
Web apps
Pros of Mobile Apps
Quickly create, and access information on the go, and simplified interactions with voice input and on-screen keyboard.
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).
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
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
Development tools, developers can build apps that work on multiple platforms, rather than writing different code for Android or iOS devices.
cross-platform
Writes apps in Swift or Objective-C
iOS developers
Writes apps in Java
Android developers
Rely on HTML5, JavaScript, and CSS
Cross-platform developers
Let you use your mobile device to make online purchases of goods and services
Mobile commerce, or m-commerce apps
Productivity suits are:
Windows 360 Office, Apple iWork, G suit, and Apache OpenOffice
Protect and organize files, and let you share your document with others.
Document management tools
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
Who and what to use to create letters, greeting cards, notes, event flyers, check lists?
Word - Personal users
Who and what to use to create essays, reports, stories, resumes, notes?
Word - Students
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
Who and what to use to create documents for publishing to the web after converting them to HTML?
Word - Web designers
To format a text you
change its font type, size, style, color, and special effects such as reflection, shadows, and outlining.
The direction in which content is printed on the page, portrait or landscape
page orientation
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
You can restrict access to a document by providing
A view-only link, or read-only access
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
Apps let you interact with numbers, charts, graphics, text, and data
Spreadsheet
To calculate taxes or payroll businesses often use
spreadsheets
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)
Allow you to organize data stored in rows and columns and perform simple or complex calculations on that data
spreadsheet
You use spreadsheet software to create, edit, and format
Worksheets
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
in a worksheet is the location formed by the intersection of a column and a row
a cell
a collection of related worksheets contained in a single file
workbook
“+”, “-”, “*”, and “/”
arithmetic operators
Spreadsheet formulas always begin with an
equal sign (“=“)
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
is a cell reference that does not change when the formula containing that reference is moved to a new location
An absolute reference
is a cell reference that changes when the formula containing that reference is moved to a new location.
A relative reference
What spreadsheet function to use to calculate the sum, average, or count of cells in a range
SUM, AVERAGE, COUNT
What spreadsheet function to use to calculate interest rates and loan payments
RATE, PMT
What spreadsheet function to use to obtain the current date, time, or date and time
DATE, TIME, NOW
What spreadsheet function to use to perform calculations based on logical conditions
IF, AND, OR, NOT
What spreadsheet function to use to calculate the largest and smallest values in a group of cells
MAX, MIN
What spreadsheet function to use to look up values in a table
VLOOKUP
What to use to highlight cells that meet specified criteria
conditional formatting
to arrange them in increasing or decreasing order
Sort data by values in a column
to display only the values you want to see
Filter worksheet data
to test multiple scenarios by temporarily changing one or more variables, to see the effect on related calculations
What-if analysis
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
to create meaningful data summaries to analyze worksheets containing large amounts of data
pivot tables
to perform steps you repeat frequently in a spreadsheet software you use
macros
represent data using bars, columns, pie wedges, lines, or other symbols.
Charts (sometimes called graphs)
Present data visually and make it easier to see relationships among the data on a spreadsheet software
charts
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
shows how several values change over time in the same graphic
A stacked area chart
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
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
a collection of data organized in a manner that allows access, retrieval, and reporting of that data
database
to track contacts, schedules, possessions, or collections.
database software for individuals
to process orders, track inventory, maintain customer lists, or manage employee records
database software for small business
to store customer relationship management data, such as interactions with customers and their purchases
database software for companies
a language that provides a standardized way to request information from a relational database system
SQL (Structured Query Language),
allow you to organize large amounts of data, and have many users update it simultaneously.
Oracle, Microsoft SQL Server, and MySQL
Data can be exported from a database into other programs, such as
a spreadsheet program
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,
provide advanced database solutions for enterprise use
SQL Server and Oracle
In a relational database, such as Microsoft Access, data is organized into tables of
records (rows of data)
Each piece of data in a database is entered and stored in an area called a
field
a column containing a specific property for each record, such as a person, place, object, event, or idea.
field
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
extracts data from a database based on specified criteria, or conditions, for one or more fields.
A query
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
converts your query specifications to SQL
visual query builder tool
provides a series of keywords and commands that advanced users might type directly to create and run queries.
SQL
a user-designed layout of database content
report
You might prepare a monthly sales………. listing top deals and agents, or an inventory report to identify low-stock items.
report
a screen used to enter data into a database
A form
provides an easy-to-use data entry screen that generally shows only one record at a time.
A form
A form is made up of
controls
elements such as labels, text boxes, list boxes, buttons, and graphics, that specify where content is placed and how it is labeled.
controls
What should you use to reduce data entry errors?
controls
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
help users navigate records and find specific information
form
refers to data collections so large and complex that it is difficult to process using relational database applications.
Big Data
What should companies do to easily increase storage or processing capabilities to store, access, or query the data?
storing large databases in the cloud
Digital images are stored either in
bitmap (raster), or vector format
Bitmap images are based on a grid of colored dots called
pixels
tend to be simple images composed of shapes, lines, and diagrams.
Vector graphics (does not lose quality)
use mathematical formulas instead of pixels to define their appearance.
Vector graphics
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)
Most clip art images are stored as
Vector graphics
refers to premade pictures and symbols available on the web or included with your application’s image gallery.
Clip art
supports images with animation and transparent backgrounds
.gif
codes a value for each pixel. Files can be large (uncompressed)
.bmp
unprocessed data from a digital camera, usually used by professional photographers (uncompressed)
.raw
commonly used for print publishing because it maintains quality.
.tiff
let you create simple, two-dimensional images.
Drawing apps
