SDO Abra Learning Resource Management Portal

 SDO Abra Learning Resource Management Portal

Gryan Lyle C. Navarro

The SDO Abra Learning Resources Management Portal objectives are to promote online collaboration for a faster and more efficient evaluation process, reduce printing costs, minimize travel time for teacher-developers and evaluators, improve accuracy and language checks using Microsoft AI tools, enhance communication and dissemination of guidelines, highlight the most functional SLRC in Abra to inspire other schools, and provide a one-stop site for LR coordinators, teachers, and evaluators.

 The SDO Abra Learning Resource Management Portal is a dynamic and comprehensive platform designed to support the curriculum for public schools in Abra. It serves as a centralized repository for a wide range of learning materials, aligning with the Department of Education's advocacy for the adoption and implementation of the Learning Resources Management and Development System (LRMDS) and in line with DepEd Digital Rise and Computerization Program. The site caters for the teachers and LR teams’ needs and guidelines in developing contextualized learning materials and is structured to facilitate easy access to quality educational resources, ensuring that teachers and students can find relevant materials efficiently. It includes an integrated system for assessment, development, storage, and delivery of resources, tailored to meet the specific needs of the local educational community. With its user-friendly interface, the LRMS site stands as a testament to the commitment to enhancing the quality of education through technology and innovation.  

 The SDO Abra Learning Resource Management Portal promotes online collaboration between the users using online tracking tool embedded into the system, and using the online evaluation in the system, the evaluator will then be redirected to open the documents in Microsoft 365 application that improves the accuracy, grammar, and vocabulary check in evaluation. Thus, the system lessens the time travel of the users and reduces the printing cost of learning materials to be evaluated. There is also a feature on the system for real time commenting, adding forum threads, and announcements that enhance communication and information dissemination. It was also integrated into separate page sections where they can download or copy templates, guidelines, and quality forms.  The SDO Abra Learning Resource Management Portal serves as a one stop site for the users.

 The innovation has a significant impact on the Schools Division of Abra by streamlining the evaluation process, reducing costs, and enhancing the quality of education. It will facilitate efficient online collaboration, minimize travel time, and cut down on printing expenses. The use of Microsoft AI tools will improve the accuracy and quality of evaluations, while the integrated communication features will ensure effective dissemination of information. By providing a centralized, user-friendly platform, the portal will support teachers and LR teams in developing high-quality, contextualized learning materials, ultimately inspiring and benefiting the entire educational community in Abra. The system is sustainable with the use of the internet through content updates and maintenance.

Automated Liquidation Forms and Reports

Automated Liquidation Forms and Reports

NORVHEE JOY B. GALLARDO

Information technology has progressively upgraded all aspects of human endeavor, including the workplace. ICT becomes indispensable and the main resource identified by every organization as an instrument to accomplish every task to attain productivity. Innovative computer software likewise adds convenience to completing time-wasting tasks. Software commonly used in any workplace is Microsoft Excel.

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). Excel forms part of the Microsoft Office suite of software. (Wikipedia)

The Automated Liquidation Forms and Reports were offline systems that work with the different features accessible in Microsoft Excel. The offline system work with Microsoft Excel’s computation capabilities and its macro programming language, Visual Basic for Applications. The computation capabilities of Microsoft Excel play a significant role in any transactions concerning simple or complex calculation of large numbers, such as financial and accounting transactions. The offline systems work with the following Microsoft Excel Functions: Financial; Date & Time; Math & Trig; Lookup & References; Logical; Information; and Data Validation. These functions offer the users the effortlessness of calculating and preparing various forms in just one go. In Microsoft Excel, Visual Basic for Applications (VBA) allows manipulation that is difficult with the standard spreadsheet techniques. Both offline systems similarly operate with simple macro programming for commands that automatically hide and unhide rows and columns, and the conversion of amounts in figures to words.

Each offline system contains a HOME page, a sheet comprising fund sources and Unified Accounts Code Structure (UACS), and multiple sheets relating to the different liquidation forms essential in the preparation of Liquidation Reports (LR), as provided in the General Accounting Manual (GAM) Volume II – Accounting Books, Registries, Records, Forms, and Reports issued by the Commission on Audit (COA). These forms comprise of the following: Disbursement Voucher (Appendix 32); Journal Entry Voucher (Appendix 36); Cash Disbursement Register (Appendix 43); Liquidation Report (Appendix 44); Status of Fund; Itinerary of Travel (Appendix 45); Reimbursement Expense Receipt (Appendix 46); Certificate of Travel Completed (Appendix 47); Inventory Custodian Slip (Appendix 59); Purchase Request (Appendix 60); Purchase Order (Appendix 61) or Job Order; Inspection and Acceptance Report (Appendix 62); Requisition and Issuance Slip (Appendix 63); Property Acknowledgement Receipt (Appendix 71);  Certification of Expenses Not Requiring Receipt (Annex A); Contract of Service; Pre-Repair Inspection; Post-Repair Inspection; Program of Work; and Canvass Form.

With a basic familiarity with Microsoft Excel, users can effortlessly become accustomed to the functionality of these offline systems. Each cell on the HOME page and on some of the liquidation forms of each system has instructions provided and by following these instructions correctly, the offline systems will get the rest of the work done. From simple to complex computations to the identification of suppliers and/or payees with the lowest bids, the systems will get it done for users. Every form was configured, from the paper size, margins, etc., all users need to do is just hit the print button and you’re Liquidation Reports will be complete.