$BI=7W;;!"%0%i%U$N:n@.(B

					2018$BG/(B06$B7n(B15$BF|(B
$B>pJs2J3XN`(B $B%3%s%T%e!<%?%j%F%i%7(B

                                       $BC^GHBg3X(B $B%7%9%F%`>pJs7O(B
                                       $B?7>k(B $BLw(B
                                       <yas@cs.tsukuba.ac.jp>

$B$3$N%Z!<%8$O!" http://www.coins.tsukuba.ac.jp/~yas/coins/literacy-2018/2018-06-15
$B$"$k$$$O!" http://www.coins.tsukuba.ac.jp/~yas/
http://www.cs.tsukuba.ac.jp/~yas/

$B"#O"Mm;v9`(B

$B
  • Excel
  • LibreOffice (OpenOffice) Calc
  • Gnumeric
  • Oleo
  • sc
  • KDE kspred
  • (VisiCalc, Lotus 123, Microsoft Multiplan)
  • (Web $B>e$N%5!<%S%9$H$H$7$F$N$b$N(B)

    $B"!9M$(J}(B

    $B%o!<%/%7!<%H(B
    $BI=!##1$D$N%U%!%$%k$KJ#?t$NI=$rJ]B8$G$-$k!#(B
    $B%;%k(B(cell)
    $BI=$N#1$D$N%^%9L\(B
    $B9T(B (row)
    $BI=$r2#$K@Z$C$?$b$N(B
    $BNs(B (column)
    $BI=$r=D$K@Z$C$?$b$N(B
    $B%;%k$K$OL>A0$,$"$k!#(B
    A B C D
    1 A1 B1 C1 D1
    2 A2 B2 C2 D2
    3 A3 B3 C3 D3
    4 A4 B4 C4 D4
    5 A5 B5 C5 D5

    $B"!<0(B

    $B%;%k$K!"!V(B=$B!W$+$i;O$^$kJ8;zNs$rBG$A9~$`$H!"<0$H$7$FI>2A$5$l$k!#(B

    $BNc!'!V(B=10+20$B!W$HBG$D$H!"2hLL$K$O!"!V(B30$B!W$HI=<($5$l$k!#(B

    $B%;%k$N<0$rI=<($7$?$j!"JT=8$9$k$K$O!"!V?t<0%P!

    Excel$B! ($B%/%j%C%/$G3HBg(B)

    $B<0$H$7$F$O!"

  • $B?t!"J8;zNs!"F|IU(B
  • $B1i;;;R!#;MB'1i;;(B(+-*/)$B!#QQ>h(B(^)$B!#J8;zNs$NO"7k(B(&)
  • $B4X?t!#(Bsum() $B$d(B average()$B!#(B($B!VA^F~!W%a%K%e!<$+$i!V4X?t!W(B)
  • $B;2>H!#(B=A1, =B2 $B$N$h$&$K%;%k$NL>A0$r=q$/$H$=$NFbMF$,;2>H$G$-$k!#(B

    $B"!%;%k$N;2>H(B

    $B%;%k$r;2>H$9$k$K$O!"(BExcel $B$G$O!"(BA1, B2 $B$N$h$&$K!"%"%k%U%!%Y%C%H$H?t;z$r;H$&!#(B $B%"%k%U%!%Y%C%H$O!"Ns!"?t;z$O9T$rI=$9!#(B $B!V(BA1:A10$B!W$H=q$/$H!"(BA1,A2,A3,...,A9,A10 $B$N(B10$B8D$N%;%k$r0UL#$9$k!#(B $B!V(BA1:C1$B!W$H=q$/$H!"(BA1,B1,C1 $B$N(B3$B8D$N%;%k$r0UL#$9$k!#(B

    Excel $B$G$N(B2$BH(B

    $BAjBPE*(B
    $B$J$K$b$D$+$J$$(B
    $B@dBPE*(B
    $ $B$rIU$1$k!#(B
    $BI=5-(B $BNs(B $B9T(B
    A1 $BAjBP(B $BAjBP(B
    $A1 $B@dBP(B $BAjBP(B
    A$1 $BAjBP(B $B@dBP(B
    $A$1 $B@dBP(B $B@dBP(B

    $BAjBP;2>H$H@dBP;2>H$G$O!"%;%k$r%3%T!<$7$?;~$NF0:n$,0[$J$k!#(B

    $B"!4X?t(B

    $B$h$/;H$&4X?t(B
    sum()
    $B9g7W(B
    count()
    $B?tCM$N8D?t(B
    average(), median(), max(), min()
    $BJ?6Q(B, $BCf1{CM(B, $B:GBg!":G>.!#Nc!#(B
    =average(B$11:B$50)
    
    if()
    $B>r7oH=Dj!#Bh(B1$B0z?t$,(Btrue$B$J$iBh(B2$B!"$=$&$G$J$1$l$PBh(B3$B0z?t$NCM!#Nc(B:
    =if(F11>=90,"S",if(F11>=80,"A",if(F11>=70,"B",if(F11>=60,"C","D"))))
    
    sumif()
    $B>r7o$rK~$?$;$P2C$($k(B
    countif()
    $B>r7o$rK~$?$;$P?t$($k!#Nc!#(B
    =countif(G$11:G$50,"S")
    

    $B"!=q<0!J%U%)!<%^%C%H!"(Bformat$B!K(B

    $B%;%k$NI=<($r!"(B($BFbMF$rJQ99$9$k$3$H$J$/(B)$BJQ99$G$-$k!#(B

    $B"!%G!<%?$NA`:n(B

    $B#1$D$N9T$r#1$D$N%G!<%?$H$7A`:n(B
    $B%=!<%H(B
    $B9T$r$"$kNs$NCM$N=g$KJB$Y$+$($k(B
    $B%U%#%k%?(B
    $B9T$N$&$A!">r7o$rK~$?$7$?$b$N$@$1I=<($7!"(B $B;D$j$rHsI=<($K$9$k(B
    $B%=!<%H$N=gHV(B

    $B"!(BExcel $B%V%C%/$H(BCSV

    Excel $B$G$O!"
  • Excel $B%V%C%/(B ($B3HD%;R(B .xlsx$B!"?7$7$$7A<0(B)
  • Excel 97-2004 $B%V%C%/(B ($B3HD%;R(B .xls$B!"8E$$7A<0(B)
  • CSV$B7A<0(B
  • $B%F%-%9%H7A<0(B($B%?%V6h@Z$j(B) $BIaDL$O!"(BExcel $B%V%C%/$r;H$&!#B>$N?M$H%G!<%?$r8r49$9$k;~$K$O!"Aj$B"!(BCSV$B7A<0(B(Comma Separated Values) $B0[$J$kI=7W;;%W%m%0%i%`$G%G!<%?$r8r49$9$k$?$a$N%F%-%9%H7A<0$N#1$D!#(B Excel $B$K$O!"(BCSV$B7A<0$N%G!<%?$rFI$_9~$s$@$j!"%G!<%?$r(BCSV$B7A<0$G=PNO$9$k5!(B $BG=$,$"$k!#(B

    CSV$B7A<0$O!"%F%-%9%H$J$N$G!"4A;z%3!<%I$NLdBj$,$J$1$l$P!"%F%-%9%H!&%(%G%#(B $B%?$GI=<($7$?$j=$@5$7$?$j$G$-$k!#(B

    $B$D$/$P(B($B4[Ln(B)$B!!(B2013$BG/!J7n$4$H$NCM!K!!EY(B($B!s(B),,$BIw8~!&IwB.(B(m/s),,,,,$BF|>H(B,$BA4E7F|](B,,
    ,$B8=CO(B,$B3$LL(B,$B9g7W(B,$B:GBg(B,,,$BJ?6Q(B,,,$B:G9b(B,$B:GDc(B,$BJ?6Q(B,$B:G>.(B,$BJ?6Q(B,$B:GBgIwB.(B,,$B:GBg=V4VIwB.(B,,$B;~4V(B,(MJ/$B+'(B),$B9_@c(B,,$B:G?<@Q@c(B,$BJ?6Q(B,$B@cF|?t(B,$BL8F|?t(B,$BMkF|?t(B
    ,$BJ?6Q(B,$BJ?6Q(B,,$BF|(B,1$B;~4V(B,10$BJ,4V(B,$BF|J?6Q(B,$BF|:G9b(B,$BF|:GDc(B,,,,,$BIwB.(B,$BIwB.(B,$BIw8~(B,$BIwB.(B,$BIw8~(B,(h),$BJ?6Q(B,$B9g7W(B,$BF|9g7W$N:GBg(B,,,,,
    1,1013.7,1017.2,49,40.5,6.5,1.5,2.4,8.9,-3.4,14.3,-7.3,62,19,2.2,9.6,$B@>KL@>(B,16.5,$BKL@>(B,218.7,10.0 ),3,3,3,,2,1,0
    2,1014,1017.5,31.5,14,4.5,1,3.5,9.4,-2.3,18.5,-7.6,60,17,2.5,10.6,$BKL@>(B,19.5,$B@>KL@>(B,181.6,11.8,--,--,--,,1,2,0
    3,1010.2,1013.6,45,11.5,9,2.5,10,16,3.7,26.6,-2.6,63,13,3.1,15.1,$BFnFn@>(B,27.7,$BFnFn@>(B,187.1,14.1,--,--,--,,0,0,0
    4,1007,1010.3,167.5,43.5,15,10.5,12.8,18.5,6.3,24.2,-0.2,65,15,3.2,12.2,$BFnFn@>(B,22.2,$BFn@>(B,202.4,17.4,--,--,--,,0,0,1
    5,1009.3,1012.6,81.5,21,10,5,17.3,23.3,11.6,28.6,1.7,71,19,2.6,7.8,$BFn(B,13.3,$BFn(B,243.9,21.3,--,--,--,,0,0,0
    6,1006.6,1009.8,138,45.5,15.5,6.5,20.9,25.3,17.5,29.6,10.8,82,36,2.3,7.7,$BFnFn@>(B,13.8,$BFn@>(B,126.1,16.4,--,--,--,,0,0,1
    7,1005.5,1008.6,45.5,25.5,22.5,12.5,24.9,29.9,21.1,36.3,17.1,81,44,2.4,7.2,$BFnFn@>(B,15.3,$BKLKL@>(B,170.7,17.9,--,--,--,,0,0,1
    8,1004.1,1007.2,70.5,29.5,19,10,27.2,32.6,22.7,36.8,18.4,77,34,2.2,6.8,$BFnFn@>(B,14.4,$BKLEl(B,221.4,18.5,--,--,--,,0,0,1
    9,1011.6,1014.7,175,74,22.5,11.5,22.9,27.8,18.3,35.2,9,79,37,2.4,12.2,$BFnFn@>(B,22.9,$BFnFn@>(B,172.3,14.9,--,--,--,,0,0,5
    10,1014.2,1017.4,417,124.5,27,8,17.8,22.2,13.8,30.4,5.1,82,27,2.4,14.5,$BKLKL@>(B,28.1,$BKLKL@>(B,122.6,9.5,--,--,--,,0,0,0
    11,1012.2,1015.6,16,7,4.5,1.5,9.8,16.6,3.8,21.2,-1.9,74,19,1.8,8.2,$BFnFn@>(B,19.1,$BFnFn@>(B,185.3,9.6,--,--,--,,0,1,0
    12,1010.1,1013.5,45.5,17.5,4,2,4.8,11.2,-1,16.2,-5.6,67,14,2.2,9.3,$BFnFn@>(B,17.3,$B@>(B,192.7,8.5,--,--,--,,0,0,1
    

    $B"#%0%i%U$N:n@.(B

    $B?tCM$J$I$+$i<+F0E*$K:n@.$9$k!#%I%m!<%D!<%k$r;H$&$N$G$O$J$$!#(B

    $BL\E*!'(B

    • $B%G!<%?$N@0M}$N$?$a!#(B
    • $B%o!<%I%W%m%;%C%5!"(BLaTeX $BJ8=q$X$NA^F~(B
    $BJ}K!(B
    • $BI=7W;;%=%U%H%&%'%"$N5!G=$rMxMQ$9$k(B
    • $B%W%m%C%H!&%=%U%H%&%'%"$rMxMQ$9$k(B

    $B"!(BExcel $B$K$h$k%0%i%U$N:n@.(B

    $BBg;v$J35G0(B
    $B7ONs(B
    $B%0%i%U$H$7$F?tCM$NJB$S(B
    $B?tCM<4(B
    y$B<4(B($B@^$l@~%0%i%U$J$I$G(B)
    $B9`L\<4(B
    x$B<4(B($B@^$l@~%0%i%U$J$I$G(B)
    $BK^Nc(B($B$O$s$l$$(B)
    $B7ONs$N@bL@(B
    $B%0%i%U%(%j%"(B
    $B%0%i%U$NGX7J(B
    $B%W%m%C%H%(%j%"(B
    $B%0%i%U$NFbB&$N@^$l@~$J$I$,I=<($5$l$kItJ,(B
    $B%?%$%H%k(B
    $B%0%i%U$N%?%$%H%k!#IaDL$O>e$KIU$1$k!#(B
    $B<4%i%Y%k(B
    $B<4$,I=$9$3$H$N@bL@!#(B

    $B%0%i%U$N

  • $BK@%0%i%U(B($B=D(B)
    Excel $B$G:n@.$7$?K@%0%i%U!
  • $B2#K@%0%i%U(B
  • $B@^$l@~%0%i%U(B
    $BC^GH$N7n$4$H$N:GDc5$29!
  • $BLL%0%i%U(B
  • $B%l!<%@!<%A%c!<%H(B
  • $B1_%0%i%U(B
  • $B@Q$_>e$2<0K@%0%i%U(B
  • $B;6I[?^!"(Bx$B$H(By$B$N%G!<%?$rN>J}M?$($F%W%m%C%H$9$k!#(B
  • $B$=$NB>(B $B@^$l@~%0%i%U$dK@%0%i%U$G$b!"(Bx$B2#<4$N9`L\$rJLES;XDj$G$-$k!#(B

    $B"!?tCM<4$N:G>.CM(B

    $B@5$N?t$rI=<($9$k%0%i%U$G$O!"?tCM<4(B(Y$B<4(B)$B$N:G>.CM$O!"(B0 $B$K$9$k$3$H!#:G>.CM(B $B$r(B 0 $B$K$7$J$$$G:9J,$r6/D4$9$k$l$P!"8m2r$rM?$($k$3$H$H$K$J$k!#(B

    $BK@%0%i%U!.CM$,(B87"> $BK@%0%i%U!.CM$,(B0">

    $B%F%l%SJsF;$G:G>.CM$,(B 0 $B$G$J$$%0%i%U$,$h$/=P$F$/$k$,!"qY$5$l$J$$$3$H!#(B

    $B"!(B3-D$B8z2L(B

    $B%l%]!<%H$dO@J8$G(B $BK@%0%i%U$G!"%0%i%G!<%7%g%s$r$D$1$?$j!"1F$r$D$1$?$j(B3-D$B8z2L!J;0

    $BK@%0%i%U!.CM$,(B0$B!"(B3D$B8z2L(B"> $BK@%0%i%U!.CM$,(B0">

    $B"!(Bgnuplot

    The Unix Super Text 52.3$B@a(B $B;2>H(B
  • $B%G!<%?$N4V$r%9%W%i%$%s6J@~$J$I$GJd40$9$k5!G=$,$"$k(B

    $B"# $B$B!zN}=,LdBj(B(1801) Microsoft Excel $B$K$h$kJ8=q:n@.(B

    Microsoft Excel $B$r
  • Dock $B$N%"%$%3%s(B($B!V(BX$B!W(B)$B$r%/%j%C%/$9$k!#(B $B$^$?$O!"(BFinder $B$N!V%"%W%j%1!<%7%g%s!W%U%)%k%@$r3+$-!"(B $B!V(BMicrosoft Excel.app$B!W$r$ open "/Applications/Microsoft Excel.app" [$B
  • $B!V%5%$%s%$%s$7$F%/%i%&%I%9%H%l!<%8$K%"%/%;%9$9$k!W$HJ9$+$l$k$H!V%5(B $B%$%s%$%s$r%9%-%C%W!d!W$rA*$V!#(B
  • $B=*N;$9$k$K$O!"!V(BExcel$B!W%a%K%e!<$+$i!V(BExcel $B$r=*N;!W$rA*$V!#(B

    $B!zN}=,LdBj(B(1802) Excel: $B%X%k%W(B

    Excel $B$re$N%a%K%e!<%P!<$K$"$k!V%X%k%W!W%a(B $B%K%e!<$+$i!V(BExcel $B%X%k%W!W9`L\$rA*Br$7$J$5$$!#(B

    $B1&>e$N%F%-%9%H%\%C%/%9$K%-!<%o!<%I$rBG$A9~$_!"%j%?!<%s!&%-!<$r2!$9$H(B $B8!:w$9$k$3$H$,$G$-$k!#(B ($B%M%C%H%o!<%/$G8!:w$,$J$5$l$k$3$H$KCm0U!#(B)

    $BL\

  • $B?tCM$dF|IU$J$I$NO"B3%G!<%?$rF~NO$9$k(B
  • CSV$B!"(BHTML$B!"$^$?$O%F%-%9%H(B $B%U%!%$%k$+$i%G!<%?$r%$%s%]!<%H$9$k(B
  • Office $B$GMxMQ2DG=$J%0%i%U$N $B%X%k%W$r=*N;$7$J$5$$!#(B
    • $B%&%#%s%I%&$N:8>e$N@V$$%\%?%s$r2!$9!#(B

    $B!zN}=,LdBj(B(1803) $B6&DL2JL\!V>pJs(B($B $B6&DL2JL\!V>pJs(B($BO$rI=<($7$J$5$$!#(B
    $BC^GHBg3XA43X7W;;5!%7%9%F%`%[!<%`!&%Z!<%8(B
    https://www.u.tsukuba.ac.jp/
    $B6&DL2JL\!V>pJs!W
    http://www.u.tsukuba.ac.jp/info_lit/tebiki.html$B!#(B $B>e$N%[!<%`!&%Z!<%8$+$i!":8B&$N%a%K%e!<$N!V6&DL2JL\!V>pJs!W!W(B $B!d!V3XFbMQ!W!d!V $BBh(B9$B>O(B $BI=7W;;%=%U%H$rMQ$$$?%G!<%?=hM}(B(Excel2016 $B$N;H$$J}(B) $B;2>H!#(B

    $B!zN}=,LdBj(B(1804) Microsoft Excel $B$NI=<(7A<0(B

    $B0lHV>e$N%a%K%e!<%P!<$K$"$k!VI=<(!W%a%K%e!<$G!"
  • $BI8=`(B
  • $B%Z!<%8%l%$%"%&%H(B $BIaDL$O!VI8=`!W$rMxMQ$7$J$5$$!#(B

    $B!zN}=,LdBj(B(1805) $B?t<0%P!<$NI=<((B

    $B%;%k$K<0$,4^$^$l$F$$$?>l9g!"7W;;7k2L$G$O$J$/!"<0$=$N$b$N$rI=<($7$?$$!#(B $B?t<0%P!<$,I=<($5$l$F$$$J$1$l$P!"
  • $B0lHV>e$N%a%K%e!<%P!<$K$"$k!VI=<(!W%a%K%e!<$r%/%j%C%/$7!"%a%K%e!<$rI=<($9$k!#(B
  • $BI=<($5$l$k%a%K%e!<$G!"!V?t<0%P! Excel$B! ($B%/%j%C%/$G3HBg(B)

    $B!zN}=,LdBj(B(1806) $B4pK\A`:n(B($B%-!<%\!<%I(B)

    $B
  • $B%+!<%=%k$N0\F0(B($B%"%/%F%#%V%;%k$N@Z$jBX$((B): $B%+!<%=%k%-! $B%;%k$NA*Br(B: $B%7%U%H%-!<$r2!$7$J$,$i!"%+!<%=%k0\F0$NA`:n$r9T$&!#(B
  • $B%;%kFbMF$N%3%T!<(B: $B%;%k$rA*Br$7!"(BCommand+C $B$G%3%T!<$7!"(BCommand+V $B%Z!<%9%H$9$k!#(B
  • $B%;%kFbMF$N0\F0(B: $B%;%k$rA*Br$7!"(BCommand+X $B$G%+%C%H$7!"(BCommand+V $B%Z!<%9%H$9$k!#(B
  • $B%;%kFbMF$N>C5n(B:$B%;%k$rA*Br$7!"0lHV>e$NJT=8%a%K%e!<%P!<$N!VJT=8!W(B $B%a%K%e!<$+$i!"!V>C5n!W!"!VA4$F!W$HA*Br$9$k!#(B $B$^$?$O!"%;%k$rA*Br$7!"%P%C%/%9%Z!<%9!&%-!<$d(B Delete $B%-!<$rBG$D!#(B
  • Command+Z undo ($BA`:nA0$N>uBV$K$b$I$9(B)
  • Command+Y redo (undo$B$N8z2L$NC$7(B) $B
  • $BLp0u(B
  • $B%?%V(B
  • Shift+$B%?%V(B
  • $B%j%?!<%s(B(Enter)$B!!(B([$B)
  • Shift+$B%j%?!<%s(B

    $B!zN}=,LdBj(B(1807) $B%^%&%9$K$h$k4pK\A`:n(B

    $B%^%&%9$K$h$k
  • $B%"%/%F%#%V%;%k$N@ZBX$((B: $B%^%&%9$G%/%j%C%/$9$k!#(B
  • $B%;%k$NFbMF$N0\F0(B: $B%^%&%9$G%I%i%C%0$7$F%;%k$rA*Br$7!"(B $B%+!<%=%k$rF0$+$7$F!"%^%&%9!&%+!<%=%k$N7A$,

    $B!zN}=,LdBj(B(1808) $B%^%&%9$K$h$k9T$HNs$NA`:n(B

    $B%^%&%9$r;H$C$F!"9T$HNs$NA`:n$r$7$F$_$J$5$$!#(B
    • $B9T$N9b$5$NJQ99(B: $B:8C<$G!"9T$H9T$N6-3&$r%I%i%C%0$9$k!#(B
    • $BNs$NI}$NJQ99(B: $B>eC<$G!"Ns$HNs$N6-3&@~$N%I%i%C%0$9$k!#(B
    • $B9TA4BN$NA*Br(B: $B:8C<$G!"9THV9f$r%/%j%C%/$9$k!#(B $B%I%i%C%0$9$k$H!"J#?t9T$NA*Br$K$J$k!#(B
    • $BNsA4BN$NA*Br(B: $B>eC<$G!"Ns$N%"%k%U%!%Y%C%H$r%/%j%C%/$9$k!#(B $B%I%i%C%0$9$k$H!"J#?tNs$NA*Br$K$J$k!#(B
    • $B9T$N:o=|(B: $B:o=|$7$?$$9T$rA*Br$7$?8e$G!"(B $B0lHV>e$N%a%K%e!<%P!<$N!VJT=8!W%a%K%e!<$+$i!"!V:o=|!W$rA*$V!#(B
    • $BNs$N:o=|(B: $B:o=|$7$?$$Ns$rA*Br$7$?8e$G!"(B $B0lHV>e$N%a%K%e!<%P!<$N!VJT=8!W%a%K%e!<$+$i!"!V:o=|!W$rA*$V!#(B

    $B!zN}=,LdBj(B(1809) $B?tCM$NBG$A9~$_(B

    $B
  • 314
  • 3.14
  • 314159265358979323846
  • 3.14159265358979323846
  • 1 1/2 ($BBSJ,?t(B)
  • 3/10 ($BF|IU$H$7$F2r $B0lHV>e$N%a%K%e!<%P!<$N!V%U%)!<%^%C%H!W%a%K%e!<$N!V%;%k!W$N!V?tCM!W9`L\$G!">.?t(B $BE@0J2<$NI=<(7e?t$J$I$rD4@0$7$J$5$$!#I=<(I}$,ITB-$7$?;~$K$I$&$J$k$+!#(B

    Excel$B! ($B%/%j%C%/$G3HBg(B)

    $B!zN}=,LdBj(B(1810) $BF|IU$NBG$A9~$_(B

    $B%;%k$KF|IU$rBG$A9~$_$J$5$$(B
    • 2018/6/15
    • 2018-6-15
    • 6/15
    • 6-15
    $BBG$A9~$s$@8e!"?t<0%P!<$K$I$N$h$&$JCM$,I=<($5$l$k$+8+$J$5$$!#(B

    $BF|IU$,$"$k%;%k$NI=<(7A<0$r!"JQ99$7$J$5$$!#0lHV>e$N%a%K%e!<%P!<$N!V%U%)!<%^%C%H!W(B $B%a%K%e!<$N!VF|IU!W$N9`L\$+$iA*$V$+!"!V%f!<%6!

    Excel$B! ($B%/%j%C%/$G3HBg(B)

    $B!zN}=,LdBj(B(1811) $BJ8;zNs$NBG$A9~$_(B

    $B%;%k$KJ8;zNs$rBG$A9~$_$J$5$$!#(B $B?t$rBG$A9~$s$@>l9g$K$O!"1&B7$($K$J$k!#$3$N>l9g!"!V=q<0!W$G!VJ8;zNs!W$H(B $B$9$k$H!"J8;zNs$K$J$j:8B7$($K$J$k!#(B

    $BD9$$J8;zNs$rBG$A9~$s$@;~$N5sF0$r3NG'!&JQ99$7$J$5$$!#(B

    1. $B%;%k(B($B$?$H$($P(BA1)$B$KD9$$J8;zNs$rBG$A9~$`!#(B
    2. $B1&B&$N%;%k(B($B$?$H$($P(BB1)$B$K$bJ8;zNs$rBG$A9~$`(B
    3. $B%;%k(B(A1)$B$N=q<0$r!"JQ99$9$k!#(B $B0lHV>e$N%a%K%e!<%P!<$N!V%U%)!<%^%C%H!W%a%K%e!<$G!"(B $B!V%;%k!W$rA*$V$+!"(B(Command+1)$B$G!"%;%k$N(B $B=q<0$rI=<($9$k!#(B
    4. $B!VG[CV!W%?%V$r3+$/!#J8;z$N@)8f$G!"
    5. $B@^$jJV$7(B
    6. $B=L>.$7$FA4BN$rI=<((B Excel$B! ($B%/%j%C%/$G3HBg(B)
    $B$3$NA`:n$rDL$8$F!"%;%k$NI=<($r
  • $B%;%k$NI}$@$1I=<($9$k!#D9$$ItJ,$OI=<($7$J$$!#(B
  • $B%;%k$NI}$G9T$r@^$jJV$7$FI=<($9$k!#(B
  • $BA4BN$r=L>.$7$FI=<($9$k(B

    $B!zN}=,LdBj(B(1812) $B%*!<%H%U%#%k(B

    $BF1$8FbMF$dO"B3$7$??t$NBG$A9~$`$?$a$K!"%*!<%H%U%#%k$N5!G=$r;H$$$J$5$$!#(B
    1. $B%^%&%9$G%I%i%C%0$7$F%;%k$rA*Br$9$k!#(B
    2. $B%+!<%=%k$rF0$+$7$F!"%^%&%9!&%+!<%=%k$N7A$,9u$$==;z$K$J$C$?$i!"(B $B%I%i%C%0$9$k!#(B
    $B
  • $B?t8D$N%;%k$K!"(B1,2,3 $B$HO"B3$7$?CM$rF~$l$k!#(B
  • $BO"B3$7$?CM$rF~$l$??t8D$N%;%k$rA*Br$7!"%*!<%H%U%#%k$G!"?t==8D$KA}$d$9!#(B
  • $B?t8D$N%;%k$K!"(B1,1,1 $B$HF1$8CM$rF~$l$k!#(B
  • $BF1$8CM$rF~$l$??t8D$N%;%k$rA*Br$7!"%*!<%H%U%#%k$G!"?t==8D$KA}$d$9!#(B
  • $B?t8D$N%;%k$K!"(B=A1,=A2,=A3 $B$N$h$&$JO"B3$7$?;2>H$rF~$l$k!#(B
  • $B;2>H$rF~$l$??t8D$N%;%k$rA*Br$7!"%*!<%H%U%#%k$G!"?t==8D$KA}$d$9!#(B $B%*!<%H%U%#%k$r;H$&;~!"(B $BAjBP;2>H$H@dBP;2>H$GF0:n$,0[$J$k(B$B!#(B $B$3$N$3$H$r3NG'$7$J$5$$!#(B

    $B!zN}=,LdBj(B(1813) $B%3%T! $BN}=,LdBj(B $B%*!<%H%U%#%k(B $B$HF1$8$h$&$K!"J#?t$N%;%k$KN`;w$NCM$rKd$a$k;~$K!"%3%T!
  • $B%^%&%9$G%I%i%C%0$7$F%;%k$rA*Br$9$k!#(B
  • $B0lHV>e$N%a%K%e!<%P!<$N!VJT=8!W%a%K%e!<$+$i!"!V%3%T! $B%^%&%9$r%3%T!<@h$X0\F0$9$k!#(B
  • $B0lHV>e$N%a%K%e!<%P!<$N!VJT=8!W%a%K%e!<$+$i!"!V%Z!<%9%H!W$rA*$V!#(B

    $B!zN}=,LdBj(B(1814) $B4X?t$H;2>H(B

    $B
  • ~yas/public_html/htdocs/coins/literacy-2018/2018-06-15/exam-result.xlsx
    $ $BI,MW$J$i(B mkdir $B$G%G%#%l%/%H%j$r:n$k(B [$B
    $ $BI,MW$i(B cd $B$G%+%l%s%H%o!<%-%s%0%G%#%l%/%H%j$r0\F0$9$k(B [$B
    $ cp ~yas/public_html/htdocs/coins/literacy-2018/2018-06-15/exam-result.xlsx . [$B
    
  • $B$^$?$O!" [web] $B%3%T!<$7$?8e!"$3$N%U%!%$%k$KBP$7$F!"
  • $B%;%k(B D11 $B$K!"%l%]!<%H$NF@E@(B B11 $B$r(B 0.6 $BG\$7$?%G!<%?$rCV$/!#(B
    =B11*0.6
  • $B%;%k(B E11 $B$K!";n83$NF@E@$r(B 0.4 $BG\$7$?%G!<%?$rCV$/!#(B
    =C11*0.4
  • $B%;%k(B F11 $B$K!"(BD11 $B$H!!(BE11 $B$NOB$rCV$/!#(B
    =D11+E11
  • $B%;%k(B G11 $B$K!"@.@S(B A+, A, B, C, D $B$rCV$/!#(B90$BE@0J>e$O(BA+$B!"(B80$BE@0J>e$O(B A$B!"(B70$BE@0J>e$O(BB$B!"(B60$BE@0J>e$O(BC$B!"$=$l0J30$O(BD$B$H$9$k!#(B
    =if(F11>=90,"A+",if(F11>=80,"A",if(F11>=70,"B",if(F11>=60,"C","D"))))
  • $B%*!<%H%U%#%k$N5!G=$r;H$C$F!"(BD11:G11 $B$NFbMF$r(B D12:G12 $B$+$i(B D50:G50 $B$^$G(B $B%3%T!<$9$k!#%*!<%H%U%#%k$N5!G=$G$O$J$/!"%3%T! H4:H8 $B$K!"$=$l$>$l(B A+ $B$N?M?t!"(BA $B$N?M?t!"(BB$B$N?M?t!"(BC$B$N?M?t!"(BD$B$N?M?t$rCV$/!#(B
    • H4 =countif(G$11:G$50,"A+")
    • H5 =countif(G$11:G$50,"A")
    • H6 =countif(G$11:G$50,"B")
    • H7 =countif(G$11:G$50,"C")
    • H8 =countif(G$11:G$50,"D")

    $B!zN}=,LdBj(B(1815) $B%0%i%U$N:n@.(B

    $BN}=,LdBj(B(1814) $B4X?t$H;2>H(B $B$r9T$$$J$5$$!#(B $B$=$7$F!"@.@S$N?M?t$+$i Excel $B$G:n@.$7$?K@%0%i%U!

    $B$^$:!"4pK\E*$J%0%i%U$rA^F~$7$J$5$$!#(B

    1. G3:H8 $B$N%;%k$r!"%I%i%C%0$7$FA*Br$9$k(B
    2. $B0lHV>e$N%a%K%e!<%P!<$N!VA^F~!W%a%K%e!<$G!V%0%i%U!W!"!V=DK@!W$rA*Br$9$k!#(B
      Excel$B! ($B%/%j%C%/$G3HBg(B)
      $B$"$k$$$O!"%j%\%s$N!VA^F~!W$rI=<($9$k!#(B $B!V=DK@!W$NCf$N!V(B(2-D)$B=DK@!W!d!V=89g=DK@!W$rA*$V!#(B
      Excel$B! ($B%/%j%C%/$G3HBg(B)

    X$B<4(B($BBh#12#<4!"9`L\<4(B)$B$r@_Dj$7$J$5$$!#(B

    1. $B%0%i%U$r%/%j%C%/$7$FA*Br$9$k!#(B
    2. $B!V%j%\%s!W$N!V%0%i%U$N%G%6%$%s!W$G!"!V%0%i%UMWAG$NDI2C!W!"!V<4%i%Y%k!W!"(B $B!VBh#12#<4!W$rA*$V!#(B
      Excel$B! ($B%/%j%C%/$G3HBg(B)
    3. $B%0%i%U$N2#<4$N2<$K$"$k!V<4%i%Y%k!W$H=q$+$l$F$$$kItJ,$N%F%-%9%H$r:o=|$7!"(B $B!V@.@S!W$HF~$l$k!#(B
    Y$B<4!JBh#1=D<4!"?tCM<4!K$r@_Dj$7$J$5$$$k(B
    1. $B%0%i%U$r%/%j%C%/$7$FA*Br$9$k!#(B
    2. $B!V%j%\%s!W$N!V%0%i%U$N%G%6%$%s!W$G!"!V%0%i%UMWAG$NDI2C!W!"!V<4%i%Y%k!W!"(B $B!VBh#1=D<4!W$rA*$V!#(B
    3. $B%0%i%U$N=D<4$N:8$K$"$k!V<4%i%Y%k!W$H=q$+$l$F$$$kItJ,$N%F%-%9%H$r:o=|$7!"(B $B!V?M?t!W$HF~$l$k!#(B

    $B%0%i%U$K%?%$%H%k$rIU$1$J$5$$!J=$@5$7$J$5$$!K!#(B

    1. $B%0%i%U$r%/%j%C%/$7$FA*Br$9$k!#(B
    2. $B!V%j%\%s!W$N!V%0%i%U$N%G%6%$%s!W$G!"!V%0%i%UMWAG$NDI2C!W!"!V%0%i%U%?%$%H%k!W!"(B $B!V%0%i%U$N>e!W$rA*$V!#(B
      Excel$B!e(B"> ($B%/%j%C%/$G3HBg(B)
    3. $B%0%i%UFb$N!V%0%i%U(B $B%?%$%H%k(B($B?M?t(B)$B!W$NItJ,$r(B $B!V@.@S$NJ,I[!W$HF~$l$k(B

    $B!zN}=,LdBj(B(1816) $B%0%i%U$N:n@.!"%0%i%U$ND4@0(B

    $B$^$:(B $BN}=,LdBj(B(1815) $B%0%i%U$N:n@.(B $B$r9T$$$J$5$$!#(B $B$3$N%0%i%U$KBP$7$F!"
  • $BK^Nc(B($B!V7ONs#1!W(B)$B$,$"$l$P!"I=<($r$J$/$9!#(B $B!V%j%\%s!W$N!V%0%i%U$N%G%6%$%s!W$G!"!V%0%i%UMWAG$NDI2C!W!"!VK^Nc!W!"(B $B!V$J$7!W$rA*$V!#(B
  • $B%0%i%U$N!VEI$j$D$V$7!W$N!V%0%i%G!<%7%g%s!W$r>C$9!#(B
    • $B!V%j%\%s!W$N!V%0%i%U$N%G%6%$%s!W$N!V%/%$%C%/%9%?%$%k!W$G!"(B $B%0%i%G!<%7%g%s!J1F!K$,$J$$$b$N$rA*$V!#(B
    • $BJQ99$7$?$$%0%i%U$NK@!J7ONs!K$r%/%j%C%/$7!"(B $B%3%s%F%-%9%H%a%K%e!<$G!V%0%i%U7ONs$N=q<0@_Dj!W$rA*$S!"(B $B!VEI$j$D$V$7!W$G!V<+F0!W$K$9$k!J%0%i%G!<%7%g%s$r$O$:$9!K(B
  • $B!V1F!W$r>C$9!#(B $BC$9J}K!$HF1MM!#(B
  • $BI,MW$K1~$8$F!"%?%$%H%k$d<4%i%Y%k$N%U%)%s%H$rJQ$($k(B($B%*%W%7%g%s(B)$B!#(B
  • $BI,MW$K1~$8$F!"%0%i%U%(%j%"$N30B&$N@~$r$J$/$9(B($B%*%W%7%g%s(B)$B!#(B Excel $B$G:n@.$7$?K@%0%i%U!

    $B!zN}=,LdBj(B(1817) $B%U%#%k%?$H2r@O(B

    $BN}=,LdBj(B(1814) $B4X?t$H;2>H(B $B$r9T$$$J$5$$!#(B $B$=$NI=$G!"
  • 10$B9T$K%U%#%k%?$r@_CV$9$k!#(B10$B9T$r%/%j%C%/$7$FA*Br$7!"(B $B!V%G!<%?!W%a%K%e!<$N(B $B!V%U%#%k%?!d%U%#%k%?!W$rA*$V!#(B $B%U%#%k%?$N5!G=$rMxMQ$7$F!"
  • $BFCDj$N@.@S(B($B$?$H$($P(BS$B$N?M$@$1(B)$B$rI=<($G$-$k$h$&$K$9$k!#(B
  • $B@.@S$,$h$$=g$KJB$YBX$($k!#(B
  • $BO"HV$N=g$KJB$YBX$($k!#(B
  • B4:F7 $B$K!"$=$l$>$lNs$NJ?6QCM(B(average)$B!":GBgCM(B(max)$B!":G>.CM(B(min)$B!"(B $BCf1{CM(B)(median)$B$rI=<($9$k!#Nc(B: =average(B$11:B$50)

    $B!zN}=,LdBj(B(1818) CSV$B$NFI$_9~$_$H%0%i%U$N:n@.(B

    $B
  • ~yas/public_html/htdocs/coins/literacy-2018/2018-06-15/tsukuba-weather-2013.csv
  • [web] $B$3$N(BCSV$B%U%!%$%k$rI=7W;;%=%U%H%&%'%"$GFI$_9~$_$J$5$$!#(B
    • $B!V%U%!%$%k!W%a%K%e!<$+$i!V3+$/!W$rA*$V!#(B
    • $B!V<+J,$N(BMac$B!W$rA*$V!#(B
    • $B%G%#%l%/%H%j$rA*$V(B
    • $BL\E*$N%U%!%$%k$rA*$V!#(B
    $B$=$7$F!"I=7W;;%=%U%H%&%'%"$NI8=`$N7A<0(B(.xlsx $B$+(B .xls)$B$GJ]B8$7$J$5$$!#(B
    • $B!V%U%!%$%k!W%a%K%e!<$+$i!VL>A0$rIU$1$FJ]B8!W$rA*$V!#(B
    • $B!V%U%!%$%k7A<0!W$G!V(BExcel $B%V%C%/(B(.xlsx)$B!W$+!V(BExcel 97-2004 $B%V%C%/(B(.xls)$B!W$rA*$V!#(B
    • $B!V>l=j!W$G%G%#%l%/%H%j$rA*$V!#(B
    • $B:G8e$K!VJ]B8!W%\%?%s$r2!$9!#(B

    $B$3$N%G!<%?$r;H$C$F!"

    $BC^GH$N7n$4$H$N:GDc5$29!

    $B%0%i%U$N:n@.(B

    1. $B%0%i%U$r=q$-$?$$%G!<%?$rA*Br$9$k(B(H5:J17)
    2. $B!VA^F~!W%a%K%e!<$G!V%0%i%U!W$rA*Br$9$k!#(B $B$"$k$$$O!"%j%\%s$N!VA^F~!W$N!V@^$l@~%0%i%U!W$G!"(B $B!V#2!]#D!W$N!V%^!<%+! X$B<4$N@_Dj(B
      1. $B%0%i%U$r%/%j%C%/$7$FA*Br$9$k!#(B
      2. $B0lHV>e$N!V%G!<%?!W%a%K%e!<$+$i!"!V%0%i%U$N85%G!<%?!W$rA*Br$9$k!#(B
      3. $B!V2#(B($B9`L\(B)$B<4%i%Y%k!W$N1&B&$N%\%?%s$r2!$7!"(B $B%o!<%/%7!<%H$N0LCV$rA*Br$9$k>uBV$K$9$k!#(B
      4. $B%o!<%/%7!<%H$NCf$G!"7n$N%G!<%?(B(A6:A17) $B$r%I%i%C%0$7$FA*Br$9$k(B
      5. $B%&%$%s%I%&$N1&B&$N%\%?%s$r2!$7!"85$N!V%0%i%U%G!<%?$NA*Br!W$N%&%$%s%I%&$KLa$k(B
      6. $B!V(BOK$B!W%\%?%s$r2!$9(B
      $BK^Nc$r1&B&$KI=<($9$k!#(B
      1. $B%0%i%U$r%/%j%C%/$7$FA*Br$9$k!#(B
      2. $B!V%j%\%s!W$N!V%0%i%U$N%G%6%$%s!W$G!"!V%0%i%UMWAG$NDI2C!W!"(B $B!VK^Nc!W!"!V1&!W$rA*$V!#(B
      $B7ONs!JK^Nc9`L\!K$N=gHV$rF~$lBX$($k(B
      1. $B%0%i%U$r%/%j%C%/$7$FA*Br$9$k!#(B
      2. $B0lHV>e$N!V%G!<%?!W%a%K%e!<$+$i!"!V%0%i%U$N85%G!<%?!W$rA*Br$9$k!#(B
      3. $B!VK^Nc9`L\(B($B7ONs(B)$B!W$N2<$G!"0\F0$5$;$?$$9`L\$rA*$S!"(B $BLp0u$r2!$7$F0\F0$9$k!#(B
      4. $B!V(BOK$B!W%\%?%s$r2!$9(B
      $BN}=,LdBj(B $B4X?t!";2>H!"%0%i%U(B$B$HF1MM$K!"(B $B%?%$%H%k$H<4$r@_Dj$9$k!#$5$i$K
    3. $B=D<4$NL\@9$N4V3V(B(10$BEYCV$-(B)$B!":G9b(B(40$BEY(B)$B!":GDc(B(-10$BEY(B)$B$rD4@0$9$k!#(B
    4. $B=D<4$N@_Dj$G!"2#<4$N8rE@$r(B 0 $B$G$O$J$/!"(B-10 $B$K$9$k!#(B
    5. $B7ONs$N=q<0$G!"@~$NB@$5!"%^!<%+!<$NBg$-$5!"?'!"1F$rD4@0$9$k(B
    6. $BA4BN$NBg$-$5$HJ8;z$NBg$-$5$N%P%i%s%9$rD4@0$9$k(B
    7. $B30B&$NOH$r>C$9(B

      $B!zN}=,LdBj(B(1819) $B%F%-%9%H$NFI$_9~$_(B($B%?%V6h@Z$j(B)

      $BN}=,LdBj(B(1818) $B$HF1MM$K!"%F%-%9%H(B($B%?%V6h@Z$j(B)$B$rFI$_$3$_!"%0%i%U$r:n@.$7$J$5$$!#(B
      • ~yas/public_html/htdocs/coins/literacy-2018/2018-06-15/tsukuba-weather-2013.txt
      • [web]

      $B!zN}=,LdBj(B(1820) LibreOffice$B$N(BCalc

      LibreOffice $B$N(B Calc ($BI=7W;;%I%-%e%a%s%H(B) $B$r$ open /usr/local3/coins/macosx/Applications/LibreOffice.app [$B $B
    8. Excel $B%V%C%/(B( .xlsx, .xls )
    9. CSV $B%U%!%$%k(B
    10. $B%?%V6h@Z$j$N%F%-%9%H!&%U%!%$%k(B $B$=$N5!G=$r3NG'$7$J$5$$!#;H$$>!2A$7$J$5$$!#(B

      $B!zN}=,LdBj(B(1821) $B%F%-%9%H$NFI$_9~$_(B($B8GDjD9%U%#!<%k%I(B)

      ls -l $B%3%^%s%I$N7k2L$K$D$$$F!"
    11. ls -l $B$N7k2L$r%U%!%$%k$KJ]B8$7$J$5$$!#(B
    12. $B$=$l$r!"(BExcel $B$G3+$-$J$5$$!#(B $B$3$N;~!"!V%9%Z!<%9$K$h$C$F1&$^$?$O:8$KB7$($i$l$?8GDjD9%U%#!<%k%I$N%G!<%?!W$H$7$F(B $B07$$$J$5$$!#(B
    13. $B7?(B($B%b!<%I(B)$B!"%j%s%/?t!"=jM-A0$r$=$l$>$l(B $BNs$H$7$FG'<1$7$J$5$$!#(B
    14. $B%U%!%$%k$NBg$-$5$N=g$KJB$YBX$($J$5$$!#(B
    15. $B%U%!%$%k$N%P%$%H?t$N9g7W$r7W;;$7$J$5$$!#(B $BJ8;z%3!<%I$NLdBj$,$"$l$P!"(B nkf$B%3%^%s%I(B (network kanji finter) $B$d(B Emacs M-x set-buffer-file-coding-system $BEy$GJQ49$7$J$5$$!#(B

      $B!zN}=,LdBj(B(1822) HTML$B$NI=$NFI$_9~$_(B

      CSV$B$HF1MM$K!"I=$r4^$`(BHTML$B$N%F%-%9%H$rFI$_$J$5$$!#(B $BI=$NItJ,$@$1$r!"I=7W;;$N%G!<%?$H$7$F

      $BCm0U(B: HTML$B%U%!%$%k$N3HD%;R$O!"!V(B.html$B!W$K$9$k!#M>7W$J3HD%;R!"$?$H$($P(B $B!V(B.php.html$B!W$K$J$C$F$$$k$H!"(BHTML$B%U%!%$%k$H$7$FG'<1$5$l$J$$$3$H$,$"$k!#(B

      $B!zN}=,LdBj(B(1823) $B9T$HNs$NA^F~(B

      $B%a%K%e!
    16. $B9T$N:o=|!#(B
    17. $B9T$NA^F~!#(B
    18. $BNs$N:o=|!#(B
    19. $BNs$NA^F~!#(B

      $B!zN}=,LdBj(B(1824) $B3NG'HV9fI=(B

      $B

      $B%R%s%H(B: rand() $B$GMp?t$r:n@.$9$k!#Mp?t$NHO0O$r(B1000$B$+$i(B9999$B$NHO0O$K(B $B$9$k!#(Bround() $B$G@0?t$K$9$k$+!"I=<($G>.?tE@0J2<$r@Z$k!#(B

      $B!zN}=,LdBj(B(1825) $B%=!<%H5!G=$NMxMQ(B

      $B%=!<%H5!G=$rMxMQ$7$F$_$J$5$$!#(B $BJ#?t$N9T$rA*Br$7!"(B $B!V%G!<%?!W%a%K%e!<$+$i!VJB$YBX$(!W$rA*$V!#(B

      $B!zN}=,LdBj(B(1826) $B%U%#%k%?5!G=$NMxMQ(B

      $B%U%#%k%?5!G=$rMxMQ$7$F$_$J$5$$!#(B $B%?%$%H%k$r4^$`9T$rA*$S!"!V%G!<%?!W%a%K%e!<$+$i!V%U%#%k%?!W$N(B $B!V%U%#%k%?!W$rA*$V!#(B

      $B!zN}=,LdBj(B(1827) $B%;%k$N7k9g(B

      $BJ#?t$N%;%k$r7k9g$7$F$_$J$5$$!#(B
      • $B7k9g$7$?$$%;%k$rA*Br$7!"(B $B%a%K%e!<%P!<$N!V%U%)!<%^%C%H!W$N!V%;%k!W(B(Command+1)$B$G!"%;%k$N=q<0$rI=<($9$k!#(B $B!VG[CV!W%?%V$r3+$/!#(B
      • $B7k9g$7$?$$%;%k$rA*Br$7!"(B $B!V%[!<%`!W%j%\%s$N!VG[CV!W$N!V%;%k7k9g!W$rA*$V!#(B
      $B7k9g$7$?%;%k$r85$KLa$7$J$5$$!#(B

      $B!zN}=,LdBj(B(1828) $B%;%k$N=q<0(B

      $B
    20. $BJ8;z$N%U%)%s%H!"Bg$-$5!"?'!"GX7J$rJQ99$9$k(B
    21. $B:81&$NB7$((B($B1&B7$(!"Cf1{B7$(!":8B7$((B)$B!">e2<(B
    22. $B9T$N9b$5!"Ns$NI}(B
    23. $B7S@~$NI=<((B

      $B!zN}=,LdBj(B(1829) $B8B3&(B

      $B
    24. $B$"$k%;%k$K(B 1 $B$HBG$A9~$`!#(B
    25. $B$=$N2<$N%;%k$K(B $B>e$N%;%k$r(B 2 $BG\$7$?CM$r<0$GF~$l$k!#(B
    26. $B$=$N2<$N%;%k(B($B?t==8D(B)$B$K(B 2. $B$r%3%T!<$9$k!#(B
    27. $B7W;;7k2L$,9g$o$J$/$J$k=j$,=P$F$/$k=j$r3NG'$9$k!#(B
    $B%;%k$K
  • =0.3-0.2-0.1+0 $B$=$N7k2L$r9M;!$7$J$5$$!#(B

    $B!zN}=,LdBj(B(1830) Windows$BHG$H(BMacOSX $BHG$NHf3S(B

    iMac $B$N(B Microsoft Excel $B$G:n@.$7$?%U%!%$%k$r!"3XN`(B PC $B$N(B Windows $B$N(B Microsoft Excel $B$GFI$_9~$_$J$5$$!#%;%k$N%G!<%?$d%0%i%U!"%U%)%s%HEy$N8+(B $B1I$(!"%Z!<%86-3&$,$I$N$h$&$K$J$k$+D4$Y$J$5$$!#$^$?5U$K!"(BWindows $BB&$G:n(B $B@.$7$?%U%!%$%k$r(BiMac $B$G3+$$$FHf3S$7$J$5$$!#(B

    $B!zN}=,LdBj(B(1831) gnuplot

    The Unix Super Text 52.3$B@a(B $B;2>H(B$B!#(Bgnuplot $B$G!"%0%i%U$r:n@.$7$J$5$$!#7A<0$H$7$F$O!"(B x11 ($BI8=`(B), EPS, tgif, png, $B$=$NB>(B( help terminal $B;2>H(B)$B$r;H$$$J$5$$!#(B $B:n@.$7$?%0%i%U$r!"%o!<%I%W%m%;%C%5!"$^$?$O!"(BLaTeX $B$NJ8=q$K

    $B!zN}=,LdBj(B(1832) NFS$BE}7W$N;k3P2=(B

    $B
  • ~yas/public_html/htdocs/coins/literacy-2018/2018-06-15/nfsstat_1500.csv $B$3$l$r2r@O$7$F!"pJs$r;k3P2=$7$J$5$$!#(B
    • NFS ops/s (operations/second)
    • IOPS (read $B$H(B write)
    • Network I/O ($BAw CPU $BMxMQN($H(B Disk $BMxMQN((B
    $B%U%!%$%k%5!<%P$N(BCPU$BMxMQN($H%G%#%9%/;HMQN($N?d0\(B

    $B"#2]Bj(B18 $BI=7W;;!"%0%i%U$N:n@.(B

    $B:#F|$N2]Bj$G$O!"(B(1) $B$H(B (5) [$B2CE@(B], (6) [$B2CE@(B] $B$N7k2L$r!"(BTA $B$KDs<($7!"3N(B $BG'HV9f$r

    (1) $BN}=,LdBj(B(1814) $B4X?t$H;2>H(B$B!"(B $BN}=,LdBj(B(1815) $B%0%i%U$N:n@.(B$B!"$*$h$S!"(B $BN}=,LdBj(B(1816) $B%0%i%U$N:n@.!"%0%i%U$ND4@0(B $B$r9T$$$J$5$$!#(B $B7k2L$r(B TA $B$K<($7!"3NG'HV9f$r

    (2) $B@5$N?t$rI=<($9$k%0%i%U$G$O!"?tCM<4$N:G>.CM$r(B 0 $B$K$9$k$3$H$,=EMW$G$"(B $B$k!#$=$NM}M3$r4JC1$K@bL@$7$J$5$$!#(B

    (3) $B650iMQ7W;;5!%7%9%F%`;HMQ$N

  • 2.7.2 lv $B%3%^%s%I(B
  • 2.7.5 grep $B%3%^%s%I(B
  • 3.3.7 (Emacs) $B8!:w!&CV49(B
  • 4.1.4 (Firefox) $B%V%i%&%6$N%7%g!<%H%+%C%H(B
  • 4.2.5 (Thunderbird) $B%K%e!<%9$N;H$$J}(B $B
  • lv $B%3%^%s%I$G!"%Q%?!<%s$G<($5$l$?J8;zNs$r%U%!%$%k8eJ}$K8~$C$F8!:w(B $B$9$k$?$a$N%-!<(B:
  • lv $B%3%^%s%I$G!"%Q%?!<%s$G<($5$l$?J8;zNs$r%U%!%$%kA0J}$K8~$C$F8!:w(B $B$9$k$?$a$N%-!<(B:
  • $B%U%!%$%k$dI8=`F~NO$rFI$_!"J8;zNs$N8!:w$r9T$$!"J8;zNs$,4^$^$l$F$$$k(B $B9T$rI=<($9$k%3%^%s%I(B:
  • Emacs $B$G!"8!:wBP>]$NJ8;z$r%?%$%W$9$k$?$S$K!"$=$N;~E@$GF~NO$5$l$?(B $BJ8;zNs$H0lCW$9$kJ8;zNs$N$"$k>l=j$K%+!<%=%k$r0\F0$9$k$h$&$J8!:wG7J}K!(B:
  • Emacs$B$N(BC-s:
  • Emacs$B$N(BC-r:
  • Emacs$B$G%$%s%/%j%a%s%?%k!&%5!<%A$r=*N;$9$k%-!<(B:
  • Emacs$B$GBPOCE*$KJ8;zNs$rCV$-49$($k$?$a$N%-!<(B:
  • Emacs$B$GBPOCE*$KJ8;zNs$rCV$-49$($kESCf$G!"CV$-49$($?$$;~$KBG$D%-!<(B:
  • Emacs$B$GBPOCE*$KJ8;zNs$rCV$-49$($kESCf$G!"CV$-49$($?$/$J$$;~$KBG$D%-!<(B:
  • Firefox$B$G!"%Z!<%8Fb$NJ8;zNs$r8!:w$9$k$?$K;H$&%-!<(B:
  • Thunderbird$B$G!"%K%e!<%9%0%k!<%W%"%+%&%s%H$r@_Dj$9$k;~$K;H$&%K%e!<(B $B%9%5!<%P(B(NNTP$B%5!<%P(B): (4) $B?7(BLinux/UNIX$BF~Lg$N
  • 08-051
  • 05-028 $B
  • $B!V(Bgrep -e aa -e bb file1$B!W$N0UL#(B
  • $B!V(Bgrep aa file1 | grep bb$B!W$N0UL#(B
  • $B!V(Bfind /bin -name "ch*"$B!W$N0UL#(B
  • $B!V(Bfind ~ -mtime -4 $B!W$N0UL#(B

    (5) [$B2CE@(B]$B!!(B $BN}=,LdBj(B(1818) $B$HF1MM$J%0%i%U$r:n@.$7$J$5$$!#$=$l$r!"%o!<%I%W%m%;%C%5!"$^$?$O!"(BLaTeX $B$NJ8=q$K

  • http://www.data.jma.go.jp/obd/stats/etrn/index.php $B$K(B $B$"$k5$>]D#$,Ds6!$7$F$$$k2a5n$N%G!<%?$+$i$D$/$P;T0J30$G!"<+J,$,=;$s$@$3(B $B$H$,$"$kCO0h$K0lHV6a$$COE@$rA*$V!#$3$NCf$K$J$$>l9g$K$O!"$D$/$P;T0J30$N(B $BG$0U$NCOE@$rA*$V!#(B
  • $B2a5n(B10$BG/0JFb$NG/$rA*$V!#(B
  • $B!V7n$4$H$NCM$rI=<(!W$rA*$V!#(B
  • HTML $B7A<0$GJ]B8$9$k!#(B HTML$B%U%!%$%k$N3HD%;R$O!"!V(B.html$B!W$K$9$k!#(B
  • $BN}=,LdBj(B(1822) $B$HF1MM$K!"(BHTML $BFb$NI=$r3+$/!#(B
  • $BI,MW$J9T$HNs$r;D$7$F!"ITMW$J9T$HNs$r:o=|$9$k!#(B
  • $BI=7W;;$N7A<0$GJ]B8$9$k!#(B
  • $B0J8e!"L\E*$N%G!<%?$rA*Br$7!"$=$l$r7ONs$H$7$F%0%i%U$r:n@.$9$k!#(B
  • $BMM!9$J=q<0$r@0$($F8+$d$9$/$9$k!#(B
  • $B%o!<%I%W%m%;%C%5!"$^$?$O!"(BLaTeX $BJ8=q$K PDF$B%U%!%$%k$r:n@.$9$k!#(B $B7k2L(B(Excel$B$N2hLL!"%o!<%I%W%m%;%C%5!"$^$?$O!"(BLaTeX$B$N%=!<%9!"(BPDF$B%U%!%$%k(B)$B$r(B TA $B$K<($7!"3NG'HV9f$r

    $BCm0U(B: Excel $B$K$O!"(BHTML $B$N(B <table> $B%?%0$r2re$N(B 3.-4. $B$NBe$o$j$K%3%T!7W$J9T$,4^$^$l$?$jNs$,(B $B9g$o$J$$$3$H$,$"$k!#(B

    (6) [$B2CE@(B] $BN}=,LdBj(B(1832) NFS$BE}7W$N;k3P2=(B $B$r9T$$$J$5$$!#(B $BMxMQ$9$k%D!<%k$H$7$F$O!"

  • gnuplot
  • LibreOffice 2$B$D0J>e$N%0%i%U$r:n@.$7$J$5$$!#:n@.$7$?%0%i%U$r!"%o!<%I%W%m%;%C%5!"$^$?(B $B$O!"(BLaTeX $BJ8=q$K?^$H$7$F


    Last updated: 2018/06/19 17:23:55
    Yasushi Shinjo / <yas@cs.tsukuba.ac.jp>