《計(jì)算機(jī)基礎(chǔ)(全英)》課程教學(xué)大綱

TheSyIlabusof

FundamentaIsofComputerAppIication

I.Anoverviewofthecourse

CourseCode:19110243

CourseName:FundamentalsofComputerApplication

CourseCategory:generalcourses(compulsory)

Classhours:48(experimentalclasshours:24)

Creditpoints:3

Suitablestudents:allcollegestudentsofnon-computermajor

Assessmentmethod:examination

Prerequisitecourses:none

II.Courseintroduction

Thiscourseisapubliccompulsorycoursefornon-computermajor

undergraduatestudents.Itisthefirstlevelofbasiccomputereducationin

collegesanduniversities,andthebasisforlearningothercomputer-related

courses.Thiscoursestartsfromapplicationandfocusesondeveloping

students*abilitiesandawarenessofusingcomputerstosolveproblems.The

contentofthiscoursemainlyincludes:computerbasicknowledge(software

andhardwareknowledge),microcomputeroperatingsystem,theapplicationof

commonofficesoftwareandsoon.Throughthestudyofthiscourse,students

willmasterthebasiccomputerknowledgeandbasicoperationskillsnecessary

forworking,studyingandlivingintheinformationsociety.

III.Teachingpurposes

Thiscourseisapubliccompulsorycourseforundergraduatestudentswho

arenotcomputermajors.Itlaysagoodfoundationforstudentstounderstand

thedevelopmenttrendofinformationtechnology,befamiliarwiththecomputer

operatingenvironmentandworkingplatform,havethecommontoolsandsoftware

todealwithdailyaffairsandcultivatethenecessaryinformationliteracy

ofstudents.Thiscoursefocusesoncultivatingstudents'basicabilitiesand

thinkingmethodsofapplyingcomputers,soastoenablestudentstoacquire

andprocessgeneralinformationbyusingcomputers,andlayagoodfoundation

forusingcomputerstosolveproblemsintheirmajorandrelatedfieldsin

subsequentcourses.

Choosecasesandlearningmaterialsaboutthegreatdevelopmentof

computerallovertheworld,letthestudentsfromthecasestudymastermodern

computerknowledge.

Iv.Teachingcontentsandrequirements

Chapter1:Computerbasicsanddigitization

(I)Purposesandrequirements

i.Understandtheevolutionprocessofcomputingtechnologyandthe

basicconceptsofcomputationalthinking.

2.Understandthesystemcompositionofthecomputer.

3.Basicknowledgeofinformationcodingincomputers.

4.Mastertheconversionmethodsofseveralcommonbases.

5.Generalknowledgeofcomputersystensandinformationsecurity.

6.Understandthehistoryandachievementsofcomputerdevelopmentin

theworld.

(2)Teachingcontents

Section1:computerbasics

1.Maincontent

(1)Thedevelopmentofelectronicconputers.

(2)Overviewofcomputationalthinking.

2.Basicconceptsandknowledge

Thedevelopmentofcomputers,characteristics,classificationand

basicconcepts.

3.Problemsandapplications

Q:giventhecurrentdevelopmentofcomputers,whatdoyouthink

computerswillbelikeinthefuture?

Aftercompletingthissection,studentsarerequiredtohavea

certainunderstandingofthedevelopmentofcomputersandtheir

functionalcharacteristics,andtoinitiallyestablishtheconcept

ofcomputationalthinking.

Section2:informationrepresentationandstorage

1.Maincontent

(1)Conversionbetweendatarepresentation,numbersystemand

commonlyusedcarrycountingsystem.

(2)Encodingrepresentationofwesterncharacters(ASCIIcode).

2.Basicconceptsandknowledge

Binary,octal,hexadecimal,ASCII,glyphcode.

3.Problemsandapplications

Question:howareNumbersandsymbolsprocessedinacomputer?

Aftercompletingthissection,studentsarerequiredtomasterthe

conversionbetweenseveralcommonbasesandunderstandtheASCII

representationofwesterncharacters.

Section3:anoverviewofthemicrocomputersystem

1.Maincontent

(1)Workingprincipleofcomputer.

(2)Computerhardwarecomposition.

(3)Compositionofcomputersoftware.

(4)Compositionofmicrocomputersystem.

2.Basicconceptsandknowledge

CPU,memory,input/outputdevices,instructions,programs.

3.Problemsandapplications

Question:whatarethemainideasofVonNeumann?Howtounderstand

theseideas?

Studentsarerequiredtounderstandthesoftwareandhardware

componentsofthecomputerandhowitworks.Understandtheconcept

ofstoragecapacity,address,bit,byte,KB,MB,GB,etc.,understand

thestructure,functionandprincipleofdisk,understandtheconcept

ofsystemsoftwareandapplicationsoftware.

(3)Thinkingandpractice

Question:howdoyouunderstandtheconceptofcomputationalthinking?

Arrangeexperimentstomakestudentsfamiliarwiththesoftware,

hardwareandnetworkenvironmentofthecomputerroomandmasterthebasic

operationmethodsofthecomputer.

Tellsomethingaboutwhatcomputersdoinscienceandtechnology

nowadays.

(4)Teachingmethodsandmeans

Thecombinationoflectureandpracticeiscarriedoutinthemultimedia

machineroom.

Chapter2:Operatingsystem

(I)Purposeandrequirements

1.Familiarwiththefunction,classificationandcharacteristicsof

theoperatingsystem.

2.Understandthefeatures,functions,operatingenvironment,startup

andexitmethodsofWindows.

3.UnderstandtheinterfacecompositionandbasicoperationofWindows.

4.Understandtheconceptofmultitaskingandmastertherunning,

switchingandexitingofapplications.

5.Understandthebasicconceptsoffilesandfolders,andmasterthe

basicoperationsoffilesandfolders.

6.MastertheusageofcommonWindowsaccessories.

7.DiscusshowoutstandingtheOSisincomputersoftware.

(2)Teachingcontents

Section1:operatingsystembasicknowledge

1.Maincontent

(1)Conceptofoperatingsystem.

(2)BasiccompositionandoperationofWindowsoperatingsystem.

2.Basicconceptsandknowledge

Operatingsystem,filesandfolders,devicemanagement.

3.Problemsandapplications

Question:howtounderstandtheconceptsofsingle-user,multi-user,

single-task,andmulti-taskinoperatingsystems?

Studentsarerequiredtounderstandtheconceptoftheoperating

system,understandthedevelopmentstatusofthemainstream

operatingsystem,understandthecharacteristicsoftheWindows

system,andbefamiliarwiththebasicoperationssuchasstarting

andclosingWindows.

Section2:file,folderandfilemanagement

1.Maincontent

(1)Theconceptandnamingmethodoffilesandfolders.

(2)Establishmentoftreedirectorystructure.

(3)Search,copy,move,renameanddeletefilesandfolders.

(4)Settingthepropertiesoffilesandfolders.

2.Basicconceptsandknowledge

Filesandfolders,treestructures,fileproperties.

3.Problemsandapplications

Question:whatisthepurposeofcreatingatreedirectorystructure?

Studentsarerequiredtomasterthebasicconceptsoffilesand

folders,thebasicmethodsofcreatingfolders,andthebasic

operationsofsearching,copying,moving,renaminganddeleting

filesandfolders.

Section3:usecommonWindowssoftwareandtools

1.Maincontent

(1)Howtousedrawing.

(2)Howtousetablets.

(3)Howtousenotepad.

(4)Howtousecalculator.

(5)Howtousescreenshottools.

(5)Howtouseoperatingsystemhelpfunction.

(6)Howtouseapplicationhelpfunction.

2.Basicconceptsandknowledge

Tablet,notepad,drawing,calculator,screenshot,helpsystem.

3.Problemsandapplications

Question:howdoyouhandleadifficultprobleminaWindows

environment?

Aftercompletingthissection,studentsarerequiredtomasterthe

useofoperatingsystemandapplicationprogramhelpfunctions,and

mastertheuseofcommonlyusedaccessorytools.

(3)Thinkingandpractice

Question:whatarethebasicfunctionsofanoperatingsystem?Thinkof

itfromtheperspectiveofthecomputerandtheuser.

Theexperimentwasarrangedtoletstudentsmasterthebasicmanagement

methodsoffilesandfoldersinWindowsenvironment,masterthebasic

managementmethodsofprogramsanddevicesinWindowsenvironmentandtheuse

ofcommonapplicationtools.

(4)Teachingmethodsandmeans

Thecombinationoflectureandpracticeiscarriedoutinthemultimedia

machineroom.

Chapter3:Word2010

(I)Purposesandrequirements

1.MasterthestartupandexitmethodsofWord,befamiliarwiththe

compositionofWordwindow,andunderstandtheoperatingenvironment

ofWord.

2.Masterthemethodsofcreating,openingandsavingdocuments,and

befamiliarwithseveralcommonviewsofdocuments.

3.Mastertheinputandeditingmethodsoftext.

4.Masterthetextcharacterformatandparagraphformattingandother

editingmethods.

5.Masterhowtousethestyle.

6.Understandwhattemplatesdo.

7.Masterthecreation,editing,modification,calculationand

conversionofformsanddocuments.

8.Mastertheestablishmentandeditingmethodsofgraphicsandpictures,

andrealizethemixingofpicturesandtexts.

9.Masterthebasicmethodsofdocumentdirectory,indexandreference.

10.Masterthebasicmethodsofdocumentreview.

(2)Teachingcontent

Section1:anoverviewofWord2010

1.Maincontent

(1)BasicfunctionsofWord.

(2)Creatingandclosingadocument.

(3)Usingtemplatetocreateadocument.

2.Basicconceptsandknowledge

Wordfeaturesandinterfacecomposition.

3.Problemsandapplications

Question:howdoIshowandhidevarioustoolbarsinaWordwindow?

StudentsarerequiredtounderstandthebasicfunctionsofWord,

masterthestartingandclosingmethodsofWord,andbefamiliarwith

theinterfacecompositionofWord.

Section2:docunentcreationandediting

1.Maincontent

(1)Createablankdocument.

(2)Editingthetext.

(3)Selectionoftextcontent.

(4)Textmovement,copyanddelete.

(5)Searchandreplace.

2.Basicconceptsandknowledge

Textrangeselection,searchandreplace.

3.Problemsandapplications

Question:howtoquicklyremoveSpacesfromadocument?

Studentsarerequiredtohaveagoodcommandofthemethodsof

creatingdocuments,enteringtextandmodifyingcommonmethods,how

toselecttext,howtomove,deleteandcopytext,andthesearch

andreplacefunctionswithandwithoutformat.

Section3:docunentlayout

1.Maincontent

⑴Howtosetthefont,size,fontshapeandcharactercolor.

⑵Howtosettheborder,shadingandspacingofcharacters.

⑶Paragrapharrangement.

(4)Paragraphindentation.

⑸Howsetparagraphborderandshading,

(6)Howtosetparagraphspacing.

⑺Howtosetthelinespacing,

(8)HowsetbulletsandNumbers,

⑼Howtouseformatbrush.

(10)Howtosetmargins.

(11)Howtoserthespecificationandprintingdirectionofthepaper.

(12)Howtosettheheaderandfooter.

(13)Howtoprintpreview.

(14)Howtosetupcolumns.

2.Basicconceptsandknowledge

Character,paragraph,andpageformatting.

3.Problemsandapplications

Question:Wordprovidesseveralviews.Whatisthedifferencebetween

them?

Studentsarcrequiredtocompletethissectionafterlearning,master

themethodsofsettingofcharacterformat,masterthemethodsof

settingoftheparagraphformat,masteringtheparagraphmerger,

split,exchange,delete,basicoperations,suchasapplication

projectssignedandnumbered,masterbrushwithformatcopymethod,

characterandparagraphformattograspthemethodofcolumns,master

pageformatsettingmethod,tograspthemethodofheaderandfooter

Settings,usetheprintpreviewtocheckthedocumentlayouteffect.

Section4:usingtemplatesandstyles

1.Maincontent

(1)HowtousethetemplateprovidedbyWordtocreatedocuments.

(2)Howtocreateandapplystyles.

2.Basicconceptsandknowledge

Applicationjftemplatesandstyles.

3.Problemsandapplications

Question:whatobjectsaretargetedbythestylesandtemplates?

Studentsarerequiredtounderstandtheconceptoftemplatesand

mastertheuseofstylesaftercompletingthissection.

Section5:preparation,calculationandmailcombinationofforms

1.Maincontent

(1)Howtocreateatable.

(2)Howtosetthecolumnwidth,rowheight,border,shadingandother

basicpropertiesofthetable.

(3)Howtocel1mergingandsplitting.

(4)Howtoinsertordeleterows,columns,andcellsinatable.

(5)Howtoformatthetablecontents.

(6)Howtousetablesforsimplearithmeticoperations.

(7)Howtomakebatchdocumentswithmailmergefunction.

2.Basicconceptsandknowledge

Create,edit,formatandcalculatetables.

3.Problemsandapplications

Question:isWordtablecalculationafunctionofWorditself?

Studentsarerequiredtomasterseveralcommonmethodsofcreating

formsinWord,thebasiceditingmethodsofforms,theuseof

formattingmethodssuchasmanualsettingandautoform,thebasic

arithmeticoperationfunctionsofforms,andthemethodofmaking

batchdocumentsbymai1merging.

Section6:textandgraphics

1.Maincontent

(1)Severalmainmethodsofproducingpicturesandgraphs.

(2)Howtoeditandmodifypicturesandgraphics.

(3)Howtousetextboxes.

(4)Howtoedittextandgraphics.

2.Basicconceptsandknowledge

Sourceandbasiceditingofimagesandgraphics.

3.Problemsandapplications

Question:howtosettheimagetoappearasabackgroundofatext?

Studentsarcrequiredtocompletethissectionafterlearning,grasp

theinsertpicturesinWordenvironment,clipart,insertedinto

variousshapes,artwords,mathematicalformulae,suchas

organizationchart,SmartArtdiagramandthebasicmethodsofvarious

objects,masterthebasiceditingmodificationmethodofimages,

graphics,mastertheusefunctionoftextbox,masterthetypesetting

byposition.

Section7:advanceddocumentapplications

1.Maincontent

(1)Documentreview

(2)Longdocumentediting

2.Basicconceptsandknowledge

Basicusage3fannotations,revisions,footnotes,catalogues,

indexes,etc.

3.Problemsandapplications

Question:howtoautomaticalgenerateandgrowdocument

directories?

Aftercompletingthissection,studentsarerequiredtomaster

severalcommondocumentreviewmethodsandbeproficientinediting

theformatofdocumentsofgraduationthesistype.

(3)Thinkingandpractice

Questiontoconsider:whataresomeoftheformatsinWordthataffect

theoveralllayout?HowdoIprioritizelayout?

Theexperimentwasarrangedtoenablestudentstomasterthebasic

operationofWordandthelayoutdesignofWorddocuments,the

establishmentanddesignofWordforms,thefunctionofmixingtextand

text,documentreviewandlongdocumentediting.

WhydoesMicrosoftOfficedominatethedomesticmarket?Talkaboutyour

viewfromthehistory,presentsituationanddevelopmenttrend.What

isthewayfornewofficesoftware?

(4)Teachingmethodsandmeans

Thecombinationoflectureandpracticeiscarriedoutinthemultimedia

machineroom.

Chapter4:Excel2010

(I)purposeandrequirements

1.Understandandmasterthebasicconceptsofspreadsheets.

2.MasterthestartupandexitmethodsofExcel,andbefami1iarwith

thecompositionandoperationenvironmentofExcelWindows.

3.Proficientincreating,openingandsavingworksheets.

4.Proficientinbasicoperationssuchasinsert,copy,move,delete,

renameofworksheet.

5.ProficientindataeditingandformattingSettingsofworksheets,

6.Proficientintheuseofformulasandfunctionsofworksheets,

7.Proficientinthemanagementandanalysisofworksheetdata,

8.Understandtheconceptofchartsandunderstandthecreationand

editingofcharts.

9.Masterpageformattingandprintingofworksheets.

(2)Teachingcontent

Section1:anoverviewofExcel

1.Maincontent

(1)BasicfunctionsofExcel.

(2)CreatingandclosinganExcelworkbook.

(3)TheinterfaceofExcel.

2.Basicconceptsandknowledge

Excelfeatures,interfaceandbasicoperations.

3.Problemsandapplications

Question:howtoswitchbetweenmultipleworksheetsinExcsl?

Aftercompletingthissection,studentsarerequiredtounderstand

thebasicfunctionsofExcel,masterthestartupandshutdownmethods

ofExcel,andbefamiliarwiththeinterfacecompositionofExcel.

Section2:workingwithworkbooks

1.Maincontent

(1)Conceptofworkbook.

(2)Workbookestablishment.

(3)Basicoperationofworkbook.

2.Basicconceptsandknowledge

Workbookconceptsandbasicoperations.

3.Problemsandapplications

Question:whatistherelationshipbetweenworkbooks,worksheets,

andcells?

Studentsarerequiredtounderstandtheconceptofworksheet,master

avarietyofwaystocreateworkbook,andmasterhowtoopen,save

andcloseworkbook.

Section3:establishmentandeditingofworksheets

1.Maincontent

(1)Establishmentofworksheets.

(2)Howtoinputofseveralbasictypesofdata.

(3)Generationofconventionalsequence.

(4)Howtoeditworksheetdata.

2.Basicconceptsandknowledge

Theestablishmentofworksheets,theinputofallkindsofdataand

thegenerationofsequences,thebasiceditingmethodofworking

sheetcelldata.

3.Problemsandapplications

Question:whatarethecharacteristicsofusingthefillhandleand

themenutoproduceasequence?

Aftercompletingthissection,studentsarerequiredtounderstand

theconceptsofworksheetsandcells,befamiliarwiththestructure

ofworksheetsandthemethodofcellrepresentation,mastertheinput

andeditingmethodsofnumericalvalue,textanddate-timetypedata,

andmasterthemethodofautomaticallypopulatingdatawithfill

handlesandfillmenus.

Mastertheselectionmethodofcells,continuousregions,and

discontinuousregions,andthemethodofquicklylocatingcellsand

regions;masterthenamingmethodofcellregions;masterthemethod

ofinsertingcolumns,rows,andcells;masterthemethodsofdata

replication,movement,deletion,elimination,andsearchand

replace.

Section4:managementofworksheets

1.Maincontent

(1)Basicoperationofworksheet.

(2)operationofworksheetwindow.

2.Basicconceptsandknowledge

Thebasicoperationoftheworksheet.

3.Problemsandapplications

Question:istherealimittothenumberofworksheetsthatcanbe

insertedintoaworksheet?

Studentsarerequiredtomastertheoperationofinserting,deleting,

renaming,copying,movingandsoon,aswellasthemethodof

splittingandfreezingtheworksheetwindow.

Section5:worksheetformatting

1.Maincontent

(1)Customformatting.

(2)Conditionalformat.

(3)Validityofdata.

(4)Formformat.

(5)Howtocopyaformatandusethestyle

2.Basicconceptsandknowledge

Worksheetformatmodifier.

3.Problemsandapplications

Question:whatcausesthetruncateddisplayofdataandthe#inthe

cell?

Aftercompletingthissection,studentsarerequiredtomaster

severalcommonformattingmethods,includingcustomformatting,

conditionalformatting,tableformatting,formatreplication

methodsandstyles,etc.,andmasterthemethodsofdatavalidity

setting.

Section6:printingofworksheets

1.Maincontent

(1)Howtosettheprintingarea.

(2)Howtosetpagenumberformat.

(3)Printpreviewandprint.

2.Basicconceptsandknowledge

PrintareaSettings,printpageformatting.

3.Problemsandapplications

Q:whatisthemainpurposeofsettingtheprintarea?

Aftercompletingthissection,studentsarerequiredtomasterthe

basicmethodsofExceldocumentprintingformatsetting,including

theformatsettingofprintingarea,printingpage,margins,

headcr/footcr,andthecharacteristicsofprintingpreviewand

printing.

Section7:formulasandfunctions

1.Maincontent

(1)Howtousetheformula.

(2)Howtousefunctions.

2.Basicconceptsandknowledge

Howtouseformulasandcommonfunctions.

3.Problemsandapplications

Question:howtounderstandtherelationshipbetweenrelative

addresses,absoluteaddresses,andnixedaddresses?

Aftercompletingthissection,studentsarerequiredtounderstand

thepurposeofformulas,mastertheinputmethodsofvariousformulas,

masterthechangingcharacteristicsofthreekindsofaddress

referenceforms(relativereference,absolutereferenceandmixed

reference)intheprocessofformulareplication,andmastertheuse

ofthefollowingcommonlyusedinternalfunctionsofExcel.

Mathematicalfunctions:ABS,INT,ROUND,TRUNC,RAND,PI,MOD

Statisticalfunctions: