Apr 30, 2019 01:28 PM
Hi there, i’m new here. My question in a nutshell is if anyone has had success building out the equivalent of a School Information System (SIS) using Airtable. Read on for more detail.
My wife and i and a small team are founding a new school for children in our community. We’ll start K–2 this fall and—should our prayers be answers—we’ll add a grade level each year all the way to grade 12. To date, we’ve been building out and refining all of our core systems, and now we’re researching a significant decision that virtually all schools face: choosing a SIS.
There’s a million of these systems out there and they all seem to take a kind of everything-you’ll-ever-need-in-one-place approach. Our workflow, however, is heavily dependent on SAAS. We use G Suite (email and productivity), Asana (tasks/project management), HubSpot (donor management), PieSync (keeping contacts in sync), Calendly (appointment scheduler), Eventbrite (fundraisers), Aplos (bookkeeping), Zapier (to tie everything together as much as we can), and some other things too. The everything-under-one-roof approach boasted by most SISs doesn’t really appeal to us (i.e. we don’t want a cute little calendar, when Google Calendar is so much better; we don’t want a half-baked project manager, when Asana is so much better, and so on). Instead, our preference is to pick the best tools we can and then automate our processes with something like Zapier.
Here’s a list of the baked-in features offered by one of the most popular SISs, called FACTS (formerly RenWeb):
We most certainly don’t need all of that—especially as a small school startup—but we will need some of it (admissions, attendance, student tracking, grade books, report cards, etc.).
I would be extremely grateful to learn about the experiences of anyone working in a school environment who may be using Airtable to fulfill some (or many) of these functions.
Thanks in advance and thanks for reading!
May 01, 2019 09:03 AM
I’ve made my own, it has:
It was kind of hard to make, but it is really flexible!
May 01, 2019 09:17 AM
Whoa @Plinio_Averbach, that’s really really encouraging to read! If ever you decide/have time to describe your process in any more detail, i would be very eager to learn more! Really appreciate your feedback.
May 01, 2019 10:03 AM
My main problem describing is the language!
=)
It took me ~20 days working ~1 hour a day
Now my students recive a form and they put all their info (name, adress, etc.) My sales squad puts the values and Put in each classes they are in.
Zappier puts them on the mailing list and generate theyer certificate, a python program generate the calendar.
After they are in a class, we define the teachers from a dropdown and it is all set to go!
Oct 22, 2019 04:30 PM
Hi Stephen - just sent you an email. Would be grateful to see a copy of your setup as we are looking to do the same thing for our preschool (a more watered down version I’m sure) and I could use some inspiration!
May 24, 2020 01:49 PM
Hi did you manage to do this? I am from a small charity for disabled children but we support alot of kids and we are struggling to separate parent and child data successfully (especially where there is more than one child in the family)
May 26, 2020 02:34 PM
What is your base structure?
May 26, 2020 03:06 PM
If you are going to store any protected health information, you should be aware that Airtable is not HIPPA compliant.
.
Oct 04, 2020 08:55 PM
I’d love to see this too. Any one that could share a template that could generate all the CSV files I need to import SIS data to Canvas LMS that would be awesome. I’d pay !
Oct 15, 2020 11:31 AM
Hi @Plinio_Averbach ,
Can you plz give me a simple guide on how you did the following :