1 / 22

Using spreadsheets for lab work

Using spreadsheets for lab work. PHY102M Henry Schreiner The University of Texas at Austin. Entering information. Cells Cells have names Cells contain data, text, or formulas Cells have formats Normally overwrites, F2 or clicking again edits. Formulas. Start with =

gent
Download Presentation

Using spreadsheets for lab work

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Using spreadsheets forlab work PHY102M Henry Schreiner The University of Texas at Austin

  2. Entering information • Cells • Cells have names • Cells contain data, text, or formulas • Cells have formats • Normally overwrites, F2 or clicking again edits

  3. Formulas • Start with = • Standard math symbols: +-*/^() • Functions: SIN(), COS(), SQRT(), … • Cells by name (click shortcut)

  4. Cell Ranges • You can refer to a range of cells using : • A1:A3 refers to the cells A1, A2, and A3 • SUM(), AVERAGE(), …

  5. Copy and paste • Normal copy/paste copies formulas • More options available • Numbers • Formats • Linked cells

  6. Copy and paste formulas • Copy and paste automatically translates positions

  7. Locking • Adding $ locks the following value • A$1 -> the 1 won’t change • $A1 -> The A won’t change • $A$1 -> Neither will change

  8. Smart fill • Using the mouse, you can smart fill values quickly • Works off selected cells • Drag the corner down or across

  9. 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

  10. 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)

  11. Graphing • Select a range • Insert graph • Choose type • Format options • Labels • Trend line and option • Move to separate sheet

  12. Advanced graphing • Changing type • Changing data source • Multiple data sources on one graph

  13. Printing • Page ranges • Scale to fit • Use sheets if you can! • Different views available

  14. 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

  15. Advanced: Unconnected selection • Use control to select ranges that don’t touch • Useful for graphing • Also works in some other programs

  16. 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

  17. Advanced: Special text • Super/subscripts • Greek letters • Special symbols • Force text with ‘

  18. Advanced: Tables (Excel) • Tables allow simple manipulation of tabular data • Auto-fills, auto-updates for formulas • Nicer range names (?) • Easy sorting

  19. Advanced: Formula helpers • List of functions • Can move cells by dragging • Can show formulas • Can show dependents • Sort: not (usually) a formula

  20. Example lab-like work m=2.1 kg g = 9.81 m/s2

  21. Second example m1=2.1 kg m2=0.93 kg

  22. More help • Appendix A in lab manual • Specific tutorials on 102M website • Look for help online • Look for YouTube videos • Ask

More Related