A computer program for performing data analysis on the effects of racial and ethnic match on mentor-mentee relationships in the Big Brother/Big Sister organization. Done in support of Jennifer Koide's PhD research thesis "Effects of Ethnic–Racial (Mis)Match on Strength of Mentorship Relationships."
This program mines data from Big Brother/Big Sister surveys to compare the survey scores between the baseline and a target interval of interest. From this data mining, the program also compares the racial and ethnic identities of the big sibling to the little sibling to determine if there is a racial/ethnic match or not.
-
Order a SOR (Strength of Relationship) data sheet first by "Match ID" alphabetically and then by Completion Date (from earliest date to latest)
-
Order a Match History Detail data sheet by "Match ID" alphabetically.
-
Run the program in a R notebook. You will be prompted several separate times:
First, to enter the pathway of the SOR file:
Second, to enter the pathway of the Match History file:
Lastly, to enter the time interval of interest for comparison of survey scores to the baseline (+/- a user-stated deviation):
Afterwards, your work is done! The program will now sift through the data to produce CSV files (one for the big, one for the little) of all cases with completed surveys at both the baseline and the target time interval, along with whether or not a racial or ethnic match occured in each case.