I Teach I Learn.com Expanding Education Awareness

  Welcome to  I teach I  learn . c o m
        


 Home
  Contact us
  Project Laptop
  Volunteer Work

  Our Mission

 Solutions
  Testing
  Research
  Consulting
 itil. Family
  Teacher Ideas
  Lit. Assessment
  Cummins Web
  Lectura
  Bilingual Ed.
 TIE  R & D
  Number Land
  Co-op Inquiry
 Support
  Links
  Bilingual Education
  
Version 2
 News


  


      [ Structure ][ Rationale ][ Database Tutorial ] [ Database]

Using Microsoft Access to homogeneously group English Language Learners for ESL instruction.

 

 Why group homogeneously? see Rationale

 Why use a database program? flexible

 Why Access? user friendly, small number of records, district program

How do we implement the program? see Structure

 How to make it happen:

  1. Import or enter student names.
  2. Choose assessment data
    1. a. Student files contain a number of academic measurements, bilingual students have a blue folder which houses a student's LEP level and LAS scores.
      b. Teacher designated levels (low numbers reduce interator error).
  3. Calibrate assessment data
    1. Equalizing score data.
  4. Enter assessment data
    1. LAS scores
    2. RPTE scores
    3. LEP level
    4. Current year teacher’s assessment
    5. Aprenda English Component scores
    6. SAT 9 Vocabulary scores
  5. Generate algorithms for composite scores.
    1. BICS weighted or CALP weighted.
    2. Missing scores
  6. Use Access Queries to execute algorithms.
    1. Enter the algorithm
    2. Add criteria
  7. Use Reports to organize findings.
    1. By level
 

 



Educational Evaluation Links

The Connection between Cooperative Learning and Authentic Assessment
A folksy, personal account of how to evaluate cooperatively grouped learners... read more.

Validity, Bias, and Justice in Educational Testing. Educational measurement has been historically dominated by technicists who abstract questions of test validity and bias from social conditions, and maintain that everyone should play by the ground rules that they, the technical experts, set.... read more.

Legal Issues in Testing.
Ability tracking, special education, school admissions, test disclosure, teacher competency... read more.

Comments on Assessment in U.S. Education. We do not know much about what assessment has accomplished but we know it has not brought about the reform of American Education... read more.


Research, Software and Theory

Criterion- vs Norm-Referenced Testing
It is common to hear criterion-referenced and norm-referenced testing referred to as if they serve the same purposes, or shared the same characteristics. Much confusion can be eliminated if the basic differences are understood....  read more.

Standard Errors in Educational Assessment: A Policy Analysis Perspective
Statistical methods are tools for understanding social processes, but there is no necessary connection between a statistical method and an empirical outcome... read more.

Hot-Potatoes, Half-Baked Software The freeware Hot Potatoes suite includes six applications, enabling you to create interactive multiple-choice, short-answer, jumbled-sentence, crossword, matching/ordering and gap-fill exercises for the World Wide Web... Read More.


This educational evaluation web's aim is to lead the drive towards integrating education, assessment and IT resources. Created by Justin Olmanson, the goal is the optimization of technology utilization in educational settings in hopes of producing more successful learners. 


Top of Page
i teach i learn.com © 1999-2003
Educators. Technology. Connected.