Buletin Poltanesa
Vol 27 No 1 (2026): June 2026

Basic Mapping Techniques Training: GPS Data Analysis with Microsoft Excel

Andrew Stefano (Agricultural Polytechnic of Samarinda)
Sri Endayani (17 Agustus 1945 University)



Article Info

Publish Date
26 Jun 2026

Abstract

Basic mapping techniques training with a focus on GPS data analysis using Microsoft Excel is a community service activity that aims to improve participants' skills in processing spatial data effectively. This training was held at the Rahmatullah Lempake Islamic Boarding School, North Samarinda, with the main participants being intermediate level students. This program is designed to provide a basic understanding of coordinate data collection using Garmin 60CSX GPS devices and processing survey data using Microsoft Excel. The training methods include theory sessions, hands-on practice in the field, and data processing simulations. The material provided includes an introduction to GPS functions, coordinate point retrieval techniques, data transfer from GPS to a computer, and data processing using basic Excel features such as tables, filters, graphs, and simple statistical functions. The results of the training showed an increase in the participants' ability to understand the basic concepts of mapping, manage coordinate data, and visualize survey results in the form of simple graphs and maps. Evaluation was carried out through pre-test and post-test to measure the level of understanding of participants before and after the training. The results of the evaluation showed an increase in the average score of the participants by 85%. In addition, participants were able to generate GPS data analysis reports independently using Microsoft Excel. This training is expected to be a solid foundation for participants to develop skills in the field of spatial data mapping and analysis, which are relevant in various fields such as geography, environment, and regional planning.

Copyrights © 2026






Journal Info

Abbrev

tanesa

Publisher

Subject

Agriculture, Biological Sciences & Forestry Computer Science & IT Education

Description

Buletin Poltanesa is a collection of research articles, scientific works, and dedication from all academic community in order to integrate information. Buletin Poltanesa provides open publication services for all members of the public, both in all tertiary educational and teacher environments and ...