Business Technology 11: Survey Says…

3.2 – Students will be expected to manipulate data using spreadsheet software to solve problems

3.3 – Students will be expected to use mathematical features of spreadsheet software to manage data

5.3 – Students will be expected to access and use information responsibly and ethically

5.6 – Students will be expected to manage hardware/software processes, files, and basic workstation procedures

Select a question in which the person’s answer can be placed in a category (ex, eye colour, favourite music genre, etc).

Your survey question: ______

1. Survey 20 people and display your data using a frequency table.

Category / Tally / Frequency / Percent (%) and Decimal

2. List three conclusions from your data.

3. Use the data to construct a labelled circle graphand bar graph using Excel. Paste both graphs below. Be sure each graph has a title.

4. If you surveyed 500 students, how many would pick the most popular category?

5. If you surveyed 500 students, how many would pick the least popular category?

Rubric:

4
/ 3
/ 2
/ 1
Survey and Data Table / Survey question is very creative and data table is very well done / Survey question is creative and data table is well done / Survey question is somewhat creative and data table is mostly well done / Survey question is not creative and data table is not well done
Data Displays / Data displays are readable and very attractive. / Data displays are readable and attractive. / Data displays are mostly readable and somewhat attractive. / Data displays are not readable or attractive.
Content and Calculations / All necessary information is included and calculations are correct. / Almost all necessary information is included and most calculations are correct. / Somenecessary information is included and some calculations are correct. / Necessary information is not included and calculations are incorrect.