computer science midterm exam

True or false: Always start the quantitative scale at zero when using bars to encode the values

True

True or false: Column headers should be aligned to match the alignment of the corresponding data

True

True or false: If you want the reader to be able to easily compare values in two separate columns of data, you should place the columns in the table in close proximity to one another

True

According to the textbook author, in a table all dates should be aligned...

any way you like, just keep the number of digits in each part of the date (month, day, year) consistent

Table: Predict the number of buttons that will be needed at several shirt-making plants in the next fiscal year

Planning

Table: Discover which brand of pants is most true to their size

Analyzing

True or false: Using 3D displays of quantitative data usually makes a graph easier to read

False

For encoding categories graphically, which is the most common?

2-D position

In Lab 6, what function was used for adding up the items in a range (# of hot dogs eaten for each person, for example) when the match was true? Select one:

=Sumif()

Which bar type: Professor Jones wants to compare the pre-test and post-test scores of all the students in her robotics class

Bar

In Lab 1, we found the net worth of rap artists. This is an example of which step of the data science process?

Data collection

Table: Show a comparison of local vs. national spending to convince the county to increase funding to area elementary schools

Communicating

In Lab 1, we used a bar chart to compare the reported and actual net worth of rap artists. This is an example of which step of the data science process?

Data visualization

Which quantitative relationship: You wish to show the variance of unemployment rates of adults across Nordic Countries

Deviation

Table or graph: Do Amazon sales rise during the holiday season?

Graph

Table or graph: How has the percentage of people who own an Apple smartphone changed over time since 2007?

Graph

In Lab 2, we visualized how SAT Math Scores have changed over time in the Alamance-Burlington school district. Generally, for graphs involving time-series data, time should be shown:

In a graph on the x-axis

Which bar type: You wish to your expenditures (food, rent, entertainment) for each month over the last year

Line

Given data that lists the annual salaries for the employees in the marketing department (including interns, analysts, managers, etc.), what would be the best measure to produce the typical salary?

Median

Table: Track the current number of defects at several manufacturing plans in real time

Monitoring

Which quantitative relationship: You wish to show the comparison between the first quarter 2016 donations by region (North, South, East, West)

Nominal Comparison

A categorical relationship that has a prescribed order (such as first, second, third, ...) would be considered which type of relationship?

Ordinal

Which quantitative relationship: You wish to show the percentage of dollars spent on food in the U.S. in the year 2010 that went to farmers versus packaging, transportation, and "Other" costs

Part-to-whole

In lab 3, we wanted to reveal the accuracy of McDonald's nutrition information by asking the question "What percent difference did foods test over/under their advertised values for calories per 100 gram serving?" This is an example of which step of the data science process?

Problem formulation

Which quantitative relationship: You wish to compare the size of the departments (Manufacturing, Sales, Engineering, Finance, Human Resources, and Marketing) within an organization, arranged from largest to smallest

Ranking

Table or graph: Looking at the sales data, by quarter, for 8 cell phone manufacturers from 2007-2017, how many smart phones were sold by Apple in the 4th quarter of 2008?

Table

Which quantitative relationship: You wish to show the decline in the success of products that are more technical in nature and the increase in those that are geared toward entertainment over the last five years

Time Series

Our textbook author gives preferred rules for tables. Which of the following does NOT belong? a. Use white space alone whenever space allows b. Use grids (combined horizontal and vertical whenever possible) c. Use subtle fill color when white space isn't possible d. Use boldfacing to group or highlight data

b. Use grids (combined horizontal and vertical whenever possible)

Which of the following is true about how to decide how much precision to use in displaying decimal points in a table? a. You should use as much precision as offered, by default, by the tool b. You should always use two decimal points c. Do not exceed the level of precision needed to serve your communication objectives and the needs of your readers d. Whole numbers are sufficient

c. Do not exceed the level of precision needed to serve your communication objectives and the needs of your readers

According to the textbook author, in a table all numbers should be aligned...

to the right