CS 110 Lecture exam 2

¡Supera tus tareas y exámenes ahora con Quizwiz!

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

Data

What is a PivotTable?

Data Summarization tool

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

Data analysis

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

According to Goldreich, the title and abstract should be as informative as possible and yet not to cumbersome or too long. The difference between them is length

True

An experiment is a valuable source of information because it is one of the only methods that allows us to make make casual statements

True

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

True

Goldreich's paper is a revised and augmented version of his essay "How to NOT write a paper" written in 1991 and revised in 1996

True

Markers can be 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

PivotCharts are charts that are made from PivotTables, and have the same options as other charts

True

The goal of a table is to represent data in a clear and accurate format

True

The purpose of a document is to communicate or persuade

True

When designing the table's rows and columns, keep your audience's needs in mind

True

You can autosize a column by double clicking the column header line

True

You can preview the font style if you use the drop down menu

True

In the GCF video over Headers, footers, and page numbers, the design tab is present under which of the following conditions:

When you have clicked in the header area

formulas

an expression that returns a value, number, text string -every formula begins with = -most common are arithmetic operators

Which of the following are true about column charts

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

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

Which of the following are true about line charts

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

Which of the following is true about the hypothesis of an experiment

-A hypothesis can be accepted -A hypothesis is a prediction that the treatment cause an effect -a null hypothesis can be proven incorrect

Which of the following are types of research papers?

-Argumentative -Analytical

In goldreich 2004 paper on how to write a research paper, which of the following steps does he recommend?

-Balance between contradictory requirements -awareness of the knowledge level of the reader -focus on the readers need's rather than the writers desires -make the reading a non-painful experience

Which of the following are places where data may be found

-Books -Web sites -Subject matter databases -Published papers -Case Studies

Which of the following are true about the thesis statement of an argumentative paper?

-Clearly articulates the topic -Establishes the stance the author is going to take

Which of the following are types of case studies

-Explanatory -Descriptive -Exploratory

Elements of an excel table

-Header row -Banded rows -Calculated columns - total row -sizing handle

Which of these is a database activity?

-NOT creating charts

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

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

Which of the following characteristics are provided by the formatting created by templates

-Table of contents with section titles -indices of keywords and their page numbers -cross-referencing with section or page numbers -tables of figures with caption titles and their page numbers -footnote numbering

Which of the following are true about why we cite sources

-To allow the readers to locate and further explore the sources you consulted -to show the depth of your research -to provide a trail for your reader to follow the research you performed -to provide evidence -to give credit

Which of the following are true about why we cite sources?

-To give credit where credit is due -to provide evidence for your arguments -to allow the readers to locate and further explore the sources you consulted -to show the depth and scope of your research -to provide a trail for your reader to follow the research you performed

To make your text stand out, which of the following can you use?

-Underline -Bold -Italic

Which of the following are true about databases for storing data

-allows operations on the data -stores and retrieves data based on keys -tools exist to allow a web interface

Designing tables

-arrange tables and rows logically -simplify the data entries as much as possible -important data should be emphasized -summarize the data to assist in comparison

filtering

-can filter by cell value, cell color, or font color -use conditional formatting to help filter -conditional formatting is scaling certain parts of your data or identifying certain ranges of information

Which of the following are characteristics of a good document

-clear and concise -organized information -correct grammar and spelling

Which of the following are features we expect from our word processor

-equation support -grammar checking -support for multiple fonts/colors -spell checking

Excel tables

-frequently used in research to visually communicate data -can be used to answer a number of questions in a minimal space -goal is to represent data in a clear and accurate format

Which of the following are tools that allow you to organize your information in a document?

-heading, table of contents -cross-references -tables to perform page layout -headers and footers -appendix

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

-it easily connects to the internet

According to Goldreich, a writer is often overwhelmed with his desire to say certain things and neglects to ask what the real needs of the readers are. Which of the following symptoms are related to the other latter scale of mind?

-obscure generality - the check list phenomenon - idiosyncrasies - lack of hierarchy or structure - talmud-ism

Which of the following are true about radar charts?

-plots the values of each category along a separate axis that starts in the center of the chart and ends on the outer ring - compost the aggregate values of multiple data sets

Data visualization is important for

-presenting research findings -sharing ideas with colleagues -conveying ideas

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

-research paper -cover letter -resume

Which of the following can be shown on a stock chart

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

adjacent range

A rectangular block of cells.

In the GCF video over headers, footers, and page numbers, you can restart the page numbering by inserting

A section break

In the GCF video over headers, footers, and page numbers, you can restart the page numbers by inserting:

A section break

When pursuing a number of papers as a part of your research, what do you read first to see if it is a good fit for your paper?

Abstract

According to Goldreich, the first thing to do before writing a paper is to do which of the following?

Ask "what is the idea that the paper is intended to communciate"

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

According to the GCF videos over getting to know word, clicking the arrow at the bottom of a group on the ribbon does what?

Brings up more commands

Which of these is not a PivotTable Feature?

Change the original data

Calculated columns

Enables you to apply a formula to all cells in a table column

A bibliography or list of works cited is almost always placed immediately after the introduction

False

According to Goldreich, as a writer, you should introduce as many of the new concepts and definitions pertaining to the subject that you can. This will ensure the reader has the necessary information

False

According to the GCF videos over getting to know your word, the ribbon is always present when you are using word

False

In the GCF video over pictures and test wrapping, the design tab allows you to insert pictures into a document

False

Information and data are synonymous

False

It is important to keep duplicates of information in your table

False

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

False

The APA allows research papers for journals to be submitted in any format, as long as it is clear and consise

False

Which feature can help you locate words or phrases within a document

Find

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

In the GCF video over pictures and text wrapping, one of the key items text wrapping controls is:

NOT the position of the text box

When Goldreich talks about how to serve the reader's needs, he identifies 4 key points. Which os the following is NOT one of those points

Focus on the writer's desires rather than the reader's needs

In the GCF video over page layout, the page dialog contained all of the following except

Font size

Which of these is not an element of an excel table?

Formula Bar

sizing handle

Handle in lower-right corner allows you to drag the table to the size that you want

To add a page number, use the __ tab

Header and footer

Which of these is not a key to designing a table?

Make a matching chart to go with the table

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

Page Layout View

Scatter charts

Show the relationship between values in two data sets or plot the two groups of numbers on one set of XY coordinates -are typically used as scientific, statistical, and engineering data -used as an initial indicator of data groupings

According to the GCF, videos on Formatting Text, you can change the font size by choosing the numeric font size or by clicking on which of the following?

Shrink and grow buttons

When goldreich talks about how to serve the reader's needs, what is the key point he illustrates

Single out clearly the new ideas presented in the paper

A key question you should ask yourself when beginning to create a document is who are you trying to communicate to or persuade?

True

Cell ranges

a cell range is a group of cells

Functions

a named operation that returns a value

non-adjacent range

a range that includes two or more adjacent ranges and selected cells - can include as many adjacent ranges as you want

References

can be relative or absolute -absolute references are not updated -relative references are updated

Which tool in excel helps you visualize the meaning behind data

charts

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 of the subject matter

The initial step in data visualization is to

create a table

The presentation of data in a pictorial or graphical format is also known as

data visualization

Header row

every column has filtering in the header row -filtering sorts data quickly

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

An argumentative paper is usually an exercise in exploration and evaluation

false

If a job posting does not specifically require a cover letting, 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 is data

numbers, characters, symbols, images which can be processed by a computer -data must be interpreted by human or machine to derive meaning

Which chart is best for showing proportions compared to the whole data

pie chart

According to the GCF videos on text basics, cut and paste options can be found by selecting the text and doing which of the following

right click

range reference

size and location of a range

total row

summary function

Who does goldreich identify as the target the author should present their ideas to?

the relevant community

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

The page layout tab can help you modify your page orientation, margins, and theme

true

visualization is really a dynamic form of persuasion through a telling story

true


Conjuntos de estudio relacionados

NSG 106 Chapter 4 Safety/Restraints

View Set

Current Leaders of different positions

View Set

Texas Teachers 158 Practice Exam

View Set

Chapter 10 Cognitive Psychology: Visual Imagery

View Set

HIST-1700-0035 Chapter 02 Diagnostic Quiz tthomas1515

View Set