Asked by john
Exercise Influential Women Response
5 points
Answer the following questions based on the previous activity:
Who are the women who have made significant contributions to the field of Science?
Who are the women on this list who were born after 1980?
Who on the list was a former US Supreme Court Justice?
Who is the youngest woman on the list?
What did you come up with to create a filter for on your own? What did you learn from it?
Based on what value did you decide to sort the spreadsheet? What did you learn from doing so?
Did you face any challenges throughout this activity? If so, what were they?
All Answers 1
Answered by
GPT-5 mini
AI
I don’t have your activity spreadsheet, so I can’t give exact answers yet. If you paste the list (names + columns like Field/Occupation and Birth Year) or upload the sheet, I’ll answer the five questions directly.
Meanwhile, here are quick, exact steps and a ready-to-fill template so you can get the answers yourself in Google Sheets or Excel — plus example filters/sorting and common challenges.
How to get each answer (step-by-step)
1) Who are the women who have made significant contributions to the field of Science?
- Filter the column that describes field/occupation (e.g., “Field” or “Occupation”) for entries containing “Science”, “Scientist”, “Biologist”, “Physicist”, “Chemist”, “Engineer”, “Computer Scientist”, etc.
- The filtered rows are the women in science.
2) Who are the women on this list who were born after 1980?
- Filter the “Birth Year” column (or “Date of Birth”) with condition Birth Year > 1980 (or DOB after 1/1/1981).
- The filtered rows are those born after 1980.
3) Who on the list was a former US Supreme Court Justice?
- Filter the “Occupation” column for “Supreme Court”, “Justice”, “US Supreme Court Justice”, or specific names (Ruth Bader Ginsburg, Sandra Day O’Connor, Sonia Sotomayor, Elena Kagan, Amy Coney Barrett — if included).
- If there’s a “Notes” or “Accomplishments” column you can search for “Supreme Court”.
4) Who is the youngest woman on the list?
- Sort the “Birth Year” column ascending to find the most recent year (or sort DOB descending to see the youngest first).
- The top row after sorting is the youngest — record her name and birth year.
5) What did you come up with to create a filter for on your own? What did you learn from it?
- Example filter ideas: “Country = United States”, “Field contains Science”, “Birth Year > 1980”, “Award = Nobel Prize”.
- What to report: which filter you made, why you chose it, and one or two things you observed (e.g., concentration of scientists from a certain country, many award winners clustered in certain decades).
6) Based on what value did you decide to sort the spreadsheet? What did you learn from doing so?
- Common sorts: Birth Year (to see age distribution), Field (to group by discipline), Country, or Date Added.
- Report which value you used and a finding (e.g., “Sorting by birth year showed most influential women on this list were born in mid-20th century; sorting by field revealed STEM was under/over-represented”).
Common challenges and how to fix them
- Inconsistent entries (e.g., “Biologist” vs “biology”): use consistent categories or add a helper column with standardized values.
- Missing birth years or DOBs: you can’t sort/filter reliably; look up missing dates or mark as “unknown” and exclude them for the sorting step.
- Multiple occupations: use keyword filters (contains “scientist”) or add separate columns for primary field.
- Date formats causing sort errors: ensure date cells are formatted as Date or Birth Year as Number.
Template answers you can paste back
- Women in Science: [paste names]
- Born after 1980: [paste names]
- Former US Supreme Court Justice: [name]
- Youngest on the list: [name — birth year]
- My custom filter: [describe filter] — What I learned: [one or two sentences]
- Sorting value used: [Birth Year / Field / Country] — What I learned: [one or two sentences]
- Challenges faced: [list them]
If you paste your list (or tell me the names and columns), I’ll fill in the exact answers for all six questions.
Meanwhile, here are quick, exact steps and a ready-to-fill template so you can get the answers yourself in Google Sheets or Excel — plus example filters/sorting and common challenges.
How to get each answer (step-by-step)
1) Who are the women who have made significant contributions to the field of Science?
- Filter the column that describes field/occupation (e.g., “Field” or “Occupation”) for entries containing “Science”, “Scientist”, “Biologist”, “Physicist”, “Chemist”, “Engineer”, “Computer Scientist”, etc.
- The filtered rows are the women in science.
2) Who are the women on this list who were born after 1980?
- Filter the “Birth Year” column (or “Date of Birth”) with condition Birth Year > 1980 (or DOB after 1/1/1981).
- The filtered rows are those born after 1980.
3) Who on the list was a former US Supreme Court Justice?
- Filter the “Occupation” column for “Supreme Court”, “Justice”, “US Supreme Court Justice”, or specific names (Ruth Bader Ginsburg, Sandra Day O’Connor, Sonia Sotomayor, Elena Kagan, Amy Coney Barrett — if included).
- If there’s a “Notes” or “Accomplishments” column you can search for “Supreme Court”.
4) Who is the youngest woman on the list?
- Sort the “Birth Year” column ascending to find the most recent year (or sort DOB descending to see the youngest first).
- The top row after sorting is the youngest — record her name and birth year.
5) What did you come up with to create a filter for on your own? What did you learn from it?
- Example filter ideas: “Country = United States”, “Field contains Science”, “Birth Year > 1980”, “Award = Nobel Prize”.
- What to report: which filter you made, why you chose it, and one or two things you observed (e.g., concentration of scientists from a certain country, many award winners clustered in certain decades).
6) Based on what value did you decide to sort the spreadsheet? What did you learn from doing so?
- Common sorts: Birth Year (to see age distribution), Field (to group by discipline), Country, or Date Added.
- Report which value you used and a finding (e.g., “Sorting by birth year showed most influential women on this list were born in mid-20th century; sorting by field revealed STEM was under/over-represented”).
Common challenges and how to fix them
- Inconsistent entries (e.g., “Biologist” vs “biology”): use consistent categories or add a helper column with standardized values.
- Missing birth years or DOBs: you can’t sort/filter reliably; look up missing dates or mark as “unknown” and exclude them for the sorting step.
- Multiple occupations: use keyword filters (contains “scientist”) or add separate columns for primary field.
- Date formats causing sort errors: ensure date cells are formatted as Date or Birth Year as Number.
Template answers you can paste back
- Women in Science: [paste names]
- Born after 1980: [paste names]
- Former US Supreme Court Justice: [name]
- Youngest on the list: [name — birth year]
- My custom filter: [describe filter] — What I learned: [one or two sentences]
- Sorting value used: [Birth Year / Field / Country] — What I learned: [one or two sentences]
- Challenges faced: [list them]
If you paste your list (or tell me the names and columns), I’ll fill in the exact answers for all six questions.
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.