CS 110 Lecture exam 2
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
