ICT, Database, Linux & eLearning

Framework to Create an Information System Strategic Plan (ISSP) This web blog framework is intended for those who will be facilitating the creation of an ISSP plan for their Ministry. The following was used for local government in the Philippines and it has been edited for use in the Public Sector of Suriname. Background The Local Government Unit (LGU)  ISSP template has been supplied as a model that you can follow (reference 1 below). It is not a strategic planning document. If you filled in the 'blanks' then you could replicate the plan but it will not be a 'sustainable' plan for your organization to implement. For those of you that are interested, NCC (National Computer Center of the Philippines) developed that template for National government departments to apply for IT equipment (refernce 2). It was not designed for LGUs. A new template for LGUs was promised over 3 years ago and it has not materialized yet. Consequently I recommend some changes to make it a ...

Preface The baseline mapping study concluded that the use of information systems as part of your knowledge society will be the major driver of your wealth and economy (see reference 3,4). This is described as recommendation four of the ICT baseline mapping study undertaken in 2024 (see reference 1). The following blog will describe the actions you will need to take in order to develop a sustainable strategic plan (ISSP) for implementation to achieve it. I have walked into many government offices in different countries where I can see the remnants of a LAN (local area network) and switches/routers that no longer work, with legacy workstations and computers only capable of using older Windows operating systems like XP.  In most cases these are the results of well intentioned one time government and/or international funding projects without the consideration of sustainability.  Even recently I have walked into government offices in the Caribbean with new workstations and high res...

  Preface This blog will outline the key steps to setup XAMPP server, connect MySQL to Workbench, create tables, enter data, connect MySQL to Looker Studio, and host Looker Studio reports in XAMPP server webpage. YouTube tutorial for above

 Preface This blog is intended to provide an option for full stack development using the LAMP, XAMP or WAMP stack with MariaDB as the backend for RDBMS MIS application development. RDBMS Logical Design The following QuickDBD website offers a good online application that will help you draw database diagrams quickly. It also offers an online tool for you to create a logic model of your database system and it also can automatically generate an SQL statement to create that database in your SQL database. QuickDBD FAQ   Install XAMPP Download and install Apache XAMPP for your operating system from their website following their installation instructions. You may encounter installation problems if you are using Windows 11. This will mainly be related to port conflicts. Windows 11 may be using port 80 for IIS. If this is the case and an error warning is issued from the XAMPP control panel then you could change the port to 8012 or some other unused port. If you are unfamiliar you can ch...

 Termux is a free and open-source emulator for Android which allows for running a Linux environment on an Android device. The link below is a YouTube tutorial on using Termux to support a MariaDB server with phpMyAdmin. Termux phpMyAdmin I am using Termux on my mobile and tablet to install and test MariaDB, Python, SQL, etc. in addition to my PC. So far I have been able to install Termux from Google Play Store, install MariaDB and phpMyAdmin and am able to use it with a browser to work on the database via the localhost. The following tutorial outline the steps I used.  I was unable to install Termux on Bluestacks (Android simulator) in Win 11 on my laptop. Step 1 - Install Termux on your mobile device from Google Play Store and > Open the application. At the  - $ prompt enter: apt update && apt upgrade -y Next enter - $ apt install php mariadb phpmyadmin -y Your current working directory is the termux home directory. Go to the root directory/file system dir wit...

MIS (Management Information System) and ERP (Enterprise Resource Planning) systems are both types of information systems that play important roles in managing and organizing business operations. While there is a relationship between MIS and ERP systems , they are not the same thing and serve different purposes within an organization. What is MIS? MIS refers to a broader concept that encompasses the use of technology, people, and processes to gather, store, analyze, and disseminate information for effective decision-making and management of an organization. MIS focuses on providing managers with the necessary information and reports to support their decision-making processes at various levels of the organization. What is ERP? On the other hand, ERP systems are a specific type of enterprise software that integrates various business functions and processes into a unified system. ERP systems typically include modules for different areas such as finance, human resources, supply chain man...

Step 1:  Install MariaDB and PHPMyAdmin in Synology NAS Drive Connect to your Synology NAS Dashboard. Select >  Package Center > MariaDB 10 > Install. Once the database is installed the next time you open Package Center it will show an Open button. Select > Open and note the Enabled TCP/IP connection Port. The default is 3306 but a different port number may be allocated such as 3308. Similarly install phpMyAdmin. If it is installed the button will show Open. To run phpMyAdmin you will need to launch it from your browser to Synology NAS Drive IP Address. The NAS IP Address is shown on the lower right hand corner of the Dashboard under System Health. e.g. LAN1   192.168.1.232 Step 2:  Access phpMyAdmin from your browser To access your phpMyAdmin you need to enter the IP Address of your NAS drive as shown in the Dashboard. You can now Import a csv table from your spreadsheet like the table shown below. You can edit and change records and fields with php...