Google Sheets: It Is All About The Data

-
Google Sheets has a variety of uses, but I love using Google Sheets for data. When you are collecting data on students, you can keep a variety of information in Google Sheets. Also, this data can be shared with the administration and/or other teachers. For example, imagine having a school wide Google Sheet for every student at the school. You could use Google Sheets to
  • report plagiarism issues (See "School Plagiarism Policy" below). If a student is plagiarizing in one class, they are probably plagiarizing in another class as well. You could share a Google Sheet with every teacher, so each attempt of plagiarism is accounted for and can be followed-up with the schools plagiarism policy.
  • note the number of times you attempt to call a student and/or guardian and the outcome of each attempt. Also, if six teachers call 2 times a week, the family may get very annoyed, but, if you could look at a Google Sheet to see if any other teacher has tried to contact that student, you could avoid this issue. Also, the administration could step in when multiple attempts have been made.
  • create your own student connection log (See "Student Connection Log" below). This is a great way to keep your student information in one place, so you can track your personal connections with the student. Having a connection with the student on a regular basis is important. This could include (phone calls, texts, emails and/or live classes). Would you go months without saying "Hi" to someone in a face to face setting? Absolutely not. This means you want to maintain this same level of connection in the virtual setting.
  • create an assignment list for your students (See "Assignment Log" below). This is great to give to students, so they know what they need to complete, and it is great for the teacher because you can see where the students are at regarding their progress in your class. Also, you could use a similar tool, at the end of the semester, to send to your bubble students (students between a 40% and 59.9%) in your class. On the assignment log, you could list major assignments, labs, tests, quizzes, etc... that they should focus on to raise their grade in your class.
  • to take attendance (See "Attendance Tracker" below). It is important to keep track of who is coming to class. You can take attendance at the beginning of class when students are completing a warm-up (just like in a face to face setting). If a student comes in after the warm-up, they will need to send you a message letting you know they were late to class, so their attendance counts.
Assignment Log

Student Connection Log

Attendance Tracker
Click Here

School Plagiarism Tracker
Click Here

Comments

Post a Comment

Popular posts from this blog

Science Resources

-
Image
  Finding helpful tools for teaching a science course online can be difficult. Here you will find NGSS resources, virtual simulations and additional resources for your science course. To view the resource, click on the links below. NGSS Resources Bozeman Science : This website shares some great resources, such as graphic organizers made for NGSS. NGSS Website:  This link will take you to the NGSS official website. NSTA Website:  This website can be used to clarify your understanding of NGSS. Phenomena for NGSS:  This website has several different phenomena that you can use in your course to start the learning process for your students. Physical Science : This link goes through the physical science lessons that you could use in your classroom. Project Phenomena:  This website gives different phenomena that you can use in your class. Also, they give resources that can be used for the phenomena. The Phenomenon Master List:  This list gives phenomenon for every...
Read more

Virtual Teaching: Interactive Whiteboard

-
Image
Interacting with your students in a virtual class can be difficult if you do not have the right tools. In fact, this is a common complaint I see among teachers. For example, Zoom is a great resource to meet with students, but you can only share a screen, use the polling tool, and use the chat. The Zoom resources are meant for webinars not teaching a class. Also, there are resources, such as Blackboard Collaborate, which allow you to use whiteboard tools, polling tools, chat, app sharing, etc..., but great options like this cost money. What do you do when you want to interact with your students for free? Also, how do you interact with your students using platforms, such as Zoom? One option that you could use is  https://www.whiteboard.chat/ . In this platform, you have access to the following: Polling Tools: You can ask students practice questions. This allows you quickly check how students are doing with the material. Do you need to spend more time on a certain topic before moving ...
Read more

Vocaroo: Educational Podcasting

-
Image
What Can  Vocaroo  Be Used For?   Vocaroo ( https://vocaroo.com/ ) is a tool that can be used to create podcasts. To begin, a podcast is a digital audio file that can be sent to your audience. So, why do you want to consider using podcasting for instruction? To begin, you are very busy. Imagine if you can reduce the number of emails you need to send, or imagine if you can reduce the number of times you need to repeat instructions. A podcast can be used to give instructions about an assignment, or a process that you want the learners to know about. All you need to do is copy the link into your learning management system, or in the chat box of your virtual classroom. Your learners will have the instructions at their fingertips that they can pause, rewind and replay as needed. This frees you up to focus on areas of your instruction that can really help students, such as teaching a student how to do something. Next, you can use podcasting to send announcements to yo...
Read more