Posts

Showing posts from 2024

GES Launches Innovative Management Information System

Image
The Ghana Education Service (GES) has launched a cutting-edge Management Information System (GESMIS) designed to revolutionize the management of education data in Ghana . The GESMIS platform provides a comprehensive and integrated system for managing education data, enhancing decision-making, and improving the overall efficiency of the education sector. With GESMIS, the GES can track student performance, monitor teacher attendance, and manage school infrastructure, among other things. The system also prioritizes staff welfare, streamlining processes such as teacher transfers. The launch of GESMIS is a significant milestone in the GES's efforts to improve education access, quality, and relevance in Ghana.

Introducing the Ultimate Excel Add-In for Changing Text Cases

Image
Excel does not have dedicated Change Case buttons like Word. In Microsoft Word, you can easily toggle text cases (e.g., uppercase, lowercase, Proper (title) case, Sentence case, etc) with the built-in Change Case button in the ribbon.  However, Excel lacks such a feature, and users typically rely on these alternatives to change text cases: 1. Functions in Excel:  Excel provides built-in functions for changing text cases: =UPPER(A1) to convert text to uppercase. =LOWER(A1) to convert text to lowercase. =PROPER(A1) to capitalize the first letter of each word. These functions require creating new columns and/or overwriting existing data. 2. Add-Ins or VBA Macros:  Users can create or download custom macros or add-ins (like the AlatiphA xCases Add-In) to add case-changing functionality directly into Excel. These tools often integrate seamlessly into the ribbon, providing one-click solutions. 3. Manual Editing:  If the dataset is small, manual editing may suffice, but it’...

How to Install a Custom Excel Add-in: A Step-by-Step Guide

Image
Excel add-ins are powerful tools that extend the functionality of Microsoft Excel.  While the built-in add-ins are impressive, custom add-ins take personalization to the next level, allowing you to automate specific tasks, enhance data analysis, or integrate external tools. If you've received a custom Excel add-in and are wondering how to install it, this guide will walk you through the process. What You Need Before You Start Before installing a custom Excel add-in, ensure you have the following: 1.  The Add-in File : Typically, this is a file with an `.xlam` or `.xla` extension. This is the add-in itself. 2. Microsoft Excel Installed: Ensure Excel is installed and functioning properly on your computer. 3. Permissions : Ensure you have access to install files and modify Excel settings. 4. Unblocking the Add-in File (if needed): Some add-in files downloaded from the internet may require unblocking. Right-click the file, select Properties  and if you see an Unblock  ...

How to Unblock Excel Files Before Use: A Step-by-Step Guide

Image
  When you download Excel files or add-ins from the internet, Windows may block them as a security precaution. This protective measure is in place to prevent potential threats, but it can also block legitimate files, such as Excel workbooks or add-ins, rendering them unusable. If you've ever encountered a file that doesn't work as expected after downloading, this guide will help you unblock it safely. Why Are Excel Files Blocked? Files downloaded from the internet are flagged by Windows as coming from an untrusted source. When you try to open a blocked Excel file, you may experience issues such as: A security warning prompting you to enable editing.  Macros or add-in functionality not working. The file failing to load altogether. This behavior ensures that potentially harmful files do not execute malicious code on your system. However, legitimate files often get flagged as well. How to Unblock an Excel File 1. Access the Properties Window : Right-click on the Excel file or add...

Introducing AlatiphA Currencies: A Dynamic Excel Add-in for Currency Formatting

Image
  Do you find yourself repeatedly formatting numbers and currencies in Excel?  Whether you're a finance professional, an accountant, or simply a power user of spreadsheets, managing currency formats can be time-consuming and tedious.  Enter AlatiphA Currencies , an innovative Excel add-in that simplifies formatting tasks with a suite of powerful macros. Key Features of AlatiphA Currencies Add-in The AlatiphA Currencies add-in includes four primary macros designed to streamline your workflow. Here’s how they work: 1. Format Currency This macro applies customized currency formats to any selected range, supporting multiple currencies like Ghanaian Cedis (GH¢), US Dollars ($), Euros (€), British Pounds (£), Japanese Yung (¥) and Nigerian Naira (NGN).  Note : The Nigerian Naira currency symbol ( ₦ ) is not compatible with the VBA editor. So, the ₦ is automatically converted to "?" when entered in the editor. This makes it difficult to use the symbol as a currency. Hence, ...

Unlocking Productivity with Excel Add-ins: A Comprehensive Guide

Image
In the fast-paced digital age, efficiency and automation are essential for businesses and individuals alike. Microsoft Excel, a cornerstone of data analysis and management, becomes even more powerful when paired with Excel Add-ins . These add-ons expand Excel’s functionality, tailoring it to specific tasks and making complex processes manageable. What is an Excel Add-in? An Excel Add-in is a supplementary program that enhances the capabilities of Excel. Add-ins can be developed using VBA (Visual Basic for Applications), COM (Component Object Model), or JavaScript-based Office Add-ins. Whether you need advanced data visualization, automated workflows, or seamless integration with other software, add-ins bridge the gap between your needs and Excel’s out-of-the-box features. Benefits of Using Excel Add-ins 1. Automation and Efficiency Add-ins automate repetitive tasks, reducing manual effort and the likelihood of human error. From complex calculations to generating reports, they save va...

How to register and access the PLC site as Headteacher

Image
  Registration   1. Launch a browser e.g. Chrome  2. Enter the URL - plc.gov.gh in the address/search bar 3. Tap/click on Create Account  4. Tap/click on Head teacher/Head icon 5. Enter your school's NEW EMIS CODE e.g. 1121210558555  6. Select and confirm school's details  7. Complete the rest of the form by entering: You Full Name  Your Phones Number and  The school's Corporate GES email address . E.g. alatiphakgpri@ges.gov.gh  8. The username field will be populated with a username based on the email address as you can see in the above screenshot with alatiphakgpri_head as the username  9. Enter and confirm the corporate  password .  Note : The password is  TempPass1@?  for all schools  10. Tick ✅ to agree to the term, conditions and policies  11. Tap/click on Create   Signing In  1. Launch a browser e.g. Chrome  2. Enter the URL -  plc.gov.gh  in the...

8 Windows system diagnostic commands you should memorize

Image
Microsoft surface laptop on a table The Command Prompt in Windows is a program that acts like a text-based input field within the Windows Graphical User Interface (UI).  While it isn't as central a tool in Windows 10 and 11 as it once was, it remains incredibly useful. You can use it for advanced admin tasks and, most importantly, to troubleshoot and fix a bunch of issues on your laptop or gaming PC. Here we discuss the 9 essential Windows system diagnostic commands that are worth committing to memory. 8 Ping For those network issues The ping command is a Command Prompt command used to test the ability of the source computer to reach a specified destination computer. It verifies that a computer can communicate with another computer.  When you type “ ping ” followed by an IP address or web domain in the Command Prompt, it sends some test packets to that address. If they make it there and come back, it means the address can communicate with your PC. If not, something is blockin...

Resetting Ghana - 2024 NDC Manifesto

Image
The National Democratic Congress (NDC) successfully launched its 2024 manifesto at the University of Education, Winneba, on Saturday, August 24. Flagbearer of the NDC, John Dramani Mahama, bemoaned the economic hardships that Ghanaians are experiencing and pledged, among other things, to scrap nuisance taxes, improve education, implement an audacious $10 billion infrastructure investment to cater for public housing projects, etc. He also pledged to thoroughly investigate scandals that occurred during the tenure of the New Patriotic Party’s (NPP) government. PREVIEW and DOWNLOAD below "

2024 New Patriotic Party (NPP) Manifesto Highlights

Image
Dr Mahamudu Bawumia, New Patriotic Party flagbearer on Sunday, August 18, in Takoradi, Western Region, presented the party’s 2024 Manifesto, ahead of the December polls. In attendance at the launch were party supporters, executives, MPs, parliamentary candidates, and Ministers of State amongst others.

Knowledge exchange key to human capital transformation – Ya-Na

Image
  Ya-Na Abukari II receiving a souvenir from Prof Dr. Naci Caglar, VC of Bursa Technical University in Bursa, Turkey after a co-operation meeting. The Dagbon overlord Ya-Na Abukari II has indicated that education and knowledge exchange can play an important role in transforming human society. According to him, monetary grants alone from advanced nations to the developing world would not bring the necessary and required human capital and infrastructure development needed to transform Africa. He therefore urged leaders of the developing world and policymakers in Africa to prioritize knowledge transfer and exchange programs to accelerate development on the continent. The Ya-Na was speaking in Turkey on Monday at a meeting with the Vice-Chancellor of the prestigious Bursa Technical University (BTU) in Bursa, Turkey. The Ya-Na is on a 10-day working visit to Turkey. He said for the developing world to achieve the needed development to take its rightful place in the world, emphasis must ...

Nayiri commends Bashiru Imoro Ibn Saeed on vice chancellor appointment

Image
The Nayiri, Naa Bohugu Mahami Abdulai Sheriga, King and Overlord of the Mamprugu Kingdom, has extended heartfelt congratulations to Bashiru Imoro Ibn Saeed on his appointment as the new Vice Chancellor of Tamale Technical University (TaTU). In a statement dated 24 June 2024, the Nayiri lauded Saeed’s distinguished academic career, which includes Saeed’s role as the first board chairman of Kpasenkpe Senior High STEM School and his contributions as a reviewer for prestigious journals such as the Journal of Applied Statistics, Taylor & Francis Group, and SAGE Open. Saeed’s election to the International Statistical Institute (ISI) further emphasises his academic excellence. “This prestigious position is not only a testament to your exceptional academic achievements and leadership skills but also a recognition of your unwavering commitment to advancing higher education in Ghana,” the Nayiri stated. Saeed, who has over a decade of experience in academia, has received numerous accolades f...

How to create strong passwords?

Image
Creating strong passwords is crucial for online security. Here are some tips to help you create strong passwords : Length : Aim for a minimum of 12 characters, but the longer, the better. Mix and match : Combine uppercase and lowercase letters, numbers, and special characters. Uniqueness : Use a unique password for each account. Avoid reusing passwords or variations. Randomness : Use a password generator to create a truly random password. Avoid common patterns*: Steer clear of common patterns like "qwerty" or "123456". Don't use personal info : Avoid using your name, birthdate, or common words related to your personal life. Update regularly : Consider updating your passwords every 60-90 days. Some examples of strong passwords include: G$e4L9aK#M2p (a generated password) Iam@S3cur3! (a passphrase with a mix of characters) Tr0ub4d3!#4g3 (a password with a mix of characters and numbers) Remember, the key is to create passwords that are unique, complex, and diffi...

Yendi’s Naa Binbiegu Tua - 332-year-old sacred mythic baobab tree

Image
  Called “Naa Binbiegu Tua”, the tree was named after a former Overlord of Dagbon, Zangina Zuu Jinjli, who reigned between 1687-1700 and is believed to be the most unattractive Ya-Na in the history of Dagbon. The 332-year-old tree used to serve as a sacred place where Naa Binbiegu mounted his gods and idols for sacrifices and libations for the Dagbon Kingdom.  Motive History has it that the motive behind the name of the tree was due to the unattractive nature of the chief and his struggle to ascend to the Dagbon throne. As the eldest son of Naa Zangina, a former Overlord of Dagbon, he was expected to be the regent after the demise of his father and oversee the performance of his funeral. After the demise of his father, Naa Binbiegu consulted elders of Dagbon and family members to perform the funeral rites of his late father, which brought to light a new Overlord, Naa Andani Sigli. However, he was not compensated with any chieftaincy role or title after serving as the regent of...

Bulk Pdf to Word Converter

Image
  What Is VBA? Every business corporation or a person has its own set of unique needs and requirements. You might be dealing with large amounts of data that require analysis to create complex financial models.  You might also require customizable apps to help you create user-defined functions, access Windows APIs and automate computer processes. Unfortunately, the  Microsoft  (MS)  Office  applications within your Windows device might not meet your unique needs and help you achieve all your goals. Microsoft Corp realized this fatal flaw and developed  Visual Basic for Applications (VBA) , which they integrated into major MS applications such as Word, Excel, and Access. VBA is a programming language  you can use to access functions beyond what basic Microsoft Office applications can provide.  This  Pdf  to  Word  converter  is created using the  VBA Programming Language.  About the App Sometimes, you need to ...

Popular Posts

ICT for JHS

Regular BECE ICT Pasco

Gov’t Intervenes As Court Orders Auctioning Of GHANASCO Cars



AlatiphA is an Education and Technology blog that provides quality contents on education and technology.

AlatiphA is optimized for news, ebooks, educational templates, training, learning, testing (quizing) and many more.

Tutorials, eBooks and tests are constantly reviewed to avoid errors but we cannot warrant full correctness of all contents.

While using this blog, you agree to have read and accepted our:

Disclaimer,
Terms of use
&
Privacy policy.

We're Social