Program Overview

University Program: Computer Science Foundation

Introduction

The Computer Science Foundation program is designed according to the latest guidelines from the Ministry of Education's Higher School Non-Computer Professional Computer Foundation Course Teaching Guidance Committee. This program focuses on the teaching needs of non-computer professional students, emphasizing the explanation of basic and practical content, and the cultivation of application abilities.

Teaching Team

The teaching team consists of 6 members:

• 朱江 (Teacher, Information Engineering College, Xiangtan University)
• 曹江莲 (Teacher, Information Engineering College, Xiangtan University)
• 杨晟院 (Teacher, Information Engineering College, Xiangtan University)
• 王婷 (Teacher, Information Engineering College, Xiangtan University)
• 成洁 (Teacher, Information Engineering College, Xiangtan University)
• 唐欢容 (Teacher, Information Engineering College, Xiangtan University)

Teaching Method

The program adopts a multi-dimensional and three-dimensional teaching model, combining lectures and practice in the computer center. The teaching method is designed to maximize learning effectiveness, considering the differences in students' computer foundation levels and the need for personalized talent cultivation.

Course Content

The program covers the following topics:

• 计算机基础知识 (Computer Foundation Knowledge)
• 操作系统 (Operating System)
• Internet应用与信息安全 (Internet Application and Information Security)
• 多媒体技术与多媒体制作 (Multimedia Technology and Production)
• Python程序语言 (Python Programming Language)
• JSP动态网页设计与制作 (JSP Dynamic Web Page Design and Production)
• 高级文字处理和数据处理 (Advanced Text Processing and Data Processing)

Reference Textbooks

The program uses the following reference textbooks:

• 李枚毅 等主编. 大学计算机基础(第3版). 湘潭大学出版社, 2017.8
• 李枚毅 等主编. 大学计算机基础实验指导(第3版). 湘潭大学出版社, 2017.10
• (美)Allen B.Downey 著, 赵普明译. 像计算机科学家一样思考Python. 人民邮电出版社, 2016.8
• 龚沛曾,杨志强主编. 大学计算机(第6版). 高等教育出版社 2013.7

Course Evaluation

The program includes a course evaluation component, where students can provide feedback on the course.

Teaching Resources

The program provides various teaching resources, including:

• Course chapter resources
• Video lectures
• Homework assignments
• Practice exercises

Course Chapters

The program consists of the following course chapters:

1. 计算机概述 (Computer Overview)

• 1.1 计算机发展过程 (Computer Development Process)
• 1.2 数制和编码 (Number System and Coding)
• 1.3 计算机系统 (Computer System)
• 1.4 自测题 (Self-Test Questions)

2. 操作系统 (Operating System)

• 2.1 操作系统概述 (Operating System Overview)
• 2.2 Windows 7操作系统 (Windows 7 Operating System)
• 2.3 自测题 (Self-Test Questions)

3. Internet应用和网络安全 (Internet Application and Network Security)

• 3.1 什么是Internet (What is Internet)
• 3.2 Internet协议 (Internet Protocol)
• 3.3 Internet应用 (Internet Application)
• 3.4 基本的加密方法和数字证书 (Basic Encryption Methods and Digital Certificates)
• 3.5 安全漏洞和网络型病毒 (Security Vulnerabilities and Network Viruses)
• 3.6 网络安全技术和工具介绍 (Introduction to Network Security Technologies and Tools)
• 3.7 自测题 (Self-Test Questions)

4. 多媒体技术 (Multimedia Technology)

• 4.1 多媒体概述 (Multimedia Overview)
• 4.2 多媒体信息的数字化 (Digitalization of Multimedia Information)
• 4.3 PS图像处理 (PS Image Processing)
• 4.4 自测题 (Self-Test Questions)

5. Python程序设计 (Python Programming)

• 5.1 程序设计概述 (Program Design Overview)
• 5.2 Python程序实例分析 (Python Program Instance Analysis)
• 5.3 Python语言的数据类型 (Python Language Data Types)
• 5.4 控制结构与函数 (Control Structures and Functions)
• 5.5 常用库介绍 (Introduction to Common Libraries)
• 5.6 自测题 (Self-Test Questions)

6. JSP动态网页设计 (JSP Dynamic Web Page Design)

• 6.1 环境Eclipse介绍 (Eclipse Environment Introduction)
• 6.2 动态Web项目和JSP动态网页的建立 (Dynamic Web Project and JSP Dynamic Web Page Establishment)
• 6.3 HTML基本语法 (HTML Basic Syntax)
• 6.4 JSP表达式和JSP指令元素 (JSP Expression and JSP Directive Elements)
• 6.5 自测题 (Self-Test Questions)

7. 高级文字处理和数据处理 (Advanced Text Processing and Data Processing)

• 7.1 Word 2010文字与表格处理 (Word 2010 Text and Table Processing)
• 7.2 长文档编辑排版实验 (Long Document Editing and Typesetting Experiment)
• 7.3 Excel主要操作 (Excel Main Operations)
• 7.4 学年综合奖学金评定实验 (Academic Year Comprehensive Scholarship Evaluation Experiment)
• 7.5 大学高考录取分数信息的分析 (University Entrance Examination Score Information Analysis)
• 7.6 自测题 (Self-Test Questions)