 Hello everyone and welcome, welcome to our Seasaw for schools back to school with CSV rostering. I'm so excited to have you join us today where we're going to show you how to get your school set up with CSV rostering. And this session is for administrators that have used CSV rostering in the past and will be continuing to use that for the new school year. So I would love to get an idea of who we have in the room, we will be communicating primarily via chat so go ahead and open up your chat. When you first open it up next to to you'll notice that it says panelists if you just click that little arrow that drop down arrow and change it to panelists and attendees, then everyone can see your responses in the chat any questions that you have. If you do that in the chat drop in your name what district you're from and your role. Welcome, welcome. Hello, Lucas. Welcome. Hi Ashley welcome. Hello, Ali. Welcome Jill. Welcome Lisa. Hi Angela welcome. Hello Beth hello Mary. Welcome. Hello, Nicole. Hi Julie. Oh Julie you're from Chicago so am I. Hi Kelly welcome. Hi Courtney. Welcome welcome. Hello Deb. Hello Janice. Hi Anne. All right, great to see you all so we're going to get started with some introductions. I am Mia. I am the training and professional development specialist here at Seesaw I am based in Chicago, Illinois. And I am a former kindergarten teacher so I'm excited to be with you today. I also have two of my colleagues with me today. Would you all Jim would you like to introduce yourself. Hi my name is Jennifer and I've been with Seesaw for about a year now working as a customer support support specialist with our large districts. Thank you. And then we have Brie as well she'll introduce herself. Hi, my name is Brie and I'm an implementation consultant I've been with Seesaw for about three years. Hi so I will be walking you through how to roster with CSV and Jennifer and Brie will be in the back channel so they will be answering any questions that you drop into the chat. If you are just joining me make sure when you open up that chat next to to you just click that little drop down arrow and change it to panelists and attendees that way so everyone. Not just the panel can see your question so this is very helpful. If you do have the same question. We also have a Q&A so if you will prefer to open that up and drop your questions in the Q&A, then that would be awesome. As I mentioned Jennifer and Brie will be checking those and responding to your questions. This session is being recorded, you will receive a follow up email in about 24 hours so just give us 24 hours and in that follow up, you will receive the slides that we are going through today, as well as the recording and a certificate of completion. So I think that we have all of the housekeeping things out of the way. So let's go ahead and get started. So as a reminder, this webinar is for admin who have used CSVs to roster their classes last year and are using the same rostering method this back to school. Hi Stephanie. All right. Just want to point out if you will be making any changes to the number of students licenses or schools that you are syncing just make sure that you reach out to us and let us know. So here is our agenda for the next hour. I like to call it our roadmap. So today we're going to cover our CSV rostering method which allows you to upload data from your SIS into CSaw to create your classes. After that we will go over data cleanup steps after you've rostered to just ensure that you have accurate analytics for the new school year. And then next we will get into some bulk updates and then finally I am going to share with you some additional resources that you can use to support your staff in training and PD and just anything that you need. All right. So before we get started, I just want to make sure that everyone is signed into their CSaw for schools district admin account. So when you go to web.csaw.me, you're going to select a CSaw for schools administrator and you're going to sign in that way. We'll drop a link in the chat to a video just in case you need any help with sign in. We'll have Brie or Jennifer drop that in the chat for you guys just so you'll have it. All right, so we are signed in and ready to go. The first thing that we need to do is to create your CSV using your SIS and upload it into CSaw. To upload your data into CSaw, you will need to use our CSaw for schools setup template, and you're going to have to fill that out. You're going to be prompted to make a copy of that template and complete it. Most data can be copied and pasted directly from your SIS into this template that we are having you copy and complete. We'll also drop a link into the chat for that links directly to that template for you to make a copy of. All right, so once you actually make a copy, you are going to need to gather the following information from your SIS. So you're going to need a unique class name for each class that you're creating, you're going to have to identify the grade level for each class. You're going to need that teacher's first and last name, all of the teachers that you are setting up. You're going to need teacher emails, student names, student IDs, and if you are using email or Google sign in, you will need to include a student email address. For email sign in, you will also need to include a password for each student. As a reminder, student IDs must be a unique ID number that will not change during the course of that student's career at your school. For your returning students, you will need to use the ID number that you assigned them last year. So we want to make sure that that ID is unique for that student because that is how their portfolios follow them from year to year. We do have some suggestions when you are creating your classes in the CSV. So we recommend for younger students for our babies that you create one homeroom for each of your teachers and add any specialists as co-teachers. It's often difficult for the little ones to go back and forth between classes, so this is what we recommend for your younger students, kindergarten through second grade or third grade. For older students, if teachers and specialists have their own class periods, then we suggest creating individual classes for each period. If specialists visit or push into a homeroom class, we recommend then adding that specialist as a co-teacher to that homeroom class. For grade level, you are going to select the appropriate grade level for the class from the drop-down menu. You'll notice that there'll be a little arrow there. Only one grade level can be selected per class, regardless of the actual grade levels in that class. However, the grade level of the class can be adjusted after the CSV import if necessary. The steps for clever lining are slightly different. If you are a school that used clever last year in our returning, we do have a webinar on Wednesday for that. Maybe Jennifer or Brie can drop the link to the registration for that in the chat there. All right, so you have your grade level selected. And the next thing that you need to select is a sign-in mode for each class. Pre-K through third grade typically uses class code sign-ins. Pre-K students will log into their class by scanning a unique QR code. The CSV import will default to class code one-to-one. However, teachers or admin can set it to shared devices after the import. For grades four through 12, they usually use email or Google sign-in. If students do not have email addresses, then you can choose class code sign-in. And we'll drop a link into the chat to help with how students sign-in. So you're going to fill in the template that you copy with information from each class using one row per student, like you see here in this example. In the CSV template that you make a copy of, there is an example. And that is underneath the tab that is titled example class roster in the setup template. So if you forget the structure of filling this out, there is an example that you can refer to directly in that template. Just a couple of things that we want to make sure that you keep in mind. There is a field explanation on that Seesaw for School setup template to help you if you are unsure as to what information to enter into the template. And another reminder is to save and export your spreadsheet as a CSV file. Other file formats are not supported. So when you finish filling out that template out your CSV template, then you can upload it directly to Seesaw. So what you're going to do is you're going to navigate back to your school dashboard. And then you're underneath the overview tab you're going to go to those admin tools and then you are going to select setup school roster. And then you're going to tap select CSV from your computer. So I am just going to go ahead and here is let's see, I have a copy. I'm going to go back and just kind of review for a second so that you guys so everyone is clear on. Here we go. So here I'm going to take a look at this spreadsheet here so here is the spreadsheet that you are going to be prompted to make a copy of this is that Seesaw for Schools template. So go ahead and click make a copy. Mine is loading here. And this is a copy of that template. So you are actually going to enter all your data into the fourth tab so this first tab includes your general instructions about making a copy of this file and following the steps. You can see the second tab. This is where you can find those field explanations. These field explanations are going to just explain the type of information that you should include in each field of the template here. And the next tab is an example of a completed template so you can see there you have a model or a guide for you. And then finally that last tab is the tab that you will actually enter your information into. So this is what that template looks like when you copy that and I see in the chat someone did ask for the clever class link zoom link so i'm going to go ahead I don't think that's been dropped in yet. Sorry about that delay so that is the link for Wednesday session so if you are rostering with clever or class length and you can go ahead and log off of this session and join us on Wednesday. Okay, so after you complete your very welcome key. So after you complete this setup template here, then you're going to save that you're going to go ahead and make sure that you save and export that this sheet right here as a CSV. So back into your dashboard so here is my my test dashboard here and you're going to go into now you're going to upload that template to seesaw. So in your dashboard, you're going to click that overview tab underneath admin admin tools, you're going to click setup school roster. And then you're going to click that button that says select CSV from your computer, and that is how you upload that directly. After you do upload after you do upload that your roster you completed template to see saw, you are going to. You're going to receive a summary of the classes students and teachers who were created and the existing teachers and students who were updated. If there are any error messages or warnings that appear. Make sure that you read that carefully and then return to your CSV to fix any of those errors so you can see here. In this sample, there are some data errors and it tells you exactly what those are so you would just go to that CSV make those changes, save a new CSV and then you would just upload that new CSV again, and then you will get that same summary and hopefully the second time around, there will not be any errors. All right. Step two, so now that you have imported your roster you'll want to take a few minutes to clean up your classes and student data on your school dashboard in order to ensure accurate analytics for the new school year. Let's skip the head one slide so here you go. If you don't need your teachers or your students to access historical portfolio, then you can skip this step. So seesaw uses the student ID to keep student portfolios from different classes in years together. Students who started off on the few using the free version of seesaw, these students do not have a student ID. Some of these students may also have multiple journals because they use seesaw and multiple classes. So what you're going to need to do is to assign the students a student ID and merge any duplicate journals. If you want your students to have access to historic data and have one cohesive journal. So you're going to do that. Again, in the overview tab underneath admin tools, you're going to select assign missing student IDs in your school dashboard and you're going to go ahead and click on that. And then that you're going to be able to view a report of all student accounts that have neither a student ID nor an email. While you're adding IDs for students an option to merge will appear if the student ID is already in use so you can see here in red. It says ID in use by Bruce B, you will have an option to click merge there click here to merge to confirm that the accounts are duplicates of the same students. If they are, then you can follow the steps to merge those two accounts, just so you know student merges cannot be undone so we want to make sure that we are clear. Alright, so next you will want to bulk archive old classes in order to clean up any classes that were created outside of your roster import for this year. You may include classes that were imported along with existing teacher accounts as well as classes from previous years. So to do so for each school dashboard underneath your admin tools you're going to tap archive old classes, then you're going to select a date. You're going to select a date to archive any classes before that date so we suggest selecting the date you uploaded your CSV roster to archive any classes created before your import. It's important to bulk archive classes before you archive students because you can only archive students that are not enrolled in an active class. Alright, so once your classes for the year have been all set up and you've archived for classes, then you can bulk archive students that are not rostered to an active class. So for example, student accounts that you don't recognize when reviewing and updating existing that you didn't recognize when reviewing and updating existing students earlier. This will ensure accurate analytics and data for the new school year. So from again from admin tools you're going to tap this time archive student accounts. I'll tell you exactly how many students are going to be archived, and then you're going to tap archive old student accounts to continue. Just think I one thing I want to point out is that no data will be deleted without your permission archive students will still be on your dashboard but they will not be taking up any of your seesaw licenses. Alright, so now let me introduce you to the new CSV bulk update tool which will allow you to make updates to your school data if seesaw and seesaw after you've imported your rosters. The CSV bulk update tool is a powerful admin tool that allows seesaw admin to create an update student and teacher accounts update class enrollments and edit class information on the admin dashboard. The CSV bulk update tool can be found underneath the students teachers classes and families tab. So simply locate the button that says bulk update classes you see it's highlighted here in orange, followed by the name of the tab you are currently viewing. If there are accounts or classed classes listed in the tab the button will be located under the tab. If there are no classes or accounts of a certain type connected to your school the button will be in the center of the screen. So tap that button to access the tool and be able to download an editable CSV of existing data or a blank template depending on the changes that you want to make. You'll also tap the button in order to upload those changes to seesaw. Then open the downloaded file in your preferred spreadsheet format program to create new accounts or classes you will use a blank template and fill in the required information. To edit existing data, you will download the existing data and make the edits in the appropriate cell. Then you will save that edited file as a CSV and then you're going to return to the bulk update tool to update the changes to seesaw. And we're going to drop a link in the chat to just the instructions for all of just this particular step for you. So currently you can make the following updates using the CSV bulk update tools. So for teachers you can create new accounts. You can view existing teacher account information and you can add or remove teachers on classes. For students you can create new student accounts and update their email addresses, student IDs, and student enrollment in classes. For classes you can edit the class name, grade level, the sign-in method, and archived or unarchived classes. And for families you can connect family members to student accounts or you can remove them from student accounts. Our team is continuing to work on this tool so you can expect some additional updates from us. So we do have all of these steps and resources at our, at this website here, web.seesaw.me, forward slash technical steps for administrators. We're going to drop that link in the chat for you and we do recommend that you bookmark that. I do want to share just some additional resources to further support your staff in implementing seesaw. So one of which is our resources for administrators page. And on this site there is a link to those technical steps that we just highlighted for you. But on this site you can also find some other resources that may be helpful. So you'll find videos on how to use the admin dashboard. So really how to dig into that data in different ways that you can use that throughout your school year. And you'll find a link to other resources as well. So we'll drop the link to that in the chat. Another resource that you can share directly with your teachers is our resources for teachers page. And on this page you will find a link to our free training site. So our free training site does on that site. It contains our on demand training videos. They are less than 10 minutes long and they're great resource for teachers to help get them started with seesaw and beyond. So we have some videos on getting up and running on setting up your seesaw account creating your first activity but we also have videos that go beyond the basics. So using folders using the blogs. This is a great resource to share with your teachers because it can get them going very very quickly. Also on this resources for teacher site. You will find links to our getting started guides which we are actually updating and will be complete by this Wednesday. And you will find resources on integrating seesaw into classroom instruction. There's one more resource that I want to share with you and that is our professional development page that you can see here. We'll drop that link in the chat as well. But on this page you will find links to our ready to use seesaw professional development kits. And you can you or your in house trainers can use these kits to help support your staff in implementing seesaw to get them trained on seesaw. So this is where you would go to access those resources. If you have any questions about professional development, you can email us at pd pd at seesaw.me and we'll just drop that email in the chat for you as well. All right, and finally we are in the middle of our seesaw connect virtual conference it is free for every educator and admin it began on last Monday. It is going all the way through August 13 so we definitely encourage you to RSVP to get access to over 30 conference courses I do have a course. In the conference as well my course talks all about getting early childhood students up and running for on devices in just six weeks so make sure you check that out. And then finally what we want to share before we open up for questions is that you can nominate educators to fast track ambassadors so if there's anyone at your school that you think would be a great person to have as a seesaw ambassador you can nominate them and fast track that this guarantees successful seesaw implementation and seesaw PD for your school. We are going to drop a link to that type form that you can use to nominate your, any of your staff members to become a seesaw certified ambassador. And now I want to open it up for any questions that you have so it looks like Jennifer and Bree, thank you you've been on top of it with the questions but if there are any additional questions, please make sure you either drop them in the chat, or in the Q&A now. Yes okay so there's a question and Mark can you please I apologize I don't see that question so can you put it back in the chat. Someone else has a question about teacher activities that will create it will they be saved yes. So, all activities that are created are saved to that teachers activity library. And those activities are saved year over year so they do not go anywhere. And there are a couple questions in the Q&A. One from Stephanie, if we are not using any data to go forward to the new academic year is there a way to delete everything and start fresh. Maybe Jennifer or Bree if you want to just unmute yourself and respond to that question you can or it looks like you might have answered those already okay. Okay it looks like there's a question about switching IDs. So Jennifer or Bree can you answer that question please feel free to unmute and just go ahead and respond. Hi there. Yeah, so it's actually we recommend leaving student IDs the same year over year. That will help to keep student journals intact. Thank you and then also there's a question what happens when archiving existing students, and then they are a part of the new class in bulk CSV. Great question. If a student is archived and they are part of the new year's CSV roster they will be unarchived automatically as part of that CSV upload. All right. After archiving can the data be deleted from their account. I would recommend reaching out to support if there is you know if there's a specific issue that you would need help with or if there's a specific reason why you would need data deleted. However on on your end there's not there's not a way to delete accounts and I think the way and I think the way that you're asking. Okay, so Mark's question if we've used seesaw last year will again this year and we have some continuing students and some that aged out of our program and some new students. Do we use the bulk tool or the CSV upload method which one would you recommend. That's a great question. I think it is. I think whichever you are the most comfortable with it might be easiest to to archive your well let's see. Let me reread this question real quick if that's okay. Of course. Thank you. Yeah, I would say the CSV upload method would probably be the easiest. But you really could do either either or. Great. Thank you so much just a couple more questions before we sign off here. Can so Michael wants to know can we reuse the CSV from last year and just change the class in the grade. I think that would depend on if the students are the same. Yeah, I think that would depend on if the students themselves are the same you might have more accurate data if you if you go right from your student information system as it is now. That would probably be what I would recommend rather than going back and editing an old CSV I would probably recommend pulling right from your sis from this year. Great. And then final question here. How can student or teachers review previous work from archive data. Great question. If the question is how do you view archived, you know, archive students and classes, you can do so from your school dashboard and go to the related tab so if you want to look at students you can look at the students tab. And, oh perfect you're going to demo that's great. Yep. Sorry, exit out of that. So here's the student tab. Perfect. If you go to the three dots on the gray bar at the top there. Yes, archived students. This will allow you to see archived students, along with unarchived students, you will be able to tell if they are archived because it will say archived in parentheses next to the student name. And this is a test account so unfortunately we don't have an example that but just so you can see how to access that information. Yeah. And it should be the same for classes as well the same same process classes, three dots show archive classes. Yep, and you can see here content team lunch and learn was archived. And so was the third grade class. All right. And what about the number showed in pending activities for students. I'm not sure last year. I'm not sure what you're asking. So if you can rephrase that question. Okay, let's see the answer that question. So archived last year's classes before uploading the CSV for this year, this, this school year, as some teachers that changed grade levels and I'm not sure if that will be an issue. It sounds like it might be a good idea to do some dashboard cleanup then before introducing your new CSV upload. That way, you're really starting fresh. It sounds like that might be in line with what you're hoping to do. And I think are there any questions that we missed I think we might have gotten them all. Okay, there's one last question, Bri and Jennifer about pending activity so if a student didn't complete an activity last year and that class is archived. Will those, will they be able to complete them I think that's your question. I'm not 100% sure on this question. I believe that I believe that only approved activities are archived along with the student journal. I'm actually fairly certain, but if you know if I would recommend reaching out to support for a better answer. But I think that only approved activities are archived along with the student journal. Thank you all so much for joining us today. I also want to thank Bri and Jennifer for being on hand to answer all your questions. As I mentioned, give us 24 hours and you will receive a follow up email with the link to the recording from today's sessions, along with the slides and a certificate of completion. Good luck with your new school year and happy seesawing everyone.