tag:blogger.com,1999:blog-55084992811732235812024-02-19T17:31:41.143-08:00Mr. Hyland's Professional BlogWhere I can show off our efforts this year!Mr. Hyland 98http://www.blogger.com/profile/15284487572276213986noreply@blogger.comBlogger39125tag:blogger.com,1999:blog-5508499281173223581.post-19964170475343759912016-03-15T08:37:00.001-07:002016-03-15T08:47:51.098-07:00Testing something out. not working yet.<html>
<head><title>snook.ca load document</title>
<script language="JavaScript">
<!--//
function loadworddoc(){
// creates the word object
var doc = new ActiveXObject("Word.Application");
// doesn't display Word window
doc.Visible=false;
// specify path to document
doc.Documents.Open(document.all.hello.value);
//copy the content from my word document and throw it into my variable
var txt;
txt = doc.Documents(document.all.hello.value).Content;
//document.all.myarea.value = txt;
document.all.tbContentElement.DOM.body.innerHTML = txt;
// quit word (very important or you'll quickly chew up memory!)
doc.quit(0);
}
//-->
</script>
</head>
<body>
<p><input type=button onClick="loadworddoc();" value="Load">
<p><input type=file name=hello>
<p><textarea name=myarea cols=50 rows=5>nothing here yet</textarea>
<object ID="tbContentElement" CLASS="tbContentElement"
CLASSID="clsid:2D360201-FFF5-11D1-8D03-00A0C959BC0A" VIEWASTEXT
width="450" height="300">
<param name=Scrollbars value=true></object>
</body>
</html>Mr. Hyland 98http://www.blogger.com/profile/15284487572276213986noreply@blogger.com0tag:blogger.com,1999:blog-5508499281173223581.post-18887082775289793732016-02-11T09:18:00.001-08:002016-02-11T09:18:07.574-08:00How to: Pull a CAASPP Accommodations Query from SEISFor my department and perhaps others who need to prepare and verify student accommodations for state CAASPP testing I have recorded here a procedure to setup a query from the Special Education Information System (SEIS) that will give all the information needed. Once you have set up this query, you can save it for next year. <br />
<br />
Here goes:<br />
<br />
<ul>
<li><b>Step 1: Search</b> -- After logging in to SEIS, find the "search for students" link on the left side-bar of your home screen (see below right). Click that link and you come to a new screen asking for "Search Filter" and "Columns to Show". </li>
<ul>
<li>Search Filter allows you to select only the names you want, which could be useful if you wanted only the 12th graders graduating or only the 11th graders potentially moving to a Transition program, etc.</li>
</ul>
</ul>
<br />
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: right; margin-left: 1em; text-align: right;"><tbody>
<tr><td style="text-align: center;"><a href="https://drive.google.com/uc?export=view&id=0BwlkQbS8OMbKZVdjX05yZHlTbnM" imageanchor="1" style="clear: right; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><img alt="Create a Query in SEIS" border="0" height="320" src="https://drive.google.com/uc?export=view&id=0BwlkQbS8OMbKZVdjX05yZHlTbnM" title="Search For Students" width="173" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">This could be useful.</td></tr>
</tbody></table>
<ul>
<li><b>Step 2: Filter</b> -- For today's CAASPP data, I put the first filter to "Case Manager" is like "Andrew Hyland" by clicking the drop down menu and scrolling down to case manager (Marked "1" and "2" in the picture below left). </li>
<ul>
<li>Nearly every box on the IEP is listed in the drop down box in alphabetical order, so the first time you create a query there will be a lot of scrolling (don't use your touch-pad chromebook unless you have to!). </li>
</ul>
<li><b>Step 3: More Filter --</b> Another filter I used for this was to click the "Not" box and select "grade level" and use Shift+click to select all the grade levels 9 and below (Marked "3" in the picture below).</li>
<ul>
<li>This was because CAASPP is done by credits, so we need to include 10th, 11th, and 12th graders from the SEIS list just incase their credits put them eligible for SBAC or the 10th grade Science test. (It's doubtful to me that 9th graders would be credit-eligible for the 10th grade Science, but it could happen.)</li>
</ul>
</ul>
<a href="https://drive.google.com/uc?export=view&id=0BwlkQbS8OMbKMUZwd3pzWmZlblU" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="193" src="https://drive.google.com/uc?export=view&id=0BwlkQbS8OMbKMUZwd3pzWmZlblU" width="320" /></a><br />
<ul>
<li><b>Step 4: Columns</b> -- Anyway, now the filter is set. Next, select what information you want to pull from SEIS. Each drop box in the "Columns to Show" section (marked "4" above) will be a column in the report you create. I scrolled through and picked the information I needed for CAASPP, shown below right. To add columns, simply click the green plus sign (marked "5" above).</li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://drive.google.com/uc?export=view&id=0BwlkQbS8OMbKQmtrOHRKeVNLYUU" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="320" src="https://drive.google.com/uc?export=view&id=0BwlkQbS8OMbKQmtrOHRKeVNLYUU" width="256" /></a></div>
<div>
<ul><ul>
<li>Quite a bit of scrolling through options, but we only have to do it once. The order of your choices from top to bottom ends up being the order of your data columns from left to right. So, be careful to put things in the order you want.</li>
</ul>
<li><b>Step 5: Save and Print </b>-- Click "Search" at the bottom of the page and you get to the results page which previews the students and data columns you've selected. From here you can name the query and save it as marked in the picture below. Then select print.</li>
<ul>
<li>You are almost done, but I'll mention that there are some powerful options on this page. You can print only a sub-set if you don't need every name in the data (check the boxes next to the names you want to print and save some paper!) </li>
</ul>
</ul>
<div>
<br /></div>
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://drive.google.com/uc?export=view&id=0BwlkQbS8OMbKcHBwd01RNEUyUTg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="244" src="https://drive.google.com/uc?export=view&id=0BwlkQbS8OMbKcHBwd01RNEUyUTg" width="640" /></a></div>
<br />
<br />
<ul>
<li><b>Step 6: Group and Sort</b> -- After saving the query for next time and clicking print, the next screen asks you how you want to group and sort the data on the printed page. For this situation, I told it to group by grade level and did not sort. </li>
<ul>
<li>If the admin. pull a large amount of data, they could group by case manager and then sort by grade level. Or, you could sort by participation in CAASPP and it would place the kids who have accommodations on top of the list for you (otherwise it's just an alphabetical list).</li>
</ul>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://drive.google.com/uc?export=view&id=0BwlkQbS8OMbKT19uYjJMV2xzNmc" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="112" src="https://drive.google.com/uc?export=view&id=0BwlkQbS8OMbKT19uYjJMV2xzNmc" width="640" /></a></div>
<div>
<br /></div>
<br />
<br />
<ul>
<li><b>Step 7: Print</b> -- Just like you do for SEIS, click print and wait for the pdf to load. Print as usual. Repeat for next year.</li>
</ul>
<div>
Enjoy, I hope this helps and came in time for this year's testing.</div>
Mr. Hyland 98http://www.blogger.com/profile/15284487572276213986noreply@blogger.com0100 W Monte Vista Ave, Vacaville, CA 95688, USA38.3602063 -121.995995338.3570933 -122.0010378 38.3633193 -121.9909528tag:blogger.com,1999:blog-5508499281173223581.post-73584284030852876072015-04-19T12:52:00.003-07:002015-04-19T12:52:51.098-07:00How to: Email your Teachers from a Form SubmitI lost about an hours worth of typing and pictures in this post, so I'm going to type up another quick version that won't be as cool. Trust me, it was awesome.<br />
<div>
<br /></div>
<div>
<a class="g-profile" href="https://plus.google.com/108938665796461106186" target="_blank">+Ken Daniels</a> asked me about making autoCrat (Thanks for this awesome tool, <a class="g-profile" href="https://plus.google.com/114670488345865665282" target="_blank">+Andrew Stillman</a> and the New Visions School team), the awesome sheets add-on, email his teachers at his school. I don't know his particular situation--when I set my version of this up, it was to invite teachers to a meeting based on a student's schedule. So there was a lot of tables and looking up going on.</div>
<div>
<br /></div>
<div>
The easiest way is to have the user enter the email addresses into the form you are using to collect data, but I hate having users make mistakes and also having them manually look up and retype stuff that the computer should do for us.</div>
<div>
<br /></div>
<div>
Here's my solution:</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTTOuX65t7Oc-jyHK1xDMYUesguCbdeY2blUn7xypMYfpbTy2q6eMX23Fm8s-QrG_2bG4MhtfIWbCoEUheaBRAwwSViPt-tyoszkOhwZLl2n3x-xlAvvwV6jPNK9hwsEs1gLEr9vtqgLA/s1600/Screenshot+2015-04-10+at+11.22.34+AM.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTTOuX65t7Oc-jyHK1xDMYUesguCbdeY2blUn7xypMYfpbTy2q6eMX23Fm8s-QrG_2bG4MhtfIWbCoEUheaBRAwwSViPt-tyoszkOhwZLl2n3x-xlAvvwV6jPNK9hwsEs1gLEr9vtqgLA/s1600/Screenshot+2015-04-10+at+11.22.34+AM.png" height="140" width="320" /></a></div>
<div>
AutoCrat will run off of a form submit now, so that's cool and that's how I'll use it here. I like to make the form as simple as possible. I've made a <a href="https://docs.google.com/forms/d/1BaaJ1NHB79hI2fVL3L1ayrC1SCy1O6IPImpb8ZD9QaU/viewform" target="_blank">sample one</a> that collects the teacher's name. </div>
<div>
<br /></div>
<div>
You'll need a spreadsheet list of teacher email addresses to look up from and the names you get from the form submit should be exactly the same (that's another problem altogether). Again, when I used this type of thing, there was a step in between where my form collected student data and then looked up teacher names and teacher emails based on that (student names are much less prone to errors in my experience since teachers are used to entering them exactly--or you could easily use the student id number which reduces potential for error a bunch). Here's<a href="https://docs.google.com/spreadsheets/d/1ZEvhEgBGCE2OXm5ES2AM8Q1ptQp-N5ETUc3FiLlmrBk/copy" target="_blank"> a sample</a>.</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjtMRjo0fl7jIEGCBBkKKDbtzj8QhX-NXhD3I9_ku4XyPe7ED8ea2A1cV9W4MdjzgIU2XNo_rbnhKOdkpwupC41TaMCk7nfbyjSNIK77v-IPOw1Fis-njAD1m-bjV5kOiMDrY3nCD2D9b0/s1600/Screenshot+2015-04-10+at+11.15.39+AM.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjtMRjo0fl7jIEGCBBkKKDbtzj8QhX-NXhD3I9_ku4XyPe7ED8ea2A1cV9W4MdjzgIU2XNo_rbnhKOdkpwupC41TaMCk7nfbyjSNIK77v-IPOw1Fis-njAD1m-bjV5kOiMDrY3nCD2D9b0/s1600/Screenshot+2015-04-10+at+11.15.39+AM.png" height="118" width="320" /></a></div>
<div>
In my email sheet, I've exported the complete addressbook from Outlook for my school site. To help the look up, I've made the leftmost column into a list of the teacher names in the same format as the teacher names appear in our student database. There's a couple ways to do that, I currently prefer the =JOIN() command until I learn a better method.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWvGu_Ev7lnit2meLnIB2rYldN0E4dHiuOfcGb5W32GJtBXVkq34JaANBOr1cvhDCrgNjAIgf_IcbcDSyMLFC9szRZUAAW_xOCJkKzCsCdzfTYK-mKfXsDcPHXNFqZXtD3Jq3EVdD37ko/s1600/Screenshot+2015-04-10+at+11.16.49+AM.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWvGu_Ev7lnit2meLnIB2rYldN0E4dHiuOfcGb5W32GJtBXVkq34JaANBOr1cvhDCrgNjAIgf_IcbcDSyMLFC9szRZUAAW_xOCJkKzCsCdzfTYK-mKfXsDcPHXNFqZXtD3Jq3EVdD37ko/s1600/Screenshot+2015-04-10+at+11.16.49+AM.png" height="261" width="320" /></a></div>
<br /></div>
<div>
<br /></div>
<div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmXHMCui91KWDhwCjAgaIDHjw19_2rJMuCMtK464LVwTOYHIq-7RzlRz_thXqp1UgSbs4CMKvTU7WcWI6hUaxhEqcbB6vwlw_0XBUjilXw928WMnS2oRhX37_XGLrglfzrO8auxatBav0/s1600/Screenshot+2015-04-10+at+11.18.04+AM.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmXHMCui91KWDhwCjAgaIDHjw19_2rJMuCMtK464LVwTOYHIq-7RzlRz_thXqp1UgSbs4CMKvTU7WcWI6hUaxhEqcbB6vwlw_0XBUjilXw928WMnS2oRhX37_XGLrglfzrO8auxatBav0/s1600/Screenshot+2015-04-10+at+11.18.04+AM.png" height="77" width="320" /></a>Then I made a named range from the columns. Technically for this lookup, you only need two columns--however, you could also do this lookup from a much bigger table if you needed. The named range makes it easier to write the formula for looking up emails, and allows you to add or subtract staff members each year as people retire/get hired without having to go back and manually change every single formula.</div>
<div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEic2BqS6BP4p-aZrUp2ILKykrMLo3oSGrk9PgFXfs2Cvt-uoVNiuyi4kT1X7lhOKeqhszoC5nnycwijroI-Jv3cK1E93sixNHGOlryXXLFC0uvYyTVy0dbU0AIJTMV8PZ1BKrKqODOdWFo/s1600/Screenshot+2015-04-10+at+11.19.46+AM.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEic2BqS6BP4p-aZrUp2ILKykrMLo3oSGrk9PgFXfs2Cvt-uoVNiuyi4kT1X7lhOKeqhszoC5nnycwijroI-Jv3cK1E93sixNHGOlryXXLFC0uvYyTVy0dbU0AIJTMV8PZ1BKrKqODOdWFo/s1600/Screenshot+2015-04-10+at+11.19.46+AM.png" /></a></div>
<div>
When you connect a form to the sheet, it will create a new sheet. As each response is listed, it will erase all data in the newest row. This means that any neat formulas you have in the response collection tab will be deleted every single time someone submits a response. The way to deal with this that I've found has been to make another sheet and use the =IMPORTRANGE() command. Images below. </div>
<div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUwDYbjPSBugvwNfyCh_D7nb8pPm7eMrqRSyiTI8f4GMsm6Jxi4zjWsSRgdTr04XicmgEEGFiVZnEjb-oHJsVv6YYDqf5ih-pGufi_ug7HGT-vs1qmYdYbNY9djYDnbEu-7SuqwXb0t1Y/s1600/Screenshot+2015-04-10+at+11.24.17+AM.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUwDYbjPSBugvwNfyCh_D7nb8pPm7eMrqRSyiTI8f4GMsm6Jxi4zjWsSRgdTr04XicmgEEGFiVZnEjb-oHJsVv6YYDqf5ih-pGufi_ug7HGT-vs1qmYdYbNY9djYDnbEu-7SuqwXb0t1Y/s1600/Screenshot+2015-04-10+at+11.24.17+AM.png" height="133" width="320" /></a></div>
<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgH6MdW8PU4dKKU5f8n1lochvHF4T_6dRUfDiqbNH8TC4K71U-wflyofpU_j3mT3ALYXWthJOJkQnNXnltgJR16U-MUecacSDF78SaevN8rgIGpv2xXTqsBi-4HSSqeIurDJrjEdTHSZPk/s1600/Screenshot+2015-04-10+at+11.26.40+AM.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgH6MdW8PU4dKKU5f8n1lochvHF4T_6dRUfDiqbNH8TC4K71U-wflyofpU_j3mT3ALYXWthJOJkQnNXnltgJR16U-MUecacSDF78SaevN8rgIGpv2xXTqsBi-4HSSqeIurDJrjEdTHSZPk/s1600/Screenshot+2015-04-10+at+11.26.40+AM.png" height="308" width="320" /></a></div>
<br />
<div>
Once the range is imported, it will auto-update with new submissions and it will allow you to make formulas in the columns to the right of your imported data. Now we can lookup effectively. </div>
<div>
<br /></div>
<div>
After importing the range, I make a column that includes teacher name data exactly as it appears in the email lookup sheet. See the =JOIN command below. In the next colunn, I've used a =VLOOKUP command to lookup the perfectly formatted teacher name in our named range at column 6 (where the emails are sitting).</div>
<div>
<br /></div>
<div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhQhjCJKgnPD82S0-1o3qw7pGMsnVgIPnSum_RCHa3zWva-sB21tnEPnewqZhsgYEgU2hI6sEoCcXIVHTkYGxRSpLiC1NllexjKYMQNswwY33rinUArAgExt5OO3d_Z29K_pX70rXlLAc/s1600/Screenshot+2015-04-10+at+12.47.00+PM.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhQhjCJKgnPD82S0-1o3qw7pGMsnVgIPnSum_RCHa3zWva-sB21tnEPnewqZhsgYEgU2hI6sEoCcXIVHTkYGxRSpLiC1NllexjKYMQNswwY33rinUArAgExt5OO3d_Z29K_pX70rXlLAc/s1600/Screenshot+2015-04-10+at+12.47.00+PM.png" height="77" width="320" /></a>You can look up any of these commands with the google help file and it explains pretty clearly all the options and parameters for each.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDPx1ZepjnNszchuaVa3b2XRxxr6oZpxJiwk9Ljy6AzD7s7hHzbTowOQ4GTFEw2xn-sii10dK9MsV7oHlp80myQjasFOaPj8Bh5sXqYZuSwIsa3qCtk6hc98GStBy8chhYqbVygZztBfU/s1600/Email+Lookup+Formulas.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDPx1ZepjnNszchuaVa3b2XRxxr6oZpxJiwk9Ljy6AzD7s7hHzbTowOQ4GTFEw2xn-sii10dK9MsV7oHlp80myQjasFOaPj8Bh5sXqYZuSwIsa3qCtk6hc98GStBy8chhYqbVygZztBfU/s1600/Email+Lookup+Formulas.png" height="208" width="640" /></a></div>
</div>
<div>
<br /></div>
<div>
I like to wrap my formulas with =IF(ISTEXT(), my current formula, "") so that I can copy down the formula to all cells in the column and it won't display errors and #N/A and be ugly.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-GQX1aXPsYqXEZhcVgaHI9BCP6U0LGyf21ia8Km53et4sCIOQ0pqhK0I5DA_hY8wlyseOm7s0VH3DDEmCaj62WCiHXu6zWwlWyySU54vFhGE1jQtqqLB-8evpsBhJaI6Qq4Aax1tmlyc/s1600/If+IsBlank+Conditional.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-GQX1aXPsYqXEZhcVgaHI9BCP6U0LGyf21ia8Km53et4sCIOQ0pqhK0I5DA_hY8wlyseOm7s0VH3DDEmCaj62WCiHXu6zWwlWyySU54vFhGE1jQtqqLB-8evpsBhJaI6Qq4Aax1tmlyc/s1600/If+IsBlank+Conditional.png" /></a></div>
</div>
<div>
<br /></div>
<div>
Getting autoCrat to email is now simple, you can have it send an email to multiple recipients or whatever you want using the dollar tags (for example: $emailAddress ) as one of the options in that add on. each time a response is submitted, autoCrat will run and fill in the email with whatever you tell it and send to all the dynamically changing emails that pertain to your current submission. I find this to be a little bit of extra work, but it avoids the problem of hard-coding a bunch of emails that will eventually change.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjeJZGyl_dM_ydM-rBSME92xIuHNrBnn0AyJdH1WWyWO2JzRgX3b01nUpN3SDJjc8UeLq2S3uDi-qLQYD2XmfcAB49sMuv_AGksDGpq4QgMfqIrmRLvzmAIBzSfYz4Wn5R7OwZrnlDTpCM/s1600/Getting+Autocrat+to+Email.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjeJZGyl_dM_ydM-rBSME92xIuHNrBnn0AyJdH1WWyWO2JzRgX3b01nUpN3SDJjc8UeLq2S3uDi-qLQYD2XmfcAB49sMuv_AGksDGpq4QgMfqIrmRLvzmAIBzSfYz4Wn5R7OwZrnlDTpCM/s1600/Getting+Autocrat+to+Email.png" height="240" width="320" /></a></div>
I hope this is helpful to Ken and anyone else who might need it. I know it's a down and dirty version, and it will help if you've got a mid-level familiarity with excel/spreadsheet functions. i.e., this "guide" is not very newbie friendly, but here it is.<br />
<br />
I know if Ken needs anymore support on it, we'll end up with a GHO and I'll attempt to record that and link it here as well if we get there.</div>
Mr. Hyland 98http://www.blogger.com/profile/15284487572276213986noreply@blogger.com0tag:blogger.com,1999:blog-5508499281173223581.post-48781597059907969572015-03-31T07:00:00.000-07:002015-03-31T07:00:05.654-07:00VPEF Grant Thank Yous from My Class<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; margin-right: 1em; text-align: left;"><tbody>
<tr><td style="text-align: center;"><a href="http://2.bp.blogspot.com/-mP6d2GeezoQ/VRhl-weZU0I/AAAAAAAAkyU/fjiAQjDQdeY/w1158-h865-no/IMG_0358.JPG" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><img border="0" src="http://2.bp.blogspot.com/-mP6d2GeezoQ/VRhl-weZU0I/AAAAAAAAkyU/fjiAQjDQdeY/w1158-h865-no/IMG_0358.JPG" height="149" width="200" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Typing our essays on student desktop, <br />
Chromebook, and hand written.</td></tr>
</tbody></table>
Earlier this school year, I applied for and was granted some generous funds for my classroom. We were able to acquire two more Chromebook laptops to bring my class's grand total of available student computers up to seven (or sometimes eight or nine depending on the old ones working properly that day!). In all, we have five Chromebooks now and those are nice for the students to use due to their speed and since my district set me up with google Classroom this semester. So overall, this grant has had a large impact on my classes. <br />
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: right; margin-left: 1em; text-align: right;"><tbody>
<tr><td style="text-align: center;"><a href="http://3.bp.blogspot.com/-a_KtsCCMrlE/VRhl-1fRNhI/AAAAAAAAkyU/jKJKtxy2zA4/w1358-h764-no/20150210_134407.jpg" imageanchor="1" style="clear: right; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><img border="0" src="http://3.bp.blogspot.com/-a_KtsCCMrlE/VRhl-1fRNhI/AAAAAAAAkyU/jKJKtxy2zA4/w1358-h764-no/20150210_134407.jpg" height="112" width="200" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Working on a Slide Presentation for <br />
Speaking and Listening Standards</td></tr>
</tbody></table>
<br />
<br />
I asked my students to write thank you notes to the Vacaville Public Education Foundation which granted the funds. It was not lost on them what kind of impact these added computers had for our class and I'm sharing a<br />
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; margin-right: 1em; text-align: left;"><tbody>
<tr><td style="text-align: center;"><a href="http://4.bp.blogspot.com/-E5gov-ybEZw/VRhl-4VcYcI/AAAAAAAAkyU/2wg6Ux5PGO8/w1158-h865-no/IMG_0356.JPG" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><img border="0" src="http://4.bp.blogspot.com/-E5gov-ybEZw/VRhl-4VcYcI/AAAAAAAAkyU/2wg6Ux5PGO8/w1158-h865-no/IMG_0356.JPG" height="149" width="200" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Part of our class writing essays.</td></tr>
</tbody></table>
handful of their notes here. Here's one below, and<a href="https://docs.google.com/document/d/1Ak_lukiXpgYtGmCXI6JyzVB6yne8eyxhR1Eldpq_s7I/pub" target="_blank"> links</a> to <a href="https://docs.google.com/document/d/1Bzs8vCnkzS1Y4GcKz81dF--hs7M23P4xKQoVEqQb6cQ/pub" target="_blank">some</a> <a href="https://docs.google.com/document/d/15poS0MA0S-w8ssqQjDdZmex0v6K1-3GuAnuksQYAVy0/pub" target="_blank">more</a> from the class.<br />
<iframe src="https://docs.google.com/document/d/1kfxGDnfvK65uO7-XGOUsOqPm7BwAwbK4Dz_fyPaaVp4/pub?embedded=true" width="650"></iframe><br />
<br />
Here are some of the projects we worked on using these computers this year:<br />
<br />
<ul>
<li>A class <a href="http://padlet.com/mrhyland98/WhereImFrom" target="_blank">Padlet</a> page "Where I'm From" poem.</li>
<li>A<a href="https://docs.google.com/presentation/d/1jiAH46fhr31Nx7mQaiOdVNGeoNd3_mvu2s1jnvqMLg0/pub?start=false&loop=false&delayms=5000" target="_blank"> Slide </a> <a href="https://docs.google.com/presentation/d/17qDPN0h6cV84OoIH4IbZFwNn3r1YVmPSHgC_6w2HttQ/pub?start=false&loop=false&delayms=5000" target="_blank">presentation</a> for <a href="https://docs.google.com/presentation/d/1xgN1Y6pDsmUL0e8LjVQwdoH6XZHUcYZ2MVjstexOomg/pub?start=false&loop=false&delayms=5000" target="_blank">Speaking</a> and <a href="https://docs.google.com/presentation/d/1_nciSpXwpRkxyv7XZLRLnm29gJVeI-mT_HUNU87i0WA/pub?start=false&loop=false&delayms=5000" target="_blank">Listening </a>skills.</li>
<li>Some shared brainstorming ideas, in preparation for our essays--here's one:</li>
</ul>
<br />
<br />
<iframe src="https://docs.google.com/document/d/1Ww7Uu6ryEgq9md7RXmDpaZnE9RmuT06bL7GVLU63_mY/pub?embedded=true" width="650"></iframe>
<br />
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: right; text-align: right;"><tbody>
<tr><td style="text-align: center;"><a href="http://1.bp.blogspot.com/-2orCvALJK1k/VRhl-w5SjEI/AAAAAAAAkyU/lQ3fJugO610/w1358-h764-no/20150210_151351.jpg" imageanchor="1" style="clear: right; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><img border="0" src="http://1.bp.blogspot.com/-2orCvALJK1k/VRhl-w5SjEI/AAAAAAAAkyU/lQ3fJugO610/w1358-h764-no/20150210_151351.jpg" height="112" width="200" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Starting my first google Classrooms.</td></tr>
</tbody></table>
For the writing assignments, I was able to use google Classroom thanks to <a class="g-profile" href="https://plus.google.com/112083500317521513414" target="_blank">+Dawn Marsh</a> at the district office who set up my classes as part of the pilot this semester!<br />
<br />Mr. Hyland 98http://www.blogger.com/profile/15284487572276213986noreply@blogger.com0Vacaville High School, 100 West Monte Vista Avenue, Vacaville, CA 95688, USA38.3601883 -121.9960780000000112.838153799999997 -163.304672 63.882222799999994 -80.687484000000012tag:blogger.com,1999:blog-5508499281173223581.post-7939070612119217292015-03-28T06:30:00.000-07:002015-03-28T06:30:00.870-07:00Batting Order Rotation<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-xSGWZEel9Zk/VRY4ewwUd-I/AAAAAAAAkpQ/EyqMvHXC_rw/w346-h489/20150327_155435~2.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-xSGWZEel9Zk/VRY4ewwUd-I/AAAAAAAAkpQ/EyqMvHXC_rw/w346-h489/20150327_155435~2.jpg" height="320" width="226" /></a></div>
Thanks to <a href="http://stackoverflow.com/questions/1985260/javascript-array-rotate" target="_blank">this code</a> that I borrowed, I was able to create a batting order rotator for my son's Tee Ball team.<br />
<br />
You can see it in action <a href="http://vhshyland.blogspot.com/2015/03/blog-post.html" target="_blank">here</a>.<br />
<br />
I can see how this might be useful for elementary classes that want to rotate line leader and class jobs frequently through the day etc. etc. and also possibly in high school for seating charts (although there's other programs for that--usually attached to your grade book program) or for lab work in science class and things of that nature.<br />
<br />
It surely would have taken me 1000 years of study to get to those few lines of code in JavaScript to rotate an array (the ones in there with the % sign I think are the trick, if I understand what I'm looking at!). I was doing it just fine in a spread sheet thanks to <a href="https://youtu.be/HCmsJAfe6t8" target="_blank">this video</a>, however, pulling from a live spreadsheet and displaying on a web page was beyond my skills at the moment and seemed like too many steps. Then I thought I could create an array pretty easily in JavaScript and it should be a sinch to essentially follow the same neat procedures from that youTube video to lookup the correct index for each new batter.<br />
<br />
<br />Mr. Hyland 98http://www.blogger.com/profile/15284487572276213986noreply@blogger.com0tag:blogger.com,1999:blog-5508499281173223581.post-38760137229831633562015-03-19T07:00:00.000-07:002015-03-20T10:32:28.367-07:00Sci Fi book choices for 12th gradeAbout a year ago, I sent a request out for some Sci Fi books for 12th graders to read as part of their unit in short stories. Here's a <a href="http://www.rbhyland.org/2014/04/12/best-sci-fi-short-stories/" target="_blank">link</a> to that post on a different blog which is worth taking a look at just for the few titles I collected in the comments.
I've copied the post below:
<br />
<blockquote style="background-color: white; color: #555555; font-family: Verdana, 'BitStream vera Sans', Tahoma, Helvetica, sans-serif; font-size: 12px; line-height: 17.3999996185303px; margin-bottom: 10px; padding: 0px;">
J’s 12th grade co-teach class is going to do a unit on science fiction short stories and wanted a list of a few good ones. So I’m posting here to get some titles.<br />
I suggested Arthur C. Clarke’s Nine Billion Names of God and Asimov’s Nightfall. I also gave some authors: Zelasny, Heinlein, L. Niven, a couple others.<br />
Nightfall is hardly short at 300+ pages but it fits the genre in other ways.<br />
Any other suggestions from folks?</blockquote>
It's that time of year again, so I've got a couple of students asking me for more suggestions. I emailed this same list to them and I'll again ask for suggestions this year so I can have a wider list every time I send it out.<br />
<br />
Any more suggestions? -- I guess it doesn't have to be a short story, but that is the unit even though the focus for their assignment is on the Sci Fi part, not necessarily the short story part.Mr. Hyland 98http://www.blogger.com/profile/15284487572276213986noreply@blogger.com0Vacaville High School, 100 West Monte Vista Avenue, Vacaville, CA 95688, USA38.3601883 -121.9960780000000113.218085799999997 -163.304672 63.5022908 -80.687484000000012tag:blogger.com,1999:blog-5508499281173223581.post-64625567507074797022015-03-17T07:00:00.000-07:002015-03-17T07:00:01.450-07:00Making Technology Run SmoothlyI'm pleased that my question via Twitter made it in to <a href="https://twitter.com/techsavvyed?lang=en" target="_blank">@TechsavvyEd</a> 's #TechDirectorChat podcast segment last week!<br />
<div>
<br /></div>
<div>
Ben had asked for any questions from the gallery for a tech director. Being a lowly teacher and having had to deal with tech and tech departments, I know what I really wanted to ask and the way I might typically ask would not be productive for his venue. When I find myself complaining about my classroom situations specifically, especially when I'm in professional development (or on a twitter chat), I then try to flip my negativity around and ask a question from the opposite direction.</div>
<div>
<br /></div>
<div>
So for my question for Ben's Director, Pete, I tweeted this:<br />
<blockquote class="twitter-tweet" lang="en">
<a href="https://twitter.com/techsavvyed">@techsavvyed</a> hey tech dir., if you could tell us teachers one important thing to make tech run smooth, what would it be?<br />
— Andrew Hyland (@AndrewHyland) <a href="https://twitter.com/AndrewHyland/status/573170745083232256">March 4, 2015</a></blockquote>
Pretty vague and open. Ben and Pete both took a turn giving me an answer in his podcast. Skip ahead to 13:00 and listen to how well Pete and Ben interpret my vague wording and both give useful answers to help make working with tech in education a little less of the nightmare it can be on the worst days.<br />
<br />
Here's the <a href="http://shoutengine.com/TechDirectorChat/making-technology-run-smoothly-in-the-classroom-7627" target="_blank">Link</a>.<br />
<br />
Thanks <a class="g-profile" href="https://plus.google.com/100343688261448370014" target="_blank">+Ben Rimes</a> for the shout out and the thoughtful response. <br />
<br />
For the record, my original intent on the question was the way Pete interpreted it--making sure stuff just works correctly between version numbers, power, internet, all those moving parts. Ben's interpretation (tech integration into lessons) and answer were what I <i>should</i> have been asking!<br />
<script async="" charset="utf-8" src="//platform.twitter.com/widgets.js"></script></div>
Mr. Hyland 98http://www.blogger.com/profile/15284487572276213986noreply@blogger.com0Vacaville High School, 100 West Monte Vista Avenue, Vacaville, CA 95688, USA38.3601883 -121.9960780000000113.220127799999997 -163.304672 63.500248799999994 -80.687484000000012tag:blogger.com,1999:blog-5508499281173223581.post-39693889083066015692015-03-13T06:30:00.000-07:002015-03-16T10:38:41.432-07:00Shut off Spell Checker in Docs<div class="separator" style="clear: both; text-align: center;">
<a href="http://www.funbrain.com/spell/spell2.gif" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="http://www.funbrain.com/spell/spell2.gif" /></a></div>
<div class="tr_bq">
<span style="font-family: Arial, Helvetica, sans-serif;">This I just found and it might be useful in two or three applications:
You can shut off the spell checker in Google Docs. Most people are smarter than I am, and so probably already knew that. Here's the quote from the help page: </span></div>
<div class="tr_bq">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="tr_bq">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<blockquote style="background-color: white; border: 0px; font-size: 16px; line-height: 24px; margin-bottom: 1em; margin-top: 1em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Arial, Helvetica, sans-serif;">Spelling suggestions as you type</span><span style="font-family: Arial, Helvetica, sans-serif;">As you type, Docs automatically underlines in misspelled words in red. Right-click an underlined word to see the suggested correction and replace the misspelled word.</span><span style="font-family: Arial, Helvetica, sans-serif;">You can turn off the spell-checker by unchecking <span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-size: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Show spelling suggestions</span> from the <span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-size: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">View</span>drop-down menu</span></blockquote>
Click <a href="https://support.google.com/docs/answer/57859?hl=en" target="_blank">here</a> for the full page.<br />
<br />
There are two times I can use this:<br />
1) During an everyday type activity when I want students to focus on composing volumes rather than editing and fretting over perfection.<br />
2) During California Exit Exam proctoring when a very few number of my students have "use of a word processor with the spell checker turned off" written in as an accommodation during the testing. Then I can have them sign in to a convenient Chromebook without disrupting the other testers or having to arrange a second adult proctor to escort them to a separate place with a clunky desktop that may or may not work, or possibly has an older version of Word etc. etc.<br />
<br />
I hope this is useful for others too.Mr. Hyland 98http://www.blogger.com/profile/15284487572276213986noreply@blogger.com0tag:blogger.com,1999:blog-5508499281173223581.post-69849945658920620332015-03-05T16:00:00.000-08:002015-03-06T12:17:45.577-08:00Testing out embedding a chart.<iframe width="636" height="524" seamless frameborder="0" scrolling="no" src="https://docs.google.com/spreadsheets/d/1pldeHKufGZOOT9_O_NeGoGR_zHTE0lFwdenvbjhmvrU/pubchart?oid=259723155&format=interactive"></iframe>Mr. Hyland 98http://www.blogger.com/profile/15284487572276213986noreply@blogger.com0tag:blogger.com,1999:blog-5508499281173223581.post-5049337882454871552015-01-03T07:46:00.001-08:002015-01-03T07:47:08.664-08:00All the MLK resources you'll ever need from Larry Ferlazzo. http://larryferlazzo.edublogs.org/2008/12/21/the-best-websites-about-martin-luther-king/Anonymoushttp://www.blogger.com/profile/15788073047805053237noreply@blogger.com0tag:blogger.com,1999:blog-5508499281173223581.post-54539319554802866772014-10-29T06:30:00.000-07:002014-10-29T06:30:03.308-07:00Class Poem on PadletJust recently, while attending the Fall CUE conference at American Canyon High School, I learned about a neat tech tool called padlet. This website allows a teacher to create a digital posterboard for the classroom. This way, your poster (created by you or, in this case by my students) can stay forever as part of their digital portfolio instead of disappearing from my limited wall space during the next unit.<br />
<br />
I'm pleased to share what my class came up with today as part of our unit on Cultural Identity.<br />
<br />
<a href="http://padlet.com/mrhyland98/WhereImFrom" target="_blank">Our Class Poem</a><br />
<br />
Enjoy.Mr. Hyland 98http://www.blogger.com/profile/15284487572276213986noreply@blogger.com0Vacaville, CA, USA38.3565773 -121.987744438.256974299999996 -122.1491059 38.4561803 -121.8263829tag:blogger.com,1999:blog-5508499281173223581.post-74996535841175000182014-10-28T07:00:00.000-07:002014-11-01T10:49:02.164-07:00#FallCUE Day2 Report<div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhimH86FdkC8EJAP2TkhJp16KOYQKKlE2P0XvFZeEOFGgj5fCUMy6fctGU4liFbQq9Mjru9Xrx5eB5G8mfSjFM9pnsR7pJF9hkvGmwFmA0g4lN48SLDd7HjK7NX1TkRAWvhRZYhyXOvqj4/s640/blogger-image--1780607661.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhimH86FdkC8EJAP2TkhJp16KOYQKKlE2P0XvFZeEOFGgj5fCUMy6fctGU4liFbQq9Mjru9Xrx5eB5G8mfSjFM9pnsR7pJF9hkvGmwFmA0g4lN48SLDd7HjK7NX1TkRAWvhRZYhyXOvqj4/s640/blogger-image--1780607661.jpg" /></a>Well, the wifi seemed to be fixed for good and the lunch line was practically zero on Day 2, so I can give CUE and ACHS some props for at least fixing some problems quickly. Peter and I had selected our sessions late last night--we were ready to rock and our shared GDoc filled up fast with notes through the day. Next time I think I'll pick a time to have an empty session to run by all the vendors and see what's up quickly. This time we needed to maximize the info-grab. But a person can only process so much and implement so much each school year. </div>
<div>
Also for next time: sitting through keynotes and going to the meet ups before and after the con. </div>
<div>
In any case, here's what we saw and as always, notes are available upon request:</div>
<div>
<br /></div>
Session 6: CCSS <a href="https://docs.google.com/presentation/d/1hNqHZCQz-QEZlFSWEku0c-snW1HXmi2cKTx7drVUNak/present#slide=id.g26fb8bdb8_11" target="_blank">Techie Tool</a>s<br />
<a href="http://padlet.com/" target="_blank">Padlet</a> - digital posters for assessment. Don't need 1:1. I think I can use this one next semester for presentations and formative assessment. If you include an oral presentation piece it's even better. This could also be a strong tool in combination with QR codes at back to school night.<br />
<a href="https://audioboom.com/" target="_blank">Audioboom</a> - pod casting as class newsletter. Students write a script and record a podcast of what they've learned this week/unit. I think this was a public tool so train for your privacy needs. (No names on air, etc. )<br />
Infuse Learning -- assessment tool much like socrative. Quite a bit of prep up front so I don't see this one on my radar until next year.<br />
<br />
Session 7: <a href="http://ireflect.sccoe.org/view/view.php?id=3565" target="_blank">Formative Assessment</a> with mobile devices<br />
<div>
<a href="https://plickers.com/" target="_blank">Plickers</a> and <a href="http://edulastic.com/" target="_blank">Edulastic</a>-something as the two most reachable for me this year in public school with non 1:1</div>
<div>
He covered a lot and they are linked in the resources. Plickers is a tool where only the teacher needs a device to use--each student (or each table group) has a paper card (which you could laminate for repeated use). The cards are used for simple multiple choice selections, so there's a little bit of prep involved, and essentially what is happening is that your regular exit ticket or warm-up is now able to collect and display live data on who and how many in class are understanding the concept. The teacher has a digital record immediately of each formative assessment, so that's appealing to me. I could really use this in Special Education for IEP goal progress--the only down side is having to work around the multiple choice-style limitations. So I wouldn't use this for every single problem each day.<br />
<br />
Session 8: <a href="https://docs.google.com/presentation/d/1IV9CuZfKwIrn-wGeMhZJoXmgg5d9YlvUIi9X3gzVVtw/edit#slide=id.p" target="_blank">Special Education</a><br />
This session was aimed at General Education teachers and getting them to use tech as a way to integrate Special Education students into the mainstream with tech as a facilitator.<br />
<div>
An 8th grade teacher presented on student Blogging in lieu of written journaling--he said the majority of his students with special needs selected the online version and suspected it was due to not liking hand writing. Audio story problems were covered by an elementary teacher and I can see how I could use that in high school. Right now that would be a lot of extra prep for my class situation for a small number of applications. They presented a video produced by a student with autism to explain his condition. </div>
<div>
A nice thing about this session was that it was not focused on 1:1 and was presented by practical individuals in a situation that was closer to mine. So often I've been the only special educator in the room and even the only public school teacher in the room, or the only teacher at a school that's not going 1:1 iPads this year.<br />
<br />
(Session 9 -- I skipped and dealt with some housekeeping issues)<br />
Session 10: <a href="http://www.melissahero.com/#!citizen-science/cekj" target="_blank">Science mobile</a><br />
Since I'm co-teaching a Biology class this year, and I met Melissa Hero back at CUE Rockstar Tahoe, I had to go to this session and see what was up. The link to her resources is where all the action is at. By this point in the conference my entire brain was shot. Melissa covered several websites to use for data sets in life science classes since most of the well known resources are for earth science (I didn't know this, but now I do!). She covered several tools for elementary and for high school. I can definitely see how to integrate the iNaturalist website/app into my class later this year. I'm definitely going to look at for next semester. </div>
</div>
<div>
iNaturalist. <a href="https://twitter.com/mdhero" target="_blank">Melissa Hero</a> link.</div>
<br />Mr. Hyland 98http://www.blogger.com/profile/15284487572276213986noreply@blogger.com0American Canyon High School, 3000 Newell Drive, American Canyon, CA 94503, USA38.1674188 -122.238918712.9670448 -163.5475127 63.367792800000004 -80.9303247tag:blogger.com,1999:blog-5508499281173223581.post-39650539134624320462014-10-25T13:50:00.002-07:002014-10-25T13:55:22.758-07:00#FallCUE Day 1 ReportOn the first day of #FallCUE this is what we learned:<br />
American Canyon had insufficient bandwidth for the number of educators and their devices on campus this morning. By the afternoon, most problems were corrected--either people had logged off or connected to their phone's hot spot. (note: this was fixed by Saturday, I never found out what the issue was)<br />
Past that glitch in the beginning, there was much to learn. We went to 5 sessions and burned our brains out on google forms, scripts like form Ranger, green screen videos in the classroom, using add-ons to give students feedback on their writing, building my class website and embedding videos in google forms.<br />
<br />
I loaded up on plenty of apps, twitter people to follow, and the real winner of the day was the number of new methods for giving feedback on student writing. <br />
I found out that google classroom is only for schools with GAFE so it's not even worth looking at until I convince someone at my school to advocate the powers that be for that situation.<br />
<br />
Session 1 was a run down on automating your work flow with formRanger and formMule scripts (scripts by Andrew Stillman) presented by <a href="https://twitter.com/John_Eick" target="_blank">@John_Eick</a>. Here's a <a href="https://sites.google.com/site/johneickautomatedworkflow/home" target="_blank">link to his resources</a> which included a step-by-step screen shot of how to set up your documents and sheets. Very useful for a teacher who is new to this type of thing. This was the session where the wifi was the worst and got better at every session following this. John was a really energetic presenter and even I, a relative expert on Stillman's old scripts, learned a few tricks to use in practice.<br />
<br />
For session 2 and following, <a class="g-profile" href="https://plus.google.com/112876859090679035263" target="_blank">+Peter Hyland</a> and I split up to hit more sessions and because he had different goals for the PD since his classroom situation with technology is vastly different than mine. I went to John Eick's next session on embedding videos in google forms and Peter went to the Hour of Awesome.<br />
Embedding videos looks like a sweet way to have students take notes while watching a short video, then the teacher is able to quickly look at the notes and give some feedback on the quality of notes, etc. etc. There are about 3 uses I thought of in my classroom and the only limitation would be technology access. Could address that by "flipping" the model" and having those that are able do the video notes at home and others do it in class. That method would require some planning for the kids not actively taking notes in the classroom.<br />
Peter said the Hour of Awesome was awesome and his notes make it sound exciting. Ask me for the link and I'll share the notes with you. It covered multiple Google products and a few of the case uses for each that could speed up repetitive teacher tasks and improve the speed of student feedback.<br />
<br />
The theme of Day 1 was faster feedback to students. The teacher has to do a little more time consuming prep and setup on the front end, however it's worth it so kids get a faster and better idea of how they're doing with anything from writing to math to biology notes. Session 3 with <a class="g-profile" href="https://plus.google.com/106922720865427646541" target="_blank">+Kristina Mattis</a> (<a href="https://twitter.com/kristinamattis" target="_blank">@KristinaMattis</a>)for me covered some add-ons in google docs that allowed collaboration, composition, editing, and publishing of student work with more modes than just text. <a href="https://sites.google.com/site/fallcue2014/digital-badges-as-currency-for-learning-and-leading" target="_blank">Session 4</a> with <a class="g-profile" href="https://plus.google.com/110006162446433877739" target="_blank">+Cate Tolnai</a> (<a href="https://twitter.com/CateTolnai" target="_blank">@CateTolnai</a>) showed me some template examples of how to organize my course content around my class website. This will be most useful to me this year and next. Finally, I visited the <a href="https://sites.google.com/site/aroundtheworldin60min/" target="_blank">green screen</a> session and got another round of figuring out how to make some videos and--even more importantly--how to use this type of project in my classes to meet standards.<br />
<br />
Overall, an awesome day for information. The spotty wifi and long lunch line were not enough to dampen the good things soaking in to my brain. <br />
More reports later.<br />
<br />
<br />Mr. Hyland 98http://www.blogger.com/profile/15284487572276213986noreply@blogger.com0American Canyon High School, 3000 Newell Drive, American Canyon, CA 94503, USA38.1674188 -122.238918712.6453843 -163.5475127 63.6894533 -80.9303247tag:blogger.com,1999:blog-5508499281173223581.post-33722714341195896652014-10-22T06:30:00.000-07:002014-10-22T06:30:01.559-07:00Case Management Documentation and GAS Part 4I'm writing this down so I can remember why I did things the way I did when I have to go back and either fix it or make a new one somewhere else:<br />
<br />
"The less change the better" is a simple motto for some folks. I wanted to keep the new method (my form) of getting Gen Ed feedback as similar as possible to the old method, so I kept the same wording and the same order of questions. I simply lifted them on to a google form which will plop the answers down in a sheet that autocrat turns into a nice PDF that looks <i>identical</i> to the version we use now. The output keeping the same look is only important to me so that the admin and district people who are used to seeing our forms can feel comfortable. More important is that the "front end"--where the Gen Ed teachers look at it--looks as similar as possible. <br />
<br />
Here's where my problem arises: I have to add some pre-filled, superfluous "questions" to the form so that autocrat will spit out the the PDFs <i>exactly </i>how I want them while keeping the formatting customized to each student. Information such as student initials and case manager emails are easy for a spreadsheet to look up and calculate, however, this behind the scenes look up has to happen before the form submits to autocrat (without reworking my entire concept and workflow here). So I will make it part of my case-manager-side script, but that means that I have about 4 extra questions hanging off the end of my Gen Ed form.<br />
<br />
Perhaps I can find a way to make them invisible in the future, or end up reworking the entire work flow. For now, better to make a working product before getting ahead of myself. <br />
<br />
That's all for now.<br />
Links:<br />
Link to part 1<br />
Link to previous part<br />
Link to next partMr. Hyland 98http://www.blogger.com/profile/15284487572276213986noreply@blogger.com0Vacaville High School, 100 West Monte Vista Avenue, Vacaville, CA 95688, USA38.3601883 -121.9960780000000112.838153799999997 -163.304672 63.882222799999994 -80.687484000000012tag:blogger.com,1999:blog-5508499281173223581.post-3234644960171552742014-10-13T06:30:00.000-07:002014-10-14T12:07:33.043-07:00Case Management Documentation and GAS Part 3.5Part of being a Special Education Teacher is giving parents progress updates on goals at least as often as their non-disabled peers. At high school, that means once per quarter. So doing goal updates this week and next has put my side project on break for a minute. In spite of that, I was able to solve one small problem with my script. I was able to get the script to take the IEP date information (from whatever the case manager puts in) and have it spit out a pretty and formatted text string (instead of a weird date code that computers read!). This solves a little problem I was having at the tail end where the printout would show a long date string including time--which I didn't want on that piece of text.<br />
<br />
As an aside, goal updates are another beast that might benefit from some automation during certain parts of that process. That's a long term thought I'm letting simmer and cook on the back burner.Mr. Hyland 98http://www.blogger.com/profile/15284487572276213986noreply@blogger.com0Vacaville High School, 100 West Monte Vista Avenue, Vacaville, CA 95688, USA38.3601883 -121.9960780000000112.838153799999997 -163.304672 63.882222799999994 -80.687484000000012tag:blogger.com,1999:blog-5508499281173223581.post-62314213392681907452014-10-06T06:30:00.000-07:002014-10-21T19:45:09.533-07:00Case Management Documentation and GAS Part 3Well, moving forward on this project. I now have the script getting all the values from the case manager submitted form and then looking up successfully the course schedule for the student from a second spreadsheet of schedule data that I pulled from the Aeries student database. At some point that could be a live lookup, but for now it's dependent on a human to keep it accurate and up-to-date. <br />
<br />
Next, it pre-fills the course info and IEP meeting information on a form for the General Education teacher to fill out and emails the teacher with a link. When they click the link, it brings them to the feedback form already in progress with almost half the information already filled in. No longer do they have to fill in their own class and double check the IEP date and time. (of course, at this point the IEP could get rescheduled, but that should be a separate thing on their calendar for another project at a later time!)<br />
<br />
One item on my list is to make this Gen Ed version of the google form look slick and professional by using the school colors and logos now that Google allows us to customize their forms in that way. I'll get this pretty good looking before I show it to my Admin., but all that is cosmetic and the guts of the program currently work how their supposed to.<br />
<br />
The next step is an Autocrat PDF creation off of my template feedback form that I created about a year ago for VHS. I have 3 or 4 tweaks left on it at this point, until the Admin. sees it and offers changes.<br />
<br />
At this point I want to record for posterity the methods I used to dump my spreadsheet data. I had to go into MS Outlook and find my campus's "All Staff" email list. Then I added all the names on that list to my contacts in Outlook. This was in the Outlook program, not webmail like a lot of people like to use for outlook. When all the names are in your contacts, you can export your contacts as a .csv file that will convert nicely into google sheets or excel, etc. It has loads of empty columns that I don't use, but it has about 3 that I needed to get. These were the account names of all the teachers and staff on campus. <br />
<br />
All our district has the domain @vacavilleusd.org but their account names are different. Usually it's the first name and the last initial (which I could make up with a spreadsheet function if it worked all the time). However, sometimes there is already an "AndrewH" account and they do "AHyland" as the account. So now I have that list from which to pull email addresses whenever I need. I made a named range to look up in and concatenated the account name with the vacavilleusd.org domain. <br />
<br />
I did some similar data pulls for schedule from Aeries (teacher, course, period) and special ed info (like testing accommodations and behavior plan status, dates for next IEP, etc.) from SEIS--our Special Ed Information System. I can detail how I pulled those later so that I can replicate them next time and for any other campus and/or district that might use this idea.<br />
Links:<br />
<a href="http://mrhyland98.blogspot.com/2014/05/case-management-documentation-and.html" target="_blank">Link to Part 1</a><br />
<a href="http://mrhyland98.blogspot.com/2014/10/IEPFeedback2.html" target="_blank">Link to Previous Part</a><br />
<a href="http://mrhyland98.blogspot.com/2014/10/IEPFeedback3-5.html" target="_blank">Link to Next Part</a>Mr. Hyland 98http://www.blogger.com/profile/15284487572276213986noreply@blogger.com0Vacaville High School, 100 West Monte Vista Avenue, Vacaville, CA 95688, USA38.3601883 -121.9960780000000113.216996299999998 -163.304672 63.503380299999996 -80.687484000000012tag:blogger.com,1999:blog-5508499281173223581.post-10642647410091870602014-10-02T07:00:00.000-07:002014-10-21T19:42:35.162-07:00Case Management Documentation and Google Apps Scripts Part 2<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNl9xjLGgF7c6OI_MEa8XrjnsS9rhguCLICXqiU9kPyP4E_yLUWxIQS-tTOJrpmiMLNt0QGBCpysTn3uHP9qQ8GgKywgv0r31JLa9sqAWPrY184VNCSah63YsYy4hcGGZPGase7AnSYog/s640/blogger-image-1042135960.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNl9xjLGgF7c6OI_MEa8XrjnsS9rhguCLICXqiU9kPyP4E_yLUWxIQS-tTOJrpmiMLNt0QGBCpysTn3uHP9qQ8GgKywgv0r31JLa9sqAWPrY184VNCSah63YsYy4hcGGZPGase7AnSYog/s640/blogger-image-1042135960.jpg" /></a>I believe I have the script completed for the first half of my project. At least, I can make the computer fetch and use all the data in question. One bump at this stage is turning out to be triggering the script in such a way that it will run completely and automatically when a form is submitted. That might be a huge task if I end up having to make half of the data lookups happen inside the script instead of inside the spreadsheet.<br />
<div>
<br /></div>
<div>
In any case, the next step will be the easy part--automating the general education feedback PDF production using the autocrat add-on. </div>
<div>
<br /></div>
<div>
I think a more expert programmer would spot some areas where I have clunky code in my script, but I'm making progress each day. This will be my first real work project in programming and when it works I will have something to brag about. </div>
<br />
<a href="http://mrhyland98.blogspot.com/2014/05/case-management-documentation-and.html" target="_blank">Link back to Part 1</a> and <a href="http://mrhyland98.blogspot.com/2014/10/IEPFeedback3.html" target="_blank">Link to Next Part</a>Mr. Hyland 98http://www.blogger.com/profile/15284487572276213986noreply@blogger.com0Vacaville High School, 100 West Monte Vista Avenue, Vacaville, CA 95688, USA38.3601883 -121.9960780000000113.220158299999998 -163.304672 63.5002183 -80.687484000000012tag:blogger.com,1999:blog-5508499281173223581.post-11391802636473878202014-09-26T07:00:00.000-07:002014-10-21T19:41:03.237-07:00Case Management Documentation and Google Apps Scripts (Add-ons)Well I've begun the project for this year and I expect to be done around January 2015, although tht may be wishful thinking. If I keep the current pace for progressing through each problem, I'll be done by thanksgiving, so January seems more realistic.<br />
<div>
<br /></div>
<div>
I have previously built each of the pieces I'm going to need for this project, now I have to connect them all and make them talk with each other. I've been able to find some great examples of code, but for all of them I've needed to tweak to make it fit my data. </div>
<div>
<br /></div>
<div>
My concept is for a special education case manager to input only four pieces of info for an IEP and have my program do the rest of the job looking up things and inviting teachers. This means making at least two databases talk to each other and probably three. For right now I'm pulling the data once a semester and using that to work with. So if something changes for a student then I have to update manually on my sheet. </div>
<div>
<br /></div>
<div>
The old method is for case managers to look up a students schedule and then manually input each of six teachers names and classes twice--once for the meeting invite and once for the feedback form. This method was varying degrees of technology away from a typing pool secretary with 5-sheet NCR paper and a highlighter. Currently we've moved up to around 1998 using a word document with fillable boxes. </div>
<div>
<br /></div>
<div>
So far I've figured out how to make the computer read the form input from the case manager and pull up the next form and pre-fill the answers. Next is to make it email the URL of the prefilled form to the six correct teachers. </div>
<div>
<br /></div>
<div>
This will certainly be part one of my posts on this topic. <a href="http://mrhyland98.blogspot.com/2014/10/IEPFeedback2.html" target="_blank">Next Post Here</a><br />
<a href="http://mrhyland98.blogspot.com/2014/10/IEPFeedback3.html" target="_blank">Link to part 3</a> -- and <a href="http://mrhyland98.blogspot.com/2014/10/IEPFeedback3-5.html" target="_blank">Link to part 3.5</a></div>
Mr. Hyland 98http://www.blogger.com/profile/15284487572276213986noreply@blogger.com0tag:blogger.com,1999:blog-5508499281173223581.post-70054833327230804562014-08-22T15:00:00.000-07:002014-08-22T15:00:00.228-07:00Donor's Choose Project for Mr. Hyland's Class -- Update!<div style="font-family: Verdana; font-size: 13px;">
Exciting Opportunity! </div>
<div style="font-family: Verdana; font-size: 13px;">
<br /></div>
<div style="font-family: Verdana; font-size: 13px;">
My Donor's Choose project, <a data-cke-saved-href="http://click.mail.donorschoose.org/?qs=7797d72db9d90aa3ea32f310da20491519e6934308108da4c054d4f00bb7278e43ff5ac2153bb4a6" href="http://click.mail.donorschoose.org/?qs=7797d72db9d90aa3ea32f310da20491519e6934308108da4c054d4f00bb7278e43ff5ac2153bb4a6" style="color: #1155cc;" target="_blank" title="Classroom Computers for Common Core Language Arts">Classroom Computers for Common Core Language Arts</a>, is eligible for a <b>three-day-only offer</b> from the Bill & Melinda Gates Foundation. To celebrate teachers and the amazing work we do, nearly all projects will be half-off through <span class="aBn" style="border-bottom-color: rgb(204, 204, 204); border-bottom-style: dashed; border-bottom-width: 1px; position: relative;"><span class="aQJ" style="position: relative; top: 2px;">August 24</span></span>.<br /><br /><br />Please donate if you are able, or share with people you know who might be interested in supporting my class and our students:</div>
<ul style="font-family: Verdana; font-size: 13px; padding: 0px 40px;">
<li style="margin-left: 15px;"><b>The half-off match will last for three days,</b> starting August 22 and ending <span class="aBn" style="border-bottom-color: rgb(204, 204, 204); border-bottom-style: dashed; border-bottom-width: 1px; position: relative;"><span class="aQJ" style="position: relative; top: 2px;">August 24 at 11:59 PM</span></span> Eastern Time. To receive funding from the Bill & Melinda Gates Foundation, other donors must complete 50% of your project funding during that time.<br /></li>
<li style="margin-left: 15px;"><b>Funding from the Bill & Melinda Gates Foundation isn't guaranteed.</b>Funds will only be applied to your project if other donors complete the rest before the offer ends on <span class="aBn" style="border-bottom-color: rgb(204, 204, 204); border-bottom-style: dashed; border-bottom-width: 1px; position: relative;"><span class="aQJ" style="position: relative; top: 2px;">August 24</span></span>.</li>
</ul>
<div style="color: #333333; font-family: sans-serif, Arial, Verdana, 'Trebuchet MS'; font-size: 13px; line-height: 16px; margin-bottom: -10px; margin-left: 15px;">
Here is a short link (also above) to my project page <a data-cke-saved-href="http://goo.gl/2hfQWo" href="http://goo.gl/2hfQWo" style="color: #0782c1;" target="_blank">http://goo.gl/2hfQWo</a></div>
Mr. Hyland 98http://www.blogger.com/profile/15284487572276213986noreply@blogger.com0Vacaville High School, 100 West Monte Vista Avenue, Vacaville, CA 95688, USA38.3601883 -121.9960780000000113.216996299999998 -163.304672 63.503380299999996 -80.687484000000012tag:blogger.com,1999:blog-5508499281173223581.post-66781724975818669062014-06-25T19:23:00.003-07:002014-06-25T19:30:42.529-07:00Keyboard Shortcuts for Google DocsI continually have to look these up, so I'm holding the link here on this site.<br />
I find the help button in Docs does not have all the shortcuts I'm looking for, most notably the "insert comment" shortcut key which is "command+option+m". Less clicking when I get my students using Docs for their writing. :)<br />
<br />
This will become important if I ever get my next task off the ground: daily warm ups using Google Docs which should get some form of feedback (i.e. comments) from me (perhaps on a weekly basis. . .).<br />
<br />
<a href="https://support.google.com/docs/answer/179738?hl=en" target="_blank">Link to the shortcuts</a><br />
<br />
Sorry, no pics for this one.Mr. Hyland 98http://www.blogger.com/profile/15284487572276213986noreply@blogger.com0tag:blogger.com,1999:blog-5508499281173223581.post-71209346940292106402014-06-13T08:30:00.000-07:002014-06-13T08:30:00.600-07:00Donor's Choose Project -- 3 new chromebooks<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvQQPE1JqBELZLJDqo0Zk-4PF2dIiCgvXoN6cS2KPjsFCultQEzS9PzjWbTYXlS63pE6hpw_gpUy-qirMbcqwKdVKrnDYI7dxfj8Ej-1Uha1vDWEZ6AHlXyVRaih2vhhpZmVmhyphenhyphenw57hFvs/s1600/Screen+Shot+2013-12-04+at+11.53.12+PM.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvQQPE1JqBELZLJDqo0Zk-4PF2dIiCgvXoN6cS2KPjsFCultQEzS9PzjWbTYXlS63pE6hpw_gpUy-qirMbcqwKdVKrnDYI7dxfj8Ej-1Uha1vDWEZ6AHlXyVRaih2vhhpZmVmhyphenhyphenw57hFvs/s1600/Screen+Shot+2013-12-04+at+11.53.12+PM.png" height="89" width="320" /></a></div>
Well, in all my free time I've created a <a href="http://goo.gl/vuuiiW" target="_blank">Donor's Choose project</a> to augment the technology in my classroom. My students really need to be able to create, compose, and publish on the internet. I would like to have a class blog for some of our literature responses and argumentative assignments next year and my students this year (2013-2014) wanted to as well.<br />
<br />
Our hold up was, well it was mostly due to planning time on my part since it was my first year at this school. I'd like to blame the equipment, but that's not the full picture. We could have done most of what I want to do--writing, drafting, collaborative revision, commenting, etc.--with my current technology setup; however, it would have been slow to say the least. <br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfz_wudCglVLeCtFHabLjxaGD7ZAynjl9OFfKWxN4Y0F6XEzjeArwY2uXij3KIEslEY-sk-uswhCL44XUFbEMSkNdDCrkRchxyq6S0eRiFJTxR-Egn49PQz0thvhcuXrlSSUlGlSsNE78/s1600/IMG_3796.JPG" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfz_wudCglVLeCtFHabLjxaGD7ZAynjl9OFfKWxN4Y0F6XEzjeArwY2uXij3KIEslEY-sk-uswhCL44XUFbEMSkNdDCrkRchxyq6S0eRiFJTxR-Egn49PQz0thvhcuXrlSSUlGlSsNE78/s1600/IMG_3796.JPG" height="238" width="320" /></a></div>
We currently have 3 classroom computers to use, a fourth one if I can free up a shared laptop for the day. Even with my reduced class sizes I had 12 students in my largest classes and that would still take 4 rotations to get all the students on to computers for typing. While that's ok for shorter writing assignments or surveys (see my <a href="http://mrhyland98.blogspot.com/2014/06/class-feedback-results.html" target="_blank">previous post</a>, the data for which I gathered using two of our computers hot-seat style after exams), it is tedious for research papers or longer assignments when the needs of my students require that some of them are typing for two or three times as long as other students. <br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyhYt-awwap1nNhdUKMSmMTGqDZdJnz9QbJpEdA4Na8Rfov2iMFjsifGcHBW2wfv4Gt1zLMu4K3aYfBY-BThHEM-SC6zCZbclv8UMSW_4vdEzc8tc6eyEqly6npskGGYoKY-7qQcswF_I/s1600/IMG_3797.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyhYt-awwap1nNhdUKMSmMTGqDZdJnz9QbJpEdA4Na8Rfov2iMFjsifGcHBW2wfv4Gt1zLMu4K3aYfBY-BThHEM-SC6zCZbclv8UMSW_4vdEzc8tc6eyEqly6npskGGYoKY-7qQcswF_I/s1600/IMG_3797.JPG" height="239" width="320" /></a></div>
Donor's Choose only lets you start out with a small project at first until you get enough "points" to allow a larger dollar amount for your projects. This, I assume, weeds out the weaker hearts, and indeed kept me out last year when I created the account and drafted half a similar project for my last classroom. Even with this small number of points--and therefore a small "budget"--I am able to fund a huge boost in capacity for my classroom: Three Chrome book laptops for my room will double the available number of screens for students to use and cut in half the time it takes for computer projects in the room. Not to mention the classroom management impact! Easier planning for me, I hope.<br />
<br />
Upon the successful funding of this project, I believe I will be able easily to plan and implement some engaging and fun lessons with our new English curriculum which will cover Antigone and Things Fall Apart next year. Look for a class blog on here and, at the very least, some published student examples of peer edited and revised, polished, college prep writing.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-1cCeEZVSn0lKC-ua2Z3nz9NiFemCxRhJdcL5drICtq7L7_v8wfq0rFSHbyKa7d01cdWcX2NOVsCcMPGE3yocadD9GT16_yQC1SI7U7ZX0keXEj21_znMi5wN6jh51G2nRXeoG_V_ZsQ/s1600/IMG_3653.JPG" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-1cCeEZVSn0lKC-ua2Z3nz9NiFemCxRhJdcL5drICtq7L7_v8wfq0rFSHbyKa7d01cdWcX2NOVsCcMPGE3yocadD9GT16_yQC1SI7U7ZX0keXEj21_znMi5wN6jh51G2nRXeoG_V_ZsQ/s1600/IMG_3653.JPG" height="239" width="320" /></a></div>
<br />
Here's the link to my teacher page on Donor's Choose: <a href="http://goo.gl/vuuiiW" target="_blank">Link</a><br />
Yes, it's the same as above--I'm trying the best I can since the project expires in 4 months.Mr. Hyland 98http://www.blogger.com/profile/15284487572276213986noreply@blogger.com0Vacaville High School, 100 West Monte Vista Avenue, Vacaville, CA 95688, USA38.3601883 -121.9960780000000113.220169299999998 -163.304672 63.5002073 -80.687484000000012tag:blogger.com,1999:blog-5508499281173223581.post-88880767720619758652014-06-05T13:03:00.001-07:002014-06-05T13:17:02.339-07:00Class Feedback ResultsTo follow <a href="http://larryferlazzo.com/about.html">Larry Ferlazzo</a>'s example, I'm posting my class feedback results from my end of year suvey. I'll put the questions followed by the highest percentage rating, just to save typing since I don't want to take the time to screen shot the charts and graphs that google forms made for me.<br />
<br />
I didn't split these by class period or anything, although I think for next year I'll take the trouble to make a different form for separate classes to get a better idea. This will be really important for me next year since I'll be co-teaching with two different teachers and teaching 4 different subjects. I'm excited for the challenge.<br />
<br />
<br />
<ul>
<li>I felt challenged by this class: 41% neutral</li>
<li>I felt like Mr. Hyland respected me: 46% agree</li>
<li>I felt like Mr. Hyland gave me useful feedback: 70% agree</li>
<li>I felt like Mr. Hyland was fair: 63% agree</li>
<li>Mr. Hyland had high expectations of me: 50% agree</li>
<li>I tried my hardest to do my best in class: 37% each (tie) strongly agree and agree</li>
<li>My grades reflected the quality of my work: 52% agree</li>
<li>Mr. Hyland encouraged me to do my best: 43% agree</li>
<li>I felt safe in Mr. Hyland's class: 54% agree</li>
<li>The class was well organized: 59% agree</li>
<li>I enjoyed being in this class: 41% agree</li>
<li>I always followed Mr. Hyland's instructions: 41% neutral</li>
</ul>
<br />
<br />
I also had 5 short answer questions where students could type a response. Some did not, and others made what seemed like sarcastic comments (hard to tell if they were serious). However, there are some gold nuggets that told me what I needed to hear from students (that's the point after all!). Many of these comments referred to our penultimate activity--watching Star Wars after a series of lessons on the Hero's Journey, so if you follow the link below and scan those comments, you'll note some fanboys.<br />
<br />
I also co-teach one period, so I included my co-teacher and co-teach class on the questionnaire. You'll see her name in there as well.
Here's <a href="https://docs.google.com/forms/d/1fyj-jdiAUk06q-iy7o6zxz12gQaeYJJrpywvE3wJWIs/viewanalytics">the link to my full results</a>, and--as un-scientific as they are--I'm proud of them this year. I always have plenty of room to improve. My goals for next year include inching forward on tech integration in my classroom lessons.Mr. Hyland 98http://www.blogger.com/profile/15284487572276213986noreply@blogger.com0Vacaville High School, 100 West Monte Vista Avenue, Vacaville, CA 95688, USA38.3601883 -121.9960780000000113.216996299999998 -163.304672 63.503380299999996 -80.687484000000012tag:blogger.com,1999:blog-5508499281173223581.post-30017852040825538822014-05-31T12:26:00.001-07:002014-05-31T12:29:06.602-07:00More Google products for educational uses.I enjoy the ability of Google+ to send me posts that I can really engage with. Of course, I have connected with some fun things and games for enjoyment on Google+. So I get a lot of that in my feed which is nice so that I can decompress from work. I have also added a good number of education related groups and ed-tech groups. Sometimes I flip past those posts if I want to avoid melting my brain from too much work-thought. <br />
<br />
Today, a post grabbed my attention because it was asking for a solution that I know how to provide. I left a short comment, knowing that I also wanted to post here on the topic. The poster, <a class="g-profile" href="https://plus.google.com/110533692928014399268" target="_blank">+Jennifer Fox</a>, asked for some follow up so here's what I put together--I hope it was what she was looking for:<br />
<br />
Original problem: "<span style="background-color: white; color: #404040; font-family: Roboto, arial, sans-serif; font-size: 13.333333015441895px; line-height: 24.26666831970215px;">Is there a way to sort responses from a Google Form as they are being gathered on the response sheet?"</span><br />
My response: Use either <a href="https://anandexcels.wordpress.com/tag/vlookup-function-in-google-docs/" target="_blank">VLOOKUP</a> or <a href="http://www.mousewhisperer.co.uk/drivebunny/using-importrange-in-google-sheets/" target="_blank">IMPORTRANGE</a> functions to copy the data to a second sheet and filter/sort that sheet. Then the original collection sheet continues to get live responses and you can still organize your data.
<br />
My example: I created a sample <a href="http://goo.gl/iKqV3i" target="_blank">google form</a> to collect fake data with numbers and letters, i.e. something to sort multiple ways. Then I went to the <a href="http://goo.gl/Ce2Lyh" target="_blank">spreadsheet</a> where all the responses were collected and created a second sheet (named "<a href="https://docs.google.com/spreadsheets/d/1AhUMGsZw4U5axVIXTXcv26zYXx7SioIf6ScIJX9Pnx8/edit#gid=545538764&fvid=185754448" target="_blank">The Magic</a>"). On the second sheet, I used the importrange function to copy the data and then I selected all three columns of data (this makes sure that when you filter, the rows of data stay together) and applied a filter. Now I can sort and filter the data and new data from the form automatically comes in whenever the users complete the form.<br />
I also got to learn a little from the other comments in the thread--specifically, that there is an SQL-style <a href="http://anandexcels.wordpress.com/2013/11/01/query-function-in-google-sheets/" target="_blank">query</a> function in google sheets.<br />
So, that was a win all around!Mr. Hyland 98http://www.blogger.com/profile/15284487572276213986noreply@blogger.com0Vacaville High School, 100 West Monte Vista Avenue, Vacaville, CA 95688, USA38.3601883 -121.9960780000000113.220170799999998 -163.304672 63.500205799999996 -80.687484000000012tag:blogger.com,1999:blog-5508499281173223581.post-89160673719388926692014-05-27T08:00:00.000-07:002014-06-05T20:34:45.040-07:00Hero's Journey Lessons Reflection Pt. 2To wrap up my reflection, I'm going to share about the final two days of my Hero' Journey lessons.<br />
<div>
Due to my lack of timing and many other excuses, I only had two days to cover about 60% of the Hero's Journey. The parts following the first threshold all the way to mastering both worlds. This proved to e difficult and since I had each student pick a different story plot line to outline, it became a challenge to keep everyone on pace while still covering each step adequately.</div>
<div>
Next time I do this (and I will), I believe I will incorporate pairs and have some of the steps of the journey be presented by flash card or short video or something independent (flipped classroom?) so my lesson time can focus on the main points without getting bogged down or having 2/3 of the class zoned out while I help one group with their plot outline. </div>
<div>
<br /></div>
<div>
The lessons as I planned them this year were too much but kids also seemed to loose interest by the end, another reason to streamline the key points and delivery by working up a video for students to watch for homework. Possibly, I could have students create a good one for me and use it in the next class. Then class times could focus on students working in pairs or groups analyzing their particular plots. </div>
<div>
<br /></div>
<div>
At this late point in the year, I always really excited about possibilities for next year. </div>
<div>
<br /></div>
<div>
I've found a link to a neat podcast that discusses Star Wars and it's uses in the classroom, so that's really exciting. </div>
Mr. Hyland 98http://www.blogger.com/profile/15284487572276213986noreply@blogger.com0tag:blogger.com,1999:blog-5508499281173223581.post-39396322981048575062014-05-23T06:00:00.000-07:002014-05-23T06:00:01.451-07:00Hero's Journey Lessons Reflection, Pt. 1<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjV5Q87wmIvrzkEEP8GITNKIzLc_KtgIrJUwEiBPS9NoKhHCu7UI0Z8Eirz5zSJIRd98zIkEeTgBB_i4d34TXt062rwPmYWN9mtipnzAtsCYc5D6MwqFN17LDntSY85iiZQMRbkrDlZxrE/s1600/IMG_3762.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjV5Q87wmIvrzkEEP8GITNKIzLc_KtgIrJUwEiBPS9NoKhHCu7UI0Z8Eirz5zSJIRd98zIkEeTgBB_i4d34TXt062rwPmYWN9mtipnzAtsCYc5D6MwqFN17LDntSY85iiZQMRbkrDlZxrE/s1600/IMG_3762.JPG" height="239" width="320" /></a>It's no secret to my students that I enjoy Star Wars in almost every way. I'm surprised these last few years at how many students have not seen the original episodes. This year, the majority of my 3rd period English 11 P class had not seen any versions of Star Wars--which surprises me since Episode III came out <a href="http://en.wikipedia.org/wiki/Star_Wars_Episode_III:_Revenge_of_the_Sith" target="_blank">in 2005</a> (and the Clone Wars cartoon just <a href="http://starwars.com/news/star-wars-the-clone-wars-final-season-the-lost-missions-to-hit-netflix-on-march-7.html" target="_blank">barely ended</a>!)<br />
<div>
My third period co-teacher (<a href="https://twitter.com/jenilola" target="_blank">@jenilola</a>)originally came up with the idea to do a Star Wars week of mini-lessons to cover the Hero's Journey--mostly since so many had not seen the movies. She had some <a href="http://en.wikipedia.org/wiki/Monomyth" target="_blank">Hero's Journey</a> lessons archived and we pulled those out to dust off for the end of May. I immediately decided to steal the lessons we crafted for my other 10th grade classes. <br />
<br />
Long story short, we ended up not having the time in the year to do Star Wars or Hero's Journey in 3rd period, and lucky for me, I've squeezed it in for my other classes. Due to some last minute training days that will keep me out of the classroom for three straight days, I had to split up the Hero's Journey mini-lessons and it only seemed natural to split them into Act I, Act II, and Act III of the quest.<br />
<br />
On day 1, I showed a very brief <a href="http://mythologyteacher.com/documents/HeroJourneyLionKing.pdf" target="_blank">power point slide show</a> (thanks to <a href="http://mythologyteacher.com/">mythologyteacher.com</a> [I only showed Act I up to the threshold, so as to not get ahead of myself!]) of the different scenes in Lion King that correspond to the "Departure" portion of the Hero's Journey up to the first threshold. I then passed out index cards with stories and movies where I knew the plots (and hoped the students would know at least one! -- turns out none of the 10th graders have seen Planes. ..). I randomly passed out cards, but let them swap until they had one they knew well. For three absent students, I later gave them the entire stack and let them pick the one they knew best, so we had some duplicates but that's ok. The students spent about 10 minutes filling out a chart with the generic steps of Act I "Departure" with the corresponding parts of their selected plot line.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXa4PSFvsnuqp3yN_4NM9lUn3SLYWhtaQM9aOJnhGYUHbL1uCr5xCJY9XqNEGBsRJDxBC5VQmUHv_RItsxCfV_RltNuOkBeXANi1xmp0u4eH5jmx3cVCkKjBYFC_oYOr_fQMlMX1CnlKs/s1600/IMG_3735.JPG" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXa4PSFvsnuqp3yN_4NM9lUn3SLYWhtaQM9aOJnhGYUHbL1uCr5xCJY9XqNEGBsRJDxBC5VQmUHv_RItsxCfV_RltNuOkBeXANi1xmp0u4eH5jmx3cVCkKjBYFC_oYOr_fQMlMX1CnlKs/s1600/IMG_3735.JPG" height="239" width="320" /></a></div>
<br />
<br />
This is where the magic happened; since, when the students could not remember a part of their plot, they had some serious questions for their classmates. "What was the 'talisman' for Po in Kung Fu Panda?" "It was the Dragon Scroll, duh!" "Wait, why?" This followed by an explanation (with no help from me in most cases) as to why the object in question fit the archetype it was supposed to fill.<br />
<br />
We also heard some discussion as to why Twilight did not fit so easily into this structure. For a few extra credit points, I assigned the kids who wanted a challenge to complete Finding Nemo with the dad as the hero and one to work with Nemo as the hero. Another student chose to do Star Wars Episode IV with C3PO as the hero (real fun and much challenge since his quest has a short cycle within Luke's hour-long departure sequence).<br />
<br />
Despite me delivering a canned power point lecture for the first 7 minutes of class and then immediately passing out a fill-in-the-box worksheet, students had some higher level thinking and two-way conversations about their hero characters. Of course, because we had to split the days of May up between other curriculum, we only talked about Act I and the departure of the hero, so there was not much discussion about how characters changed and why they had to take certain actions or make certain choices.<br />
<br />
If these weren't mini lessons, I would next want to have them produce one high-quality poster (gotta love posters, plus I need something on my walls for back to school night next Fall!) for 2 or 3 of the key steps--perhaps one showing all the "guardians of the thresholds" from all the 12 different films and stories they broke apart.<br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmtmFs3ft1U4oZY0UX3YgtXhhhG5Utzb3nFpUvPtKFYiLoqyh_TTvL8xa3l9JukaB4hQaIK5QBP8qkTT77TOoby9ylKSaZv45zly0P5ac11NmLq6KOXN8bwpmytVvVAIELB7UY3Mq3BlY/s1600/IMG_3740.JPG" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img alt="" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmtmFs3ft1U4oZY0UX3YgtXhhhG5Utzb3nFpUvPtKFYiLoqyh_TTvL8xa3l9JukaB4hQaIK5QBP8qkTT77TOoby9ylKSaZv45zly0P5ac11NmLq6KOXN8bwpmytVvVAIELB7UY3Mq3BlY/s1600/IMG_3740.JPG" height="239" title="" width="320" /></a>Did I mention that I moved all the desks around in my room? Mostly to get them off the walls so that students could then post their Hero Journey plot points around the room. Sadly, we ran out of time (mini lessons, a blessing and curse!) before I could have students present their Act I lists or gallery walk the room and discuss. Never fear, however, since the desks ended up in a large circle and we had plenty of top-quality discussion before the sticky notes finally went up.<br />
<br />
<br /></div>
Mr. Hyland 98http://www.blogger.com/profile/15284487572276213986noreply@blogger.com0Vacaville High School, 100 West Monte Vista Avenue, Vacaville, CA 95688, USA38.3601883 -121.9960780000000113.220117799999997 -163.304672 63.5002588 -80.687484000000012