Courses:
I. Computer Foundation: 1, system overview; 2. Working principle; 3. Hardware composition; 4. Basic operation; 5. Daily maintenance; 6. printer; 7. Operating system and application software
Second, Chinese and English input: 1, fingering practice, 2, pinyin input; 3, five-stroke input
Third, WIN operating system: 1, secondary source manager; 2. Shortcuts; 3. Manage documents; 4. System tools; 5. Install software and hardware; 6. Input method; 7. Win the net; 8. orchid; 9. Network components; 10, the identifier in the network; 1 1, communication;
Fourth, INR NET and outlook network applications: 1, INR NET settings; 2. browse; 3.nermeering meeting; 4. Chat room; 5. mail; 6. use iuutlook settings; 7. Wordpad; 8. Drawing; 9. entertainment; 10, game.
Verb (abbreviation of verb) Mord document: 1. Document creation, input, editing and saving; 2, fonts, paragraphs, headers and footers, page printing; 3. Form drawing, editing, formatting, flexible editing and application; 4, drawing, inserting artistic words, and mixing pictures and texts; 5. Style application, modification manager and style library; 6. Create a template application modification manager; 7. Atlas, calibration, automatic format and abstract; 8. Customize application charts, data of several years, mathematical formulas, mathematical symbols and templates; 9. Web page creation, editing, dynamic effects and link publishing; 10, document preview, margins, header and footer print range, printer properties;
6. Excel data table: 1, worksheet; 2, data input, filling and sorting, creating a mechanical board; 3. cells; 4. Discovering and replacing management, splitting, freezing and moving; 5. Number format, adjustment and text box; 6. Formula calculation and circular combination, function formula and financial function; 7. Chart creation, modification, adding selection, depth and width; 8. Graphic drawing, insert editing, shadow and three-dimensional effect of calligraphy; 9. Application and creation of PivotTable fields and formats; 10, database, data sorting, classification, summary, variables and planning scheme, operation table; 1 1, worksheet settings, header, footer, margins, pagination printing.
Seven. Powerpoin slide: 1. Create a presentation; 2. Design the template; 3. Prompt the wizard and edit the text; 4. Screening effect; 5, slide layout editing text box; 6. plate type; 7. Color scheme; 8. Motherboard; 9. Headers and footers; 10, insert graphics, GIF animation; 1 1, chart creation, format table operation; 12, add sound, music, movies and videos; 13, page organization screening preparation; 14, set the demonstration effect; 15, playback control.
Eight, Access database: 1, database introduction; 2. Relate to the desktop database for several years; 3. Safety; 4. Database window, data table object of several years, query, form, report and web page object; 5. The wizard creates the database; 6. Design and create new tables, fields, descriptions, data types, keywords, search and filtering, and import linked tables. 7. Modify tables, fields and keyword indexes. 8. Create a column form and add editing, searching and recording; 9. Form editing; 10, data analysis and query; 1 1, Report Wizard, Design Report, Post Label, Modify Report; 12, database compression, repair, encryption and decryption security control.
Nine, Frontpage page: 1, the basic element of the page; 2. Create a new webpage or website; 3. Making and decorating web pages; 4. Font, paragraph and list operations; 5. Preview and save the webpage or website; 6. Image processing text hyperlink; 7. Link to the webpage; 8. Link to email; 9. Popular links; 10, the color of bookmarks and hyperlinks; 1 1, table insertion and editing nesting; 12. Frame creation, attributes and segmentation; 13, form; 14, drop-down list, text box, scrolling text box; 15, button, subtitle, counter; 16, dynamic, animation, filtering effect; 17, navigation view, report view, template and task view; 18, link management; 19, apply for spatial domain name; 20. Check hyperlinks; 2 1, test file; 22.Http protocol publishing website.
X. virus and its treatment: 1. Virus overview; 2. Prevent common viruses; 3. judge the virus; 4.KV3000。 Rising Norton antivirus software; 5. Capture new viruses; 6. Use of debugging.
XI。 Installation and use of common software: 1, netants2. Download and install KV3000, Rising and Jinshan viruses; 3. Download and install the input method; 4，ACDSee。 Heroes look at pictures; 5. Compress WINZIP.
XII. Assembly and debugging of multimedia computer hardware: 1, assembly process; 2.CPU routing; 3. Sound card, network card and graphics card; 4.Atx power supply; 5. Hard disk, floppy disk drive and CD-ROM drive; 6, display, speaker, keyboard; 7. Hardware testing; 8.CMOS settings;
Thirteen. WIN system installation: 1, new hard disk partition FDISK；; 2. High grid format of hard disk; ; 3. Driver installation; 4. Install application software; 5. Win system optimization;
Fourteen, hardware selection and fault handling: 1, CPU sliding frequency reduction, frequency locking, overclocking skills; 2, the motherboard CMOS problem; 3.BIOS upgrade and reset; 4. Memory anti-counterfeiting, fault detection and handling; 5. Hard disk principle, optimizing bad area repair, saving data, overclocking, low grid DM software partition, high grid; 6. The preferred technology trend of display is magnetization color matching and focusing; 7, the principle of graphics card installation; 8, PCA sound card noise and failure; 9, CD-ROM cleaning and failure; 10, speaker optimization; 1 1, common failures of floppy drive; 12, power failure and detection; 13, floppy drive failure; 14, burner application.
Fifteen. Virus and its treatment: 1. Virus overview; 2. Prevent common viruses; 3. judge the virus; 4. Installation and use of 4.KV3000, Rising and Norton antivirus software; 5. Capture new viruses; 6, the use of debugging
16. Internet settings and LAN: 1, mode diagnosis installation and Internet settings; 2. Browse and search; 3.WINZIP compression and download; 4.QQ chat; 5.GHOST application; 6, CD ghost; ; 7. quickly assemble GHOST；; 8. Installation and application of local area network; 9. Hub principle and application; 10, straight line and crosshair; 1 1, local area network internal settings; 12, Internet cafes; 13, Internet cafe maintenance.
Seventeen. Computer network foundation: 1. Computer network foundation; 2. Composition and structure of computer network; 3. Classification of computer networks; 4. Principles and steps of network design; 5. Construction requirements of network integrated wiring when wiring; 6. The production standards of 10M/ 100M and 1000M are adopted for twisted-pair crystal heads; 7. Differences and requirements of stacking and cascading of hubs and switches; 8, 5-4-3 Ethernet wiring principle and implementation; 9. Configuration and function of peer-to-peer network and peer-to-peer network under WIN98/WINZ000/WINXP/WIN2003 system; 10, NETBEUI protocol, IPX/SPX compatible protocol, TCP/IP protocol; 1 1, IP segment division in TCP/IP protocol, IP address classification and reserved address in IP address; 12, the configuration of printer server and the realization of network printing; 13, Methods and implementation of enterprises and Internet cafes accessing the Internet; 12, Application and setting of management software for enterprises and Internet cafes; 13, common peer-to-peer network fault diagnosis and testing.
Eighteen. Configuration and application of WINDOWS2000/2003 server: 1, application of active directory server; 2. install and uninstall the active directory server; 3. Account management settings; 4. Setup and implementation of workstation login active directory; 5. The function, establishment and application of 5.DHCP server; Function, establishment and application of 6.FTP/WEW server: 7. Function, establishment and application of 7.DNS server; Comprehensive application of 8.DNS/FTP/WEB server; 9. Function, establishment and application of enterprise mail (exchange) server: 10, function, establishment and application of DFS distributed server; 1 1, the function, establishment and application of terminal server; 12, setting and application of server backup and recovery; 13, disk quota and disk array setting and application.
Nineteen, Cisco CCNA network engineer certification training: 1, TCP/IP protocol and subnet planning and division; 2. Introduction of 2.OSI network model: 3. Understanding Cisco router interface; 4. Load the IOS system with the console interface of Cisco router; 5. Initialization of 5.CISCO router; 6. The use of four modes and common commands commonly used by Cisco; 7.IP static routing configuration and application; 8.IP dynamic routing (RIP, IGRP, EIGRP, OSPF)4. General password setting of Cisco router; 9. Implementation of remote login router IOS and application of mapping: 10, standard access list); Configuration and application (standard access list); 1 1. Establishment and application of extended access list: 12, backup and recovery of Cisco router configuration; 13, installation and recovery of Cisco IOS system; 14, Universal Network Protocol (HDLC, PPP, Frame Relay, X, 25); 15, loading the IOS system of Cisco switch; 16, Cisco Switch VLAN Branch; 17, the role of Cisco switch trunk.
Twenty, Redhat linux certification training (full-time half a month in 790 yuan; Night shift for one month (790 yuan)
First, UNIX/LINUX basics: 1, introduced by REDHAT; 2. Installation and system partition of 2.REDHAT (SWAP and EXT3); 3. Storage and installation of multiple systems of 3.REDHAT and WINDOWS; 4. Operation and application of 4.REDHAT system; 5. Install common application software (Wu Bi, QQ, etc.) under the Red Hat system. ); 6. The characteristics, security, common settings and applications of the server under the 6.REDHAT system.
Second, the network configuration and application of REDHAT LINUX: 1, the setting of network card under REDHAT system; 2. Interconnection between 2.REDHAT system and WINDOWS system (establishment and application of SAMA server); 3. Configuration and application of FTP server in REDHAT system: 4. Configuration and application of WEB server in Red Hat system: 5. Configuration and application of DNS server in Red Hat system: 6. Configuration and application of 6.DHCP in Red Hat system.
21. Computer Network Security Analysis and Management Training: 1, Computer Network Security Overview; 2. Security technology of computer network information transmission; 3. Setting and application of network server access control: 4. Principle and application of firewall; 5. Installation and application of network proxy server; 6. Internal security technology of operating system; 7. Network security setting and management under Windows 2000/2003 server: 8. Intermediate network security setting and management under Windows 2000/2003 server: 9. Advanced security setting and management under Windows 2000/2003 server: 10, computer network monitoring setting and application1. 12, the common methods of computer network intrusion and the capture of network intrusion users.
Twenty-two, HTWL syntax: 1, tag use; 2. Edit the text panel 3. Tag text format 4. Create table 5. Use layer 6. Other marks.
Twenty-three, Dreamweaver Mx web design: 1, establish the site (determine the nature of the site, determine the storage location, the specific operation of site establishment, and establish the home page); 2. Create site content: (tag usage, text panel editing, four attributes of the page, HTML language); 3. Home page (determine the logo, title and navigation bar of the home page); 4. Web page attributes and components; 5. Insert page contents (pictures, multimedia, horizontal lines, spaces and characters); 6. Hyperlink type (text hyperlink, e-mail link, anchor link, picture link, picture hotspot link); 7. Form establishment (meaning of form control, form attributes, basic operation of form); 8. Layout table; 9. Form creation (HTML code of form, value of form type, format and parameters of form, events of form); 10, the use of basic objects in the form (function, the use of two types of buttons in the form, radio buttons and check buttons); 1 1. Edit the frame page (HTML tag, composition and attributes of the frame page, page set attributes); 12, CSS cascading style sheet (function, concept, features, comparison between CSS and HTML formats, customization of CSS, redefinition of HTML, CSS link style, external CSS); 13, template (concept, function, editing, saving, updating and application); 14, library (concept, function, editing, saving and updating); 15, layer application (concept, function, attribute, layer animation); 16, application of behavior (generation, behavior method, behavior object, behavior action); 17, javascript application; 18, plug-in format, installation application. 19, site management (remote, test server, upload site, manage site).
Twenty-four, FLASH Mx website animation design: 1, simple animation production (drawing tools and menus); 2. Make simple animation (the action of changing position, shape and color); 3, the production of graphics; 4. Frame-by-frame animation (countdown timer, application of flipping frames, background layer, action change); 5. Interpolation animation (key frames, interspersed actions and motion forms) 6. Proximity layer (establishment and production method); 7, mask animation (bottom static animation, bottom moving animation, bottom moving animation); 8, button (function and nature, function, production method, state); 9. Adding sound to animation (mode, format, method of inserting sound, quality); 10, interactive animation (action command, addition calculator, jump, start and stop); 1 1, animation release (mode, format selection, attention)
Twenty-five Fireworks MX website image processing: 1, integrated interface (main menu, toolbox, toolbar, animation panel, item 1); 2. Create an import document; 3. Drawing and editing images (bitmap and vector, entering object mode, drawing objects, drawing free paths, obtaining objects from other software, editing objects, selecting objects, changing the shape of paths, transforming paths and changing the appearance of paths); 3. Color (Web reliable color, color sample panel, transparent background, halo elimination); 4. Use text in graphics (input, edit, import, increase effect, deform, convert text into path and image); 5. Symbols (frame insertion technology, fade-in and fade-out effect, export and import of symbols); 6. Comprehensive examples (photo frame, navigation bar, text mask, drawing complex path objects, picture materials, exporting documents, optimizing documents, slicing and hot spots, fuzzy effects).
26th, PHOTOSHOP image processing: 1. Interface 2. The third floor. Mask and path 4. Filter 5. Images and 3D effects 6. Text design 7. Image synthesis.
27. Comprehensive example of website design: 1, personal website construction; 2. Enterprise website construction; 3.PWS website server; 4. Virtual host and domain name application; 5. Upload and download web pages; 6. Website management and maintenance.
28.SQL SERVER Foundation: 1, the development history and characteristics of SQL SERVER2000; 2. The architecture of 2.SQL SERVER2000; 3. Relational database; 4. Database objects of 4.SQL SERVER2000; 5.SQL and TRANSACT-SQL；; ; 6.SQL SERVER 2000 installation; 7. System database and system table of 7.SQL SERVER2000; 8. Connection and registration of 8.SQL SERVER server; 9. How to use Query Analyzer and Enterprise Manager
29.SQL SERVER operation: 1. Create, view, manage and delete databases; 2. Identifiers, object naming rules and habits of 2.SQL SERVER; 3. Create tables, delete tables, modify tables, view table properties, rename tables and index tables. 4. Select the query, use the TOP keyword and use the DISTINCT keyword; 5. Use calculated columns, manipulate the column names of the query, use WHERE clause, use LIKE clause to fuzzy query, and use ORDER BY to sort the data; 6. Insert data, modify data, delete data, create and delete views, and modify view definitions. 7. Simplify queries with views, add, delete and modify data through views, and encrypt views.
Thirty, the development and improvement of SQL SERVER
1, plastic data type, currency data type, numeric data type, floating-point data type, time and date data type, character data type and user-defined type; 2. Multi-table query and Cartesian product, using table aliases and using union sub-statements; 3. Use statistical functions, GROUP BY, COMPUTE and COMPUTE BY clauses, nesting and other query methods; 4. Data integrity foundation, constraint to realize data integrity, rules, using default values, and using IDENYITY columns; 5. Comments, batch processing, global variables and local variables; 6. Conditional judgment structure and circulation structure; 7. Cursor and transaction; 8. Mathematical functions, string functions, date functions, other functions and user-defined functions; 9. Overview of usage management and triggers of stored procedures; 10, use and management of triggers, and special functions of triggers.
3 1. Database management: 1, standard login mode, integrated login mode, database security, roles and permissions; 2. Database backup and database recovery; 3. Import and export of data of different or same database types, separation and connection of databases.
Thirty-two, the basis of ASP: 1, the configuration of ASP development environment is the configuration of server: the selection of Html markup language, code writing tools, scripting language, operating system, server configuration and database selection; The application scope of 2.ASP (developing websites and information management systems); Tools and applications for developing websites in 3.ASP (Html markup language, tools for developing web pages, tools for processing pictures, tools for making animations, scripting language, configuration of development environment, use of ASP built-in objects, use of ADO components, development of database).
Thirty-three, VBScript and JavaScript: 1, the role, definition and use of constants and variables; 2. Data type; 3. Use operators and operator priorities; 4. Control statement (if it is conditional control, select the conditional control statement, and for the next loop control statement, Do...Loop loop control statement, Exit forcibly exits the loop statement); 5. Processes and functions (definition and use of Sub, definition and use of functions, use of commonly used built-in functions).
Thirty-four, the use of ASP built-in objects: 1, request objects, methods, collections, properties; 2. Session objects, methods, sets and attributes (life cycle and scope of session variables); 3. Application objects, methods, sets and attributes (life cycle and scope of application variables); 4. Server objects, methods and properties; 6. Objects, methods and properties.
35. ADO component: 1, connecting object; 2. Recordset object; 3. Command object
Nine. Database: 1, select; 2. Update; 3. Insert; 4. Delete; 5, SQL Server 2000 database installation, use methods and skills; 7, Access database installation, use methods and skills.
Thirty-six, display the data in the database: 1, use the connection object of ADO component to connect to SQL Server database and
Access the database; 2. Use the Recordset object of ADO component to manipulate the data table; 3. Use loop statements to loop a large amount of data.
37. Establish a member management module: 1, and establish a user database; 2. Member registration (submission of form data, two methods of using Insert to insert statements in ASP, using ASP's built-in object request and response, button response event to limit input content, and using scripting language; 3. Modification of member information, two methods of using Update to modify statements in ASP, and using Include method to call public files; 4. Administrators with super permissions delete member information; Use Delete statement to delete data in ASP: 5. Member login: display the IP address of the member online and use the property ServerVariable of the request object. Login control, using Session object to realize that members are not allowed to open pages before logging in.
Production of message system: 1, establishment of message data table; 2. Code for creating message boards; 3. Use Session object to prevent the content of repeatedly submitted emails from being refreshed; 4. Use XXX desc order to display the latest news at the beginning; 5. The administrator deletes illegal messages.
39. Make a counter: 1, and use an application to make a counter; 2. use the Global.asa file; 3. Application of On_strat () and On_end () processes of application programs and session objects; 4. Use Cookies as counters; 5. Make counters with counter components.
Forty, the production of chat room: 1, using session2, using the program.
41. Production of voting system: 1, design of database; 2. Make a display page; 3, the production of voting page
Forty-two, news release system: 1, news release system process analysis; 2. Code for creating a news release system; 3. Administrators publish, delete and modify news online.
Forty-three, the production of community forum: 1, the process analysis of the whole website; 2. Create the interface and code of the movie website; 3. Realize the online management of the website.
44. Visual Basic: 1, design steps; 2. Run the program; 3. Basic characteristics, visual design and event-driven programming of 3.Visual Basic application; 4. The difference between 4.Visual Basic and other visual programming tools; 5. Install the Chinese version of Microsoft Visual Basic6.0.
45.Visual Basic6.0 integrated development environment: 1, menu bar; 2. Toolbar 3. Toolbox; 4. Code editing window; 5. Project window 6. Property window; 7. Form; 8. Object and event driven; 9. Basic development methods of 9.Visual Basic6.0 applications (interactive development, working mode of event-driven applications; 10, application development example (creating application interface, setting properties, writing code, saving application, debugging, running application, generating executable file)
46.Visual Basic programming: 1, data type (variables and constants, integer data, floating-point data, currency type, string, variable data, date data, data type conversion, array, record); 2. Expressions and operators (arithmetic operators, string operators, relational operators, logical operators, special operators, operator priorities and statements); 3. Program flow: branch, conditional judgment, loop, idle loop, Do event function and common standard function 4. Application example.
47.Visual Basic forms and basic input/output: 1, forms; 2. Use the printing method; 3. Format function and area recognition; 4.Tab and Spc functions; 5.InputBox function; 6.MsgBox functions and statements
48.Visual Basic common controls: 1, labels: common properties, click events, and other uses of label controls; 2. Text box): MultiLine attribute, SelStart attribute; 3. Command buttons and public attributes; 4. Picture frame: the special attribute of picture frame and painting event; 5. Framework; 6. Option button; 7. check box; 8. List box; 9. Combo box; 10, scroll bar; 1 1, timer; 12, common conversations; 13, image control
49. Visual Basic Engineering and Program Management: 1, Visual Basic Engineering Structure; 2. Create, open and save the project; 3. Use multiple projects; 4. Add, delete and save files; 5. Use documents in the project; 6. Make and run executable files; 7, set the engineering properties; 8. Use wizards and external programs.
50. The structure of Visual Basic application program: 1, module; 2. process; 3. Debugging of the program (error example, error type of Visual Basic6.0, debugging window, breakpoint debugging).
5 1.Visual Basic menu programming: 1, menu code design; 2. Advanced application of menu (effective attribute, visible attribute, menu control array, check attribute, dynamic menu, pop-up menu, separator design); 3. Toolbar design (using application wizard to create a toolbar, using toolbar controls to create a toolbar); 4. Design and use of status bar
52.Visual Basic Form Design: 1. Using ActiveX controls to design the interface of forms and multi-form programs; 2. Multi-document interface programming
53. Visual Basic file processing: 1, file controls (DriveListBox control, DirListBox control, FileListBox control, CommDialog control); 2. Use file control to process files; 3. File processing functions of 3.Visual Basic 6.0 (Kill statement, FileCopy statement, Shell function); 4. File system (sequential file, random file, binary file); 5.FileSystemObject programming.
54. Database technology: 1, database connection (ADO control binding); 2. Database connection module; 3, login, registration, query interface, database modification and deletion function realization, data report and program release.
55.Visual Basic comprehensive development experiment course: 1, Visual Basic interface design; 2. Forms and input/output; 3. Use and programming of 3.Visual Basic controls (including procedures). Implementation of calculator; 5. typing game design; 6, WORD design 7, book lending query system (26 hours)
56..NET framework: 1, content. NET framework; 2. Namespaces and classes; 3. Compilation. Network application; 4. The execution process of the controlled program; 5..NET framework utility
57..NET universal type system: 1. General type system overview; 2. Value type and reference type
58..NET strings, arrays and sets: 1, strings; 2. Setting and arrangement; 3. array; 4. Common collection types; 5. Create and manipulate collections
59..NET object-oriented technology: 1, properties and methods; 2. Encapsulation, inheritance and polymorphism; Step 3 connect
60..NET reads and writes data streams and files: 1, streams; 2. Readers and writers; ; 3. File input and output operations
61. Using ADO.NET to access data: 1, an overview of ADO.NET; 2. Connect the data source; 3. use DataReader to retrieve data; 4. Use stored procedures; 5. use DataSet and DataAdapter to retrieve data.
Sixty-two, use ADO.NET to modify the data: 1, and use the command object to modify the database; 2. Update the database with DataAdapter and DataSet; 3. Operation data sheet
Sixty-three, ADO.NET advanced theme: 1, DataRelation；; 2. Master-slave table 3, XML and data set
64..NET Web service: 1. Introduction of network services; 2.Web service invocation; 3. Write a simple Web service
65. The high-level theme of. NET: 1, event and delegation; 2. Use events; Step 3 launch an activity
66..NET application deployment: 1,. NET framework deployment foundation; 2. Introduction of deployment plan; Step 3 Deploy the instance
Sixty-seven NET experimental course: 1, ordinary operation; 2. Strings, arrays and collections; 3. Create and use classes; 4. Data flow and file operation; 5. Use ADO.NET to obtain data; 6. Use ADO.NET to modify data; 7. Realize the master-slave relationship of tables; 8. Create and use WEB services; 9. Deploy Windows applications.
Sixty-eight, graduation design, professionalism, job hunting skills, exam review, employment recommendation.
Certificate:
1, diploma in computer network and software engineering, College of Technology, Trade and Technology, Guangzhou University.
2. Graduation certificate of "Computer Network and Software Engineering" of Guangzhou Zhongwei Vocational Training School.
3. You can apply for national technical qualification certificates such as computer office automation, microcomputer system maintainer, computer network administrator, multimedia works producer and computer programmer.
4. You can apply for international IT certification such as Microsoft Certified Office Expert, Cisco CCNA Certified Network Engineer, Macromedia Certified Website Designer, Microsoft Database Certified Expert, ASP Programmer, REDHAT Linux System Engineer, VB Programmer, etc. NET programmer.
Employment direction:
After graduation, students majoring in this major can engage in office automation processing, computer installation and maintenance, web page making, computer network and professional server maintenance and development, dynamic business website development and management, software testing and development, and commodity trade of computer-related equipment.
, ize: 10.5pt "> 1, menu code design; 2. Advanced application of menu (effective attribute, visible attribute, menu control array, check attribute, dynamic menu, pop-up menu, separator design); 3. Toolbar design (using application wizard to create a toolbar, using toolbar controls to create a toolbar); 4. Design and use of status bar
52.Visual Basic Form Design: 1. Using ActiveX controls to design the interface of forms and multi-form programs; 2. Multi-document interface programming