What should I learn in computer application technology?
Basic knowledge of computer application technology; Master the professional knowledge of this major, have certain computer hardware management and common software application ability, and can constantly adapt to the rapid development of computer technology; Master relevant laws and regulations, and have clear judgment ability on the legality of computer applications. Professional specifications. Have the ability to operate, manage and maintain computer hardware and computer software system, master the preliminary design and use ability of database application system, and have the ability to skillfully apply office automation software; Have the ability to use the high-level language to write general application programs, have the basic application ability of network, and have multimedia processing skills such as graphics and images. Be able to master the laws and regulations involved in computer management and use, and use them. Knowledge structure 1, general knowledge. General knowledge is the basis and tool for learning and mastering professional basic theories and professional knowledge, and plays an auxiliary and supporting role in future computer applications. General knowledge includes solid knowledge of culture, social science and law, as well as basic theoretical knowledge of computer mathematics, computer application, C language programming, computer network and operating system principles. 2. Professional knowledge. Professional knowledge is the basis of computer application technology. Professional knowledge includes Visual FoxPro programming, VisualBasic.net programming, JAVA programming, graphics and image processing, FLASH animation making, web page making, etc. (2) Ability structure 1, basic ability: application ability of computer-related advanced mathematics; Basic programming skills; Computer system management and maintenance capabilities; Foreign language application ability; Automobile driving ability. 2. Professional ability: the ability to design, debug and maintain programs in high-level languages; Skillful use of office automation series software; Be able to design and apply management information system using relational database Visual FoxPro; Able to write general windows application software in Visual Basic language; Processing ability of computer multimedia materials; Comprehensive web design and production capabilities. 3. Comprehensive ability: social adaptability; Learning ability; Competitive ability; Organization and management ability; Innovative and entrepreneurial ability. (a) professional backbone course 1, computer mathematics foundation This course is a compulsory basic knowledge of mathematics for computer majors. According to the characteristics of computer specialty, the application of Mathematica mathematical software is strengthened. Include calculus, linear algebra and probability theory. Calculus module includes unary calculus, ordinary differential equation, multivariate calculus, infinite series, numerical calculation and so on. The linear algebra module includes the basic concepts, theories and applications of determinant, matrix and linear equations. Probability theory module includes random events and probability, random variables and their probability distribution, digital characteristics of random variables and so on. 2. Fundamentals of Computer Application This course is an introductory course for basic computer education. It mainly teaches the basic knowledge and composition principle of computers, the concept and operation of computer operating systems (Windows and Dos), the use of office software Word, Excel and PowerPoint, the basic knowledge of computer networks and the common operation of the Internet. 3.C language programming mainly teaches the basic knowledge of computer programming, the basic concepts of C language, sequence structure programming, branch structure programming, loop structure design, functions, pointers, arrays, structures, union, enumeration types, compilation preprocessing, bit operations, files, etc. Master the basic methods and programming skills of C language. 4. Computer Network Fundamentals This course mainly teaches the basic knowledge, related technologies and practical applications of computer networks. The main contents include: computer network overview, network architecture, computer local area network technology, transmission media in the network, network interconnection and Internet technology. 5. Fundamentals of Computer Multimedia Technology This course mainly teaches the basic knowledge of computer multimedia technology. The main contents include: image processing, sound processing, film and television processing, and combining various multimedia elements with Authorware editing and synthesis software. 6. Principles of Operating System This course mainly teaches the basic knowledge of operating system, including process management, storage management, file management, input/output system, interface between users and operating system and introduction of Linux operating system. 7. Graphic image processing This course mainly teaches the use of Photoshop software for graphic image processing. Through systematic study of Photoshop software, students can independently edit, synthesize, correct and adjust the color of images and make simple special effects. 8. Network Security Technology and Prevention This course systematically introduces the main theories, technologies and application knowledge of network security and management. It mainly includes: network security overview, information security mechanism, key distribution and management, virus and preventive measures, system attack intrusion detection, firewall technology, WWW security, e-mail security, security analysis of other Internet applications, network operating system security, etc. (2) Professional core course 1, Vf database application mainly teaches the basic principles of database and the composition of database system; The characteristics, basic operation and data composition of relational database; Take Visual Foxpro as an example, learn the design and development of database, and master the application of database. 2.VB.NET Programming This course mainly teaches the integrated development environment, programming basics, forms and basic input and output, common controls, engineering and program management, application program structure, menu programming, form design and file processing of VB.NET programming language.