MORE EVENTS
Leadership
Exchange
Solutions
Summit
DigCit
Connect
Change display time — Currently: Mountain Daylight Time (MDT) (Event time)

Automate your Spreadsheet AND Your Data with Google Apps Script!

,
Colorado Convention Center, Bluebird Ballroom Lobby, Table 32

Participate and share: Poster
Save to My Favorites

Presenters

Photo
Digital Resource & Content Specialist
Ysleta ISD
@BuenrostroErick
Erick Buenrostro is a Google Certified Trainer and Cyber Security specialist working for the Ysleta ISD in El Paso, TX. Erick has worked in the Education field for the past 11 years, spear-heading projects such as the 1:1 device initiatives for students and teachers, district conferences, and the newly formed eSports initiative. Erick has a passion for learning and discovering the best ways to help improve student and teacher success.
Photo
Innovative Learning Specialist
I have been an educator for 31 years, spending the last 11 at the district level as a Technology Integration Specialist. I am a Minecraft™ Ambassador, a Microsoft™ Education Expert, a Google™ Certified Trainer and Coach, and an Apple™ Learning Coach. I love helping teachers to find innovative ways to use technology tools effectively in the classroom. I also love to code my spreadsheets with Google Apps Script. When I am away from the office, I love to drive with my husband to NMSU and watch my amazing and super handsome twin sons play in the NMSU Pride of New Mexico Band.

Session description

Google Apps Script can customize any spreadsheet in many ways! Come learn how using a few lines of script can transform your spreadsheet, and help you organize and group data better, and faster!

Purpose & objective

It is my goal that participants will walk away with a very clear understanding of how to add Google Apps Script to any spreadsheet to help automate and organize data very quickly. Anyone who is attending this session will be expected to take part in working right alongside the presenter. This session will not be a "sit and get" session, as there will be work time for participants to learn and experience how to add Google Apps Script to a spreadsheet correctly.

The presenter and co-presenter will walk around and facilitate by answering questions and troubleshooting issues that may come up as participants are working on their scripts. Each attendee will receive a digital step-by-step tutorial that will describe in detail every action the presenter will be modeling and demonstrating during the session. They will also leave with a script that can be put into practice right away.

My overall goal is that participants feel empowered and confident about using Google Apps Script to create new ways of organizing data, that will save time and effort for those needing to access data types for student success.

More [+]

Outline

This session will be completely hands-on, where attendees will be expected to complete the same tasks that the presenter will model for them. Participants will be given adequate work time, where they will be working on their own devices, and the presenter and co-presenter will facilitate and ensure that everyone is fully participating. The activities that will be covered are as follows:

1. What is Google Apps Script, and how do I access it?
2. How do I write Google Apps Script?
3. How do I test the script?
4. Are there places I can find other examples of script?
5. What data will I be using?
6. How do I get the script to read the correct data?
7. What does the data tell me?
8. How can this Data Draw help me group students faster?
9. How can I plan lessons based on this Data Draw?
10. Where can I get additional information if I need it?

Any other questions or issues will be answered and addressed as they come up during the session. Attendees will be given the presenter's contact information, if there is more support or information needed.

More [+]

Supporting research

The following article describes what data-driven instruction actually is, and some tips for utilizing it in the classroom. Data-driven instruction is one of the pillars of the Blended Learning pedagogy, which is based on personalized learning opportunities for students.
https://otus.com/guides/data-driven-instruction/

More [+]

Session specifications

Topic:
Computer science & computational thinking
Grade level:
PK-12
Skill level:
Beginner
Audience:
Coaches, Teachers, Technology coordinators/facilitators
Attendee devices:
Devices required
Attendee device specification:
Laptop: Chromebook, Mac, PC
Participant accounts, software and other materials:
Attendees must have a Google account so that they will have access to the extensions within Google Sheets. We will be using the Google Apps Script extension within the spreadsheet to create a program to read the data.
Subject area:
Computer science
ISTE Standards:
For Coaches:
Data-Driven Decision-Maker
  • Assist educators and leaders in securely collecting and analyzing student data.
For Education Leaders:
Empowering Leader
  • Inspire a culture of innovation and collaboration that allows the time and space to explore and experiment with digital tools.
For Educators:
Designer
  • Use technology to create, adapt and personalize learning experiences that foster independent learning and accommodate learner differences and needs.