Basic Rules for the Correct and Effective Use of Google Sheets for Lab Reports

Basic Rules for the Correct and Effective Use of Google Sheets for Lab Reports

1. Every numerical value has to be written in a separate cell and only one time.
2. If you need to use a numerical value in calculations, use in codes the reference name of the cell, where this numerical value is located.
3. For each numerical value have to be shown what it means and what are units of this value.
4. Don't write a numerical value together with it’s unit to the same cell.
5. Absolutely all necessary calculations have to be completed by Google Sheets codes (scripts).
6. Changes of any initial numerical value have to automatically recalculate all results.
7. In texts use correct formats of mathematical constants, signs, or operations, not Google Sheets codes.
8. Use superscript characters: ⁰ ¹ ² ³ ⁴ ⁵ ⁶ ⁷ ⁸ ⁹ ⁺ ⁻ ⁼ ⁽ ⁾ ⁿ ⁱ .
9. Use subscript characters: ₀ ₁ ₂ ₃ ₄ ₅ ₆ ₇ ₈ ₉ ₊ ₋ ₌ ₍ ₎ ₐ ₑ ₒ ₓ ₔ ₕ ₖ ₗ ₘ ₙ ₚ ₛ ₜ .
10. Use math and greek characters: ° ⨯ ∙ ≈ ∞ √ 𝚫 𝚯 𝚹 𝚺 𝛀 𝛆 𝛌 𝛍 𝛑 𝛒 𝛔 𝛕 𝛚 𝛜.
11. In lab reports do calculations of % errors comparing obtained in experiment values with expected values even if these calculations are not mentioned in the procedure.
12. Don't make your lab report as a literary novel.
13. Use a tabular style in all parts of your report.
14. The Conclusion section of lab reports should indicate how the results of your experiment correspond to the laws of Physics.
15. If the obtained %-error is more than 50%, do not write that the results of the laboratory experiment are in good agreement with the laws of Physics.
16. All calculations for answering laboratory questions should be done by Google Sheets codes (scripts).
17. Any report should be one page of a Google Sheets worksheet.
18. Reports must begin with the name of the experiment and the name of the student.
19. All tables must have explanatory titles.
20. All columns of tables should have explanatory headings with units of measurement. Units have to be in round brackets.
21. All graphs must have explanatory titles.
22. Axes of graphs should have explanatory titles with units. Units have to be in round brackets.
23. Charts must plot a trendline and a trendline equation.
24. Do calculations of slopes by using codes (scripts) with the slope() function.
25. To submit your report, submit in Blackboard only a web link to your Google Sheets work.
26. Don't submit any files or weblink to not Google Sheets.
27. If you are making a second or subsequent attempt to submit your corrected lab report, submit the weblink by Blackboard again, even if your web link has not changed.
28. The number of your attempts to get the highest grade is not limited.
29. Share your Google Sheets to vznamenskiycitytech@gmail.com giving editor rights.
30. See my comments, corrections and remarks in your Google Sheets.
31. If you want to increase your grade, correct your report according to my comments and resubmit it again.

2021 Fall Term 1 General Physics II Algebra Based PHYS 1434 OL3517660 NY...

2021 Fall Term 1 General Physics II Algebra Based PHYS 1434 OL3517660 NY...

2021 Fall Term 1 General Physics II Algebra Based PHYS 1434 OL3317673 NY...

2021 Fall Term 1 General Physics II Algebra Based PHYS 1434 OL3517660 NY...

2021 Fall Term 1 General Physics II Algebra Based PHYS 1434 OL3317673 NY...

Average AC Power

Direct and Alternating Currents

Coulomb's Force

Coulomb Law Formula Discussion

University Physics Volume 3 - 1.3 Refraction - EXAMPLE 1.2

EXAMPLE 1.2
Determining the Index of Refraction

Find the index of refraction for medium 2 in Figure (a), assuming medium 1 is air
and given that the incident angle is
°
and the angle of refraction is
°.

You can change angles and the result will be calculated for your angles.

Strategy
The index of refraction for air is taken to be 1 in most cases (and up to four significant figures, it is 1.000). Thus, n₁ = 1.00 here. From the given information, θ₁ = 30.0° and θ₂ = 22.0°.
With this information, the only unknown in Snell’s law is n₂, so we can use Snell’s law to find it.

Solution
From Snell’s law, we have
n₁ sin θ₁ = n₂ sin θ₂

n₂ = n₁ sinθ₁ / sinθ₂.
Entering known values,
n₂ = 1.00 sin 30.0° / sin 22.0° = 0.500 / 0.375 = 1.33

What is C?

The angular frequency of the oscillations in an LC circuit is .0×10³ rad/s.

If L= H, what is C?

Solution:

C=µC

What is the maximum current flowing through the circuit?

In an LC circuit, the self-inductance is
L=.0×10⁻² H
and the capacitance is
C=.0×10⁻⁶ F.

At t=0, all of the energy is stored in the capacitor, which has a charge
q=×10⁻⁵ C. 

(a) What is the angular frequency ω of the oscillations in the circuit?

(b) What is the maximum current I₀ flowing through the circuit?

(c) How long does it take the capacitor to become completely discharged? t_d=?

(d) What is the capacitor charge in µC when time t = ×10⁻⁴s?

Solution:

(b) The current is at its maximum when all the energy is stored in the inductor. From the law of energy conservation:


(c) The capacitor becomes completely discharged in one-fourth of a cycle, or during a time T/4, where T is the period of the oscillations. Since

(d) q=q₀ × cos(ω t)



 ω= rad/s
  I₀= A
t_d= s
q(t)= µC

LC Angular Frequency of the Oscillations in the Circuit

In an LC circuit, the self-inductance is
L=.0×10⁻² H
and the capacitance is
C=.0×10⁻⁶ F.

At t=0, all of the energy is stored in the capacitor, which has a charge
q=×10⁻⁵ C. 

What is the angular frequency of the oscillations in the circuit?

 ω= rad/s

Problem-Solving Strategy

 When you are solving some physical problem, try to write your solution in the form of one symbolic equation, where on the left you have the symbol of an unknown physical parameter that you have to calculate, and on the right, you have symbols of only known physical parameters and known constants. Only after this step should you make substitutions on the right, replacing symbols with physical values. If you are doing multi-step calculations using intermediate calculations, write and use intermediate calculations with as many significant figures as possible.

But enter the final result using the correct number of significant figures after rounding the calculated final value. Rounding off in intermediate calculations often makes the final result incorrect. Before you enter the final result, check again what the units of the final results should be according to the text of the problem. The test system accepts as correct results only numbers obtained in expressions written in these units.

Problem 3

 Problem 3

Three identical point charges of 1 C each are located at the vertices of an equilateral triangle, and this system has a potential energy of 1 J. (There is no in our consideration of other charges or external fields)

What would be the potential energy with the same arrangement of point charges, if the charges had different values, for example, the following: -1 C, 2 C, and 3 C?

Problem 2

 When two electric charges occupy the positions shown in Figures 1 and 2, the values of the Coulomb force between the charges are known, respectively F₁ and F₂.

Find the force of the Coulomb interaction of charges when they occupy the position shown in Figure 3.

Problem 1

Two point-objects carrying the same electric charge are keeping at some distance from each other by a string, which exerts on objects only its known tension force T₁ and does not participate in electrostatic interaction.
If four such point-objects with the same as previous charges are attached to a string at the same distance from each other as before, what will be the tension T₂ in the middle of the string?

🧑‍🔬 Hydrogen Wave Function 😲

Active T-Shirt

$25.00

Baseball ¾ Sleeve T-Shirt

$25.20

Classic T-Shirt

$19.90

Graphic T-Shirt

$28.22

Lightweight Hoodie

$34.85

Lightweight Sweatshirt

$34.85

Long Sleeve T-Shirt

$25.20

Long T-Shirt

$25.20

Premium T-Shirt

$28.22

Pullover Hoodie

$39.90

Pullover Sweatshirt

$34.85

Racerback Tank Top

$19.90

Sleeveless Top

$28.22

Essential T-Shirt

$19.90

Tank Top

$19.90

Tri-blend T-Shirt

$25.20

V-Neck T-Shirt

$22.16

Zipped Hoodie

$39.90

A-Line Dress

$46.45

Chiffon Top

$28.22

Fitted Scoop T-Shirt

$22.16

Fitted T-Shirt

$19.90

Fitted V-Neck T-Shirt

$22.16

Graphic T-Shirt Dress

$40.39

Leggings

$40.39

Mini Skirt

$30.77

Premium Scoop T-Shirt

$28.22

Relaxed Fit T-Shirt

$22.16

Sticker

From $1.25

Glossy Sticker

From $1.38

Laptop Skin

$25.25

Laptop Sleeve

$35.86

Transparent Sticker

From $1.54

iPad Skin

$20.21

iPad Snap Case

$45.46

iPhone Skin

$15.14

iPhone Snap Case

$25.25

iPhone Soft Case

$21.00

iPhone Tough Case

$30.30

iPhone Wallet

$35.35

Samsung Galaxy Skin

$15.14

Samsung Galaxy Snap Case

$25.25

Samsung Galaxy Soft Case

$21.00

Samsung Galaxy Tough Case

$30.30

Art Board Print

From $7.28

Art Print

From $17.18

Canvas Mounted Print

$27.00

Canvas Print

$48.48

Framed Art Print

$80.81

Metal Print

$58.57

Photographic Print

$6.79

Postcard

From $1.51

Poster

$14.32

Tapestry

$31.21

Wood Mounted Print

$27.00

Acrylic Block

From $21.46

Bath Mat

$21.68

Clock

$30.30

Coasters (Set of 4)

$13.91

Comforter

$105.31

Duvet Cover

$86.87

Floor Pillow

From $47.22

Shower Curtain

$57.14

Throw Blanket

$38.92

Throw Pillow

From $18.40

Kids Pullover Hoodie

$26.27

Baby T-Shirt

From $13.69

Kids T-Shirt

From $13.69

Long Sleeve Baby One-Piece

From $14.55

Short Sleeve Baby One-Piece

From $14.55

Toddler Pullover Hoodie

$26.27

Drawstring Bag

$30.30

All Over Print Tote Bag

From $17.18

Backpack

$50.00

Classic Mug

From $12.61

Cotton Tote Bag

From $13.19

Duffle Bag

$45.00

Fitted 3-Layer

From $16.00

Mask

From $8.00

Small Mask

From $8.00

Kids Mask

From $9.99

Pin

$3.31

Scarf

From $22.33

Socks

From $12.92

Tall Mug

From $12.61

Travel Mug

$25.25

Water Bottle

$18.88

Zipper Pouch

From $10.30

Greeting Card

From $1.94

Hardcover Journal

From $17.43

Spiral Notebook

From $10.73

Jigsaw Puzzle

$30.00

Apron

$20.00

Magnet

$7.00

Unconventional Physics 🧑‍🔬: Hydrogen Wave Function 😲: Active T-Shirt $25.00 Baseball ¾ Sleeve T-Shirt $25.20 Classic T-Shirt $19.90 Graphic T-Shirt $28.22 Lightweight Hoodie $34.85 Lightweight S...