Notesale: Turn your study into money

Document Preview

Extracts from the notes are below, to see the PDF you'll receive please use the links above

---

Quiz #1 Review
Word:
Block style letter

Letter style often used in business (heading, opening,
body, closing)

Clipboard

Designated area in memory, paste uses most recent
item

Office Clipboard

Stores last 24 cut/copied items

Points

72 points to an inch

Document collaboration

Working w/others to create, review, and revise a
document

Peer editing

Form of document collaboration

Markup

Comments and tracked changes

Read Mode

Displays text in columns

Tabs

Used to position text within a line

Tab stop

Specifies a location within the line of text

Tab leader

Character repeated to fill space spanned by a tab

Hanging indent

First line farther left (ie
...
essay)

Graphics sources

Web page, online source, digital camera pictures,
screen captures, illustration software

Ligatures

Combinations of 2 or more characters into a single
character to create more readable text

OpenType font

Scalable font format (needed for ligatures)

Pagination

How a document is divided into pages

Template

Master document that includes basic elements for
particular types of documents

Web page title

Text displayed in title bar of browser window

Style

Named set of formats

Quick Styles

ie
...
title
page, table of contents)

Outline View

Displays organization of the document

SmartArt graphics

Diagrams that show relationships btw elements and are
used to illustrate info

Elements

Ppl, tasks, goals, stats, etc
...
computers, keyboards, disk drives,
iPads, flash drives)

Software

Instructions that tell hardware what to do (2 kinds:
operating-system – makes hardware usable ie
...
Angry
Birds)

Data

Collection of facts (ie
...
Front-line help-desk workers, to systems analysts,
to programmers, all the way up to the chief information
officer (CIO)

Process

Series of steps undertaken to achieve a desired
outcome or goal

Role of IS

Collect, store, organize, and distribute data throughout
the organization; take data and turn it into information,
and then transform that into organizational knowledge

The cloud

Applications, services, and data storage on the Internet
that rely on giant server farms and massive storage
devices that are connected via Internet protocols (use
of these = cloud computing)

Advantages

No software to install or upgrades to maintain, available

from any computer that has access to the Internet, can
scale to a large number of users easily, new
applications can be up and running very quickly,
services can be leased for a limited time on an asneeded basis, your information is not lost if your hard
disk crashes or your laptop is stolen, you are not
limited by the available memory or disk space on your
computer
Disadvantages

Your information is stored on someone else’s computer,
you must have Internet access to use it, you are relying
on a third-party to provide these services

Private cloud

Cloud service provider sections off web server space for
a specific organization - has full control over that server
space while still gaining some of the benefits of cloud
computing

Virtualization

Process of using software to simulate a computer or
some other device

Data process

Add context  information, use to make decisions 
knowledge, knowledge and experience  wisdom
(deeper understanding)

Database

Organized collection of related info

Relational database

Data organized into tables, each table has fields and
records (ie
...
on slides

Design

Fonts, colours, accent graphics, should be appropriate
for purpose and audience

Storyboard

Visual layout of slides in pres (sketches)

Slide layout

Arrangement of text and graphics

Title slide

Includes title and author, diff layout

Placeholder

Box w/dashed-line border

AutoFit

Automatically sizes text to fit in placeholder

Serif vs
...

Previewing a presentation

Shows what printouts will look like

Time stamp

Date automatically updated in footer

Slide master

Template that applies to all slides in presentation

Notes Page view

Used to add/format notes, add graphics to notes, and
format layout of Notes page

Notes Master

Used to change layout and look of printed speaker
notes

Slide transition

How one slide changes to the next in Slide Show view

Animation

Visual effect in which objects appear to move

Annotations

Markings made on a slide that help the audience better
understand the content (ie
...
WiFi)

Intellectual property

Property (ie
...
commercial, educational, nature of copyrighted
work, amount of work used, and effect of use on
potential market for/value of work)

Patent

Protection for someone who invents a new product or
process (lets them stop others from making, using,
offering for sale, selling, or importing the invention);
lasts 20 years; 3 conditions: must be original, nonobvious, and useful

Patent troll

Person/organization who gains the rights to a patent
but does not actually make the invention that the
patent protects – they search for ppl who are illegally
using the invention in some way and sue them

Trademark

Word, phrase, logo, shape or sound that identifies a
source of goods or services (ie
...
name,
social security number, financial info)

Non-obvious relationship

Process of collecting large quantities of a variety of

awareness (NORA)

information and then combining it to create profiles of
individuals (ie
...
159

Adjacent cells

Cells that are next to each other

Range

Selection of 2+ cells

Theme

Predefined set of colours, fonts, and effects used to
format a worksheet, used for consistent and
professional look

Cell styles

Apply several formats in 1 step and ensure consistent
cell formatting

Page Layout view

Worksheet is displayed as pages, can modify page

formats (margins, headers, footers), and data can be
changed (use to prepare worksheet for printing)
Gridlines

Solid lines that mark off rows and columns

Formulas

Mathematical statements used to calculate values, must
begin w/= sign, error displays green triangle in upperleft corner

Order of operations

BEDMAS woohoo

Pointing

Entering cell references into a formula by clicking in the
cell (best b/c typing errors are avoided)

Circular reference

Formula references the cell it’s stored in

Source/destination

Place data is cut/copied from and pasted to

Fill handle

Solid square in lower-right corner or selected cell/range
(drag to copy contents/formula)

Relative cell references

Cell references that reflect the row/column they have
been copied to

Conditional formatting

Formatting applied to cell when specified condition is
met (makes data easier to evaluate)

Function

Performs a calc that results in a single value (requires
data called arguments enclosed in parentheses)

SUM function

Adds value of cells in range

Syntax

Structure of fx, illustrated by ScreenTip

AVERAGE function

Adds values of cells in range and divides by number of
cells

MAX function

Finds largest value in range

MIN function

Finds smallest value in range

Absolute cell reference

Cell reference that doesn’t change when copied (has
dollar signs ie
...
$A1)

Chart

Visual representation of worksheet data

Data series

Column w/numerical data

Series name

Label for data series

Categories

Within series, data is divided into categories

Category labels

Text in cells adjacent to data series

Data marker

Chart symbol that represents a single data point

Chart title

Describes what is charted

Legend

Corresponds to category labels

Data labels

Identify each value in data series

Plot area

Part of chart that displays data

Chart area

Entire chart and all elements

Pie charts

Best for data that is a % of a whole

 Slice

 Each one represents a value from the series

Bar charts

Best for comparing differences btw
...
column chart Bar = horizontal bars, column = vertical bars
Line chart

Can include several series of data w/each line
representing a series and each point representing a
value (good for showing differences of data over time)

Chart design

Chart type, data for chart, and basic style/layout

Sparklines

Mini-charts that can be inserted in a cell

Static

By default, pasted data doesn’t change when the
source data changes

Linked cells

Contain a reference to original data and will
automatically update if the source data changes

ROUND function

Changes a value by rounding it to a specific # of
decimal places =ROUND(C16,1) (cell ref, # of decimal
places, negative numbers mean 10s, 100s, etc
...
car loan, mortgage)

Principal

Amount of money owed, decreases w/each payment
made

Amortization table

Displays the interest and principal amounts for each
payment of an installment loan

PMT function

Used to calculate the equal periodic payment for an
installment loan =PMT(rate, term, principal) (rate =
interest rate per period, for monthly payments divide
by 12, term = total # of payments to be made,
principal = amount borrowed, must be negative)

TODAY function

Displays the current date

NOW function

Displays the current date and time

Tables

Allow a range of related data to be managed and
analyzed independent of any other data in the
worksheet

Filter

Displays only rows that meet specific criteria

Calculated column

Allows a single formula to be entered in a cell and then
the formula is automatically copied to all other cells in
the column

PivotTable

Each column of a worksheet is a field that can be used
in a report to summarize data

 PivotTable report

 Allows worksheet data to be put into small, concise
reports, simplifying data analysis

CHOOSE function

Lookup function that is used to return a value from a
list of values =CHOOSE(choice, option, option, …)
(choice = #/formula/cell reference from 1 to 254,

options = possible values to return)
VLOOKUP function

Used to return a value from a table of values stored in
the worksheet =VLOOKUP(value, range, column) (value
= # to be looked up in a table of values, range = cell
range where the VLOOKUP table is stored)

Embedded object

Keeps the features of the application it was created in
(Keep Source Formatting)

Linked object

Automatically updates when the source data is updated
(Link & Merge Formatting)

What-If question

Asks how a value/set of values impacts results

Spreadsheet model

Worksheet that includes related data and formulas for
analyzing the data

What-if analysis

Businesses asking “What-If” questions of their
spreadsheet models in order to make predictions

Access:
Database

Organized collection of related data

Relational database

Computer application used to create a database (ie
...
Excel, text files)

Append

Add to existing table

Select query

Database object used to retrieve data that matches
specified criteria

Design grid

Used to specify fields and criteria

Range query

Select query with criteria that matches a range of
values (uses <, >, <=, >=, and <>)

Complex query

Select query with multiple criteria (uses And/Or)

Wildcard

Character that matches any one or more characters (*
matches any number of characters or none, and ?

matches any one character or none)
Like operator

Used to specify criteria when using wildcard

How to refer to another

[Table Name]![Field Name]

field in criteria
Parameter query

Retrieves data that matches criteria (called a
parameter) typed by the user when the query is run
(type prompt in [] in criteria box)

Update query

Modifies/updates records (Design  Update)

Bourgeois:
Future trends in IS

Globalization (growing use of Internet esp
...
hearing aids, Bluetooths),
collaborative (sharing data w/others passively/actively),
3D printers, physical objects being connected to
Internet, autonomous robots and vehicles

Systems analyst

Works w/person, team, or department w/business
requirements and identifies the specific details of a
system that needs to be built

Programmer

Writes computer code in a programming language,
fulfill design specifications given to them by systems
analysts

Computer engineer

Designs computing devices

 Hardware engineer

 Designs hardware components (ie

---