《计算机基础(全英)》-课程教学大纲.docx

《《计算机基础(全英)》-课程教学大纲.docx》由会员分享，可在线阅读，更多相关《《计算机基础(全英)》-课程教学大纲.docx（22页珍藏版）》请在得力文库 - 分享文档赚钱的网站上搜索。

1、The Sy I Iabus ofFundamentals of Computer AppIicationI. An overview of the courseCourse Code: 19110243Course Name: Fundamentals of Computer ApplicationCourse Category: general courses (compulsory)Class hours: 48(experimental class hours: 24)Credit points: 3Suitable students: all college students of

2、non-computer majorAssessment method: examinationPrerequisite courses: noneI I. Course i ntroduct ionThis course is a public compulsory course for non-computer major undergraduate students. It is the first level of basic computer education in colleges and universities, and the basis for learning othe

3、r computer-related courses. This course starts from application and focuses on developing students abilities and awareness of using computers to solve problems. The content of this course mainly includes: computer basic knowledge (software and hardware knowledge), microcomputer operating system, the

4、 application of common office software and so on. Through the study of this course, students will master the basic computer knowledge and basic operation skills necessary for working, studying and living in the information society.III. Teach i ng purposesThis course is a public compulsory course for

5、 undergraduate students who are not computer majors. It lays a good foundation for students to understand the development trend of information technology, be familiar with the computer operating environment and working platform, have the common tools and software to deal with daily affairs and culti

6、vate the necessary information literacy of students. This course focuses on cultivating students basic abilities and thinking methods of applying computers, so as to enable students to acquire and process general information by using computers, and lay a good foundation for using computers to solve

7、problems in their major and related fields in subsequent courses.establishment and design of Word forms, the function of mixing text and text, document review and long document editing.Why does Microsoft Office dominate the domestic market? Talk about your view from the history, present situation an

8、d development trend. What is the way for new office software?(4) Teaching methods and meansThe combination of lecture and practice is carried out in the multimedia machine room.Chapter 4: Excel 2010(1) purpose and requirements1. Understand and master the basic concepts of spreadsheets.2. Master the

9、startup and exit methods of Excel, and be familiar with the composition and operation environment of Excel Windows.3. Proficient in creating, opening and saving worksheets.4. Proficient in basic operations such as insert, copy, move, delete, rename of worksheet.5. Proficient in data editing and form

10、atting Settings of worksheets.6. Proficient in the use of formulas and functions of worksheets.7. Proficient in the management and analysis of worksheet data.8. Understand the concept of charts and understand the creation and editing of charts.9. Master page formatting and printing of worksheets.(2)

11、 Teaching contentSection 1: an overview of Excel1. Main content(1) Basic functions of Excel.(2) Creating and closing an Excel workbook.(3) The interface of Excel.2. Basic concepts and knowledgeExcel features, interface and basic operations.3. Problems and applicationsQuestion: how to switch between

12、multiple worksheets in Excel?After completing this section, students are required to understand the basic functions of Excel, master the startup and shutdown methodsof Excel, and be familiar with the interface composition of Excel. Section 2: working with workbooks1. Main content(1) Concept of workb

13、ook.(2) Workbook establishment.(3) Basic operation of workbook.2. Basic concepts and knowledgeWorkbook concepts and basic operations.3. Problems and applicationsQuestion: what is the relationship between workbooks, worksheets, and cells?Students are required to understand the concept of worksheet, m

14、aster a variety of ways to create workbook, and master how to open, save and close workbook.Section 3: establishment and editing of worksheets1. Main content(1) Establishment of worksheets.(2) How to input of several basic types of data.(3) Generation of conventional sequence.(4) How to edit workshe

15、et data.2. Basic concepts and knowledgeThe establishment of worksheets, the input of all kinds of data and the generation of sequences, the basic editing method of working sheet cell data.3. Problems and applicationsQuestion: what are the characteristics of using the fill handle and the menu to prod

16、uce a sequence?After completing this section, students are required to understand the concepts of worksheets and cells, be familiar with the structure of worksheets and the method of cell representation, master the input and editing methods of numerical value, text and date-time type data, and maste

17、r the method of automatically populating data with fill handles and fill menus.Master the selection method of cells, continuous regions, and discontinuous regions, and the method of quickly locating cells andregions; master the naming method of cell regions; master the method of inserting columns, r

18、ows, and cells; master the methods of data replication, movement, deletion, elimination, and search and replace.Section 4: management of worksheets1. Main content(1) Basic operation of worksheet.(2) operation of worksheet window.2. Basic concepts and knowledgeThe basic operation of the worksheet.3.

19、Problems and applicationsQuestion: is there a limit to the number of worksheets that can be inserted into a worksheet?Students are required to master the operation of inserting, deleting, renaming, copying, moving and so on, as we11 as the method of splitting and freezing the worksheet window.Sectio

20、n 5: worksheet formatting1. Main content(1) Custom formatting.(2) Conditional format.(3) Validity of data.(4) Form format.(5) How to copy a format and use the style2. Basic concepts and knowledge Worksheet format modifier.3. Problems and applicationsQuestion: what causes the truncated display of dat

21、a and the # in the cell?After completing this section, students are required to master several common formatting methods, including custom formatting, conditional formatting, table formatting, format replication methods and styles, etc., and master the methods of data validity setting.Section 6: pri

22、nting of worksheets1. Main content(1) How to set the printing area.(2) How to set page number format.(3) Print preview and print.2. Basic concepts and knowledgePrint area Settings, print page formatting.3. Problems and applicationsQ: what is the main purpose of setting the print area?After completin

23、g this section, students are required to master the basic methods of Excel document printing format setting, including the format setting of printing area, printing page, margins, header/footer, and the characteristics of printing preview and printing.Section 7: formulas and functions1. Main content

24、(1) How to use the formula.(2) How to use functions.2. Basic concepts and knowledgeHow to use formulas and common functions.3. Problems and applicationsQuestion: how to understand the relationship between relative addresses, absolute addresses, and mixed addresses?After completing this section, stud

25、ents are required to understand the purpose of formulas, master the input methods of various formulas, master the changing characteristics of three kinds of address reference forms (relative reference, absolute reference and mixed reference) in the process of formula replication, and master the use

26、of the following commonly used internal functions of Excel.Mathematical functions: ABS, INT, ROUND, TRUNC, RAND, PI, MOD Statistical functions: SUM, SUMIF, SUMIFS, AVERAGE, COUNT, COUNTIF, COUNTIFS, COUNTA, MAX, MIN, RANKText functions: LOWER, UPPER, LEN, LEFT, RIGHT, MID, TEXT, FIND, SEARCHDate and

27、 Time functions: DATE, DAY, MONTH, YEAR, NOW, TODAY, TIME Conditional functions: IF, AND, OR Financial function: PMT, PV, FVDatabase statistics functions: DCOUNT, DCOUNTA, DMAX, DMIN, DSUM, DAVERAGELookup functions: VLOOKUP, HLOOKUP, LOOKUPSection 8: data management and analysis1. Main content(1) Da

28、ta editing(2) Data sorting.(3) Data screening(4) Data query.(5) Data statistics.(6) Classification and summary.(7) The use of PivotTables and PivotCharts.(8) Linkage operation of multiple worksheets.(9) Data combination calculation.2. Basic concepts and knowledgeCommonly used data query and statisti

29、cal methods, data merge operation.3. Problems and applicationsQuestion: does a subtotal perform the same function as a database statistics function?Students are required to complete this section after learning, to grasp the method of simple conditions and complex sequence database, senior master rec

30、ord sheet, screening and filtering method for query, master the methods of database statistics function is used to, and master the classification summary, pivot tables and data perspective to summary the data analysis method, the master data merge operations.Section 9: chart function1. Main content(

31、1) How to create charts.(2) How to edit charts.(3) How to analyze charts.2. Basic concepts and knowledge Charts and chart editing.3. Problems and applicationsQuestion: can you convert arbitrarily between different types of charts?Students are required to be proficient in creating common charts such

32、as bar charts, pie charts and line charts, understand the types and functions of charts, and master the basic methods of editing charts and the basic editing of chart elements.How to use the Knowledge of Excel to standardize their daily consumption and say no to bad consumption behavior?(3) Thinking

33、 and practiceQuestion to consider: Excel is called a spreadsheet. What do you think of the word electronic”?The experiment was arranged for students to master the basic operation of Excel and the format of worksheets, the use of formulas and functions, the use of sorting, filtering, categorizing, Pi

34、votTables and PivotCharts of databases, the simple use of data merging, and the methods of establishing, editing and formatting charts.(4) Teaching methods and meansThe combination of lecture and practice is carried out in the multimedia machine room.Chapter 5: Working with PowerPoint 2010(1) purpos

35、e and requirements1. Master the starting and exiting methods of PowerPoint, be familiar with the composition of PowerPoint Windows, and understand the operating environment of PowerPoint.2. Proficient in creating, opening and saving the presentation.3. Proficient in the basic operations of slide del

36、etion, copy, move and insert.4. Proficient in adding text, tables, charts, pictures and other elements of the presentation.5. Proficient in the generation of presentation animation, sound, video and other effects.6. Be familiar with the types of views in PowerPoint and the slide manipulation under e

37、ach view.7. Proficient in master, theme, background and other methods to unify the slide style.8. Proficient in the presentation mode, effect setting and switching operation methods.9. Proficient in the hyperlink setting method between the presentation and the website and other files.(2) Teaching co

38、ntentSection 1: PowerPoint overview1. Main content(1) The function of PowerPoint.(2) How to start and close PowerPoint.(3) Composition of PowerPoint interface.(4) View types of PowerPoint.(5) Concept of design template and slide format.2. Basic concepts and knowledgePowerPoint features, interface co

39、mposition and basic operations.3. Problems and applicationsQ: what are the features of making slides in various view modes? After completing this section, students are required to understand the basic functions of PowerPoint, master the starting and closing methods of PowerPoint, be familiar with th

40、e interface composition of PowerPoint, master the characteristics of various operations in different view environments, and master the use of tools such as templates and slide formats.Section 2: the creation of the presentation1. Main content(1) How to create a blank presentation.(2) How to create p

41、resentations according to the template.(3) How to create presentations with themes.(4) How to create presentations based on existing content.2. Basic concepts and knowledgeBasic methods for creating presentations.3. Problems and applicationsQ: what are the characteristics of several common methods o

42、f creating presentations?After completing this section, students are required to familiarize themselves with several common methods of creating presentations.Section 3: editing the presentation1. Main content(1) Making presentations and adding various elements.(2) Browse, copy, move, insert and dele

43、te slides.2. Basic concepts and knowledge Basic operation of slides.3. Problems and applicationsQuestion: how to understand the use of placeholders?After completing this section, students are required to master the methods of adding and editing various basic elements, including text, pictures, clipa

44、rt, shapes, SmartArt charts, art words, tables, charts, organization charts, etc. Master the basic operation method of slide, such as slide insertion, delete, move, etc.The fourth section of the presentation appearance effect Settings1. Main content(1) How to use theme.(2) How to use the background.

45、2. Basic concepts and knowledge Theme, background.3. Problems and applicationsQuestion: what aspect of the presentation does the theme change primarily?After completing this section, students are asked to master several common ways to change the appearance of a presentation, including topic and back

46、ground scenarios.Section 5 creation of hyperlinks1. Main content(1) How to create a hyperlink to a location in the current presentation.(2) How to create a hyperlink to the outside of the presentation.2. Basic concepts and knowledgeHyperlink concepts and settings.3. Problems and applicationsQuestion

47、: how do I create relative links between slides in a presentation?After completing this section, students are required to master the method of creating hyperlinks to a location in the document and to the outside of the document.Section 6: the presentation1. Main content(1) Manual projection.(2) Auto

48、matic projection.(3) How to set slide switching effect.(4) How to set slide animation effect.(5) How to add multimedia objects to the slide.(6) How to control slide show.2. Basic concepts and knowledge Slide show method.3. Problems and applicationsQuestion: how do I set the presentation to auto-play?Students are required to master the manual and automatic slide show modes, be familiar with the Settings of slide switching effect and animation effect, understand the method of