Download Word and Excel Practice Exercise and more Slides Engineering in PDF only on Docsity!
Word and Excel Practice Exercise
IMPORTANT
While highly recommended as preparation for the Word and Excel Assignment, this practice exercise is optional and will not be graded.
Solutions to this assignment have been posted.
Please note that this exercise is not exhaustive and does not cover all tasks required on the Word and Excel Assignment.
Purpose
The purpose of this practice exercise is to help prepare you to complete the Word and Excel Assignment.
This exercise requires you to use the following:
Microsoft Excel for creating tables, scatter plots, and completing data analysis. Microsoft Word for creating a summary document containing the results and discussion from two Excel exercise. Specifically, Word will be used to import tables/plots; create text, equations, captions, and drawings; and to use built-in tools for heading styles, automatic referencing and citations, and tables of contents.
Relevant Resources
The Microsoft Excel tutorials and Microsoft Office Learning Resources are available at http://engineering.queensu.ca/Current-Students/First-Year-Studies/Incoming-Students.html
You should read this tutorial and refer to these resources while completing the exercise. If you have any additional questions about the exercise, you may contact [email protected] for assistance.
Required Software
This practice exercise can be completed on both PCs and Macs. You will need the following software and plug-ins:
- Microsoft Excel - Ensure the “Analysis ToolPak” plug-in is installed in your version.
- Microsoft Word - Ensure you have the option to use the IEEE reference style in the Word citation management tool.
Detailed installation instructions are included in the Microsoft Excel and Word tutorials mentioned previously in ‘Relevant Resources.’
Learning Outcomes
Upon successful completion of this assignment, students will be able to:
- Input experimental data into Microsoft Excel.
- Perform calculations in Microsoft Excel using both manually inputting formulas and built-in functions.
- Generate simple and effective tables and graphs to describe experimental data in Microsoft Excel.
- Perform basic data analysis in Microsoft Excel. Specifically, students will be able to perform regression and residual analyses as part of a laboratory error analysis.
- Properly format and organize a formal laboratory report in Microsoft Word.
- Integrate both graphs and tables created in Microsoft Excel into a laboratory report in Microsoft Word.
- Generate equations, sample calculations, and basic diagrams in Microsoft Word.
- Correctly reference resources used in a formal laboratory report using IEEE format.
- Critically evaluate experimental results on a basic level.
Instructions
This assignment contains two questions:
- Question 1: Specific Weight of Lake Ontario
- Question 2: Resistance in a Circuit
The questions are described in detail beginning on page 6.
To complete both questions you will need to create multiple tables and graphs in Microsoft Excel, and you will need to import them into a properly formatted Microsoft Word document. The specific formatting requirements are listed on pages 3 to 5.
Graphs
- Do not include chart titles. Your figure caption should sufficiently introduce the contents of your graph.
- Do include axis titles (with units).
- Eliminate/Reduce horizontal and vertical gridlines when appropriate. Horizontal and vertical gridlines should only be included if they highlight key data points or are critical for making your graph more legible.
- Avoid using colour where possible.
- When inserting graphs into a report, make sure they are an appropriate size. Graphs/Figures should be as small as possible, while still remaining clear and legible to the naked eye (without zoom). It is appropriate to conserve space and place figures side-by-side if they are clear, legible, and their content is related.
8. Captions
Include captions below figures and above tables using the Word Captions tool. Refer to each figure and table in the body of your report using cross-referencing , also found under the Word Captions tool. Use the “Only Label and Number” option when inserting cross- references such that the references appear as “Table 1” or “Figure 1” in the body of the report.
9. Table of Contents
Use Word Table of Contents to generate a Table of Contents page from the headings. Note that Word will do this automatically provided that you have used styles for your section headings.
10. List of Figures/ List of Tables
Use Word Captions to insert a List of Figures and List of Tables immediately after the Table of Contents page, generated from the captions used for your figures. The Table of Contents, List of Figures, and List of Tables should not be included in the Table of Contents.
11. References
Use Word Citations & Bibliography to insert in text citations and add a references section to the end of your document. Reference all documents used. Citations must be in IEEE style. It is not mandatory that you use the Microsoft Word citation management tool. You are free to use other citations management tools (e.g. Zotero). No citation management tools are perfect. It is always expected that you manually check that your citations are generated in proper IEEE format and that you make all necessary adjustments.
12. Significant Figures
If not instructed otherwise, for the purposes of this assignment, report all numerical values to 4 significant figures.
13. Numbering Equations
Number all equations included in the body of the report. Any equations included should be referenced at least once by number in the explanatory text. It is not expected that students use Word Captions to generate equation captions, cross- references, or a List of Equations.
14. Sample Calculations
Consider the following structure for effective sample calculations: I. Include the generic form of the equation. Ensure the equation is numbered. II. Define all variables. III. Substitute numeric values into the equation with units. IV. Report the final answer with units.
15. Units
When reporting units, ensure there is a space between the numerical value and the unit. However, a space should not be left between the numerical value and the unit for percentages or degrees.
Question 1: Specific Weight of Lake Ontario
You and a fellow engineering friend own a beautiful boat. Recently, you have decided to move your boat from your seaside Newfoundland residence to Kingston. While out working on an APSC-100 assignment you notice that your boat is sitting lower in the lake water than it did on the Newfoundland coast, making you wonder about the differences in specific weights of water in Lake Ontario and the Atlantic Ocean. Underwater pressure has a linear
a. A short paragraph outlining the two sets of data and describing the tables and plots you are including. Be sure to use Word functions to add captions and cross-references to the plots and tables in your report. b. The Excel tables of the new data, historical data and historical data in metric units– remember to number each table and include an explanatory caption above each table to describe it (use Word’s reference tool for captions and cross-referencing) c. The graph of the results – include a figure number and explanatory caption underneath the figure to describe its contents d. A short paragraph commenting on whether or not the specific weight of water in Lake Ontario is significantly different than the specific weight of ocean water, and potential reasons for similarity or difference. Describe the difference between density and specific weight.
Question 2: Resistance in a Circuit
An experiment was conducted by some engineering students to study voltage, current, resistance, and power in a circuit that consists of a voltage source and a resistive load (a light bulb) connected in series. The output voltage of the voltage source, 𝑉, was varied over time and the current, 𝐼, through the circuit was measured, as shown in Table 2. You have been asked to calculate some other quantities shown in Table 2. ∆𝐸 represents the energy dissipated in the resistor over a time interval of ∆𝑡 = 0.20 𝑠, and ∆𝑄 represents the charge flow through the resistor over a time interval of ∆𝑡 = 0.20𝑠.
Table 2: Data collected from a circuit containing one resistive load connected to a power source.
Point Elapsed Voltage Current ∆E ∆Q Power I^2 # time [s] [V] [A] [J] [C] [W] [A^2 ] 1 0.2 0 102.1 0 1. 2 0.4 0 105.5 0 1. 3 0.6 0 105.1 0 1. 4 0.8 0 107.7 0 1. 5 1.0 0 108.3 0 1. 6 1.2 0 109.1 0 1. 7 1.4 0 109.9 0 1. 8 1.6 0 113.1 0 1. 9 1.8 0 113.9 0 1. 10 2.0 0 115.9 0 1. 11 2.2 0 116.0 0 1. 12 2.4 0 120.2 0 1. 13 2.6 0 124.0 0 1. 14 2.8 0 120.3 0 1. 15 3.0 0 124.8 0 1. 16 3.2 0 125.1 0 1. 17 3.4 0 127.6 0 1. 18 3.6 0 128.8 0 1.
- Enter the data above into an Excel spreadsheet.
- To populate the last four columns in Table 2, calculate ∆𝐸, ∆𝑄, and 𝐼^2 for each time interval (∆𝑡 = 0.2𝑠) using the given formulas (see the box).
- Format the cells in the last four columns to display two decimal places.
- Use the SUM function in Excel to find the total energy consumption and the total charge consumption over 3.6 seconds. Display the results in a new (appropriately labeled) row at the bottom of the table.
- Construct a scatter plot of 𝑃 vs. 𝐼^2 , with 𝑃 on the y-axis and 𝐼^2 on the x-axis. The plot has the form 𝑃 = 𝑅(𝐼^2 ) + 𝑃 0 where 𝑃 0 and 𝑅 are unknown quantities to be fit from the generic linear equation of the form 𝑦 = 𝑚𝑥 + 𝑏. In this equation, m is the slope of the line and b is the y- intercept.
Unit Conversions: A = Ampere = C/s V = Volt = J/C J = Joule C = Coulomb W = Watt = J/s Symbols: ∆E = energy dissipated in ∆𝑡 ∆Q = total charge in ∆𝑡 V = voltage P = power I = current ∆t = 0.2 s = time interval R = resistance (ohms) Formulas: V = (I)(R) P = (R)(I)^2 = (I)(V)=∆𝐸/∆𝑡 V = ∆E/∆Q I = ∆Q/∆t
