Eisenhower Middle School

Wyckoff, New Jersey

Computer Technology 7-1

Click Here To Login To Eisenhower Google Apps

Click here to learn more about Google Apps

2. Student Info Data Project

A. Collecting the Student Data

Option #1 - Online data entry

1. Access the online survey and fill in your information.

2. Access the Student Data Spreadsheet that contains the results of the online survey. (You must login to Eisenhower Google Apps to view this).

3. Now that you are viewing the Student Data Spreadsheet in Google Docs, you need to download it onto your computer into Excel.  Do this by going to FILE> DOWNLOAD AS...> EXCEL.

4. Choose SAVE AS when prompted. The file will download and appear in a window that pops up.

5. Click on the downloaded file to open it.

6. Immediatly SAVE the file to your desktop.  Call it "Student Data - Your Initials".

 Option #2 - In class data collection

Collect data from people in your class using paper and pencil.   Learn how to sort and filter the data in the spreadsheet.

See the Directions Handout for more information.

B. Manipulating Your Student Data

How to Sort data in Excel (detailed pdf version)

How to Filter data in Excel (detailed pdf version)

Once the information has been collected, complete the following:

1. Follow the directions for the Student Data Setup

2. When you are ready to Sort and Filter your data, see the Student Data Requirments for a list of the project requirments for sorting and filtering you data.

More with Excel:

Download a sample spreadsheet of student data.