LC Programming Excel Spreadsheet

This assignment will be interactive, which means the actual problems won’t be available until we start the assignment. I will post example problems that will be similar to the problems we will be working on together. Please make sure these problems are of familiarity to you before bidding. Thank you 🙂

For the following information calculate the height in meters for the following starting conditions for each
initial velocity. Remember that the kinematics equation is
Height = starting height + velocity*time + 1/2*g*t2
Plot all three data sets that you calculate on the same plot. Make sure to label the plot.
time(s)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
starting height
gravity
symbol
s
g
value
0
-9.81
h(m) V1
h(m) V2
h(m) V3
owing starting conditions for each
quation is
Total points for this
sheet = 50
ke sure to label the plot.
units
m
m/s2
symbol value units
Initial velocity (V1)
V
50 m/s
Initial velocity (V2)
V
120 m/s
Intitial velocity (V3)
V
230 m/s
Use Built in Functions to Answer questions in this Sheet.
Q1) You came across acounter weight in your work setting labeled 0.1 slugs.
What is the equivalent weight in tons and lbs?
0.1 weight [=] slugs
weight [=] tons
weight [=] lb
Q2) Students taking CLSE 114 received the following grades on an assignment.
What was the average grade, standard deviation, the range of grades withing one standard de
Bob
Jane
Tom
Isabel
Mike
Herseth
Helen
Io
Cecil
Samantha
65
78
87
78
79
80
76
78
90
69
Average
SD
Range
# of A/B’s
ions in this Sheet.
Total points for this
sheet = 25
s withing one standard deviation and number of grades greater than or equal to 80?
Provide the terminology that completes the following
questions or statements.
The area in Excel that contains tabs, groups and associated clickable functions is known as:
The intersection of a column and row is called:
What is the term that decribes when the cursor is on an intersection of a row and column?
What type of format will present calculations in short hand form?
Where can an Excel user click on to reference the location of values used in calculations?
s the following
Total points for this
sheet = 25
Use Built in Functions to Answer questions in this Sheet.
Total points for this
sheet = 25
Q1) You came across acounter weight in your work setting labeled 0.1 slugs.
What is the equivalent weight in tons and lbs?
0.1 weight [=] slugs
weight [=] tons
weight (=1 lb
Q2) Students taking CLSE 114 received the following grades on an assignment.
What was the average grade, standard deviation, the range of grades withing one standard deviation and number of grades greater than or
65
78
87
Bob
Jane
Tom
Isabel
Mike
Herseth
Helen
78
79
80
76
Jo
78
90
Cecil
Samantha
69
Average
SD
Range
# of A/B’s