1) Students will be able to create SQL queries to extract data that is useful to daily life a) Students will learn various syntax involved with SQL queries.
b) Explore various applications of SQL in fashion careers.
c) Discuss how spreadsheets can be used in marketing scenarios for product bundling.
● Compare tradeoffs associated with computing technologies that affect people’s everyday activities and career options (CA CCSS for CS 6-8.IC.20)
2) Given a data set, the learner will be able to create a visualization from a software of choice
a) After exploring the concepts of data and code, students will learn Tableau, Flourish, Google sheets, etc to create visualizations
b) Learners will articulate which visualizations are best for certain scenarios and why.
c) Once creating the visualization, students will begin to create hypotheses about the visualization’s meaning.
● Organize and present collected data visually to highlight relationships and support a claim (CA CCSS for CS 3-5.DA.8)
● Understand that statistics can be used to gain information about a population by examining a sample of the population; generalizations about a population from a sample are valid only if the sample is representative of that population.
Understand that random sampling tends to produce representative samples and support valid inferences (CA CCSS.MATH.CONTENT.7.SP.A.1)
3) While in front of an audience, pupil groups will be able to articulate the meaning of data and visualizations verbally.
a) Students will create a group presentation and articulate data meanings. b) Ideas will be formed and orally communicated.
● Collaborate with many contributors when creating a computational artifact (CA CCSS for CS 6-8.IC.22)
● Use data to highlight and/or propose relationships, predict outcomes, or communicate ideas (CA CCSS for CS 3-5.DA.9)
4) Class members will create a data science and computer science study plan with the computer science queen that serves as their mentor. This will lead to collaborative work in CS to problem solve. Bias will also be investigated.
a) Students will begin to articulate and come to terms with the idea of bias within the world of computing.
b) Through creating a team and mentorship, girls will start navigating the idea of thriving in STEM.
● Discuss issues of bias and accessibility in the design of existing technologies (CA CCSS for CS 6-8.IC.21)
● Seek and incorporate feedback from team members and users to refine a solution that meets user needs (CA CCSS for CS 6-8.AP.15)
5) Students will utilize technology to describe a phenomena of their choice, creating a project to describe the idea with data.
a) Students will utilize their coding skills and mastery of various technologies to design a data study from scratch.
b) Utilize knowledge of spreadsheets to transform data appropriately for the study’s focus.
c) Statistics can be incorporated by the student through various avenues. ● Alternatively, students could collect data from online forms and surveys, from a sensor, or by scraping a web page, and then transform the data to expose
relationships. They could highlight the distribution of data (e.g., words on a web page, readings from a sensor) by giving quantitative measures of center and variability. (CA CCSS for Mathematics 6.SP.5.c, 7.SP.4)
● Collect data using computational tools and transform the data to make it more useful. (CA CCSS for CS 6-8.DA.8)