Nsonye Capstone Project: Julia E-Library

Nsonye - Bridging the Tech Gender-gap is dedicated to bridge the technology gap for women and the girl-child, by engaging participants in community and upskill programs such as product management, data analysis, web development, and host of others.

I was accepted into the Nsonye cohort 3, to train as a data analyst. At the end of the training, participants were shared into teams comprising of data analysts, product designers, project managers, and web developers to build an E-library to aid those transitioning into tech. As one of the data analysts in the team, we were responsible for carrying out customer survey and analysis of responses. We drafted the questionnaire for the survey using the Google form and sent out to 18 persons and got responses from 16 persons.

Kindly find link to the instruction, Google form for survey and the presentation slide linkon my Github.

Steps carried out for the analysis:

I converted the response from the Google form to Google sheet and downloaded it as an .xlsx file. I used Microsoft excel for cleaning the dataset by focusing on the needed questions to be used in the analysis then analysed the questions separately.

Question 1: Have you had any experience with digital platform of the E-library?

The first question I analysed was the respondents experience with any digital platform of the library.

I created a worksheet for this question, copied the question to a column, the responses to rows, then copied and pasted the options from the Google form using the special paste transpose. I used the below formula to get my number of response for each option

=If(iserr(search(C$1, $B2)) “ ”, 1) and I got the below table

I copied and paste the options to an empty row, I also copied the total and paste transpose then converted it to a table. I analysed the responses using the pivot table, I picked responses for row label and sum of column for values.

And further analysed my data using the column chart

Question 2: Are there Platforms that makes it easier for you to access resources as a tech newbie?

I created a worksheet for this question, copied the question to a column, the responses to rows, then copied and pasted the options from the Google form using the special paste transpose. I used the below formula to get my number of response for each option

=If(iserr(search(C$1, $B2)) “ ”, 1)

I analysed the responses using the pivot table, I picked responses for row label and sum of column for values. I used the column chart for further analysis.

Question 3: How have you been getting your resources/materials for study?

I created a worksheet for this question, copied the question to a column, the responses to rows, then copied and pasted the options from the Google form using the special paste transpose. I used the below formula to get my number of response for each option

=If(iserr(search(C$1, $B2)) “ ”, 1)

I analysed the responses using the pivot table. I picked responses for row label and sum of column for values, then used % of grand total to get percentage for each option. I used the pie chart for further analysis.

Question 4: What were your challenges or problems in finding the right platform?

I created a worksheet for this question, copied the question to a column, the responses to rows, then copied and pasted the options from the Google form using the special paste transpose. I used the below formula to get my number of response for each option

=If(iserr(search(C$1, $B2)) “ ”, 1)

I analysed the responses using the pivot table. I picked responses for row label and sum of column for values. I used the column chart for further analysis.

Question 5: Kindly state if you are a newbie in Tech or you are transitioning into Tech?

I created a worksheet for this question, copied the question to a column, the responses to rows, then copied and pasted the options from the Google form using the special paste transpose. I used the below formula to get my number of response for each option

=If(iserr(search(C$1, $B2)) “ ”, 1)

I analysed the responses using the pivot table. I picked responses for row label and sum of column for values, then used % of grand total to get percentage for each option. I used the donut chart for further analysis.