_计算机操作系统_试题库系统的设计与实现.doc
第9卷第2期2007年6月防 灾 科 技 学 院 学 报J.of Institute of Disaster-Prevention Science and TechnologyVol.9 No.2Jun. 2007?计算机操作系统?试题库系统的设计与实现任占营 1杜启军 1刘海明 2刘士杰 11 华北科技学院，河北三河 101601；2 博彦科技(北京)，北京 100094摘 要：根据现代教育理念与技术的要求，结合?计算机操作系统?课程的教学实际，应用 VB 6.0 编程语言和 SQL Server 2000 数据库，开发了?计算机操作系统?试题库系统，实现教考别离，解决了人工出题的随 机性。本文介绍了试题库的功能设计、数据库表设计、自动抽题策略、Word 试卷组成等技术，具有很强的通 用性和可操作性。关键词：试题库；系统设计；自动组卷中图分类号：TP23文献标识码：A文章编号：1673-8047(2007) 02-0092-03The Design & Realization of Test Questions Database System for ComputerOperating SystemRen Zhanying1 Du Qijun1 Liu Haiming2 Liu Shijie1(1 North China Institute of Science & Technology, Sanhe, Hebei 101601; 2 BoYan Co. Ltd. Beijing 100094) Abstract: According to the requirement of modern teaching concept and technology, combined with the actual teaching conditions of Operating System, making use of the VB 6.0 and SQL Server 2000, a testing questions database system was designed and realized. The system benefits for dividing of testing & teaching and settles the problems of random testing papers. In this paper, some key techniques, such as system function designing, the database table designing, making-up strategy, Word-paper etc. are introduced, and they have very strong general use and maneuverability.Key Words: test questions database; system design; automatically making paper前言$¼%P,$%fi$fihQRf$%Ko$¼ø%;$% A,h%Do%fi,$¾ $¼oy¾ $%,fl$, ¾:%R½$¼%$ ,$¼¼%,%$¼% QR%:¼¼%$,%Q%, !%o$¾ufiv ¼÷ffi%,fi$,$,Word $,$%½½o1系统功能分析与设计¼fi¾%$p$,¾%fi,¾,Q%o%fi,f%¢%fi1o¾%½,¾%¾½,%¢½,%fi¾%½,¾%$,ufivfifi%K½ 1o13:fi, Word ,%oy½fi$fi作者简介：K¢(19tt),T,KfiflQ,fiI¼%Io收稿日期：²00a10²0,NÇ,%þ%:fl%y Word %,110 $,¼%Q%$¾,AJ %fi:%,½%,y$%fio23:yfi%,$%fiP,½øfi,%,$¢,$¾%fiP, fi$¿ 6 ,%:½¼,fi½¼,/,/¼fi:%¾$ A,B,C,D ¶¾, fi$f,¼,¶¾%:%½fi%K Word fl½%o33:y½fiªø%,fi$IA%fi ªø,½fi%½½,fi$%,fi%fifi $,$½¾,$I¾fi: y$¼%øfi¾,fi%f D,%¼%øfi¾,h%¼%AC$A3fi¾,%½½$ ¼A:y½%,fl øCA3$%fiC3,%C¾3,$%o图 1 计算机操作系统试题库系统功能结构图表 1 试题结构表2数据库表设计fifi$%$,Ø$% “·%fi·%fi·%¼,$fi¼$%fi¼ffi(E-R )¾¿$,%,f¾%fifi¾%,%¼,%2o$fi%$K$ $,øfi$,$,fi$o$½$ 1 $ 2o%¼y ¼ % () øfi ¢ $¾%¾ optid(K%)numericC6,03××××××1chapterdselectid qname answer rankidremarkvarcharnumeric varchar varchar varchartext2(2,0)200020001%¼fi fi½¼½¼$¼ªøfi$fi/<fi>fififi防灾科技学院学报第 9 卷· 94 ·% 193 ½y,®:Documents ¾½ Document ½$fl%:Paragraphs ¾½ ,Paragraph ½,ParagraphFormat ½ %$½¿¼,½¿$%K¼¼¼%$fi3o$fi$% Word %fi¾®f:QuestionLeiBie = QuestionLeiBie + 1QuestionNumber = RST.RecordCountQuestionMark = RST.Fields("everymark").Value TX = QuestionLeiBie & "." & TX & "(" & QuestionNumber & "×" & QuestionMark & "/=" & QuestionNumber * QuestionMark & ")" &表 2 试卷结构表y ¼ %¼ chapter_idselectid rankidtimuNumvarcharnumeric varcharint2(2,0)14××××øfi%¾everymarkint4×%1 remarktext3抽题策略的实现fi$½,fl ½¾,¾¿$%,$%$A,$A%$%¾þ$%o½ 2o'%Chr(13)TempStr = TempStr & TXTempAnswer = TempAnswer & TX QuestionNumber = 0With RST'Do While Not .EOFQuestionNumber = QuestionNumber + 1TempStr = TempStr & QuestionNumber & "."& .Fields("qname").ValueTempAnswer=TempAnswer&QuestionNumber & "." & .Fields("noranswer").Value& Chr(13).MoveNextLoopEnd With wdRange.SetRange wdRange.Paragraphs(wdRange.Paragraphs.Coun t).Range.Start, _ wdRange.Paragraphs.Item(wdRange.Paragraphs.图 2 试卷结构设置y,fi¾P¼fiofi$þfi,½$¾fi,½$þfi%ø,%¾%,½¼fi Recordset¾$,fiR%Ǿ ,¾oCount).Range.EndWith wdRange'P'4Word 试卷的制作fi% Word %fi$,fl Word %oWord 2000 % VBA fi%f$%,Word 2000 $¾$ 193 ½,$¾% Application ½,yfi$ Word 2000 ¼fi,% VBA Word 2000¼fi%:Word 2000 ¼fi$.InsertAfter TempStr.Font.Name = "$".Font.Size = 12.ParagraphFormat.Alignment =wdAlignParagraphLeftEnd With wdDoc.Save wdDoc.Close(fø 125 ½)3.4 利用多媒体直观教学观摩$%¼½,¼$Ç%$¼,f%K,% VCD fiy,R,$Q%R%¼o½%¾,fiK %R%5o3.± 鼓励学生参加等级裁判员考核%¾f,¿R¾¾$,QR%,pØo f¾fiþ,fl ,½¾%$½Q%o¾I%K,Ko¼$¼%fi,$¼%,¾$fiR¢K%flI,Kfi,f÷%Qf$%o%¼,¼%¼%, %p¾,fi% o%,¢fi%¾f,¾,fiy,$K$¼o参考文献1 $¾.p(²003)M.fl:$ $½,²003² .½.I¼,²00±(10):90913 ø.½$%½. yÇ,²003(4):1±1t4 $¾.$¶(1998²00²)M.fl:$½,1999± ,K½.½øÇ!R% .ff! ²003(9):11±11a结束语L¼,QfR%,R%¢¼f, %flf%,¾fiR%,fi$LI,L,½$%o%øK%I,flIfiPøI,¼%Kø,ؾ,(Lø 94 ½)结束语ufiv$fi%, þf¼¾,¼¼$%¼%¼,$¾%,f½%¾,Q%½,%o$fi$%½,¾fi%¢,½¼¼¾ ,$%fo参考文献1 K¢,T. ¾%$fi . ½fl,²00±,²(4):98100² K¢,Kþ$. $¾Rfifi%flQ. fi,²001(3):a0a33 K¢,¼ . Word ²000 $% *BA flQ.½fl,²003,±(²):a1a²
