Add Initial Data with airSlate SignNow

Add initial data

video I'm gonna show you how to set up a datasheet I use this format both as a teacher and as an administrator when I was a teacher I would use this to track just my own class as an administrator I use this to track multiple classes basically have a spreadsheet for each grade level and the goal of these kind of data sheets is to show you one in a snapshot how a whole group of students is doing whether it's by class or by grade level and two to provide enough detail that you can track individual students over time the goal is to make sure that no teachers or students are falling in the cracks and that you are helping kids when before it's too late so the first thing we're going to do is we're going to be putting students names here the first thing I'm going to do is I'm going to skip down a line and I'm going to just highlight a whole row now I can do it that way or I can take a shortcut just click on the three and I'll highlight the whole row and I use colors quite a bit to kind of break up these rows so because I'm gonna be doing one with multiple teachers I'm gonna put the teacher's name here I'm gonna bold it and I'm going to change the color as well so that's the teacher's name now I can go ahead and put in the students names I can see this one kind of is a bit too big for this column one way you can quickly resize those columns is to highlight it move until your arrow gets the little double arrows there then if you double click on it it'll just resize it for you so I've got all the names now up here I'm going to be putting the assessments so the first assessment let me just put in let's say I want to track running records if you don't know what those are it's not really important it's just the important part is just the name of the assessment and I want to track the middle of the year or the beginning of the year running records middle of the year and end of year okay that doesn't look particularly pretty so what I'm gonna do is gonna highlight these three cells go up to format merge merge all okay and then I will highlight all of these things I'm going to Center them I'll build them as well and then I'll draw some borders around them so you can kind of see the distinct parts and that I like to do also is just differentiate between those I'm going to turn those a light gray so I have running records middle of the year beginning of year middle of year end of year I'm gonna highlight all of these cells and I'm going to put some borders on those as well just makes it easier to track now if I was just doing a single class I'd move on from here but if I'm gonna put in multiple classes like maybe I want to put a whole grade on one sheet I'll highlight that across again I'll put in the next teacher's name again I'm just gonna bold it and change the text color just to help differentiate that and then I would put in a whole another set of names let me get those names fours here real quick there we go and then I'll highlight all of these as well now you notice when I scrolled down there if my if my spreadsheet gets too long all that information I typed up there disappears and I might forget which column is which so to stop that from happening what you need to do I'm gonna highlight this whole row because I want to be able to see running records beginning of your middle of your end of year I always want to be able to see that so I'm gonna highlight that I'm going to go up to view freeze up to current row so what that does is that's going to freeze that those top two rows no matter how far I scroll down that will always be there now that I'm thinking of it if I add in more of these that same problem might happen if I scroll this way too far now the names disappear I don't want that to happen either so I'm gonna highlight this column I'm gonna go up to view freeze freeze one column now no matter how far I go over to the right the names will always stay there and no matter how far go up and down this will always stay there that helps navigating these much bigger spreadsheets that take up more than just your screen size that really helps kind of keep it organized for you now let's say I don't want to just track wanting records I want to track another different assessment what I do is I like to resize this column I'm going to use this column as kind of I'm going to put in lucky a visual break there I'll just highlight the whole thing and turn it gray and I'm going to do the same thing over here let's say I haven't going to track I stations and beginning of year middle of the year when they reformat this just the way I did the other one so I'll go up to four-minute merge cells urge all I'm gonna highlight everything I will Center it I'm not going to do that I'll bold it put some borders on it as well I'm gonna make these guys that lighter gray just to help me at a glance differentiate and then I will also go ahead and put in some borders here okay so here I've got all of my students I've got teachers obviously I could just keep going forever and adding more and more classes when I do these I make one for each grade level and I list every single class in that grade level with all the students so I have one sheet that I can go to to look at and obviously I can continue adding assessments over here as well I'm going to stick with two this one on the bottom here we're going to be adding some more stuff we're also going to be adding some color coding in this but you'll have to go to the next video to see how I automatically add color coding to all scores and how we quickly and easily put in the proficiency rates down here at the bottom for each class so you can click on my next video demo datasheet - to see how we do that