Academic Achievement Report for Ygnacio Valley Elementary School

Document Sample
Academic Achievement Report for Ygnacio Valley Elementary School Powered By Docstoc
					The Role of Correlation and Regression in
         Data Decision Making
                Webinar
                  Bill Conrad
            Assessment Coordinator
       Alameda County Office of Education
                510-670-4250
              bconrad@acoe.org

            Wednesday, May 18th
             5:30 pm – 6:30 pm              1
                   Virtual Dinner Choices
                   chez panisse in Berkeley




Brussel Sprouts Salad                    Pasta




                                      Onion Tart   2
     Cornish Hen
                   The Moral Purpose

To support every student at our District/School as if he/she
                    were our own child.




                                                           3
                Webinar Logistics

1. Please put your telephone on mute until you
   want to speak.
2. You can use the chat or question function to
   ask questions during the session.
3. We will use the polling function today. When a
   poll comes up, just click your answer!
4. Remember – no e-mailing during the webinar!
   The system is watching! : > }
5. Have fun!

                                                    4
                 Webinar Outcomes

• Introduce administrators to building and interpreting
  correlation and regression visualizations using Excel and
  SPSS.
• Understand how to interpret scatter plot charts, correlation
  statistics, and regression in response to education
  questions involving assessment data.
• Practice using scatter plots, correlation statistics, and
  regression to respond to education questions designed by
  administrators and using district data.
• Use Excel and SPSS to create data visualizations that
  integrate into reports to stakeholders.


                                                              5
How do I make sure that I have the Data Analysis
          Pack on my Excel Program?

1. Select Tools on the Excel Worksheet Menu Bar
2. Select Add-Ins from the Tools Menu.
3. Check the box for Analysis ToolPak
4. Click the Analysis ToolPak to add this feature to
   your tools menu.
5. Visit the link below to see the installation
   procedure.
           http://www.schoolsanddata.org/Movies/tool/tool.htm

Source: Schools and Data by Theodore B. Creighton               6
Data Inquiry Modules Google
           Groups




                              7
                      Data Engagement
                         History of Rock




Source: Visual Explanations by Edward Tufte   8
 How might you use correlation and regression in your work
      as a school principal or district administrator?
After Reading Chapters 4-5 of Schools and Data by Creighton, please
respond to the questions below.


How might you use correlation and regression in your work as a school
principal?




What are some specific questions that you might ask that use correlation
and regression?




How would you communicate correlation and regression results to different
stakeholder groups?                                                   9
                         Scenario 1

You are on a grade level/department team interested in
learning whether the successful implementation of an early
reading assessment and intervention system results in
improved student achievement. Your team’s initial learning
target was to help 2nd grade students stay on track for the 5
key elements supporting reading. Your team would implement
a screening and ongoing monitoring assessment system in
conjunction with the DIBELS Outcome Driven Model to
assure that all 2nd graders are reading by the end of second
grade.



                                                          10
                            Scenario 1 (Continued)
As a key component of this lesson plan strategy teachers collaborated to implement a
      comprehensive early reading assessment system incorporated the following key
      elements:
•     Implement a comprehensive system of screening and on-going monitoring early
      reading assessment for the following key elements of reading:
         •Phonemic Awareness
         •Phonics
         •Vocabulary
         •Fluency
         •Comprehension
•     Work as grade level teams to implement the outcomes driven system to effectively
      use the information gained from the comprehensive early reading assessment system
      to identify student reading needs; validate those needs; plan actions to address
      student early reading needs; implement the actions; monitor ongoing achievement;
      adjust actions as necessary to improve student performance.

                             https://dibels.uoregon.edu/
                                                                                       11
       What is comprehensive early reading assessment system?




Source: Dynamic Indicators of Basic Early Literacy Skills Web
site: https://dibels.uoregon.edu/                               12
                                        What is the Outcomes-Driven Model?




Source: Dynamic Indicators of Basic Early Literacy Skills Web
site: https://dibels.uoregon.edu/dibelsinfo.php#which                        13
 Scenario 2: Early Reading Assessment Implementation

Second grade teachers implement the outcome driven
model based upon mutually agreed upon criteria. Teachers
are interested in learning whether different levels of
implementation result in different levels of student
achievement. Is there any correlation between the level of
implementation and the improvement of student
achievement on Fluency Assessments?




                                                        14
       Scenario 2 (Early Reading Assessment Implementation Rubric)

      Emerging                     Developing                       Proficient                     Exemplary
        (0-1)                          2                                3                              4

Teachers administer the       Teachers administer the         Teachers administer the         Teachers administer the
fluency assessments to        fluency assessments to          fluency assessments to          fluency assessments to
students.                     students.                       students.                       students.

Teachers do not as yet use    Teachers use the early          Teachers use the early          Teachers use the early
the assessments to identify   reading assessments to          reading assessments to          reading assessments to
students who are on track,    identify students who are       identify students who are       identify students who are
at some risk, or at risk.     on track, at some risk, or at   on track, at some risk, or at   on track, at some risk, or at
                              risk.                           risk.                           risk.
Teacher as yet use the
Outcomes Driven Mode to       Teacher as yet use the          Teacher use the Outcomes        Teacher use the Outcomes
support students who need     Outcomes Driven Mode to         Driven Mode to support          Driven Mode to support
early reading intervention    support students who need       students who need early         students who need early
support.                      early reading intervention      reading intervention            reading intervention
                              support.                        support.                        support.
Teachers as yet do not
participate in grade level    Teachers as yet do not          Teachers as yet do not          Teachers actively
teams to review early         participate in grade level      participate in grade level      participate in grade level
reading data and              teams to review early           teams to review early           teams to review early
collaboratively design        reading data and                reading data and                reading data and
activities that support       collaboratively design          collaboratively design          collaboratively design
students.                     activities that support         activities that support         activities that support
                              students.                       students.                       students.

                                                                                                                           15
Scenario 1 (Early Reading Fluency Assessment Implementation Tool)




                                                                16
How can I use conditional formatting of Excel to
 identify students at different fluency levels?




                                                   17
How can I use conditional formatting to identify
     students at different fluency levels?




                                                   18
How can I use conditional formatting to identify
     students at different fluency levels?




                                                   19
How can I use the scatter plot chart to compare teacher
  implementation levels and spring fluency scores?

                        Finding: There are far fewer students at
                        risk in the Spring screening assessment
                        for second graders than in the fall initial
                        screening.


                        Why the Finding is Important: The
                        implementation of the Outcome Driven
                        System may be helpful in identifying
                        students at risk and providing early
                        support to improve their fluency
                        performance.


                        What Next? Try to determine why 3
                        students are still at risk at the Spring
                        screening assessment.
                                                                      20
    How can I practice using the conditional formatting function to
          identify at risk scores and at some risk scores?



    Practice using the
  conditional formatting
function to identify at risk
 scores, at some risk, or
         on track


   Copy and paste your
 visualization to the right
   include at least one
finding, why the finding is
 important, and what you
      would do next.

                                                                      21
How can I use the scatter plot chart to compare teacher
  implementation levels and spring fluency scores?




                                                     22
                  How can I use the scatter plot chart to compare teacher
                    implementation levels and spring fluency scores?

                                                                              Finding: There seems to be a
                                                                              correlation between levels of
                                                                              implementation and improved student
                  Comparison of Teacher Implementation and Spring             fluency scores with level 4 teacher
                                     Fluency
                                                                              implementation demonstrating the
                160                                                           greatest effect.
                140
                120
Fluency Score




                100
                80                                                  Series1   Why the Finding is Important: Full
                60                                                            implementation of the Outcome Driven
                40
                20
                                                                              Model may result in the best student
                 0                                                            performance in fluency .
                      0    1       2         3        4     5
                               Implementation level


                                                                              What Next? What can we do to ensure
                                                                              that teachers implement all components
                                                                              of the Outcome Driven Model?
                                                                                                              23
     How can I practice using the scatter plot function of Excel to
          identify at risk scores and at some risk scores?



Practice using the scatter
 plot chart to compare
     Spring Fluency
   Performance with
Performance on the ELA
          CST


   Copy and paste your
 visualization to the right
   include at least one
finding, why the finding is
 important, and what you
      would do next.
                                                                      24
  How can I use the correlation
function of Excel find the actual
  correlation between teacher
 implementation and the spring
        fluency scores?



                                    25
                         What is Correlation?


Correlation is a measure used to describe the relationship between two or
more variables. If there is a correlation between variables, that does not
mean there is also a cause and effect.
The Pearson correlation coefficient is used to determine whether two
variables are correlated. The coefficient varies between -1.00 and +1.00.
Page 37 shows various correlations using different Pearson correlation
coefficients. The Pearson correlation coefficient measures both the
direction and strength of the correlation.




   You can read more about Correlation in the Schools and Data Book –
                       Chapter 4 – pages 33-35
                                                                        26
What is Correlation?




                       27
What is Correlation?




                       28
How can I use the correlation function of Excel to compare
teacher implementation levels and spring fluency scores?




                                                             29
How can I use the correlation function of Excel to compare
teacher implementation levels and spring fluency scores?




                                                             30
How can I use the correlation function of Excel to compare
teacher implementation levels and spring fluency scores?




                                                             31
How can I use the correlation function of Excel to compare
teacher implementation levels and spring fluency scores?

                             Finding: There is a strong correlation of
                             0.6 between Teacher Implementation
                             and 2nd grade fluency performance on
                             the Spring Screening Assessment.


                             Why the Finding is Important: There
                             is an indication that there might be a
                             relationship between teacher
                             implementation of the Outcome Driven
                             Model and student performance on the
                             spring fluency assessment.


                             What Next? How can we determine the
                             which implementation levels produce the
                             best results for our students?
                                                                   32
     How can I practice using the correlation function of Excel to
        determine if there is a relationship between teacher
  implementation of the Outcome Driven Model and Spring ELA CST
                            Performance?

    Practice using the
  correlation function to
     compare teacher
implementation scores to
 student performance on
   the Spring ELA CST
       assessment


   Copy and paste your
 visualization to the right
   include at least one
finding, why the finding is
 important, and what you
      would do next.                                            33
  How do I build a correlation using SPSS?
      Open the SPSS file labeled Formative_Assessment.sav



Follow the instructions on page 44 of the Schools and Data
  Book to create a correlation using the DIBELS.sav file


  You can see a simulation of how to do a correlation on
              SPSS at the Web site below


http://schoolsanddata.com/Movies/music%20correlation.htm



                                                            34
     How can I practice using the correlation function of SPSS to
        determine if there is a relationship between teacher
  implementation of the Outcome Driven Model and Spring ELA CST
                            Performance?

 Practice using the SPSS
  correlation function to
     compare teacher
implementation scores to
 student performance on
   the Spring ELA CST
       assessment


   Copy and paste your
 visualization to the right
   include at least one
finding, why the finding is
 important, and what you
      would do next.                                           35
How can I use the regression function of Excel to compare teacher
      implementation levels and spring ELA CST Scores?



  Please read chapter 5 (Pages 50-63) of
 Schools and Data by Theodore Creighton
and view the Regression Analysis Tutorial at

   http://schoolsanddata.com/Excel%20Regression.htm




                                                               36
How can I use the regression function of Excel to compare teacher
      implementation levels and spring ELA CST Scores?




                                                               37
How can I use the regression function of Excel to compare teacher
      implementation levels and spring ELA CST Scores?




                                                               38
How can I use the regression function of Excel to compare teacher
      implementation levels and spring ELA CST Scores?




 http://mste.illinois.edu/activity/regression/#simulation
                                                               39
How can I use the regression function of Excel to compare teacher
      implementation levels and spring ELA CST Scores?




                                                               40
How can I use the regression function of Excel to compare teacher
      implementation levels and spring ELA CST Scores?




                                                               41
How can I use the regression function of Excel to compare teacher
      implementation levels and spring ELA CST Scores?




                                                               42
How can I use the regression function of Excel to compare teacher
      implementation levels and spring ELA CST Scores?




                                                               43
How can I use the regression function of Excel to compare teacher
      implementation levels and spring ELA CST Scores?




                                                               44
 How do I build a regression using SPSS?
     Open the SPSS file labeled Formative_Assessment.sav



 Follow the instructions on pages 57-61 in
Chapter 5 of the Schools and Data Book to
       create a regression using the
      Formative_Assessment.sav file


There is no online simulation for using SPSS
          to carry out a regression

                                                           45
    How can I practice using the regression function of Excel to
        determine if there is a relationship between teacher
  implementation of the Outcome Driven Model and Spring Fluency
                               Scores?

     Practice using the
 regression function to
     compare teacher
implementation scores to
 student performance on
    the Spring Fluency
          Scores


   Copy and paste your
 visualization to the right
   include at least one
finding, why the finding is
 important, and what you
      would do next.                                           46
How can I use the t-test of Excel to measure whether there is a
  significant difference between two independent means?



Please read chapter 7 (Pages 81-101) of
Schools and Data by Theodore Creighton
     and view the t-test Tutorial at

  http://schoolsanddata.com/Excel_t_test.htm




                                                                  47
                            Data Inquiry Resources

Schools and Data. 2007. by Theodore B. Creighton. Corwin Press. Thousand Oaks
California.
    This book provides the basis for all of the Data Inquiry Modules. It introduces
    administrators to educational data; basic statistical techniques; and how to use
    Excel and SPSS to employ the statistical techniques. It also has online tutorials
    that demonstrate how to use Excel and SPSS to carry out the analyses.


Visual; Explanations: Images and Quantities, Evidence and Narrative. 1997 by
Edward Tufte. Graphics Press. Chesire, Connecticut.
    “This book describes design strategies- the proper arrangement in space and
    time of images, words, and numbers- for presenting information about motion,
    process, mechanism, and cause and effect.” It provides many beautiful historical
    and current examples of data visualization and resulting actions.


The Cognitive Style of Power Point: Pitching Out Corrupts Within. 2006. by
Edward Tufte. Graphics Press. Chesire, Connecticut.

    Describes how data visualization using power point forces one into a cognitive
    style that is aligned more with a corporate pitch than a thoughtful opportunity to
    reflect on important ideas. This is a must read for anyone who uses Power            48
    Point..
The Role of Correlation and Regression in
         Data Decision Making
                Webinar
                  Bill Conrad
            Assessment Coordinator
       Alameda County Office of Education
                510-670-4250
              bconrad@acoe.org

            Wednesday, May 18th
             5:30 pm – 6:30 pm              49

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:2
posted:7/21/2012
language:
pages:49