Computer Assisted Reporting (CAR) has transformed journalism in Kenya by enabling reporters to analyse and interpret complex data sets to uncover stories that traditional reporting might miss. Central to CAR is the use of specialized software that helps journalists gather, manipulate, and visualise data efficiently. This chapter focuses on the various types of computer data exercises that digital journalists engage in, highlighting their relevance in producing accurate and impactful news stories in Kenya's dynamic media landscape.
In digital journalism, computer data exercises refer to the various methods and techniques used to handle data through software tools to extract meaningful information. These exercises form the foundation of CAR, empowering journalists to verify facts, identify trends, and present data-driven narratives. Kenyan journalists working with institutions such as county governments or financial institutions rely on these exercises to scrutinize budgets, expenditure reports, or public procurement data, ensuring transparency and accountability.
Data collection is the initial step in any computer-assisted reporting exercise, involving the gathering of raw data from diverse sources. In Kenya, journalists may collect data from government portals like the Kenya Open Data Initiative, public records at the Judiciary, or datasets from NGOs monitoring social issues.
Web Scraping: Automated extraction of data from websites, useful for collecting information such as public tenders or election results published online. For example, a journalist might scrape data from the Independent Electoral and Boundaries Commission (IEBC) website to analyse voting patterns.
Downloading Public Datasets: Many government agencies release datasets in formats such as CSV or Excel, which journalists can download for analysis. The Kenya National Bureau of Statistics (KNBS) provides demographic and economic data vital for investigative reporting.
Freedom of Information Requests: Journalists may request data not publicly available through formal channels, such as county budgets or procurement contracts from county governments.
APIs (Application Programming Interfaces): Some organisations provide APIs to access real-time or bulk data. For instance, the Central Bank of Kenya offers APIs for financial data that can be integrated into reporting tools.
Manual Data Entry: In cases where data is only available in hard copy, journalists may digitize information manually, though this is time-consuming and prone to error.
Raw data often contains errors, inconsistencies, or irrelevant information that can mislead analysis if not addressed. Data cleaning and preparation are essential to ensure accuracy and reliability before deeper examination.
Removing Duplicates: Duplicate entries can skew results, so eliminating repeated records is crucial. For example, in analysing public procurement data, repeated contract entries must be identified and removed.
Handling Missing Values: Missing data points may require imputation, removal, or flagging to maintain dataset integrity. Kenyan health data from county hospitals often has gaps that need careful treatment.
Standardizing Formats: Dates, currencies, and categorical variables must be consistent. For instance, financial figures should all be represented in Ksh for comparability.
Correcting Errors: Typos, misclassifications, or outliers must be detected and corrected. A journalist analysing educational performance data from schools may need to fix incorrectly recorded exam scores.
Filtering Irrelevant Data: Removing columns or rows not pertinent to the investigation streamlines the dataset for focused analysis.
After cleaning, data is subjected to various analytical techniques to uncover patterns, relationships, and insights that advance the story. Kenyan journalists utilising data from institutions like the National Hospital Insurance Fund (NHIF) apply these techniques to investigate fund utilisation or fraud.
Sorting and Filtering: Organising data by specific criteria, such as sorting counties by budget allocation, helps prioritise areas of interest.
Statistical Summaries: Calculating means, medians, or frequencies reveals central tendencies and distributions, critical for understanding phenomena like unemployment rates.
Cross-Tabulation: Comparing two or more variables, such as education level versus income, to identify correlations.
Trend Analysis: Examining data over time to detect increases or decreases, such as tracking crime statistics across Nairobi over several years.
Data Aggregation: Summarising detailed data into higher-level categories, for example, aggregating health expenditure by region.
Presenting data in visual formats enhances comprehension and engagement with the audience. Effective visualisation is a vital skill for digital journalists to communicate complex findings clearly.
Charts and Graphs: Bar charts, line graphs, and pie charts are used extensively to depict comparisons and trends. A journalist reporting on county revenue collection might use bar charts to compare performance across counties.
Maps: Geographic visualisation, such as heat maps or choropleth maps, helps illustrate spatial patterns. For example, reporting on drought-affected areas in Kenya benefits from mapping rainfall data.
Infographics: Combining visuals and text to summarise key points allows for easy consumption, especially on social media platforms.
Dashboards: Interactive platforms that allow users to explore data dynamically, such as public expenditure dashboards created by civil society organisations.
Timelines: Visualising events or data points chronologically aids in storytelling, for instance, showing the progression of a corruption scandal.
Explain five methods of data collection used in computer assisted reporting and discuss how each method can be applied in Kenyan digital journalism. (10 marks)
Describe the importance of data cleaning in CAR and identify five common data cleaning activities with examples relevant to Kenyan public sector data. (10 marks)
Outline five data analysis techniques used in computer assisted reporting and explain their significance in uncovering stories. Provide examples from the healthcare or education sector in Kenya. (10 marks)
Discuss five types of data visualisation tools and how they improve the presentation of data-driven stories in Kenyan digital journalism. (10 marks)
Create a free account to open more of this chapter.
Free: practical guides, quick cards, workplace scenarios and more.
Create a free accountThis chapter explored various types of computer data exercises that form the foundation of computer assisted reporting, highlighting their role in organizing and analyzing information. It then defined quantitative data as numerical information that can be measured and statistically analyzed, followed by an explanation of qualitative data, which consists of descriptive and non-numerical details used to understand context and meaning. The chapter introduced statistical data analysis software, emphasizing tools that help process and interpret numerical datasets effectively. Attention was also given to data visualization software, which transforms complex data into graphical formats to enhance comprehension and communication. Finally, the chapter discussed data categorization as a critical step in organizing data into meaningful groups, facilitating easier analysis and reporting. These components collectively underpin the effective use of software in computer assisted reporting.