Courses/Computer Science/CPSC 203/CPSC 203 Template/Labs Template/TA Examples for Spreadsheets/Ibrahim: Week 2 - Lab 1

From wiki.ucalgary.ca
Jump to: navigation, search

Ibrahim: Week 2 - Lab 1

EXAMPLE. The spreadsheet given below contains the population (as of July 2007) and area in square kilometers for a few countries (source: CIA's The World Fact Book). Use this data to plot a 2D Bar chart for both the population and area against the country names.

Download This File: Media: W2c1_chart_data_set.xls

Then reformat the chart according to the instructions given below.

Preview:

W2c1-1.png

  • Tasks 1:
    • Create a chart from the the data set provided, as shown below.
    • Q - Why is this not a good chart?

W2c1-2.png

  • Task 2:
    • Create a new column for the population in hundreds, as shown below.

W2c1-3.png

  • Task 3:
    • Change the chart's data source and title for the population from the current (on column B) to the newly created one (on column D). The new graphs should look something like this:

W2c1-4.png

  • Task 4:
    • Add a header, axis labels and change the location of the legend on the chart, so that it looks something like this

W2c1-5.png

  • Chart Evaluation:
    • Q - Which of the countries given has
      • the largest population ?
      • the smallest population ?
      • the largest area ?
      • the smallest area ?
      • more than a hundred people per square kilometer?
      • less than a hundred people per square kilometer?