- 21
- 209 621
Tales from Outside the Classroom
United States
Приєднався 1 бер 2014
Tracking Student Data in Google Sheets Part 2: Individual Student Data Sheets
In my first Tracking Data with Google Sheets video I walk you through setting up the spreadsheet to auto-calculate student percentages and averages, and conditional formatting to color code based on student mastery. In this Part 2 Google Sheets video, I walk you through using formulas to create individual student reporting pages based on your inputted data.
This Google Sheets video tutorial walks through pulling information from cells in another tab or sheet, adding graphs, and using the find and replace tool to duplicate the work simply and easily.
These individual student reporting pages are perfect for data conversations. They are easy to use for RtI or MTSS meetings, parent-conferences, or your PLC meetings.
Want to save yourself time? Grab my free, easy to use templates!
Individual test assessment tracker: docs.google.com/spreadsheets/d/1ARPSPJ9z78nldeQrFOpm80H5HHkCZ1gUNQR4s6sV3bE/copy
Are you a 1st grade, 2nd grade, 3rd grade, or 4th grade teacher looking to track your math data? I've got you covered! Download your Standard-by-Standard Math Tracking Spreadsheet here: www.talesfromoutsidetheclassroom.com/math-standards-tracking/
This Google Sheets video tutorial walks through pulling information from cells in another tab or sheet, adding graphs, and using the find and replace tool to duplicate the work simply and easily.
These individual student reporting pages are perfect for data conversations. They are easy to use for RtI or MTSS meetings, parent-conferences, or your PLC meetings.
Want to save yourself time? Grab my free, easy to use templates!
Individual test assessment tracker: docs.google.com/spreadsheets/d/1ARPSPJ9z78nldeQrFOpm80H5HHkCZ1gUNQR4s6sV3bE/copy
Are you a 1st grade, 2nd grade, 3rd grade, or 4th grade teacher looking to track your math data? I've got you covered! Download your Standard-by-Standard Math Tracking Spreadsheet here: www.talesfromoutsidetheclassroom.com/math-standards-tracking/
Переглядів: 1 962
Відео
Hands-On Fractions Greater than 1 Lesson
Переглядів 2,4 тис.Рік тому
This video walks through my hands-on, interactive lesson I use to introduce my 3rd graders to fractions greater than 1 (improper fractions). Through manipulating the cookies, students are also interactive with concepts connected to comparing fractions and equivalent fractions and whole numbers as fractions. You cannot also use this lesson to connect with mixed numbers, which would make this les...
Creating Fractions Strips Interactive Lesson
Переглядів 2,8 тис.Рік тому
Introduce students to fractions with this hands-on, interactive fractions strips lesson. Store bought fractions strips, while helpful, don't help students build an understanding of fractions concepts. This one lesson introduces students to many concepts: unit fractions, numerator, denominator, equivalent fractions, and comparing fractions. You can read more on this lesson here: www.talesfromout...
How to use my Time-Saving Phonics Data Tracker Spreadsheet
Переглядів 946Рік тому
Tracking your phonics data in a spreadsheet makes it easy to look at all of your students' information at a glance to make instructional group decisions. This free, editable spreadsheet in Google Sheets lets you customize it for whatever diagnostic phonics assessment you use. Plus, individual student data pages are auto-created- saving you SO MUCH TIME. To sign up to receive this free phonics d...
What is Successive Blending
Переглядів 1,8 тис.Рік тому
A quick video walkthrough of the steps in successive blending. CCVC words are modeled in this tutorial but the same strategy can be used for students that need additional support with phoneme blending at any phonics level. For more on successive blending, including directions on how to implement it step by step, and successive blending activities, read my successive blending post: www.talesfrom...
Displaying Centers Digitally with Powerpoint
Переглядів 1,6 тис.2 роки тому
A tutorial on using my Editable Centers Management Powerpoint to display, time, and signal your centers and small groups rotation. This in-depth walkthrough shows you how to customize this editable Powerpoint to match your style, and to fit your needs, no matter how you structure your centers. From a slide per rotation to a daily display, this template has everything you need. You can purchase ...
Managing Centers and Small Group Rotations with Powerpoint
Переглядів 4 тис.2 роки тому
Powerpoint can time, signal, and rotate your reading centers and math centers for you! In just a few minutes, you can set up your small group rotation display. When it's time for your centers to begin, just click launch and you're ready to go! This tutorial walks through how to set it up in Powerpoint including slide timings and transitions and embedding video timers. Featured in video: Centers...
Tracking Student Assessment Data in Google Sheets
Переглядів 14 тис.3 роки тому
Tracking student assessment data in one place helps you keep a pulse on student performance and analyze your results. This video walks through setting up Google Sheets to be a data spreadsheet. Use Sheets to autoscore your percentages, calculate average scores, and identify the number of students proficient. Customize my premade data tracker here: docs.google.com/spreadsheets/d/1ARPSPJ9z78nldeQ...
Area and Perimeter Piet Mondrian Digital Art Project
Переглядів 9413 роки тому
Practice area and perimeter with this engaging digital art project inspired by the abstract art of Piet Mondrian. Using Google Sheets and Google Classroom makes this super easy to start with your students. I did this project with 3rd grade and it was a great formative check as well. Piet Mondrian on Tate Kids: www.tate.org.uk/kids/explore/who-is/who-piet-mondrian Piet Mondrian at MoMA: www.moma...
Organization in Google Classroom
Переглядів 3553 роки тому
Keeping student work organized in Google Classroom can be tricky. This video is what worked best for me during virtual learning.
Creating a Student Checklist with Google Sheets
Переглядів 16 тис.3 роки тому
Looking to create a checklist to track student work completion or attendance? Google Sheets makes it so easy whether you're in class for instruction, or online for distance learning. I walk through the simple steps for setting up a checklist, and then explore some more other options like color coding rows or columns, setting up point values, and tracking grade percentages.
Using PDFs with Google Classroom
Переглядів 5133 роки тому
This helpful video walks you through modifying your existing PDF's to have only the pages your students need and then assigning those PDF's to your students in Google Classroom. This easy to use app requires no extra installations and is ready to use with just a couple clicks of the button! Use any PDF with your students in just a few minutes! For a video on getting started with Google Classroo...
Google Forms & Google Classroom
Переглядів 14 тис.4 роки тому
A look at using Google Forms within Google Classroom- grading subjective questions, giving feedback to students, and returning grades. For an introduction to Google Forms watch my video: ua-cam.com/video/f1ox2LjDHpo/v-deo.html Or an introduction to Google Classroom: ua-cam.com/video/ToxqQREq2V8/v-deo.html
An Introduction to Google Classroom
Переглядів 2,4 тис.4 роки тому
An Introduction to Google Classroom
Editable Centers Management Powerpoint
Переглядів 2,5 тис.6 років тому
Editable Centers Management Powerpoint
Curriculum Mapping with Excel and Sheets
Переглядів 29 тис.8 років тому
Curriculum Mapping with Excel and Sheets
Creating Mind Maps from Google Docs
Переглядів 105 тис.10 років тому
Creating Mind Maps from Google Docs
Hi this was amazing! I am trying to make somethings similar, however, I am making one where the students input their own data. The problem I have is with my envision the total number of questions change over time. Is their a formula for that?
I'm not sure what you're asking exactly, so I apologize in advance if this doesn't help. You can put the total score field in as a place, and then figure out the actual score in a formula by referring back to that location. I believe you would need to have a place to enter the raw score as well. So you would enter the formula as something like =B4/B9 if B4 was the place where the total number of points was entered and B9 was the raw score for that individual student. Then for the next student it would be =B4/B10 referring back to the same quiz total but for the new student.
I am unable to get the template. I get the first email to confirm but the template doesn't show up. It's not in spam?
Thank you! IS there a way to have the sheet give the class data as a whole? for example percent of class who is in the green for cvc or letter sounds?
Yes, there are many different count and count if functions you can add in. I will explain how I set up mine using B/C columns but the same is true for the others and you can use the corner drag to extend the formulas across. In B34, I added =COUNT(B3:B32) so that the number of students actually assessed was counted. That way, fluctuations due to student moves is accounted for. Then in B35, I used the formula =COUNTIF(C3:C32,">79%") to count the number of students at 80% or above. You can adjust that figure to what works for you. In C35 I built the equation =B35/B34 so I could figure out the percent of students at mastery. There are many different formulas you can build in and use to look at the data more globally.
This is so amazing! Thank you for sharing. Is there a way to add more test names beyond AH?
Hi, I emailed you back as well. No, there's not; they won't transfer over to the individual student pages if you just add them.
thank you! life saver!
If you tie it right you don’t even need to glue it
Hi! My grade team and I are hoping to share one document between the 3 of us for groupings. Is there a way to add more than 30 student names?
Hi, sorry, no, my prebuilt templates only include spaces for 30 students. You could add additional rows to the tracking pages but not the individual student pages. That number of tabs for the student pages would be quite cumbersome.
This tutorial is one the best ever! Thank you for sharing xoxo
Nice video! It's a great activity, however I think it more useful to start with half, then next strip is quarters, and third strip is eighths. Students then see quarters as half of a half, and eighths as half of halves of a half. Similarly, do this with thirds, sixths, and ninths. In this way, they are seeing relationships between fraction families. You mentioned avoiding fifths because they are too tricky. Totally appropriate to avoid fifths and sevenths at this stage of learning fractions. A great way to generate discussion and to see what the students notice, particularly when you line up fraction bars from largest (halfs) to smallest (ninths). This activity is a great follow-up: education.nsw.gov.au/teaching-and-learning/curriculum/mathematics/mathematics-curriculum-resources-k-12/mathematics-k-6-resources/colour-in-fractions
Thank you!
help, I can't get the slides to go on a timer. I did all the steps here and it doesn't work
Hi, I'm sorry I didn't see this sooner. UA-cam doesn't notify me of all comments, for some reason. Did you get this worked out or do you still need help? If you email me at talesfromoutsidetheclassroom@gmail.com I can help you figure it out!
Can you direct me to where I can find a way to share the data with the individual student but the teacher have the master of everyone
I have not done this myself but I think there's a way to do that with the Autocrat add on.
How do you add a new test name?
I show you that tab at the 1:30 mark. Changing the text is the same way you change any text. You don't have to do anything specific.
Where do you get the image from
I have created them. The file is linked in the video description.
OMG! I have been needing this (and asking how to do this) for YEARS! Thank you so much! I found you on Pinterest. 🥰
This is awesome and thanks for detailed info.
Thank you for sharing this. Very helpful.
Wow, this is amazing and just what I was looking for! Thank you for sharing this template for free.
Exactly what I need
This product is NOT user friendly the slides tabs/w ribbons is not editable there is however a bunch of pictures in which you have to copy from or download individually in order to use. By far this is one of the Worst products I have ever purchased from TPT I felt that it was very misleading.
I am sorry you feel that it's misleading. I try to show in the preview file and in this video that it's something you put together on your own to match your needs, rather than something set up that requires you to follow a specific set of rotations or with specific rotation names or timings. In order to make it fit whatever you system uses, it can't come completely premade. I have tried to include as many starter options as I can to help it not feel cumbersome. If there's something specific that you feel would be more helpful, please let me know. The video shows how you can either insert the pictures or copy them from the given file. In the tutorial, I give several suggestions for making it quicker. You don't need to download anything separately or individually. Everything is in the downloaded folder that you used to access the file. You can insert everything you need in the time it takes you to insert 1 image. There is a background option for every style that is blank so you can put your own words on it, so it is editable.
This is unbelievably helpful! Thank you for making this tutorial!
Thanks so much. This was great :)
Ah, number fudging! You should always allow for students to get a 0. Otherwise it screws up the numbers... (in your favor)
Nothing in this video said you shouldn't allow for students to get a 0. In fact, I clearly stated it was a limitation in the method I was using. Anyone concerned with it being "number fudging" could just use "average" instead of "averageif". There is absolutely no intended "number fudging" here. Just trying to prevent a lack of score from actually fudging the numbers.
The screen is very blurry!
You are right! I uploaded a different way. I'm going to delete this and reupload a new version in just a bit. Thank you for commenting!
Actually, I'm having the same issue with new uploads. The best way to fix it is on the user end, unfortunately. Go to the settings cog, click quality, and then select auto. It's still not great, but it's much better than when I first viewed it.
Ok thanks
Thank you! Great way to learn how to be more efficient when tracking data!
I would love it if you could show how to create charts now with this data!
Hi! Can you tell me more about what you'd like to see? Charts for overall student performance? Charts per assessment?
Fantastic video! Thank you so much. You are making my life much easier, as I seek to learn mindmapping.
l know a much better way than this
This is very useful for me. Thanks. Where’s part 2
Love this! Thank you. You have just made curriculum mapping manageable and do-able for me. Bless you!
This is the second video of yours that I have watched. I really appreciate you style! Very informative and practical! Thank you!
Wonderful! Similar to what I was envisioning!
Thank you! Needed this to complete a course in university. Had to create data from assessments and chart and analyze them. I am so grateful not to have to create the whole spreadsheet myself.
I got here from a Pinterest Pin, to a Blog. You explained wonderfully!
Thank you so much.
Thanks, very easy to follow with great instructional detail.
What grade level do you teach? Elementary, Middle, or Secondary?
I am at the elementary level. Something similar could be done for the secondary level, I'm sure.
This information saved me time of working. Thank you for sharing this knowledge.
Hey, thanks for sharing this knowledge with us. Good work 👏👏👏👏
Thanks a lot! The best video ever! <3
Great organization. This is a template that should be given to ALL first year teachers.
So helpful!! Thank you
Thank you so much. Very Helpful for my Beat Making Class that I teach...Happy Hollidays
Thank you!
This is SO SO helpful. Thank you!!
Hey so could you help me with this.I mistakenly have responded to a quiz with a different account provided by a teacher in google classroom in google forms.I again submitted with the proper account.The quiz wanted my email address in the beginning.I mistakenly gave the email address that I dont use for my google classroom.So basically my teacher recieved a response from a different email and didnt know it was mine.I used my account and did the quiz again.Do you think the teacher can trace back the first response and know it was mine?The quiz only dealt with email addresses and no name.Do u think she might see somehow through google classroom that i was the one who submitted the first response?
No, she won't know the first email address was you. I'd recommend emailing your teacher to let her know.
Wow!! thank you!! This is just what I need at this stage as I figure out homeschooling during covid-19. Thank you! Thank you!
Glad it was helpful!