Loading in 2 Seconds...
Loading in 2 Seconds...
Integrating Edusoft Data into the SIP Mid-year Application. Objectives. Participants will be able to: Identify subgroups not making satisfactory progress on identified Annual Measureable Objectives (AMO); Generate specific reports using Edusoft Report Builder; and
Participants will be able to:
Select a school from the drop down list and click on the provided buttons.
You can use the flowchart to determine if a subgroup reached its AMO target for this year. Any subgroup that did not meet the AMO target must be reported on the Mid-Year Report.
You will see “Winter 2013 Interim Assessment – Grade 5 Reading” under Exams currently selected
This box may look different for you – choose “all” if it gives you a choice of classes.
Check to be sure the Assessment is correct
Here you will see the names and ID numbers of the students who took the assessment you chose.
Double click on the tab to open the menu
To see other ethnicities, clear the filter for Hispanic and apply another filter.
You may also deselect Hispanic/Latino in the filter, delete the rows for the other ethnicities, and clear the filter. This would just leave Hispanic/Latino
Let’s start with the ECONOMICALLY DISADVANTAGED Subgroup
Insert a new column
You will type a formula in the first cell under the title in the new column…
When you start to type in the cell, a formula bar will appear. You may continue the formula in the formula bar.
This is a nested IF statement that says “if either column J or column K contains a Y, then there will be a Y in column L. If not, column L will be blank”.
Click on cell of first column you want to combine
Click on cell of second column you want to combine
Start by clicking in the first box under the column title and typing =IF(
Next, click on the cell under the title LEP 2 Years or less
Press F4 KEY 3 times
To lock the columns, use the F4 Key
Hover over the right bottom corner of the first cell in the new column until an + appears…
To check if your formula is correct, select a cell and check to see that the row and column referenced are correct….
Utilizing data from the reading baseline and mid-year assessments describe the changes to instruction, strategies, and/or school improvement activities that will be made prior to the administration of the FCAT 2.0 to ensure that students scoring FCAT 2.0 Levels 1 or 2 increase achievement to making satisfactory progress (FCAT 2.0 Level 3). Please be specific for each grade level and/or subgroup.
Filter the column for Economically Disadvantaged so that you only have ED students showing.
Moving to the right hand side of the slide shows performance of each student and the Reporting Categories.
Use the Excel files to address Questions 3-5 for Subgroup FCAT Levels on the SIP Mid-year Narrative Report.
Ms. Pamela Wentworth
Ms. Dolores de la Guardia
Dr. Sherian Demetrius