ICT, Database, Linux & eLearning

 A Web Application to Read & Write Excel Files 1. Template Based Approach DZone - Database Zone Architecture is in 3 parts: Model, View, Controller. Model: the data from the database View: the template file Controller: listen for events from the View and populate data from the database Keikai Spreadsheet (View) - DatabaseComposer (Controller) - MyDataService (Model) Keikai GitHub

Raspberry Pi Desktop on an Intel Atom N270 Acer One Laptop  I was recently given an Acer Aspire One laptop with Windows XP with 1 GB RAM and 160 GB hard drive with a 1024 by 600 pixel display. I thought it would be interesting to try and refurbish it with a RaspberryPi desktop for PC, which I downloaded from: Raspberry Pi Desktop for PC and Macdesktop/ The downloaded filename is 2021-01-11-raspios-buster-i386.iso which is a 32 bit OS that could be installed on the Aspire One. The Aspire One had a limited legacy BIOS that allowed booting from the USB ports but did not allow me to create a backup image using Clonezilla or Macrium Reflect. Perhaps it was the operator's fault. I gave up after spending a day trying. I used Rufus to enable the raspios iso to boot off my USB.  Installing Raspberry Pi Desktop You can run the Debian with Raspberry Pi Desktop from the live USB drive or use it to install as your computer's main operating system. You can follow the instructions from the f...

Transitioning from Windows XP to Bodhi Linux This tutorial is intended to help users who are transitioning from a Windows XP or Windows 7 operating system to Linux. We are focusing on users who are mainly using their Windows XP with Microsoft Office for word processing and spreadsheets for general office productivity and the web browser for internet searches. First we will discuss the differences between the two operating systems and desktop environments. We will look at how to save and store your files in folders. You will also be shown how to download and install applications. We will also review some productivity tools and applications for Bodhi Linux. Instead of Outlook we suggest using Google's Gmail which will allow you to pop and combine your emails from different servers. It will also provide other Google apps that you can use via a browser. We will briefly review LibreOffice, how to open and save files in Microsoft Office formats to share with those in the Microsoft world....

Introduction - Part 1 The digital revolution is leaving many behind as technology leaps ahead. Many countries are limited to personal computers with Windows XP as its operating system (OS) and processors with memory that cannot support newer Windows, or Linux OS. Windows 10 minimum requirement: newer CPU (1 GHz or more), 2 GB RAM (64 bit), and 32 GB hard drive storage plus display at 800x600 pixels. These requirements are similar for newer Linux, or Chrome OS. However Linux does provide options for 'lite' versions that could run on more minimal hardware that supported Window XP and Window 7. The objective of this tutorial is to try to install a lite version of Linux on a Windows XP laptop with a Pentium M CPU, with 512 MB RAM and a 40 GB HDD. We know that we could install Puppy Linux, which supports Raspberry Pi up to version 4, however this was not pursued because we also wanted it to be able to run LibreOffice which is a functional replacement for Microsoft Office, so ...

A Sustainable Approach to Digital Literacy using Open Source Applications for schools and SMEs Mission To increase the computer literacy and competencies of children and small-medium enterprises (SME) in developing countries. We want to teach children in as many schools as possible to learn how to use the computer, within their respective country's technological limitations, so that they can actively participate in the fourth revolution. This would also apply to small businesses so that they can improve their operation and marketing skills in addition to opportunities for involvement in the global business network. Vision Enable developing countries to catch up and take part in the fourth revolution (transformation of the third digital revolution) as a connected, global stakeholder Introduction https://www.weforum.org/agenda/2016/01/the-fourth-industrial-revolution-what-it-means-and-how-to-respond/ We are in the midst of a fast charging digital revolution some consider it a part ...

Introduction The Small Industries Development Organization (SIDO) offices in Tanzania would like to develop a computerized SME database to better serve their clientele in their regions. As a result the Canadian Executive Service Organization (CESO) has initiated two assignments for the SIDO offices in Mara and Arusha regions with a Canadian Volunteer Advisor (VA) specialist Augusto Ribeiro. Based on experience with copyright issues with unlicensed software applications the VA proposes the use of Free and Open Source Software (FOSS) for the project. The software is LibreOffice Base from the Document Foundation established in Germany with support globally. LibreOffice is a powerful office application that can replace Microsoft Office and it runs on multiple operating systems including Windows, Linux and Apple based systems. It supports both open document formats odt, ods, odp, and Microsoft office file formats like doc, docx, xls, xlsx, ppt, pptx, etc. For more information on the Doc...

This blog tutorial is created to help you create a browser based (cloud) database application using MariaDB with CodeIgniter together with the Grocery-CRUD plugin that you can easily test through your localhost server on your desktop, on your LAN or via internet through your ISP. Download and install XAMPP on Windows OS or Apache, MariaDB (MySQL) and PHP on Linux. Download and install CodeIgniter3 in /xampp/htdocs or /var/www/html/ in Ubuntu under your website folder name. Download and install Grocery-CRUD application folders by merging them with the CodeIgniter3 folders in your proposed website. Use phpAdmin to create the MariaDB database for your website. Edit /application/config/database.php to point to your database as required. Edit /application/config/config.php to point to your database as needed. You can follow the following online tutorials or read the user manuals online to customise your site to work with CRUD. https://www.grocerycrud.com/ https://www.groceryc...