Analyzing Data Using Excel
1 Analyzing Data Using Excel
Rev2.01
Analyzing Data Using Excel
Analyzing data is an important skill for any professional to possess. The existence of
data in its raw collected state has very little use without some sort of processing.
Examples of this are the answers to quiz questions that are collected from students.
If no further examination of the quiz answers is undertaken, you will not know if the
students passed or failed. Further, you would not know how one student performed
as opposed to another. Excel can assist you in this analysis of data. You can grade
the students’ results and chart their progress. You can even allow the modification of
data through web pages. If you teach, you keep student data; so make the most of
your available data and use it efficiently by evaluating that data with Excel.
In this workshop you will learn to use the features in Excel 2000 to track student
progress and analyze general data. You will import the textual results of an online
quiz. You will also create a spreadsheet to analyze that data. Collaborative
enhancements to spreadsheets will be used such as saving worksheets as web
pages and adding interactivity. You will also import survey data and analyze it with
pivot tables and charts. Let’s make use of your data by analyzing it, today!
Before You Begin
Excel is Microsoft’s popular spreadsheet software that enables the calculation and
display of complex mathematical formulas. Extensive formatting is available to
customize the viewing of these calculations as well. It imports data from a variety of
sources. Internet Explorer 5 adds new web discussion features that enable you to
take your documents that have been saved as web pages and hold discussions on
them and even take advantage of interactivity that may be added to the web page.
The web-based documents can then round trip those documents back into Excel for
editing using the familiar environment used to create the document in the first place.
What you will do:
4 Create a
spreadsheet
4 Use f