管理信息系統(tǒng) 實(shí)驗(yàn)報(bào)告

1、2013管理信息系統(tǒng)實(shí)驗(yàn)報(bào)告工商1001 張高陽 20100381目錄 TOC o 1-3 h z u HYPERLINK l _Toc345525323 Lab Report 1 PAGEREF _Toc345525323 h 1 HYPERLINK l _Toc345525324 PHASE 1 PAGEREF _Toc345525324 h 1 HYPERLINK l _Toc345525325 PHASE 2 PAGEREF _Toc345525325 h 1 HYPERLINK l _Toc345525326 PHASE 3 PAGEREF _Toc345525326 h 2 HYP

2、ERLINK l _Toc345525327 PHASE 4 PAGEREF _Toc345525327 h 2 HYPERLINK l _Toc345525328 PHASE 5 PAGEREF _Toc345525328 h 3 HYPERLINK l _Toc345525329 PHASE 6 PAGEREF _Toc345525329 h 4 HYPERLINK l _Toc345525330 Lab Report 2 PAGEREF _Toc345525330 h 5 HYPERLINK l _Toc345525331 PHASE 1 PAGEREF _Toc345525331 h

3、5 HYPERLINK l _Toc345525332 PHASE 2 PAGEREF _Toc345525332 h 6 HYPERLINK l _Toc345525333 PHASE 3 PAGEREF _Toc345525333 h 7 HYPERLINK l _Toc345525334 PHASE 4 PAGEREF _Toc345525334 h 11 HYPERLINK l _Toc345525335 PHASE 5 PAGEREF _Toc345525335 h 11 HYPERLINK l _Toc345525336 Lab Report 3 PAGEREF _Toc34552

4、5336 h 13 HYPERLINK l _Toc345525337 1WHAT PRODUCTION PROBLEMS DO YOU HAVE? PAGEREF _Toc345525337 h 13 HYPERLINK l _Toc345525338 2EVALUATING TOTAL PURCHASES AND ANNUAL INCOME? PAGEREF _Toc345525338 h 16 HYPERLINK l _Toc345525339 3. FINDING OUR INFORMATION ABOUT YOUR EMPLOYEES. PAGEREF _Toc345525339 h

5、 18 HYPERLINK l _Toc345525340 4.EXPLORING INFORMATION AT B&B TRAVEL. PAGEREF _Toc345525340 h 21 HYPERLINK l _Toc345525341 Lab Report 4 PAGEREF _Toc345525341 h 23 HYPERLINK l _Toc345525342 1.Automating Repetitive Tasks. PAGEREF _Toc345525342 h 23 HYPERLINK l _Toc345525343 2.Calculate Tax Values. PAGE

6、REF _Toc345525343 h 23 HYPERLINK l _Toc345525344 3.Determine Shipping Charges. PAGEREF _Toc345525344 h 25 HYPERLINK l _Toc345525345 4.Assess the Letter Grade. PAGEREF _Toc345525345 h 25Lab Report 1PHASE 1EntityPrimaryStudentStudent numberTeacherTeacher numberSeminarSeminar kindSeminar sectionSeminar

7、 namePHASE 2selectcomposeTeachPHASE 3PHASE 4PHASE 5Seminar RelationSeminar kinddetailPartWeb101The Basics of the Web and Internet5Web105Building a Web Site4Seminar Section RelationSeminar nameSeminar kindTeacher numberWeb101-1Web1010001Web101-2Web1010001Web101-3Web1010001Web101-4Web1010002Web101-5We

8、b1010002Web105-1Web1050003Web105-2Web1050004Web105-3Web1050005Web105-4Web1050005Student RelationStudent numberStudent nameSex0001JackMale0002RoseFemale0003JamesMale0004KobeMaleTeacher RelationTeacher numberTeacher nameSex0001SparrowMale0002SarahFemale0003TomMale0004ConnorMale0005PenyFemale0006WestMa

9、leScore RelationStudent numberSeminar nameScore0001Web101-1890001Web102-1790002Web101-5690003Web102-359PHASE 6Lab Report 2PHASE 1添加員工信息利用向?qū)?chuàng)建窗體：使用砂巖樣式：生成窗體：PHASE 2創(chuàng)建查詢，添加排序PHASE 3建立查詢使用向?qū)?chuàng)建報(bào)表確定分組級(jí)別確定排序和匯總字段在設(shè)計(jì)視圖中去除對(duì)Raw Material Name的頁眉和頁腳更改對(duì)Unit求和的公式，將控件來源的=Sum(Unit)改為=Sum(Unit*Amount)然后，一張滾燙的新鮮報(bào)表就出

10、爐啦PHASE 4創(chuàng)建查詢，設(shè)定排序PHASE 5選定篩選內(nèi)容應(yīng)用篩選取消篩選Lab Report 31WHAT PRODUCTION PROBLEMS DO YOU HAVE?首先將記錄按照某一字段排列，然后分類匯總，算出分類次品率：制作成圖表：然后修改篩選字段，重新排列記錄，再次匯總：繪制次品率與機(jī)器關(guān)系的圖標(biāo)：重復(fù)上述操作，繪制次品率與員工，與產(chǎn)量關(guān)系的圖標(biāo)：由以上四張圖標(biāo)分析可知：10號(hào)產(chǎn)品次品率最低，20號(hào)產(chǎn)品最高，但是三種產(chǎn)品之間無明顯差別。5號(hào)機(jī)器的次品率最高，其它三臺(tái)機(jī)器無明顯差別。3333號(hào)員工生產(chǎn)的產(chǎn)品次品率最低，其它四人無明顯差別。次品率在單批產(chǎn)量為500是達(dá)到了單批產(chǎn)量

11、10000時(shí)的10倍多。切次品率隨產(chǎn)量上升呈明顯下降趨勢。建議：擴(kuò)大生產(chǎn)規(guī)模，提高單次生產(chǎn)產(chǎn)量，減少生產(chǎn)批次。2EVALUATING TOTAL PURCHASES AND ANNUAL INCOME?建立數(shù)據(jù)透視表，將ANNUAL INCOME作為行標(biāo)簽，數(shù)據(jù)作為列標(biāo)簽，求和和求平均兩列：我們看到在平均購買額里，年收入100K+的人反而不高，而年收入在25K-50K的人最低。如果我是決策者，應(yīng)該集中精力去吸引年收入100K+的顧客。因?yàn)槠湄S厚的收入和仍然較低的消費(fèi)說明這個(gè)群體還有提升消費(fèi)的空間。消費(fèi)總額和年齡的關(guān)系，和地區(qū)的關(guān)系或者是和房子數(shù)量的關(guān)系。要獲得這些數(shù)據(jù)，我們要從把原始數(shù)據(jù)表的數(shù)

12、據(jù)導(dǎo)入數(shù)據(jù)透視表，以觀測字段作為行標(biāo)簽，以TOTAL PURCHASES的求和或者平均數(shù)作為列，進(jìn)行相關(guān)分析。3. FINDING OUR INFORMATION ABOUT YOUR EMPLOYEES. a pivot table that shows average salary by gender within department. a pivot table that shows the number of employees by clearance. conditional formatting to highlight those employees in the Engin

13、eering department. conditional formatting to highlight those employees who have no clearance(none). basic Filter to show only those employees who have top secret clearance(TS). Custom Filter to show only those employees who earn more than $50,000.4.EXPLORING INFORMATION AT B&B TRAVEL.Which, if any,

14、location should be closed?創(chuàng)建數(shù)據(jù)透視窗口和數(shù)據(jù)透視圖：由圖可知，應(yīng)該關(guān)閉23號(hào)交易點(diǎn)。Which, if any, travel consultants should be downsized?創(chuàng)建數(shù)據(jù)透視窗口和數(shù)據(jù)透視圖：由圖可知，應(yīng)該裁掉701號(hào)交易員。On which cruise lines should B&B focus its sales efforts?創(chuàng)建數(shù)據(jù)透視窗口和數(shù)據(jù)透視圖：由圖可知，Equatorial Easy航線交易量和利潤還很低，可以著重發(fā)展。Lab Report 4Automating Repetitive Tasks.打開宏錄制：輸入一到六個(gè)月：結(jié)束宏錄制，在sheet2執(zhí)行宏，在sheet3用ctrl+shift+M執(zhí)行宏。Calculate Tax Values.打開visual basic，輸入代碼：在單元格中使用函數(shù)：拖動(dòng)完成計(jì)算：Determine Shipping Charges.新建啟用宏的excel工作簿，打開visual basic，在sheet1中添加模塊，輸入代碼：Assess the Letter G