A simple way of creating charts to include in our courses is to use a spreadsheet application and then copy them over to Moodle. In this section, we will be investigating the two most popular spreadsheet applications: Microsoft Excel and OpenOffice.org. Let's start with Microsoft Excel.
In this example, I'm going to use Microsoft Office Excel 2003. The process we will be working through is the same for later versions of Excel. Note that it will also work with earlier versions, but you might have to hunt for the functions.
Here is a data handling question I am going to set for my students:
A workshop manager carried out a survey to find out how long people spent drinking refreshments during their morning break. Below is his data:
Time (t seconds) |
Number |
---|---|
0 < t ≤ 30 |
4 |
30 < t ≤ 60 |
10 |
60 < t ≤ 90 |
15 |
90 < t ≤ 120 |
17 |
120 < t ≤ 150 |
3 |
a) Draw a cumulative frequency curve for this...