Submitted:
14 May 2024
Posted:
14 May 2024
You are already at the latest version
Abstract
This study explores innovative strategies to enhance hands-on learning experiences in a Database Management Systems (DBMS) course while addressing challenges related to software installation complexities and financial barriers. The investigation focuses on an online course format catering to students majoring in information systems, healthcare administration, business administration, and marketing. Traditional software installation hurdles, especially for complex systems like Microsoft Access and MySQL, can impede students' engagement and access. To overcome these challenges, the study proposes leveraging cloud-based solutions and clientless remote desktop gateways like Apache Guacamole. Results indicate that these approaches effectively eliminate software installation obstacles, ensuring seamless access to essential tools for all students. The study underscores the importance of innovative technological solutions in promoting inclusive and impactful learning environments in higher education.
Keywords:
education
; software
; equity
; experiential learning
Introduction
When crafting a curriculum for educating a diverse group of students, it’s crucial to customize the approach to accommodate varying levels of technical proficiency. Factors like financial constraints and limited familiarity with software installation also warrant attention. This investigation centered on a Database Management Systems (DBMS) course, engaging students majoring in information systems, healthcare administration, business administration, and marketing. The course was conducted online, posing distinct challenges compared to face-to-face setups where a standardized classroom environment, direct physical interaction, and technical assistance are more readily available.
The course’s design aimed to offer students a hands-on learning experience, recognized as pivotal in education. Hands-on learning fosters active exploration and application of knowledge, bolsters information retention, boosts motivation and engagement, and facilitates deeper understanding and skill development. During course preparation, it became evident that installing database software can prove significantly more complex than typical applications. Moreover, certain DBMS software entails additional licensing costs, a considerable financial consideration for students venturing into new software technologies. Is there a solution that can deliver a hands-on learning environment without the complexities or expenses linked to software installation?
Literature Review
The integration and utilization of digital tools and software within educational settings have persistently posed a formidable challenge. Students who lack technical expertise often grapple with the intricacies of software installation procedures, which encompass configuring settings, resolving compatibility dilemmas, and handling dependencies. These complexities have been documented as impediments that impede students' effective engagement with course materials and active participation in practical learning endeavors (U.S. Department of Education, 2023). Furthermore, the financial ramifications linked to software procurement serve as additional obstacles to accessibility. Many educational institutions and students confront financial constraints, rendering it arduous to afford costly software licenses and subscriptions. This financial strain disproportionately impacts students hailing from disadvantaged backgrounds, constricting their access to indispensable educational assets (Fox, 2012).
In response to these challenges, educators and scholars have advocated for diverse strategies and remedies. One viable tactic entails harnessing open-source software and cost-free alternatives that furnish analogous functionalities to proprietary tools sans the associated expenses (Michael Heron, 2013). Through the adoption of open-access solutions, educational entities can diminish financial barriers and champion fair access to vital learning materials. Moreover, the advent of virtualized environments and cloud-based platforms has emerged as a promising antidote to streamline software deployment and accessibility. Virtualization technologies empower students to remotely access software applications, obviating the necessity for individual installations and compatibility hitches (Vescio, 2008). Cloud computing services proffer scalable and economical solutions for hosting educational software, furnishing on-demand access to resources sans necessitating extensive hardware investments.
Additionally, collaborative endeavors among educational institutions, software developers, and licensing agencies can expedite the negotiation of discounted or subsidized licensing pacts, rendering proprietary software more accessible to students (Money Matters, 2008). These alliances cultivate a supportive milieu for technology-driven learning, guaranteeing that students possess the requisite tools for academic success. This study is poised to propel substantive progress in enhancing both technical prowess and financial accessibility and equity, chiefly within the realm of educational software. By concentrating on methodologies to surmount barriers in accessing database software tailored for educational utility, it endeavors to augment access to pivotal learning tools and knowledge management resources. This research endeavors to proffer cost-efficient alternatives that can be readily embraced by educational institutions irrespective of their financial capacities. Particularly, this study aspires to cultivate a more all-encompassing digital milieu wherein students and educators alike can leverage the potential of database software to enrich teaching and learning experiences.
Theoretical Framework
Designing a database management systems course for online students presents a fascinating challenge. The aim is to provide a seamless hands-on experience with database software without imposing obstacles or costs that might deter students from participation. One avenue explored was leveraging Microsoft Access, a user-friendly option embedded in Microsoft Office suites. However, the compatibility issue arises for Apple users, necessitating complex workarounds like setting up dual-boot systems via Boot Camp. Another option considered was MySQL, favored for its open-source nature and broad support. Yet, its installation complexities and ongoing administration hurdles pose significant challenges, potentially hindering student engagement.
To address these issues comprehensively, the course design focuses on cloud-based solutions. Utilizing cloud platforms like AWS, Azure, or Google Cloud, students can access virtual environments pre-configured with various database management systems. This approach eliminates compatibility concerns across operating systems and streamlines the setup process, ensuring all students have equal access to the required software. Moreover, cloud-based environments offer scalability, enabling students to work on real-world projects without hardware limitations.
The course structure includes modules on fundamental database concepts, hands-on exercises using cloud-based databases, and collaborative projects to simulate real-world scenarios. By emphasizing practical skills over software installation intricacies, students can concentrate on learning database design, querying, optimization, and administration. Additionally, incorporating virtual labs and interactive tutorials enhances the learning experience, providing immediate feedback and guidance. Furthermore, partnerships with cloud service providers can offer discounted or free access to these environments for educational purposes, alleviating financial burdens on students. Dedicated support channels and forums foster a community where students can seek help and share insights, promoting a collaborative learning environment. By embracing cloud technology and a project-based learning approach, the database management systems course aims to empower online students with practical skills while minimizing barriers to entry, ensuring a fulfilling and inclusive learning journey for all participants.
Possible Solutions to Installing and Gaining Access to Software
To facilitate students' exploration and utilization of software resources, educational institutions can deploy innovative strategies.
- Implement custom virtual machines or containers with pre-installed software suites, ensuring uniformity across student setups and eliminating individual installation hassles.
- Engage closely with institutional IT services to streamline software deployment. Leverage their expertise in defining system requisites, software licensing, and deployment methodologies aligned with your institution's tech infrastructure.
- Embrace cloud-based and SaaS solutions for critical tools, bypassing local installations. This approach enables students to access software via web browsers, mitigating compatibility issues and enhancing accessibility.
- Provide alternative software choices for complex installations or device compatibility challenges, ensuring students have viable substitutes for seamless workflow continuation.
- Cultivate a culture of mutual support among students through online forums or discussion groups. Encourage sharing of tips, troubleshooting insights, and solutions to common installation hurdles.
- Institute a feedback loop for students to share their software installation experiences, leveraging platforms like learning management systems (e.g., Blackboard). Utilize this data to refine future deployment processes, addressing recurring issues proactively.
By embracing these dynamic strategies, educators can empower students with efficient software setup, promoting a harmonious learning journey focused on academic excellence over technical impediments.
In the database management course, an extensive curriculum was developed comprising six unique assignments designed to incrementally test and enhance students’ database management skills. Each assignment was meticulously structured to offer students practical exposure to crucial facets of database design, implementation, and SQL querying, nurturing a profound comprehension of relational database principles and SQL proficiency. Through immersive engagement with practical scenarios and hands-on tasks, students honed vital competencies in database design, query formulation, and data manipulation, laying a robust groundwork for their pursuits in data-centric domains.
Solutions Used in the Database Management Systems Course
Throughout the database management systems course, various innovative methods were employed to streamline software installation and access.
Initially, the instructor adopted a proactive approach by regularly monitoring the Discussion Board on the Blackboard platform. This platform served as a collaborative space where students freely exchanged tips, troubleshooting insights, and solutions to common software problems. The invaluable feedback gathered from these discussions enabled the pinpointing of recurring issues and facilitated ongoing improvements to the software experience for future cohorts.
Undoubtedly, the most impactful strategy involved granting students access to essential software through a clientless remote desktop gateway. Specifically, at NSU, students utilized the open-source software Apache Guacamole (https://guacamole.apache.org/). Apache Guacamole revolutionizes software accessibility by offering a web-based remote desktop gateway. This open-source solution is accessible to all, including educational institutions, providing a seamless way for students to connect to remote computers or virtual machines using just a standard web browser—no additional software or plugins required. This flexibility empowers students to access a full desktop environment and applications from anywhere with internet access, irrespective of their device or operating system. Guacamole's user-friendly interface facilitates easy connection management, seamless transitions between remote sessions, and personalized desktop configurations. At NSU, accessing the remote desktop is as straightforward as:
- Go to the following URL using any browser. https://desktop.nsuok.edu
- Enter their username and password.
- The students can now access any software installed on the remote machine. In particular, for students in my database management systems course, the students would now select the software application MS Access as shown in Figure 1.
The unique charm of Apache Guacamole lies in its clientless nature, earning it the moniker "clientless software." It operates without the need for plugins or additional client software, thanks to the power of HTML5. Once Guacamole is set up on a server, accessing a desktop computer becomes as easy as opening a web browser. This functionality empowers students to log into computers equipped with necessary software and engage in hands-on exercises without the hassle of installing or purchasing additional software packages.
Results
All students (46 out of 46), irrespective of their technical acumen or financial status, smoothly engaged with and fulfilled the database assignments without the hassle of installing or purchasing any software. This accomplishment was facilitated by leveraging a virtualized environment. Through this setup, students accessed the necessary database software remotely, directly from their web browsers. This approach eliminated the logistical hurdles associated with traditional software installation, such as compatibility issues, configuration intricacies, and system requirements. Consequently, students could channel their efforts entirely into learning and applying database management concepts without being impeded by technical obstacles.
Moreover, the utilization of open-source software in this educational setting played a pivotal role in ensuring fair access to essential learning resources. These initiatives not only alleviated the financial strain on students but also fostered a culture of collaboration and knowledge sharing within the academic realm. Students gained access to top-tier software without the hefty costs typically linked to proprietary solutions. The seamless completion of database assignments sans software installation or purchase requirements underscored the efficacy of this approach in nurturing student success and engagement. By dismantling barriers to access and embracing forward-looking technological strategies in learning, an inclusive educational environment was established where every student had the chance to excel and thrive.
Conclusion
In reflecting on the journey of teaching a course on database management systems, it's clear that the experience has been both enlightening and challenging. The emphasis on providing students with a practical, hands-on learning experience was crucial, especially considering the complexities and financial barriers often associated with installing database software. The implementation of a clientless remote desktop gateway, specifically through Apache Guacamole at NSU, emerged as a remarkably efficient and practical solution to tackle these challenges related to software accessibility in teaching database management systems. By harnessing this technology, students gained seamless access to necessary software without the usual complexities or costs tied to traditional installation methods. This not only facilitated hands-on learning but also promoted inclusivity by eliminating financial barriers that might have otherwise limited students' access to essential resources. This approach showcases the power of innovative solutions in surmounting logistical hurdles and enhancing the overall educational experience.
As we navigate the dynamic landscape of education, it remains crucial to remain open to adopting new technologies and methodologies that enhance accessibility and effectiveness. Embracing tools like Apache Guacamole ensured that every student could fully engage in their learning journey, empowering them to succeed and thrive in both academic and professional pursuits. This experience underscores the importance of leveraging innovative solutions to create inclusive learning environments that support student success.
References
- Zaza, C.; Neiterman, E. Does Size Matter? Instructors’ and Students’ Perceptions of Students’ Use of Technology in the Classroom. Journal of Information Technology Education: Research 2019, 18. [Google Scholar] [CrossRef] [PubMed]
- Dawson, K. Using action research projects to examine teacher technology integration practices. Journal of Digital Learning in Teacher Education 2012, 28, 117–124. [Google Scholar] [CrossRef]
- Fox, C.; Waters, J.; Fletcher, G.; Levin, D. The broadband imperative: Recommendations to address K-12 education infrastructure needs; State Educational Technology Directors Association: Washington, DC, USA, 2012. [Google Scholar]
- Freeland, J.; Hernandez, A. Schools and software: What’s now and what’s next? Clayton Christensen Institute: San Mateo, CA, 2014. [Google Scholar]
- Hsu, P.; Sharma, P. A case study of enabling factors in the technology integration change process. Educational Technology & Society 2008, 11, 213–228. [Google Scholar]
- Igere, M.A.; Adomi, E.E.; Nwosu, C.O. The predictive nature of work motivation and career commitment of librarians in Universities in Southern Nigeria. Library Philosophy and Practice (e-journal) 2020, 1–24. [Google Scholar]
- Tarun, I.M. The Effectiveness of a Customized Online Collaboration Tool for Teaching and Learning. Journal of Information Technology Education: Research 2019, 18. [Google Scholar] [CrossRef] [PubMed]
- McAvoy, J.; Butler, T. A Failure to Learn By Software Developers: Inhibiting the Adoption of an Agile Software Development Methodology. Journal of Information Technology Case and Application Research 2009, 11. [Google Scholar] [CrossRef]
- Kumar, K. Role of Database Management Systems in Selected Engineering Institutions of Andhra Pradesh: An Analytical Survey. International Journal of Knowledge Content Development & Technology 2016, 6, 41–68. [Google Scholar]
- Kumar, R. Impact of database management in modern world. Engineering reports 2020, 3, 1–4. [Google Scholar]
- Lu, R.; Overbaugh, R. School environment and technology implementation in K-12 classrooms. Computers in the Schools 2009, 26, 89–106. [Google Scholar] [CrossRef]
- Maitato, E. A Study on the Frequency and Purpose of Use of E-Resources Regarding Level of Awareness of Students in Sardar Vallabhbhai Patel University of Agriculture and Technology. International Journal of Library Science 2020, 9, 71–75. [Google Scholar]
- McGinty, J. Digital Libraries Need Digital Organization: Identifying, Defining, and Creating New Academic Library Management Structures. In ACRL Fourteenth National Conference. 12th-15th March (pp. 298-303). www.ala.org 2009.
- Heron, M.; Hanson, V.L.; Ricketts, I. Open source and accessibility: advantages and limitations. Journal of Interaction Science 2013. [Google Scholar] [CrossRef]
- Money matters: Budgets, finances, and resources for tech programs. Technology and Learning 2008, 28, 2.
- Muyiwa, O. Access and Utilization of Information Resources and Services by Legislative Aides in the National Assembly Library Abuja. Unpublished. Masters Thesis, Ahmadu Bello University, Zaria, Nigeria, 2015. [Google Scholar]
- National Education Association. Preparing 21st century students for a global society: An educator’s guide to the “four Cs.”; National Education Association: Washington, DC, 2012. [Google Scholar]
- Nwachukwu, V.N.; Abdulsalami, T.L.; Salami, P.F. (2014). Availability, accessibility and use of information resources and services among information seekers of Lafia Public Library in Nasarawa State. In Information and Knowledge Management (Vol. 4, No. 10, pp. 1–11).
- Nwafor, M.C.; Okeke, I.E.; Urhiewhu, L.O. Extent of Digital Information Resources Usage by Undergraduates Of Selected Higher Institutions In Delta And Edo States, Nigeria. Research of Humanities and Social Sciences 2018, 5. [Google Scholar]
- Nwankwo, N.G.; Chukwu, I.L.; Igbokwe, O.P.; Agbanu, N.A. Awareness and Use of Library Information Resources: A Conceptual Approach. International Journal of Social Sciences and Humanities Reviews 2019, 9, 188–197. [Google Scholar]
- Office of Educational Technology, “A Call to Action for Closing the Digital Access, De- sign, and Use Divides”, 2024 National Educational Technology Plan.
- Onwuchekwa, E.O. (2011). Organisation of Information and the Information Retrieval System. www.researchgate.net.
- Onwukanjo, S.A.; Joseph. Information resources availability and accessibility on user satisfaction: case study of Federal University of Technology, Minna Library. Journal of Applied Information Science and Technology www.jaistonline.org. 2017, 10. [Google Scholar]
- Ovigue EL& Abdulsalami, L.T. The Constraints to Effective Use of Federal University Library Lafia by Students. International Journal of Information Science 2019, 9, 16–25. [Google Scholar] [CrossRef]
- Sejane, L. Access to and use of electronic information resources in the academic libraries of the Lesotho Library Consortium. Doctoral dissertation, 2017. [Google Scholar]
- Singh, P. Library Databases: Development and Management. Annals of Library and Information Studies 2004, 51, 72–81. [Google Scholar]
- Steiner, L. Designing effective professional development experiences: What do we know? Learning Point Associates: Naperville, IL, USA, 2004. [Google Scholar]
- Thomas, L.; Knezek, D. Information, communication, and educational technology standards for students, teachers, and school leaders. In International handbook of information technology in primary and secondary education; Voogt, J., Knezek, G., Eds.; Springer: New York, NY, USA, 2008; Volume 20. [Google Scholar]
- Unegbu, V.E.; Lawal-Solarin, E.; Ladan, M.U. Library Resources Availability and Accessibility as Determinants of Undergraduates Library Use in Lagos State University, Nigeria. Gateway Library Journal 2017. [Google Scholar]
- Usoro, I.M.P.; Umoren, M.E.; Akwan, N.A. Students’ Characteristics and Information Resources Utilization in the University of Uyo Library. International Journal of Library and Information Science Studies 2018, 4, 40–51. [Google Scholar]
- Vescio, V.; Ross, D.; Adams, A. A review of research on the impact of professional learning communities on teacher practice and student learning. Teaching and Teacher Education 2008, 24, 80–91. [Google Scholar] [CrossRef]
- Xie, X.; Siau, K.; Nah, F.F.-H. COVID-19 pandemic – online education in the new normal and the next normal. Journal of Information Technology Case and Application Research 2020, 22. [Google Scholar] [CrossRef]
- Yebowaah, F.A.; Plockey, F.D.D. Awareness and use of electronic resources in university libraries: A case study of University for Development Studies Library. Library Philosophy and Practice. Retrieved from digitalcommons.unl.edu. 2017.
Figure 1.
depicts a seamless connection between a web browser and a remote computer facilitated by Apache Guacamole. This software revolutionizes access to applications by simplifying the complexities inherent in traditional remote desktop solutions, offering a user-friendly experience accessible from any web-enabled device.
Figure 1.
depicts a seamless connection between a web browser and a remote computer facilitated by Apache Guacamole. This software revolutionizes access to applications by simplifying the complexities inherent in traditional remote desktop solutions, offering a user-friendly experience accessible from any web-enabled device.
Disclaimer/Publisher’s Note: The statements, opinions and data contained in all publications are solely those of the individual author(s) and contributor(s) and not of MDPI and/or the editor(s). MDPI and/or the editor(s) disclaim responsibility for any injury to people or property resulting from any ideas, methods, instructions or products referred to in the content. |
© 2024 by the authors. Licensee MDPI, Basel, Switzerland. This article is an open access article distributed under the terms and conditions of the Creative Commons Attribution (CC BY) license (http://creativecommons.org/licenses/by/4.0/).
Copyright: This open access article is published under a Creative Commons CC BY 4.0 license, which permit the free download, distribution, and reuse, provided that the author and preprint are cited in any reuse.
