There are multiple ways to sort the data. The fastest way is to click a small box on the right side of a column and you can choose various ways to sort the data. The other way is to select the "Sort & Filter" function directly beside the "Find/Replace" tool. (It's all together...how convenient!)
Lastly, I was able to calculate the sum, average, max, etc. of the data in individual columns.
Not having used excel in quite some time, it took some catching up to do and playing around with it to figure out where everything was again. I attached a picture of what the data looked like after using the "Find/Replace" function, sorting, and calculating the sum of ages.
Standards the activity would fall under include:
1. Facilitate and Inspire Student Learning and Creativity
a. model creative and innovative thinking
b. engage students in solving real problems using digital tools and resources
c. promote student reflection using collaborative tools to clarify students’ understanding thinking, planning,
and creativity
2. Design and Develop Digital-Age Learning Experiences and Assessments
a. design relevant learning experiences that incorporate digital tools and resources to promote student learning and creativity
d. provide students with multiple formative and summative assessments aligned with content and technology standards and use that data to inform learning and teaching
c. communicate relevant information and ideas effectively to students, parents, and peers using a variety of digital-age media and formats
d. model and facilitate effective use of current and emerging digital tools and resources to support research and learning
Copyright © 2008, ISTE (International Society for Technology in Education), 1.800.336.5191 (U.S. & Canada) or 1.541.302.3777 (Int’l), iste@iste.org, www.iste.org. All rights reserved.
No comments:
Post a Comment