DOWNLOAD THE COMPLETE PROJECT

10 Users found this project useful

Impact of Spreadsheet Formula Training on Students’ Accounting Calculation Skills among Accounting Education Students in Nigerian Polytechnics

Abstract

Spreadsheet proficiency has become an important component of accounting education because modern accounting tasks increasingly require the use of digital tools for computation, data analysis, financial reporting, budgeting, record keeping, and decision-making. Accounting Education students are expected to apply spreadsheet formulas accurately when performing accounting calculations and managing financial information. However, inadequate practical exposure to spreadsheet formula functions may limit students’ ability to perform accounting calculations efficiently and accurately. Spreadsheet Formula Training provides students with structured opportunities to learn and practise the application of spreadsheet formulas to accounting-related tasks. Such training may strengthen students’ computational accuracy, speed, analytical ability, and practical digital accounting competence. Against this background, this study investigates the impact of Spreadsheet Formula Training on students’ accounting calculation skills among Accounting Education students in Nigerian polytechnics. The study will be anchored on Experiential Learning Theory, Social Cognitive Theory, and Human Capital Theory. Experiential Learning Theory explains how students develop practical skills through direct experience, reflection, conceptualization, and active experimentation. Social Cognitive Theory emphasizes learning through observation, modelling, guided practice, feedback, and self-efficacy. Human Capital Theory explains how investment in relevant knowledge and practical digital skills improves students’ productivity, employability, and preparedness for workplace responsibilities. Collectively, these theoretical perspectives provide a suitable framework for explaining how Spreadsheet Formula Training may influence students’ accounting calculation skills. The study will adopt a quantitative quasi-experimental research design. The population will comprise Accounting Education students enrolled in selected Nigerian polytechnics. A multistage sampling technique will be used to select states, polytechnics, departments, levels of study, classes, and eligible students. Data will be collected using structured questionnaires, spreadsheet formula competency assessment tests, practical accounting calculation tasks, spreadsheet-based exercises, performance rubrics, observation checklists, and pre-test and post-test assessments. Spreadsheet Formula Training will be assessed using indicators such as basic arithmetic formulas, addition formulas, subtraction formulas, multiplication formulas, division formulas, percentage calculations, average calculations, total calculations, difference calculations, ratio calculations, proportion calculations, discount calculations, markup calculations, margin calculations, tax calculations, depreciation calculations, interest calculations, commission calculations, payroll calculations, overtime calculations, inventory calculations, cost calculations, revenue calculations, profit calculations, loss calculations, budget calculations, variance calculations, financial-ratio calculations, cash-flow calculations, account-balance calculations, trial-balance calculations, ledger calculations, invoice calculations, receipt calculations, expense calculations, sales calculations, purchase calculations, bank-reconciliation calculations, statistical calculations, conditional formulas, logical formulas, lookup functions, rounding functions, date functions, error-handling functions, formula referencing, relative cell references, absolute cell references, mixed cell references, formula copying, formula editing, formula auditing, formula verification, error identification, error correction, worksheet organization, financial-data entry, spreadsheet formatting, financial-data presentation, and application of formulas to realistic accounting problems. Students’ accounting calculation skills will be assessed using indicators such as accuracy, speed, consistency, formula selection, correct formula application, numerical computation, interpretation of results, error detection, error correction, financial-data analysis, and application of spreadsheet calculations to accounting tasks. Descriptive statistics will be used to summarize students’ demographic and academic characteristics, spreadsheet experience, exposure to formula training, and accounting calculation skill levels. Inferential statistical techniques, including paired and independent t-tests, analysis of covariance (ANCOVA), correlation analysis, and multiple regression analysis where appropriate, will be used to determine the impact of Spreadsheet Formula Training on students’ accounting calculation skills. Where a quasi-experimental design is adopted, accounting calculation scores before and after the training may be compared with those of a control group receiving conventional classroom instruction 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 Spreadsheet Formula Training has a significant positive impact on students’ accounting calculation skills in Nigerian polytechnics. Students exposed to structured spreadsheet formula training are expected to demonstrate improved accuracy, speed, confidence, and efficiency when performing accounting calculations. Training in basic arithmetic formulas may strengthen students’ ability to perform routine accounting computations. Addition, subtraction, multiplication, and division exercises may improve students’ ability to calculate financial amounts accurately. Percentage calculations may strengthen students’ ability to determine tax, discounts, commissions, markups, margins, and other percentage-based accounting figures. Average and total calculations may improve students’ ability to summarize financial information. Ratio and proportion exercises may strengthen students’ ability to perform financial analysis. Discount and markup calculations may improve students’ ability to determine appropriate selling and purchasing figures. Tax-calculation exercises may strengthen students’ ability to apply relevant tax computations to accounting transactions. Depreciation exercises may improve students’ ability to calculate depreciation expenses and asset values. Interest and commission calculations may strengthen students’ ability to determine financial charges and earnings. Payroll calculation exercises may improve students’ ability to calculate wages, salaries, deductions, and overtime. Inventory and cost calculations may strengthen students’ ability to determine stock values and production-related costs. Revenue, profit, and loss calculations may improve students’ ability to determine financial performance. Budget and variance calculations may strengthen students’ ability to compare planned and actual financial outcomes. Financial-ratio exercises may improve students’ ability to calculate and interpret accounting ratios. Cash-flow and account-balance calculations may strengthen students’ ability to analyze cash movements and account positions. Trial-balance and ledger calculations may improve students’ ability to apply spreadsheet formulas to double-entry accounting records. Invoice, receipt, expense, sales, and purchase calculations may strengthen students’ ability to process routine business transactions. Bank-reconciliation calculations may improve students’ ability to identify and resolve differences between bank and accounting records. Conditional and logical formulas may strengthen students’ ability to automate accounting calculations based on specified conditions. Lookup functions may improve students’ ability to retrieve financial information efficiently from accounting datasets. Rounding functions may strengthen numerical presentation and reduce inappropriate decimal results. Date functions may improve students’ ability to perform calculations involving transaction periods and accounting dates. Error-handling functions may help students identify and manage calculation errors. Formula-referencing activities may improve students’ understanding of how spreadsheet cells interact within accounting calculations. Relative-reference exercises may strengthen students’ ability to copy formulas across financial datasets while allowing references to adjust appropriately. Absolute-reference exercises may improve students’ ability to maintain fixed values such as tax rates, interest rates, or predetermined accounting parameters. Mixed-reference activities may strengthen students’ ability to combine fixed and changing references in complex accounting calculations. Formula-copying exercises may improve efficiency when working with large accounting datasets. Formula-editing activities may strengthen students’ ability to modify calculations when accounting conditions change. Formula-auditing exercises may improve students’ ability to examine formulas and identify calculation problems. Formula-verification activities may strengthen students’ ability to confirm the accuracy of spreadsheet calculations before using the results for accounting decisions. Error-identification exercises may improve students’ ability to detect incorrect formulas, references, and numerical results. Error-correction activities may strengthen students’ ability to resolve spreadsheet calculation problems. Worksheet-organization activities may improve students’ ability to arrange accounting information systematically. Financial-data-entry activities may strengthen students’ accuracy in entering accounting information into spreadsheets. Spreadsheet-formatting activities may improve students’ ability to present financial calculations clearly and professionally. Financial-data-presentation exercises may strengthen students’ ability to communicate accounting calculations in an understandable format. Practical accounting scenarios may help students apply spreadsheet formulas to realistic business problems. Repeated practice may improve calculation speed, accuracy, confidence, and independence. Guided demonstrations may provide students with clear models for applying spreadsheet formulas. Individual exercises may strengthen independent calculation skills. Group exercises may encourage collaborative problem-solving. Lecturer feedback may help students identify and correct formula-related errors. Peer assessment may expose students to alternative approaches to spreadsheet calculations. Self-assessment may encourage students to evaluate their own spreadsheet competence. Progressive exercises may prepare students to handle increasingly complex accounting calculations. However, the effectiveness of Spreadsheet Formula Training may be constrained by inadequate computer laboratories, insufficient computers, unreliable electricity supply, poor internet connectivity, limited access to spreadsheet software, outdated computer facilities, large class sizes, inadequate practical training periods, insufficient lecturer training, limited accounting-specific spreadsheet exercises, inadequate supervision, poor access to digital learning resources, limited student participation, and inadequate integration of spreadsheet-based accounting activities into Accounting Education curricula. The study therefore expects structured, practical, accounting-focused, technology-supported, and adequately supervised Spreadsheet Formula Training to contribute significantly to improved accounting calculation skills among Accounting Education students in Nigerian polytechnics. The study is expected to contribute to the literature on Spreadsheet Formula Training, accounting calculation skills, Experiential Learning Theory, Social Cognitive Theory, Human Capital Theory, accounting education, practical accounting education, spreadsheet applications, digital accounting skills, accounting computation, financial-data analysis, spreadsheet-based accounting, formula application, financial calculations, percentage calculations, tax calculations, depreciation calculations, payroll calculations, inventory calculations, cost calculations, revenue calculations, profit calculations, budget calculations, variance calculations, financial-ratio calculations, bank-reconciliation calculations, formula referencing, spreadsheet auditing, error detection, error correction, digital financial records, workplace readiness, employability skills, technological competence, professional competence, Accounting Education students, Nigerian polytechnics, and Accounting Education in Nigeria. The findings will provide useful information to the National Board for Technical Education, polytechnic administrators, Accounting Education departments, accounting educators, curriculum developers, professional accounting bodies, employers, industry partners, and policymakers regarding strategies for strengthening students’ practical digital accounting competencies. The study will also provide evidence-based recommendations for integrating Spreadsheet Formula Training into Accounting Education programmes, establishing functional computer laboratories, providing adequate spreadsheet software and digital resources, incorporating accounting-specific spreadsheet exercises into practical instruction, strengthening students’ formula application and financial-calculation skills, improving spreadsheet auditing and error-correction competence, providing repeated practical exercises and structured feedback, expanding collaboration between polytechnics and accounting workplaces, and aligning Accounting Education programmes with contemporary digital accounting and financial-computation requirements in Nigeria.

Keywords: Spreadsheet Formula Training, accounting calculation skills, spreadsheet skills, digital accounting skills, financial calculations, accounting education, practical accounting education, spreadsheet applications, formula application, financial-data analysis, accounting computation, error detection, spreadsheet auditing, Accounting Education students, Nigerian polytechnics, Nigeria.