May 24, 2017 -- SienaSemanticsSurvey -- Code Breakdown -- Cell #11, #12, #13, #14, & #15

Cell #11
"Bar Graph for Career Interest in Science"

introduces and defines FSurveyParts --> this will take in certain columns from the data that is relevant to the topic of Career Interest in science from the surveys --> has to have student data columns explicitly stated to know which ones correspond to this topic as done in Cell #12

This cell incorporates the user's input of gender from the previous cell from the options "Boy", "Girl", or "All" and also outlines that if there was no selection choice, the code will default to gather "All" data

Based on the title of this cell, should a graph be generated?
_________________________________________________________________________________
Cell #12
"Bar Graph for Stem Semantics" -- 2014

This involves survey results from 2014 --> and based on the survey from this year, the corresponding data was found to be included in columns ranging from 8-33 but being Python starts from 0 are shifted to range from 7-32. From this the size of the vector can be determined using "vecSize=SemanticsS14Q.shape[1]"

Then, using this data from the 2014 Semantics Survey, the previously outlined table using the name, mean, and SEM, can be filled in accordingly using the FData function defined in Cell #9.

When run, this cell will generate the table where each of the questions asked is listed and its corresponding calculations of average and SEM of student responses are listed to 6-7 sig figs.
_________________________________________________________________________________
Cell #13
"Bar Graph for STEM Semantics" -- 2015

This involves survey results from 2015 --> and based on the survey from this year, the corresponding data was found to be included in columns ranging from 8-33 but being Python starts from 0 are shifted to range from 7-32. From this the size of the vector can be determined using "vecSize=SemanticsS15Q.shape[1]"

Then, using this data from the 2015 Semantics Survey, the previously outlined table using the name, mean, and SEM, can be filled in accordingly using the FData function defined in Cell #9.

When run, this cell will generate the table where each of the questions asked is listed and its corresponding calculations of average and SEM of student responses are listed to 6-7 sig figs.
_________________________________________________________________________________
Cell #14
"Bar Graph for STEM Semantics" -- 2016

This involves survey results from 2016 --> and based on the survey from this year, the corresponding data was found to be included in columns ranging from 5-30 but being Python starts from 0 are shifted to range from 4-29. From this the size of the vector can be determined using "vecSize=SemanticsS14Q.shape[1]"

Then, using this data from the 2016 Semantics Survey, the previously outlined table using the name, mean, and SEM, can be filled in accordingly using the FData function defined in Cell #9.

When run, this cell will generate the table where each of the questions asked is listed and its corresponding calculations of average and SEM of student responses are listed to 6-7 sig figs.
_________________________________________________________________________________
Cell #15
"Bar Graph for STEM Semantics" -- 2017

This involves survey results from 2017 --> and based on the survey from this year, the corresponding data was found to be included in columns ranging from 6-31 but being Python starts from 0 are shifted to range from 5-30. From this the size of the vector can be determined using "vecSize=SemanticsS14Q.shape[1]"

Then, using this data from the 2017 Semantics Survey, the previously outlined table using the name, mean, and SEM, can be filled in accordingly using the FData function defined in Cell #9.

When run, this cell will generate the table where each of the questions asked is listed and its corresponding calculations of average and SEM of student responses are listed to 6-7 sig figs.

Comments

Post a Comment

Popular posts from this blog

6/14/17 Notes

I want to write a code so that I can search the name of a class, and everyone who took that class will appear. Originally I assumed I could use the same command I did to search for a specific name, and then edit that so the code would search for a specific person. However, looking at the format of the file, there are four different columns that contain class information, while there’s only one column with name information. I am going to see if I can search for a specific class in the “Am S1” column first to see if everything runs smoothly, and if that works, I will look for ways to search for an ID word in multiple columns. I tried this command. Only the column headings are appearing and nothing else Studentinfo14[Studentinfo14['Am S1'].str.contains('Discovery', na=False)] I changed “Studentinfo14” to attendance so that the code would look for this information in the attendance file instead of the master file. This worked, but using this file means that I ca...
Read more

6/06/17 Notes (formatting code and searching for a specific person)

Working on fixing the format of the code, deleting cells, and making sure everything in an organized order to make it easier to use Earlier I was having a problem displaying the Confidence survey chart so I renamed all the columns and then it displayed. I now found that the command “ConfidenceS#.lock[:,:] also works, and is much more efficient because now I don’t have to go through each survey and copy and past the column names for every year of every survey. This works for all of them except Semantics, not sure why. I finished adding all the survey information I needed to merge all the surveys for 2014. I keep getting errors in the cells that deal with inverting numbered responses because certain column headers “don’t exist.” This means I actually will have to rename all the columns. However, for some reason this does not affect the cells that merge all the data. I successfully uploaded all the files onto the code and merged all the surveys and the attendance spreadsheet to...
Read more

May 22, 2017 -- SienaSemanticsSurvey -- Code Breakdown -- Cell #8

Image
Information on Counter Counter: container that keeps track of how many times equivalent values are added. ScountsS14=coll.Counter(SemanticsS14.iloc[:,3])                                            ^ locates each student's data, but pulls out the 4th column (name of school)                       ^creates a collection of how many times student's listed the same school labels = list(set(SemanticsS14.iloc[:,3])                       ^ removes duplicates                 ^ creates a list n = len(labels)         ^ gives the length of the list found above                   ^ becomes representative of size which will be used below to distribute pieces of pie...
Read more