Created 6/14/20. Updates available 
online.
 
  
    
    
  
    
      
    
    Lens Equation Experiment using Excel
      
    
    
    
     
    
    
    
    
    
      
        | 
          Title
         | 
        Lens Equation Experiment using Excel | 
      
      
        
          | 
            Description
           | 
          Students should be able to derive the lens equation:
1/f = 1/do + 1/di
(not usually an easy task)
using data collected in class with actual convex lenses or online with the simulation.
(IMPORTANT NOTE: clicking "download" is the best choice because the other option gives you a document format, not an Excel file.) | 
        
      
      
        
          | 
            Subject
           | 
          Physics | 
        
      
      
        
          | 
            Level
           | 
          High School | 
        
      
      
        
          | 
            Type
           | 
          Lab | 
        
      
      
        
          | 
            Duration
           | 
          90 minutes | 
        
      
      
        | 
          Answers Included
         | 
        No | 
      
      
        | 
          Language
         | 
        English | 
      
      
        
          | 
            Keywords
           | 
          equation, excel, experiment, lab, lens, simulation | 
        
      
      
        | 
          Simulation(s)
         | 
        Geometric Optics | 
      
    
    
    
    
    
    
    
    
    
    
    
    
    
    
      
        | 
          Author(s)
         | 
        Ed Chomka | 
      
      
        | 
          Contact Email
         | 
        chomkae@suttonschools.net | 
      
      
        | 
          School / Organization
         | 
        Sutton (MA) High School | 
      
      
        | 
          Date submitted
         | 
        1/26/09 | 
      
      
        | 
          Date updated
         | 
        4/18/14 |