Tables, Charts, Graphs Practice
In this session, you create a table, a chart, and graph using your preferred word-processing application. (Be aware that these exercises have not been used significantly and may have some bugs. Let me know.)
- Create a table according to these specifications (add any extra graphic design features as you wish):
Create a four-column table with the following title as the top row spanning all four rows: "Table 1 Comparison of three brand name treadmills." Make the title bold. Create the following column heads in the next row: Features, Nordic Trac, APEX 6106, Sports Art 3100-HR. In the first main data row, include the following: Motor, 3.0 CHP, 2.0 CHP, 2.7 CHP. In the next row: Frame, Steel, Steel, Steel. In the next row: Speed range, 0 – 10 mph, 0 – 11 mph, 0 – 11mph. In the next row: Incline, 0 – 12%, 0 – 15%, 0 – 12%. In the next row: Belt thickness, 2-ply, 4-ply, 2-ply. In the next row: Belt size, 20" × 60", 30" × 55", 20" × 57". In the next row: Storage, Space Saver design, Non-foldable, Non-foldable. In the next row: Program variety, 31 programs, 8 programs, 5 programs. In the next row: Weight capacity, 300 lbs, 300 lbs, 325 lbs. In the final row: Cushioning, Dura Soft, Cushioning, Shock Dissipation System. Use bold or italics for the column headings; consider using italics for row headings (first column). Left-align all cells except for the title.
- Create a chart according to these specifications (add any extra graphic design features as you wish):
First, here is a recording about doing a simple column chart in Excel 2007 (although this is such a basic task, I doubt the version matters).
Create a column chart (as defined by Microsoft) that shows the 1995 combined cycle and 1997 photovoltaic power plants each rated at 28% CP. Source: 1990 Energy Technologies Status Report, California Energy Commission. For this chart, create a verical axis labeled "30-Year Cost in Millions of U.S. Dollars," start at 0 and ending at 250. Make a red bar that reaches to 235 and blue bar to its immediate right that reaches to 23. Center the label under the the horizontal axis for these bars entitled "80-Megawatt Photovoltaic Power Plant." Next to these two bars, create a red bar that reaches to 35 and blue bar to its immediate right that reaches to 175. Center a label under the axis for these bars entitled "80-Megawatt Natural-Gas Combined-Cycle Power Plant. Include a legend for this chart in which blue indicates operating cost and red indicates capital cost.
- Create a line graph using the data in this table and add appropriate labels, title, date, and source citation. The source is http://www.w3schools.com/browsers/browsers_stats.asp; date is April 3, 2017; make up an appropriate title (and place it correctly).
Here is a recording about doing a simple line graph in Excel 2010 (although this is such a basic task, I doubt the version matters).
- Name this file (or these files) beginning with some identifiable part of your name followed by _tablesetcformat1, and e-mail it to your instructor.
Programs and information provided by firstname.lastname@example.org.