FLIPPED CLASSROOM ACTIVITY by Y KRISHNA BHARGAVI REMOTE

FLIPPED CLASSROOM ACTIVITY by Y. KRISHNA BHARGAVI REMOTE CENTRE: 1080 (GRIET- Hyd) IDP in Educational Technology, IIT Bombay

Table of Contents SECTION SLIDE # ABOUT ME 3 OUT-OF-CLASS SEGMENT 5 IN -CLASS SEGMENT 10 EVALUATION 19 IDP in Educational Technology, IIT Bombay 2

About Me I’m Y. Krishna Bhargavi working as Assistant Professor in the department of CSE, GRIET-Hyderabad. I’m having teaching experience of 5+ years. I’m designing flipped classroom activity for the topic INTRODUCTION TO SQL in DATABASE MANAGEMENT SYSTEMS. This topic comes under the domain of Computer Science and Allied. IDP in Educational Technology, IIT Bombay 3

Y. Krishna Bhargavi Introduction to SQL Database Management Systems CSE II Year UG students of CSE and IT Gokaraju Rangaraju Institute of Engineering and Technology, Hyderabad IDP in Educational Technology, IIT Bombay 4

Out-of-class Activity Design Learning Objectives of Out-of-Class Activity At the end of watching the videos, student should be able to § § § Choose appropriate domain types for attributes. [APPLY LEVEL] Classify the attributes of a relation under different integrity constraints. [UNDERSTAND LEVEL] Create the schema of a relation. [CREATE LEVEL] Key Concepts to be covered § § Introduction to SQL - platforms Domain Types in SQL CREATE TABLE Construct Integrity Constraints IDP in Educational Technology, IIT Bombay 5

Out-of-class Activity Design https: //www. youtube. com/watch? v=ay-bzel 4 Wj. Y Main Video Source URL License of Video Creative Commons Attribution license (reuse allowed) Mapping Concept to Video Source CONCEPT VIDEO SEGMENT DURATION (in min) Introduction to SQL platforms Video 1 – 00: 00 -7: 44 Domain Types in SQL Video 2 - 7: 45 - 12: 15 4. 30 CREATE TABLE Construct Video 3 - 12: 16 - 17: 15 4. 59 Video 4 - 17: 16 - 22: 48 5. 32 Video 5 - 22: 49 - 30: 27 7. 38 Video 6 - 30: 28 – 38: 10 7. 42 Integrity Constraints TOTAL DURATION 38. 5 min IDP in Educational Technology, IIT Bombay 6

Out-of-class Activity Design Aligning Assessment with Learning Objective 1 Learning Objective Assessment Strategy Choose appropriate domain types for attributes Create a table with appropriate domain types for the attributeseno, ename, salary Expected duration (in min) Additional Instructions (if any) 10 Watch Video 2 before answering this question IDP in Educational Technology, IIT Bombay 7

Out-of-class Activity Design Aligning Assessment with Learning Objective 2 Learning Objective Assessment Strategy Classify the attributes of a relation under different integrity constraints. How would you classify the types of constraints Expected duration (in min) 15 IDP in Educational Technology, IIT Bombay Additional Instructions (if any) Watch Video 4, 5 and 6 before answering this question 8

Out-of-class Activity Design Aligning Assessment with Learning Objective 3 Learning Objective Assessment Strategy Create the schema of a relation Create a table with appropriate domain types for the attributeseno, ename, salary with eno as primary key Expected duration (in min) 10 Additional Instructions (if any) Watch Video 2, 3, 4, 5 and 6 before answering this question Expected activity duration 35 min IDP in Educational Technology, IIT Bombay 9

In-class Activity Design -1 Learning Objectives of In - Class Activity At the end of the class, students will be able to, § § Solve problems involving creation of tables [ANALYZE LEVEL] Implement integrity constraints on attributes of relation. [ANALYZE LEVEL] Key Concepts to be covered § Use of constraints in creation of relations. § Implementation of create construct. IDP in Educational Technology, IIT Bombay 10

In-class Activity Design Active Learning activities Concept clarification using: § Peer Instruction Real world problem solving using: § Think-Pair-Share IDP in Educational Technology, IIT Bombay 11

In-class Activity Design Peer Instruction Strategy – What Teacher Does Pose the two PI questions at the start of the class and provide summary of basic identities and expression simplification. Q 1: Primary Key constraint ensures that primary key values a) are repeated across tuples b) are not null 1. True, True 2. True, False 3. False, True 4. False, False IDP in Educational Technology, IIT Bombay 12

In-class Activity Design Peer Instruction Strategy – What Teacher Does Q 2: Foreign key constraint can be implemented on primary key of same table or primary key of another table. a) True b) False IDP in Educational Technology, IIT Bombay 13

In-class Activity Design Peer Instruction Strategy – What Student Does § § § For each question they will first vote individually. Then they will discuss with peers and come to consensus. Listen to instructors explanation. IDP in Educational Technology, IIT Bombay 14

In-class Activity Design Think-Pair-Share Strategy – What Instructor does First provide a Query: Create tables with the following fields: Emp (Empid, ename, sal, mgrid, dno) Dept (Dno, dname) Consider empid and dno as primary key for emp and dept tables respectively. Apply foreign key on mgrid and dno in emp table. IDP in Educational Technology, IIT Bombay 15

In-class Activity Design Think-Pair-Share Strategy – What Instructor does Think (~2 minutes) Instruction: Assume the primary key constraints are applied on dno and empid. Think individually and identify the proper attributes to refer in order to apply the foreign key constraints. IDP in Educational Technology, IIT Bombay 16

In-class Activity Design Think-Pair-Share Strategy – What Instructor does Pair (~5 minutes) Instruction: Now pair up and compare your answers. Agree on one final answer. While students are pairing and discussing, instructor goes to 2 -3 sections to see what they are doing. IDP in Educational Technology, IIT Bombay 17

In-class Activity Design Think-Pair-Share Strategy – What Instructor does Share (~8 minutes) Instructor asks a group to share their answer with class and see whethere are different answers. After sharing is done, instructor gives feedback on the correct solution and how integrity constraints play a major role in real life applications, like Flipkart. IDP in Educational Technology, IIT Bombay 18

In-class Activity Design- Evaluation Reasons for being active learning strategies In both the above strategies, students are required to go beyond mere listening and execution of prescribed steps. They are required to think deeply about the content they were familiarized in out-of-class and do higher order thinking. There is also feedback provided through instructor summary. IDP in Educational Technology, IIT Bombay 19