DOWNLOAD THE COMPLETE PROJECT

3 Users found this project useful

Effect of Accounting Spreadsheet Training on Students’ Data Organization Skills among Accounting Education Students in Nigeria

Abstract

Accounting spreadsheet training is an important component of contemporary accounting education because spreadsheets are widely used for organizing, processing, analysing, and presenting financial information. Accounting education students need practical competence in entering financial data, structuring accounting information, applying formulas, sorting and filtering records, creating tables, validating data, and presenting information in a clear and systematic format. However, students may possess basic computer knowledge without having sufficient spreadsheet skills to organize accounting data accurately and efficiently. Accounting Spreadsheet Training provides students with practical opportunities to work with financial datasets, organize accounting records, apply spreadsheet functions, create structured worksheets, identify and correct data-entry errors, and manage financial information using digital tools. Against this background, this study investigates the effect of accounting spreadsheet training on students' data organization skills among accounting education students in Nigeria. The study will be anchored on Experiential Learning Theory, Constructivist Learning Theory, and Technology Acceptance Model. Experiential Learning Theory emphasizes learning through concrete experience, reflective observation, conceptualization, and active experimentation, providing a suitable framework for students' participation in hands-on spreadsheet activities. Constructivist Learning Theory emphasizes active participation, problem-solving, prior knowledge, and the construction of knowledge through meaningful learning experiences. The Technology Acceptance Model explains how perceived usefulness and perceived ease of use may influence students' acceptance and utilization of spreadsheet technology for accounting tasks. Collectively, these theoretical perspectives provide a suitable framework for explaining how accounting spreadsheet training may influence students' data organization skills. The study will adopt a quantitative quasi-experimental or analytical cross-sectional research design. The study population will comprise accounting education students enrolled in selected public and private universities across Nigeria. A multistage sampling technique will be used to select geopolitical zones, states, universities, faculties or departments, levels of study, classes, and eligible accounting education students. Accounting spreadsheet training will be assessed using indicators such as spreadsheet fundamentals, worksheet creation, accounting data entry, cell formatting, data classification, table creation, data sorting, filtering, data validation, formula application, relative and absolute cell referencing, spreadsheet functions, worksheet organization, naming and structuring of worksheets, data cleaning, duplicate identification, error checking, conditional formatting, pivot tables where appropriate, financial data templates, transaction schedules, ledger and trial balance worksheets, budgeting worksheets, financial statement worksheets, practical accounting datasets, spreadsheet-based accounting exercises, guided demonstrations, individual practice, group activities, feedback, repeated hands-on training, and use of spreadsheet applications relevant to accounting practice. Students' data organization skills will be assessed using indicators such as accurate data entry, logical arrangement of accounting data, classification of financial information, appropriate use of tables and worksheets, consistent formatting, sorting and filtering of records, identification and removal of duplicate information, data validation, accurate use of formulas, appropriate cell referencing, organization of financial records, creation of structured accounting schedules, maintenance of data integrity, error detection and correction, retrieval of specific financial information, preparation of organized accounting reports, management of large financial datasets, efficient navigation of worksheets, and ability to organize unfamiliar accounting datasets systematically. Data will be collected using structured questionnaires, standardized spreadsheet skills tests, practical spreadsheet tasks, accounting data organization exercises, computerized accounting scenarios, competency-based assessment rubrics, observation checklists, students' practical spreadsheet files, and pre-test and post-test assessments where a quasi-experimental design is adopted. Descriptive statistics will be used to summarize students' demographic and academic characteristics, exposure to spreadsheet training, technology-use experiences, and levels of data organization skills. Inferential statistical techniques, including chi-square tests, paired and independent t-tests, correlation analysis, and multiple regression analysis where appropriate, will be used to determine the effect of accounting spreadsheet training on students' data organization skills. Where a quasi-experimental design is adopted, data organization skill scores before and after exposure to accounting spreadsheet training may be compared with those of a comparison group receiving conventional accounting instruction without structured spreadsheet training to determine changes associated with the intervention. Diagnostic tests will also be conducted to assess the reliability, validity, and robustness of the findings. The study is expected to find that accounting spreadsheet training has a significant positive effect on students' data organization skills among accounting education students in Nigeria. Students exposed to structured and practical spreadsheet training are expected to demonstrate stronger abilities to enter, classify, arrange, validate, retrieve, and manage accounting data than students with limited spreadsheet exposure. Practical exercises involving sales records, purchase records, cash transactions, payroll data, inventory records, receivables, payables, budgets, and financial statement schedules may help students understand how large volumes of accounting information can be organized systematically using spreadsheet applications. Training in sorting, filtering, data validation, and structured worksheet design may improve students' ability to maintain accurate and accessible accounting records. Formula-based activities may also help students reduce repetitive manual calculations and improve the consistency of organized financial datasets. Data-cleaning exercises may strengthen students' ability to identify duplicates, incomplete entries, inconsistent formats, and other data-quality problems. Advanced spreadsheet activities such as pivot tables and structured financial-data summaries may further improve students' ability to organize and retrieve information efficiently. However, inadequate access to computers, unreliable electricity supply, limited spreadsheet facilities, insufficient instructional time, large class sizes, varying levels of prior computer knowledge, inadequate lecturer training, and limited access to current spreadsheet applications may reduce the effectiveness of spreadsheet training. The study therefore expects practical, continuous, technology-supported, and well-supervised accounting spreadsheet training to contribute significantly to improved data organization skills among accounting education students in Nigeria. The study is expected to contribute to the literature on accounting spreadsheet training, data organization skills, accounting education, accounting technology, digital accounting skills, spreadsheet applications, experiential learning, constructivist learning, technology acceptance, computerized accounting education, practical accounting skills, accounting pedagogy, and higher education in Nigeria. The findings will provide useful information to the National Universities Commission, universities, accounting education departments, accounting educators, professional accounting bodies, curriculum developers, information and communication technology units, and policymakers regarding strategies for strengthening digital accounting education. The study will also provide evidence-based recommendations for integrating structured spreadsheet training into accounting education programmes, developing accounting-specific spreadsheet exercises and datasets, improving access to computer laboratories and spreadsheet applications, training accounting educators in contemporary spreadsheet technologies, incorporating data organization competency assessments, providing repeated hands-on spreadsheet practice, strengthening students' data-quality and validation skills, and aligning accounting education with the digital data-management competencies required in contemporary accounting workplaces in Nigeria.

Keywords: Accounting spreadsheet training, data organization skills, accounting education students, spreadsheet applications, accounting technology, digital accounting skills, computerized accounting, data management, experiential learning, constructivist learning, technology acceptance, accounting pedagogy, Nigerian universities, Nigeria.