[Music]
hello guys I am here with another video
today we're going to talk about online
attendance it is something really simple
it's something really easy but if you
have great tools you can make it easier
and I'm gonna share with you one link
guys and the link is right here below
the video and if you click it you may
have a problem like that because this is
not the link for the file
it's the link for you to copy the file
so it says the file does not exist so in
this case you just need to choose the
copy the link and paste it manually
right here and in yeah it says you can
access the file now and you can just
make a copy click on this link and this
is a Google spreadsheet and it's a great
it has great tools here it's like a
Microsoft Excel but everything is online
you don't need to save it you don't need
to download it here ok every time when
you take attendance just close the file
it automatically saves your Google Drive
so the thing is you need to have a
Google Drive and Google account if you
don't have it in your browser you're
going to end up a situation like that so
let's open in this this mode and you see
it says you have to sign in so you have
to do this one you have to write your
credentials and sign in and then access
the file because it will be saved in
your Google Drive so what is the file
it's right here it says copy of
attendance template tennis tablet is the
original name because you made a copy in
your Drive it says the copy of the file
so you can change the names right
another big deal and you can write your
class code here you can write your name
here and you can just paste your
students name right here and you can
also write to these numbers here right
number them 1 2 3 and you'll need to
write everything manually
it works the same as Microsoft Excel
right you can just choose some and then
scroll down so you see it gives us 36
numbers 36 names and then you can just
write
and copy the names right here you can
also even write number okay because this
column represents the number right and
everything is dated here this is these
are only weekdays but if you are working
let's say weekend as well or some
specific days you can just start writing
today's date here let's try this right
it is on April 12 right April 11 so it
says it's Saturday it is Saturday right
so it automatically gives you the day
right here and after that you can just
scroll this date here that's it you see
until June 7 it gives you every single
day and then maybe you don't work out
every day right you don't need all these
columns for example I don't work on
Sundays right you can just click this
and delete the column you'll need to
delete them one by one
you can just click multiple by using
ctrl button Sunday Thursday Sunday
Thursday Sunday so you see you can just
to choose everything at once and then
you can delete it Thursday and Sunday so
because I usually don't want to see all
other days it doesn't change the formula
everything stays the same and at the end
you can see it counts your number of
blades and absences right it is it is
the important part right here so you can
just there's a key here you can see it
says P for present al for late and a for
absent you can assign some more
attendance key history right here
- to avoid some errors on the file so
let's say students one was present
present present present all at present
so let's say if you put that here it
gives you an error so we cannot do that
on the assigns variables are a LP DNS
but you can change it we will talk about
that in a minute
so you see it gives the numbers so it's
a great tool guys it automatically
counts and if you need more days you can
just come to the last and then insert
one right or you can just choose more
let's say I choose that much columns and
I want to insert seven right and I want
I can just copy the names again just
choose and click and scroll there and
then it's gonna give you the dates and
then the day is everything okay so
that's it guys if you are using in
another language it's the important part
right here let's go to key so key is
right here right you can just edit the
file like like like you want for example
some of my followers are from other like
other countries so you can just change
this key like let me make it Turkish
so let's go back to course one and let's
check so you see it says get G and yolk
for Y so it changed it and the thing is
you know I changed my variables so now I
cannot use these letters I need to use
the letters I assign because it says it
involved right so the formula works like
that it's really simple let's say he was
here
and so you see one late one one two
it automatically counts and the best
thing is you can change the language
guys so you can also add more here to
avoid having errors for example if some
students drop the course you can just
put D here or you can raise their names
if something started too late you can
just put asked for the day they started
the course to avoid like no counting
lates and absences and the other good
thing is if you just want to use the
right side of the page all right you can
just scroll right and you see the
students names stays right here so I'm
just gonna show you like that right
let's understand it better so let's say
these are the dates I used it before if
I just scroll right and right you see
students name stays right here so it
does not disappear so you can just check
their attendance and name you see while
looking at this screen so it stays right
here it's a really cool feature if you
need more courses you can just you just
click any of them okay and then
duplicate the course so you see it gives
you another one with the same so you can
just rename it make it course four or
you can just write your course name
right so you see you can if you don't
need more if you have only one course
you can delete it okay that's it so and
the good thing is here everything is
online you don't need to save it and you
don't need to download it guys don't
download it this is Microsoft this is
another Microsoft Excel if you download
it it makes you in Excel but you can
just lose some of the functions so you
can just download it from here file and
where is it yeah it's right your
download as Microsoft Excel file or we
can if you want to make it a report for
the school for the management you can
share the PDF file the one of the one of
the best thing is you can share with the
people for example let's say your
management wants to see what you are
doing with this course right they want
to take the attendance they want to
check that and they
they want to call the parents right so
the only thing you want to do is just
click on this share option and write
their email address and then share it
with them
and for the for the people to see the
attendance but cannot change it you can
just make it visible for them they
cannot edit it right just just make it
can we you okay let's say I'm sharing
with one people now and after you share
with them and they're gonna receive an
email
yeah let's see I have a new mutation
right here I can just click on this
invitation so you see it says it you can
I can view only right I cannot change
the file but I can see what's happening
right here so I want to I want to show
you one thing guys so you see this is
the teacher right here and this is the
manager manager can view only right but
you can they can request access to edit
the file so everything I change on the
left side on that my original file is a
teacher the management can see right
here without saving the file so let's
see here I say this student was late so
you think it appears on the right it's a
great tool guys so let's say they're
absent absent absent absence right and
Late Late Late Late so you see
everything automatically saves and they
can see all the changes on the file
that's it I'm going to show you another
video with you guys about grading I also
have a Google spreadsheet about of the
great students Optima mark them if you
have any questions you can just comment
below I will try to answer all the
questions know as much as possible see
you guys good bye
you