essential standard 5 - advanced spreadsheet (charts)
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
---|---|---|---|---|---|
y-axis | the left vertical side of the graph. It contains the numerical data.
🗑
|
||||
x-axis | the bottom horizontal side of the graph. It contains the category information.
🗑
|
||||
Data markers | are used in a graph to indicate data values.
🗑
|
||||
data series | a collection of related values, such as one row or column from a spreadsheet.
🗑
|
||||
Gridline | a horizontal or vertical line that extends across the plot area of the graph for the purpose of adding clarification to the data.
🗑
|
||||
plot area | is the background portion of a graph. It is the area bound by the values (y) and categories (x) axes.
🗑
|
||||
tick mark | is used in a graph to clarify data categories or values.
🗑
|
||||
Legend | an object that explains the symbols, colors, or patterns used to differentiate the data.
🗑
|
||||
data label | a single value or text explanation used to explain the data in a series.
🗑
|
||||
chart title | the main heading, which describes the purpose and content.
🗑
|
||||
x-axis title | describes the horizontal data.
🗑
|
||||
y-axis title | describes the vertical data.
🗑
|
||||
embedded chart | is one that appears on the same sheet as the spreadsheet it represents; otherwise, it is referred to as a separate chart.
🗑
|
||||
linked chart | a chart that will reflect changes made to the spreadsheet it represents.
🗑
|
||||
column chart | used to make comparisons and generalizations about groups of data, such as to compare the number of students from each class (Sophomores, Juniors, and Seniors) to their attendance at assemblies.
🗑
|
||||
stacked bar chart | used to represent the sum of more than one value and compare the contribution of individuals to the whole, such as the total sales for three components to the whole sales for a store.
🗑
|
||||
line chart | used to show trends or changes in data over time, such as growth in sales over several quarters.
🗑
|
||||
XY scatter chart | used to show the correlation of two or more data sets, such as the correlation between stress rates and wait time in a doctor’s office.
🗑
|
||||
pie chart | used to represent the contribution of each component of one series of data to the whole, such as the percentage of expenditures to the total budget.
🗑
|
||||
exploded pie chart | a pie chart in which the individual components are enhanced.
🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
spencercte
Popular Computers sets