CS105 - Department of Computer Science | Southern Illinois University Carbondale

CS105
Introduction to Application Software

Catalog Description

This course is designed to provide a detailed exposure to various computer applications software including word processing, database management, spreadsheet, presentation, Web design software, and programming concepts. The course is designed to help students to better use the computer as a tool in their own fields and to help prepare students for Microsoft Office Specialist Certification examinations.

Objectives

The objectives of this course are (1) to make sure, through plenty of hands-on experience, that students are able to perform the standard skills which are required by MS Office specialist certification in Word, Excel, PowerPoint, Access, and Outlook; (2) to learn how to properly organize, manage, and protect their data files and e-mails; (3) To learn how to customize a software user interface to fit each user's needs and preferences; (4) To be aware of some software-related issues, such as, copyright, plagiarism, and malware; (5) to form good habits and understanding in order to use new software properly.

Course Outline

There will be two exams and 12 lab assignments during the course of the semester		Lectures	Labs
1.	Introduction to Windows Operating Environment a) Windows Interface (i) Customizing the Desktop b) Windows Explorer (i) Disk management functions (ii) File management functions c) Text and Graphics tools d) Explorer and Outlook e) Email and attachments	3	1
2.	Essential Computing Concepts Input, processing, output, storage	2	1
3.	Introduction to Word Processing a) Creating and editing text (i) Text and document formatting b) WordArt and graphics c) Merging documents (i) Mail merge (ii) Envelop addressing d) Printing and printing options e) Using Web features	2	2
4.	Introduction to Spread Sheet a) Designing and creating a worksheet b) Using formulas and functions c) Absolute and relative reference d) Creating and editing macros e) Creating and editing charts f) Optimization and goal seeking g) Adding graphics to a worksheet and charts h) Linking and embedding i) Printing and printing options (i) Using web features	5	3
5.	Introduction to Database Management a) Planning and creating a database b) Creating database objects c) Creating a table using wizard d) Creating a table by importing data e) Manipulating a table f) Relating multiple tables g) Creating and modifying queries h) Creating queries using SQL i) Creating and modifying forms j) Creating and modifying reports (i) Sorting and grouping (ii) Calculated control k) Importing and exporting data l) Printing and printing options	5	3
6.	Introduction to Presentation Software a) Creating and editing a presentation b) Using master slide and templates c) Transitions and effects d) Presentations as web pages e) Presentations as web pages f) Creating a web page using HTML g) Web development tools (i) Microsoft Front page	5	2
7.	Introduction to HTML & World Wide Web	4	2
8.	Introduction to Outlook	1	1
	Total	27	15

Webmaster - EOE Link - Privacy Policy Last Update: May 2008