Google Application Terms

Order of Operations

( ), Multiply, Division, Add, Subtract

Multiplication Symbol

*

Addition Symbol

+

Subtraction Symbol

-

Division Symbol

/

5 Principles of Effective Communication

1 Focus on the situation, issue, or behavior, and not on the person. 2. Maintain the self-confidence and self-esteem of others. 3. Maintain a positive and supportive attitude. 4. Take initiative to make things better. 5. Lead by example.

5 Steps in Communication Planning

1. Determine the purpose of the message 2. Identify the Audience 3.. Clarify objectives 4. Determine the best channel of communication 5. Outline the communication for delivery

Why is understanding communication important?

1. It will help you be more effective in communicating with others. 2. It will help to reduce misunderstanding between people. 3. It helps to avoid friction between people.

Text Alignment

1. Right - all text even on the righthand side 2. Center - all text centered from the middle 3. Left - all text even on the lefthand side 4. Justified - all text evenly spaced to line up along left and right side

Types of Google Forms Questions

1. Short Answer 2. Multiple Choice 3. Linear Scale

Paragraph styles

1. Title 2. Heading 1, 2, 3 3. Normal Text

3 ways to insert cell references in formulas

1. You can enter a cell reference in a formula by clicking the cell location on the spreadsheet. 2. You can enter cell references in a formula by typing in the reference in the formula bar or cell. 3. Cell references make it easy to use values from other cells in a formula.

Communication Style

A person's preferred way of sharing information with others

Style Guide

A set of guidelines for the writing and design of documents

Communication

Act or process of using words, sounds, signs or behaviors to express or exchange information, or to express your thoughts, ideas, feelings to someone else.

Understanding in communication is achieved when

All of the involved parties agree on the shared meaning of the shared message

Can Comment

Allows a team member to review a presentation.

Google Sheets

Application for Calculations on Spreadsheets

Google Slides

Application for Presentations

Google Docs

Application for Word Processing

Google Forms

Application for asking questions and gathering responses

Location of Works Cited page

At the end of the document, on a separate page

Feedback

Both verbal and nonverbal communication

Eye contact

Can help you determine a person's intent in a situation

Cell Reference

Column Letter and Row Number

Hide a Column

Column does not appear but the information is still there

Merge

Combine cells into a single cell

Share a link with users

Common way to send or distribute a Google Form

Click the Next Button

Conditional Branching occurs in Google Forms

Paint Format tool

Copy complex text formatting from one section of the document to another

(Tanner and O'Brian 163)

Correct in-text citation referencing a book titled "History of New York", by Kathy O. Tanner and Lawrence O'Brian, page 163.

Keyboard shortcut to select ALL text

Ctrl+A

Keyboard shortcut for Copy

Ctrl+C

Keyboard shorcut to open Find tool

Ctrl+F

Keyboard shortcut opens the Find and Replace dialog window

Ctrl+H

Keyboard shortcut for Paste

Ctrl+V

Keyboard shortcut for Delete or Cut

Ctrl+X

Keyboard shortcut for Undo

Ctrl+Z

Can edit

Default level of access when sharing a file using an email address

Column Headings

Descriptions of the contents of the column, rather than data

Logical Expression

Expression that evaluates to TRUE or FALSE

Answer Key

Feature added to each question to make a Google Form into a quiz

Find and Replace

Feature that locates specific text and then replaces it with desired text

During active listening "attending" is the process

Focusing on the information you have received

Conditional Formating

Formatting that is applied to a cell when a specified condition is met.

Complex Formula

Formula with several operations being performed at once

Footer

Found at the bottom of page

Header

Found at the top of the page

SUM

Function that adds together the values in a group of cells

AVERAGE

Function that returns the average (arithmetic means) of its arguments

MAX

Function that returns the largest number from a range of cells

MIN

Function that returns the smallest number from a range of cells

Descending Order

Go backwards when sorting

Ascending Oder

Go forwards when sorting data

Google Forms works with _____________ ___________ to further analyze and manipulate the form responses

Google Sheets

Filering Data in a Spreadsheet

Hides data that you do not want to see

"In-Progress"

If A2=4 and B2=3, what would the following function return? =IF(A2+B2<10, "In-progress", "Done")

"Done"

If A2=6 and B2=8, what would the following function return? =IF(A2+B2<10, "In-progress", "Done")

Culture

Impacts how you communicate verbally and how you interpret verbal communication

Control Key

In Google Sheets which key would you press to select a group of cells

Table Title

Informs the viewer what the table is about

During active listening, "understading" is the process of

Interpreting the meaning of the communication

Ctrl+U

Keyboard shortcut to Underline Text

Bullets

Marks, usually a round or square dot, used to emphasize items in a list

Cut and Paste

Moves information from one place to another

My Drive

Name of the Google Drive where your documents are located

Currency

Number format to apply to a cell showing the total sales in dollars

Number of columns in a Table are equal to

Number of Column Headings

Number of rows in a table are equal to

Number of Row Titles plus one more

Count

Number of cells with something in them

Artifacts

Objects or images which are used to communicate non-verbally

Collaboration

Occurs when two or more people combine their knowledge, creativity, and experience, and share the responsibility of reaching a common goal.

Landscape orientation

Paper is 11" x 8.5"

Portrait orientation

Paper is 8.5" x 11"

Argument in the Function

Part of formula in parentheses

Open Communication Style

Person readily expresses emotions, thoughts, and feelings without holding back in anyway

A Template

Pre-designed document

During active listening "recalling" is the process of

Restating the information you have received

Font

Set of characters designed to look the same

During active listening "responding" is the process of

Showing the sender you are listening by providing feedback

$

Symbol used to designate an absolute cell reference

Wrap text

Text flow option allowing the text to surround an object

Conditional Branching

The feature in Google Forms that directs the user to another section of the form based on an answer to a question

Operand

The number being added, subtracted, multiplied, divided in a formula

Operator

The operation being performed in a formula

Format Attribute

The pieces of information that describe the appearance of a cell's content

Numbered

The type of list used for items that are in chronological or sequential order.

Nonverbal Communication

The use of body language, emotions, eye movement to communicate

Verbal Communication

The use of sounds or language to relay a message

Absolute

There is no change to the cell or row with a "$"

A "Relator"

This person is someone who is easy to get along with and communicates well with others

A "Director"

This person is usually known for their aggressive, competitive nature

A "Receiver"

This person provides feedback to confirm what they have heard and to confirm the understanding of all parties

Use of parentheses ( )

To force a certain order of operations in a formula

Importance of Collaboration

To have people work together for an organization to help it grow and for the best results to be achieved.

Shift Key

To select a very large group of cells in Google Sheets, click on the first cell in the group, hold down the ________ key, and then click on the last cell in the group.

Dictionary

Tool to use to find synonyms for words in your document

Insertion point

Vertical blinking line where text appears in a document

Ctrl+X then Ctrl+V

Which sequence of keyboard shortcuts would you use to MOVE information from one cell to another

Collaboration allows you the ability to work _________

together