Module 2

Front 1

RM

Back 1

these are resource materials that are found on the course website. There are files and online video tutorials available for each application. Practice files are also available.

Front 2

Data

Back 2

Facts "in a form that can be read, used, and manipulated by a computer." Ex: data would be the raw ingredients of a food recipe (eggs, milk, sugar, etc.)

Front 3

Information

Back 3

Collected and transformed data that communicates meaning. Ex: information would be the finished product produced from a recipe (soufflé)

Front 4

Process

Back 4

The sequence of steps that manipulates and transforms data into information. Ex: process is the actual execution of recipe steps (sift one cup of flour into a large mixing bowl, etc.)

Front 5

Fundamental Computer Components

Back 5

All computer systems have the following 4 components: Input, Process, Secondary Storage, Output

Front 6

Column (Bar) Charts

Back 6

Data that is arranged in columns or rows on a worksheet can be plotted in a column chart. Useful for showing data changes over a period of time or for illustrating comparisons among items.

Front 7

Line Charts

Back 7

Data that is arranged in columns or rows on a worksheet can be plotted in a line chart. Can display continuous data over time, set against a common scale, and are therefore ideal for showing trends in data at equal intervals. Category data on the horizontal axis, value data on the vertical axis

Front 8

Pie Charts

Back 8

Data that is arranged in one column or row only on a worksheet can be plotted in a pie chart. Show the size of items in one data series proportional to the sum of its items. Data points are displayed as a percentage of a whole pie.

Front 9

Data points

Back 9

individual values plotted in a chart and represented by bars, columns, lines, pie slices, dots, etc.

Front 10

Scatter Plot Charts

Back 10

data that is arranged in columns and rows on a worksheet can be plotted in an xy (scatter) chart. Show the relationship between two groups of numbers as one series of xy coordinates. Commonly used for displaying and comparing numeric values (scientific, statistical, and engineering data)

Front 11

Data Series

Back 11

A group of related data values belonging to a single category, usually separated by a time period. Each data series in a chart typically has a unique color or pattern. Can plot one or more data series in a chart expect pie charts which have only one data series

Front 12

Essential Chart Elements

Back 12

Most charts must include clear titles and labels in order to be effective. Legends aren't required for all charts, usually needed to distinguish between data series.