计算机专业英语课程标准,计算机专业英语课程教与学

原标题：计算机专业英语课程教与学

划重点

活动规则

课程配套教材

提供PPT、教学大纲、考卷

适合高校大学生和研究生计算机技术基础(计算机导论)课程的双语或全英语教学

作者：江红、余青松

定价：49.50元

ISBN：9787302473190

授课老师可以在书圈申请样书

样书申请

课程教学大纲

课程名称(中文)：信息技术基础(全英文)

课程名称(英文)： Fundamentals of Information Technology

课程性质：(通识必修、通识选修、学科基础、专业必修、专业选修、教师教育)

学分：2+2

学时：72，其中理论学时：36，实践(实验)学时：36

授课对象：中法工商管理创新实验班

授课语言：英文

开课院系：计算中心

课程网址：大夏学堂

https://elearning.ecnu.edu.cn/webapps/blackboard/execute/modulepage/view?course_id=_360_1&cmp_tab_id=_706_1&editMode=true&mode=cpview

撰写人：江红

一、课程简介(英文)

Deion

This Course is designed to enablestudents to use Information Technology (IT) systems and applicationsindependently to support a range of information processing activities. It isdesigned to develop a broad knowledge of the theoretical concepts, principles,boundaries and scope of IT applications. These activities will be centred onusing software applications packages (Windows, Word, Excel, PowerPoint, HTML,Access) to meet complex information requirements while paying attention tosecurity and the needs of other users.

二、课程目标

Objectives

On completion of the Course thestudents should be able to:

1. Operate a range of IT equipmentindependently, giving attention to security and to other users.

2. Use a range of softwareapplication packages to meet complex information requirements.

三、教学内容、学时分配和作业要求

subject deion(includingaims and objectives)

This Course provides a general and practical introduction to information technology for students in all disciplines. it consists of the following modules:

(1)theory one: fundamental principles of information technology, the usage of application software, the basic concept of system software;

(2)theory two: fundamental principles of computer operation, the main hardware components of the computer, hardware selection and evaluation, data storage and retrieval;

(3)theory three: introduction to data communications, the internet, the web and electronic commerce;

(4)introduction to Windows Operations;

(5)introduction to Word Processing;

(6)introduction to Spreadsheets;

(7)introduction toPowerPoint Presentation;

(8)introduction to the world wide web and Web Page Design; and

(9)introduction to Databases.

Learning Outcomes

Including:

1. Students who complete successfully this subject will have knowledge and understanding of:

·The five parts of an information system: people, procedures, software, hardware, and data;

·Common features of most software applications;

·The differences between system software and application software;

·Basic functions of any operating system;

·The purpose of utilities and utility suites;

·the main hardware units of a computer, how they work, how they are interconnected and how processing is controlled in computers;

·input and output methods;

·how data is stored internally and externally;

·storage media;

·data communications and networking;

·Internet providers, connections, and protocols;

·Functions of the internet, the usage of search tools;

·Web utilities including Telnet, FTP, plug-ins, and helper applications;

·Electronic commerce including Web storefronts, auctions, and electronic payment;

·HTML language;

·The causes of some common software and hardware problems, (e.g. cable connections, device settings, software option settings) and what action to take to resolve these;

·Assessing information requirements and designing solutions using IT.

2. Students who complete successfully this subject will be able to:

·Use the tools within the operating system, e.g. file managers, print managers and control panels);

·know the ways in which data can be kept secure, (e.g. encryption, passwords, back-ups, virus protection) and how security procedures can be used to meet the needs of all users of a computer system;

·use Word processing;

·use Excel (functions, absolute and relative referencing, graphs);

·use PowerPoint;

·use Access (create tables, develop queries and reports);

·integrate data types within and/or from more than one software application package(s);

·extract and present relevant information from suitable local and remote computer data sources, and

·develop web pages using HTML.

Assessments

Assignment 1 (Windows) 2 %

Assignment 2 (Word) 3 %

Assignment 3 (Excel) 4 %

Assignment 4 (PowerPoint) 3 %

Assignment 5 (HTML) 4 %

Assignment 6 (Access) 4 %

Mid-term Tests 20 %

Final Exam 60 %

---------

100 %

======

Recommended TEACHING Hours

4 class hours / week over an 18-week teaching period (2 class hours for final examination). Total class hours = 17*4+2=70Weekly Teaching Guide

Week

Topics

Readings/HOMEWORK

PRACTICE

1

Introduction To Information Technology & System Unit

Ch.1

Windows Practical(1)

2

Software: Operating Systems & Application software

Ch.2 & Tutorial 1(CPU)

Windows Practical(2)

3

Word Processing

Ch. 5 & Tutorial 4(OS)

Word Practical

4

PowerPoint Presentations

PowerPoint Practical

5

Introduction to spreadsheets: general spreadsheet design, absolute and relative formulas, function

Ch 6 (1)

Lab-1 (Excel)

6

Excel case study-1

Ch 6 (2)

Lab-2 (Excel)

7

Chart characteristics and design, financial functions，Excel case study-2

Ch 6 (3)

Assignment–1 (Excel)

8

Input and output devices & Secondary storage

Ch.3 & Tutorial 2(I/O)

Ch 4&Tutorial 3(storage)

Revision 1~4(Excel)

9

Mid-term Test

10

Introduction to WWW

Ch 9 (1) &

Tutorial 6(Networks)

Lab-3(HTML)

11

Constructing Web Pages-- Structure of a HTML document

Ch 9 (2)

Lab-4(HTML)

12

Constructing Web Pages - Tables & Images

Ch 9 (3)

Assignment-2(HTML)

13

Data communications: needs, fundamentals, equipment, connectivity

Ch 8 & Tutorial 5

(Communications)

Revision 1~4(HTML)

14

Databases - Concept of a database

Access: Introduction to Access

Ch 7 (1)

Lab –5(Access)

15

Access: Queries from Access

Ch 7 (2)

Lab –6(Access)

16

Access: Reports from Access

Ch 7 (3)

Lab–7(Access)

17

Computers and Society & Revision

Ch 10

Revision 1~4

Assignment 3

(Access)

18

Final Examination

Teaching Schedule:

Times

Ch1

Ch2

Ch3

Ch4

Ch5

Ch6

Ch7

Ch8

Ch9

Ch10

Exam

Sum

Lectures

2

4

2

4

2

6

6

4

6

2

38

Practices

10

10

10

2

32

四、教材、参考书目或其他学习材料

计算机专业英语教程(第2版)，江红主编，清华大学出版社，2017.8. ISBN：9787302473190

(美)Timothy J. O'Leary,Linda I. O'Leary 著，计算机专业英语(Computing Essentials)，北京：高等教育出版社，2012. ISBN：9787040115451

MID-TERM Examination (TEST)

(Structure)

Section A: Windows Operations (40 marks)

The students are required to carry out any of the following tasks:

lFile management

lUse Print Manager

lBack up files

lSet passwords

lUse virus protection software

lResolve hardware problems

lResolve software problems

Section B: Word Processing (30 marks)

Section C: PowerPoint (30 marks)

Final Examination (Structure)

Section A: twenty multiple choice questions x 1 mark each = 20 marks, five fill-in-blanks x 1 mark each = 5 marks

Section B: five matching questions x 1 mark each = 5 marks

Section C: five calculation questions x 2 marks each = 10 marks

Section D: ten excel analytical questions x 2 marks each = 20 marks

Section E: one html analytical question x 20 marks each = 20 marks

Section F: four access analytical questions x 5 marks each = 20 marks

Total= 100 marks

六、教学和实践环境要求：

Lecturing and Practicing Requirements:

lComputer+ Data projector

lSpeaker+ microphone, etc., multimedia devices

lLocalArea Network

lWindows7 (English Version)

lOffice2013 (Word, Excel, PowerPoint, Access) (English Version)

lWINRAR

lAuthoringTools: Dreamweaver, FrontPage, etc.返回搜狐，查看更多

责任编辑：