integrating edusoft data into the sip mid year application n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Integrating Edusoft Data into the SIP Mid-year Application PowerPoint Presentation
Download Presentation
Integrating Edusoft Data into the SIP Mid-year Application

Loading in 2 Seconds...

play fullscreen
1 / 66

Integrating Edusoft Data into the SIP Mid-year Application - PowerPoint PPT Presentation


  • 111 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Integrating Edusoft Data into the SIP Mid-year Application' - elkan


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
objectives
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
  • Export Excel files to focus on student performance data to improve instruction.
subgroups and amo
Subgroups and AMO
  • Your Annual Measureable Goal is determined by the state and provided to you at
  • http://osi.dadeschools.net – then click “Current and Expected Values 12-13” in the bottom section of “DATA Analysis.”
  • By clicking on 2011-2012 in the Annual Measurable Objective (AMO2) column, you will be able to access this information.
slide6

Annual Measurable Objectives-2 Report, 2011-12

Select a school from the drop down list and click on the provided buttons.

District

District

slide9

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.

slide14

You will see “Winter 2013 Interim Assessment – Grade 5 Reading” under Exams currently selected

slide19

Choose View/Save in EXCEL.

  • Save the Excel file to your flash drive using a logical name: (Reading Grade 05 WIA Subgroups).
slide23

Open the EXCEL file that you saved:

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

slide36

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

slide37

Let’s

Let’s start with the ECONOMICALLY DISADVANTAGED Subgroup

slide44

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.

slide45

Let’s look at the formula you will type:

=IF(K13=”Y”,”Y”,IF(L13=“Y”,”Y”,””))

TYPE

TYPE

TYPE

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

slide46

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

=IF($K13=“Y”,”Y”,($L13=“Y”,”Y”,””))

=IF(K13=“Y”,”Y”,(L13=“Y”,”Y”,””))

Press F4 KEY 3 times

To lock the columns, use the F4 Key

=IF(

slide47

To copy the formula for the whole column….

Hover over the right bottom corner of the first cell in the new column until an + appears…

Double click

slide49

To check if your formula is correct, select a cell and check to see that the row and column referenced are correct….

slide50

From the 2012-2013 SIP Mid-Year Narrative Report:

Question #3.

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.

slide63

Moving to the right hand side of the slide shows performance of each student and the Reporting Categories.

slide65

Use the Excel files to address Questions 3-5 for Subgroup FCAT Levels on the SIP Mid-year Narrative Report.

slide66

Ms. Linda Fife

305-995-2692

lfife@dadeschools.net

Ms. Pamela Wentworth

305-995-1520

pwentworth@dadeschools.net

Ms. Dolores de la Guardia

305-995-7686

ddelaguardia1@dadeschools.net

Dr. Sherian Demetrius

305-995-7046

sdemetrius@dadeschools.net