TEC-GIS45-01 · Lesson 6 · 18 clock hours · lab
Digital Productivity Tools for GIS and Survey Professionals
Objective. Students organize field data using cloud storage and file-naming conventions, perform data entry and basic computation in a spreadsheet, and compose professional technical emails and reports using industry-standard formatting.
⚠ Pending professional review
This lesson, its worked examples and its practice questions has not yet been verified by an industry-certified professional or by a certification or approval body. It is a study draft and may contain errors. Do not use it as instructions for work on a job site or on live equipment. Always follow your instructor, your supervising professional, and current official references and regulations.
VoTechWorks program approval and accreditation are still in progress. Credentials are issued only by the certifying bodies named in each program, after their own exams.
Why Digital Productivity Skills Matter in GIS and Surveying
Field crews collect raw data every day—GPS coordinates, elevation readings, equipment logs, and site observations. That data is only useful if it is organized, accurate, and communicated clearly to clients, project managers, and regulators. Employers in GIS, surveying, and drone operations expect every technician to manage files systematically, work competently in spreadsheets, and write professional documents. These skills are tested indirectly in NSPS CST and Esri ArcGIS Pro certification work, and they underpin every deliverable you will produce as a professional.
File Organization and Cloud Storage
A consistent folder hierarchy prevents data loss and saves hours of searching. The industry convention used in this program follows a three-level structure:
```
ProjectName / YYYY-MM-DD / DataType
```
For example: `OakStreetSurvey / 2025-06-10 / ControlPoints`
Using ISO date format (year-month-day) keeps folders sorted in chronological order automatically. Data-type folders hold raw files in their original format—never overwrite originals. Place processed or edited versions in a clearly labeled subfolder such as `Processed` or `Final`.
Cloud platforms such as Microsoft OneDrive and Google Drive provide version history, which means earlier versions of a file can be recovered if a mistake is made. Always name files descriptively: `OakSt_ControlPts_Raw_2025-06-10.csv` is far safer than `data1.csv`. Avoid spaces in file names; use underscores or hyphens instead, because many GIS applications and command-line tools misread spaces.
Safety and data-security note: Never store files containing client personally identifiable information or sensitive site coordinates on an unsecured personal device or public cloud account without employer authorization. Follow your organization's data-handling policy.
Spreadsheets for Field Data
Spreadsheet software (Microsoft Excel or Google Sheets) is the everyday tool for reviewing, cleaning, and summarizing field data before it enters a GIS or survey-adjustment program.
Importing CSV data: A CSV (comma-separated values) file is a plain-text format that nearly every instrument and data collector can export. When you open or import a CSV, verify that column headers match what you expect—point ID, northing, easting, elevation, and description are typical for survey data.
Cleaning common errors:
- Remove blank rows between data records.
- Check for text characters in numeric columns (for example, an elevation recorded as `102.4m` instead of `102.4`).
- Verify that coordinate values are within the expected geographic range for your project area.
- Flag and document any suspicious value rather than deleting it silently—note it in a comment cell and inform your supervisor.
Summary statistics: Three formulas cover most field-data summaries:
- `=MIN(range)` — lowest value in a column
- `=MAX(range)` — highest value in a column
- `=AVERAGE(range)` — arithmetic mean of the column
These tell you the elevation range across a site and help identify outliers before data reaches the project file.
Charts: An XY scatter chart (also called an XY plot) graphs easting on the horizontal axis and northing on the vertical axis, giving a rough plan view of point locations. Label axes with units, add a chart title, and include the project name and date in the chart area or caption.
Professional Email Communication
Email is a legal business record. In GIS and surveying, a poorly written email can damage client trust or create confusion about deliverables and deadlines.
A professional technical email includes:
1. Subject line — specific and informative: OakStreetSurvey – Schedule Update Due to Weather
2. Salutation — use the recipient's name and a professional greeting.
3. Opening sentence — state the purpose immediately.
4. Body — one idea per paragraph; plain language; no slang or unexplained jargon.
5. Action item or next steps — tell the reader exactly what happens next and by when.
6. Closing and signature — your full name, job title, company, and contact information.
When notifying a client of a weather delay, acknowledge the inconvenience briefly, explain the reason factually, state the revised schedule clearly, and attach any supporting documents (a revised timeline, for example) with a short note describing each attachment.
Field Reports
A field report documents what happened on site. It protects you, your company, and the client. Standard sections in most survey and GIS field reports are:
| Section | What to include |
|---|---|
| Project name and number | As shown on the contract or work order |
| Date and time | Start and end of field work |
| Weather | Conditions at start and end; note any changes |
| Personnel | Full names and roles of everyone present |
| Equipment used | Instrument make, model, and serial number |
| Observations | Work completed, issues encountered, decisions made |
| Next steps | What remains; who is responsible; target date |
Always export the completed report as a PDF before uploading. PDF preserves formatting across different devices and operating systems, ensuring that what the client or supervisor sees matches what you prepared.
Saving and Submitting Work
Upload files to the correct cloud folder immediately after completing each task—do not save only to a local drive. Confirm the upload is complete (the file appears in the folder and can be opened) before closing the application. Use the naming convention provided by your instructor, which mirrors professional practice.
Key terms9
CSV (comma-separated values)A plain-text file format where each data value is separated by a comma; the standard export format for most survey instruments and GPS data collectors.
Folder hierarchyA structured, nested arrangement of folders (project / date / data-type) that keeps files organized and findable across a project team.
ISO date formatThe international date notation YYYY-MM-DD (e.g., 2025-06-10) that sorts chronologically in file systems and avoids regional date-format confusion.
Summary statisticsNumerical measures—minimum, maximum, and mean—that describe the range and central value of a data set, used to quickly check field data before processing.
XY scatter chartA graph that plots two numeric variables on perpendicular axes; in surveying, commonly used to display point easting (X) versus northing (Y) as a rough plan view.
Field reportA standardized written record of a site visit that documents date, personnel, equipment, weather, work completed, and next steps; a legal project record.
PDF (Portable Document Format)A file format that preserves the visual layout of a document regardless of the software or device used to open it; the standard format for submitting final reports.
Version historyA cloud storage feature that saves previous copies of a file automatically, allowing recovery of data overwritten or deleted in error.
Data cleaningThe process of identifying and correcting errors in a data set—such as blank rows, text in numeric fields, or out-of-range values—before analysis or import into GIS.
Worked examples4
1. A CSV file contains elevation data for five survey points: 312.4, 298.7, 305.1, 321.0, and 309.8 feet. Calculate the minimum, maximum, and mean elevation.
- List all five values: 312.4, 298.7, 305.1, 321.0, 309.8
- Identify the minimum: scan the list — 298.7 is the smallest value.
- Identify the maximum: scan the list — 321.0 is the largest value.
- Calculate the mean: add all values together — 312.4 + 298.7 + 305.1 + 321.0 + 309.8 = 1547.0
- Divide the sum by the count of values: 1547.0 ÷ 5 = 309.4 feet
Answer: Minimum = 298.7 ft; Maximum = 321.0 ft; Mean = 309.4 ft
2. During data cleaning you find that one cell in the Elevation column contains the text '315.2m' instead of the number 315.2. Describe the steps to clean this error in a spreadsheet.
- Click on the cell containing '315.2m'.
- Delete the contents of the cell.
- Type the numeric value 315.2 (no unit label) and press Enter.
- Verify the cell is now left-aligned if it was storing text, or right-aligned confirming it is recognized as a number.
- Add a comment to the cell documenting the original entry ('315.2m') and the date of correction, then notify your supervisor of the data anomaly.
Answer: Cell value corrected to the number 315.2; original error documented in a cell comment.
3. A project folder is named 'survey data june 10 2025 control'. Rewrite this folder name to follow the convention ProjectName / YYYY-MM-DD / DataType, correcting spacing and format issues.
- Identify the three components from the original name: project name ('survey data'), date ('june 10 2025'), and data type ('control').
- Format the project name using title case and underscores instead of spaces: 'SurveyData' or 'Survey_Data'.
- Convert the date to ISO format: June 10, 2025 becomes 2025-06-10.
- Capitalize the data type consistently: 'ControlPoints'.
- Assemble the full path: SurveyData / 2025-06-10 / ControlPoints
Answer: SurveyData / 2025-06-10 / ControlPoints
4. An elevation data set has 8 points. After cleaning, the values are: 410.2, 398.5, 405.0, 412.7, 400.1, 407.3, 395.8, 403.6 feet. Compute the mean elevation.
- Add all eight values: 410.2 + 398.5 + 405.0 + 412.7 + 400.1 + 407.3 + 395.8 + 403.6
- Running total: 410.2 + 398.5 = 808.7; + 405.0 = 1213.7; + 412.7 = 1626.4; + 400.1 = 2026.5; + 407.3 = 2433.8; + 395.8 = 2829.6; + 403.6 = 3233.2
- Divide the sum by the number of points: 3233.2 ÷ 8 = 404.15 feet
- Round to two decimal places as appropriate for survey data: 404.15 ft
Answer: Mean elevation = 404.15 ft
The math in this lesson1
Learners find the minimum, maximum and mean (309.4 ft) of five field measurements in a spreadsheet.
S-ID.2
In class: Set up a cloud folder hierarchy following a provided naming convention (project/date/data-type), import a CSV of simulated field point data into a spreadsheet, clean formatting errors, compute summary statistics (min, max, mean elevation), and create a simple XY scatter chart of the points. · Draft a professional email to a hypothetical client explaining a schedule delay due to weather and attaching a revised project timeline; peer-review for tone, clarity, absence of jargon, and correct grammar using a provided rubric, then revise and resubmit. · Complete a short field-report template documenting a simulated site visit: project name, date, weather, personnel, equipment used, observations, and next steps; format the report to match a sample employer standard, export as a PDF, and upload to the class cloud folder.
Materials: Classroom PCs with Microsoft 365 or Google Workspace; cloud storage (OneDrive or Google Drive); sample CSV point-data file; email rubric; field-report template; sample employer field report for formatting reference
Check: Spreadsheet graded against key for correct data cleaning, formula use, and chart labeling (80% correct); email and field report each evaluated with provided rubric—must score 'meets standard' on all four rubric categories (tone, accuracy, format, completeness) to pass.
Practice check8
Answer each question, then check it. Nothing is recorded; this is your own practice.
Record this lesson on my transcript. Sign in with your key and enrollment email to record lessons (enroll free if you have no key). This page stays open to read and practise.