data otiscoeukyedu kasa Socialization eg students discussing a concept Tacit Tacit Externalization eg Creating a visual metaphor for a concept Explicit Tacit Combination eg Converting two data sets into a graph ID: 567271
Download Presentation The PPT/PDF document "Wrangling your" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Wrangling your
data
otis.coe.uky.edu
/
kasaSlide2
Socialization
e.g. students discussing a concept.
Tacit
Tacit
Externalization
e.g. Creating a visual metaphor for a concept
Explicit
Tacit
Combination
e.g. Converting two data sets into a graph
Explicit
Explicit
Internalization
Tacit
Explicit
e.g. Reading a paper about a concept/topicSlide3Slide4Slide5Slide6
Computational Thinking
Formulating problems in a way that enables us to use a computer and other tools to help solve them.
Logically organizing and analyzing data Representing data through abstractions such as models and simulations
Automating solutions through algorithmic thinking (a series of ordered steps) Identifying, analyzing, and implementing possible solutions with the goal of achieving the most efficient and effective combination of steps and resources Generalizing and transferring this problem solving process to a wide variety of problems Slide7
e.g. Grades and Test Scores
Using tech to “connect” the twoSlide8
A
B
C
F
4
26
7
2
1
3
104
80
32
3
2
47
127
110
42
1
8
19
46
48
Course Grades
Exam LevelsSlide9
A
B
C
F
4
26
7
2
1
3
104
80
32
3
2
47
127
110
42
1
8
19
46
48
Course Grades
Exam LevelsSlide10
A
B
C
F
4
26
7
2
1
3
104
80
32
3
2
47
127
110
42
1
8
19
46
48
70%
37%
17%
95%
Course Grades
Exam LevelsSlide11
ρ
= 0.93Slide12
ρ = 0.93Slide13
ρ
= 0.93Slide14
Student ID
K-PREP Score
1
N
2
P
3
A
4
D
5
P
Student ID
Course Grades
1
C
2
B
3
C
4
A
5
A
Two Data TableSlide15
A
B
C
Student ID
KPREP
Has Account
1
N
=VLOOKUP(A2,Sheet2!$A$2:$B$6,2,FALSE)
2
P
3
A
4
D
A
B
Student ID
Course Grade
1
A
2
B
3
B
Stitching together two sets of data w/ VLOOKUPSlide16Slide17Slide18