Reading .csv files

• 

  Option 1: Prints all data submitted to the google form

• 

  Options 2&3: Finds the oldest and youngest respondents, respectively

• 

  Options 4&5: Finds the most and least experienced respondents

• 

  Option 6: Searches for a respondent's name and returns their information

• 

  Option 7: Searches for respondents in a certain year and returns the names that match

• 

  Option 8: Searches for respondents who know a certain language and returns their names

Inspiration: For this hackathon, we wanted to create something that would help us in the future. As part of the Girls Who Code College Loop at UF, we are actually planning on hosting our own hackathon for members and anyone interested in learning. By participating, we were able to 1) gain insight into how hackathons work and 2) create a project that would help us with this plan.

What it does: Our project accepts a csv file that we create from responses to a Google Form. We plan on sending out this google form to our possible hackathon participants in order to understand them better. This includes their names, year of college, years of experience, programming languages they know, and any feedback they would like to give us. We then can use this file to see certain trends in our participants, such as the most experienced, the oldest, the kinds of languages our respondents know, and more. This way, we will have a better idea of who we are holding our hackathon for.

How we built it: To work on this together, we used Repl.it, which allowed us to make edits at the same time and run our project together. By using this, we bypassed the commands and specifics of GitHub, and were actually able to feel like we were on the same page 100% of the time. The basic outline of the program was this: read the file, create objects for each person's response, and find the data we needed.

Challenges we ran into: One big challenge we had was with the csv file itself. By using Google Forms, we were forced to adhere to the format that was given and had to grapple with delimiters and file streams. However, in the end, we were able to get the information we needed in an organized fashion. Additionally, we had trouble with the format of char arrays and had to use an external debugger to eventually solve the problem.

Accomplishments that we're proud of: We are proud of our problem-solving skills, considering we wanted a way to work together but had very little experience with GitHub. Therefore, when we found Repl.it, we were very happy with it. Also, we are proud of how well we worked together and got to finish the project fairly quickly.

What we learned: We especially learned how we can use Google Forms in a deeper way for our own purposes. By creating this project, we will be able to analyze responses from our organization's members in a much better fashion, thus making us more efficient and conscientious altogether.

What's next for reading .csv files: We will most likely be using this project when we host our own hackathon.

Built With

• c++