Change display time — Currently: Eastern Daylight Time (EDT) (Event time)

Working With and Protecting Original Data for Students and Teachers

,
Pennsylvania Convention Center, Terrace Ballroom Lobby, Table 26

Participate and share: Poster

Save to My Favorites

Presenters

Dr. Amy Arsiwala

Supervisor Of Instructional Technology

Franklin Township Board of Ed
@amy_arsiwala

Dr. Amy Arsiwala is the Supervisor of Instructional Technology for Franklin Township Public Schools. She also Adjuncts at Drew U. She is a former instructional technology coach, special education teacher and the Middle School STEAM coordinator. She is an advocate for students with special needs and is the Assistive Technology Evaluator for the district. She is a member of NJCart. Areas of expertise, Instructional Design, Special Education, Chromebook Management, STEAM & Technology Integration.

Hussian Arsiwala

Franklin Township BOE

Mariya Arsiwala

Franklin Township BOE

Zahra Arsiwala

Franklin Township BOE

Ted Samaras

Instructional Technology Coach

Franklin Township BOE
@ourtechcoach
@ted.samaras

Ted Samaras is an instructional technology coach (Franklin Township Public Schools, Somerset, NJ). He is also a Google for Education Certified Innovator (VIA20) and Trainer and Apple Coach. Ted is the host and creator of the “Ski Cap, Hoodie, and Shorts” podcast. He is also the creator of Recruit Helpers, a website and database providing student athletes information for college recruiting. He assisted in the development and implementation of various technology rollouts, including the district's 1:1 Chromebook initiative. He is a graduate of Rutgers University and also holds a Master's in Educational Technology from New Jersey City University.

Session description

With all the data that we collect today, it's important to know how to manipulate it without corrupting the original data. In this session, we will show how our students, teachers and coaches do this with Query, Important Range and VLookup in Google Sheets.

Purpose & objective

Participants will be able to begin to understand how important it is to preserve the original data collected before using and manipulating it. They will learn about different techniques and formulas to pull data from a source sheet including Query, ImportRange, and VLookup. Modeling will also be done regarding how to set up sheets ahead of time for students and also how to help students understand the importance of data and how to use it. Examples of some of the work we have done with students and staff members will be available prior to, during, and after the session on Ted's website www.ourtechcoach.com. Users will find resources not only for this session, but for other global projects that the team has worked on with educators around the world. Success will be determined by feedback surveys and anecdotal notes from conversation during the session.

More [+]

Outline

Based on the timing of a 90 minute in person Poster session (can be adjusted)
Example presentation and modeling from student, teacher, and coach work. (20 minutes)
Modeling and working - how to mini lesson on Query for participants to interacted with presenters and work on their own should they choose.. (15 minutes)
Modeling and working - how to mini lesson on Import Range for participants to interacted with presenters and work on their own should they choose. (15 minutes)
Modeling and working - how to mini lesson on VLookup for participants to interacted with presenters and work on their own should they choose. (15 minutes)
Open Q&A about any of the topics above or Google Sheets in general. (25 minutes)

More [+]

Supporting research

Creating Dynamic Crossword Puzzles in Google Sheets - Presented at SPARCC (OH) 2022- https://youtu.be/jEgYxDjCMPE
Chose Your Own Adventure with Google Sheets - Presented at SPARCC (OH) 2021 - https://youtu.be/9S4EvEhHR5E
Game Based Learning with Google Sheets - 5a Maraton Internacional (Mexico) https://www.youtube.com/watch?v=UOL-RBFqMSA
www.ourtechcoach.com
www.recruithelpers.com
Global Perspectives on Gameful and Playful Teaching & Learning By Dr. Matthew Farber
Instructional Coaching by Jim Knight
String Theory by David Foster Wallace
Where Good Things Come From by Steven Johnson
The Wild Card by Hope and Wade King

More [+]

Session specifications

Topic:

Professional learning

Skill level:

Beginner

Audience:

Coaches, Professional developers, Teachers

Attendee devices:

Devices useful

Attendee device specification:

Smartphone: Android, iOS, Windows
Laptop: Chromebook, Mac, PC
Tablet: Android, iOS, Windows

ISTE Standards:

For Coaches:
Data-Driven Decision-Maker

Support educators to interpret qualitative and quantitative data to inform their decisions and support individual student learning.

For Educators:
Collaborator

Collaborate and co-learn with students to discover and use new digital resources and diagnose and troubleshoot technology issues.

For Students:
Empowered Learner

Students use technology to seek feedback that informs and improves their practice and to demonstrate their learning in a variety of ways.

Working With and Protecting Original Data for Students and Teachers

, Pennsylvania Convention Center, Terrace Ballroom Lobby, Table 26

Presenters

Session description

Purpose & objective

Outline

Supporting research

Session specifications

People also viewed

,
Pennsylvania Convention Center, Terrace Ballroom Lobby, Table 26