Lecture quiz #3

Which of the following are tool(s) that allow you to organize your information in a document?

appendix, heading/table of contents, headers and footers, cross-reference

Data visualization is important for

All the answers

Templates can be a key feature in the creation of a document. What does a template provide to aid the creator of the document?

A "Fill in the Blank" document that can be completed either by hand or through an automated iterative process.

According to the Statistics Canada website, if you are unfamiliar with the data you are analyzing, it is a good idea to

Consult an expert on the subject matter

The presentation of data in a pictorial or graphical format is also know as ____.

Data Visualization

According to the Statistics Canada website, the process of developing answers to research questions through the examination of data is called

Data analysis

According to the Statistics Canada website, data analysis is the process of developing questions through the examination and interpretation of data.

False

According to the Statistics Canada website, to be effective, the analyst needs to understand the current relevant issues and should be careful not to include those that could emerge in the future.

False

If a job posting does not specifically require a cover letter, sending your resume in without one or with just a post-it note is perfectly acceptable.

False

Pie charts are best for showing trends over time.

False

Spreadsheets are easy for people to understand and visualize data trends and patterns.

False

What shows you only the data you need or helps you find a specific type of data?

Filtering

To add a page number, use the ____ Tab.

Header and footer

Which of the following are true about column charts?

In column charts, categories are typically organized along the horizontal axis, and values along the vertical axis, Column charts are useful for showing data changes over a period of time, Column charts are useful for illustrating comparisons among items.

Which of these is not the three elements to successful data visualization?

It easily connects to the Internet

Which of the following are true about line charts?

Line charts are ideal for showing trends in data at equal intervals, Line charts are usually set against a common scale, Line charts can display continuous data over time.

Which of the following are true about radar charts?

Radar charts compare the aggregate values of multiple data sets, A radar chart plots the values of each category along a seperate axis that starts in the center of the chart and ends on the outer ring.

When we refer to a document, which of the following could we be referring to?

Research paper, resume, cover letter

Which of the following are true about scatter charts?

Scatter charts are typically used for displaying and comparing numeric values such as scientific, statistical, and engineering data, Scatter charts show the relationships among the numeric values in several data series, Scatter charts are ideal to use when trying to understand what the relationship is between two sets of values (i.e. linear, exponential, etc.)

Which of the following characteristic(s) are provided by the formatting created by templates?

Table of contents with section titles, Tables of figures with caption titles and their page numbers, Cross-referencing with section or page numbers, Footnote numbering, Indices of keywords and their page numbers

Which of the following are true about surface charts

You can use a surface chart when both categories and data series are numeric values, Colors and patterns indicate areas that change over time and space - they are ideal for showing duration values, Colors and patterns indicate areas that are in the same range of values, A surface chart is useful when you what to find optimum combinations between two sets of data.

If you have a situation where the axis labels are long and the values that are shown are durations, the best chart to use is which of the following?

Bar chart

Which of the following are characteristic(s) of a good document?

correct grammar and spelling, organized information, clear and concise

To add a filter to your data, click the Filter command under which tab?

data

Which of the following can be shown on a stock chart?

opening price, volume of stocks traded, high value, closing price, low value

Use ____ from the commands in the bottom corner to view how your worksheet will print.

print view

Which of the following are feature(s) we expect from our word processor?

spell checking, grammar checking, equation support, support for simple fonts/colors

A key question you should ask yourself when beginning to create a document is "Who are you trying to communicate to or persuade?" This allows you to know your audience.

true

A word processor is a computer application used for the production (including composition, editing, formatting, and possibly printing) of any sort of printable material.

true

Clustered column charts compare values across categories by displaying values in vertical rectangles.

true

Which tool in Excel helps you visualize the meaning behind data?

Charts

According to the Statistics Canada website, which of these is not a basic step in the analytical process

Finding the data on a helpful website

Which of these is one of the most important keys to understanding how to visualize your data?

knowing your audience

Which of the following are true about using charts in presentations?

They provide a visual aid to the topic, You don't want them to cause you to become the voice-over to the video, Putting complex charts up can cause the audience to lose focus on your voice.

A stacked column chart shows the relationship of individual items to the whole by comparing the contribution of each value to a total across categories.

True

Area charts emphasize the magnitude of change over time. They can be used to draw attention to the total value across a trend by displaying the sum of the plotted values. This shows the relationship of the parts to the whole.

True

Markers are used to show individual data values. They can clutter up the effect, but can also illustrate key values. They can be used with any type of chart.

True

The Page Layout tab can help you modify your page orientation, margins, and theme.

True

The filtering tools are added to the Header row.

True

The purpose of a document is to communicate or persuade.

True

Visualization is really a dynamic form of persuasion through telling a story.

True

To add a row, select the row ___ the place where you want to add the row.

below

To delete a row or column, select the row or column and use the delete command in the ___ group of the Home tab.

cells

Pie charts show the size of items in multiple data series, proportional to only one of the other items.

false

The APA (American Psychological Association) allows research papers for journals to be submitted in any format, as long as it is clear and concise.

false