There is a MySQL table titled, s_ s_nwea_student, that stores details for each student. Each student will be in the table more than once as the building and grade may change for a given test term.

Import the excel file into s_nwea_student.

Run the utilities in; “SE AA NWEA Utilities” to update the MunID and ScbID.

Run the Insert into statement to load the unique student data for this term/

There is a MySQL table titled, s_achievementstudentfile, that stores details for each student. Each student will be in the table more than once as the building and grade may change for a given test term.

SELECT DISTINCT 3833 AS AsfMunID, 2017 AS AsfSchoolYear, ScbID AS AsfScbID, StudentID AS AsfStudentNumber, TermTested AS AsfTestTerm, StudentFirstName AS AsfFirstName, StudentLastName AS AsfLastName, StudentMiddleInitial AS AsfMiddleInitial, StudentGrade AS AsfGrade, SchoolName FROM s_nwea_teacher LEFT OUTER JOIN c_buildings ON SchoolName = ScbName WHERE NwtMunID = 3833 AND ScbScdID = 3833 ORDER BY StudentLastName, StudentFirstName;