Using spreadsheets for lab work - Department of Physics

Using spreadsheets for lab work - Department of Physics

Using spreadsheets for lab work PHY102M Henry Schreiner The University of Texas at Austin Entering information Cells Cells have names A B C 1

A1 B1 C1 2 A2 B2 C2 3 A3

B3 C3 Cells contain data, text, or formulas Cells have formats Normally overwrites, F2 or clicking again edits Formulas Start with = Standard math symbols: +-*/^() Functions: SIN(), COS(), SQRT(), Cells by name (click shortcut) A B

C 1 1 = A1 + A2 + A3 6 2 2 = ( A1 + A2 ) / A3 1 3 3

= SQRT(A2 ^2) 2 Cell Ranges You can refer to a range of cells using : A1:A3 refers to the cells A1, A2, and A3 SUM(), AVERAGE(), A B C 1 1

=SUM(A1:A3) 6 2 2 =AVERAGE(A1:A3) 2 3 3 Copy and paste Normal copy/paste copies formulas More options available Numbers Formats

Linked cells Copy and paste formulas Copy and paste automatically translates positions A B C 2 =A1

=B1 3 =A2 1 Locking Adding $ locks the following value A$1 -> the 1 wont change $A1 -> The A wont change $A$1 -> Neither will change A B

C 2 =$A$1 =$A$1 3 =$A$1 1 Smart fill Using the mouse, you can smart fill values quickly Works off selected cells

Drag the corner down or across Smart fill Using the mouse, you can smart fill values quickly Works off selected cells Drag the corner down or across Formulas -> Like copy/paste Numbers/Text -> Tries to guess the series Handy formulas PI() SIN(x), COS(x), TAN(x) ASIN(x), ACOS(x), ATAN(x) SQRT(x) RADIANS(x), DEGREES(x)

SUM(x), AVERAGE(X) CONVERT(x, from, to) SLOPE(y,x), INTERCEPT(y,x) Graphing Select a range Insert graph Choose type Format options Labels Trend line and option Move to separate sheet Advanced graphing Changing type Changing data source Multiple data sources on one graph

Printing Page ranges Scale to fit Use sheets if you can! Different views available Advanced: Naming cells Cells can have a name Makes formulas nicer Fewer $ Personal preference: Start names with _ =$A$1 * $A$2 * B1 vs. =_m * _g * B1

Advanced: Unconnected selection Use control to select ranges that dont touch Useful for graphing Also works in some other programs Advanced: Cell formatting You can control sig-figs with formatting You can change display types You can control color, etc. 0.001234 0.0012 1.2E-3

Advanced: Special text Super/subscripts Greek letters Special symbols Force text with Advanced: Tables (Excel) Tables allow simple manipulation of tabular data Auto-fills, auto-updates for formulas Nicer range names (?) Easy sorting Advanced: Formula helpers List of functions Can move cells by dragging

Can show formulas Can show dependents Sort: not (usually) a formula Example lab-like work j t=j/30 (s) h (m) v (m/s) 0 0.141 0.000 1

0.113 0.267 2 0.091 0.533 3 0.083 0.800

4 0.083 1.067 5 0.026 1.333 6 -0.016 1.600

7 -0.053 1.867 8 -0.071 2.133 m=2.1 kg m*g* h

*m*v ^2 g = 9.81 m/s2 Second example Run 1 Run 2 Run 3 Run 4 m (kg) m1

m2 m1+m2 m1+m2 v (m/s) 1.2 2.2 .70 .75

Averag e Total p=m*v KE=1/2*m*v ^2 m1=2.1 kg m2=0.93 kg More help Appendix A in lab manual Specific tutorials on 102M website Look for help online

Look for YouTube videos Ask

Recently Viewed Presentations

  • Presentazione di PowerPoint - magistri.altervista.org

    Presentazione di PowerPoint - magistri.altervista.org

    Trasduttori: E' un dispositivo in grado di trasformare le variazioni di una grandezza fisica , normalmente non elettrica , in un'altra grandezza , normalmente di natura elettrica (tensione , frequenza o corrente).
  • Dobbiamo vincere - Gianmaria Miciluzzo

    Dobbiamo vincere - Gianmaria Miciluzzo

    Dobbiamo vincere L'Inter Dream Team La società Peppino Prisco Alcune immagini Prischiane Dobbiamo vincere L'Inter Dream Team La società Peppino Prisco Alcune immagini Prischiane I successi dell'Inter 13 SCUDETTI 1 SUPERCOPPA DI LEGA 3 COPPE ITALIA 2 COPPE INTERCONTINENTALI 3...
  • NABL Preparation

    NABL Preparation

    Haematologyand Immunohaematology. Microbiology and Serelogy. Histopathology . Cytopathology. Genetics Nuclear Medicine (in-vitro . tests only) Application. The scope of accreditation which includes. materials or items tested. specific tests or types of tests performed .
  • Developing a Research Informed Pedagogy for ITE

    Developing a Research Informed Pedagogy for ITE

    Healey- Mick Healey took this and added 'research-tutored' Many teaching and learning activities may involve a mixture of the 4 approaches and a balance is sought over the 4 approaches over the longer period. These activities have been adapted to...
  • Unit 3 - Outcome 2 the mechanisms responsible for the acute ...

    Unit 3 - Outcome 2 the mechanisms responsible for the acute ...

    Unit 3 - Outcome 2the mechanisms responsible for the acute responses to exercise in the cardiovascular, respiratory and muscular systems. Assessment descriptor: Comprehensive and detailed analysis of collected data, thorough and insightful understanding of the mechanisms responsible for acute effects...
  • Chapter 3 Effects of IT on Strategy and Competition

    Chapter 3 Effects of IT on Strategy and Competition

    SUBSTITUTE PRODUCTS & SERVICES. CUSTOMERS. Threats. Bargaining power. N. Dr. Chen, The Trends of the Information Systems Technology. TM - ... TM - outsourcing. three. Companies are increasingly outsourcing the management of IT for reasons that include concern for ....
  • Graph-Induced Multilinear Maps from Lattices

    Graph-Induced Multilinear Maps from Lattices

    Lattice Trapdoors [Aj'99,…] Can efficiently sample a pair (?,?) ?∈???×? is a nearly-uniform matrix. ? is some trapdoor information about ? ... Graph-Induced Multilinear Maps from Lattices Last modified by: Shai Halevi
  • Cloning through diffraction: Goals and technologies at the

    Cloning through diffraction: Goals and technologies at the

    Cloning through diffraction: Goals and technologies at the Center for High-throughput Structural Biology (CHTSB). INTRODUCTION: The goal of the Center for High-Throughput Structural Biology (CHTSB) is to overcome the most significant obstacles to structure determination by focusing on technology development...