PROPOSAL FOR A DIGITAL TOOL FOR PROCESSING ELECTORAL DATA BY POLLING STATIONS AT THE DISTRICT LEVEL IN MOZAMBIQUE USING MICROSOFT OFFICE EXCEL
DOI:
https://doi.org/10.56238/levv16n54-126Keywords:
Digital Tool, Data Processing, Electoral Management, ExcelAbstract
This article proposes the development of a digital tool designed in Microsoft Office Excel to support electoral bodies in the processing of election results at the district level. The motivation behind this proposal lies in the observation that Mozambican districts still rely on manual methods for counting and consolidating electoral data, which are prone to human errors, delays, and inconsistencies. The proposed tool is expected to streamline the registration, calculation, and analysis of results from polling station tables, thus enhancing the speed, accuracy, and transparency of the district-level tabulation process. The tool will utilize simple formulas and cross-sheet references to automate the calculation of valid votes, null votes, abstentions, and candidate percentages. It will also provide automatic generation of summary reports and graphical visualizations to facilitate the interpretation and dissemination of results. Excel was chosen due to its wide availability in public administration, cost-effectiveness, and the general familiarity of election officials with the platform, reducing the need for intensive training. This paper outlines the proposed structure of the tool, defines the roles of its intended users, and explains how the tool would be deployed during the electoral period. If validated and implemented, this digital solution could significantly improve electoral data management at the district level, contributing to more reliable, auditable, and publicly trusted election processes.
Downloads
References
Alvarez, R. M., Hall, T. E., & Hyde, S. D. (2008). Election Fraud: Detecting and Deterring Electoral Manipulation. Brookings Institution Press. DOI: https://doi.org/10.5771/9780815701606
Costa, M; Pereira, a. (2021). Gestão de Dados em Processos Eleitorais Digitais. Editora Técnica.
Petersen, S. D. and Jaecks, H. K. (2005). Combination electronic and paper ballot voting system. https:// bit.ly/2K0amhZ (Acessado em: 01 de Maio de 2025).
TSE (2014a). Conheça a história da urna eletrônica brasileira, que completa 18 anos. https://goo.gl/MmmpFN (Acessado em: 01 de Maio de 2025).
Ferrão et al./ Revista Brasileira de Computação Aplicada (2019), v.11, n.2, pp.1–12 DOI: https://doi.org/10.5335/rbca.v11i2.9056
Lei nº 14/2018, de 18 de Dezembro, que altera a Lei nº 7/2018, de 3 de Agosto que estabelece o Quadro Jurídico para a eleição dos Titulares dos órgãos das autarquias locais.
Lei nº 15/2024, de 23 de Agosto, atinente a revisão da Lei nº 8/2013, de 27 de Fevereiro, alterada e republicada pela Lei nº 2/2019, de 31 de Maio, que estabelece o Quadro Jurídico para a eleição do Presidente da República e dos Deputados da Assembleia da República.
Marcone, M. d., & Lakatos, E. M. (2017). fundamentos de metodologia científica (5 ed.). Sao Paulo: Atlas S.A.
Norris, P. (2014). Why Electoral Integrity Matters. Cambridge University Press. DOI: https://doi.org/10.1017/CBO9781107280861
OLIVEIRA, R.; SANTOS, F. (2019). A Digitalização dos Processos Eleitorais: Impactos e Benefícios. Revista de Administração Pública.
Comissão Nacional de Eleições de Moçambique. (2023). Manual de Processamento de Dados Eleitorais. Maputo, Moçambique.
Reynolds, A. (2005). conceção de Sistemas Eleitorais (p. 4). Suecia: Bulls Tryckeri.Norris (2015)
SMITH, J. (2020). Digital Democracy: Transforming Electoral Processes. Cambridge University Press.
