Computer Fundamentals and Application Technology Syllabus | Generated by AI
Question: Please translate the full syllabus of the Guangdong Higher Education Self-Examination course “Computer Fundamentals and Application Technology (Practical)” (Course Code: 13808) into English and format it neatly.
Answer:
Guangdong Higher Education Self-Examination
Course: Computer Fundamentals and Application Technology (Practical)
Course Code: 13808
I. Assessment Objectives
This course aims to develop students’ foundational computer knowledge, practical operational skills, and application-oriented thinking. Students should master basic hardware/software operations and proficiently use office software and network tools to solve real-world learning and work problems. Specific objectives:
- Master the basic operation logic and core functions of the Windows operating system, independently complete file management, system settings, etc.
- Proficiently use office software (Word, Excel, PowerPoint) for document processing, data analysis, and presentation creation in real scenarios.
- Possess basic computer network application skills, including standardized use of browsers, email, information retrieval, file transfer, and collaboration.
- Develop a practical mindset of “identifying problems → analyzing problems → solving problems”, handle common software issues (e.g., file saving errors, formatting issues), and ensure complete workflows and accurate results. This lays the foundation for further professional studies and workplace applications.
II. Reference Textbook
Computer Fundamentals and Application Technology, edited by Bao Peiming, China Machine Press, 2023 edition.
III. Assessment Content
The assessment focuses on practicality and foundational skills, covering five core practical modules:
- Windows Operating System Basic Operations
- File management: create, copy, move, delete, rename files/folders; search by name/type/size; set file attributes (hidden, read-only)
- System settings: change desktop background, taskbar position; add/switch input methods; adjust screen resolution
- Built-in accessories: use Notepad, Calculator, Snipping Tool
- Word Document Processing
- Text editing and formatting (font, paragraph alignment, line spacing, indentation)
- Structured layout: apply styles, insert/edit tables (merge cells, adjust size, borders/shading)
- Graphics and text mixing: insert images/shapes, text wrapping, headers/footers, page numbers, margins, paper size
- Excel Spreadsheet Processing
- Data entry and formatting (number, date, text); merge/clear cells
- Formulas and functions: basic arithmetic (+, -, *, /); common functions (SUM, AVERAGE, COUNT, VLOOKUP, IF, etc.)
- Data processing: sorting (single/multiple conditions), filtering (auto/advanced), conditional formatting
- Data visualization: create and customize charts (column, line, pie, etc.)
- PowerPoint Presentation Creation
- Slide management: insert/delete/copy slides, apply layouts
- Content editing: text formatting, insert images/audio/video, animation effects
- Playback settings: transition effects, custom shows, rehearsal timing
- Advanced: slide master, hyperlinks
- Basic Network Applications
- Browser operations (Chrome/Edge): navigate websites, bookmark, download files, clear cache
- Email: send/receive/reply/forward messages with attachments (webmail or Outlook)
IV. Exam Structure (Total: 100 points)
All questions are practical hands-on tasks performed on the computer:
-
Basic Operations (1 question, 20 points)
Windows file management + browser/email tasks; submit screenshots or files as proof. -
Word Document Processing (1 question, 30 points)
Comprehensive document creation (text, formatting, tables, images); save as .docx with specified name. -
Excel Spreadsheet Processing (1 question, 30 points)
Data entry, formulas/functions, sorting/filtering, conditional formatting, charting; save as .xlsx. -
PowerPoint Presentation (1 question, 20 points)
Create a complete multi-slide presentation (5–8 slides) with animations, transitions, hyperlinks; save as .pptx.
V. Exam Requirements
- Format: 100% on-computer practical exam (no written paper)
- Duration: 90 minutes
- Coverage: All 5 modules must be tested
- Difficulty distribution: Easy 20%, Moderately easy 35%, Moderately difficult 35%, Difficult 10%
VI. Exam Environment Requirements
- OS: Windows 10
- Software: Microsoft Office 2019 Professional (Word, Excel, PowerPoint)
- Browsers: Google Chrome & Microsoft Edge (clean, no extensions)
- Built-in tools: Notepad, Calculator, Snipping Tool
- Network: Local network + limited internet access (only allowed exam-related sites)
VII. Important Notes
- Save work frequently
- Files must be named exactly as required (e.g., “CandidateName_Excel.xlsx”) and saved to the specified folder (usually D:\Exam Files)
- Incorrect naming or path = loss of marks
VIII. Sample Questions (Translated Examples)
-
Basic Operations Sample
Create a folder, copy specific .docx files, rename one, then use Edge to visit 163.com, bookmark it, and download a headline image. -
Word Sample
Create a “University Computer Fundamentals Course Report” with specified title formatting, body text, a 3×2 table of knowledge points, proper alignment, and save as “CandidateName_CourseReport.docx”. -
Excel Sample
Enter student score data, calculate total score (30% usual + 70% final), use AVERAGE, sort descending, apply green/red conditional formatting, insert a clustered column chart, save as specified. -
PowerPoint Sample
Create a 6-slide “Smart Bracelet X1 Promotion” presentation with title slide, content slides, wipe animations, fade transitions, hyperlink from price slide back to appearance slide, and save correctly.
References:
- Original Chinese syllabus provided by the user (Guangdong Self-Examination Office, course 13808)