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

					2014$BG/(B06$B7n(B06$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>pJs9)3X0h(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-2014/2014-06-06
$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%;%k(B(cell)
    $B#1$D$N>#L\(B
    $B9T(B (row)
    $B2#$K@Z$C$?$b$N(B
    $BNs(B (column)
    $B=D$K@Z$C$?$b$N(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
    $BF,$K(B $ $B$rIU$1$k!#(B$A1 $B$d(B A$1 $B$d(B $A$1 $B$N$h$&$K!#(B
    $B%;%k$r%3%T!<$7$?;~$K!"AjBPE*$J;2>H$G$O!"<+F0E*$KHV9f$NIU$1BX$($,9T$o$l(B $B$k!#@dBPE*$J$b$N$G$O9T$o$l$J$$!#(B

    $B$=$NB>!"(BA1,B2 $B$NBe$o$j$K(B R1C1, R2C2 $B$N$h$&$JI=8=J}K!(B(Lotus 123) $B$b$"$k!#(B

    $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$rJT=8$9$k$K$O!"!V?t<0%P!

    $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!#(BA1, B2 $B$N$h$&$J%;%k$NL>A0$r=q$/$H$=$NFbMF$,;2>H$G$-$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>.(B
    if()
    $B>r7oH=Dj!#Bh(B1$B0z?t$,(Btrue$B$J$iBh(B2$B!"$=$&$G$J$1$l$PBh(B3$B0z?t$NCM(B
    sumif()
    $B>r7o$rK~$?$;$P2C$($k(B
    countif()
    $B>r7o$rK~$?$;$P?t$($k(B

    $B"!=q<0(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

  • $B@^$l@~%0%i%U(B
    $BC^GH$N7n$4$H$N:GDc5$29!
  • $BK@%0%i%U(B
    Excel $B$G:n@.$7$?K@%0%i%U!
  • $B2#K@%0%i%U(B
  • $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

    $BCm0U(B:

    $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(1501) 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 Office 2011$B!W(B $B$NCf$N!V(BMicrosoft Excel.app$B!W$r$ open "/Applications/Microsoft Office 2011/Microsoft Excel.app" [$B
  • $B!V$h$&$3$=!W$,I=<($5$l$?$i!"!VB39T!W%\%?%s$r2!$9!#(B
  • $B!V(BExcel $B%V%C%/(B $B%.%c%i%j! $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(1502) 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

    $B!V(BExcel $B%X%k%W!W$N%&%$%s%I%&$N:82<$K!"!V%*%s%i%$%s!W$H!V%*%U%i%$%s!W$N(B $B@ZBX$,$"$k!#!V%*%U%i%$%s!W$O!"%M%C%H%o!<%/$K@\B3$5$l$F$$$J$/$F$bMxMQ$G(B $B$-$k!#!V%*%s%i%$%s!W$O!">pJs$,B?$$$,!"%^%$%/%m%=%U%H

    $BL\

  • $B%G!<%?$NF~NO$H%$%s%]!<%H(B
  • $B%0%i%U$H%0%i%U%#%C%/%9(B $B%X%k%W$r=*N;$7$J$5$$!#(B

    $B!zN}=,LdBj(B(1503) $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
    http://www.u.tsukuba.ac.jp/
    $B6&DL2JL\!V>pJs(B($B
    http://www.u.tsukuba.ac.jp/tebiki/tebiki.pdf $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(Excel2010 $B$N;H$$J}(B) $B;2>H!#(B

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

    $B!VI=<(!W%a%K%e!<$G
  • $BI8=`(B
  • $B%Z!<%8%l%$%"%&%H(B $BDL>o$O!"I8=`$rMxMQ$9$k!#(B

    $B!zN}=,LdBj(B(1505) $B4pK\A`:n(B

    $B
  • $B%+!<%=%k$N0\F0(B($B%"%/%F%#%V%;%k$N@Z$jBX$((B)
  • $B%;%kFbMF$N0\F0(B: $B%;%k$NA*Br!"(BCommand+C $B%3%T!+V $B%Z!<%9%H(B
  • $B%;%kFbMF$N%3%T!<(B: $B%;%k$NA*Br!"(BCommand+X $B%+%C%H!"(B Command+V $B%Z!<%9%H(B
  • Command+Z undo ($BA`:nA0$N>uBV$K$b$I$9(B), Command+Y redo (undo$B$N8z2L$NC$7(B) $B
  • Tab, Shift+Tab, Return, Shift+Return
  • $BLp0u(B $B%^%&%9$K$h$k
  • $B9T$N9b$5!"Ns$NI}$NA}8:(B($BC<$N9T!?Ns$N6-3&@~$N%I%i%C%0(B)
  • $B%o!<%/%7!<%H$N@Z$jBX$((B($B2<$N%?%V$N%/%j%C%/(B)
  • $B%;%k$NFbMF$N0\F0(B($B%I%i%C%0!"%^%&%9!&%+!<%=%k$, $BF1$8FbMF$dO"B3$7$??t$NBG$A9~$_(B($B%I%i%C%0!"%^%&%9!&%+!<%=%k$,==;z(B($B%*!<%H%U%#%k(B))
  • $B%;%k$r;XDj$7$F!"%3%T! $B%a%K%e!
  • $B9T$NA^F~!":o=|(B
  • $BNs$NA^F~!":o=|(B
  • $B!V=q<0@_Dj%D!<%k%P! $B!V?t<0%P! $B%;%kFbMF$N%/%j%"(B $B!V?t<0%P!o$KI=<($9$k$3$H$r>)$a$k!#(B

    $B!zN}=,LdBj(B(1506) $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 $B!V=q<0!W%a%K%e!<$N!V%;%k!W$N!V?tCM!W9`L\$G!">.?tE@0J2<$NI=<(7e?t$J$I$r(B $BD4@0$7$J$5$$!#I=<(I}$,ITB-$7$?;~$K$I$&$J$k$+!#(B

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

    $B%;%k$KF|IU$rBG$A9~$_$J$5$$(B
    • 2014/6/6
    • 2014-6-6
    • 6/6
    • 6-6
    $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$$!#!V=q<0!W%a%K%e!<$N!VF|IU!W$N(B $B9`L\$+$iA*$V$+!"!V%f!<%6!$B!zN}=,LdBj(B(1508) $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 $B!V=q<0!W!d!V%;%k!W(B(Command+1)$B$G!"%;%k$N=q<0$rI=<($9$k!#(B $B!VG[CV!W%?%V$r3+$/!#(B $BJ8;z$N@)8f$G!"(B $B
    4. $B@^$jJV$7(B
    5. $B=L>.$7$FA4BN$rI=<((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(1509) $B%*!<%H%U%#%k$H%3%T! $BF1$8FbMF$dO"B3$7$??t$NBG$A9~$`$?$a$K!"%*!<%H%U%#%k$N5!G=$r;H$$$J$5$$!#(B $B$^$?!"N`;w$N$3$H$r!"%3%T!
  • 1,2,3,..., $B$N$h$&$JO"B3$7$?CM$rF~$l$k!#(B
  • =A1,=A2,=A3 $B$N$h$&$JO"B3$7$?;2>H$rF~$l$k!#(B $BAjBP;2>H$H@dBP;2>H$GF0:n$,$I$N$h$&$KJQ2=$9$k$+D4$Y$J$5$$!#(B

    $B!zN}=,LdBj(B(1510) $B4X?t!";2>H!"%0%i%U(B

    $B
  • ~yas/public_html/htdocs/coins/literacy-2014/2014-06-06/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-2014/2014-06-06/exam-result.xlsx . [$B
  • [web] $B$3$N%U%!%$%k$KBP$7$F!"
  • D$BNs$K!"%l%]!<%H$NF@E@$r(B 0.6 $BG\$7$?%G!<%?$rCV$/!#Nc(B: =B11*0.6
  • E$BNs$K!";n83$NF@E@$r(B 0.4 $BG\$7$?%G!<%?$rCV$/!#Nc(B: =C11*0.4
  • F$BNs$K!"(BD$BNs$H(BE$BNs$NOB$rCV$/!#Nc(B: =D11+E11$B!#(B
  • G$BNs$K!"@.@S(BS,A~D$B$rCV$/!#(B90$BE@0J>e$O(BS$B!"(B80$BE@0J>e$O(BA$B!"(B70$BE@0J>e$O(BB$B!"(B60$BE@0J>e$O(BC$B!"$=$l0J30$O(BD$B$H$9$k!#(B $BNc(B: =if(F11>=90,"S",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(BD12:G12$B$+$i(BD50:G50$B$^$G(B $B$K9-$2$k!#%*!<%H%U%#%k$N5!G=$G$O$J$/!"%3%T!J}$G$-$k$h$&$KN}=,$9$k$HNI$$!#!K(B
  • 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)
  • H4:H8 $B$K!"$=$l$>$l(B S $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 $BNc(B: =countif(G$11:G$50,"S") $B@.@S$N?M?t$+$i Excel $B$G:n@.$7$?K@%0%i%U!

    $B4pK\E*$J%0%i%U$rA^F~$9$k!#(B

    1. H4:H8 $B$N%;%k$r!"%I%i%C%0$7$FA*Br$9$k(B
    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!V%0%i%U!W$rI=<($9$k!#(B
    3. $B!V=DK@!W$NCf$N!V(B2-D$B=DK@!W!d!V=89g=DK@!W$rA*$V!#(B

    X$B<4(B($B9`L\<4(B)$B$r@_Dj$9$k(B

    1. $B%0%i%U$r%/%j%C%/$7$FA*Br$9$k(B
    2. $B!V%0%i%U!W%a%K%e!<$+$i!V%0%i%U%G!<%?$NA*Br!W$rA*$V(B
    3. $B!V(BX/$B9`L\<4$N%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!"@.@S$NL>A0(B(G4:G8) $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

    $B%0%i%U$K%?%$%H%k$rIU$1$k!#(B

    1. $B%0%i%U$r%/%j%C%/$7$FA*Br$9$k(B
    2. $B%j%\%s$N!V%0%i%U!W$r3+$-!"$=$N1&$N!V%0%i%U%l%$%"%&%H!W$r%/%j%C%/$7$F(B $BI=<($9$k!#(B
    3. $B!V%0%i%U%?%$%H%k"'!W$+$i!"!V%?%$%H%k$r%0%i%U$N>e$KI=<(!W$rA*$V!#(B $B%0%i%UFb$N!V%0%i%U(B $B%?%$%H%k!W$NItJ,$r(B $B!V@.@S$NJ,I[!W$HF~$l$k(B
    4. $BF1MM$K!"!V<4%i%Y%k"'!W$+$i!V2#<4%i%Y%k!W!d!V<4%i%Y%k$r<4$N2<$KG[CV!W(B $B$rA*$V!#!V<4%i%Y%k!W$K!V@.@S!W$HF~$l$k!#(B
    5. $BF1MM$K!"!V<4%i%Y%k"'!W$+$i!V=D<4%i%Y%k!W!d!V<4%i%Y%k$r2sE>!W(B $B$rA*$V!#!V<4%i%Y%k!W$K!V?M?t!W$HF~$l$k!#(B

    $B!zN}=,LdBj(B(1511) $B%0%i%U$ND4@0(B

    $B
  • $BK^Nc(B($B!V7ONs#1!W(B)$B$NI=<($r$J$/$9!#(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!V1F!W$r>C$9!#(B
  • $B%?%$%H%k$d<4%i%Y%k$N%U%)%s%H$rJQ$($k!#(B
  • $B%0%i%U%(%j%"$N30B&$N@~$r$J$/$9!#(B

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

    $B
  • ~yas/public_html/htdocs/coins/literacy-2014/2014-06-06/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%G%#%l%/%H%j$rA*$V(B
    • $B!VA*BrBP>](B:$B!W$H$7$F!V$9$Y$F$N%U%!%$%k!W$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 .xlsx)$B$GJ]B8$7$J$5$$!#(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!V%0%i%U!W$rI=<($9$k!#(B
    3. $B%0%i%U$N X$B<4$N@_Dj(B
      1. $B!V%0%i%U!W%a%K%e!<$+$i!"!V%0%i%U%G!<%?!W$rA*Br$9$k!#(B
      2. $B!V(BX/$B9`L\<4$N%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
      3. $B%o!<%/%7!<%H$NCf$G!"7n$N%G!<%?(B(A6:A17) $B$r%I%i%C%0$7$FA*Br$9$k(B
      4. $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
      5. $B!V(BOK$B!W%\%?%s$r2!$9(B
      $B7ONs$N=gHV$rF~$lBX$($k(B
      1. $B!VF|:G9b!W$N%0%i%U$rA*Br$9$k!#(B $B%0%i%U$N@~$NItJ,$r%/%j%C%/$9$k!#(B $B$"$k$$$O!"(B $B%^%&%9%+!<%=%k$rF0$+$7!"!V7ONs(B $BF|:G9b(B ...$B!W$HI=<($5$l$?$i%/%j%C%/$9$k!#(B
      2. $B!V=q<0!W%a%K%e!<$+$i!V7ONs(B...$B!W$rA*Br$9$k!#(B $B$"$k$$$O!"(B $B%3%s%F%-%9%H%a%K%e! $B!V=g=x!W%?%V$rA*Br(B
      3. $B1&B&$N!V>e$X0\F0!W%\%?%s$H!V2<$X0\F0!W%\%?%s$GJQ99$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
    4. $B<4$NL\@9$N4V3V$rD4@0$9$k(B $B!V2#<4$H$N8rE@!W$rD4@0$9$k(B($B%A%'%C%/$r$O$:$9(B)$B!#(B
    5. $B7ONs$N=q<0$G!"@~$NB@$5!"%^!<%+!<$NBg$-$5!"?'!"1F$rD4@0$9$k(B
    6. $BK^Nc$N0LCV$rD4@0$9$k(B
    7. $BA4BN$NBg$-$5$HJ8;z$NBg$-$5$N%P%i%s%9$rD4@0$9$k(B
    8. $B30B&$NOH$r>C$9(B

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

      $BN}=,LdBj(B(1512) $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-2014/2014-06-06/tsukuba-weather-2013.txt
      • [web]

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

      LibreOffice $B$N(B Calc ($BI=7W;;%I%-%e%a%s%H(B) $B$r$ /Applications/LibreOffice.app [$B $B
    9. Excel $B%V%C%/(B( .xlsx, .xls )
    10. CSV $B%U%!%$%k(B
    11. $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(1515) $B%F%-%9%H$NFI$_9~$_(B($B8GDjD9%U%#!<%k%I(B)

      ls -l $B%3%^%s%I$N7k2L$K$D$$$F!"
    12. ls -l $B$N7k2L$r%U%!%$%k$KJ]B8$7$J$5$$!#(B
    13. $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
    14. $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
    15. $B%U%!%$%k$NBg$-$5$N=g$KJB$YBX$($J$5$$!#(B
    16. $B%U%!%$%k$N%P%$%H?t$N9g7W$r7W;;$7$J$5$$!#(B $BJ8;z%3!<%I$NLdBj$,$"$l$P!"(B nkf (network kanji finter) $B$d(B Emacs set-buffer-file-coding-system $BEy$GJQ49$7$J$5$$!#(B

      $B!zN}=,LdBj(B(1516) 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(1517) $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(1518) $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(1519) $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(1520) $B%;%k$N7k9g(B

      $BJ#?t$N%;%k$r7k9g$7$F$_$J$5$$!#(B
      • $B7k9g$7$?$$%;%k$rA*Br$7!"(B $B!V=q<0!W!d!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(1521) $B=q<0(B

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

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

      $B
    21. $B$"$k%;%k$K(B 1 $B$HBG$A9~$`!#(B
    22. $B$=$N2<$N%;%k$K(B $B>e$N%;%k$r(B 2 $BG\$7$?CM$r<0$GF~$l$k!#(B
    23. $B$=$N2<$N%;%k$K(B 2. $B$r%3%T!<$9$k!#(B
    $B%;%k$K
  • =0.3-0.2-0.1+0 $B$=$N7k2L$r9M;!$7$J$5$$!#(B $B%(%/%;(B $B%k!V1i;;8m:9!WBP:v9V:B(B$B;2>H!#(B

    $B!zN}=,LdBj(B(1523) 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(1524) 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"#2]Bj(B15 $BI=7W;;!"%0%i%U$N:n@.(B

    • $B:#F|$N2]Bj$G$O!"(B(1) $B$H(B (4) [$B2CE@(B] $B$N7k2L$r!"(BTA $B$KDs<($7!"3NG'HV9f$r

    (1) $BN}=,LdBj(B(1510) $B$r9T$$$J$5$$!#(B $B7k2L$r(B TA $B$K<($7!"3NG'HV9f$r

    (2) The Unix Super Text $B$N

  • $B>e4,(B26.1 $B@a!"(B26.5$B@a(B $B
  • 26.1$B@a$G=R$Y$i$l$F$$$k!V%M%C%H%o!<%/%K%e!<%9!W$H0lHLE*$J0UL#$G$N%M%C(B $B%H%o!<%/%K%e!<%9$N0c$$(B
  • $B5-;v(B
  • $B%K%e!<%9%0%k!<%W$GLZ9=B$$,;H$o$l$F$$$kM}M3(B
  • NNTPSERVER
  • $B%3%s%T%e!<%?4X78$N%K%e!<%9%0%k!<%W$N%H%C%W%I%a%$%s(B
  • Subject $B$,Bg;v$G$"$kM}M3(B
  • $B%M%C%H%o!<%/%K%e!<%9$GK\L>$r;H$&=,47$,$"$kM}M3(B

    (3) The Unix Super Text $B$N

  • $B>e4,(B $BBh(B11.3,11.4,11.7$B@a!"Bh(B40.1-40.3$B@a(B $B
  • sh(bash)$B$G%7%'%kJQ?t$KCM$rBeF~$9$kJ}K!(B
  • sh(bash)$B$G%7%'%kJQ?t$NCM$r;2>H$9$kJ}K!(B
  • sh(bash)$B$G%/%)!<%H!V(B' '$B!W$NF/$-(B
  • sh(bash)$B$G%@%V%k%/%)!<%H!V(B" "$B!W$NF/$-(B
  • (tcsh,bash$B6&DL(B)history $B%3%^%s%I(B

    (4) [$B2CE@(B]$B!!(B $BN}=,LdBj(B(1512) $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(1516) $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

    (5) $B

    (5a) [$B2CE@(B] gnuplot $B$r;H$C$F!"(BExcel $B$G:n@.$7$?$b$N$HN`;w$N%0%i%U$r:n@.(B $B$7$J$5$$!#:n@.$7$?%0%i%U$r!"%o!<%I%W%m%;%C%5!"$^$?$O!"(BLaTeX $BJ8=q$K?^$H(B $B$7$F$l$NMxE@$HLdBjE@$r=R$Y$J$5$$!#(B $B$$!#(B

    (5b) [$B2CE@(B] LibreOffice $B$r;H$C$F!"(BExcel $B$G:n@.$7$?$b$N$HN`;w$N%0%i%U$r(B $B:n@.$7$J$5$$!#:n@.$7$?%0%i%U$r!"%o!<%I%W%m%;%C%5!"$^$?$O!"(BLaTeX $BJ8=q$K(B $B?^$H$7$F(B $B$l$NMxE@$HLdBjE@$r=R$Y$J$5$$!#(B

    Last updated: 2014/06/06 11:26:41
    Yasushi Shinjo / <yas@cs.tsukuba.ac.jp>