If you spend a lot of time doing repetitive tasks with large data...
STOP!
We automate time consuming school tasks through the magic of code
If you spend a lot of time doing repetitive tasks with large data...
STOP!
We automate time consuming school tasks through the magic of code
See what's possible with these short demo videos:
Apps that School Administrators love:
The days of manually processing tardies are over. Automated processing, parent emails, summary reports, and printable notification slips. Check out the Case Studies (linked below) for how two of our clients have significantly reduced tardies.
($209/year, first semester free, no obligation)
Know where every student is on campus, block select groups of students from leaving class together at the same time, get alerts when students are out of class for too long, and protect instructional time with limited windows for approving passes during class.
Reestablish a culture of academic attendance with this Electronic Hall Passes application.
($899/year, first semester free, no obligation)
Period truancies -> Full day truancies -> Chronic absenteeism
To stop this progression, this application processes thousands of student records, identifies at-risk students early, automates parent communication and student notifications, and frees hours of staff time to connect with students and develop effective solutions to the root causes of their attendance challenges.
($209/year, first semester free, no obligation)
Not all tardies are created equal. First period arrival tardies are different from passing period tardies, and warrant different treatment. Tracking the root causes behind each student's tardies, and providing more appropriate interventions based on those root causes, can more effectively reduce tardies. Managing these data points has never been easier than with this targeted Tardies application.
($99/year, first semester free, no obligation)
Automated parent emails and powerful analytical tools to proactively identify students with the greatest need for support. Catch and address low-level behaviors before they escalate into preventable high-level incidents.
($239/year, first semester free, no obligation)
Getting students involved on campus can effectively reduce chronic absenteeism and improve academic outcomes. Building a school culture of involvement is challenging - this activities scanning and tracking application can help.
($189/year, first semester free, no obligation)
Sending custom informational emails, scannable event registrations with QR codes, and more has never been easier than with Mail Merge Made Easy.
($30/year, first semester free, no obligation)
Apps that Classroom Teachers love:
Thinking Classrooms offer promising opportunities for student learning, but also present logistical challenges with taking attendance, cell phone distractions, visibly random groups, and tracking hall passes. This application streamlines these tasks so teachers can focus on what they do best - supporting students in thinking and learning.
($10/user/year, site license is also available)
Building and sustaining positive working relationships is crucial. Save time with this fully customizable check-in form that sends automated personalized email responses to every student. Change the questions and reuse the form as often as you want.
($10/user/year, site license is also available)
Getting to know students and providing custom feedback is important... and very time-consuming. Save time in sending personalized automated emails through a get-to-know-you form, then easily provide custom assignment feedback to students all year long.
($10/user/year, site license is also available)
You do. During onboarding you will create copies of our template spreadsheets so you are the owner, then you give us editing permissions through Google Workspace to add our formulas and scripts. Once set up, you can remove our access completely so nobody outside of your school/district has access to confidential student data. At all times you are in full control of your spreadsheets and the data contained therein.
For security reasons, most district IT Directors do not allow third party access to their Student Information Systems. In these cases you will run reports from your SIS and import them into our applications. We teach you how to import your data - this short demo video shows how easy it is.
But if your IT Department is willing, we will work with them to create a channel from your SIS to our spreadsheets that updates your data automatically.
There is one Master Data spreadsheet with standard information about your students, such as names, ID numbers, classroom schedules, and parent email addresses. Each application pulls the specific data it needs from this Master Data spreadsheet, that way you only import this standard data once instead of importing into each separate application that you use. You will update this Master Data spreadsheet more frequently at the beginning of each semester when there are more new enrollments and schedule changes, but less often during the middle and end of each semester.
Each application has its own separate spreadsheet. For example, as often as you want to process tardies records, you will run a tardies report from your SIS then import that report into the Tardies application. Some applications, like Electronic Hall Passes or Student Involvement, use handheld scanners to input students’ IDs into the spreadsheets instead of running reports through your SIS.
This short demo video shows some scanner options. Handheld scanners are inexpensive and provide a fast way to enter students’ ID numbers into spreadsheets that collect data from students (like Electronic Hall Passes or Student Involvement) instead of through SIS reports (like Tardies or Period Truancies). If entry time is not an issue, then students can manually type their ID numbers instead.
We recommend a scanner model based on your needs, but you can purchase whichever scanners you want. Scanners are not included in the fee we charge for our applications.
Versatile: https://a.co/d/5tYdSFk ($35). Wired or wireless, QR codes or barcodes, instant or delayed upload, includes stand.
Basic: https://a.co/d/0AzQrKG ($24). Wired to computer via USB, QR codes or barcodes.
Be informed when shopping for scanners. Less expensive models may not scan your particular encoding protocol, or may scan only barcodes (1D) but not QR codes (2D), among other differences. Look for free returns so you can exchange the scanner for a different model if it cannot read your particular barcodes.
A free basic Google Workspace account is sufficient for applications that merely process data. For our applications that also send emails, such as parent notification emails for student tardies, we can disable the email functionality and instead generate a Microsoft Excel file containing the contents of each email to be sent, then you can use your Microsoft email client to send the Mail Merge emails from the Excel file.
Each subscription application comes with a free trial for one semester. With no upfront expense, we work with you to create the data pulls from your SIS, teach you how to use each application, and provide customizations to meet your unique needs. If you like the application, pay the annual subscription fee to retain use of the scripts, with no large up-front purchase costs and no long term contracts. Ongoing support is included in the annual subscription fee.
If you do not like an application, then keep or delete the spreadsheets, that’s up to you - we merely disable the scripts that process the data in each spreadsheet.
Our applications use data that is inputted from two sources: 1) reports from your Student Information System (SIS), and 2) from collecting students' ID numbers. These two short videos explain how it all works - how to import data from your SIS into our applications, and the various options for collecting student ID numbers with handheld scanners.
At the peak of the COVID-19 Omicron surge, quarantines stretched our school staff extremely thin. It was all-hands-on-deck as we prioritized only the most essential tasks to keep core operations afloat.
I learned that many of our time-consuming tasks could be automated with programmable spreadsheets, and that doing so would alleviate workloads for our already overloaded staff. I created automated seating charts that identified all students seated within "close contact" distance of a COVID-positive classmate, automated the COVID-19 flowchart with quarantine directives, and others.
After seeing some of these applications, staff members started enthusiastically asking:
"Can you also make spreadsheets do _________?!!"
And that's how Spreadsheets for Schools was born.
I love freeing staff from hours behind spreadsheets so they can spend their time with more meaningful student-facing tasks - like building relationships, understanding students' stories, and developing effective solutions.
In 10th grade a phenomenal math teacher inspired me to pursue a math teaching career. I began teaching in Ohio in 2004 then moved to Southern California in 2007.
Early in my career I experienced the power of programming on graphing calculators and in spreadsheets, both of which I used to enrich math lessons. In 2017 I started teaching computer science which fueled my interest in programming even further.
I love inspiring and empowering the next generation of talented student developers. And, it's a blast helping school staffs automate their work so they can spend more of their time making a difference directly with students.
Here is my résumé.