We received our fifth LEARN SOMETHING NEW TEAM CHALLENGE submission. Thank you for participating, Robert and Morgan.
The team will post updates in the comments section of this post so please check back regularly to hear how this Student Data Visualization project is coming along.
Here are the details so far:
Project Name: Student Data Visualization
Current Situation or Problem: Teachers have a limited ability to view data to maximize their instructional effectiveness.
Purpose and Details of the Project: We need a way to help teachers to visualize student data to inform instruction. They need to be able to look at historical data (of previous students) to identify gaps in instruction/learning in order to reflect effectively on their own practice. They also need to be able to be able to evaluate student data of their incoming students so they can design curriculum and instruction for the upcoming year.
Roles of Members on the Team: Robert Douglas: create and implement an excel tool that will allow teachers to effectively analyze data. Morgan Williams: to ensure that data instrument effectively displays all pertinent data.
Learning Objectives: Robert needs to learn to use the new version of Excel (Excel 2010) and the new PowerPivot. He also needs to learn the basics of dashboard design and advanced excel charting techniques. Success will be measured by the quality of the finished data instrument.
|Title: PowerPivot for the Data Analyst: Microsoft® Excel 2010
By: Bill Jelen
|Title: Charts and Graphs: Microsoft Excel 2010
By: Bill Jelen
|Title: Create Dynamic Charts in Microsoft® Office Excel® 2007 and Beyond
By: Reinhold Scheck
Publisher: Microsoft Press
Due Date: August 16, 2010
Comments: Because PowerPivot is such a new product, there were no manuals or guides available. If not for the availability of rough cuts, it would be an impossible project.