(upbeat music)
Hey everyone! Welcome to the Tech Exchange: Ideas for Staff by Staff.
Today we're in our Marshalltown office and you'll never guess who I found who has our tech tip for today!
It's Sandy Gavagan...
...an administrative assistant here at the agency...follow me.
Hey Sandy!
Hey Cari!
How are you?
I'm well, how are you?
I'm very good, hey we just though we'd stop by
so you could share a tool with us that you find makes your job more efficient and effective.
Oh gladly!
Cari, I've been using a new add-on
through Google Sheets called EZ Query.
EZ Query allows you to build new tabs
inside of a spreadsheet
to filter only the information that you need.
So, if I was having multiple teachers record information on the same Google form...
about a behavior for a specific student
I could then sort
by teacher to see how that student is doing for that particular teacher?
Yes. You can use EZ Query for that.
...Or if I was collecting responses from staff I could sort by the staff person's name?
Yes! Let me show you how it works.
Ok, here's my spreadsheet and you can see down across the bottom it says working document
so this will be the document that we're going to query.
So, first off we're going to start up here...at the add-ons.
Since I already have EZ Query
We're just gonna get you started...you wanna go to add-ons...
and in the search i want to tell it to find
EZ...that's all you need to type.
Since I already have EZ Query loaded mine tells me to manage...
But when you put it down, as a download...
you're gonna see in that green box, it says free with a plus sign.
So, just click that and it'll start to download.
Then you'll come back up to the add-on
and you'll find EZ Query
right under your add-ons.
You need to come tell it to create a sheet
And tell me more about the sheet you have there Sandy.
The sheet that I have here is...was...
a copy of the applications that people have requested to put onto their ipads.
and it is...full of...
educational assistants, the SLPs, the SLPAs...
I have OTPTs...
So, there's a lot of information that I would have to go through
and cut and paste, but when you do a query
it does the work for ya.
So, first off, let's start with the audiologists.
So, if I tell it that I want to name the next sheet up...
we're gonna name it "audiologist".
I don't need all of the columns to go into my next tab
I just need first and last name...
which is column B and column C.
I need column F which is a description of the application.
and I need H which is the cost of the application.
I wanna come down to filter
I want it to filter column E because that's where all of the disciplines are located.
And because I'm filtering for just the audiologist...
and it's asking me what column I'm looking at
I want it to go to E which is where the disciplines are located.
I want it to contain, not equal, so that way in case...
something gets spelled a little differently, it'll still be able to find it.
So, if I come in and I tell it audiologist
and then I want to add to make a new tab
and then down at the bottom it'll create it.
So now my new tab is down across the bottom and it does say audiologist
and these are the audiologists.
and this is the applications that they've ordered...
and this is the cost of each application.
So, now if you wanna go back out and search for a different
come back to your working document
go back up to add-ons
come back to EZ Query and create another sheet.
Wow! that sure makes sorting data really easy!
Yes Cari, it does!
because once you get the tabs built and you get it to filter
you only get the information that you need
you don't have to spend your time scrolling through the database
trying to find the information that you need
because it will be on the tab that you just created.
Thank you Sandy! It's been great learning about EZ Query!
Oh Cari, you're very welcome.
...and thank you everyone for watching the Tech Exchange: Ideas for Staff...
...by staff.
I hope this tech tip today has been useful,
to learn additional information about today's topic,
please visit the Tech Exchange playlist on our agency YouTube Channel
There you'll find links to additional information in the description below.
(upbeat music)
Không có nhận xét nào:
Đăng nhận xét