 I'm going to show you a really easy way to use Google Sheets to create charts or graphs so you can kind of visualize your data a little easier. So first you have to have a sheet and some headings so I have my fake student list here and then some fake data. So maybe this is like a grade book or something like that. And here's my students and then I've got my data imported. So all I need to do to start a chart or a graph, click on the data so I'm going to select I'm going to click and drag so I'm going to select all of the data I want to make a chart with. So it's all this blue highlighted color right now. And there's a couple places you can look. Down here at the bottom there's an explore button. You can click that and it quickly gives you some ideas of charts you can use. I kind of go old school. I like the options are going up to the insert button up here and going down to chart but either one you can find the same things they'll do the same thing. So I'm going to click the chart button. It's going to dump a chart in here that I can see now it's small and I'll make it bigger but this is just the basic thing that she said I think this is what you're trying to do. I can change my chart style by going over here where it says chart type and clicking that drop down. And I can kind of see now these are the four that were suggested I could choose like maybe this was a like a timeline chart or something that it chose the best chart for that data and in this case this is the kind of chart I would use but there are other options you could do it a stacked one where it takes all of your scores and puts them on top of each other. So maybe all of those four pieces of data were really going to accumulate to be one final score. There's also and this won't work necessarily but there are pie charts this is obviously not the kind of data I would use with that but you can choose which one you want. Maybe you want a horizontal type chart. I'm going to go ahead and stick with that original one right here. So that gives me my basic chart I'll make it a little bit bigger so we can see it a little bit better and I can kind of move it around for right now but this is pretty boring it's just right out of the bat this is what it decided to make. If I go up here to the top where it says customize over here on the right this is where you get to kind of change your chart to make it what you want it to be and you can work your way down all of these topics and kind of click and choose what you want. I tend to go with 3d it makes it a little bolder and shows up a little bit better and then you can go down to the axis you can name these things like maybe I just want this to be scores and when I click into it you can see right over here it just changed that type chart title to scores if you want to have more room you can always take off the title as well and it kind of jumps the chart up a little bit more. You can bold things change the text a little bit format things the way you want maybe I want my labels to actually have all their numbers on it now this is kind of a bad one for that because there's so much data here those are really hard to see so I may not want that but you can go ahead and kind of poke around in here and see the things you want to do all the axes you can change all kinds of stuff maybe you want to put some grid lines in so that these show up a little bit more and you can see some of those lines now appeared in the back so there's lots of settings that you can put in here to make this chart work for you. Now when I'm done I can just go ahead and click the edit back off I can move this chart on my sheet but if I want it kind of big enough to kind of see I can still edit this I can go to these three dots here and go back to edit the chart I can delete it if I'm just like you know what I really don't want it I can download this as an image or a PDF so maybe I want to share this with someone as an image or put it in a document or something I have that ability I can publish it to the web I can copy it and paste it into something else I can also move it to its own sheet so right now you can see it's kind of on top of all my data right here and if I wanted to see my scores and my chart I'd have to make it really small and suddenly it gets hard to see so I can click those three dots go down to move to its own sheet and then right down here at the bottom I've got my data where I was at here where I made it and my chart number one it's a lot bigger and easier to read and what's nice about this is as I go over you can see it's interactive I can pull up the data from that student so you can see here that all of data one that first assessment tool I've got all my students listed down here that's my piece of data on the first one for each kid is blue I can go in and just double click on that color and I can change any of the stuff that I want to change so maybe I don't like the colors and I don't want that first data to be blue maybe I did that in the start of school and for some reason in my brain the start of school is red do my fill color and change that to red then I can go back up to that data and go to data two and I'm thinking this is kind of like Thanksgiving time and I'm gonna make that a orangeish brown color and data three we did during the winter time and my brain thinks well that's got to be blue and then my data four is springtime and that's sunny and grass so that's green so you can change those colors however you want and then you can see that they changed right over here as well and there's lots of customizing you can do it's basically just kind of jump around here and take a look find the ones that work for you you can't break it you can always undo any mistake that you might make click little x up here and then I'm back to this full screen view I go back to my full data and then I can go back over here and even on this page I can go to my copy my chart I can edit I can publish I can do all those same things I could do before so once again just edit click the button and you're back into this whole customized thing and you could change however you want maybe make the background make the background blue you could do anything you want with your charts to make them work for you