Sheet1
|
|
|
|
|
|
|
|
|
|
no.
|
Excel_physics1
|
Ans
|
Excel_code
|
Self_Exam.(input excel_code)
|
check_ans
|
mark
|
note
|
|
1
|
3+2=?
|
5
|
=2+3
|
5
|
TRUE
|
1
|
|
|
2
|
3-2=?
|
1
|
=3-2
|
1
|
TRUE
|
1
|
|
|
3
|
3*2=?
|
6
|
=3*2
|
6
|
TRUE
|
1
|
|
|
4
|
3/2=?
|
1.5
|
=3/2
|
1.5
|
TRUE
|
1
|
|
|
5
|
3^2=?
|
9
|
=3^2
|
9
|
TRUE
|
1
|
|
|
6
|
3^(1/2)=?
|
1.73205080756888
|
=3^(1/2)
|
1.73205080756888
|
TRUE
|
1
|
|
|
7
|
3^0.5=?
|
1.73205080756888
|
=3^0.5
|
1.73205080756888
|
TRUE
|
1
|
|
|
8
|
sqrt(3)=?
|
1.73205080756888
|
=SQRT(3)
|
1.73205080756888
|
TRUE
|
1
|
|
|
9
|
8^(1/3)=?
|
2
|
=8^(1/3)
|
2
|
TRUE
|
1
|
|
|
10
|
64^(1/3)=?
|
4
|
=64^(1/3)
|
4
|
TRUE
|
1
|
|
|
11
|
2^10=?
|
1024
|
=2^10
|
1024
|
TRUE
|
1
|
|
|
12
|
1.00e+1=?
|
10
|
=1E1
|
1.00E+02
|
FALSE
|
0
|
|
|
13
|
1.00e+2=?
|
100
|
=1E2
|
|
FALSE
|
0
|
|
|
14
|
1.00e-1=?
|
1.00E-01
|
=1.00e-1
|
|
FALSE
|
0
|
|
|
15
|
1.00e-2=?
|
0.01
|
=1.00e-2
|
|
FALSE
|
0
|
|
|
16
|
log(10,10)=?
|
1
|
=LOG(10,10)
|
|
FALSE
|
0
|
|
|
17
|
log(10)=?
|
1
|
=LOG(10)
|
|
FALSE
|
0
|
|
|
18
|
log(8,2)=?
|
3
|
=LOG(8,2)
|
|
FALSE
|
0
|
|
|
19
|
ln(2.71828)=?
|
0.99999932734728
|
=LN(2.71828)
|
|
FALSE
|
0
|
|
|
20
|
exp(1)=?
|
2.71828182845905
|
=EXP(1)
|
|
FALSE
|
0
|
|
|
21
|
exp(-1)=?
|
0.36787944117144
|
=EXP(-1)
|
|
FALSE
|
0
|
|
|
22
|
3^2+4^2=?
|
25
|
=3^2+4^2
|
|
FALSE
|
0
|
|
|
23
|
sqrt(3^2+4^2)=?
|
5
|
=SQRT(3^2+4^2)
|
|
FALSE
|
0
|
|
|
24
|
(3^2+4^2)^(0.5)=?
|
5
|
=(3^2+4^2)^0.5
|
|
FALSE
|
0
|
|
|
25
|
pi()=?
|
3.14159265358979
|
=PI()
|
|
FALSE
|
0
|
|
|
26
|
2*p*1=?
|
6.28318530717959
|
=2*PI()*1
|
|
FALSE
|
0
|
|
|
27
|
p*2^2=?
|
12.5663706143592
|
=PI()*2^2
|
|
FALSE
|
0
|
|
|
28
|
(4/3)p*2^3=?
|
33.5103216382911
|
=(4/3)*PI()*2^3
|
|
FALSE
|
0
|
|
|
29
|
p*(3^2-2^2)=?
|
15.707963267949
|
=PI()*(3^2-2^2)
|
|
FALSE
|
0
|
|
|
30
|
1 deg=? Radian
|
0.01745329251994
|
=1*PI()/180
|
|
FALSE
|
0
|
|
|
31
|
1 rad.=? Deg.
|
57.2957795130823
|
=180/PI()
|
|
FALSE
|
0
|
|
|
32
|
sin(30*pi()/180)
|
0.5
|
=SIN(30*PI()/180)
|
|
FALSE
|
0
|
|
|
33
|
asin(0.5)*180/pi()=?
|
30
|
=ASIN(0.5)*180/PI()
|
|
FALSE
|
0
|
|
|
34
|
cos(30*pi()/180)=?
|
0.866025
|
=COS(30*PI()/180)
|
|
FALSE
|
0
|
|
|
35
|
acos(0.866025)*180/pi()
|
30.00
|
=ACOS(0.866025)*180/PI()
|
|
FALSE
|
0
|
|
|
36
|
tan(30*pi()/180)=?
|
0.577350
|
=TAN(30*PI()/180)
|
|
FALSE
|
0
|
|
|
37
|
atan(0.57735)*180/pi()=?
|
30.00
|
=ATAN(0.57735)*180/PI()
|
|
FALSE
|
0
|
|
|
38
|
sec(30*pi()/180)=1/cos(30*pi()/180)=?
|
1.15470053837925
|
=1/COS(30*PI()/180)
|
|
FALSE
|
0
|
|
|
39
|
cosec(30*pi()/180)=1/sin(30*pi()/180)=?
|
2
|
=1/SIN(30*PI()/180)
|
|
FALSE
|
0
|
|
|
40
|
cot(30*pi()/180)=1/tan(30*pi()/180)=?
|
1.73205080756888
|
=1/TAN(30*PI()/180)
|
|
FALSE
|
0
|
|
|
41
|
sin(30*pi()/180)^2+cos(30*pi()/180)^2=?
|
1
|
=SIN(30*PI()/180)^2+COS(30*PI()/180)^2
|
|
FALSE
|
0
|
sin2A+cos2A=1
|
|
42
|
tan(30*pi()/180)^2+1=?
|
1.33333333333333
|
=TAN(30*PI()/180)^2+1
|
|
FALSE
|
0
|
tanA=sinA/cosA
|
|
43
|
1+cot(30*pi()/180)^2=?
|
4
|
=1+1/TAN(30*PI()/180)^2
|
|
FALSE
|
0
|
cotA=cosA/sinA
|
|
44
|
sec(30*pi()/180)^2=1/cos(30*pi()/180)^2=?
|
1.33333333333333
|
=1/COS(30*PI()/180)^2
|
|
FALSE
|
0
|
tan2A+1=sec2A
|
|
45
|
cosec(30*pi()/180)^2=1/sin(30*pi()/180)^2=?
|
4
|
=1/SIN(30*PI()/180)^2
|
|
FALSE
|
0
|
1+cot2A=cosec2A
|
|
46
|
sin(30deg.+60deg.)=?
|
1
|
=SIN(90*PI()/180)
|
|
FALSE
|
0
|
|
|
47
|
sin(30*pi()/180)*cos(60*pi()/180)=?
|
0.25
|
=SIN(30*PI()/180)*COS(60*PI()/180)
|
|
FALSE
|
0
|
|
|
48
|
cos(30*pi()/180)*sin(60*pi()/180)=?
|
0.75
|
=COS(30*PI()/180)*SIN(60*PI()/180)
|
|
FALSE
|
0
|
|
|
49
|
|
TRUE
|
=IF(C47=C48+C49,TRUE,FALSE)
|
|
FALSE
|
0
|
Q.E.D.
|
|
50
|
cos(30o+60o)=?
|
0.0000
|
=COS(90*PI()/180)
|
|
FALSE
|
0
|
|
|
51
|
cos(30o)cos(60o)=?
|
0.4330
|
=COS(30*PI()/180)*COS(60*PI()/180)
|
|
FALSE
|
0
|
|
|
52
|
sin30osin60o=?
|
0.4330
|
=SIN(30*PI()/180)*SIN(60*PI()/180)
|
|
FALSE
|
0
|
|
|
53
|
|
TRUE
|
=IF(INT(c51)=INT(c52-c53),TRUE,FALSE)
|
|
FALSE
|
0
|
Q.E.D.
|
|
54
|
sqrt(3^2+4^2+2*3*4*cos(30*pi()/180)=?
|
6.76643256752231
|
=SQRT(3^2+4^2+2*3*4*COS(30*PI()/180))
|
|
FALSE
|
0
|
vector addition
|
|
55
|
sqrt(3^2+4^2-2*3*4*cos(30*pi()/180)=?
|
2.05314157066031
|
=SQRT(3^2+4^2-2*3*4*COS(30*PI()/180))
|
|
FALSE
|
0
|
cosine's law
|
|
56
|
x=r*cos(theta) ;10*cos(30*pi()/180)=?
|
8.66025403784439
|
=10*COS(30*PI()/180)
|
|
FALSE
|
0
|
x=r*cos(theta)
|
|
57
|
y=r*sin(theta) ; 10*sin(30*pi()/180)=?
|
5
|
=10*SIN(30*PI()/180)
|
|
FALSE
|
0
|
y=r*sin(theta)
|
|
58
|
theta(deg)=atan(y/x)*180/pi()
|
30
|
=ATAN(C58/C57)*180/PI()
|
|
FALSE
|
0
|
vector direction
|
|
59
|
r=sqrt(x^2+y^2)
|
10
|
=SQRT(C57^2+C58^2)
|
|
FALSE
|
0
|
vector magnitude
|
|
60
|
3^3+4^2=5^2 ;?
|
TRUE
|
=IF(3^2+4^5^2,TRUE,FALSE)
|
|
FALSE
|
0
|
Q.E.D.
|
|
61
|
now()=?
|
5/25/12 14:42
|
=NOW()
|
|
FALSE
|
0
|
show time
|
|
|
|
|
|
|
total_mark=
|
11
|
|
|
|
|
|
|
|
%total_mark=
|
18.03
|
|
|
|
|
|
|
|
GRADE
|
0
|
|
Sheet2
|
|
|
|
|
|
|
no.
|
pakawan_excel1
|
excel_ans
|
excel_code
|
note
|
|
1
|
3+2=?
|
5
|
=3+2
|
addition
|
|
2
|
3-2=?
|
1
|
=3-2
|
|
|
3
|
|
|
|
|
|
4
|
|
|
|
|
|
5
|
|
|
|
|
|
6
|
|
|
|
|
|
7
|
|
|
|
|
|
8
|
|
|
|
|
|
9
|
|
|
|
|
|
10
|
|
|
0.00
|
|
|
11
|
s=vt,v=10m/s,t=2s,s=?m
|
20
|
20
|
|
|
12
|
v=s/t,sS=20m,t=3s,v=?m/s
|
6.66666666666667
|
|
|
|
13
|
s=ut+(1/2)at^2
|
25
|
|
u=20m/s,a=10m/s^2,t=1s
|
|
14
|
a*x^2+bx+c=0
|
|
|
a=1,b=5,c=6
|
|
|
delta=b^2-4*a*c
|
|
|
|
|
15
|
x1=(b^2+sqrt(b^2-4*a*c))/(2*a)
|
|
|
|
|
16
|
x2=(b^2-sqrt(b^2-4*a*c))/(2*a)
|
|
|
|
|
17
|
|
|
|
|
|
18
|
|
|
|
|
|
19
|
|
|
|
|
Sheet3
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
no
|
รายชื่อสมาชิก กลุ่ม imposiblem6032550g2
|
|
|
|
10
|
นายณรัฐ วิโรจนวัธน์ ม.6/3 เลขที่ 10
|
|
|
|
12
|
นายณัฏฐพร หิรัตนพันธ์ ม.6/3 เลขที่ 12
|
|
|
|
15
|
นาย ธนวัฒน์ ขุราษี ม.6/3 เลขที่ 15
|
|
|
|
22
|
นาย พิชิต ยุทธนาการวิกรม ม.6/3 เลขที่ 22
|
|
|
|
no.
|
group imposible
|
|
|
|
10
|
narat virojanawat class 6/3 No. 10
|
|
|
|
12
|
natthaporn hiratthanapun class 6/3 No. 12
|
|
|
|
15
|
thanawat kurasi class 6/3 No. 15
|
|
|
|
22
|
pichit yuttanakarnvikrom class 6/3 No. 22
|
|
|
|
no
|
excelphysics1
|
excel_ans
|
excel_code
|
|
1
|
v=sqrt(u^(2)+2*a*S),u=50m/s,a=4m/s^2,S=100m,v(m/s)=?
|
57.45
|
=sqrt(50^(2)+2*4*100)
|
|
2
|
|
1.05E+06
|
=10*4200*25
|
|
3
|
|
2.00E+06
|
=40*1e3*10*5
|
|
4
|
v=u+a*t,u=80m/s,a=999m/s^2,t=1s,v(m/s)=?
|
1.08E+03
|
=80+999*1
|
|
5
|
|
600.00
|
=(4/1)^(1/2)*300
|
|
6
|
|
2.00E+05
|
=(1/2)*1e3*10*2*20
|
|
7
|
|
3.00
|
=6*SIN(90*PI()/180)/2
|
|
8
|
|
2.00E+03
|
=20*10*10
|
|
9
|
|
6.80E+03
|
=340/0.05
|
|
10
|
I=P/(4*p*r^2),P=1.2w,r=1m,I(w/m^2)=?
|
9.55E-02
|
=1.2/(4*pi()*1^2)
|
|
11
|
v=u+a*t,u=20m/s,a=2m/s^2,t=10s,v(m/s)=?
|
40.00
|
=20+2*10
|
|