GIS and Mapping in Excel

Fall 2022
Olympia
Evening
Freshman - Senior
Class Size: 25
4 Credits per quarter
Log in to add this offering to your saved list.
Taught by

Students in this course can develop essential spreadsheet skills, while learning to make maps inside an Excel worksheet, using the ArcGIS for Office software.  This course is designed for the newcomer to Excel to learn essential spreadsheet skills, which are important in many career paths.

This course builds a foundation for students interested in spreadsheeting, starting at the very beginning with a simple Excel orientation and moving to methods for computations and essential tabular functions.  Further lessons will teach how to use filters, pivot tables, vlookup functions, and how to create charts in Excel.

Students will learn how to obtain tabular data from the web and reformat that data for ingestion into the GIS (Geographic Information System). GIS datasets are based on tables that contain spatial and non-spatial content.  Increasingly, map makers rely on the Microsoft Excel spreadsheet software to manage data tables and improve and ensure data quality. The ArcGIS for Office software (made by Esri, Inc) puts Excel tabular data into a GIS and then onto a map. There are then many options for managing the map’s appearance conducting spatial analysis.  

ArcGIS for Office lets users export their Excel maps into interactive Powerpoint slides, which useful for sharing maps with colleagues. In addition to sharing maps, other popular methods for formatting and communicating a spreadsheet’s content will be covered, such as dashboards, and other layout tools.  

There is no prerequisite GIS knowledge or Excel knowledge needed to take this course. 

This course will be offered in hybrid mode so students can choose to take the course in the TESC Computer Applications Lab. Students who have a home computer - with Windows operating system - and the ability to install the ArcGIS for Office software can take the course over Zoom simulcast.  Two monitors are recommended to take this course from a home computer.

Registration

Fall 2022 Registration

Course Reference Numbers

(4): 10322

Academic details

Certificates

This offering is connected to the undergraduate Geographic Information Systems Certificate at Evergreen. For more information visit: https://www.evergreen.edu/certificates/geographic-information-systems

Credits
4
Maximum Enrollment
25
Class Standing
Freshman
Sophomore
Junior
Senior

Schedule

In Person or Remote
In Person
Time Offered
Evening
Schedule Evergreen link
see Schedule Evergreen for detailed schedule

First Meeting

LAB 2 1223B - CAL East
Location
Olympia