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

1、Syllabus of Fundamentals of Computer CultureCourse Name：Fundamentals of Computer CultureCourse Code： Credits：1 Total Credit Hours：48Lecture Hours：16 Experiment Hours：Programming Hours：32 Practice Hours：Total Number of Experimental (Programming) Projects 12 , Compulsory ( 12 ), Optional ( 0 ).School：

2、Artificial Intelligence and Computer ScienceTarget Major：Non-computer-science majors、Course Nature & AimsThis is a compulsory course for non-computer-science majors, and it is a basic course in the students professional training program. The course includes theoretical knowledge and computer practic

3、e, and it has the characteristics of a combination of knowledge and skills. By studying this course, students would have the following abilities: to master the main principle of computer systems, computer multimedia technology, computer network, computer software development and other basic knowledg

4、e and application fields; to master the skills and comprehensive ability of Windows operating system and Office software; to improve the knowledge of computer culture and have a good foundation for the usage or further study of computer technology in the future.、Course Objectives1. Moral Education a

5、nd Character Cultivation.The Report of the 18th CPC National Congress pointed out: to establish morality and cultivate people as the fundamental task of education, and to train socialist builders and successors with all-round development morally, intellectually, physically and aesthetically. Univers

6、ity students are the pillars of the country, the innovators and leaders of the future development. They must be trained to love the party and the country, to have firm ideals and beliefs, and to have a correct outlook on world, life and values. Therefore, in the teaching process of this course, ideo

7、logical and political education is infiltrated into the teaching process, including the spirit of the 19th CPC National Congress, the core values of socialism, and the education of excellent Chinese traditional culture. In particular, the four self-confidence of socialism with Chinese characteristic

8、s are integrated into teaching. We should cultivate students love of the country, study, science, and research, together with innovative attitude towards life and the spirit of exploration. Through the introduction of computer development, we can guide students to pay attention to the development of

9、 Chinas computer industry, stimulate students national pride, self-confidence to surpass the world, and encourage students to strive for the scientific research of our country. At the same time, we should educate students to pay attention to the daily code of conduct, abide by the law, civilization,

10、 trustworthiness, take care of the environment, be strict with self-discipline, and dedication, and become well-educated and knowledgeable high-tech workers.2.Course ObjectivesThrough the study of this course, students qualities, skills, knowledge and abilities obtained are as follows：Objective 1. L

11、earn and master the composition, working principle, coding technology and communication technology of the computer system. （Corresponding to Chapter 1, 2, 4 and 5, supporting for graduation requirements index x.x）Objective 2. Learn and master the operation and usage of commonly used computer softwar

12、e. （Corresponding to Chapter 3, supporting for graduation requirements index x.x）3. Supporting for Graduation RequirementsThe graduation requirements supported by course objectives are mainly reflected in the graduation requirements indices x.x, x.x, x.x. , as follows:Supporting for Graduation Requi

13、rementsCourse ObjectivesGraduation RequirementsIndices and Contents Supporting for Graduation RequirementsTeaching TopicsLevel of Support IndicesContentsObjective 1X. DescriptionXXXIndex x.x:Description XXXXXXXChapter 1, 2, 4, and 5Objective 2Chapter 3、Basic Course ContentChapter 1 Basic Knowledge o

14、f Computers (supporting course objectives 1)1.1 Computer and Information Society1.2 Fundamentals of Digital TechnologyTeaching Requirements: Through study, students are required to be familiar with the background of computers, to understand the development of software and hardware of computer system

15、s, to master the division of computer functions and types, and to understand the current situation of computer applications in various fields. Students are required to master the representation and storage of information in the computer system, the coding rules of numerical data in the computer, and

16、 the conversion rules of data between binary and octal, decimal and hexadecimal. Students are required to master computer operation rules and storage methods.Key Points: The representation and storage of information in the computer; binary coding rules, binary conversion rules.Difficult Points: Codi

17、ng rules of numerical data in the computer.Chapter 2 Computer Systems (supporting course objectives 1)2.1 Overview of Computer System2.2 Computer Hardware System2.3 Computer Software System2.4 Computer Operating SystemTeaching Requirements: Through study, students are required to be familiar with th

18、e composition of the computer hardware system, the working principle and related knowledge of the five components, as well as technical indicators, to understand the working process of the computer, to master the hierarchical structure of the computer storage system, to understand the types of memor

19、y and storage technology, to understand the functions and status of commonly used software in computer software systems, and to understand the types and functions of the Windows operating system.Key Points: The composition and working principle of the computer hardware system, the functions of the f

20、ive components and related technical indicators, and the hierarchical structure of the storage system.Difficult Points: .The working principle of the computer, the technical specifications of the five components, and the storage structure of the storage system.Chapter 3 Commonly Used Computer Softwa

21、re (supporting course objectives 2)3.1 Windows 103.2 Word 20163.3 Excel 20163.4 PowerPoint 2016Practice 1: Windows basic operation (compulsory)Practice 2: Windows advanced operation (compulsory)Practice 3: Word basic operation (compulsory)Practice 4: Word mail merger operation (compulsory)Practice 5

22、: Word long document operation (compulsory)Practice 6: Word comprehensive operation (compulsory)Practice 7: Excel basic operation (compulsory)Practice 8: Excel data management (compulsory)Practice 9: Excel graph creation and editing (compulsory)Practice 10: Excel comprehensive exercise (compulsory)P

23、ractice 11: PowerPoint basic operation (compulsory)Practice 12: PowerPoint advanced operation (compulsory)Teaching requirements: Through study, students are required to proficiently master the functions and operation methods of Windows operating system, to master the functions, software environment

24、and operation methods of office software: Word, Excel and PowerPoint, to master the corresponding knowledge of all kinds of application cases, and have the ability to independently use these software to produce multimedia information documents, various types of charts and presentations of all kinds

25、of application cases.Key Points: Functions, software environment and operation methods of Windows, Word, Excel and PowerPoint.Difficult Points: File management in Windows operating system, page layout and formatting of Word multimedia documents, use of Excel function, production of PowerPoint multim

26、edia animation slides.Chapter 4 Fundamentals of Multimedia Technology (supporting course objectives 1)4.1 Basic concepts of multimedia technology4.2 Images and graphics4.3 Videos4.4 Digitization of text information4.5 AudiosTeaching requirements: Through study, students are required to be familiar w

27、ith the basic concepts and technical indicators of multimedia technology, to understand the work flow of digital coding, storage and processing of various types of media, as well as the technical indicators of several kinds of commonly used media. Students are required to understand the commonly use

28、d multimedia editing software, and the drawing principle of graphics. Students are required to master ASCII coding table and GB2312-80 Chinese character coding rules. Students are required to understand the processing of text characters and Chinese characters in the computer. Students are required t

29、o understand multimedia compression technology, and file compression operation.Key Points: The basic concept of multimedia technology, the work flow of digital coding, storage and digital processing of various types of information, and the technical indicators of commonly used media.Difficult Points

30、: Digital coding, storage, representation and processing of multimedia information.Chapter 5 Basic Knowledge of Computer Network (supporting course objectives 1)5.1 Overview of Computer Network5.2 Elements of the Network5.3 Local Area Network5.4 Internet5.5 Overview of Network SecurityTeaching requi

31、rements: Through study, students are required to understand the basic concepts, communication principles, related technologies and working process of computer data communication, to understand the basic concepts, classification and composition of computer networks, to understand the concepts and app

32、lications of network protocols, TCP/IP protocols, IP addresses and domain names, to understand network architecture, and to understand basic network security knowledge. Students are required to use the Internet.Teaching emphasis: The classification of computer network and the basic concept of data c

33、ommunication, the concepts and applications of TCP/IP protocol, IP address and domain name.Teaching difficulties: Basic concepts and network protocol rules in computer network and data communication.、Table of Credit Hour DistributionTeaching ContentIdeological and Political Integrated Lecture HoursE

34、xperiment HoursPractice HoursProgramming HoursSelf-study HoursExercise ClassDiscussion HoursChapter 1 Basic Knowledge of ComputersEncourage students to study diligently and rigorously, to master science and technology, and to accumulate knowledge and strength for the innovation and development of sc

35、ience and technology in our country.4Chapter 2 Computer SystemsEncourage students to work and study hard, to enhance the self-confidence to surpass the world.2Chapter 3 Commonly Used Computer SoftwareEncourage students to be honesty and trustworthy, to study rigorously, to make progress, and to have

36、 the courage to explore.232Chapter 4 Fundamentals of Multimedia TechnologyEncourage students to set up lofty ideals, to love life, to build beautiful home, to let life shine, and to accumulate knowledge and strength.4Chapter 5 Basic Knowledge of Computer NetworkEducation of network security, craftsm

37、an spirit, and professional ethics. Encourage students to use the network to exchange knowledge, transfer positive energy, and be an intellectual youth with both moral and academic excellence.4Total1632Sum48、Summary of Experimental (Programming) ProjectsNo.Experiment (Programming) NameExperiment (Pr

38、ogramming)HoursExperiment (Programming)TypeAbstractCourse TypeSupporting Course Objectives1Windows basic operation2verificationBasic operation of windows, create shortcut keys, set desktop background, create, delete, copy, move and manage files and folders, and compress.Compulsory22Windows advanced

39、operation2verificationFunctions of the control panel and settings for common items: clock, mouse, and user account, etc.Compulsory23Word basic operation2verificationText entry, find and replace, paragraph formatting, document editing, paragraph and page setup, insert pictures and Arts.Compulsory24Wo

40、rd mail merger operation2verificationWord document mail merger, table manipulation, and table formula editing.Compulsory25Word long document operation4verificationLong document editing, typesetting, formatting, inserting catalogs, captions, page setup, style use, and sections setting.Compulsory26Wor

41、d comprehensive operation4verificationComprehensive use of Word to create case documents.Compulsory27Excel basic operation2verificationSet up workbooks, worksheets, data editing, table data formatting, and the use of common functions.Compulsory28Excel data management2verificationUse of Excel functio

42、ns, data analysis: classification, summary, sorting, and table formatting.Compulsory29Excel graph creation and editing4verificationCreation and editing of charts, common functions, and page setup.Compulsory210Excel comprehensive exercise4verificationThe comprehensive application of Excel editing, fu

43、nction and formatting functions to design and beautify charts.Compulsory211PowerPoint basic operation2verificationCreate presentations, apply themes, slide switching, playback, animation settings, presentation formatting, modelling applications and settings.Compulsory212PowerPoint advanced operation

44、2verificationInsert arts, drawing graphics and text boxes in slides, and customize slides and animation effects.Compulsory2Note: Fill in comprehensive, designing, verification and demonstration in the experiment type, which refers to comprehensive experiment, designing experiment, verification exper

45、iment and demonstration experiment, respectively.Comprehensive experiment refers to the experiment involving the comprehensive knowledge of the course or related knowledge of the course.Designing experiment refers to the experiment in which the students design the experiment scheme and complete it b

46、y themselves based on the given experimental objectives and experimental conditions.Verification experiment refers to an experiment conducted to verify whether the knowledge or hypothesis is correct after a certain understanding of the research object is achieved or a certain hypothesis is put forwa

47、rd.Demonstration experiment refers to the experiment performed by the teacher in line with the teaching content.、Teaching MethodThe teaching method of this course is a mixed one based on the platform of MOOC of Jiangnan University. The compulsory contents of the course are provided to students, by w

48、atching and studying online in the form of course videos. Some teaching materials are provided to students for offline self-learning. According to the teaching plan, the course contents and assignments are regularly released on the MOOC platform, and the students are required to upload assignments t

49、o MOOC platform in a specified period of time. 、Course Assessment and Achievement EvaluationAssessment Methods：Non-ExaminationExamination Formats：Open-bookGrading Methods：Two-level SystemCourse Assessment Content, Assessment Format and Supporting Course ObjectivesCourse Objectives（Indices）Assessment

50、 ContentAssessment Formats and Proportion（）GradingCourse VideosAssignment EvaluationMidterm ExamFinal ExamProportion（）Objective 1（Index x.x）Background of computer development, basic concepts of computer, numerical coding, operation, binary conversion.171562664Objective 2（Index x.x）The concept, funct

51、ion and operation of Windows, the function and operation of Word, Excel and PowerPoint, and the production of various documents.81041436Total25251040100、Course ResourcesTextbooks：1. Xia Hongbin. New Edition of Fundamentals of Computer Culture（the 2nd Edition） M. Beijing: Posts and Telecom Press, 2020.2. Xia Hongbin. New Edition of Experimental Guidance and Exercises of Fundamentals of Computer Culture （the 2nd Edition）M. Beijing: Posts and Telecom Press, 2020.Bibliography：1. Feng Jianhua, Liu Yian. New Edition of Fundamentals of Computer Culture M. Beijing: