(A) Overview of information technology
1 information and information technology
(1) Information features and definitions, data, information, knowledge, information processing system. (understand)
(2) Information classification and information processing, information technology content. (familiar)
2. Microelectronics technology
(1) Concept of integrated circuits, development and classification of integrated circuits, IC cards. (understand)
(2) Integrated circuit manufacturing and packaging form, Moore's Law. (familiar)
3. Communication technology
The basic principle of (1) communication system includes channel, source and destination, analog signal, digital signal and all-optical network. (understand)
(2) The transmission mode, bandwidth, transmission rate, multiplexing technology and switching technology of the channel. (familiar)
(3) Wired transmission, wireless transmission, wired carrier communication, transmission medium and optical fiber communication. (familiar)
(4) Radio communication, microwave communication, satellite communication, infrared communication and mobile communication. (understand)
4. Fundamentals of digital technology
(1) information represents the unit, commonly used decimal number, BCD code, and transmission rate unit. (understand)
(2) Integer coded representation, original code, complement, complement, real coded representation, machine number, true value, data overflow. (familiar)
(3) Bit logic operation, conversion between decimal numbers, decimal number operation, conversion between original code, complement and complement, and the original code and complement represent the range of numbers. (master)
(2) Computer hardware
1. Basic principles of computer
(1) Computer development and classification, software overview, hardware overview. (understand)
(2) Overview of common input devices, common output devices, central processing units and the characteristics of Pentium processors. (understand)
(3) Computer classification, overview of internal memory and external memory, system bus and I/O bus. (understand)
(4) Overview of microprocessor development, word length, processing speed, instruction and instruction system, client and server. (understand)
2.PC composition
(1) Overview of motherboard, chipset, BIOS, memory, I/O bus and I/O interface. (understand)
(2) The composition and running process of BIOS, various types of memory RAM and ROM. (understand)
(3) At present, the popular SDRAM, DDRSDRAM, RDRAM parameters, data transmission rate calculation, and memory packaging forms. (understand)
(4) I/O bus, I/O working mode, several commonly used I/O device interfaces and I/O bus bandwidth calculation. (understand)
3. Common input devices
(1) Keyboard, mouse, pen input device, scanner and digital camera. (understand)
(2) The classification, working principle, basic operation and interface type of keyboard and mouse. (understand)
4. Common output devices
(1) Working principle, main classification and characteristics of common output devices. (understand)
(2) The main performance parameters of commonly used output devices and the interface types adopted. (understand)
5. External memory
(1) The working principle, composition, classification and interface types of several common external memories. (understand)
(2) Memory storage structure, setting of various performance parameters, data distribution and capacity calculation. (understand)
(3) Computer software
Basic concepts of 1. software
(1) The definition of software. (familiar)
(2) Classification of software. (master)
2. Operating system
(1) The concept and function of operating system. (master)
(2) The type and characteristics of the operating system. (familiar)
(3) The function of the operating system. (master)
(4) Introduction of general operating system. (understand)
3. Programming language and processing system
Classification of (1) programming languages. (master)
(2) Data component and control component of programming language. (master)
(3) Programming language processing system. (familiar)
(4) Introduction of main programming languages. (understand)
4. Algorithms and data structures
The concept, properties and evaluation of (1) algorithm. (master)
(2) The concept of data structure. (familiar)
(3) The concept and life cycle of software engineering. (familiar)
(d) Computer networks and the Internet
1. Computer Network Basis
(1) The definition, composition and classification of computer networks. (master)
(2) Classification of network services, network software, network operating system and network application software. (understand)
2. Computer local area network
(1) The characteristics, composition and classification of LAN, as well as the commonly used LAN. (master)
(2) LAN expansion, repeaters and bridges. (understand)
3. Computer Wide Area Network
(1) WAN basics, WAN access technology. (understand)
(2) Packet switching and routing. (master)
(3) Common ten thousand. (understand)
4. Internet and its application
(1) China Internet development, network interconnection, TCP/IP protocol. (understand)
(2) IP address, IP datagram and domain name. (master)
(3) the router. (understand)
(4) Services provided by the Internet. (master)
5. Network information security
(1) Overview of network information security, content of information security and classification of information security. (understand)
(2) Data encryption, digital signature, identity authentication and access control. (understand)
(3) packet filtering and firewall, computer virus. (understand)
(5) Digital media and its application
1. Text and text processing
(1) Text, word processing, text input method. (understand)
(2) Text representation and character coding. (master)
(3) the preservation of text and the type of text file. (understand)
(4) Text editing, retrieval and presentation. (understand)
2. Images and graphics and their applications
(1) color generation, color expression method, color space. (understand)
(2) Acquisition and reproduction of digital images. (understand)
(3) Simulate the digital process of the image. (master)
(4) Digital image representation, compression coding and performance index of digital image. (master)
(5) Common image file formats, digital image processing and application, and common software. (understand)
(6) Computer synthetic images, synthetic process, advantages and common drawing software. (understand)
3. Acquisition and playback of waveform sound
(1) Digitization of analog sound signal. (master)
(2) waveform sound acquisition equipment, waveform sound representation, compression coding and editing. (understand)
(3) Making and playing computer-generated sound. (understand)
4. Digital video and its application
The composition and principle of (1) video signal, and three formats of color TV. (understand)
(2) Acquisition and playback of digital video, and digitization of video signals. (master)
(3) Digital video compression coding, editing and application. (understand)
(4) Digital video synthesized by computer. (understand)
(5) Streaming media. (understand)
(6) Information system and database
1. computer information system
(1) The meaning and characteristics of computer information system. (master)
(2) Types of computer information systems. (familiar)
(3) The structure of computer information system. (understand)
(4) The development trend of computer information system. (understand)
2. Introduction of typical information systems
(1) manufacturing information system. (familiar)
(2) E-commerce. (familiar)
(3) E-government. (understand)
(4) Geographic Information System and Digital Earth. (understand)
(5) Distance education. (understand)
(6) Telemedicine. (understand)
(7) Digital library. (understand)
3. Relational database system
Composition and characteristics of (1) database system. (master)
(2) Basic concepts and types of data model. (familiar)
(3) Relational data model. (master)
(4) relational operation. (master)
(5) Relational database language SQL. (master)
(6) Application of database system and new technology. (understand)
4. Information system development and management
(1) software engineering and information system development. (familiar)
(2) System planning and analysis. (understand)
(3) System design. (understand)
(4) System implementation and operation maintenance. (understand)
(7) Windows
1. Keyboard and mouse
(1) The use of keyboard, commonly used function keys and shortcut keys. (understand)
(2) The purpose, shape and significance of the mouse. (familiar)
The basic concept of 2.2. Windows operating system
(1) Start and shut down the system. (understand)
(2) Introduction of desktop elements, taskbar, desktop icons and shortcuts. (master)
(3) Window and menu operation. (master)
3. Files and folders
(1) Basic concepts. (understand)
(2) Naming rules and wildcards. (master)
(3) File and folder operations. (familiar)
4.Windows utilities
(1) My computer and browser. (master)
(2) Recycle Bin and Clipboard. (master)
(3) Settings of control panel, keyboard, mouse and monitor. (understand)
(4) Common system tools. (understand)
8) Words
1 Word and its working window
(1) Method of running and quitting Word. (familiar)
Basic components of Word window, menu bar, toolbar, ruler and status bar. (understand)
(3) Toolbar settings, two commonly used toolbars. (master)
(4) Introduction of the main menu bar. (familiar)
(5) Characteristics and switching of several views. (master)
(6) Multi-window and multi-document editing. (familiar)
2. Basic operations of creating and saving documents
(1) Create a document. (master)
(2) Establish special documents. (understand)
(3) Save the document, first save the operation, and then save the operation. (master)
(4) Automatically save the settings. (familiar)
(5) Protect documents from unauthorized changes. (master)
3. Edit Text (Master)
(1) text input.
(2) Input of automatic atlas.
(3) Review the text.
(4) Check spelling and grammar.
(5) Selected articles, single line, paragraph and whole article.
(6) Insert and rewrite, find and replace.
(7) Delete text, move text, copy text and proofread text.
(8) Undo operation/repeat operation.
4. Simple typesetting (master)
(1) Font setting, font color setting, character spacing and character scaling, and character position setting.
(2) Paragraph alignment settings, first line indentation, hanging indent, line spacing, and paragraph front/back spacing.
(3) Bullets and numbers, initial sinking, borders and shadows.
(4) Column setting and separator setting.
(5) Chapter format setting and page format.
(6) Paper type setting and layout setting.
(7) Style setting.
(8) The use of format brushes.
5. Form processing (familiar)
(1) Create a table.
(2) Edit the table and merge and split it.
(3) Table border setting, shading setting and color setting.
(4) Setting of cell format.
(5) The use of table formula objects.
6. Advanced typesetting (main)
(1) Draw graphics and text boxes.
(2) The use and setting of wordart, charts, clip art and pictures in documents.
(3) file insertion, domain.
(4) Word document printing settings.
(9) Excel
The basic operation of 1 be good at
(1) Basic functions of Excel. (understand)
(2) Start and exit Excel. (familiar)
(3) Excel window, common toolbars, main menu bar, status bar, grid lines and color settings. (familiar)
(4) Workbook files, creating, opening and saving workbooks. (master)
(5) Close and protect the workbook. (familiar)
2. The basic operation of the worksheet
(1) Worksheet features: multi-row, multi-column, maximum number of rows and maximum column name. (familiar)
(2) Select, insert, delete, move and copy worksheets. (master)
(3) Rename the worksheet. (master)
(4) the protection of the worksheet. (familiar)
(5) Print the worksheet. (familiar)
3. Basic operation of cells
(1) Several main data types in Excel. (familiar)
(2) Input cell data (characters, numerical values, date and time, logical values). (master)
(3) The concept, meaning and state transition of relative reference and absolute reference. (master)
(4) The use of formulas in cells and several commonly used operators. (master)
(5) Insert a function into the cell and use several common functions. (master)
(6) Insert, select and delete cells. (master)
(7) Move cells and fill cells (cells contain formulas, but not formulas). (master)
(8) selective pasting. (master)
(9) Modify/clear the text in the cell. (master)
(10) Find/replace the text in the cell. (master)
(1 1) Merge/split cells. (master)
(12) Several ways of data input, refer to other cells to realize input, and use Word files to input Excel, text files and database files. (familiar)
(13) The meaning of common error messages. (familiar)
Format worksheet
(1) Edit rows/columns. (familiar)
(2) Set the font, font, font size and color. (master)
(3) Set the alignment, cell border and shading. (familiar)
(4) automatic format. (familiar)
5. Data analysis
(1) data list. (understand)
(2) data collation. (master)
(3) classified summary. (master)
(4) data screening. (master)
(5) Pivottable. (familiar)
(6) charts. (master)
(10) slide
1. Run, view, create, open, save and close PowerPoint. (familiar)
(1) Startup and exit 1)PowerPoint.
(2) PowerPoint window and its view.
(3) Create a new presentation.
(4) Open the existing presentation.
(5) Save the presentation.
2. Editing operation of slides. (master)
(1) Slide selection, insertion, deletion, copying, moving and editing.
(2) Editing operations of objects (text boxes, pictures, clip art, action buttons, wordart) in slides.
(3) Object action settings, hyperlinks.
3. Set the slide appearance. (master)
(1) slide master settings.
(2) Slide layout settings.
(3) Definition of color scheme.
(4) Slide background setting.
(5) Slide header/footer settings.
(6) Select the application design template.
4. Presentation. (master)
(1) Demonstrate the operation, position the slide, change the mouse shape, and play the slide.
(2) Set the slide show mode.
(3) Making the switching effect between slides.
(4) Animation settings in slides.
5. Print the presentation. (understand)
6. Packaging and publishing of presentations. (understand)
(1) Packaging of presentation.
(2) Release of the presentation.
;