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

1、The Syllabus of of Computer I. An overview course 19110243 Fundamentals Computer Application general courses Class hours: 48(experimental class hours: Credit points: all college students of non-computer Assessment examination noneII. introduction course is a public compulsory for students. It is the

2、 first level of basic computer in universities, and the for learning courses. This course starts from application on developing abilities awareness of to solve The of this course mainly (software operating the application of office on. of this will the basic skills for studying and living in the inf

3、ormation society.III. purposes course is a public compulsory for are not It lays a foundation for to understand of information be familiar with the computer platform, have the software to with information of This focuses on cultivating basic abilities thinking of computers, so to to information by c

4、omputers, and lay a foundation using to solve in major related fields in courses.1 cases and learning the development of all over world, students case modern Iv. Teaching requirementsChapter and (I) Purposes and 1. Understand the process of technology and of computational 2. Understand the system co

5、mposition of 3. of information in computers.4. the conversion of common bases.5. knowledge computer information 6. Understand the history and of development in the world.(2) basics1. Main content(1) The development of electronic computers.(2) Overview of 2. The of characteristics, classification and

6、 basic concepts.3. applicationsQ: given of computers, do think computers will like in After completing this section, students required to understanding of of characteristics, and initially establish the of computational information representation and 1. Main content(1) Conversion between commonly (2

7、) representation western characters 2. 2 octal, ASCII, glyph code.3. applicationsQuestion: symbols in a computer?After completing this section, students required to the conversion between several common bases and ASCII representation of western an overview of the microcomputer system1. Main content(

8、1) principle of computer.(2) Computer hardware (3) Composition of computer (4) Composition of microcomputer 2. input/output devices, 3. applicationsQuestion: what the main ideas of How to understand ideas? required to software components of the computer and how it the of storage capacity, bit, byte,

9、 etc., structure, principle of disk, understand of system software application software.(3) Thinking Question: do the of computational Arrange experiments to make familiar with the of computer master the computer.Tell about what computers and technology nowadays.(4) and The of lecture and practice i

10、s carried in the machine Chapter Operating system(I) and requirements31. with classification of the system.2. operating of Windows.3. Understand the of Windows.4. Understand the concept of master the running, exiting 5. Understand the basic concepts files folders, master of files and 6. the usage of

11、 common Windows accessories.7. Discuss how outstanding the OS is in computer software.(2) system basic 1. Main content(1) Concept system.(2) of Windows operating 2. Operating system, files folders, device 3. applicationsQuestion: concepts of single-user, multi-task in required to of the operating sy

12、stem, status of the mainstream system, of be familiar with the such starting and Windows. file, folder file management1. Main content(1) The naming method (2) of tree directory structure.(3) Search, and delete files and (4) the properties of files folders.2. folders, structures, file 3. applications

13、Question: what is the purpose creating tree directory structure?4 required to master of files and of creating and of searching, copying, moving, folders. common Windows 1. Main content(1) How use (2) How use (3) How use notepad.(4) How use (5) How use screenshot (5) How use operating (6) How use app

14、lication 2. notepad, calculator, system.3. applicationsQuestion: do a difficult problem in a Windows After completing this section, students required to the use of operating system application program master use of commonly accessory tools.(3) Thinking Question: what the basic functions of operating

15、 Think of it from the of user.The was arranged to let master of folders in environment, master the basic management of in Windows of common application tools. (4) and The of out in the machine Chapter 3: Word 2010(I) Purposes and 1. the exit methods of Word, with of Word window, and operating of 2.

16、the of creating, opening and familiar with several common views of documents.53. the of text.4. Master the text format paragraph formatting editing methods.5. to style.6. Understand what templates 7. Master the modification, calculation conversion of forms documents.8. Master the establishment editi

17、ng of graphics mixing of pictures texts.9. the of directory, index reference.10. the of review.(2) content an overview of 20101. Main content(1) of Word.(2) a document.(3) template to create a document.2. Word features interface 3. applicationsQuestion: do I in a Word window? required to of Word, ma

18、ster starting and Word, and be familiar with interface of Word. editing1. Main content(1) Create blank document.(2) Editing text.(3) of text (4) Text (5) Search replace.2. Text range search and 3. applicationsQuestion: quickly remove Spaces document?6 required to a good of creating documents, enteri

19、ng text modifying common methods, to how to move, copy text, and the search and replace functions with without layout1. Main content(1) How the size, font and color.(2) How the of (3) Paragraph arrangement.(4) Paragraph indentation.(5) How border and (6) How spacing.(7) How the spacing.(8) How and (

20、9) How use format brush.(10) How to margins.(11) How to the specification printing direction of the paper.(12) How to the footer.(13) How to print preview.(14) How to up columns.2. page formatting.3. applicationsQuestion: several is the between them? required to complete learning, master of of chara

21、cter format, the of setting of format, the exchange, delete, projects master with copy character and paragraph to the method of master setting method, to the method of header Settings, use the preview to check layout styles1. Main content(1) How use the template provided by Word to 7(2) How 2. of te

22、mplates and 3. applicationsQuestion: what objects are by the required to of master use of completing this section. calculation and of 1. Main content(1) How a table.(2) How to set column width, row height, border, shading other basicproperties of table.(3) How merging and splitting.(4) How or delete

23、 rows, columns, and cells in a (5) How the table (6) How use tables simple arithmetic (7) How documents with mail function.2. tables.3. applicationsQuestion: is table a function of required to master several common of forms in Word, of use of formatting as autoform, operation of forms, the method ma

24、king batch documents by mail merging. text and 1. Main content(1) Several main of producing graphs.(2) How edit and modify pictures (3) How use boxes.(4) How edit text 2. Source basic of 3. applicationsQuestion: the image appear a of text?8 required to complete learning, the insert pictures in Word

25、inserted into mathematical such chart, SmartArt the editing of graphics, master use of text master by position. advanced 1. Main content(1) Document review(2) Long editing2. usage of annotations, revisions, indexes, etc.3. applicationsQuestion: generate directories?After completing this section, stu

26、dents required to several common proficient in editing the of documents of (3) Thinking to what are of formats in Word affect the How do I prioritize The was arranged enable to the basic operation Word the design of documents, design of Word forms, the function of mixing text review editing.Why does

27、 Microsoft dominate the domestic market? Talk view from the present situation development What for new (4) and The of lecture and practice is carried in the machine Chapter 2010(I) purpose requirements1. Understand the basic concepts spreadsheets.92. of Excel, be familiar with the operation of Windo

28、ws.3. creating, opening and saving 4. Proficient in such insert, copy, delete, rename of worksheet.5. editing of worksheets.6. the use of of worksheets.7. the of worksheet data.8. Understand the concept of charts and editing of charts.9. page formatting and printing of (2) content an overview of 1.

29、Main content(1) of (2) an Excel workbook.(3) The interface Excel.2. Excel features, interface basic 3. applicationsQuestion: switch between in Excel?After completing this section, students required to the of the of be familiar with the of working with 1. Main content(1) Concept workbook.(2) (3) of 2

30、. concepts and operations.3. applicationsQuestion: what is the between workbooks, worksheets, and cells? required to of worksheet, master variety of to workbook, how to open, workbook.10 establishment of worksheets1. Main content(1) of (2) How input of several types of data.(3) Generation of convent

31、ional (4) How edit worksheet 2. The of worksheets, the input of all kinds of data the generation of sequences, the basic of cell 3. applicationsQuestion: what the of using the fill menu to produce a After completing this section, students required to the concepts of worksheets be familiar with of th

32、e method master of text and date-time type the method of with fill fill menus.Master method continuous regions, and discontinuous method of quickly locating cells the method regions; the method of inserting columns, rows, master of and search and of worksheets1. Main content(1) of worksheet.(2) oper

33、ation of worksheet window.2. The of worksheet.3. applicationsQuestion: is a limit to that be a worksheet? required to master of inserting, renaming, so on, as well as method of splitting and freezing worksheet window. worksheet 111. Main content(1) formatting.(2) Conditional (3) Validity of data.(4)

34、 Form (5) How copy a format the style2. Worksheet 3. applicationsQuestion: what of in After completing this section, students required to several common formatting methods, custom formatting, conditional formatting, table formatting, format methods etc., the of data validity setting. of 1. Main cont

35、ent(1) How the (2) How page number (3) preview 2. Settings, print 3. applicationsQ: what is of setting the print area?After completing this section, students required to the basic of Excel printing the format setting of margins, header/footer, characteristics of printing. formulas and functions1. Ma

36、in content(1) How use the formula.(2) How use 2. How use formulas and 3. applicationsQuestion: between 12absolute mixed After completing this section, students required to the purpose of master input formulas, the characteristics of three kinds absolute reference reference) in of the use of followin

37、g commonly used of Mathematical functions: ABS, INT, PI, SUM, SUMIFS, VERAGE, COUNT, COUNTIF, MAX, MIN, RANKText LEFT, RIGHT, MID, TEXT, FIND, Date and DATE, DAY, MONTH, YEAR, NOW, TODAY, Conditional functions: OR function: , FVDatabase statistics DCOUNT, DMAX, DMIN, DSUM, DAVERAGE VLOOKUP, 1. Main

38、content(1) editing(2) sorting.(3) (4) query.(5) (6) summary.(7) The use of and PivotCharts.(8) of multiple worksheets.(9) 2. used query and statistical methods, 3. applicationsQuestion: does a subtotal same function a function? required to complete learning, to the method of conditions and complex s

39、equence senior master record 13 and filtering method for query, the of database is the classification summary, pivot data summary the data method, master chart function1. Main content(1) How charts.(2) How edit (3) How 2. Charts chart editing.3. applicationsQuestion: can you between different types

40、of required to be proficient in common charts charts, types functions the basic of charts and editing of chart How to use the daily say to bad behavior?(3) Thinking to Excel is a do of electronic?The experiment was arranged for students to operation of Excel the of worksheets, use of formulas the us

41、e of sorting, filtering, categorizing, PivotTables and of the use of merging, and the of establishing, charts.(4) and The of lecture and practice is carried in the machine Chapter Working with 2010(I) purpose requirements1. Master the starting and exiting of be familiar with the of PowerPoint Window

42、s, and understand the operating environment of 142. creating, opening and saving 3. the basic of slide copy, move and 4. Proficient in adding pictures of the 5. Proficient in of presentation sound, video other 6. Be with the of in PowerPoint and under each 7. master, theme, background unify style. 8

43、. the presentation setting and switching operation methods. 9. the setting between the the other files.(2) content overview1. Main content(1) The function of (2) How start close PowerPoint.(3) Composition of PowerPoint interface.(4) View of (5) Concept design template 2. features, interface and oper

44、ations.3. applicationsQ: what are of making slides in various view modes?After completing this section, students required to the of master and of PowerPoint, be familiar with interface of the characteristics of various operations different view environments, the use of tools such as the of the 1. Ma

45、in content(1) How a (2) How according to template.(3) How with themes.(4) How on existing 152. for presentations.3. applicationsQ: what are of several common of creating After completing this section, students required to familiarize themselves with several common editing presentation1. Main content

46、(1) Making presentations elements.(2) Browse, insert 2. of slides.3. applicationsQuestion: use of After completing this section, students required to the of basic clipart, SmartArt art words, tables, charts, etc. Master method slide, such insertion, etc.The fourth of presentation effect Settings1. Main content(1) How use (2) How use the background.2. Theme, 3. applicationsQuestion: what of presentation theme change After completing this section, students asked to common appearance of creation of hyperlinks1. Main content(1) How a to a location the current presentation.(2) How a