Computer Application Foundation Exam Modules | Generated by AI
English Explanation of the Exam Content
Major: Computer and Applications (Professional Code: A080701)
This is a vocational college (专科) level computer skills examination in China, typically for the “Computer Operation” or “Computer Application Foundation” certification test. It consists of 5 main modules:
1. Word Editing and Formatting
Focus: Mastering text layout and formatting skills in Microsoft Word.
Tasks:
- Format a given short article, including:
- Font formatting (font type, size, bold, italic, color, etc.)
- Paragraph formatting (alignment, indentation, line spacing, bullets/numbering, borders, shading, etc.)
- Common requirements: title centering, first-line indent, section headings, page setup, headers/footers, etc.
2. Excel Data Processing
Focus: Using formulas and functions to process table data in Microsoft Excel.
Tasks:
- Insert/delete rows and columns
- Use formulas and functions for calculations (e.g., SUM, AVERAGE, IF, VLOOKUP, COUNTIF, etc.)
- Data sorting, filtering, pivot tables (sometimes included)
- Create charts based on data
Typical scenario: Given a raw score table or sales data, calculate totals, averages, rankings, etc.
3. Programming
Focus: Ability to write, debug, and run programs.
Language usually used: C language (most common in this exam)
Typical question example (as in your text):
Write a program to calculate the sum of the first 50,000 terms of the alternating harmonic series:
S = 1 − 1/2 + 1/3 − 1/4 + 1/5 − 1/6 + …
Output the result with 4 significant digits.
Key requirements:
- Correct loop structure
- Proper handling of alternating signs (+/−)
- Use float/double data type
- Control precision output (usually printf(“%.4f\n”, s);)
4. Database Application
Software used: Microsoft Access (most common in this exam)
Tasks:
- Create a new database
- Create multiple data tables
- Set primary keys
- Establish relationships between tables (one-to-many, etc.)
- Enter data
- Design and run queries (select queries, parameter queries, crosstab queries, etc.)
- Create forms and simple reports
5. Network Technology
Focus: Basic networking knowledge and Windows network operations
Content includes:
- Basic concepts: IP address, subnet mask, gateway, DNS, OSI model, TCP/IP
- LAN vs WAN, common devices (router, switch, hub)
- Windows network connection setup:
- Set static/dynamic IP
- Share files and printers
- Map network drives
- Ping command, ipconfig, etc.
Mostly theoretical questions + simple practical operations.
Summary
This exam is a comprehensive practical test of basic computer office and application skills, very common for Chinese vocational college students (especially non-computer majors). The full score is usually 100 points, divided roughly as:
Word ≈ 25–30 pts
Excel ≈ 25–30 pts
Programming ≈ 20 pts
Access ≈ 15–20 pts
Network ≈ 10 pts (mostly theory)
All tasks are completed on the computer within a limited time (usually 90–120 minutes). Passing score is typically 60 points.
If you need sample questions, templates, or practice files for any of these five parts, feel free to ask!