<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:"Calibri Light";
panose-1:2 15 3 2 2 2 4 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Garamond;
panose-1:2 2 4 4 3 3 1 1 8 3;}
@font-face
{font-family:"Lucida Calligraphy";
panose-1:3 1 1 1 1 1 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Garamond",serif;
color:#1F4E79;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79">Afternoon all!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79">The ACT scores are back,
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79">I wanted to update you on how to load your ACT spreadsheet. Thanks Tammy for working with me on this!!!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79">DASL put out that you need to update columns CR and CS to Change Strnk to StRnk<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79">Update column AA to say 10,11,or 12 not 10<sup>th</sup> , 11<sup>th</sup> or 12<sup>th</sup><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79">What they failed to mention is that once you open the file, some of the formatting changes.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79">The file not only contains your State ACTs from February, but all other ACT scores taken this school year. If you have not loaded or hand entered previous scores
that is fine.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79">If you have you need to delete the test scores with those dates out of the file or it will load them as duplicates.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79">Now to format the file:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79">The test date column AO needs to be mmyyyy. 22024 will not load. You will have to highlight the column with the test score, right click, format cells and click
on custom and put 000000 in the field. That will update that column to report any date for the months of January through September to have a leading 0.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79">The column for Birthdate, column P, needs to be mmddyyyy just highlight the row and format cells as custom with 00000000 and it will add all the 0s in.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79;background:yellow;mso-highlight:yellow">Save the file as a .csv and do not open it again prior to loading.</span><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79">This should allow you to load the file. From what I have seen you will still have some unmatched records but the majority of them will load.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79">Let me know if you have any questions.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79">K<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Lucida Calligraphy";color:#4472C4">Karen Wilson
</span><span style="font-family:"Lucida Calligraphy";color:#2E74B5">MCEP</span><span style="font-family:"Lucida Calligraphy";color:#4472C4"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Lucida Calligraphy";color:#4472C4">EMIS Support Specialist<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Lucida Calligraphy";color:#2E74B5">Miami Valley Educational Computer Association<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Lucida Calligraphy";color:#2E74B5">888 Dayton Street, Suite 102<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Lucida Calligraphy";color:#2E74B5">Yellow Springs, OH 45387<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Lucida Calligraphy";color:#4472C4">937-767-1468 ext 3115<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Lucida Calligraphy";color:#4472C4">Fax 937-767-1793<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>