<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: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;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Bahnschrift Light";
panose-1:2 11 5 2 4 2 4 2 2 3;}
@font-face
{font-family:Garamond;
panose-1:2 2 4 4 3 3 1 1 8 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.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" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79">Good Morning All!</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79">The ACT scores are back, </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79">I wanted to remind you that you will need to update the ACT spreadsheet before you can upload it. These
are directions from Karen that I saved from last year…… </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><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</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><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></span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><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.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><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.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><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.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79">Now to format the file:</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><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.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><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.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:12.0pt;font-family:"Garamond",serif;color:#1F4E79"> <span style="background:yellow">Save the file as a .csv and do not open it again prior to loading.</span></span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><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.</span><o:p></o:p></p>
<p class="MsoNormal">Let me know if you have any issues/problems/questions,<o:p></o:p></p>
<p class="MsoNormal">Angie<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-family:"Bahnschrift Light",sans-serif;color:#83A9E7">Angie Luttrell, CEP<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Bahnschrift Light",sans-serif;color:#83A9E7">EMIS Support Specialist<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Bahnschrift Light",sans-serif;color:#83A9E7">Miami Valley Educational Computer Association<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Bahnschrift Light",sans-serif;color:#83A9E7">888 Dayton Street, Suite 102<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Bahnschrift Light",sans-serif;color:#83A9E7">Yellow Springs, OH 45387<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Bahnschrift Light",sans-serif;color:#83A9E7">937-767-1468 ext 3111<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Bahnschrift Light",sans-serif;color:#83A9E7">FAX: 937-767-1793<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>