# Excel Rubric

Anonymous
account_balance_wallet \$20

### Question Description

- Create the same exact Excel Rubric

- Make sure that all data and graphs are included

- File is uploaded on how the Excel should come out to

Lab Assignment Rubric Lab Assignment Rubric Notes ● This rubric applies for lab assignment only. ● All assignments must be turned in at the end of the lab. The deadline is always before midnight the next Lab. ● Check all your numbers, plots and writings before you turn in. No resubmission will be considered. ● Turn in your lab assignment individually though you have worked in a groups of 2 or 3. Write down all the group members names. Lab Assignment Rubric 1. Click on Insert 2. Then click Text 3. Everyone must have this box in their assignment including the names of the lab partners. Lab Assignment Rubric 20pts Data collection Collect right data under appropriate column. Avoid unnecessary data collection. Units Check your units for the collected data in the table. Make sure you have right unit under the axis of your plotted graph. The calculated result must have a correct unit. Point distribution 3 pts 2 pts Unit Data Lab Assignment Rubric 20pts Decimal Places I will check two decimal values for: ● Linest. ● Calculated result including other values from any other equations. Linest You must have your linest. Points distribution 2 pts 1 pts LINEST Lab Assignment Rubric 20pts Plots I will check: ● Data points ● Graph title ● Axis titles ● Trendline ● Trendline equation ● Error bars 0.5 for each criteria. Calculation I will check all your calculation steps. Points distribution 3 pts 3 pts Graph Plot Lab Assignment Rubric 20pts Percentage of Error More than 20% error is not accepted. Less than 10% error will get full point. In between will get half point. Point distribution 2 pts Group Make sure you write your group number & names of each member. 1 pts Lab Assignment Rubric 20pts Summary Appropriate conclusions drawn from findings to evaluate meaning and importance of the experiment is expected. Point distribution 3 pts Lab Assignment Rubric Notes Click the plus sign to add a new tab Lab Assignment Rubric 20pts 3 pts + Point distribution 2 pts + 2 pts + 1 pts + 3 pts + 3 pts + 2 pts + 1 pts + 3 pts = 20 pts

Robert__F
School: UCLA

Fit 1
-0.05644
1.984056
4.024556
6.065056
8.105556
10.14606
12.18656
14.22706
16.26756

Particle 2
Time (s) Speed (m/s)
0
0
1
2.23
2
5.32
3
7.53
4
10.4
5
12.4
6
15.3
7
17.4
8
20.3

Particle 1
20
15

Speed (m/s)

Particle 1
Time (s) Speed (m/s)
0
0
1
2.01
2
3.91
3
6.02
4
8.11
5
10.3
6
12.1
7
14.2
8
16.3

10
5
0
0

1

-5

2.0405 -0.0564444
0.011128 0.0529787
0.999792 0.0861951
33624.73
7
249.8184 0.0520072
Particle 1
Compare with the following equation,

m is the slope of the velocity vs. time g
rate of change of velocity.

Lab 1: Basic analysis using Excel
Group members' names

Velocity vs. Time
1.
2.
3.

y = 2.0405x - 0.0564
R² = 0.9998

2

3

4

5

6

7

8

Time (s)
Series1

Series2

Linear (Series1)

𝑣 = 𝑎𝑡 + 𝑣0
the following equation,
𝑦 = 𝑚𝑥 + 𝑐
the velocity vs. time graph known as "acceleration", simply the
hange of velocity.
∆𝑣
𝑎=
∆𝑡

9

ic analysis using Excel
...

flag Report DMCA
Review

Anonymous
Excellent job

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors