InTeGrate Modules and Courses >Coastal Processes, Hazards and Society > Student Materials > University Park: Blended > Detailed Step-by-Step Instructions > Step 3: Open Data in Excel
InTeGrate's Earth-focused Modules and Courses for the Undergraduate Classroom
showLearn More
hideHide
These materials are part of a collection of classroom-tested modules and courses developed by InTeGrate. The materials engage students in understanding the earth system as it intertwines with key societal issues. The collection is freely available and ready to be adapted by undergraduate educators across a range of courses including: general education or majors courses in Earth-focused disciplines such as geoscience or environmental science, social science, engineering, and other sciences, as well as courses for interdisciplinary programs.
Explore the Collection »
show Download
hideHide
The student materials are available for offline viewing below. Downloadable versions of the instructor materials are available from this location on the instructor materials pages. Learn more about using the different versions of InTeGrate materials »

Download a PDF of all web pages for the student materials

Download a zip file that includes all the web pages and downloadable files from the student materials

For the Instructor

These student materials complement the Coastal Processes, Hazards and Society Instructor Materials. If you would like your students to have access to the student materials, we suggest you either point them at the Student Version which omits the framing pages with information designed for faculty (and this box). Or you can download these pages in several formats that you can include in your course website or local Learning Managment System. Learn more about using, modifying, and sharing InTeGrate teaching materials.
Initial Publication Date: December 7, 2016

Step 3: Open Data in Excel

  1. Next, open the Excel spreadsheet that you were provided. In the first row and column of a blank sheet, paste the data you copied in Step 2. This will paste all the data as a single column.
  2. We have provided British Columbia as an example for you to follow. Use this Excel document to add the data from your other two sites.
  3. You will now need to separate the data into four columns. You will do this using the "Data" tab and the "Text to Columns" tool. When you open the tool, your screen should look like Figure 4.43. Make sure you have all of your data selected, or the tool won't open.
    1. In the wizard Step 1, select the "Delimited" option, then hit next to move to Step 2.
    2. In Step 2, select the "semicolon" option, at which point the one column of data should appear in four separate columns separated by a vertical line.
    3. At this point you can hit "Finish" and your Excel sheet should have 4 columns (A, B, C, and D) of data.
    4. Your pasted data should look similar to the examples provided (although it will likely have different dates).

These materials are part of a collection of classroom-tested modules and courses developed by InTeGrate. The materials engage students in understanding the earth system as it intertwines with key societal issues. The collection is freely available and ready to be adapted by undergraduate educators across a range of courses including: general education or majors courses in Earth-focused disciplines such as geoscience or environmental science, social science, engineering, and other sciences, as well as courses for interdisciplinary programs.
Explore the Collection »