Co-Taught+Classes

Class Combining
> //Even if you are not a teacher who expects classes to be combining...// > Open your gradebook. > From "File," select "Print," and then print a "Score Chart" for all classes in Term 1 > From "File," select "Print," and then print a "Seating Chart" for all classes in Term 1 > From "File," select "Pint," and then print an "Attendance Chart" for all classes in Term 1 if you have been keeping attendance. > //See below for a complete list.// > > //If this works, it'll work every time--see below for a more detailed explanation of how the combo should be working, if you're interested, or would like to suggest a better/easier method!//
 * ** To Avoid Losing Any Data ,** save a backup copy of your gradebook to your flash drive, or to your H: drive
 * **Print your grades** and **seating charts** so that it is easy to transfer grades and move seats
 * If you are a teacher who responded as requsted to the email, **Delete** the **classes** marked "**combine**".
 * **Sync** **data** with Edline to add the "**combine**" students into the "**main**" class.
 * Make adjustments to the grades, attendance, and seating of the newly "combined" students, as desired.

**Syncing--Detailed Instructions and Explanations**
>> Click on "Old Class Materials" in the left column of Edline, and you can copy anything from the "combined" (//a.k.a. deleted)// class back to the "main" class (//see below to remind yourself which you chose)//
 * **Login to Edline**
 * If your **classes have disappeared**, Edline automatically saved all of your settings and documents.
 * To **rename your classes** in Edline so they make sense to you, to your students, and to your students' parents...
 * **Login** to Edline, and click on the **Class** you want to rename.
 * In the //left column//, scroll down and click on "**Manage Class**" under Command Center.
 * Change the "Class Name" to whatever you wish the class to be called in Edline--PLEASE do not change the Course ID!!
 * Save the changes to the class.

To **rename your classes in your Gradebook** and **Sync the list of students** >> >> From "**File**," select "**Email/Internet,"** change the Action to "**Sync Class Data**" and click the "**Sync**" button. Click on the link, and select "**Open**," etc. >> >> //** ERROR MESSAGE? ** This is the point at which I am not 100% certain everything will work properly. I'm wondering if there won't be an error message because there are courses in the gradebook that Edline doesn't believe exist...// If so, we may have to delete those classes before Syncing, which is easy enough to do... >> >> If you've backed up your gradebook and printed copies of your students' scores (grades), you can **delete the "combine" classes** so that your gradebook syncs by doing the following: >>> //This will pull up a list of all of your classes. Make sure you have backed up a copy of your gradebook!!// >>> //Once you have **deleted all of the classes you wanted to combine**, try Sync-ing again. >>> If you are still getting an error message,// email Hilary.
 * **Open** your **gradebook**. //Did you save a backup copy yet? Do that, just in case! It's usually easier to re-enter data if you print Charts of the Scores...//
 * **Sync** your class lists
 * 1) From "Tool," at the top of the gradebook, select "Delete," and the "Class" from the drop-down menus.
 * 1) Click on the "**combine**" class(es)--//see below--//and click the "Delete" button.

>> The classes you noted as "**main**," should transfer all the "combine" students as "//new/add//" students when you Sync. >>> //The "Records" window will open.//
 * The classes you noted to "**combine**" should mark all__ students as "//withdrawn//" when you Sync.
 * To **rename your classes in your Gradebook**, Change the Class Name in Edline, and Sync your data first, then...
 * Open your gradebook. From "**Chart**," select "**Records**" from the drop-down menus.
 * Click on the "**Classes**" tab. The class name is listed in two places--change what is next to "Custom Label" so that your gradebook matches Edline

**Solution Notes**
(One Ring to Rule Them All--//I couldn't help myself. Hopefully Tolkein's ghost is in a forgiving mood!)// > > Set objExcel = CreateObject("Excel.Application") > objExcel.Visible = True > > Set objWorkbook = objExcel.Workbooks.Open("C:\Documents and > Settings\hshort\Desktop\Tech Liason\Network\EdLine\Future > Projects\TestCoTaughtReplace\Class.csv") > Set objWorksheet = objWorkbook.Worksheets(1) > > Set objRange = objWorksheet.UsedRange > > objRange.Replace "combine", "main" > > **Scripts:**
 * **Use a VisualBasic script to replace Secondary CourseIDs with Main CourseIDs**
 * Now that the schedule is set, the **script can be run on the Schedule upload**, and shouldn't add more than a minute (//assuming it works properly)// to the upload process.

Participating Teachers
> Main: 86121001, Combine: 86121901, 86111001 > Main: 66022001, Combine: 66022002, 66022003 > Main: 66033001, Combine: 66033002 > Combine:10100001 and 10100901 > Combine: 10100002 and 10100902 > Combine: 10100003 and 10100903 > Main 70047013 Combine: 70049013, 70050013 > Main: 70094013 Combine: 70104013, 70114013, 70124013 > Main: 70093013 Combine: 70103013, 70113013, 70123013 > Main: 70500013 Combine: 70751013, 70752013, 70754013 > Main: 10106001 Combine 10106901 > Main : 10106002 Combine 10106902 > main: 70047012: combine: 70048012, 70050012 > main: 70047013: combine: 70048013, 70049013, 70050013 > main: 70093012: combine: 70103012, 70123012 > main: 70096012: combine: 70103012, 70500012, 70751012 > Main: 15110009, combine 15110901 > Main: 151100010, combine 15110902 > Main: 70050014 combine: 70047011, 70048011, 70048014, 70049011 > Main: 70123011 combine: 70093011, 70103011, 70113011 > Main: 70126011 combine: 70096011, 70106011, 70116011 > Main: 70752011 combine: 70751011 > Main: 70754011 combine: 70500011 > Main: 2030003, combine: 20300201 > Main: 10118001, combine: 10118901, 10119001, 10119901 > Main: 10096801, combine: 10118902, 10095801, 10119902 > Main: 40112071 Combine: 40111073, 40111072 > Main: 40300001 Combine: 40300051 > Main: 40311001 Combine: 40311061, 40311062 > Main: 25095007 Combine: 25095007 & 25095901 > Main: 25095009 Combine: 25095009 & 25095903 > Main: 25095008 Combine: 25095008 & 25095902 > Main: 10090901, Combine: 10090001 > Main-150900011, Combine-15090901 > Main-150900012, Combine-15090902 > Main-15101071, Combine-15110061 > Main: 86129001, combine: 86129002 > Main: 20220008 combine: 20220903 > Main: 62503001, Combine: 62504001 > Main: 10201001, Combine: 10202041 > Main: 62503002, Combine: 62504002 > Main: 66065001, Combine: 66065002, 66065003, 66067001, 66067002 > Main: 15100904, Combine: 15100008 > MAIN: 10120001 combine 10120901 > MAIN: 10120002 combine 10120902
 * **Burchett**
 * **Carlson**
 * **Cohen**
 * **Depkin**
 * **Duffy**
 * **Frisch**
 * **Furner-Brown**
 * **Gauthier**
 * **Hilliard**
 * **Marsico**
 * **McKinzie**
 * **Miller**
 * **Morgan**
 * **Page**
 * **Rivoli**
 * **Roeder**
 * **Rothe**
 * **Williams**
 * **Woodcock**

So far, coming up with a way to combine //different// courses and sections together into a single Edline courseID seems to be useful for
 * co-taught classes
 * dual-period Math and Reading/English classes
 * internships
 * lunches (//we could make the Cafeteria the "Lunch Teacher," and students could see upcoming menus, etc.)//

Initial Response, Clarification of Problem
From: Short, Hilary B.
 * Sent:** Tuesday, August 26, 2008 10:43 PM

Getting grade reports to the right student, in the right spot is currently dependent on both the student’s ID (//the same three letters and three numbers that they use for SWIPE and to login to computers)// and the Class ID //(a combination of the course and section numbers in SILK).//

If the Class ID is changed, when you export results to Edline, it’ll fail, because Edline won’t know which Class website to attach the reports to. (Parents checking grades click on the Class, and then click on the Grade Report for that class—grade reports have a StudentID so that only that student and the student’s parent can see it on the class website—make sense?) That's why co-taught students, who have a different course number and section number than the main course, must be kept separate in the gradebook.


 * SHORT EXPLANATION:** nope, no fix at this time. You can mess with the Class Title all you want to change the order of classes in your gradebook, or differentiate “Algebra II Pd 3” and “Algebra II Pd 3co” for example, but don’t touch the Class ID (1012006)—it’ll cause all sorts of errors when I try to upload student schedules, and when you try to export grade reports, if you do. Copying and pasting kidlets will just result in them being Withdrawn from one class, and added back to the other one in your gradebook—every time you Sync or try to upload reports, you’ll have to re-do the copying and pasting of students…

If you’re interested in tackling data Syncs and getting them better, though, I’m REALLY eager to find a person/group to take over Edline schedule imports some point later in this semester (once I know what I’m doing!)—I’ll train you, support you, cheer you on…


 * LONGER EXPLANATION:** At the moment, co-taught courses need two different IDs (course number and section) in SILK. To generate the Course ID in Edline, I just concatenate the course # and section #. Students (and parents) are identified by the student’s accountID (HND002, for example).

When schedules are uploaded into Edline, I export the data out of STARS (which is supposed to pull it perfectly from SILK—ha!), reformat slightly, and import it into Edline. One student’s schedule, therefore, might look like this in my data file:

HND002 10611002 HND002 HR23 HND002 10203301 HND002 98922112 HND002 1022901 HND002 1060021

Right now, the only modifications I'm making (//time-wise//) are simple ones.
 * 1) a. delete lines that contain “HR” in the CourseID# column (so that Homerooms don’t show up in gradebooks)
 * 2) b. delete lines where the value in the CourseID# column starts with 989 (which removes Early Release and Lunch from the student’s display screens).

The only way I could come up with to handle co-taught classes would be to create a lookup table or script of some sort, which is //way// beyond my Excel comfort level. For example, once I’ve got the final list, the script would…

replace(10611002, 10611001) - //so instead of appear in the co-taught section 2, the student would appear in section 1// replace (1061104, 1060021)

Essentially, it would go through the final list of courses and rewrite the main course number over top of the co-taught course number. The problem is, I couldn’t figure out a way to automate that process, or create the list of co-taught classes, before we started Teacher Week, so I abandoned it. It was more important to try to update schedules at the end of each day than fix the co-taught folks (I know that sucks for co-teachers, but there’s only so much time I’ve got…)

That’s probably way more information then you needed/wanted to know, but I hope it explains where I’m at now with co-taught classes [it’s a known frustration]. If I (or anyone else interested in working on it) can figure out a way to automate the combination of co-taught classes in the Edline schedule import, we’ll still need to


 * investigate what that does to pages teachers have already created for co-taught classes in Edline
 * investigate what that does to gradebooks already Syncing with Edline

Does it withdrawal all students in the co-taught class and add them to the main course—great, the teacher can just copy and paste grades…BUT, if it deletes the co-taught class completely, I don’t want folks grades to disappear (it’s unlikely this’ll happen, but I don’t want a bunch of teachers beating me to death with chairs because I erased half a class’s grades—by accident.)

If we can figure out a way to do that, we could let everyone know what’s coming, what they need to do, and go for it. I’m not sure it’s feasible, to be honest.

I totally welcome any thoughts or ideas you have about another way to handle co-taught classes—I know it’s annoying that they seem to exist in SWIPE and STARS and Edline as separate universes…

Hilary

Concern/Problem

 * From:** Rivoli, Amy M.
 * Sent:** Tuesday, August 26, 2008 4:24 PM
 * To:** Short, Hilary B.

Is the ability for students/parents to access their grade/attendance for their classes dependent upon their ID AND Class label/id provided through edline?
 * Overall Questions to be answered**

Since the title shown on our class list is unalterable (Algebra II for example for ALL my Algebra II classes), is it possible for students to still be able to access their grades etc if I create a new class (with name Per 2 for example) and copy the students into that new class (from Algebra II to Per 2) since when you copy their Id is transferred over (as well as their grades etc if you so choose)? Or Will I need to keep them under that generic Algebra II since the class code/section is embedded somehow? Is there a way to put the class code/id into a newly formed class list? This question also applies to two-section classes (i.e. co taught).
 * Situation to explain Question to be answered**

Amy M. Rivoli Mathematics Teacher Kenwood High School 410-887-0153 x487