Shofan Fiangga, Rooselyna Ekawati, Muhammad Habibulloh, Sari Kusuma Dewi
In this paper, we use of forecasting functions in Microsoft Excel to predict the future profile of graduates from the faculty of a state university in Indonesia. The use of Microsoft Excel is decided due to the fact that most of academics are familiar with the application. In this forecasting, specifically, we focus on two main forecasting functions: FORECAST and FORECAST.LINEAR. These functions generate linear regression from the historical data to project the estimation on the future data of the alumni from the tracer study. Additionally, the availability of advanced exponential smoothing functions (such as FORECAST.ETS) is also discussed and compared. By implementing these formulas in Excel, regarding the result on tracer study in the future, educational institutions are able to be informed and develop a polycy decisions regarding curriculum adjustments to enhance the quality of education based on the tracer study result. © 2025 Author(s).
Matematics Education, Surabaya State University, Surabaya, Indonesia; Physics Education, Surabaya State University, Surabaya, Indonesia
