还剩7页未读，继续阅读
文本内容:
The ExperimentaI SyI IabusofFundamentals ofComputer AppIicationI.An overviewof thecourseCourse Code:19110243Course Name:Fundamentals ofComputer ApplicationCourseCategory:general coursescompulsoryClass hours:48experimental classhours:24Credit points:3Suitable students:all collegestudents ofnon-computer majorAssessmentmethod:examinationPrerequisite courses:noneII.The generalpurpose and requirements ofexperimental teaching
1.Requirements forStudents:1The experimentalcontent mustbe previewedbefore eachexperiment,and thecorrespondingexperimental previewreport mustbe completed.2For eachexperiment,the laboratoryinstruction,storage equipmentfor theexperimentand otherrelevant documentsshall bebrought along.3Must enter the laboratory on time.Those whoare latefor5minutes willnotbe admittedto the laboratory,and the experimental classwill bepunished asbeingabsent fromclass.4If youneed toask forleave forsome reason,you mustpresent thevalid requestforleave tothe teacheraccording tothe requirementsof theschool,and itis invalidif you submitit later.5Obey thearrangement of the experimental instructor and take theseatsaccording tothe serialnumber”.If the machine needsto beadjusted forany reason,the consentof the experimentalinstructorshall beobtained.6Please raiseyour handifyouhave anyquestions onthe computer.Studentscan discusswith eachother withoutmaking anoise.7During theexperiment,you are not allowed to do anything unrelatedto theexperiment,and youarenotallowedtobring foodinto the laboratory.Once found,youwill bedriven out of thelaboratory afterbeing remindedinvalid.8After theend of theexperiment,shut downthemachine,put the keyboard standandseat inorder,andtakethe sundriessuch asthe tableoutof thelab.
2.Requirements forteachers:1Teachers shouldenterthelaboratoryontime andshould notbe latefor theexperimentalclass.2Students previewreports shouldbe checkedbefore theexperiment.Experimental operationis notallowed for students whodo notprepare carefullyordo notprepare atall.3In experimentalclass,teachers shouldguide studentscarefully andsolveproblems intime.54Carefully correctthe studentsexperiment reportsand makethe experimentscoresfaithfully.5Students arestrictly requiredto abideby the operating rules andexperimental rulesforstudents.Teachers havethe rightto stop the use of machinesandstoptheexperiments ifnecessary tothose whoviolate therulesand do notlistento advice.6Do notdoanythingirrelevant totheexperimentalcontent inthe laboratoryclass,anddonot leavethelaboratorywithout permission.III.Requirements forexperimental conditions:1Hardware requirements:Personal computers,internal LAN,the Internet.2Software requirements:Operating system:English Windows operating systemOfficesoftware:Office2010EnglishOther software:WinRarDiscuss thecomputer developmentall over the world.Thanks tothose pioneerswhomade outstandingcontributions tothe developmentof computer.3Experimental teachingcontentAccording tothe curriculumdesign and teaching requirements,this experimentsetup5experimental items,a totalof15special experimentalcontent,to trainstudentsin basiccomputer operation,word processing,spreadsheet application,presentation production,network applicationand otheraspects ofpracticalapplication ability.Experimental project1:Windows operating systemExperiment1:Basic Operationof WindowsExperimentcontents:Start andclose Windows,how touse keyboard and mouse,useof and English input method,punctuation mark,switch ofand Englishinputmethod.Experimental nature:public computerroomExperimental hours:3Experimental purposeand requirements:
1.Master thestartup andshutdown methods of Windows operatingsystem.
2.Understand andmaster theuse of thekeyboard.
3.Understand andmaster theuse of the mouse.
4.Master theand Englishinput methodsand theswitch ofand Englishinput methods.Experimental conditions:Installation of Windows operatingsystem isrequiredExperiment2:Windows Fileand FolderManagement.Setting upWindows system andusing commonapplication toolsExperimentcontent:basic operationof Windowswindow,basic operationof filesandfolders.Experimental properties:verification anddesignExperimental hours:3Experimental purposeand requirements:
1.Master the basic operationofWindows.
2.Master thebasic operationof thefile,including copying,moving,renaming,deleting,setting properties,etc.
3.Master thebasic operationof thefolder,including:establish,copy,move,delete,rename,attribute setting,etc.Research andThinking:What arethe domesticoperating systemsWhat isthe currentstate of
1.developmentWhat isthe biggestfunction of theoperatingsystem forordinary users
2.Experimental project2:word processingsoftwareExperiment3:The establishment,editing andtypesetting of Word documentsExperimental content:document creation,editing andmodification,page,character andparagraph formatting,use ofbullet andnumber,column segmentation,text searchand replacement.Experimental properties:verification anddesignExperimental hours:3Experimental purposeand requirements:
1.Master commonediting methods of documents.methods ofcharacters andparagraphs.
2.Master theformatting
3.Master theuse ofbullet pointsand numbers,setting of
4.Master thecolumn format.
5.Masterthe methods of findingand replacingwords.Experimental conditions:Windows operatingsystem andOffice suiteshould beinstalled.Experimentalcontent:table establishment,formatting Settings,Experimental properties:verification anddesignExperimental hours:3Experimental purposeand requirements:
1.Master severalcommon methodsof tableestablishment.Experiment4:Making Wordtable
3.Master theediting and formatting methodsof tables.Experimental conditions:Windows operatingsystem andOffice suiteshould beinstalled.Experiment5:Word graphicmixingExperimental content:clip art,pictures,artistic words,optional graphics,formula insertionand editing,graphic objectsand textbetween thesurrounding,overlapping relationshipSettings.Experimental properties:verification anddesign hours:3Experimental purposeand requirements:Experimental
1.Master theinsertion methodsof common graphics objects.
2.Master thebasic editing methodsof commongraphicsobjects.
3.Master the setting method of theposition relation of pictureand textandthe positionrelationofdiagram.Experimental conditions:Windows operatingsystem andOffice suiteshould beinstalled.Experiment6:Annotation,review andmail mergeof WorddocumentsExperimental content:document annotation,review andmail mergefunction.Experimental properties:verification anddesignExperimental hours:3Experimental purposeand requirements:
1.Master thebasic methodsof addingand editingannotations totexts.
2.Master commontext reviewtools.
3.Master theuse ofmail merge.Experimental conditions:Windows operatingsystem andOffice suiteshould beinstalled.Experiment7:Styles and the application of stylesheetsExperimental content:style,document structurediagram,automatic directorygeneration.Experimental properties:verification anddesignExperimental hours:3Experimental purposeand requirements:
1.Master themethod inthe outlineview.
2.Master themethod ofreading and editing documentsby usingdocument structurediagram.
3.Master theapplication methodsof styles.
4.Master thegeneration method ofthedirectory.Experimental conditions:Windows operatingsystem andOffice suiteshould beinstalled.Experiment8:Comprehensive Applicationof WordExperimentalcontent:comprehensive newspaperboard design,long documentediting.Experimental nature:comprehensiveExperimental hours:3Experimental purposeand requirements:Use thevarious functions ofWordto designthecomprehensive bulletinboardandedit thelong document.Experimental conditions:Windows operatingsystem andOffice suiteshould beinstalled.Research andThinking:
1.What isthe developmenthistory ofdomestic officesoftware Whydoes MicrosoftOfficedominate thedomestic marketTalk aboutyour viewfrom thehistory,presentsituation anddevelopment trend.
2.How torealize theautomatic generationofthecatalog and thesetting of thepageheader andfooter ofdifferent contentsof eachchapter inthe designof thegraduationthesis equallength documentExperimentalproject3:Excel2010Experiment9:Basic operation andformat settingof ExcelExperiment contents:establishment,saving andopening of Excel files,data input,naming,copying,moving,inserting,deleting,splitting andfreezing of worksheets,and formattingofworksheets.Experimental properties:verification anddesignExperimental hours:3Experimental purposeand requirements:
1.Master the creation,saving andopening ofExcel workbooks.
2.Master theinput methodsof variousdata.
3.Master thebasic operationsofExcelworksheets,including renaming,copying,moving,inserting anddeleting.
4.Master theformatsettingmethod ofthe worksheet.Experimental conditions:Windows operatingsystem andOffice suiteshould beinstalled.Experiment10:Use ofExcel formulaand functionExperimentalcontent:formula,function application,three addressdifference andapplication.Experimental properties:verification anddesignExperimental hours:3Experimental purposeand requirements:
1.Master theuse ofExcel formulas.
2.Master theuse of common functionsin Excel.
3.Master thedifference andapplicationofthe threeaddresses.Experimental conditions:Windows operatingsystem andOffice suiteshould beinstalled.Experiment11:Excel dataManagementExperimental content:database establishment,editingmethod,database query,statistical method,data mergeoperationand thebasic usage of PivotTable.Experimental properties:verification anddesignExperimental hours:3Experimental purposeand requirements:
1.Master theestablishment methodof database.
2.Master thebasic editing methodsof database.
3.Master thequery andstatistical methodssuch asfiltering,classificationand summarycommonly usedin database.
4.Master thebasicusage ofPivotTable.
5.Master themerging operationof data.Experimental conditions:Windows operatingsystem andOffice suiteshould beinstalled.Experiment12:Excel datachart processingpivottables,andthesimulation operationofdata.Experimental properties:verification anddesignhours:3Experimentalpurpose and requirements:Experimentalcreation methodsof commoncharts in Excel.
1.Master thebasicediting methodsofcommoncharts inExcel.
2.Master thebasicusage ofExcel pivotchart.
3.Master thebasicusageofanalog operation.
4.MastertheExperimental contents:thecreationandeditingofcommondata chartsandExperimental conditions:Windows operatingsystem andOffice suiteshould beinstalled.Experiment13:Comprehensive Applicationof ExcelExperimentcontent:Making appropriatespreadsheet applicationexamples bycomprehensivelyapplying variousfunctionsofExcel.Experimental nature:comprehensiveExperimental hours:3Experimental purposeandrequirements:Exercise theability tosolve practicalproblemsby usingExcel comprehensively.Experimental conditions:Windowsoperatingsystem andOffice suiteshould beinstalled.Research andThinking:
1.How tounderstand theword electronicinExcelspreadsheet software
2.Are numericdata anddate datatwo differenttypes ofdata
3.How touse theKnowledge ofExcel tostandardize theirdaily consumptionandput anend tobad consumptionbehaviorsExperiment project4:PowerPoint2010Experiment14:PowerPoint presentationmakingExperimental content:theestablishment andmodificationsetting methodofthepresentation,methodoftheverification anddesignpresentation,andtheeffectExperimental properties:requirements:
1.Master themain methodsof creatingpresentations,basic
2.Master theeditingmethodsof presentation,basic
3.Master thetypesetting methodsof presentation,animation
4.Masterthe settingmethodofpresentation,presentation
5.Masterthe method.Experimental hours:3Experimental purposeandExperimental conditions:WindowsoperatingsystemandOffice suiteshould beinstalled.Research andThinking:
1.How tounderstand therelationship betweenplaceholder andmaster
2.How tocontrol theanimation executiontime ofthe objectHow isthe triggermechanismimplemented
3.What aresome factorsto considerwhen settingup yourpresentation,fromcontent toappearance toeffectExperimental project5:Computer networkApplication foundationExperiment15:LAN settingand resourcesharing,Information queryandE-mail useExperimentcontent:Test networkconnectivity,IP addressand domainname setting,network resourcesharing.The useofthebrowser,the sending and receiving ofE-mail.Experimental properties:verification anddesignExperimental hours:3Experimental purposeandrequirements:
1.Master thetesting methodof networkconnectivity.
2.Master themethodsofnetwork resourcesharing.
3.Understand therole ofIP addressesand domainnames.Why andby whomwas thenetwork invented
4.
5.Master theuseofcommon browsers.Discuss thedifferences betweenbrowsers allovertheworld.Which one
6.is popular,why
7.Master thesendingandreceivingofE-mail.Think aboutthe convenienceand differencebetween Emailand Wechat.Which onedoyou likebetter anduse morefrequentlyV.Recommend teachi ngmater ia Isandteachi ngreference resources
1.Liu Yong.Fundamentals ofuniversity computer2nd edition.Tsinghua universitypress,
2013.7Learning website:.gdoa.net:8580Vi i.Other instruct ionsIn this course,the finalexam accounting for70%ofthetotal scoreis conductedbycomputer examination,andthescore ofthis courseis comprehensivelyevaluatedby combiningwith theusual scoreaccountingfor30%ofthetotal score.Theperformance ofthiscourseis mainlyassessed fromthe aspectsof mid-term examination,experiment completion,auxiliary learningplatform practice,attendance andclassroomperformance.。
个人认证
优秀文档
获得点赞 0
