header
GLOSSARY


Polar Orbiting
- The satellite passes near or passes the north and south poles of the equator on the top or
bottom approximately 90 degrees.

Geostationary Orbit – An orbit, which places the object directly above the equator and remains stationary in the sky circling the Earth at the same rate of spin.

Syntax – A set of rules used to combine commands in a programming language

Latitude – Gives a location north or south of the equator

Longitude – Gives a location east and west of Greenwich, England

Remote Sensing – Examining without touching

Nautical Mile – A unit of measure equaling one minute of arc along any meridian. There are 60 nautical
miles in one degree of latitude

Knots – A unit of speed equal to one nautical mile per hour

RADAR – Radio Distance and Ranging. Records how long it takes the signal to bounce off an object

CERSER – Center of Excellence in Remote Sensing Education and Research

CReSIS – Center for Remote Sensing Ice Sheets

Datum- singular form information gathered

Data – plural form information gathered

.csv – Comma Separated Values

.ht – height file

MHz- One million cycles per second (Hertz)

.xlsx- extension for Microsoft Excel

.txt- text file

^p- paragraph mark

,^p
- comma paragraph mark

Formulas used in Excel:

=(C1-360) : C1 was a longitude ranging from 0-360º. This formula converted that longitude to a +
or – longitude ranging from 0-180º.

=IF((Sheet1!$A26/$I/$1)=INT(Sheet1!$A26/$I$1),Sheet1!A26,””) : This function compared a division
calculation to an integer division calculation. Used for reducing the number of lines visible in a spreadsheet.

=IF((H1=”0″),”0″, -(H1)) : If depth reading is in H column, converts it to a negative for graphing purposes.

=IF ((D1=0), M, If ((E1=C),C,A)) : An IF statement nested within a second IF statement. This function set
a cell to M, A, or C depending on the data in cells D1 and E1.

=IF(may14_05!$A2/ROUNDUP(COUNT(may14_05!$A:$A)/32000,0)=INT(may14_05!$A2/ROUNDUP
(COUNT(may14_05!$A:$A)/32000,0)),may14_05!A2,””) : This function compared a division calculation
to an integer division calculation.. Used for reducing the number of lines visible in a spreadsheet to
32000 lines or less.

=COUNTA(A:A): Total lines in column A

=COUNTIF(J:J,”M”) : number of M lines in column J

=COUNTIF(J:J,”C”) : number of C lines in column J

=COUNTIF(J:J,”A”) : number of A lines in column J

=IF(S1!$A1/ROUNDUP(COUNT(S1!$A:$A)/200,0)=INT(S1!$A1/ROUNDUP(COUNT(S1!$A:$A)/200,0)),
S1!A1,””) : This formula was use to reduce lines to 200 to convert the files into .CSV files for Google map.