4/21/2016 Hosted by Campus Training Visit: www.csub.edu/training/ - - PDF document

▶
4 21 2016
SMART_READER_LITE
LIVE PREVIEW

4/21/2016 Hosted by Campus Training Visit: www.csub.edu/training/ - - PDF document

Mar 01, 2024 191 likes •266 views

4/21/2016 Hosted by Campus Training Visit: www.csub.edu/training/ Email: training@ csub.edu Contact: Tammara Sherman, 661-654-6919 Visualizing data basics Line charts Bar & Column charts Pie & Doughnuts charts Pivot

slide-1
SLIDE 1

4/21/2016 1

Hosted by Campus Training

Visit: www.csub.edu/training/ Email: training@ csub.edu Contact: Tammara Sherman, 661-654-6919

  • Visualizing data basics
  • Line charts
  • Bar & Column charts
  • Pie & Doughnuts charts
  • Pivot charts

Balance Communicate Insightful

  • Using graphical means to convey

information clearly and effectively

  • Functional and aesthetic
  • Make sense of data

Source: Vitaly Friedman (2008) "Data Visualization and Infographics" in: Graphics, Monday Inspiration, January 14th, 2008.

“Yet designers often fail to achieve a balance between form and function, creating gorgeous data visualizations which fail to serve their main purpose — to communicate information“ (Friedman 2008).

slide-2
SLIDE 2

4/21/2016 2

“The eye is exquisitely sensitive to patterns in variations in color, shape and pattern.”

(David McCandless, 2010 TED Talk) “A picture is worth a thousand words.” The Value of Visualization

Should it be a bar, column, or pie chart? What am I visualizing, trends over time, numbers

  • f things, or distributions
  • f things?

How can I make it be more meaningful?

What do I really want to see?

slide-3
SLIDE 3

4/21/2016 3

7

  • Use when 2 or more items
  • Show trends over time
  • Visual comparison

192 75 150 216 20 50 150 503 35 58 72 115 100 200 300 400 500 600 2012 2013 2014 2015

Training Attendees

FDW Office ProCard Scale

  • Counts
  • Dollars

Categories

  • Time, Things, Terms, etc

Values

  • Counts
  • Sums
  • Products

Legend

  • Series 1 Name
  • Series 2 Name

486 588 453 484 100 200 300 400 500 600 700 SAT ACT

SAT/ACT Scores

Male Female 9

  • Use when 3 or more items
  • Show trends over time
  • Visual comparison
slide-4
SLIDE 4

4/21/2016 4

Scale

  • Counts
  • Dollars

Categories

  • Time, Things, Terms, etc

Values

  • Counts
  • Sums
  • Products

Series 1 Series 2

Legend

  • Series 1 Name
  • Series 2 Name

11 1 1 2 2 12 Curriculum Developer Preschool Teacher* Education Administrator Teacher-Leader Teacher 2 4 6 8 10 12 14

Cu Curre rrent E Educator R ator Role le

Teach college* Early Childhood Director* Curriculum Developer Teacher Education Administrator Teacher-Leader Principal

1 2 3 4 Intended Career/Position

  • Use when 3 or more items
  • Show trends over time
  • Visual comparison
  • Works well with long names
  • Same as column charts (horizontal)

Scale

  • Counts
  • Dollars

Categories

  • Time, Things, Terms, etc

Values

  • Counts
  • Sums
  • Products

Series 1 Series 2

Legend

  • Series 1 Name
  • Series 2 Name
slide-5
SLIDE 5

4/21/2016 5

13

48-66 42% 29-47 37% under 28 21%

12.3 %

68% Of the students participated Of the respondents were Female Age

  • Use when you have 2 or more items
  • Shows proportionality

Scale

  • Percent

Categories

  • Time, Things, Terms, etc

Values

  • Counts
  • Sums
  • Products

Series 1 Series 1 Series 2 Series 2

Legend

  • Series 1 Name
  • Series 2 Name

Scale

  • %

Categories

  • Time, Things, Terms, etc

Values

  • Counts
  • Sums
  • Products

Legend

  • Series 1 Name
  • Series 2 Name

Series 1, 50 Series 2, 50

%

slide-6
SLIDE 6

4/21/2016 6

Go to:

  • 1. Open Windows Explorer or My

Documents

  • 2. Navigate to:
  • Facshare (s:)//tsherman/E2016O

Excel 2016 and Graphs

  • 3. Copy to your desktop
  • Excel and Graphs Data.xlsx

Grades Counts A 100 B 250 C 150

slide-7
SLIDE 7

4/21/2016 7

  • Columns and Values
  • Values are Text or Numbers

Column 1 Column 2 Value Value

Business Unit Fiscal Year Period Accounting Date Acct Cat Account Fdescr Amount BKCMP - CSU Bakersfield 2015 208/25/2015 604 604001 - Telephone Usage 5.95 BKCMP - CSU Bakersfield 2015 208/31/2015 604 604001 - Telephone Usage 9.94 BKCMP - CSU Bakersfield 2015 309/29/2015 604 604001 - Telephone Usage 4.82 BKCMP - CSU Bakersfield 2015 410/13/2015 604 604001 - Telephone Usage 10.89 BKCMP - CSU Bakersfield 2015 511/19/2015 604 604001 - Telephone Usage 13.25 BKCMP - CSU Bakersfield 2015 612/31/2015 604 604001 - Telephone Usage 17.24 BKCMP - CSU Bakersfield 2015 701/19/2016 604 604001 - Telephone Usage 12.44 BKCMP - CSU Bakersfield 2015 802/12/2016 604 604001 - Telephone Usage 10.42 BKCMP - CSU Bakersfield 2015 701/13/2016 606 606001 - Travel-In State 270.83 BKCMP - CSU Bakersfield 2015 107/16/2015 660 660002 - Printing 1.92

Numerous resources for Excel 2016 are available on the web. GCFLearnFree.org YouTube Google Search

GCF LearnFree.org

Provides great step-by-step instructions and videos from basic to advanced users. Lesson 23: Charts

YouTube

Provides great videos from basic to advanced users.

Search Engines

Provides great videos, forums, and instructions from basic to advanced users.

  • Visualizing data basics
  • Line charts
  • Bar & Column charts
  • Pie & Doughnuts charts
  • Pivot charts