Activity 1: Introduction to Cumulative Frequency Tables

In this section, you will learn how to organise information from a frequency table into a cumulative frequency table.

To start off, view the video lesson below to understand how the cumulative frequency table is created.



After viewing the video lesson, record down your learning points on the wall below. Refresh the page regularly to see what your friends have written and feel free to comment back on their points.

3E1


3E2


3E4

Activity 2: Creating Cumulative Frequency Tables with Excel

In this section, you will learn to use simple Excel functions such as SUM to create your own cumulative frequency tables.

To start off this activity, please download the activity 2 excel spreadsheet below and save it onto your D drive.

For your practice problems, you may want to refer to the video lesson in the previous activity on calculating the cumulative frequency.

Activity 3: Creating Cumulative Frequency Diagrams with Excel

For this part of the lesson, you will learn to create cumulative frequency diagrams using scatterplots in Excel.

Before that, view the following video lesson to get an idea of how a cumulative frequency diagram is obtained from the cumulative frequency table.



Then download the activity 3 excel spreadsheet from the file box found in the previous activity and save it into the D drive.

Activity 4: Wrapping up the lesson

This activity marks the end of the lesson today. Before leaving the class, take some time to complete the simple questionnaire below as a way of recapping today's lesson.