<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Chidiuto Okorie on Medium]]></title>
        <description><![CDATA[Stories by Chidiuto Okorie on Medium]]></description>
        <link>https://medium.com/@giovanniberchmans29?source=rss-607970840e99------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*YWhIGUlpRbu_J8rcsCqscQ.jpeg</url>
            <title>Stories by Chidiuto Okorie on Medium</title>
            <link>https://medium.com/@giovanniberchmans29?source=rss-607970840e99------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 15:34:23 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@giovanniberchmans29/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Database Design Project: Secondary School Database with MySQL]]></title>
            <link>https://giovanniberchmans29.medium.com/database-design-project-secondary-school-database-with-mysql-111dccd21fd6?source=rss-607970840e99------2</link>
            <guid isPermaLink="false">https://medium.com/p/111dccd21fd6</guid>
            <category><![CDATA[database-administration]]></category>
            <category><![CDATA[mysql]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Chidiuto Okorie]]></dc:creator>
            <pubDate>Tue, 21 May 2024 16:18:55 GMT</pubDate>
            <atom:updated>2024-05-25T08:03:18.302Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="Database Design: Image From Toptal" src="https://cdn-images-1.medium.com/max/1024/0*-upRH25SezYzgnwu.png" /><figcaption>Image from Toptal.com</figcaption></figure><p>The idea for this project came when I saw a friend; a UI/UX designer who designed a school manager app. While I scrolled through wireframes and clicked through prototypes, the thought of building something similar with SQL slowly grew in my head.</p><p>A school manager app is a great idea, no doubt. However, for such a thing to work, a database is required. Several kinds of databases exist, and resources abound on the internet to understand what a database is. If you are unfamiliar with the concept and wish to take a quick overview, you can read <a href="https://www.freecodecamp.org/news/what-is-sql-database-definition-for-beginners/">this article on freecodecamp</a>. Otherwise, we can go straight to business.</p><h3>Project Overview</h3><p>The aim of this project is to create a scalable database for a newly established secondary school in Nigeria; Stardust High School. It is to allow the following;</p><ul><li>Creation of student and staff ids and emails</li><li>Students to view their semester courses or results</li><li>Parents to view their children’s results, subjects, and subject teachers</li><li>Form teachers to view their students’ performances</li><li>Auto-update of students’ class every new session.</li></ul><p>Skills required to perform these tasks include; database planning and ERD design, database creation, views, triggers, stored procedures, and user management.</p><h4>1: Database Planning</h4><p>Just as the first stage in constructing a building is drawing up the plan, the first stage in creating the Stardust High School database is to create the database plan. This plan is an Entity Relationship Diagram (ERD); a visual representation of the tables, columns, and other objects to be added to the database.</p><figure><img alt="Entity Relationship Diagram for Stardust College — 13 tables in total." src="https://cdn-images-1.medium.com/max/668/1*iIQl9PLcsrf2wTmIIS8G4A.png" /><figcaption>Entity Relationship Diagram for Stardust High School</figcaption></figure><p>This ERD was created on MySQL Workbench. It contains 13 tables;</p><ul><li>staff positions — lookup table; contains all the staff along with their current positions and the number of staff in each category.</li><li>marital status — lookup table; contains possible marital status for staff and guardians</li><li>guardian type — lookup table; shows the different types of guardians a student might have</li><li>grades — the different grades possible; lettered A to F</li><li>subjects — a list of all subjects offered in the school; subjects taken by both junior and senior students are indicated as such.</li><li>academic year — lookup table for every academic year since Stardust High School’s founding.</li><li>genders — lookup table for staff and students&#39; tables</li><li>term — lookup table for every term (every academic year) since Stardust’s founding.</li><li>staff — table containing all the staff; academic and non-academic.</li><li>guardians — table containing list of all guardians for Stardust students.</li><li>results — every result in every subject for every student in Stardust.</li><li>students — table containing every Stardust student (past and present).</li><li>classes — lookup table for all 6 academic years (JSS1 — SS3)</li></ul><h4>2: Database Creation</h4><p>This step involves creating Stardust High’s database, along with all the tables involved. The first step here is relatively simple:</p><pre>-- Drop any existing schemas of the same name<br>DROP SCHEMA IF EXISTS stardust;<br><br>-- Create a new Stardust schema<br>CREATE SCHEMA stardust;<br><br>-- Set stardust as the active schema for subsequent queries<br>USE stardust;</pre><p>Next comes the table creation. All 13 tables will be created, along with their constraints: primary key, foreign key, nulls, defaults, etc. Here’s a code snippet from the staff table creation.</p><pre>CREATE TABLE staff (<br> staff_id INTEGER PRIMARY KEY, -- Sets Staff Id as primary key<br>    first_name VARCHAR(50) NOT NULL,<br>    middle_name VARCHAR(50),<br>    surname VARCHAR(50) NOT NULL,<br>    email VARCHAR(150),<br>    gender_id VARCHAR(50) REFERENCES genders (gender_id),<br>    phone VARCHAR(20),<br>    position_id INTEGER NOT NULL,<br>    marital_id INTEGER,<br>    FOREIGN KEY (position_id) REFERENCES staff_positions (position_id),<br>    FOREIGN KEY (marital_id) REFERENCES marital_status (status_id)<br>);</pre><blockquote>See SQL codes for all 13 tables <a href="https://github.com/Diuto/stardust-high-database/blob/main/tables%20and%20data/stardust_high.sql">here</a>.</blockquote><h4>3: Triggers</h4><p>Next comes the triggers. In simple terms, triggers are actions to be carried out automatically, tied to other actions by SQL code. In layman’s terms; one thing happens on the database (an update, insert, delete, etc.), and it causes something else to happen in the database. Read more about Triggers on <a href="https://www.freecodecamp.org/news/sql-triggers/">freecodecamp</a>.</p><p>The following triggers are set up in the database:</p><ol><li>Staff Table Triggers: There were three triggers in the staff table; one to update the number of staff in each position, one to create an employee email address, and another to create an employee id.</li><li>Student Table Triggers: Similar to the staff table, the triggers here were for student email, student id, and a third to update the number of students in each class.</li><li>Result Trigger: A single trigger to register the date wherein a result entry was made</li><li>Term and Year Triggers: Creates ids for new academic sessions, then updates students’ classes and the number of students in each class.</li></ol><pre>-- Result Trigger<br>CREATE TRIGGER result_date<br>BEFORE INSERT ON results<br>FOR EACH ROW <br> SET new.subject_date = CAST(NOW() AS DATE);<br><br>-- Term Triggers<br>CREATE TRIGGER term_id<br>BEFORE INSERT ON term<br>FOR EACH ROW<br> SET new.term_id = CONCAT(<br>                      REPLACE(<br>                       REPLACE(<br>                        &#39;2022/2023&#39;, &#39;20&#39;, &#39;&#39;)<br>                       , &#39;/&#39;, &#39;&#39;)<br>                      , CASE WHEN term_name = &#39;First&#39; THEN &#39;01&#39;<br>                        WHEN term_name = &#39;Second&#39; <br>                        THEN &#39;02&#39;<br>                        WHEN term_name = &#39;Third&#39; <br>                        THEN &#39;03&#39;<br>                       ELSE NULL<br>                        END<br>                    );<br>-- The rest of the triggers can be found on GitHub in the same document <br>-- as the database creation queries.</pre><h4>4: Test Data Loading</h4><p>In order to ensure that the database objects created thus far work properly, the next step would be to create dummy data that fit the inputs this database would expect once it goes live. Some of the data was created manually (especially the lookup tables). The others, however, were created using <a href="https://cobbl.io/">Cobbl</a>; a dummy data generator. Here’s a peek of the staff table using data generated from Cobbl:</p><figure><img alt="Staff Table using data generated from Cobbl" src="https://cdn-images-1.medium.com/max/855/1*dxCi6AWwkavfzfBvj1hETQ.png" /><figcaption>Staff Table, using data generated from <a href="https://cobbl.io/">Cobbl</a></figcaption></figure><blockquote>Test data for all tables can be found <a href="https://github.com/Diuto/stardust-high-database/blob/main/tables%20and%20data/lookup_tables.sql">here</a>.</blockquote><h4>5: Stored Procedures</h4><p>A stored procedure is a series of SQL statements put together and saved under a name such that, when the named procedure is called, those statements are executed by SQL. It is often said that stored procedures are useful when one intends to reuse the same queries often or to grant access to organization report creators who require certain data but don’t write SQL themselves.</p><p>The following stored procedures were created in the Stardust High database:</p><ol><li><strong>form_teacher_students:</strong> to show each form teacher a list of students in their class. This procedure takes in a single argument; the teacher’s staff id.</li><li><strong>guardians_wards:</strong> to pull up a list of students in the school (past and present) registered by a parent/guardian. This takes the guardian id as its sole argument.</li><li><strong>num_students_class:</strong> shows a list of students currently in a given class along with the number of students in said class. This takes two arguments; one input and one output.</li><li><strong>student_details:</strong> takes in an argument (student id) and returns their details from their full name to their age, and their current form teacher.</li><li><strong>student_subjects:</strong> takes in two arguments — students id and department (Science/Arts/Commercial) where necessary — and returns a list of subjects such a student can take in the current term.</li><li><strong>student_results:</strong> takes three arguments — student id, academic year, and term — and returns the uploaded results for the student that term along with the term average.</li></ol><p>See the stored Procedure for Student Results:</p><pre>DELIMITER //                 -- Change the delimiter<br>CREATE PROCEDURE student_results <br>(<br>  IN stud_id INT,            -- Student ID<br>  IN acad_year VARCHAR(20),  -- Academic Year (for result)<br>  IN term_i VARCHAR(20)      -- term<br>  )<br>BEGIN<br> WITH res1 AS (              -- A CTE to retrieve the original result<br>   SELECT<br>      s.subject_name,<br>      test1,<br>      test2,<br>      exam,<br>      (test1+test2+exam) AS total<br>   FROM results r<br>     LEFT JOIN subjects s ON r.subject_id = s.subject_id<br>   WHERE student_id = stud_id <br>      AND term_id = (         -- Subquery to retrieve term id<br>              SELECT term_id FROM term <br>              WHERE academic_year = acad_year AND term_name = term_i<br>              )<br><br>   UNION                      -- Union, append the result average<br>   <br>   SELECT <br>       &#39;Overall Avg:&#39;,<br>        null, null, null,<br>        ROUND(AVG(test1+test2+exam), 2)<br>   FROM results<br>   WHERE student_id = stud_id <br>    AND term_id = (<br>             SELECT term_id FROM term <br>             WHERE academic_year = acad_year AND term_name = term_i<br>              )<br>),<br>grad AS (                     -- A second CTE to add the grades<br> SELECT <br>      *,<br>      COALESCE(LAG(min_score, 1) OVER(), 100) AS next_score<br> FROM grades<br>)<br><br>-- Main query to match the grades to the results<br>SELECT <br> subject_name,<br>    test1, test2, exam,<br>    total,<br>    grade_id AS grade,<br>    honour<br>FROM res1 r<br>LEFT JOIN grad g<br>ON r.total &gt; g.min_score<br> AND r.total BETWEEN g.min_score AND next_score;<br>END //<br>DELIMITER ;          -- Change the delimiter back to the semicolon<br><br><br>-- Next, test the procedure with one of the students<br>CALL student_results(2020101, &#39;2022/2023&#39;, &#39;First&#39;);</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/475/1*9-5kIQXxkPHOnduxqPyORg.png" /><figcaption>Result for student with id 2020101 in 1st term, 2022/2023 academic year</figcaption></figure><blockquote>See the rest of the stored procedures <a href="https://github.com/Diuto/stardust-high-database/blob/main/tables%20and%20data/procedures.sql">here</a>.</blockquote><h4>6: User Management</h4><p>The next task here is creating users to access database objects. Three different permission levels are in order:</p><ol><li>Database Administrator: All privileges granted.</li><li>Database Manager: Other ICT staff get privileges such as CREATE, CREATE VIEW, ALTER, INSERT, DROP, DELETE, etc.</li><li>Form Teachers &amp; ICT Interns: Form teachers need to access student results and see certain student details. Hence, they are granted SELECT and EXECUTE permissions.</li></ol><p>First, these users are created, using their organization email address. The organization email is used because this project assumes the database will be hosted on the school’s private server.</p><pre>-- This block creates all the necessary database accounts: <br>-- that is, ICT staff and the class teachers. <br>-- The last 3 users are ICT staff; administrators<br><br>CREATE USER <br> &#39;nathan.l.bailey&#39;@&#39;staff.stardust.com&#39; IDENTIFIED BY &#39;nathan123l&#39;,<br> &#39;brianna.e.allen&#39;@&#39;staff.stardust.com&#39; IDENTIFIED BY &#39;brianna123e&#39;,<br> &#39;nicholas.w.roberts&#39;@&#39;staff.stardust.com&#39; IDENTIFIED BY &#39;nicholas123w&#39;,<br> &#39;audrey.l.gonzales&#39;@&#39;staff.stardust.com&#39; IDENTIFIED BY &#39;audrey123l&#39;,<br> &#39;alyssa.n.simmons&#39;@&#39;staff.stardust.com&#39; IDENTIFIED BY &#39;alyssa123n&#39;,<br> &#39;alexandra.l.hernandez&#39;@&#39;staff.stardust.com&#39; IDENTIFIED BY &#39;alexandra123l&#39;,<br> &#39;alexandra.m.wilson&#39;@&#39;staff.stardust.com&#39; IDENTIFIED BY &#39;alexandra123m&#39;,<br> &#39;lillian.m.turner&#39;@&#39;staff.stardust.com&#39; IDENTIFIED BY &#39;lillian123m&#39;,<br> &#39;robert.clark&#39;@&#39;staff.stardust.com&#39; IDENTIFIED BY &#39;robert123c&#39;,<br> &#39;stephen.w.lopez&#39;@&#39;staff.stardust.com&#39; IDENTIFIED BY &#39;stephen123w&#39;<br>PASSWORD EXPIRE;<br><br>-- The &#39;Password Expire&#39; statement ensures the original password expires <br>-- upon first login and they create a new password for better security</pre><p>Next, we create the permissions.</p><pre>-- Lilian Turner is the sole DB Admin, so their permission is <br>-- specifically created<br>GRANT ALL PRIVILEGES ON stardust.*<br>TO &#39;lillian.m.turner&#39;@&#39;staff.stardust.com&#39;; <br><br>-- For DB Managers, more ICT staff could be hired along the way; and since<br>-- there are too many privileges, a role is created instead.<br><br>CREATE ROLE DBManager; <br><br>GRANT     -- Grants privileges to the new role<br> CREATE,<br> ALTER,<br>    CREATE TEMPORARY TABLES,<br>    CREATE VIEW,<br>    EVENT,<br>    EXECUTE,<br>    INDEX,<br>    INSERT, <br>    SELECT, <br>    SHOW VIEW, <br>    TRIGGER, <br>    UPDATE <br>ON stardust.* TO DBManager;<br><br><br>-- This block adds the ICT DB Managers to the role<br>GRANT &#39;DBManager&#39;<br>TO <br>&#39;robert.clark&#39;@&#39;staff.stardust.com&#39;, &#39;stephen.w.lopez&#39;@&#39;staff.stardust.com&#39;;<br><br><br>-- Select and Execute privilege for the form teachers and future interns<br>-- to enable them so they can use stored procedures<br>GRANT SELECT, EXECUTE ON stardust.*<br>TO<br> &#39;nathan.l.bailey&#39;@&#39;staff.stardust.com&#39;,<br> &#39;brianna.e.allen&#39;@&#39;staff.stardust.com&#39;,<br> &#39;nicholas.w.roberts&#39;@&#39;staff.stardust.com&#39;,<br> &#39;audrey.l.gonzales&#39;@&#39;staff.stardust.com&#39;,<br> &#39;alyssa.n.simmons&#39;@&#39;staff.stardust.com&#39;,<br> &#39;alexandra.l.hernandez&#39;@&#39;staff.stardust.com&#39;,<br> &#39;alexandra.m.wilson&#39;@&#39;staff.stardust.com&#39;;</pre><h4>7. Backup and Recovery</h4><p>Like all forms of digital information, data stored within a database can be lost due to several reasons; from user erros to hardware malfunction. Therefore, it is important to occasionally save a copy of your data for easy retrieval in the case of a mishap. For stardust college, I would recommend the following:</p><ul><li>A cloud storage; a different service provider (needless to say, off-premises)</li><li>A backup hard-drive/optical storage</li><li>A backup on the on-premises server itself, to be synced periodically.</li></ul><h3>Conclusion</h3><p>Having a database like this one only serves to create a platform for schools to better manage their student data and understand metrics for both the business and educational aspects of the institution. Room for growth appears in the following departments;</p><ul><li>Financial data, to help both school management and guardians track payments for students.</li><li>A school manager app (such as a Power BI service app) to help parents, staff, students, and other stakeholders access data visualization to uncover trends as concerns them — business or academic.</li><li>Adding data about students in extracurricular activities; prefects, representatives in competitions, medals won, etc.</li><li>A pipeline from this project to an input source where the student and guardian data can be added by admin, staff data by HR, and results, by their various teachers.</li></ul><p>Thank you for reading up to this point. See the complete project repository <a href="https://github.com/Diuto/stardust-high-database/tree/main">here</a>. Your comments, suggestions and other corrections are welcome.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=111dccd21fd6" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Data Analytics: More than a Career for Me]]></title>
            <link>https://giovanniberchmans29.medium.com/data-analytics-more-than-a-career-for-me-ed358fac88fb?source=rss-607970840e99------2</link>
            <guid isPermaLink="false">https://medium.com/p/ed358fac88fb</guid>
            <category><![CDATA[100-days-of-learning]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[careers]]></category>
            <category><![CDATA[growth]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Chidiuto Okorie]]></dc:creator>
            <pubDate>Tue, 10 Oct 2023 21:30:42 GMT</pubDate>
            <atom:updated>2023-10-10T21:30:42.456Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/800/0*IcraptAXp4GGPUhi.jpg" /><figcaption>Image from dreamstime</figcaption></figure><p>It’s the 100th day (more like 100th entry) of my <a href="https://x.com/diuto_okorie/status/1540031950160904195?s=20">#100DaysOfData series</a>. If you follow me on twitter, you’re probably thinking, “Oh finally. I thought it’d never end.” Guess what? Me neither, and here’s why.</p><p>In June 2022, I picked up yet another tech interest. This, after my failed attempts at Native Android development (with Java) in late 2019 — early 2020, that extremely short stint at frontend web development (sometime in 2018 – 2019), and the cross-platform mobile development with flutter (2021) that lasted a bit longer than the others; hell, I even completed a Zuri training and started HNG 2021 with it. Nods to my <a href="https://medium.com/@giovanniberchmans29/hng-8-goals-39fadbe2aded?source=your_stories_page-------------------------------------">HNG 8 opening article</a>.</p><p>Yet again, I find myself intrigued by an arm of tech; the 21st century’s buzzword industry. Having understood why I kept falling by the wayside in the past, I was determined to stay in line this time —to become a data professional. One of my biggest challenges is staying committed, and one way to tackle that was the #100Days challenge. So, on the 23rd day of June in the Year of the Lord 2022, I kicked it off.</p><iframe src="https://cdn.embedly.com/widgets/media.html?type=text%2Fhtml&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;schema=twitter&amp;url=https%3A//twitter.com/diuto_okorie/status/1540031950160904195%3Fs%3D20&amp;image=https%3A//i.embed.ly/1/image%3Furl%3Dhttps%253A%252F%252Fabs.twimg.com%252Ferrors%252Flogo46x38.png%26key%3Da19fcc184b9711e1b4764040d3dc5c07" width="500" height="281" frameborder="0" scrolling="no"><a href="https://medium.com/media/e12a3f35daa0009cdedea4a32d18e018/href">https://medium.com/media/e12a3f35daa0009cdedea4a32d18e018/href</a></iframe><p>Yes, yes, 23rd June 2022 was — * counts fingers* — 475 days ago. Consistency has always been a problem for me. I knew even when I learned on some days, documenting would be a problem, and if I felt I was being inconsistent, I’d be inclined to quit. So, I wrote this under the original post.</p><iframe src="https://cdn.embedly.com/widgets/media.html?type=text%2Fhtml&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;schema=twitter&amp;url=https%3A//twitter.com/diuto_okorie/status/1539339201329627141%3Fs%3D20&amp;image=https%3A//i.embed.ly/1/image%3Furl%3Dhttps%253A%252F%252Fabs.twimg.com%252Ferrors%252Flogo46x38.png%26key%3Da19fcc184b9711e1b4764040d3dc5c07" width="500" height="281" frameborder="0" scrolling="no"><a href="https://medium.com/media/a03a0ee37dfdf2b11851db3382ab6821/href">https://medium.com/media/a03a0ee37dfdf2b11851db3382ab6821/href</a></iframe><p>“The sweetness of a journey is in the going, not the destination,” my grandad always says. I decided to focus on the journey. I was going to keep learning data analysis long enough to make 100 posts regardless of how distracted I got, regardless of how lax I got with it. And I did get lax…</p><p>Sometimes, it was my fault and sometimes, it wasn’t. Between my job (which I don’t have anymore), my academic activities and other commitments, sometimes, I could not simply bring myself to put a tweet together.</p><p>My friend and I used to joke about it, “that 100-days series that’s taken like a thousand days and counting.” How funny would it have been if I actually made it to half of a thousand? I planned initially to leave the 100th entry to whenever I get a job in data, then have landmarks placed for when I officially started learning and when I got my first full-time job. But if that doesn’t happen soon, the wait will probably be a recipe for depression; plus, this had me too excited.</p><p>Data Analysis, for me, is more than just a career. This thread was a way to prove to myself that I could stay consistent; that I could begin a journey and see it through. That’s the ‘W’ I’m leaving here with. I’m not close to where I want to be or where I should be, but I’m 100 entries and a few minor projects better a data analyst than I was on 23rd June 2022.</p><p>I hope I make it on this path. If I don’t, it won’t be for my lack of trying.</p><p>There was no reason for me to share this story, except that I miss writing in this form, and this was a good excuse. In the meantime, here is my linktree, in case you’d like to contact me for gigs, internships, or other roles.</p><p><a href="https://linktr.ee/diutooo">@diutooo | Linktree</a></p><p>Whatever projects I work on, you’ll be able to access them from there.</p><p>Here’s to the journey. Cheerio!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ed358fac88fb" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Video Game Sales Analysis — EntryLevel Capstone Project]]></title>
            <link>https://giovanniberchmans29.medium.com/video-game-sales-analysis-entrylevel-capstone-project-327ebc22ff3?source=rss-607970840e99------2</link>
            <guid isPermaLink="false">https://medium.com/p/327ebc22ff3</guid>
            <category><![CDATA[microsoft-excel]]></category>
            <category><![CDATA[videogames]]></category>
            <category><![CDATA[video-games-industry]]></category>
            <category><![CDATA[data-analyst]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Chidiuto Okorie]]></dc:creator>
            <pubDate>Mon, 31 Oct 2022 15:20:05 GMT</pubDate>
            <atom:updated>2022-10-31T15:27:06.307Z</atom:updated>
            <content:encoded><![CDATA[<h4>An analysis of Video Game Sales Between 1980 and 2020</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*xl58wIw7XH2z17KV" /><figcaption>Image from UCL Pi Media (<a href="http://static1.squarespace.com/static/5d0dc22f70b70c00015d510a/5d0dc48245897f0001f24807/6013d74aa0d7195b7bf6f3a5/1613581258756/igor-karimov-9AmKnNZw3GA-unsplash.jpg?format=1500w">uclpimedia.com</a>)</figcaption></figure><p>On 13th September 2022, I began a bootcamp/training with EntryLevel where I carried out two projects. One of them particularly piqued my interest for reasons I don’t yet understand. Since that was the case, I decided to publish on Medium and make it My First Official Data Analyst project.</p><h4>Tools Used:</h4><p>Spreadsheets (Google Sheets)</p><h4>Knowledge Required:</h4><p>Formulas in spreadsheets including but not limited to;</p><ul><li>VLOOKUP</li><li>Arithmetic and Conditional Statements (e.g. SUMIF, COUNTIF, etc.)</li><li>FILTER</li><li>Pivot Tables</li><li>Charts and other Visualisation tools</li></ul><h3>Project Description</h3><p>In order to make an entrance as a publisher in the video gaming industry, a startup has requested analysis on the leaders in the video game market. The aim of this exercise is to understand what aspects of the market are the most lucrative, know the major competitors and the best ways to enter into the market.</p><p>To achieve this goal, I retrieved a <a href="https://www.kaggle.com/gregorut/videogamesales">video games sales dataset from Kaggle</a> from games with over 100,000 copies sold. I imported this data and analysed it using spreadsheets (Google Sheets) from formatting and cleaning to visualisation. This report provides insight into the data and the process used in analysing it.</p><h3>Data Design</h3><p>The video game sales dataset has 11 features and 16,598 observations. The observations so rank (according to global sales), game, platform, publisher, genre, year of release, sales in North America, Japan, Europe, other countries, and total global sales. The data was stored in a Comma-Separated Values (CSV) format as vgsales.csv. In this format, I imported the document into Google Sheets.</p><p>To begin the data cleaning process, I filtered the columns to check for missing data. I discovered that missing year and publisher data were replaced with “N/A” in the dataset. I decided to clean the “Year” data using this logic; several gaming platforms have existed since the origin of video gaming and have gone in and out of vogue. Hence, I decided that the platform on which a game was released could very well be used to guess the time period during which it was released. Hence, I created a new column, “Year_Cleaned” and replaced each N/A with the Median release year for the corresponding release platform. The publisher column remained untouched.</p><p>It is also worthy of note that there is no data available for the years 2018 and 2019. There is also very little data available for 2020.</p><p>From here, the next step was the analysis and visualisation, all of which was done using pivot tables and charts in Google Sheets.</p><h3>Analysis Questions and Insights</h3><p>We begin by exploring the total sales per year and the popularity growth and decline of video games in the 40 years covered within the dataset; 1980–2020.</p><h4>#1. World Video Game Sales</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/734/1*VZFzgv_L2ejMTiztZzp_Ww.png" /></figure><p>According to the area chart above, video game sales in the 80’s remained pretty steady while rising and dropping at a regular rate. In the mid-90’s, however, sales began to skyrocket as video and game technologies got better. Sales peaked in the late 2000’s and dipped after 2010. Does that mean the video game market is dying?</p><h4>#2. Where are the best game markets?</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/521/1*Y3kle2P4w47sevSeKksxGw.png" /></figure><p>Going by the Doughnut chart above, North America is the best continent in the world to establish a gaming business as they alone constitute nearly half the total global sales (49.3%). Japan (a country, unlike other continents here) accounts for 14.5% of global game sales.</p><h4>#3. What are the most popular video game genres?</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/696/1*YdEp9vA9pDTjQZi2sFJpsQ.png" /></figure><p>The dataset shows 12 distinct video game genres over the 40-year period. We measure the popularity of the game genre by total sales. Action games, sports, and shooter games are the top 3 with strategy coming bottom of the lot.</p><h4>#4. Where do these games sell best?</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/655/1*41_jju3FVk795iDAnxx3sA.png" /></figure><p>As previously mentioned, North America usually has the most sales by a mile, so it makes sense that nearly all genres sell well in North America. You would also notice that in Japan, genres like strategy, role-playing, and puzzle sell pretty well, compared to games like shooter and racing that do not. Still, I wouldn’t base any decision on those numbers considering they compare to continents rather than just countries.</p><h4>#5. How have these genres fared over the years?</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/706/1*fWJnTtuFuFdn2kqWCIXVww.png" /></figure><p>The plot above is a heatmap that shows how sales have progressed over the decades. The most popular game genres over the last two decades are action and sport games. Shooter, miscellaneous, and role-playing games are up there as well, but not quite on par with the first two. Having large markets like that might mean you have a larger potential audience. However, it could mean bigger competition as well.</p><h4>#6. What is the competition like in each Genre?</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/594/1*3RLgsY5QPGgdqoaNtFTpBg.png" /></figure><p>Action games have the highest number of publishers, corresponding with their popularity. The Action game market has the highest competition.</p><h4>#7. Who are we competing against in the market?</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/680/1*8qAcDyYLIXOu7bNK04eNDw.png" /></figure><p>The chart above shows the 10 most successful game publishers in the market with respect to total sales. Nintendo, a leading game publisher in the Action and Sports genres, is the biggest market leader.</p><h4>#8. How do these competitors fare in the market?</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/669/1*CCRrflu5O-Oq4N1ga8tOXw.png" /></figure><p>The aim of the radar chart above is to show how each of the top 10 competitor’s global sales (in millions of copies sold) compares to the number of games released. From the radar chart, Nintendo is the only publisher whose market performance far outweighed their number of games released. This could mean they have excellent profit on each game released.</p><h4>#9. What gaming platforms are most popular with publishers?</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/713/1*KH3KUXsNQEk3XsfdsItOhA.png" /></figure><p>First things first, the reason we consider only platforms since 2010 is because Gaming platforms come and go. When releasing a game, we wouldn’t want to consider platforms that were popular in the 90’s. The list above will help us decide our scale of preference as we plan what platforms to release games on.</p><h4>#10. What are the best-selling gaming platforms?</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/668/1*JdgfpTTfx1B5l7HhZN_nvg.png" /></figure><p>Even though it is important to know the most popular platforms with publishers, it is more important to know the ones consumers prefer. From the bar chart above, customers obviously prefer the PlayStation (PS3 and PS4) and the X360 (Xbox 360) platforms. Other popular platforms are 3DS, Wii, XOne (Xbox One).</p><h3>Next Steps</h3><p>The analysis above shows us some of the important things we need to know about the video game market and what opportunities to exploit. We’ve identified who our main competitors are, the best platforms on the market and the best genres to enter the market through. We shall now explore the decisions to make and the actions to take before moving into the video game industry.</p><ol><li>Set up an office in North America and another in Japan. These two have the largest gaming markets for continent and country respectively.</li><li>Venture into sports or shooter games; they have low competition compared to their market popularity.</li><li>Try to look into Nintendo’s and Activision’s business models and see how they penetrate the market. Nintendo is a leading marketer in sports and action while Activision has the same pull in shooter.</li><li>The games we release should be available on PlayStation 3 and 4 (maybe 2 as well). It should also be available on Xbox 360.</li></ol><h3>Conclusion</h3><p>The said game publisher company for which this analysis was done is an entirely made up one. The task required us to come up with a business problem we would solve using the data provided, so I created one.</p><p>Below is a list of other related links to this project:</p><p>Dataset on Kaggle:</p><p><a href="https://www.kaggle.com/gregorut/videogamesales">Video Game Sales</a></p><p>Spreadsheet Used for the Project:</p><p><a href="https://docs.google.com/spreadsheets/d/1QKE-F7YWILXinHJDXcMaGgIvnHbAPptwHhlOshyoRfU/edit?usp=sharing">EntryLevel Capstone Project</a></p><p>EntryLevel Portfolio, including First Project:</p><p><a href="https://drive.google.com/file/d/1LJgyrcPC4nMsZnP21qEcumBgcMq1hHgW/view?usp=sharing">EntryLevel Portfolio.pdf</a></p><blockquote>If my First Data Analyst Project impressed you, find me on <a href="https://www.linkedin.com/in/chidiuto-okorie-0397a3163">LinkedIn</a> or <a href="https://twitter.com/diuto_okorie">Twitter</a>. I’d love to hear your feedback and I’m currently open to internships.</blockquote><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=327ebc22ff3" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[He Who Puts His Hand To The Plough…]]></title>
            <link>https://giovanniberchmans29.medium.com/he-who-puts-his-hand-to-the-plough-bb5d2378a1c9?source=rss-607970840e99------2</link>
            <guid isPermaLink="false">https://medium.com/p/bb5d2378a1c9</guid>
            <category><![CDATA[2023-elections]]></category>
            <category><![CDATA[priesthood]]></category>
            <category><![CDATA[nigeria-election]]></category>
            <category><![CDATA[politics]]></category>
            <category><![CDATA[catholic]]></category>
            <dc:creator><![CDATA[Chidiuto Okorie]]></dc:creator>
            <pubDate>Wed, 22 Jun 2022 11:20:50 GMT</pubDate>
            <atom:updated>2022-06-22T15:05:42.018Z</atom:updated>
            <content:encoded><![CDATA[<h4>Is it getting harder for Catholic Priests to not look back?</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/750/0*-cVLzREwWW3IdEDd.jpg" /><figcaption>Image gotten from Rainbowtoken.com</figcaption></figure><p>As soon as you read the byline, I imagine one of two scenarios went through your head;</p><ol><li>You’re a devout Catholic and you’re thinking, “God forbid! What sort of clownery is contained within this story?”</li><li>You’re non-Catholic thinking, “It’s about time…”</li></ol><p>Or maybe you’re a part of a third, less extreme group, wondering why I would suggest such a thing, and you’re genuinely curious to see what I’m getting at. I certainly do hope I’m able to pass this message across in the most inquisitive manner possible. Let us begin;</p><h3>Source of Concern</h3><p>I’ll start by pointing out the state of events that drew me to think about this article. Initially, I was going to go with the title, “Let this cup pass me by… Are Priests getting tired of their vows?” But then, I realised I would have to do a whole section on educating people about the priestly vows, how they came to be, and perhaps what popular people (relevant to my point) may have broken their vows.</p><p>Rather than ply that road, I made myself the puss in priestly boots; imagining what life must be for these men, hardened by 10+ years of education and charged to go out into a world, having nothing that belonged to them; ultimately, not even belonging to themselves.</p><h4>Rev. Fr. Dr. Hyacinth Alia</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/363/0*K4Z3uvZFVCjqmqIe.jpg" /><figcaption>Rev. Fr. Hyacinth Alia</figcaption></figure><p>I first came upon the idea of this article a few months ago when — like any other day — I was scrolling through the blue bird app and happened to stumble into a tweet mentioning a catholic priest in a certain diocese vying for a political position in his state.</p><p>I thought to myself; “Ugh, Twitter trolls again…”</p><p>Sadly (or fortunately, depending on who you ask) for me, I have an undying curiosity that simply will not remain silent in the face of unanswered questions. I abandoned my work for that day and decided to go gossip-hunting.</p><p>Now, I do not claim to be an expert at detecting the original account out of many parody Twitter accounts (especially when that original lacks the famous blue tick), but I did search through tweets and happened to find a certain <a href="https://twitter.com/frhyacinthalia">@frhyacinthalia</a>; a Twitter account who became a <a href="https://www.merriam-webster.com/dictionary/tweep">tweep</a> in January 2022. Lucky enough, there were less than 10 tweets, so the earliest of those was barely a scroll away;</p><h3>Rev. Fr. Dr. Hyacinth Alia on Twitter: &quot;LET&#39;S WAKE UP TO THE CHANGE pic.twitter.com/d5ct0ppr33 / Twitter&quot;</h3><p>LET&#39;S WAKE UP TO THE CHANGE pic.twitter.com/d5ct0ppr33</p><p>Wow; Revered Father Doctor Hyacinth Alia… an ordinated Priest of the “Holy Roman Catholic Church,” looking to become the next Governor of Benue State; that too, under the infamous All Progressives Congress (APC) political party. A Priest in every sense of the word; he even posted photos of himself officiating the Holy mass a few times.</p><h3>Rev. Fr. Dr. Hyacinth Alia on Twitter: &quot;MASS FOR THE SICK AT ST. PAUL&#39;S CATHOLIC CHURCH IKYAATOR, VANDEIKYA Today, Thursday April 28, 2022 I said Mass for the sick (Healing Mass) at the St. Paul&#39;s Catholic Church Ikyaator in Vandeikya local government area of Benue State.May God help us. pic.twitter.com/JtXjQTMY6l / Twitter&quot;</h3><p>MASS FOR THE SICK AT ST. PAUL&#39;S CATHOLIC CHURCH IKYAATOR, VANDEIKYA Today, Thursday April 28, 2022 I said Mass for the sick (Healing Mass) at the St. Paul&#39;s Catholic Church Ikyaator in Vandeikya local government area of Benue State.May God help us. pic.twitter.com/JtXjQTMY6l</p><p>Of course, the biggest question for me would be how a Catholic priest who may have sworn perpetual poverty managed to raise 50 million naira (NGN 50M) to purchase the APC Express of Interest form.</p><p>Nevertheless, the Catholic Diocese of Gboko, Benue state, suspended Fr. Hyacinth, for breaking the priestly code of conduct regarding non-involvement in partisan politics.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/665/0*Ka8ActozhjBZ6mqY.jpeg" /><figcaption>Press release by the Catholic of Gboko, Benue state, regarding Fr. Hyacinth Alia</figcaption></figure><p>The story between him winning the APC gubernatorial ticket for Benue state and the party looking to cancel the primaries as of today, is of no consequence to this article. Therefore, I now move to the second big candidate for this article;</p><h4>Very Rev. Fr. Ejike Mbaka</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/750/0*ASDVkfKRXiw9QZR2.jpg" /><figcaption>Very Rev. Fr. Ejike Mbaka</figcaption></figure><p>No stranger to religious and political controversy, Fr. Mbaka (as he is more popularly known) is by far, the more popular of the two priests I chose to focus on today. He grew to fame in the early 2000s with his Adoration Ministries in Enugu State, Nigeria (abbreviated as AMEN). Of course, the different adoration albums he released with his band helped a lot.</p><p>Christians in South-Eastern Nigeria held him in high regard for so long; with a good number of them believing him to be the most anointed priest of his time, as far as they could tell. Catholics and non-Catholics swarmed to his Adoration ground for prayers and blessings, and to purchase blessed items.</p><blockquote>I once attended a crusade myself, where Fr. Mbaka ministered on the last day. As the event ended and Fr. Mbaka’s car was leaving, people crowded it and would simply not let him go. People took off their clothes to wipe his windshield and lay on the car’s hood in what became a low-speed parade. This is just how much he had been idolised.</blockquote><p>It doesn’t seem so far-fetched to assume that being a man, some of this started to get to Fr. Mbaka’s head. In 2015, he fell out with a lot of his followers for his prophecy that President Muhammadu Buhari — who was then, only an aspirant — was sent by God to save Nigeria. Fast-forward a few years, and a lot of Nigerians would argue that such a revelation was definitely of flesh and blood.</p><p>In 2018, Fr. Mbaka had a political fallout again, after he asked President Buhari to not contest during the 2019 elections, owing to another revelation. The <a href="https://independent.ng/apc-mbaka-not-bound-prophecies-buhari/">ruling party hit back with a statement</a> that they were not bound by his prophecies.</p><p>In 2021, once again, he had a fallout with the Presidency, leading to a hurl of words back and forth and an eventual threat to blackmail him. This led to the now-infamous clergyman’s <a href="https://gazettengr.com/exclusive-catholic-church-suspends-father-mbaka-amidst-buhari-spar-followers-on-rampage/">30-day suspension by the Catholic Diocese of Enugu</a>, by the authority of His Lordship Most Rev. Dr. Callistus Valentine Onaga.</p><p>Now, barely a year after, the man of God is caught in his own web again. This time, for making statements which could be considered derogatory to Presidential candidate and former governor of Anambra State, Peter Obi, going further to imply he would never become President.</p><p>Following this act, the Catholic diocese of Enugu released a statement dissociating itself from such statements. The letter below — similar to the one issued to Fr. Hyacinth (see above) — states that the act is in clear violation of some priestly code of conduct with prevents them from engaging in partisan politics; a fact which Fr. Mbaka simply had to have known.</p><figure><img alt="Press Release by the Catholic Diocese of Enugu in response to Fr. Mbaka’s statement" src="https://cdn-images-1.medium.com/max/613/1*pCJkgyHXGhjIXm3np5lCoQ.png" /><figcaption>Press release by the Catholic Diocese of Enugu in response to Fr. Mbaka’s statement</figcaption></figure><p>Only a day later, the Catholic Diocese of Enugu released a second statement; this time, banning Catholics from attending Adoration ministries. See below</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/648/1*n4M5uDVCprr8rlcaDTC34A.png" /><figcaption>Second press release by the Catholic Diocese of Enugu in response to Fr. Mbaka’s statement</figcaption></figure><h3>What Now?</h3><p>Yes, the question. Why did I think it fit to write this? I don’t know, maybe I’m tired of seeing Priests turn on their vows big time. I mean, there are little things that happen on the spur of the moment, and you can’t help but look past them as mistakes that we as humans are prone to.</p><p>However, running for an electoral seat seems to be a rather long process; and public too. He had to have been warned along the way, by parishioners and colleagues.</p><p>Publicly picking a side in the name of God — that too, during the liturgy — may have been a momentary lapse the first time, but I once heard the saying; “One is an accident, two is a coincidence, three is a pattern.”</p><p>Make no mistake; this is only in politics, and it contains only the two most recent POPULAR scandals. I chose to not expand the scope of my article to contain other forms of scandal. The reason for this article is to ask the question; Are modern catholic priests now looking back as well?</p><blockquote>“He who puts his hand to the plough and looks back is not fit for the kingdom of God…” ~Luke 9:62</blockquote><p>Why go ahead to make vows when you’re unsure of your discipline? Why continue stubbornly on a path to breaking your religious vow after being reprimanded?</p><p>I giggled at this point because I just realised, we could make the same argument against people who show utter disregard for their marriage vows. Heh! Your face didn’t happen to squeeze a little bit, did it? I don’t think we’re ready for that conversation.</p><p>Catholics will tell you to pray for the Priests — they are human, after all.</p><p>Some people might use more occurrences like this to discredit the institution of Priesthood.</p><p>Me? I just wonder what questions we aren’t asking? Perhaps it’s true that history has nothing new for us — it only rinses and repeats in a different format. For if in 2022, centuries after the church’s dark ages, Priests who should show the body of Christ the way, are themselves still breaking their vows; trying to enjoy benefits outside of the vocation, then maybe George R. R. Martin was right after all.</p><blockquote>“Words are Wind.”</blockquote><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=bb5d2378a1c9" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[BARBERSHOP]]></title>
            <link>https://giovanniberchmans29.medium.com/barbershop-727b1c8e15e7?source=rss-607970840e99------2</link>
            <guid isPermaLink="false">https://medium.com/p/727b1c8e15e7</guid>
            <category><![CDATA[barbershop]]></category>
            <category><![CDATA[fiction-writing]]></category>
            <category><![CDATA[lifestyle]]></category>
            <dc:creator><![CDATA[Chidiuto Okorie]]></dc:creator>
            <pubDate>Sat, 02 Apr 2022 19:39:54 GMT</pubDate>
            <atom:updated>2022-04-02T19:41:26.472Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/480/1*Hp0bFQyBJSJ52mC4k4BpCg.jpeg" /></figure><p>My barbers always think I betray them by going to other barbers. That’s partly true, since I never really had one barber, save my friend Fidelis who got into the business and got really good at it. And that happens only when I’m around his place.</p><p>That aside, I visit a barbershop an average of once a year (twice, on good years), thanks to my hair whose growth rate would make a snail feel like The Flash. When I go, it’s one of three things;</p><ul><li>I rarely remember the last one I went to,</li><li>I simply don’t want to go back because they ruined my hairline (more than it already is ruined) the last time, or…</li><li>I’ve changed location and can’t access the last place.</li></ul><p>So when I return to a barber I’ve cut my hair with before, they think I’ve betrayed them.</p><p>On this particular day, this “gentleman ” reminded me one of the other reasons I don’t like going to barbershops. He started a conversation.</p><p>Now, around my friends, I’m a blabbermouth, but around strangers, I’m socially awkward and can only exchange formal sentences; business only, and we go our separate ways.</p><p>“Boy, you dey live for this area?” he asked.</p><p>“Yeah. Anything?”</p><p>“I never see your face for here before. You dey go barb for another side?”</p><p>Holy Lord! Not today? I was in no mood for chit chat, so I didn’t respond.</p><p>“Everybody know me for this area naa. If you don come this salon, you suppose know me. You no know me?”</p><p>I replied icily, “No.” But that didn’t discourage him from continuing. He started sterilising his clipper, as I tried to decide what hairstyle to go for. Did it really matter? He’d ruin it anyway. They always do.</p><p>“Boy you dey travel?”</p><p>Holy hell! I wasn’t going to catch a break.</p><p>“Yeah.” “When?” he asked again.</p><p>“I never know.” I did know; I was to travel that day. At this point, he was done sterilising, and I drew an imaginary line around my head with my fingers, indicating I wanted a round-cut afro, or whatever it was called. He understood.</p><p>Clint — I didn’t get his real name, but I will call him this so I don’t have to keep saying “The barber” — proceeded to tell me how he was “hustling”. Apparently, that’s what they’re calling it these days. He complained about how he’d been “pressing&quot; and “client never show love.”</p><p>Clint was mad at his close friend who recently “picked” would neither give him update, nor tell him anything besides “na grace.”</p><p>I kept muttering “Ha! Nawa oo,” “mad, mad, mad!” and even completing his sentences at intervals, all the while praying he didn’t notice my disinterest and ruin my hair intentionally — it seemed to be taking good shape thus far.</p><p>Much of the rest of the (one-sided) conversation was him talking about people owing him money and how they tried to run with it. At some point, he mentioned that the cost of a haircut was now ₦1000, thinking I’d take the bait. I smiled and kept monitoring the state of my hair.</p><p>Clint’s next attempt was him laughing at another guy in the shop for being a virgin. He turned to me and said, “You na boss naa. Shey you don straff?”</p><p>I smiled again.</p><p>“Ah, you never straff? You dey miss oo.” He was on my hairline now, so I was trying to remain focused.</p><p>“Taaa! You wey I dey see everyday dey carry woman. This one na oga!”</p><p>Frankly, I was tired, so I fizzled out and drowned in my own thoughts. The barbershop was always a place of relief for men. They talked about all the things men traditionally loved; football, drinks, business, and most importantly, booty! They talked about depression and hardships. Friendships were formed and quarrels were settled there. Like a bar, but the only alcohol here was used to sterilise equipment.</p><p>At the end of the session, you would leave with a good carve and a light heart. I wondered if I’d ever fit in such conversations. Or maybe it was a good thing I didn’t.</p><p>Who knows? Time will tell.</p><p>He signalled to my jaw, meaning he wanted to shave my beard/moustache and was seeking permission. I looked at the scanty shrubs there that gave me a bit of bragging right and something to pull, albeit lightly, when in deep thought. I wasn’t ready to lose it, so I shook my head.</p><p>When I all was done and the traditional spirit spray had come and gone with its little sting, I pulled a ₦1000 note from my pocket and gave it to Clint.</p><p>“Boss, see as your hair fine. You go leave am for me?”</p><p>The hair did indeed come out well — better than I’d thought it would, in any case. However, we were looking at the last money I had to my name in the world. I was not going to leave it. I spoke my first real words since I walked into the salon.</p><p>“Oga, you do well, but na who hold bar dey show love. No vex, next time.”</p><p>Considering my whore-like barber habits, there would probably not be a next time. He didn’t know that, so he smiled and gave me back my change. I left the barbershop with a good carve, but my heart remained unchanged.</p><blockquote>This was my excuse for a first medium post in a while. I hope it was worth it. What are your salon experiences? Care to share?</blockquote><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=727b1c8e15e7" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[The Physicist]]></title>
            <link>https://giovanniberchmans29.medium.com/the-physicist-3318618c4deb?source=rss-607970840e99------2</link>
            <guid isPermaLink="false">https://medium.com/p/3318618c4deb</guid>
            <dc:creator><![CDATA[Chidiuto Okorie]]></dc:creator>
            <pubDate>Tue, 23 Nov 2021 09:38:16 GMT</pubDate>
            <atom:updated>2021-11-26T15:11:36.166Z</atom:updated>
            <content:encoded><![CDATA[<blockquote>“There are things so serious we can only joke about them.” — The Physicist</blockquote><p>After a long day of trying to commune with the universe; answer its question of state and solve its problems, our dear old physicist decides to call it a day. He takes a walk to the other end of his lab, ignoring the other attendants as he walked past — such idiots, bearing gnat-sized brains. He’s silent enough to get past Gerd, the little kid who just joined and was always trying to get him to look at his work.</p><p>This physicist gets to the other end of the lab undetected, takes off his lab coat and replaces it with a dusty trench one, put on his hat and slips past the door in a series of quick, light fingered moves that would make a ninja jealous. Now, it’s just him, the cool evening breeze and his Model-T Ford with a broken speedometer. Who cares anyway? There’s a lot of important problems in the universe left to solve. He really never bothered how fast he was going, so long as he knew where he was.</p><p>He gets into his car, ignites it and the very sound gives him joy, as he steers it out through the mud into the decent streets of Munich, enjoying the breeze and the scenery that came with it. Barely 20 minutes into the joyride, our physicist gets a shout from the Polizei (Police), ordering him to pull over.</p><p>“What could these morons want now? Interrupting a man trying to escape all unpleasantness.” He pulls over anyway, but with a stern look on his face.</p><p>“Sir, you’re driving too fast, I trust you know that,” said the first polizei as he came from behind.</p><p>“Well as you can see, my speedometer is broken,” he snapped back.</p><p>“Sir, I see from your ID that you are a well-respected scientist. I do not wish to make this night any longer than it already is. You were driving at 35 mph; well over the 20mph limit. Fix your speedometer and get your brick brain off my roads,” bellowed the second officer.</p><p>This man was clearly the superior and the physicist, proud as he was, wanted no further problems. He breathed his anger out and drove off.</p><p>“35 miles per hour,” he murmured, mimicking the polizei, “I don’t understand how I manage to be surrounded by fools all…” the ford came to a sudden halt. Our physicist looked around and something was off. He had plied these roads a hundred times before, but now they looked strange. He tried to look around for landmarks, but couldn’t find any. Then something even stranger happened; he noticed his speedometer was working again.</p><p>After hours of trying to find his way back, the sudden rain that had him drenched, he found one whom he thought looked like a fellow intellectual. Our physicist alighted, stepped through the mud and went to tap on the stranger’s shoulder; who then looked at him, blank-faced from a bench. The physicist said, “Hallo! My name is Werner Heisenberg, and I think I’m lost. Where is this place?”</p><blockquote>“Not only is the Universe stranger than we think, it is stranger than we can think.” — Werner Heisenberg (The Physicist)</blockquote><p>Edit: It would appear this one is harder to grasp than I thought, so I’ll give a hint:</p><h4>Look up “Heisenberg’s Uncertainty Principle”</h4><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=3318618c4deb" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[HNG 8: GOALS!!!]]></title>
            <link>https://giovanniberchmans29.medium.com/hng-8-goals-39fadbe2aded?source=rss-607970840e99------2</link>
            <guid isPermaLink="false">https://medium.com/p/39fadbe2aded</guid>
            <dc:creator><![CDATA[Chidiuto Okorie]]></dc:creator>
            <pubDate>Tue, 17 Aug 2021 12:28:08 GMT</pubDate>
            <atom:updated>2021-08-17T12:28:08.011Z</atom:updated>
            <content:encoded><![CDATA[<p>It was a major dilemma, deciding whether or not to register for HNG this year. “I mean, come on, man… you barely made it past <a href="http://internship.zuri.team/">Zuri</a> (Zuri, with i4G, organized a training, like a lighter version of HNG, which partook in. See link at the end), <a href="http://internship.zuri.team/">and</a> school hadn’t even resumed as of yet. Is this really what you want?”</p><p>However, I came to the conclusion that it was worth the shot and that I was going to give it my best. Since I was first introduced to programming, I’ve tried my hands on many different tracks; C++, Java, Html/CSS, R, Python, and most recently, Flutter. That’s a whole lot of tracks for less than 3 years of not mastering any. Shame on me.</p><p>In case you’re wondering, Flutter is a development kit used to develop cross-platform (Android and iOS) mobile apps using the Dart Language. If you’re interested, my favourite flutter tutor is Andrea (Code with Andrea, YouTube). Find the link to his channel at the end of this article.</p><p>Of all these, Flutter is the one where I’ve lasted the longest. So I decided, because of this, to take one last go at Programming and see how it goes. And I’m not just going to see how it goes. In HNG 8, I’m going to</p><ul><li>Test my ability to learn on the job</li><li>Meet deadlines</li><li>Work well in a team and contribute a useful quota</li><li>Have a tech internship experience</li><li>Finally get familiar with Github and it’s space. In case you have the same issue, I could share the tutorial I started with. Find the link at the end of the article.</li><li>And at the end of the training, I should be sure whether or not I mean to pursue a career in tech.</li></ul><p>Well, at this point I suppose I’ve mentioned all that is to be in this article… all except the promised links.</p><p>Code with Andrea on YouTube (Flutter) : <a href="https://youtu.be/zTvewUdNslo">https://youtu.be/zTvewUdNslo</a></p><p>Zuri Internship: https://internship.zuri.team</p><p>Github: https://youtu.be/RGOj5yH7evk</p><p>This ink belongs to Okorie Chidiuto.</p><p>Here we go!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=39fadbe2aded" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[IT DIARY: ENTRY 28]]></title>
            <link>https://giovanniberchmans29.medium.com/it-diary-entry-28-8b4ddf4a3a98?source=rss-607970840e99------2</link>
            <guid isPermaLink="false">https://medium.com/p/8b4ddf4a3a98</guid>
            <dc:creator><![CDATA[Chidiuto Okorie]]></dc:creator>
            <pubDate>Fri, 30 Jul 2021 06:27:43 GMT</pubDate>
            <atom:updated>2021-07-30T06:27:43.741Z</atom:updated>
            <content:encoded><![CDATA[<h4>THE LAST WATCH</h4><p>You know that saying that time is slow when you wait and fast when you’re late? It couldn’t be more true for my last week of internship. As fate would have it, my last week happened to be a night-shift week for me and it got kinda exciting knowing I’d end my internship with the rising sun.</p><p>My last day (or night) at work, I left home for the office, thinking of what surprises my final 16 hours as an intern held for me. I started to have subtle flashbacks of the past four and a half months of my life. I remembered very clearly the day I applied. I was searching out ISPs to send applications to while filling in my practical manual in school.</p><p>I remember getting the call for an interview only a few days later, which was weird to be since the last place I applied now became the first place I received feedback from. I remembered telling my friend P the news and her words being “You have an interview, this boy. What are you still doing in school?”</p><p>All the “How did you apply?”, “Are they still taking interns?”, “Where did you find the company?” questions I had to answer still ring in my head today. I remembered the interview and the successful message later on. Then the other interview with another company a few days later and how I respectfully declined and opted to continue where I already started after they offered me placement a week later.</p><p>I recalled how the days turned into weeks and weeks into months. My first field job with Mark, every moment of annoyance and regret, every joke and every moment of happiness. I remember most of all, the two times I had to be reprimanded. Boy am I a stubborn one?</p><p>All in all, it’s been an internship to remember. Maybe not quite as I imagined before I began, but hey! Lemons and lemonades, right?</p><p>Now after 16 long hours through the night, the Sun rises. My time here is over. I must return to school for my final Season in the Sun. It’s the end of my Lasgidi Intern Series. Although cut short by the rather unfortunate loss of my device (blessed be his memory), I had to at least sign out.</p><p>It’s been an honor, but now, like all things good or bad…</p><p>My watch has ended.</p><p>#MyInternshipDiary #LasgidiIntern</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=8b4ddf4a3a98" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[IT DIARY: ENTRY 27]]></title>
            <link>https://giovanniberchmans29.medium.com/it-diary-entry-27-bcad744f34a4?source=rss-607970840e99------2</link>
            <guid isPermaLink="false">https://medium.com/p/bcad744f34a4</guid>
            <dc:creator><![CDATA[Chidiuto Okorie]]></dc:creator>
            <pubDate>Mon, 26 Jul 2021 21:04:34 GMT</pubDate>
            <atom:updated>2021-07-30T04:52:41.252Z</atom:updated>
            <content:encoded><![CDATA[<h4><strong>COPORATE CULTURE OR CO-OPERATE CULTURE?</strong></h4><p>It would seem after every writing hiatus, I usually come back with the same phrase, “Oh, how I’ve missed you.” But I do not think it has been quite as serious as now. First off, this time it wasn’t an intentional absence and… you know what? Skip all that.</p><p>So what did bring me back to my diary? What happening was so big that I had to re-enter the scribe realm? Stay with me…</p><p>It’s been 2 weeks (or just a little longer) since I first got wind of the released academic calendar for school. I must say, I was quite psyched. Although I dare not admit those to the thousand and one classmates of mine who are having the time of their lives doing IT and would love to not resume till… when? August ending? Mid-September? I’m sorry, but I don’t think I can take it.</p><p>I’d be lying if I said I didn’t learn anything useful here during my internship. However, the most significant ones have been unrelated to the job. One of those has been the reason I almost never get angry. Apparently, I tend to go berserk when I do. I bring things that can almost never be fixed.</p><p>Another is, I’m really not ready for the corporate culture… or as I’ve found it to mean; “Co-operate culture”. It would appear everything a superior does is right, and I don’t get to have a side of the story. It would seem I need to learn to not have a reply to everything, and above all, it would seem saying a superior “yelled at me” is disrespectful to him/her, and a more courteous term would be “raised their voice at me”.</p><p>All this reminds me of a theory my favorite character Barney Stinson from “How I Met Your Mother” had. It was the circle of yelling… or was it the chain of yelling? The boss yells at the project manager, who yells at you, and you yell at your roommate who’s a kindergarten teacher. She yells at a kid in class, and the kid, who is your boss’ kid, yells at his dad, your boss.</p><p>No, diary… I’m not going to yell at anyone. Lol.</p><p>If you haven’t already guessed it, I got a stern admonishing from my supervisor for insubordination for the second time in my internship that’s already shorter than it should have been. Perhaps I’m lucky it was cut short. A third may not have ended so “not-so-lightly”. This is weird because I’ve never had such an experience in any of my former jobs or internships. Maybe I’ve just had it easy the entire time and this is just the universe’ way of showing me the flipside.</p><p>Whatever it is, it’s almost over. I’m counting down the days (or nights, since I’m on night duty), and Lord help me once I’m done with school. I hope I never again have to face Co-operate culture.</p><p>Till the next entry...</p><p>#MyInternshipDiary #LasgidiIntern</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=bcad744f34a4" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[IT DIARY: ENTRY 26]]></title>
            <link>https://giovanniberchmans29.medium.com/it-diary-entry-26-b18567531944?source=rss-607970840e99------2</link>
            <guid isPermaLink="false">https://medium.com/p/b18567531944</guid>
            <dc:creator><![CDATA[Chidiuto Okorie]]></dc:creator>
            <pubDate>Tue, 22 Jun 2021 17:18:23 GMT</pubDate>
            <atom:updated>2021-06-22T17:18:23.282Z</atom:updated>
            <content:encoded><![CDATA[<h3><strong>Fathers’ Day</strong></h3><p>Everyday, it becomes increasingly difficult to hold oneself back from giving sassy replies to those superiors who keep asking annoying questions and making annoying remarks; especially when they do it daily. It is even more so when you have those sassy replies in abundance popping up in your head. *sigh</p><p>“What is your name?”</p><p>“Emmanuel,” I sighed, knowing that’s not what he expected to hear.</p><p>“No, no, your other name…”</p><p>“Chidiuto”</p><p>“No,” he quickly cut in with all the excitement of a 5-year-old, “It is Chukwu-diuto. I’ve told you so many times, give me your father’s number so I can call him and tell him he gave you the wrong name. Chi can mean any god but Chukwu is the one true God we serve.” I’d heard this speech so many times I mumbled it flawlessly as he was reciting the words. It almost sounded like a broken record.</p><p>“Perhaps when you have another child or a grandchild, sir, you can give him this name ‘Chukwudiuto’ so you can stop losing sleep over another man’s name” was the reply I had in mind, but all I did was give half a smile and increase my pace. It didn’t help me…</p><p>“Wait, I’ve told you to cut this hair before. I don’t like the way your hair is bushy,” he said, determined to ruin my mood that afternoon.</p><p><em>“Well, I don’t like how bald you are either, but you don’t see me complaining about that and asking you to grow some hair”, </em>but once again this was only in my head and I gave the remaining half smile in response.</p><p>“I’ll bring scissors tomorrow and cut this your hair,” was the last straw he pulled.</p><p>“I’d like to see you try,” I said this time, not knowing the words slipped my mouth. Luckily, I was out of earshot and I pretended not to hear him.</p><p>Walking away, I recalled having a similar encounter with a man in church who since he first saw me and thought I was a visiting Priest, has seized every opportunity to remind me I would make a good Reverend Father (or so he thinks). It was funny the first couple of times, but it’s grown less so since then.</p><p>“Give me your Father’s number so I call him. It’s not too late to send you to the seminary”. I looked at him, while trying to concentrate on the announcements being read by the catechist at the time.</p><p>I was going to say “Why not hold your peace and raise your kid to be that which you like so much about me, then send him to the seminary?”. However, I settled for, “It’s not my Father’s choice to make, sir”. I immediately regretted my politeness because he came back with a “No, no… It’s his choice, you’re still under him.”</p><p>It was at that moment I felt pity for his children, imagining the number of choices he’d force down their throats. I immediately started to appreciate one of my dad’s qualities; 98% of the time, he’s let us make our own choices. He rarely ever forced a choice down our throats and he let us make our own mistakes and grow.</p><p>Then I remembered it was Fathers’ day. I took out my phone and set a reminder. I’d call him immediately I got home.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b18567531944" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>