How to Build Apps for Education [No Code]

– [Eddie] Hello, this
is Eddie from AppSheet here to help you create your own suite of custom applications for
managing your classrooms, school or university all
without a single line of code. Today, we’re gonna start with two things. We’re gonna give you a quick background on AppSheet and education, and then we are going to have a demo of a quick, simple student directory app. So the first thing to know is
that AppSheet does education. We know what we’re talking about. AppSheet is in use by reading
organizations like Harvard, Dartmouth, University of
Virginia, University of Michigan, and public school districts
around the country. The Harvard Business Review
has actually even featured us in one of their posts
talking about how AppSheet has helped to transform what
they do with Google Sheets, and their directory systems. Second thing to note is that if you are a education provider, do not miss out on our 50% discount for educators and non profits. We’d love to support what you’re doing. You’ll find the link in the
YouTube description section. And the final thing to note is
that AppSheet is a platform. So rather than offering a single use app or even multiple apps, we have a platform to allow you to build your own customizable apps
without code to meet the needs that you have on the ground every day. So AppSheet is a platform that connects with your existing
cloud base data sources, which is helpful because then
your data is no longer siloed, but rather you can maintain
your single source of truth but whether that’s on
Google Sheets, or Drop Box, or SQL Server, or other
common data sources. AppSheet can also scale
with you as you grow, so whether you’re just using
a couple hundred rows of data, or you’re using a couple
million rows of data, AppSheet can handle that. Another thing to note is that
AppSheet is platform agnostic, which means that we actually don’t care where your data’s coming from. We’ll help you make the most of it. So whether you’re using something like Google Sheets to
build a really simple app, which is what we’ll be doing today, or you’re using a system
like Sales Force or SQL, we can also help you
maximize those platforms, which often times allow you
to use even larger data sets. So a common question we get
is what kind of applications do people actually build
and use on AppSheet? In the education section
what we’ve often seen is educators using us for
things like assignments, and activity scheduling
and contact directories. There are also schools and districts which use us for managing
grades and meal planing. We’ve also heard of administrators who use AppSheet to build
their own flash card systems to remember students’ names. And at the university level, we’ve also seen a lot of
unique niche use cases for AppSheet in things like lab testing, library management, and
waste management coordination just to name a few. One analogy I like to use for AppSheet is that it’s a little like
learning to play the piano. Everyone starts with learning
a couple chords and scales, but once you’ve mastered the basics, that allows you basically
unlimited possibilities to build anything from
any common data source, leveraging all of our
functionality and feature sets. From here, let’s go ahead and get started. I’m going to head over to Google sheet, and I’m going to go ahead and type in a set of column averages. Our first row is very important, because this is how we detect the equivalent fields for our app. I’m gonna go ahead and fast forward to get the data in here. Now you can see we have
our high school classroom with professional athletes
from around the world. Now to get started, let’s go ahead and head back to AppSheet, and go to start for free. If we’re a first time user it’ll walk us through the
short sign in process, but for me we’ll go ahead and
jump here to new mobile App. We’ll start with our own data. We’ll call this data Superstar
High School Directory. And we’re going to have
this be a education App, and we’ll choose our data source, called the student directory. Now here you can see we’ve just created our first App with AppSheet. And AppSheet is directly pulling the data and displaying it in a
mobile-friendly format. What we can see is that even our image, which is drawing from these URLs is now being expressed
visually in our app. If we click into any of our individuals, you can see the same data is reflected inside the app as well. One thing to note too is that the AppSheet App and your spreadsheet are both totally connected. So if you were to change
Danica Patrick’s GPA from 3.4 to 3.52, and we save that, then that change will now be
reflected in our Google Sheet. Your AppSheet App is
also off-line compatible, so if we’re in a location that
does not have access to WiFi, you can simply save your
changes on your local device, and when you reach WiFi,
your App will automatically connect and seek your data as appropriate. So to get under the hood and
understand what’s going on, let’s head over to our data tab. Here we can see we have our
one student directory database. And let’s go ahead and make
sure we allow Adds and Deletes. And that just insures that we
can add new data from our app into our spreadsheet if we’re
trying to add a new record. Let’s also head over to columns, and you can see that here we have our various columns expressed. Now, AppSheet has already
identified what most of these are, but in case we want to
change some of these, we can do so here. And we can also create slices. For instance, if we wanted a sub-set of our data on how to
represent the Dean’s List. We’ll call it Dean’s List and we’ll make use of
this AppSheet expression. An expression is a lot
like a Google Sheet formula or Excel formula, and we’ll simply say her GPA
is greater than 3.499999, and that person would
be on the Dean’s List. So we’ll save that, now let’s
head over to our UX section. In our UX section, you
can see that we have our Student Directory tab
that we’re in right now. And we’re in a deck view, we can change that to a
table view if we wanted, or a detail view. But I actually prefer for this particular data set a gallery view. We can see that we have all
of our 10 outstanding students visually represented here. We could also change the
icon if we wanted to, let’s turn this into a person. We can also change to our other view. So here, we have our
Student Directory One view, and let’s turn this into a form. Now what this does is
it allows us to enter in a new student on the go. We can also see above that
we have our Dean’s List view which isn’t reflected
yet, but we can go ahead and add a gallery view
for Dean’s List as well. Our Dean’s List only has six students because only six of them made a 3.5 count. But let’s change our
original one to New Student. Now our form is reflected
properly and if you scroll down we see that we have a Dean’s list. The Dean’s list right now
is in the Menu View section so we can see it here, but if we wanted we can change that to be in our main tab. So now we have three views reflected here, and let’s go ahead and make that a star. Let’s add an icon for
our Dean’s list as well. So here you can see we’ve
created three simple views. If we wanted to, we could
create up to five views in our bottom row, and a
number of additional views in our menu section as well. We could also customize
some of the branding, in the brand section. We can create our own formatting rules to make the text bigger or smaller, or add different conditional
formatting elements for how the names are displayed. And we also have our Behavior tab. Behavior allows us to add various actions, and workflow reports that affects how we use the app on a regular basis. For instance, we could
create a party action. So here, what we’re doing is we’re going to set a column for tardies, and we’re going to set it to a new value every time we use this action. And we’re gonna set the task Tardies+1. So essentially what that’s saying is that anytime let’s say that Cristiano
Ronaldo is tardy for class, right now he’s at six tardies. But we could mark him as tardy, and he would be up to seven tardies. We can also create workflows, for instance we could have a workflow for unexcused absences. We’ll call that unexcused absences. And we’ll say that
whenever a change happens and unexcused absences
is greater than five. Let’s go ahead and
e-mail the Parent E-mail. And here we could either
type in an e-mail, or we could use our expression and remember we have our columns and one of our columns is Parent E-mail. So we’ll just even insert
Parent E-mail here, and we are good to go. Finally we have reports. If we wanted to, we could add a report that would send the Dean’s List, or our tardies, or unexcused absences, or any other key information
we want at whatever interval makes sense to these
specified stakeholders. Once we finish setting
up our UX in behavior, we can jump over to security. In this case, we would want
to require user sign-in because we have confidential data. We have phone numbers and e-mails, and we don’t want that getting out. So we can select our
domain authentication, right now we’re using Google. For the vast majority of the
apps that you’ll be creating, you would likely want to
require a user sign-in as well. And once we finish with security, we can briefly explore Intelligence. Intelligence allows us
to make use of features like Smart Assistant,
which is a voice assistant that enables you to find what
you’re looking for in the app, just by your voice. So once we’re done finalizing our app, we can head over to Not Deployed. In this, we’ll go ahead and automatically run a deployment check. And we can see that our app passes. And so we’re going to go ahead and move our app to a deployed state. Once our app is deployed, we’ll go ahead and check our e-mail. And we can see that
we’ve received our app, Superstar High School Directory is ready. If we’re on the phone, we
can go ahead and install this as an app on our phone, but for now we’re just going
to view it in our browser. And you can see that we have
our fully functional app with our Dean’s List, Slice,
our Student Directory, and our form to create new students right here in our browser ready to go. If we jump back over to the editor, you can see that here we
have our Share App sections. We can share our app
with our entire domain or specific users. And there you have it. That is how you build an app
on the AppSheet platform. So whether you’re a teacher, school staff, district administrator, or you
work at the university level, know that there is a
path for success for you. You can get started for free, just by following the link in this video, or head over to,
and hit Start For Free. Or head over to the Sample App section, and go over to Education, and you can start thinking through ideas on what might make sense for
you and your institution. If you have any thoughts or questions, we’d love to hear from you in
the YouTube comments section, or jump over to, and with that thank you
so much for watching.

Leave a Reply

Your email address will not be published. Required fields are marked *