The University of Tennessee at Martin

Department of Computer Science and Information Systems

Computer Science 201

Introduction to Computer Applications

(Effective Fall 2002)

 

 

PREREQUISITE: None

 

CATALOG Concepts of computer systems and procedures including software

DESCRIPTION: applications, input and output, data storage, communications and networks, internet and world wide web, and operating systems and system software. Emphasis on using integrated software tools on the microcomputer which include word processing, spreadsheet, database, presentation graphics, communications, web browsers, electronic mail, personal information management, and multimedia authoring. Credit may not be received for both Comp Science 200 and Comp Science 201. Credit does not apply to computer science major or minor requirements.

 

OBJECTIVES: The student will:

1.       Be familiar with terms and concepts of a computer system: notions of hardware, software, storage, files, records, fields, filenames, hardcopy, softcopy, communication.

2.       Understand the fundamentals of computers and computer nomenclature, particularly with respect to personal computer hardware and software, and the World Wide Web.

3.       Be exposed to the general procedures necessary to have the computer accomplish an objective.

4.       Understand the fundamentals of using Windows 2000 and Windows Explorer.

5.       Understand the fundamentals of word processing to create a cover letter and resume, and create a research paper with a table.

6.       Understand the fundamental concepts of a LAN and WAN and the software/hardware necessary for a LAN and Internet System.

7.       Understand the concepts of a spreadsheet and how to manipulate the entries, up to the use of simple understanding of macros.

8.       Understand the concepts of a simple database and how to build a file, access a file or files and to output information depending on files.

9.       Understand the fundamental concepts of software packages and the impact they have on the working community.

10.   Understand the use of multimedia presentations using power point.

11.   Understand how to schedule and contact management using Outlook.

12.   Understand the different platforms (including the apple system) and supporting software.

13.   Make use of the World Wide Web as a repository of the latest information and as an integrated learning tool.

14.   Understand strategies for purchasing, installing, and maintaining a personal computer.

15.   Integrate Microsoft Office XP applications.

 

TEXTS: CS201 Shelly Cashman Series Kit, ISBN: 0-619-15331-8, Discovering Computers 2003 Concepts for a Digital World Web and XP Enhanced Complete by Shelly, Cashman, and Vermaat and Microsoft Ofice XP Introductory Concepts and Techniques by Shelly, Cashman, and Vermaat, Course Technology, 2002

 

 

CS 201 continued

 

OUTLINES

 

Text: Discovering Computers 2003 Concepts for a Digital World Web and XP Enhanced Complete by Shelly, Cashman, and Vermaat

Chapter

Title

Period

(50 minutes)

1

Introduction to Computers

1

2

The Internet and World Wide Web

2

3

Application Software

1

4

The Components of the System Unit

1

5

Input

1

6

Output

1

7

Storage

1

8

Operating Systems and Utility Programs

2

9

Communications and Networks

2

10

E-Commerce

1

11

Computers and Society: Home, Work, and Ethical Issues

1

12

Computers and Society: Security and Privacy

2

13

Databases and Information Management

1

14

Information System Development

1

15

Program Development and Programming Languages

1

16

Computer Careers and Certification

1

Appendix

Coding Schemes and Number Systems

1

 

TEXT: Microsoft Office XP Introductory Concepts and Techniques Shelly Cashman Series

Chapter

Title

Period

(50 minutes)

COM 17 COM 30

Essential Introduction to Computers

1

INT 1.01- INT 1.77

An Introduction to Windows 2000 Professional and Office XP

2

WD 1.03 WD 3.66

WDW 1.01 WDW 1.14

Microsoft Word 2002

Project ONE, Project TWO, Project THREE, and Web Feature

4

E 1.03 E 3.79

EW 1.01 EW 1.15

Microsoft Excel 2002

Project ONE, Project TWO, Project THREE, and Web Feature

5

A 1.03 A 3.58

AW 1.01 AW 1.10

Microsoft Access 2002

Project ONE, Project TWO, Project THREE, and Web Feature

5

PP 1.03 PP 2.64

PPW 1.01 PPW 1.13

Microsoft PowerPoint 2002

Project ONE, Project TWO, and Web Feature

2

O 1.03 O 1.55

Microsoft Outlook 2002

1

I 1.04 I 1.48

Office XP Integration

1

Hour Exams 3 ___

Total Periods 45

 

Comprehensive Final (given during Final Exam week)

** The order of the presentation will be at the discretion of the instructor.