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

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:




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


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


 * 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:


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


 * Chart Design:
 * Q - How has the Golden Rectangle rule been adopted in the previews shown?
 * Q - Why was a Bar chart used for this example instead of a Pie chart or a Line graph?


 * 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?