Lab 1 Lab Analysis and Report
Introduction
Welcome to the first lab! In this lab, we focus on analyzing given data and writing a portion of lab report; we do not do any physical experiments. The data we analyze today w
...
Lab 1 Lab Analysis and Report
Introduction
Welcome to the first lab! In this lab, we focus on analyzing given data and writing a portion of lab report; we do not do any physical experiments. The data we analyze today were taken in real experiments conducted by former physics students. They tested a physics theory about projectile, which was a metallic ball thrown into midair. Your analysis involves organizing data into data table, converting units, graphing data, calculating the theoretical value, and determining the relative error using Microsoft Excel. Then, you explain the outcomes of the analysis to the readers by writing a lab report. This lab walks you through how to use the Excel spreadsheet and its formulas, and how to create a Word document with tables, figures, and equations. Those are also the tools and techniques relevant in future lab experiments and lab writeups. You should first read the entire document, so you know the important information that helps you complete this and future labs successfully. At the end of the lab, you have an Excel file and a Word document that you submit to the Lab 1 Assignment submission folder on D2L.
Objectives
Through the lab exercises, you will be able to
• analyze data in Excel spreadsheet and write report in Word document,
• record experimental data in Excel table,
• create Excel formulas,
• fill/copy values and formulas,
• use cell references in Excel formulas,
• create scientific graphs,
• organize scientific information into proper sections in lab report,
• insert in the report editable tables and graph copied directly from Excel,
• type equations using Equation Editor,
• and perhaps format inserted pictures (not the graph) properly using crop tool.
Materials
For this lab, you need to use the desktop version of Excel and Word to complete all tasks. Word and Excel that you can use in a browser are called web apps which may lack some functions that we need in the lab. If you do not have desktop version of those apps, you can install a free copy of Microsoft 365 on your Windows or Mac computer as well as iOS and Android devices-- see Free & Discounted Software (https://mnscu.sharepoint.com/sites/CENT-Students/SitePages/Software.aspx ) webpage in MyCentury under the Students tab or read the PDF document How to Download Office 365 on your Device (https://mnscu.sharepoint.com/:b:/r/sites/CENTStudents/Technology/How%20to%20Download%20Office%20365%20(for%20students).pdf?csf=1&web =1&e=wxMzWT ). If you have a computer that does not allow you to install the desktop version of Microsoft 365 apps, you can still use the desktop version of Office 365 apps through remote access method. These are the Word and Excel that you use on campus computers, and you access a Windows computer at Century remotely. Read the instructions in the document Access Century’s Remote Virtual
[Show More]