Reflection And Refraction Lab
Reflection and Refraction
Part 1 - Reflection
DATA TABLE:
Incident angle, θi
30
45
60
Reflected angle, θr
What can you conclude about the relationship of θi and θr? Does this verify the law of reflection?
Part 2 - Reflection:
Step I - Find the image location, circle that point and label it “I”. Measure and record the object distance do and the image distance di. What can you say about the location of the image?
Step J - Is the image real or virtual?
Part 3 - Refraction and the Refractive Index of Water:
Data Table
Experiment
Incident angle, θi
Refracted angle, θr
Index of refraction, n
1
2
3
Average value of the index of refraction, navg = _______________________.
Find the percent difference between the known value and your average experimental value.
Part 4 - Refraction and Refractive Index:
Data Table
Experiment
Incident angle, θi
Refracted angle, θr
Index of refraction, n
1
2
3
Average value of the index of refraction, navg = _______________________.
Find the percent difference between the known value of 1.49 and your average experimental value.
Lab Manual
Physics 2
LabPaq: PK-2
A Lab Manual of 11 Experiments for Independent Study
Published by Hands-On Labs, Inc.
Physics 2: Lab Manual of Experiments for the Independent Study of Physics
Designed to accompany Physics LabPaq PK-2 081611
LabPaq® is a registered trademark of Hands-On Labs, Inc. (HOL). The LabPaq referenced in this manual is produced by Hands-On Labs, Inc. which holds and reserves all copyrights on the intellectual properties associated with the LabPaq’s unique design, assembly, and learning experiences. The laboratory manual included with a LabPaq is intended for the sole use by that LabPaq’s original purchaser and may not be reused without a LabPaq or by others without the specific written consent of HOL. No portion of any LabPaq manual’s materials may be reproduced, transmitted or distributed to others in any manner, nor may they be downloaded to any public or privately shared systems or servers without the express written consent of HOL. No changes may be made in any LabPaq materials without the express written consent of HOL. HOL has invested years of research and development into these materials, reserves all rights related to them, and retains the right to impose substantial penalties for any misuse.
Published by: Hands-On Labs, Inc.
3880 S. Windermere St. Englewood, CO 80110 Phone: 303-679-6252 Toll-free: 1-866-206-0773 Fax: 270-738-0979
www.LabPaq.com
E-mail: Info@LabPaq.com
Printed and bound in the United States of America.
ISBN: 978-1-866151-40-6
The experiments in this manual have been and may be conducted in a regular formal laboratory or classroom setting with the user providing their own equipment and supplies. The manual was especially written, however, for the benefit of independent study students who do not have convenient access to such facilities. It allows them to perform physics experiments at home or elsewhere by using LabPaq PK-2, a collection of experimental equipment and supplies specifically packaged by Hands-On Labs, Inc. to accompany this manual.
Use of this manual and authorization to perform any of its experiments are expressly conditioned upon the user reading, understanding, and agreeing to abide by all the safety precautions contained herein. Although the author and publisher have exhaustively researched all sources to ensure the accuracy and completeness of the information contained in this book, we assume no responsibility for errors, inaccuracies, omissions or any other inconsistency herein. Any slight of people, organizations, materials or products is unintentional.
Table of Contents Introduction .................................................................................................................................. 4
Important Information to Help Students Study Science ..................................................... 4 WELCOME TO THE WORLD OF SCIENCE! ................................................................................ 4
Laboratory Equipment and Techniques ........................................................................... 13 Use, Disposal, and Cleaning Instructions for Common Materials ................................... 19
HOW TO WRITE LAB NOTES AND LAB REPORTS .................................................................. 21 Lab Notes .......................................................................................................................... 21 Lab Reports ....................................................................................................................... 23 Laboratory Drawings ......................................................................................................... 27 Visual Presentation of Data .............................................................................................. 28 Computer Graphing Using MS Excel ................................................................................. 32
SAFETY CONCERNS ............................................................................................................... 40 Basic Safety Guidelines .................................................................................................... 41 Material Safety Data Sheets ............................................................................................. 46 Science Lab Safety Reinforcement Agreement ............................................................... 50
EXPERIMENTS 1. Static Electricity or Electrostatics .................................................................................... 53 2. Electric Fields ................................................................................................................... 63 3. Introduction to Electrical Circuits .................................................................................... 74 4. Resistors in Series and Parallel ...................................................................................... 87 5. Semiconductor Temperature Sensor .............................................................................. 96 6. Capacitance in a Circuit ................................................................................................. 102 7. Electric Motor ................................................................................................................. 113 8. Reflection and Refraction .............................................................................................. 119 9. Diffraction Grating ......................................................................................................... 130 10.Polarized Light ............................................................................................................... 141 11.Radioactive Decay ......................................................................................................... 147 APPENDIX Using Statistics .................................................................................................................... 154
© Hands-On Labs, Inc. LabPaq PK-2 4
Introduction Important Information to Help Students Study Science
Version 09.3.05
WELCOME TO THE WORLD OF SCIENCE! Don't be afraid to take science courses. When you complete them, you will be very proud of yourself and will wonder why you were ever afraid of the “S” word – Science! After their first science course most students say they thoroughly enjoyed it, learned a lot of useful information relevant to their personal lives and careers, and only regret not having studied science sooner. Science is not some mystery subject comprehended only by eggheads. Science is simply a way of learning about our natural world and how it works by testing ideas and making observations. Learning about the characteristics of the natural world, how those characteristics change, and how those characteristics interact with each other make it easier to understand ourselves and our physical environment and to make the multitude of personal and global decisions that affect our lives and our planet. Plus, science credits on an academic transcript are impressive, and your science knowledge may create some unique job opportunities. All sciences revolve around the study of natural phenomena and require hands-on physical laboratory experiences to permit and encourage personal observations, discovery, creativity, and genuine learning. As increasing numbers of students embrace online and independent study courses, laboratory experiences must remain an integral part of science education. This lab manual’s author and publisher are science educators who welcome electronic technology as an effective tool to expand and enhance instruction. However, technology can neither duplicate nor replace learning experiences afforded to students through traditional hands-on laboratory and field activities. This does not mean that some experiments cannot or should not be replaced or reinforced by computer simulations; but any course of science study must also provide sufficient hands-on laboratory and field experiences to:
Engage students in open-ended, investigative processes by using scientific problem solving.
Provide application of concepts students have seen in their study materials which
reinforce and clarify scientific principles and concepts.
Involve multiple senses in three-dimensional rather than two-dimensional learning experiences that are important for greater retention of concepts and for accommodation of different leaning styles.
© Hands-On Labs, Inc. LabPaq PK-2 5
Stimulate students to understand the nature of science including its unpredictability
and complexity.
Provide opportunities to engage in collaborative work and to model scientific attitudes and behavior.
Develop mastery of techniques and skills needed for potential science, engineering, and technology careers.
Ensure advanced placement science courses transfer to college credit.
The knowledge gained from science courses with strong laboratory components enables students to understand in practical and concrete ways their own physical makeup, the functioning of the natural world around them, and contemporary scientific and environmental issues. It is only by maintaining hands-on laboratory experiences in our curricula that the brightest and most promising students will be stimulated to learn scientific concepts and avoid being turned-off by lecture- and textbook-only approaches. Physical experimentation may offer some students their only opportunity to experience a science laboratory environment. All students – as potential voters, parents, teachers, leaders, and informed citizens – will benefit from a well-rounded education that includes science laboratory experiences, when it is time for them to make sound decisions affecting the future of their country and the world. 19th century scientist, Ira Remsen (1846-1927) on the subject of Experimentation:
© Hands-On Labs, Inc. LabPaq PK-2 6
This lab manual can be used by all students, regardless of the laboratory facilities available to them. The experiments are based on the principles of micro- and small-scale science which have been successfully used in campus laboratories for decades. LabPaq’s micro- and small-scale experiments can also be performed at home, in a dorm room, or at a small learning center that lacks a formal laboratory. What are Micro- and Small-scale Experiments? You may be among the growing number of students to take a full-credit, laboratory science course through independent study, due to the development and perfection of micro-scale and small-scale experimentation techniques over the past half century. While experimentation on any scale is foundational to fully understanding science concepts, science courses in the past have required experimentation to be performed in the campus laboratory due to the potential hazards inherent in traditional experimentation. Potential hazards, increasing chemical, specimen, and science equipment costs, and environmental concerns made high schools, colleges, and universities reexamine the traditional laboratory methods used to teach science. Scientists began to scale down the quantities of materials and the size of equipment used in experiments and found reaction results remained unchanged. Over time, more and more traditional science experiments were redesigned to be performed on micro and small scales. Educational institutions eventually recognized that the scientific reaction, not the size of the reaction, facilitates learning. Successive comparative assessments have proven that students’ learning is not impaired by studying small-sized reactions. Many assessments even suggest that science learning is enhanced by small-scale experimentation. The primary pioneer and most prominent contributor to micro- and small-scale experimentation was Dr. Hubert Alyea, a chemistry professor at Princeton University, who began utilizing micro-scale experiments in the 1950s. Dr. Alyea reformatted numerous chemistry experiments and also designed many of the techniques and equipment used in micro- and small-scale science today. In the mid-1990s, Dr. Peter Jeschofnig of Colorado Mountain College pioneered the development of LabPaq’s academically aligned, small-scale experiments that can be performed at home. Hands-On Labs, Inc. has subsequently proven that students can actually perform LabPaq's rigorous science experiments at home and still achieve an equivalent, if not higher, level of learning than their campus-based peers.
© Hands-On Labs, Inc. LabPaq PK-2 7
The Organization of this Lab Manual Before proceeding with your experiments, please thoroughly read and understand each section of this lab manual, so you understand what is expected of you. Introduction and How to Study Science: These sections include important information about general scientific subject matter and specific information about effectively studying science and conducting science experiments. Read these sections carefully and take them to heart! How to Perform an Experiment and Laboratory Equipment and Techniques: Adhering to the procedures described in these sections will greatly facilitate experimental activities. The laboratory techniques and equipment described primarily apply to full-scale experiments and formal laboratories; however, knowledge of these items is important to a basic understanding of science and is relevant to home-based experimentation. How to Write Lab Notes and Lab Reports: Like all serious scientists, you must record formal notes detailing your activities, observations, and findings for each experiment. These notes will reinforce your learning experiences and science knowledge and provide the basis from which you will prepare Lab Reports for your instructor. This section explains how these documents should be organized and prepared. Safety Concerns: The Basic Safety Guidelines and Safety Reinforcement Agreement are the most important sections of this lab manual and should be reviewed before each experiment. The safety sections are relevant to both laboratory and non-laboratory experimentation. The guidelines describe potential hazards as well as basic safety equipment and safety procedures designed to avoid such hazards. Required Equipment and Supplies: If you are performing these experiments in a non- laboratory setting, you must obtain the LabPaq specifically designed to accompany this lab manual. The LabPaq includes all the basic equipment and supplies needed to complete the experiments, except for minor items usually found in the average home or obtained at local stores. At the beginning of each experiment you will find a materials section listing which items are found in the LabPaq and which items you will need to provide. Review this list carefully before you begin an experiment to ensure you have all required items. Experiments: The experiments included in this lab manual were specifically selected to accompany related course materials for a traditional academic term. These experiments emphasize a hands-on, experimental approach for gaining a sound understanding of scientific principles. The lab manual’s rigorous Lab Report requirements help reinforce and communicate your understanding of each experiment’s related science principles and strengthen your communication skills. This traditional, scientific method approach to learning science reflects the teaching philosophy of the authors, Hands-On Labs, Inc., and science educators around the globe.
© Hands-On Labs, Inc. LabPaq PK-2 8
HOW TO STUDY SCIENCE It is unfortunate that many people develop a fear of science somewhere early in life. Yes, the natural sciences are not the easiest subjects to learn; but neither are they the hardest. Like in any other academic endeavor, if you responsibly apply yourself, conscientiously study your course materials, and thoughtfully complete your assignments, you will learn the material. Following are some hints for effectively studying science and any other subject, both on or off campus. Plan to Study: You must schedule a specific time and establish a specific place in which to seriously devote yourself to your studies. Think of studying like you would think of a job. Jobs have specific times and places in which to get the work done, and studying should be no different. Just as television, friends, and other distractions are not permitted on a job, they should not be permitted to interfere with your studies. If you want to do something well, you must be serious about it, and you cannot learn when you are distracted. Only after you have finished your studies should you allow time for distractions. Get in the Right Frame of Mind: Think positively about yourself and what you are doing. Put yourself in a positive frame of mind to enjoy what you are about to learn, and then get to work. Organize any materials and equipment you will need in advance so you don't have to interrupt your work later. Read your syllabus and any other instructions and know exactly what your assignment is and what is expected of you. Mentally review what you have already learned. Write down any questions you have, and then review previous materials to answer those questions. Move on, if you haven't found the answer after a reasonable amount of time and effort. The question will germinate inside your mind, and the answer will probably present itself as you continue your studies. If not, discuss the question later with your instructor. Be Active with the Material: Learning is reinforced by relevant activity. When studying, feel free to talk to yourself, scribble notes, draw pictures, pace out a problem, or tap out a formula. The more physically active things you do with your study materials, the better you will learn. Have highlighters, pencils, and note pads handy. Highlight important data, read it out loud, and make notes. If there is a concept you are having problems with, stand up and pace while you think it through. Try to see the action taking place in your mind. Throughout your day, try to recall things you have recently learned, incorporate them into your conversations, and teach them to friends. These activities will help to imprint the related information in your brain and move you from simple knowledge to true understanding of the subject matter.
© Hands-On Labs, Inc. LabPaq PK-2 9
Do the Work and Think about What You Are Doing: Sure, there are times when you might get away with taking a shortcut in your studies, but in doing so you will probably shortchange yourself. The things we really learn are the things we discover ourselves, which is why we don't learn as much from simple lectures, passive videos, or someone simply telling us the answers to our questions. Discovery learning – figuring things out for ourselves – is the most effective and long-lasting form of learning. When you have an assignment, don't just go through the motions. Enjoy your work, think about what you are doing, be curious, ask yourself questions, examine your results, and consider the implications of your findings. These critical thinking techniques will improve and enrich your learning process. When you complete your assignments independently and thoroughly, you will be genuinely knowledgeable and can be very proud of yourself. How to Study Independently There is no denying that learning through any method of independent study is very different from learning through classes held in traditional classrooms. It takes a great deal of personal motivation and discipline to succeed in a course of independent study where there are no instructors or fellow students to give you structure and feedback. These problems are not insurmountable, and meeting the challenges of independent study can provide tremendous personal satisfaction. The key to successful independent study is having a personal study plan and the personal discipline to stick to that plan. Properly Use Your Learning Tools: The basic tools for web courses and other distance learning methods are often similar, consisting of computer software, videos, textbooks, and study guides. Check with your course instructor to make sure you acquire all the materials you will need. You can obtain these items from campus bookstores, libraries, or the Internet. Related course lectures and videos may even be broadcast on your local public and educational television channels. If you choose to do your laboratory experimentation independently, you will need the special equipment and supplies described in this lab manual and contained in its companion LabPaq. For each study session, first work through the appropriate sections of your course materials, because these serve as a substitute for classroom lectures and demonstrations. Take notes as you would in a regular classroom. Actively work with any computer and text materials, carefully review your study guide, and complete all related assignments. If you do not feel confident about the material covered, repeat the previous steps until you do. It is wise to always review your previous work before proceeding to a new section to reinforce what you’ve previously learned and prepare you to better absorb new information. Actual experimenting is among the last things done in a laboratory session.
© Hands-On Labs, Inc. LabPaq PK-2 10
Plan to Study: A normal science course with a laboratory component may require you to spend as many as 15 hours a week studying and completing your assignments. To really learn new material requires at least three hours of study time each week for each hour of course credit taken. This applies as equally to independent study as it does to regular classroom courses. On a school campus science students are usually in class for three hours and in the laboratory for two to three hours each week. Then, they still need at least nine hours to read their text and complete their assignments. Knowing approximately how much time is required will help you formulate a study plan at the beginning of the course. Schedule Your Time Wisely: The more often you interact with study materials and call them to mind, the more likely you are to reinforce and retain the information. It is much better to study in several short blocks of time rather than in one long, mind-numbing session. Accordingly, you should schedule several study periods throughout the week or during each day. Please do not try to do all of your study work on the weekends! You will burn yourself out, you won't learn as much, and you will probably end up feeling miserable about yourself and science too. Wise scheduling can prevent such unpleasantness and frustration. Choose the Right Place for Your Home Laboratory: The best place to perform at-home experiments will be determined by the nature of the individual experiments. However, this place is usually an uncluttered room where a door can be closed to keep out children and pets; a window or door can be opened for fresh air ventilation and fume exhaust; there is a source of running water for fire suppression and cleanup; and there is a counter or tabletop work surface. A kitchen usually meets all these requirements. Sometimes the bathroom works too, but it can be cramped and subject to interruptions. Review each experiment before starting any work to help you select the most appropriate work area. Because some of the equipment and supplies in your LabPaq may pose dangers to small children and animals, always keep safety in mind when selecting a work area, and always choose an area where you cannot be disturbed by children or pets. Use a Lab Partner: While the experiments in the LabPaq can be performed independently, it is often fun and useful to have a lab partner to discuss ideas with, help take measurements, and reinforce your learning process. Whether your partner is a parent, spouse, sibling, or friend, you will have to explain what you are doing, and in the process of teaching another, you will better teach yourself. Always review your experiments several days ahead of time so you have time to line up a partner if needed. Perform Internet Research: Students in today’s electronic information age are often unaware of how fortunate they are to have so much information available at the click of a mouse. Consider that researchers of the past had to physically go to libraries, search through card catalogs for possible sources of information, and wait weeks to receive books and journals that may not contain the information they needed. Then they had to begin their search all over again! Now you can find information in a matter of minutes.
© Hands-On Labs, Inc. LabPaq PK-2 11
Since most courses today include online components, it is assumed that you have reasonable computer skills. If you make ample use of those skills and include online research as part of your study routine, you can greatly enhance your depth of learning as well as improve your grades. Keep a web browser open as you review your course materials and laboratory assignments. When you encounter words and concepts that you have difficulty fully understanding, perform a quick web search and review as many sites as needed until the definition or concept is clear in your mind. Web searches are especially valuable in science. For example, if you have difficulty with a concept, you can usually perform an image search that will help visually clarify the object of interest. Perform a text search to find descriptions and information from leading scientists at famous institutions all over the world. For unfamiliar terms, enter the word “define” plus the unfamiliar term into your search engine and a myriad of differently phrased definitions will be available to help you. This lab manual lists numerous respected websites that you may find useful, and you will undoubtedly find many more on your own. Rely only on trusted government and educational institutions as sources for valid research data. Be especially skeptical of and double-check information garnered from personal blogs and wiki sites like wikipedia.org, where anyone, regardless of their expertise or integrity, can post and edit information. As students all over the world are finding, the worldwide web is a treasure trove of information, but not all of it is valid! Finally, while website links in this lab manual were valid at the time of printing, many good websites become unavailable or change URLs. If this happens, simply go to one of the other sites listed or perform a web search for more current sites. HOW TO PERFORM AN EXPERIMENT Although each experiment is different, the process of preparing, performing, and recording an experiment is essentially the same. Read the Entire Experiment before You Start: Knowing what you are going to do before you do it will help you organize your work and be more effective and efficient. Review Basic Safety: Before beginning work on any experiment, reread the lab manual’s safety sections, try to foresee any potential hazards, and take appropriate steps to prevent safety problems. Organize Your Work Space, Equipment, and Materials: It is hard to organize your thoughts in a disorganized environment. Assemble all required equipment and supplies before you begin working.
© Hands-On Labs, Inc. LabPaq PK-2 12
Outline Your Lab Notes: Outline the information needed for your Lab Notes and set up any required data tables before the experiment, to make it easier to enter observations and results as they occur. LabPaq CDs normally include a Report Assistant containing .rtf files of each experiment’s questions and data tables. These files can be copied and pasted into your Lab Notes to facilitate your compilation of data and text information. Perform the Experiment According to Instructions: Follow all directions precisely in sequential order. This is not the time to be creative. Do not attempt to improvise your own procedures! Think About What You Are Doing: Stop and give yourself time to reflect on what has happened in your experiment. What changes occurred? Why? What do they mean? How do they relate to the real world of science? This step can be the most fun and often creates "light bulb" experiences of understanding. Clean Up: Always clean your laboratory space and laboratory equipment immediately after use. Wipe down all work surfaces that may have been exposed to chemicals or dissection specimens. Blot any unused chemicals with a paper towel or flush them down the sink with generous amounts of water. Wrap dissection specimens in newspaper and plastic and place them in a sealed garbage can. Discard used pipets and other waste in your normal trash. Return cleaned equipment and supplies to their LabPaq box and store the box out of reach of children and pets. Complete Your Work: Complete your Lab Notes, answer the required questions, and prepare your Lab Report. If you have properly followed all the above steps, the conclusion will be easy.
Why Experimental Measurements Are Important:
We measure things to know something about them, to describe objects, and to understand phenomena. Experimental measurement is the cornerstone of the scientific method; thus, no theory or model of nature is tenable unless the results it predicts are measurable and in accordance with the experiment.
© Hands-On Labs, Inc. LabPaq PK-2 13
Your primary tasks in a science laboratory course are to create experimentally measured values, compare your results to accepted theoretical or measured values, and gain a full understanding of scientific concepts. This is true for experiments done both inside and outside of a formal laboratory. Each experiment is predicated upon a theory of scientific principle and represents a test of that theory through experimentation, observation, measurements, and analysis.
Laboratory Equipment and Techniques While many of these techniques and equipment are most applicable to specific science disciplines in formal laboratory facilities, knowledge of these items is often required for the study of other science disciplines and when working in a home laboratory. Dispensing Chemicals: To avoid contamination when pouring liquid chemicals from a reagent (ree-ey-juhnt) bottle with a glass stopper, hold the stopper in your fingers while carefully pouring the liquid into the desired container. When pouring from a screw-cap bottle, set the cap down on its top so that it does not become contaminated or contaminate anything. Be certain to put the correct cap on the bottle after use. Never pour excess chemicals back into a reagent bottle, because this may contaminate the reagents. If any liquid spills or drips from the bottle, clean it up immediately. To obtain samples of a powdered or crystalline solid from a container, it is best to pour the approximate amount of solid into a clean, dry beaker or onto a small piece of clean, creased paper for easy transport. Pour powders and crystals by tilting the container, gently shaking and rotating the solids up to the container lip, and allowing the solids to slowly fall out. If you pour too much solid, do not put any solid back in the container. Also, never put wooden splints, spatulas, or paper into a container of solids to avoid contamination. Dropping Chemicals: In micro-scale science, you use only small drops of chemicals, and it is extremely important that the drops are uniform in size and carefully observed. To ensure uniformity of drop size, use scissors to cut off the tip of the pipet perpendicular to the pipet body; cutting at an angle will distort drop sizes. Turn the pipet upside down so the dispensing chamber behind the dropper is full of liquid. Then hold the dropper in front of your eyes so you can carefully observe and count the number of drops dispensed as you slowly squeeze the pipet.
You can see the incorrect (left) and correct (right) way to dispense drops. The pipet should be held in a vertical position at eye level to ensure drops are uniform in size and the correct drops are dispensed.
© Hands-On Labs, Inc. LabPaq PK-2 14
Heating Chemicals: Heat solid and liquid chemicals with great care to prevent explosions and accidents.
Liquids in Beakers: To heat liquids in beakers or flasks, ensure that these containers are well supported above the heat source. Generally, the beaker or flask is placed on wire gauze supported by an iron support attached to a stand. The heat source is placed under the beaker or flask. Liquids in Test Tubes: When heating liquids in test tubes, always use a test tube holder. Evenly heat the test tube contents by carefully moving the test tube back and forth in the flame. Heat the test tube near the top of the liquid first; heating the test tube from the bottom may cause the liquid to boil and eject from the tube.
Heating Sources for Small-scale Techniques: For micro- and small-scale science experimentation, the most commonly used heat sources are alcohol burners, candles, and burner fuel. Alcohol burners can be a problem because their flame is almost invisible, and they cannot be refilled while hot. Candles, while effective for heating small quantities of materials, tend to leave a sooty, carbon residue on the heated container that obstructs observations. Sterno and similar alcohol based fuels are very volatile and cannot be safely shipped; however, the Glycol-based fuel used in LabPaqs is safe to ship. Chafing dish (i.e., burner fuel) is actually the best of these alternatives because it has a visible flame, is easily extinguished, and does not leave excessive flame residue. Regardless of the type of burner used, never leave an ignited heat source unattended. Mass Measurement Equipment: Note that weighing scales are often called balances since weights are calculated using balance beams. Triple and quadruple beam balances are the most common measuring equipment found in laboratories. However, with today's precision technology, digital top-loading balances are becoming increasingly popular.
Triple and Quadruple Beam Scale: These balances typically include a hanging pan and vary in their degree of accuracy. After the scale has been set at zero, the object to be weighed is placed in the hanging pan, and balancing weights are added or subtracted by moving a pointer across a horizontal bar scale. When exact scale is achieved, the pointer indicates the object’s mass. Digital Top Loading Balance: This scale is initially zeroed by pressing the zero button. If your are using weighing paper or a small beaker, first tare the paper or beaker by placing it on the scale and pressing the tare button. This will produce a zero reading, and the weight of the paper or beaker will be excluded from the weighing process. Hanging Spring Scales: Measurements are taken by suspending the item from a scale, often within a container. Spring scales are not easily tared, so the container weight should be separately calculated and subtracted from the combined weight of the item and the container.
© Hands-On Labs, Inc. LabPaq PK-2 15
The Non-digital Analytical Balance: This instrument is very delicate, and the instructions for its use are quite detailed. Because of its extreme sensitivity, weighing on the analytical scale must be carried out in a closed chamber that is free from drafts. This instrument is seldom used by first-year science students.
Volume Measurement Equipment: To obtain accurate measurements from any glass volume measurement container, such as a beaker or graduated cylinder, you must identify and correctly read a curved surface known as the meniscus. The meniscus of water and water- based solutions concaves downward and is read at the very bottom of its curve. A mercury meniscus is convex and is read at the very top of its curve. There is no meniscus issue associated with plastic containers. Filtration Equipment: Gravity filtration is used to remove solid precipitates or suspended solids from a mixture. It works like a small funnel or spaghetti strainer, except that it is lined with fine, conical filter paper to trap the solids. After pouring a mixture into the filter from a beaker, use a special spatula, called a rubber policeman, to scrape any remaining solids from the beaker wall into the conical filter paper. Then, use a wash bottle to rinse residue from both the beaker and rubber policeman into the filter cone to ensure that all the mixture's particles pass through the filter. Suction filtration uses a vacuum to suck a mixture through a filter. It is much faster than but not always as efficient as gravity filtration. The required vacuum is usually created by the aspirator of a laboratory water faucet. Bunsen Burner: This old, tried-and-true heat source relies on the combustion of natural or bottled gas. To achieve the best flame, you must properly adjust the burner's gas inlet valve and air vent. Open the valves only halfway before lighting the burner. The safest way to light the burner is to bring a lighted match to the flame opening from the side, not the top. When the burner is lit, close the air vent and adjust the gas inlet valve until the flame is approximately 10 cm high. The flame should be luminous and yellow. Next, open the air vent until the flame becomes two concentric cones. The outer cone will be faintly colored and the inner cone will be blue. The hottest part of the flame is at the tip of the blue cone. Graduated Cylinder: Graduated cylinders are available in a wide range of sizes. To read a volume in a graduated cylinder, hold the cylinder at eye level so the contents level and you can directly view the meniscus. Looking at a meniscus from below or above will create parallax and cause a false reading. Always read any scale to the maximum degree possible, including an estimate of the last digit. Buret: Burets are long, graduated tubes usually used in titration. They have a stopcock or valve on the bottom that allows you to dispense liquids in individual drops and accurately measure the quantity dispensed. Use caution when opening the stopcock to ensure that only one drop is dispensed at a time. Pipet: Pipets are small tube-type containers with openings at one end if made of plastic or at both ends if made of glass. They come in a range of volumes and are generally used to transfer specific amounts of liquids from one container to another.
© Hands-On Labs, Inc. LabPaq PK-2 16
Berel Pipet: These soft and flexible pipets are made of polyethylene plastic and are extensively used in LabPaqs. They have long, narrow tips and are used to deliver chemicals and to collect products. Berel pipets come in different sizes, and their tips can have different diameters and lengths. You can modify them to serve diverse purposes such as chemical scoops, gas generators, or reaction vessels. Volumetric Flask: Volumetric flasks are pear-shaped flasks with long necks used for the preparation of solutions whose concentrations need to be very accurate. Flasks come in a variety of sizes ranging from a few milliliters to several liters, and their volume levels are precisely marked. When the liquid level inside a volumetric flask is such that the meniscus lines up with the calibration mark on the neck, the volume of the liquid is exactly as stated. Unlike volumetric flasks, the markings on beakers, Erlenmeyer flasks, and most other laboratory containers are very good approximates but are not intended to be exact and precise volume measurements. Wash Bottles: These plastic squeeze bottles produce a small stream of water that can be easily dispensed as needed (e.g., washing out residue from a container). The bottles usually contain distilled or deionized water and are typically used to top off the last few milliliters of a vessel and avoid overfilling. In micro- and small-scale experimentation, plastic pipets are used for similar functions. Tissue Culture Well Plates: These microplates are plastic trays containing numerous shallow wells arranged in lettered rows and numbered columns. Similar to test tubes and beakers, you can use the wells to observe reactions, to temporarily store chemicals during experiments, and to hold pipets. The most commonly used plates are 24-well and 96-well. Distilled Water and Deionized Water: Tap water frequently contains ions that may interfere with the substances you are studying. To avoid such interference, use distilled or deionized water any time water is needed for dilution of concentration or the preparation of experimental solutions. Wash used glassware with soap, rinse with tap water, and rinse again with distilled water.
© Hands-On Labs, Inc. LabPaq PK-2 17
© Hands-On Labs, Inc. LabPaq PK-2 18
© Hands-On Labs, Inc. LabPaq PK-2 19
Use, Disposal, and Cleaning Instructions for Common Materials These procedures are not repeated for each experiment, because it is assumed students will always refer to them before beginning any experiment. Properly cleaning the laboratory after experimentation is a safety measure! Instrument Use
Small quantities of chemicals are usually packaged in thin stem pipets. The drop size dispensed from small dropper bottles is different from that of the pipets. Most experiments require pipet-sized drops. It may be necessary to squeeze a few drops of chemical from a dropper bottle into a well plate, and then use a clean, empty pipet to suck up and drop the chemical.
Once dispensed, do not return chemicals to their dropper bottles as this could cause
contamination. To avoid over-dispensing, squeeze out only a few drops of chemicals into a well plate at a time. Squeeze out more as needed.
To use burner fuel, unscrew the cap, light the wick, and place the can under a burner
stand. Extinguish the fuel by gently placing the cap over the flame to deprive it of oxygen. Leave the cap sitting loosely on top of the wick when you are not using the fuel in order to avoid unnecessary evaporation and ensure an ample supply of fuel for all experiments. Allow the fuel to cool completely before tightly screwing on the cap for storage. If you screw the cap on while the fuel is still hot, you may create a vacuum that will make it very difficult to reopen the fuel can in the future.
To reseal a pipet, heat the tip of a metal knife and press the pipet tip onto the hot
metal while twirling the bulb. Never simply hold a flame to the tip of the stem!
To minimize contamination, avoid touching the surfaces of clean items that might later come in contact with test chemicals.
Storage and Disposal
Items in LabPaq auxiliary bags are generally used multiple times or for several different experiments. Always clean and return unused auxiliary items to the bag after completing an experiment.
Blot up used and leftover chemicals with paper towels and place in a garbage bin or
flush down a drain using copious amounts of water. The quantities of chemicals used in LabPaqs are very small and should not negatively impact the environment or adversely affect private septic systems or public sewer systems.
Discard non-chemical experimental items with household garbage but first wrap
them in newspaper. Place these items in a securely covered trash container that cannot be accessed by children and animals.
© Hands-On Labs, Inc. LabPaq PK-2 20
LabPaqs containing dissection specimens will usually contain specific information
regarding their handling. After completion of any dissecting work, wrap dissection specimens in news or waste paper, seal in a plastic bag, and place in a closed trash bin for normal garbage disposal.
Cleaning Instructions
To clean a thin-stemmed plastic pipet, squeeze the bulb to draw up and then expel tap water from the bulb several times. Repeat this process with distilled water. Dry the pipet by repeatedly squeezing the bulb while tapping the tip on a clean paper towel. Then use gravity to help dry the pipet by forcefully swinging the pipet into a downward arch while squeezing the bulb. Lay the pipet on a clean paper towel or place it in a test tube stand and allow it to air dry.
Use a mild liquid dishwashing detergent mixed with warm water to loosen solids or
oils that adhere to experimental glassware, plastics, and equipment and to clean laboratory equipment and the laboratory area after an experiment. Use tap water to rinse washed items well and remove all traces of detergent.
Use a soft cloth or a test tube brush to loosen and clean residue from the surfaces of
experimental glassware, plastics, and equipment.
Use a final rinse of distilled water to clean tap water mineral residue from newly washed items, especially beakers, cylinders, test tubes, and pipets.
Dry test tubes by placing them upside down in the test tube rack. Air dry other items
by placing them on paper towels, aluminum foil, or a clean dishtowel. Important Notice Regarding Chemical Disposal: Due to the minute quantities and diluted and/or neutralized chemicals used in LabPaqs, the disposal methods previously described are well within acceptable levels of disposal guidelines defined for the vast majority of local solid and wastewater regulations. Since regulations occasionally vary in some communities, you are advised to check with your local area waste authorities to confirm these disposal techniques are in compliance with local regulations and/or if you should seek assistance with disposal.
© Hands-On Labs, Inc. LabPaq PK-2 21
HOW TO WRITE LAB NOTES AND LAB REPORTS Generally two basic records are compiled during and from scientific experimentation. The first record is your Lab Notes which you will record as you perform your experiments. Entries in your lab notebook will be the basis for your second record, the Lab Report. The Lab Report formally summarizes the activities and findings of your experiment and is normally submitted to your instructor for grading.
Lab Notes Scientists keep track of their experimental procedures and results as they work by recording Lab Notes in a journal-type notebook. In laboratories these notebooks are often read by colleagues, such as directors and other scientists working on a project. In some cases scientific notebooks have become evidence in court cases. Consequently, Lab Notes must be intelligible to others and include sufficient information so that the work performed can be replicated and there can be no doubt about the honesty and reliability of the data and the researcher. Notebooks appropriate for data recording are bound and have numbered pages that cannot be removed. Entries include all of your observations, actions, calculations, and conclusions related to each experiment. Never write data on pieces of scratch paper to transfer later, but always enter the data directly into the notebook. When you record erroneous data, neatly draw a light, diagonal line through the error, and write a brief explanation as to why you voided the data. Also record information you learn from an error. Mistakes can often be more useful than successes, and knowledge gained from them is valuable to future experimentation. As in campus-based science laboratories, independent study students are expected to keep a complete scientific notebook of their work which may or may not be periodically reviewed by the instructor. Paperbound 5x7 notebooks of graph paper work well as lab notebooks. Since it is not practical to send notebooks back and forth between instructors and students for each experiment, independent study students usually prepare formal Lab Reports and submit them along with their regular assignments to the instructor via email or fax. Lab Notes of experimental observations can be kept in many ways. Regardless of the procedure followed, the key question for deciding what kind of notes to keep is: Do I have a clear enough record that if I pick up my lab notebook or read my Lab Report in a few months, I can still explain to myself or others exactly what I did? Lab Notes generally include these components:
Title: Match the title to the title stated in the lab manual.
Purpose: Write a brief statement about what the experiment is designed to determine or demonstrate.
© Hands-On Labs, Inc. LabPaq PK-2 22
Procedure: Briefly summarize what you did to perform this experiment and what equipment you used. Do not simply copy the procedure statement from the lab manual.
Data Tables: Always prepare tables before experimenting, so they will be ready to receive data as it is accumulated. Tables are an excellent way to organize your observational data, and where applicable, the Procedure section advises a table format for data recording.
Observations: Record what you observed, smelled, heard, or otherwise measured? Generally, observations are most easily recorded in table form.
Questions: Thoughtfully answer the questions asked throughout and at the end of experiments. The questions are designed to help you think critically about the experiment you just performed.
Conclusions: What did you learn from the experiment? Base your conclusions on your observations during the experiment. Write your conclusions in your best, formal English, using complete sentences, full paragraphs, and correct spelling.
Some general rules for keeping a lab notebook are:
1. Leave the first two to four pages blank so you can add a Table of Contents later. Entries in the Table of Contents should include the experiment number, name, and page number.
2. Neatly write your records without being fussy. 3. Do not provide a complete Lab Report in your lab notebook. Instead, record what you
did, how you did it, and what your results were. Your records need to be substantial enough that any knowledgeable person familiar with the subject of your experiment can read the entries, understand exactly what you did, and repeat your experiment if necessary.
4. Organize all numerical readings and measurements in appropriate data tables. Refer
to the sample Lab Report in this lab manual. 5. Always identify the units (e.g., centimeters, kilograms, or seconds) for each set of
data you record. 6. Always identify the equipment you are using so you can refer to it later if you need to
recheck your work. 7. Capture the important steps and observations of your experiments using digital
photos in which you are pictured. Photos within your Lab Report document both what you observed and that you actually performed the experiment.
© Hands-On Labs, Inc. LabPaq PK-2 23
8. Record more rather than less data. Even details that may seem to have little bearing on your experiment (e.g., time and temperature variances when the data were taken) may turn out to have great bearing on your future results analysis.
9. Make a note if you suspect that a particular data set may not be reliable. 10. Never erase data. If you think an entry in your notes is in error, draw a single line
through it and note the correction, but don’t erase or scratch it out completely. You may later find that the information is significant after all.
Errors: Although experimental results may be in considerable error, there is never a wrong result in an experiment. Whatever happens in nature, including the laboratory, cannot be wrong. If you made your observations and measurements carefully, your results will be correct. Errors may have nothing to do with your investigation, or they may be mixed up with so many other unexpected events that your report is not useful. Even errors and mistakes have merit and often lead to our greatest learning experiences. Errors provide important results to consider; thus, you must think carefully about the interpretation of all your results, including your errors. Experiment Completion: The cardinal rule in a laboratory is to fully carry out all phases of your experiments instead of “dry-labbing” or taking shortcuts. The Greek scientist, Archytas, summed this up very well in 380 B.C.:
Lab Reports This lab manual covers the overall format that formal Lab Reports generally follow. Remember, the Lab Report should be self-contained, so anyone, including someone without a science background or lab manual, can read it, understand what was done, and understand what was learned. Data and calculation tables have been provided for many of the experiments in this lab manual, and you are encouraged to use them. Computer spreadsheet programs such as Microsoft® Excel® and websites like nces.ed.gov/nceskids/Graphing/Classic/line.asp can also greatly facilitate the preparation of data tables and graphs. Visit www.ncsu.edu/labwriter/ for additional information on preparing Lab Reports.
© Hands-On Labs, Inc. LabPaq PK-2 24
Lab Reports are expected to be word processed and to look organized and professional. They should be free of grammar, syntax, and spelling errors and be a respectable presentation of your work. Avoid writing in the first person as much as possible. Lab Reports should generally contain and clearly distinguish the sections discussed in detail below. The presentation and organization skills you’ll develop by producing science Lab Reports is beneficial to all potential career fields. Lab Report Format: Title Page This is the first page of the Lab Report and consists of:
a. Experiment number and/or title b. Your name c. Names of lab partner(s) d. Date and time experiment was performed e. Location if work was performed in the field f. Course number
Section 1: Abstract, Experiment, and Observation Abstract: Even though the abstract appears at the beginning of the Lab Report, you will write it last. An abstract is a very concise description of the experiment’s objectives, results, and conclusions and should be no longer than a paragraph. Experiment and Observation: In chronological order, carefully and concisely describe what was done, what was observed, and what, if any, problems were encountered. Describe what field and laboratory techniques and equipment you used to collect and analyze the data on which the conclusions are based. Insert photos and graphic illustrations in this section; graphics should be in .jpg or .gif format to minimize electronic file size. Show all your work for any calculations performed. Title every graph and clearly label the axes. Data point connections should be “best-fit curves,” which are smooth, straight or curved lines that best represent the data, instead of dot-to-dot data point connections.
Include all data tables, photos, graphs, lists, sketches, etc. in an organized fashion. Include relevant symbols and units with data. Generally one or two sentences explaining how data was obtained is appropriate for each data table.
Note any anomalies observed or difficulties encountered in collecting data as these may affect the final results. Include information about any errors you observed and what you learned from them. Be deliberate in recording your experimental procedures in detail. Your comments may also include any preliminary ideas you have for explaining the data or trends you see emerging.
© Hands-On Labs, Inc. LabPaq PK-2 25
Section 2: Analysis – Calculations, Graphs, and Error Analysis Generally, the questions at the end of each experiment will act as a guide when preparing your results and conclusions. The analysis is written in paragraph form and no more than one or two pages long. As you write, consider the following:
a. What is the connection between the experimental measurements taken and the final results and conclusions? How do your results relate to the real world?
b. What were the results of observations and calculations? c. What trends were noticed? d. What is the theory or model behind the experiment? e. Do the experimental results substantiate or refute the theory? Why? Be sure to refer
specifically to the results you obtained. f. Were the results consistent with your original predictions of outcomes or were you
forced to revise your thinking?
g. Did errors (e.g., environmental changes or unplanned friction) occur? If so, how did these errors affect the experiment?
h. Did any errors occur due to the equipment used (e.g., skewed estimates due to a lack
of sufficient measurement gradients on a beaker)?
i. What recommendations might improve the procedures and results? Error Analysis: In a single paragraph, comment on the accuracy and precision of the apparatuses used, include a discussion of the experimental errors, and include an estimate of the errors in your final result. Remember, errors are not mistakes. Errors arise because the apparatus and/or the environment inevitably fail to match the ideal circumstances assumed when deriving a theory or equation. The two principal sources of error are:
Physical phenomena: Elements in the environment may be similar to the phenomena being measured and may affect the measured quantity. Examples include stray magnetic or electric fields or unaccounted for friction. Limitations of the observer, analysis, and/or instruments: Examples include parallax error when reading a meter tape, the coarse scale of a graph, and the sensitivity of the instruments.
Human errors and mistakes that are not acceptable scientific errors include: calculator misuse (e.g., pushing the wrong button, misreading the display); misuse of equipment; faulty equipment; incorrectly assembled circuits or apparatuses.
© Hands-On Labs, Inc. LabPaq PK-2 26
Section 3: Discussion, Results, and Conclusions Discussion: Carefully organize your discussion to include consideration of the experiment’s results, interpretation of the results, and uncertainty in the results. This section is written in paragraph form and is generally no more than one to two pages in length. Occasionally it will be more appropriate to organize various aspects of the discussion differently. While not all of the following questions will apply to every experiment, consider them when writing your Lab Report. Results:
a. What is the connection among your observations, measurements, and final results? b. What were the independent or dependent variables in the experiment? c. What were the results of your calculations? d. What trends were noticeable? e. How did the independent variables affect the dependent variables? For example, did
an increase in a given independent variable result in an increase or decrease in the associated dependent variable?
Interpretation of Results:
a. What is the theory or model behind the experiment you performed? b. Do your experimental results substantiate or agree with the theory? Why or why not?
Be sure to refer specifically to your experimental results. c. Were these results consistent with your original beliefs or were you forced to
reevaluate your prior conceptions? Uncertainty in results:
a. How much did your results deviate from expected values? b. Are the deviations due to error or uncertainty in the experimental method? Can you
think of ways to decrease the amount of uncertainty? c. Are the deviations due to idealizations inherent in the theory? What factors has the
theory neglected to consider?
d. In either case, consider whether your results display systematic or random deviations.
© Hands-On Labs, Inc. LabPaq PK-2 27
Lab Notes and Lab Reports undoubtedly sound complex and overwhelming at first, but don’t worry. They will make more sense to you when you begin performing the experiments and writing reports. After writing your first few Lab Reports, the reports will become second nature to you. Refer to the sample Lab Report in this manual.
Laboratory Drawings Laboratory work often requires you to illustrate findings in representational drawings. Clear, well organized drawings are an excellent way to convey observations and are often more easily understood than long textual descriptions. The adage “a picture is worth a thousand words” really is true when referring to Lab Notes. Give yourself ample drawing space and leave a white margin around the actual illustration so it is clearly visible. Also leave a broad margin along one side of your drawing to insert object labels. Use a ruler to draw straight lines for the labels and connecting lines to the corresponding objects. The image below provides an example of how laboratory drawings should look when they are included in a formal Lab Report. Students often believe they can’t draw; however, with a little practice, anyone can illustrate laboratory observations. A trick many artists use is to form a mental grid over the scene and draw within the grid. For example, quickly make a free hand drawing of the diagram below. Now, mentally divide the diagram into quarters and try drawing the diagram again. In all likelihood, the second, grid-based drawing yielded a better result.
SOURCE OF DRAWING Your Name Such as MUNG BEAN Date of Drawing TITLE OF DRAWING Such as CELL STRUCTURE
© Hands-On Labs, Inc. LabPaq PK-2 28
Visual Presentation of Data Like pictures, good graphs and tables can quickly and clearly communicate information visually; hence, graphs and tables are often used to represent or depict collected data. Graphs and tables should be constructed to stand alone – all the information required to understand a graph or table should be included. Tables A table presents data clearly and logically. Independent data is listed in the left column and all dependent data is listed to the right. While there will be only one independent variable, there can be more than one dependent variable. The decision to present data in a table rather than a graph is often arbitrary; however, a table may be more appropriate when the data set is too small to warrant a graph or is large, complex, and not easily illustrated. Often, data tables display raw data, and a graph provides visualization of the data. Graphs A graph is composed of two basic elements: the graph itself and the graph legend. The legend provides the descriptive information needed to fully understand the graph. In the graph at right, the legend shows that the red line represents Red Delicious apples, the brown line represents Gala apples, and the green line represents Wine Sap apples. Without the legend it would be difficult to interpret this graph. When inserting a graph, choose “Scatter” as the type of graph. Trend line or Line of best fit: To more clearly show the trend between two sets of data, ”lines of best fit” or ”trend lines” are added to data. This enables us to determine the general trend of the data or to better use the data for predictive purposes. Excel or a similar spreadsheet program can easily add a trend line to the data. Use Excel to make a scatter plot of the data and then add a trend line. In most cases the line may not
Plant Height versus Fertilizer Solution X-Axis Y-Axis Fertilizer % solution
Plant Height in cm
0 25 10 34 20 44 30 76 40 79 50 65 60 40
© Hands-On Labs, Inc. LabPaq PK-2 29
pass through very many of the plotted points. Instead, the idea is to get a line that has equal numbers of points on either side. Most people start by viewing the data to see which trend line fits the data the best (i.e. which kind of trend line comes closest to the points). For most (but not all) of the data a linear trend line will provide a good fit. Trendlines are most useful to predict data that is not measured. In interpolation, the trend line is used to construct new data points within the range of a discrete set of known data points. Similarly, a trend line can be used to extrapolate data that are outside of the measured data set. This is illustrated in Figures 1 through 4.
Sample data set:
Time, t (seconds)
Distance, x (cm)
0.1 3.8 0.3 6.1 0.5 7.95 0.8 11
Figure 1: Sample data
Figure 2: Scatter graph of sample data
Figure 3: Scatter graph with a trendline and the equation of the line.
© Hands-On Labs, Inc. LabPaq PK-2 30
As an example of interpolation, if we want to know the cm-displacement at a time of 0.6 s on the Figure 4 Interpolation of data point, we add a vertical line from 0.6 s to the trendline, and then a horizontal line to the distance. This will reads an approximately distance of 9 cm. More accurately, the slope equation of the line may be used to calculate this value: y=10.182 x + 2.885; y = 10.182*0.6+2.885 = 8.99 cm To extrapolate, we would extend the trendline beyond the collected data and repeat the above process. We could also use the slope equation of the line. For example, using the equation to extrapolate the distance at 1 sec. : y = 10.182*1.0+2.885 = 13.1 cm Graph Setup: Consider a simple plot of the Plant Height versus Plant Fertilizer Concentration as shown in one of the data tables above. This is a plot of points on a set of X and Y coordinates. The X-axis or abscissa runs horizontally; the Y-axis or ordinate runs vertically. By convention, the X-axis is used for the independent variable – a manipulated variable in an experiment whose presence determines the change in the dependent variable. The Y-axis is used for the dependent variable – the variable affected by another variable or by a certain event. In this example, the amount of fertilizer is the independent variable and goes on the X-axis. The plant height, since it may change depending on changes in fertilizer amount, goes on the Y-axis. One way to determine which data goes on the X-axis versus the Y-axis
Figure 4: Interpolation of a data point
© Hands-On Labs, Inc. LabPaq PK-2 31
is to think about what affects what. Does fertilizer affect plant height or does plant height affect fertilizer. Only one of these options should make sense. Plant height will not change the fertilizer, but the fertilizer will affect the plant height. The variable that causes the change is independent, and the variable that changes is dependent. If the data deals with more than one dependent variable, it would be represented with three lines and a key or legend would identify which line represents which data set. In all graphs, each axis is labeled, and the units of measurement are specified. When a graph is presented in a Lab Report, the variables, the scale, and the range of the measurements should be clear. Refer to the table below when setting up a line graph.
How to Construct a Line Graph Step Explanation 1 Identify the
variables. Independent variable: Controlled by the experimenter. - Goes on the X-axis – the abscissa. - Located on the left side of a data chart.
Dependent variable: Changes with the independent variable. - Goes on the Y-axis – the ordinate. - Located on the right side of a data table
2 Determine the range.
Subtract the lowest data value from the highest. - Calculate each variable separately.
3 Determine the scale.
Choose a scale that best fits each variable’s range (e.g., increments of one, two, five, etc.). - Choose a scale that spreads the graph over most
of the available space. 4 Number and label
each axis. The axes tell what the graph’s data lines represent. - Always include units of measure (e.g., days, time,
meters, etc.). 5 Plot the data points. Plot each data value on the graph with a dot.
- Add the numerical data next to the dot, if there is room and you avoid cluttering the graph.
6 Draw the graph. Draw a straight or curved line that best fits the data points. - Most graphs are shown as smooth lines, not dot-
by-dot connections. 7 Title the graph. The title should clearly tell what the graph is
depicting. Provide a legend to identify different lines, if the
graph has more than one set of data.
© Hands-On Labs, Inc. LabPaq PK-2 32
Computer Graphing Using MS Excel These instructions apply to the 2003 version of Excel. If you have a newer version, perform an Internet search for current instructions. This set of general instructions will be used to plot the following data:
Time, t (seconds) Distance, x (cm) 0 0 .1 9.8 .2 30.2 .3 59.9 .4 99.2 .5 148.9
When graphing x-y data, you must first determine which variable will be the X-variable and which will be the Y-variable. If you are unsure, review the previous Visual Presentation of Data section. Create a File
1. Open a blank Excel spreadsheet. 2. Save the file under an appropriate name, such as Exercise 1-Time vs
Distance.
Create Data Table
1. Enter the X-data points in the first column (A). 2. Enter the Y-data points in the second column (B).
Note: It is often useful to enter zero as the first data value, but not always. Nonetheless, it is a good habit to start.
3. Highlight all the data values by placing the curser in the first cell to be highlighted (A1) and either:
Clicking and holding the left mouse button while pulling the mouse and
curser down and to the right so the cells are highlighted and then releasing the button.
Holding the key on the keyboard and using the direction arrows to move the cursor over the desired area until all cells are highlighted.
© Hands-On Labs, Inc. LabPaq PK-2 33
Create Graph
4. Click the Chart Wizard icon on the toolbar or select Chart from the Insert menu.
Step 1: Chart Type
5. Select XY (Scatter) from the Standard Types tab. 6. Select your preferred Chart sub-type. Although
you can choose graphs with data points, graphs with smooth lines are preferable.
7. Click Next >.
Step 2: Chart Source Data Carefully review this information to ensure the graph has the correct values for the vertical and the horizontal axes.
8. Select the Columns option button on the Data Range tab.
The range should read =Sheet1!$A$2:$B$7 This means the data:
Comes from Sheet 1 of the workbook. Comes from cells A2 through B7. Has been organized by data columns
instead of data rows.
© Hands-On Labs, Inc. LabPaq PK-2 34
9. Under the Series tab, the values for the X- and Y-axes are as follows:
X Values: =Sheet1!$A$2:$A$7 Y Values: =Sheet1!$B$2:$B$7 This means:
1. The data comes from Sheet 1 of the workbook.
2. The X-value data comes from cells A2 through A7.
3. The Y-value data comes from cells B2 through B7.
Note: If the data is reversed, replace the incorrect column letters and numbers with the correct ones.
10. To maintain the appropriate reference, rename the series of data points from the default, Series1, by entering another name in the Name field. Data is commonly used.
11. Click Next >.
Step 3: Chart Options
12. Chart Options allows you to assign titles and labels to your graph as well as determine the appearance of gridlines and legends. Make your selections.
13. Click Next >.
Step 4: Chart Location
14. Choose the location where your graph will be created. As new sheet: Opens a new page on which the graph will appear. As object in: Places the graph in the current spreadsheet.
If you’re unsure, select As object in so the data and graph will appear on the same page.
© Hands-On Labs, Inc. LabPaq PK-2 35
15. Click Finish to complete the graph.
Using Excel® To Calculate the Slope of the Line 1. Put your cursor on the line in your graph and right-click.
An option menu will drop down; select “Add Trendline.”
2. Left-click on “Add Trendline.” The window to the right will appear with icons for the types of trend lines possible.
3. For most data you will usually want a “Linear” trendline.