《計算機基礎(全英)》-實驗教學大綱

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