This fun graphing activity teaches students of all ages how to make unique pictorial graphs using Excel. The step-by-step, illustrated illustrations make it easy to teach the lesson in one class period.
Options for younger and advanced students are included, so the activity may be adapted to a wide variety of age and ability levels. Optional additional resources are also included to make the activity more educational, like a data collection form and picture cards to use during the data collection phase.
The zipped folder contains …
…an activity packet (in PDF) that includes instructions for the teacher, a reproducible student instructions document, picture cards, and a data collection form.
…a separate set of Excel worksheets for younger students (pictograms are automatically created as students enter their numbers [data] into five cells).
…an original Excel file containing a sample data table and pictogram to use as a resource and/or teaching aid with older students (4th through 7th).
...an editable student instructions page (Word format) to allow for lesson modifications or additions (i.e., related to using the school’s technology and media storage devices).
Please Note: The screenshots in the student instructions page are from Excel 2016 for PCs (which is very similar to Excel 2013), but completing the activity using Excel 2010 will require some modifications to the student page of instructions. Most menus use the same names, but their appearance and locations differ. Adding chart and axis titles is very different in Excel 2010, so those procedures will need to be modeled for users of the 2010 version.