The skills needed to create spreadsheets and graphs will stand students in good stead from junior high school through college and into their professional lives as adults. Start in 7th grade to teach your students how to create these data and math skills with Apple’s program called Numbers. And although, the assignments provided in this unit are written to take advantage of the tools available in Numbers, if you’re a Microsoft user, the ideas can be easily converted to Excel spreadsheets and graphs. The unit includes teacher instructions and screen shots on how to use the tools in Numbers and a follow-along assignment to introduce students to the basics of spreadsheets and graphs, including line graphs, column graphs and pie charts. Because there is value in reinforcing these skills over a two-year period, six assignments have been included, three each for 7th grade and 8th grade. Besides reproducible instructions for each of the seven assignments in this unit, I’ve also provided seven grading rubrics and seven completed assignments so you can see what the finished product should look like. The seven student assignments are based on data available at internet websites, so you can also judge how well your students are navigating the internet. The unit includes 46 pages of information with the how-to manual, the assignment instructions and the grading rubrics available in PDF form and the completed assignments available in Numbers.
Numbers Spreadsheets and Graphs
by Diane Yale-Peabody
is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License