版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领
文档简介
PAGE
PAGE
9
TheExperimentalSyllabusof
FundamentalsofComputerApplication
Anoverviewofthecourse
CourseCode:19110243
CourseName:FundamentalsofComputerApplication
CourseCategory:generalcourses(compulsory)
Classhours:48(experimentalclasshours:24)
Creditpoints:3
Suitablestudents:allcollegestudentsofnon-computermajor
Assessmentmethod:examination
Prerequisitecourses:none
Thegeneralpurposeandrequirementsofexperimentalteaching
1.RequirementsforStudents:
(1)Theexperimentalcontentmustbepreviewedbeforeeachexperiment,andthecorrespondingexperimentalpreviewreportmustbecompleted.
(2)Foreachexperiment,thelaboratoryinstruction,storageequipmentfortheexperimentandotherrelevantdocumentsshallbebroughtalong.
(3)Mustenterthelaboratoryontime.Thosewhoarelatefor5minuteswillnotbeadmittedtothelaboratory,andtheexperimentalclasswillbepunishedasbeingabsentfromclass.
(4)Ifyouneedtoaskforleaveforsomereason,youmustpresentthevalidrequestforleavetotheteacheraccordingtotherequirementsoftheschool,anditisinvalidifyousubmititlater.
(5)Obeythearrangementoftheexperimentalinstructorandtaketheseatsaccordingtothe"serialnumber".Ifthemachineneedstobeadjustedforanyreason,theconsentoftheexperimentalinstructorshallbeobtained.
(6)Pleaseraiseyourhandifyouhaveanyquestionsonthecomputer.Studentscandiscusswitheachotherwithoutmakinganoise.
(7)Duringtheexperiment,youarenotallowedtodoanythingunrelatedtotheexperiment,andyouarenotallowedtobringfoodintothelaboratory.Oncefound,youwillbedrivenoutofthelaboratoryafterbeingremindedinvalid.
(8)Aftertheendoftheexperiment,shutdownthemachine,putthekeyboardstandandseatinorder,andtakethesundriessuchasthetableoutofthelab.
2.Requirementsforteachers:
(1)Teachersshouldenterthelaboratoryontimeandshouldnotbelatefortheexperimentalclass.
(2)Students'previewreportsshouldbecheckedbeforetheexperiment.Experimentaloperationisnotallowedforstudentswhodonotpreparecarefullyordonotprepareatall.
(3)Inexperimentalclass,teachersshouldguidestudentscarefullyandsolveproblemsintime.
(4)Carefullycorrectthestudents'experimentreportsandmaketheexperimentscoresfaithfully.
(5)Studentsarestrictlyrequiredtoabidebytheoperatingrulesandexperimentalrulesforstudents.Teachershavetherighttostoptheuseofmachinesandstoptheexperimentsifnecessarytothosewhoviolatetherulesanddonotlistentoadvice.
(6)Donotdoanythingirrelevanttotheexperimentalcontentinthelaboratoryclass,anddonotleavethelaboratorywithoutpermission.
Requirementsforexperimentalconditions:
(1)Hardwarerequirements:
Personalcomputers,internalLAN,theInternet.
(2)Softwarerequirements:
Operatingsystem:EnglishWindowsoperatingsystem
Officesoftware:Office2010(English)
Othersoftware:WinRar
Discussthecomputerdevelopmentallovertheworld.Thankstothosepioneerswhomadeoutstandingcontributionstothedevelopmentofcomputer.
3.Experimentalteachingcontent
Accordingtothecurriculumdesignandteachingrequirements,thisexperimentsetup5experimentalitems,atotalof15specialexperimentalcontent,totrainstudentsinbasiccomputeroperation,wordprocessing,spreadsheetapplication,presentationproduction,networkapplicationandotheraspectsofpracticalapplicationability.
Experimentalproject1:Windowsoperatingsystem
Experiment1:BasicOperationofWindows
Experimentcontents:StartandcloseWindows,howtousekeyboardandmouse,useofandEnglishinputmethod,punctuationmark,switchofandEnglishinputmethod.
Experimentalnature:publiccomputerroom
Experimentalhours:3
Experimentalpurposeandrequirements:
1.MasterthestartupandshutdownmethodsofWindowsoperatingsystem.
2.Understandandmastertheuseofthekeyboard.
3.Understandandmastertheuseofthemouse.
4.MastertheandEnglishinputmethodsandtheswitchofandEnglishinputmethods.
Experimentalconditions:InstallationofWindowsoperatingsystemisrequired
Experiment2:WindowsFileandFolderManagement.SettingupWindowssystemandusingcommonapplicationtools
Experimentcontent:basicoperationofWindowswindow,basicoperationoffilesandfolders.
Experimentalproperties:verificationanddesign
Experimentalhours:3
Experimentalpurposeandrequirements:
1.MasterthebasicoperationofWindows.
2.Masterthebasicoperationofthefile,includingcopying,moving,renaming,deleting,settingproperties,etc.
3.Masterthebasicoperationofthefolder,including:establish,copy,move,delete,rename,attributesetting,etc.
ResearchandThinking:
1.Whatarethedomesticoperatingsystems?Whatisthecurrentstateofdevelopment?
2.Whatisthebiggestfunctionoftheoperatingsystemforordinaryusers?
Experimentalproject2:wordprocessingsoftware
Experiment3:Theestablishment,editingandtypesettingofWorddocuments
Experimentalcontent:documentcreation,editingandmodification,page,characterandparagraphformatting,useofbulletandnumber,columnsegmentation,textsearchandreplacement.
Experimentalproperties:verificationanddesign
Experimentalhours:3
Experimentalpurposeandrequirements:
1.Mastercommoneditingmethodsofdocuments.
2.Mastertheformattingmethodsofcharactersandparagraphs.
3.Mastertheuseofbulletpointsandnumbers.
4.Masterthesettingofcolumnformat.
5.Masterthemethodsoffindingandreplacingwords.
Experimentalconditions:WindowsoperatingsystemandOfficesuiteshouldbeinstalled.
Experiment4:MakingWordtable
Experimentalcontent:tableestablishment,formattingSettings.
Experimentalproperties:verificationanddesign
Experimentalhours:3
Experimentalpurposeandrequirements:
1.Masterseveralcommonmethodsoftableestablishment.
2.Mastertheeditingandformattingmethodsoftables.
Experimentalconditions:WindowsoperatingsystemandOfficesuiteshouldbeinstalled.
Experiment5:Wordgraphicmixing
Experimentalcontent:clipart,pictures,artisticwords,optionalgraphics,formulainsertionandediting,graphicobjectsandtextbetweenthesurrounding,overlappingrelationshipSettings.
Experimentalproperties:verificationanddesign
Experimentalhours:3
Experimentalpurposeandrequirements:
1.Mastertheinsertionmethodsofcommongraphicsobjects.
2.Masterthebasiceditingmethodsofcommongraphicsobjects.
3.Masterthesettingmethodofthepositionrelationofpictureandtextandthepositionrelationofdiagram.
Experimentalconditions:WindowsoperatingsystemandOfficesuiteshouldbeinstalled.
Experiment6:Annotation,reviewandmailmergeofWorddocuments
Experimentalcontent:documentannotation,reviewandmailmergefunction.
Experimentalproperties:verificationanddesign
Experimentalhours:3
Experimentalpurposeandrequirements:
1.Masterthebasicmethodsofaddingandeditingannotationstotexts.
2.Mastercommontextreviewtools.
3.Mastertheuseofmailmerge.
Experimentalconditions:WindowsoperatingsystemandOfficesuiteshouldbeinstalled.
Experiment7:Stylesandtheapplicationofstylesheets
Experimentalcontent:style,documentstructurediagram,automaticdirectorygeneration.
Experimentalproperties:verificationanddesign
Experimentalhours:3
Experimentalpurposeandrequirements:
1.Masterthemethodintheoutlineview.
2.Masterthemethodofreadingandeditingdocumentsbyusingdocumentstructurediagram.
3.Mastertheapplicationmethodsofstyles.
4.Masterthegenerationmethodofthedirectory.
Experimentalconditions:WindowsoperatingsystemandOfficesuiteshouldbeinstalled.
Experiment8:ComprehensiveApplicationofWord
Experimentalcontent:comprehensivenewspaperboarddesign,longdocumentediting.
Experimentalnature:comprehensive
Experimentalhours:3
Experimentalpurposeandrequirements:UsethevariousfunctionsofWordtodesignthecomprehensivebulletinboardandeditthelongdocument.
Experimentalconditions:WindowsoperatingsystemandOfficesuiteshouldbeinstalled.
ResearchandThinking:
1.Whatisthedevelopmenthistoryofdomesticofficesoftware?WhydoesMicrosoftOfficedominatethedomesticmarket?Talkaboutyourviewfromthehistory,presentsituationanddevelopmenttrend.
2.Howtorealizetheautomaticgenerationofthecatalogandthesettingofthepageheaderandfooterofdifferentcontentsofeachchapterinthedesignofthegraduationthesisequallengthdocument?
Experimentalproject3:Excel2010
Experiment9:BasicoperationandformatsettingofExcel
Experimentcontents:establishment,savingandopeningofExcelfiles,datainput,naming,copying,moving,inserting,deleting,splittingandfreezingofworksheets,andformattingofworksheets.
Experimentalproperties:verificationanddesign
Experimentalhours:3
Experimentalpurposeandrequirements:
1.Masterthecreation,savingandopeningofExcelworkbooks.
2.Mastertheinputmethodsofvariousdata.
3.MasterthebasicoperationsofExcelworksheets,includingrenaming,copying,moving,insertinganddeleting.
4.Mastertheformatsettingmethodoftheworksheet.
Experimentalconditions:WindowsoperatingsystemandOfficesuiteshouldbeinstalled.
Experiment10:UseofExcelformulaandfunction
Experimentalcontent:formula,functionapplication,threeaddressdifferenceandapplication.
Experimentalproperties:verificationanddesign
Experimentalhours:3
Experimentalpurposeandrequirements:
1.MastertheuseofExcelformulas.
2.MastertheuseofcommonfunctionsinExcel.
3.Masterthedifferenceandapplicationofthethreeaddresses.
Experimentalconditions:WindowsoperatingsystemandOfficesuiteshouldbeinstalled.
Experiment11:ExceldataManagement
Experimentalcontent:databaseestablishment,editingmethod,databasequery,statisticalmethod,datamergeoperationandthebasicusageofPivotTable.
Experimentalproperties:verificationanddesign
Experimentalhours:3
Experimentalpurposeandrequirements:
1.Mastertheestablishmentmethodofdatabase.
2.Masterthebasiceditingmethodsofdatabase.
3.Masterthequeryandstatisticalmethodssuchasfiltering,classificationandsummarycommonlyusedindatabase.
4.MasterthebasicusageofPivotTable.
5.Masterthemergingoperationofdata.
Experimentalconditions:WindowsoperatingsystemandOfficesuiteshouldbeinstalled.
Experiment12:Exceldatachartprocessing
Experimentalcontents:thecreationandeditingofcommondatachartsandpivottables,andthesimulationoperationofdata.
Experimentalproperties:verificationanddesign
Experimentalhours:3
Experimentalpurposeandrequirements:
1.MasterthecreationmethodsofcommonchartsinExcel.
2.MasterthebasiceditingmethodsofcommonchartsinExcel.
3.MasterthebasicusageofExcelpivotchart.
4.Masterthebasicusageofanalogoperation.
Experimentalconditions:WindowsoperatingsystemandOfficesuiteshouldbeinstalled.
Experiment13:ComprehensiveApplicationofExcel
Experimentcontent:MakingappropriatespreadsheetapplicationexamplesbycomprehensivelyapplyingvariousfunctionsofExcel.
Experimentalnature:comprehensive
Experimentalhours:3
Experimentalpurposeandrequirements:ExercisetheabilitytosolvepracticalproblemsbyusingExcelcomprehensively.
Experimentalconditions:WindowsoperatingsystemandOfficesuiteshouldbeinstalled.
ResearchandThinking:
1.Howtounderstandtheword"electronic"inExcelspreadsheetsoftware?
2.Arenumericdataanddatedatatwodifferenttypesofdata?
3.HowtousetheKnowledgeofExceltostandardizetheirdailyconsumptionandputanendtobadconsumptionbehaviors?
Experimentproject4:PowerPoint2010
Experiment14:PowerPointpresentationmaking
Experimentalcontent:theestablishmentandmodificationmethodofthepresentation,andtheeffectsettingmethodofthepresentation.
Experimentalproperties:verificationanddesign
Experimentalhours:3
Experimentalpurposeandrequirements:
1.Masterthemainmethodsofcreatingpresentations.
2.Masterthebasiceditingmethodsofpresentation.
3.Masterthebasictypesettingmethodsofpresentation.
4.Mastertheanimationsettingmethodofpresentation.
5.Masterthepresentationmethod.
Experimentalconditions:WindowsoperatingsystemandOfficesuiteshouldbeinstalled.
ResearchandThinking:
1.Howtounderstandtherelationshipbetweenplaceholderandmaster?
2.Howtocontroltheanimationexecutiontimeoftheobject?Howisthetriggermechanismimplemented?
3.Whataresomefactorstoconsiderwhensettingupyourpresentation,fromcontenttoappearancetoeffect?
Experimentalproject5:ComputernetworkApplicationfoundation
Experiment15:LANsettingandresourcesharing,Information
温馨提示
- 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 20以内的加法口算练习题4000题206
- 二手车抵押合同2024年
- 2024年石场购货合同样本
- 养老院协议2024年
- 2024年合规物语反商业贿赂之廉洁协议
- 2024年篮球架销售合同范本
- 2024年国家货物运输代理合同
- 彩色印刷合同范本2024年
- 2024年公司债务债权转让协议书
- 2024年运输服务居间合同范本
- 中国AIOps现状调查报告(2024)-云计算开源产业联盟
- 2024新沪教版英语初一上单词表
- 宣传片基本报价单三篇
- 2024年考研英语真题及答案(完整版)
- 小学生少先队中队长竞选PPT
- 《千字文》(课堂)课件
- 2022-2023学年部编版高中语文必修上册2.2《红烛 》教学实录
- DB11-T825-2021绿色建筑评价标准
- 六三制新青岛版四年级科学上册第二单元第6课《哪杯水热》课件
- 小学生美术课件-第2课-蔬菜苏少版-(共18张PPT)ppt课件
- 国家基本药物目录(最新版)
评论
0/150
提交评论