計(jì)算機(jī)基礎(chǔ)中的計(jì)算數(shù)據(jù)和表格第一章信息與計(jì)算機(jī)基礎(chǔ)知識(shí)【例1-3-4】將(26)10轉(zhuǎn)換成二進(jìn)制數(shù)。所以，(26)10=(11010)2?！纠?-3-5】將(0.78125)10轉(zhuǎn)換成二進(jìn)制數(shù)。純小數(shù)乘以2乘積后的純小數(shù)部分乘積后的整數(shù)部分0.78125×20.56250 10.5625×20.125 10.125×20.25 00.25×20.5 00.5×20.0 1則(0.78125)10=(0.K-1K-2K-3K-4K-5)2=(0.11001)2。如果十進(jìn)制小數(shù)在轉(zhuǎn)換時(shí)，乘積取整不為0或產(chǎn)生循環(huán)，那么只要保留所要求的精度即可?！纠?-3-6】將(26.78125)10轉(zhuǎn)換為二進(jìn)制數(shù)。因?yàn)?26)10=(11010)2，(0.78125)10=(0.11001)2所以(26.78125)10=(11010.11001)2【例1-3-7】將(139)10轉(zhuǎn)換成八進(jìn)制數(shù)。所以(139)10=(213)8【例1-3-8】將(0.425)10轉(zhuǎn)換成八進(jìn)制數(shù)。純小數(shù)乘以8乘積后的純小數(shù)部分乘積后的整數(shù)部分0.425×8 0.400 30.400×8 0.200 30.200×8 0.600 10.600×8 0.800 40.800×8 0.400 6如果取5位小數(shù)能滿足精度要求，則得(0.425)10≈(0.33146)8?！纠?-3-9】把(1101001)2轉(zhuǎn)換成八進(jìn)制數(shù)。因?yàn)椋?001101001)2↓↓↓(151)8所以，(1101001)2=(151)8【例1-3-10】把二進(jìn)制小數(shù)(0.0100111)2轉(zhuǎn)換成八進(jìn)制小數(shù)。因?yàn)椋?0.010011100)2↓↓↓(0.234)8所以，(0.0100111)2=(0.234)8【例1-3-11】把(101101101.0100101)2轉(zhuǎn)換成十六進(jìn)制數(shù)。因?yàn)椋?000101101101.01001010)2↓↓↓↓↓(16D.4A)16所以，(101101101.0100101)2=(16D.4A)16【例1-3-12】把八進(jìn)制數(shù)(643.503)8轉(zhuǎn)換成二進(jìn)制數(shù)。因?yàn)椋?643.503)8↓↓↓↓↓↓(110100011.101000011)2所以，(643.503)8=(110100011.101000011)2【例1-3-13】將(1863.5B)16轉(zhuǎn)換成二進(jìn)制數(shù)。因?yàn)椋?1863.5B)16↓↓↓↓↓↓(0001100001100011.01011011)2所以，(1863.5B)16=(1100001100011.01011011)2第四章Excel2016表格處理軟件圖4-2-3、圖4-2-4、圖4-4-2、圖4-4-3、圖4-4-5、圖4-4-6對(duì)應(yīng)的表編號(hào)姓名性別年齡測(cè)試值1測(cè)試值2測(cè)試值3分?jǐn)?shù)1分?jǐn)?shù)2分?jǐn)?shù)3分?jǐn)?shù)4分?jǐn)?shù)5分?jǐn)?shù)62016060林榮海男23ftt4504506425003422452016061陳梅雅女23ftt4506426234502343422016062杜明世男23ftt4005345674505345232016063黃俊虹女24fft4506426234005345672016064李晨曉男23fft4505345234506426232016065王錦宏女22ttf4506426234505345232016066沈瑩瑩女23fff4505345235003422452016067謝師暉男23ftf5003422454505345232016080李嘉欣男24ttf4003872875003422452016081邱振霖男22fff4503962564003872872016082許文宇男23ftf4506426234505345232016083林成友男24ftt45053452350034224520160596高海君女23ftt40053456750034526720160601姚樂(lè)佳男23fft45064262345064262320160603許婉瓊女23fft45053452345053452320160605游昌達(dá)男22ttf50034224550034224520160608郭曉云女22fff50034526750034526720160611許毅煌男24ftf40038728740038728720160614廖偉保男23fff45039625645039625620160618陳振宇男23ftt45034224550034224520160620黃雅貞女23ttt500345267400387287圖4-5-4、圖4-5-5對(duì)應(yīng)的表生產(chǎn)零件1生產(chǎn)零件2生產(chǎn)零件3生產(chǎn)零件4生產(chǎn)零件5生產(chǎn)零件6每組生產(chǎn)總和檢測(cè)獎(jiǎng)勵(lì)等級(jí)第一組304030102030160合格二等獎(jiǎng)第二組503040203040210合格一等獎(jiǎng)第三組102020304050170合格二等獎(jiǎng)第四組102030304030160合格二等獎(jiǎng)平均生產(chǎn)量2527．53022.532.537.5175圖4-6-6、圖4-6-8、圖4-6-10對(duì)應(yīng)的表職工生產(chǎn)零件數(shù)量統(tǒng)計(jì)表姓名性別零件A零件B零件C零件總和貝懷遠(yuǎn)男30193079蔡昌達(dá)男353040105蔡瑩宇女30191968陳坤錦女304030100陳梅雅女363040106陳清滿男40203090高海陽(yáng)男304030100郭云曉女373040107李婉瓊女19384097林乃偉男403040110歐洪峰男30353095王煒佳女304037107圖4-6-11、圖4-6-12、圖4-6-14、圖4-6-15對(duì)應(yīng)的表公司產(chǎn)品銷售表產(chǎn)品編號(hào)第一季度第二季度第三季度第四季度全年銷售合計(jì)全年銷售額是否大于均值A(chǔ)12330374046153FALSEB17843485257200TRUEA18533353738143FALSEB10132353739143FALSEA18741434345172TRUEB19833353637141FALSEB14532353940146FALSE第七章數(shù)據(jù)庫(kù)基礎(chǔ)與Access2016表7-4-1員工的基本信息編號(hào)姓名性別出生日期專業(yè)電話06008黃忠杰男1993.02.18財(cái)會(huì)1361234567802012吳小薇女1994.08.30自動(dòng)化1371234567802078呂紅婷女1993.09.15計(jì)算機(jī)1301234567808098苗衛(wèi)華男1992.11.18外貿(mào)1391234567808011鐘平安男1993.05.07英語(yǔ)1351234567806005葛斯淼男1994.11.11漢語(yǔ)言文學(xué)1331234567806007馬淑雅女1992.07.27工商管理1381234567801001李麗芬女1992.07.24機(jī)械工7-4-1、圖7-4-4對(duì)應(yīng)的表學(xué)號(hào)姓名性別出生日期籍貫黨員否入學(xué)成績(jī)附加分班級(jí)編號(hào)050202104李逵源男1986/3/3寧波431300502021050202105倪越利男1986/2/15杭州423400502021050202106鄭峰男1985/6/18舟山457250502021050204132王海男1985/11/30寧海460350502041050202114蔣微女1987/6/28象山508250502021050202101徐海波男1987/2/14余杭555100502021050201109雷湘筱女1988/1027寧波500120606011050204102寧兵兵男1987/4/25上海448180606041050204208李明慧女1988/3/1杭州452160606042050204219張?zhí)旄Ｄ?987/11/28寧波439220606042050204222應(yīng)俊立男1988/1/29紹興420200606042050204225吳哲男1986/12/12杭州469300606042070301101張守華男1988/11/11寧波499160703011070301102林秨齡女1989/11/28蕭山509200703011070601105楊笑月女1989/1/31寧波511150703011070601111苗易女1988/5/4杭州469150703011070601124唐曉慶男1988/10/2寧波423100703011070604126林琴琴女1988/5/4紹興492400706041070604222朱錦華男1988/5/6杭州485300706042開(kāi)課序號(hào)課程名稱學(xué)時(shí)數(shù)學(xué)分?jǐn)?shù)考試否0626050數(shù)據(jù)庫(kù)原理及應(yīng)用644Yes0670009高等數(shù)學(xué)1644Yes0690051計(jì)算機(jī)科學(xué)導(dǎo)論483No0690252大學(xué)物理1483No1075201Matlab程序設(shè)計(jì)483No編號(hào)學(xué)號(hào)開(kāi)課序號(hào)教師編號(hào)成績(jī)1070604222069025206005587206060410206060500600737330606042080606050060073684060604219060605006007392506060422506060500600739360706042220670009060009767050604132062605006002465807060412606900510600247090606042220626050060073801007060