Apps script Reading Logs system for educators to collect reading data from students

Google Sheets Tutorials · Intermediate ·📊 Data Analytics & Business Intelligence ·1y ago

About this lesson

@redtailfanschool In this video I share a new system I have developed that creates a student reading log for each student, then allows the teacher to pull the data from each student sheet back to a master sheet. The master sheet does some data analysis automatically for the teacher. This concept could be used to create student spreadsheets that then aggregate the student data back to the teacher master sheet. This is all done with 4 small apps scripts. I have made an additional video since this was made with some simplifications and some enhancements. https://youtu.be/YeQZNA_TPDI https://docs.google.com/document/d/1U_rN_RebHTzX_K5HMqbdMECL7f5A3Cgt-M-JeLY8nfo/edit?usp=sharing

Original Description

@redtailfanschool In this video I share a new system I have developed that creates a student reading log for each student, then allows the teacher to pull the data from each student sheet back to a master sheet. The master sheet does some data analysis automatically for the teacher. This concept could be used to create student spreadsheets that then aggregate the student data back to the teacher master sheet. This is all done with 4 small apps scripts. I have made an additional video since this was made with some simplifications and some enhancements. https://youtu.be/YeQZNA_TPDI https://docs.google.com/document/d/1U_rN_RebHTzX_K5HMqbdMECL7f5A3Cgt-M-JeLY8nfo/edit?usp=sharing

Watch on YouTube ↗ (saves to browser)

Sign in to unlock AI tutor explanation · ⚡30

Related Reads

Kevin O’Leary says data centres use less water than golf courses. The numbers are more complicated.

Kevin O'Leary claims data centres use less water than golf courses, but the numbers are more complicated, highlighting the need for nuanced analysis of water usage in different industries

The Next Web AI

A Bloomberg Terminal Costs $32,000 a Year. Here’s the Same Read, Free, in Five Minutes.

Access financial data without costly Bloomberg terminals, leveraging free alternatives for data analysis and interpretation

Medium · Data Science

Working With Real World Data: CSV, Excel, and JSON Files

Learn to handle real-world data in various formats like CSV, Excel, and JSON to work confidently with any given data

Working With Real World Data: CSV, Excel, and JSON Files

Learn to work with real-world data in various formats like CSV, Excel, and JSON to confidently handle diverse data sources

Medium · Machine Learning

This could be the most perfect data frontend