1. Basic concepts of information technology
1.1 Information society and information technology applications
1.2 Basic knowledge of elementary mathematics
·Simple statistics of data, commonly used statistical functions, and commonly used statistical charts
2. Basic knowledge of information processing
·The whole process of information processing
·Requirements for information processing (accurate, safe and timely)
·Information processing system
·Rules and regulations related to information processing
·Data collection methods, classification methods, coding methods
·Data entry methods and requirements
·Data Verification method
·Data output format
·File organization and access method
·File storage format
·File Compression and decompression
3. Basic knowledge of computer systems
3.1 Basic knowledge of hardware
·Connection of major components
·Main performance indicators of CPU
·Main Categories, characteristics, and main performance indicators of storage
· Categories, characteristics, and main performance indicators of auxiliary storage
· Categories, characteristics, and protection methods of commonly used storage media
< p>·The categories, characteristics, and main performance indicators of commonly used input devices·The categories, characteristics, and main performance indicators of commonly used output devices
·The categories and characteristics of commonly used I/O interfaces
·Common sense about the installation, use and maintenance of commonly used information processing equipment
3.2 Basic knowledge of software
·Basic concepts of operating systems
· Basic concepts of file system
·Basic knowledge of application software
·Basic knowledge of application system development
3.3 Basic knowledge of multimedia
·Multimedia Data format
·Multimedia creation tools and applications
4. Basic knowledge of operating system usage and file management
·Understanding of desktop environment
·Basic concepts and operation methods of icons, windows and their components]
·Basic concepts of files, folders, and directory structures
·File management operation methods
5. Basic knowledge of word processing
·Basic process of word processing
·Basic knowledge of text typesetting
·Basic functions and operation methods of word processing software
·File type and format compatibility
6. Basic knowledge of spreadsheets
·Basic concepts of spreadsheets
·Composition of spreadsheets
·Basic functions and operation methods of spreadsheet software
·Common data formats and commonly used functions
7. Basic knowledge of presentations
·Basic concepts of presentations
·Basic functions of commonly used presentation software
·Presentation production methods
8. Basic knowledge of database application
·Basic concepts of database application
·Basic functions and operation methods of database management system
9. Basic knowledge of computer network applications
·Basic concepts of local area network
·Basic concepts of the Internet, TCP/IP protocols and their main applications
·Types of commonly used network communication equipment and features
·Commonly used Internet connection methods
·Methods for sending, receiving and managing emails
·Methods for browsing, searching and downloading online information
>10. Basic knowledge of information security
·Basic knowledge of security in computer installation, connection, and use
·Basic knowledge of health and safety of computer environments
·Computer viruses Basic knowledge of prevention and control
·Common methods of information security (file access control, data encryption/decryption, backup and recovery, digital signatures, firewalls)
11. Information Processing Practice
·Understand the information processing requirements of the application department and the existing information processing environment
·Conceive and select information processing methods
·Discover information processing problems and seek solutions
·Improve information processing methods and write technical summaries
12. Basic knowledge about laws and regulations
·Computer Software Protection Regulations
·***Concepts of shared software, free software, and user licenses
·Related information security Legal, regulatory and professional ethical requirements (protection of business secrets and personal information, etc.)
13. Professional English
·Correctly read and understand simple English commonly used in computer use. Note: Computer-based exams will be conducted in batches. Candidates’ computers are equipped with the operating system Windows and office software (using software and versions that are generally popular in society). Candidates can choose appropriate software during the exam, complete the operation tasks according to the requirements of the test questions and save the operation results.
1. Basic computer operations
·View the basic parameters of the computer system: CPU type, RAM size, operating system and version, networked computer name
·View and change the desktop configuration: date and time , volume settings, screen settings, screen saver, wallpaper
·View and change the settings of the control panel
·Set the Chinese character input method
·I/ O device driver installation, installation of commonly used software
·Use and maintenance of commonly used I/O devices
·Help function
·Window operations, icons Operations and command line operations
·Create shortcuts for applications and run applications
·Defragment the disk
·Check for viruses
< p>2. File management·Understand tree directories, view and personalize the properties of folders/files, and identify file types
·Create, rename, move, copy, delete files or files Folder
· Back up disk files or folders to floppy disks or removable disks
· File and directory compression, decompression, encryption and decryption
· In the hard disk Search for specified files by file name, file type or update date
·Empty the Recycle Bin and recover deleted files in the Recycle Bin
·Files between Network Neighbors*** Enjoy it with the printer
3. Word processing
·Create new files, open existing files, save files, save as files, close files
·Help function
·Type text, select, Move, copy, cut, and paste file blocks
·Format settings, hypertext links, basic modifications, string search and replace, and macro operations for selected text blocks
·Insert Tables, graphics, special symbols, files (including images), establishing directories and indexes
·Basic table operations
·Conversion of multiple document formats (plain text, doc, html, documents module, PDF format)
·Set header, footer and page number
·Page setup, print preview, print in various specified ways
·Draw Simple graphics
·Merge emails
·Apply templates to create format documents and create new templates
·Typesetting and layout design
4. Spreadsheet processing
·New, open, save, save as, close spreadsheet
·Help function
·Adjust the basic settings of the spreadsheet (change view mode, zoom tool, modify toolbar, adjust rows and columns)
·Absolute address and relative address reference
·Set cell format
·In Insert text, special symbols, formulas, images into cells, and perform macro operations
·Select, edit, search, replace, and sort spreadsheet data
·Use formulas and common function operations, Use the autofill/copy handle tool to copy or increment data items
·Identify error messages
·Create various charts based on the data table to analyze the data, and edit and modify the charts to make them beautiful Practical
·Table data filtering, classification and summary
·Pivot table production
·Document layout setting, printing preview, printing worksheet/workbook< /p>
·Convert multiple file formats
·Set header, footer and page number
5. Presentation processing
·Create a new presentation, select the appropriate module, use and operate the master
·Insert new slides, enter text, tables and graphics
·Insert and edit various objects such as formulas
·Open presentation documents, edit and modify slide content, set formats, make modifications, and set backgrounds
·Copy, move, and delete slides Slides, reorder
·Set slide switching method, add speaker's notes, add animations, set hyperlinks
·Browse presentations, adjust show time
< p>·Use the help function·Convert multiple file formats
·Connect a projector for demonstration operation
6. Database processing
·Create new databases, data tables and views, create data table structures, enter data records, browse data tables
·Open database tables, edit data records, create indexes, and sort , save/save database table as
·Copy database/table structure, copy database, make backup file
·Query data records according to specified criteria, create queries with multiple criteria, save Query, add/delete filters
·Create, modify, print reports, set headers/footers, and perform data group statistics
·Use the help function
·Conversion of multiple file formats (word processing documents, spreadsheets, database tables)
7. Internet communication
·Set network connection, TCP/IP properties
·Settings of browser and email processing software
·Browse web pages according to URL, save, Print the specified web page
·Enter the portal website and search the web page with keywords and logical operators
·Download the required information through FTP or HTPP protocol
·Set bookmarks for web pages and open bookmarked web pages
·Set up new email accounts in email management software and receive emails
·Create and edit emails in various styles Mail, send mail (can have attachments)
·Create new mail folders, move between folders, search, sort, copy, delete mails
·Create an address book, Enter, edit, categorize, export, and import email addresses
·Use the address book to send mass emails, use the reply function to reply to emails, and forward emails