Honolulu University Course Outlines-Information Technology Curriculum

CS 460 Symposium II - Applications Emphasis 30 credit hours
Online Distance Learning at Honolulu University

COURSE OBJECTIVES: Upon completion of this course, you will be able to:

1) Demonstrate basic computer application techniques and skills.
2) Format documents using current word-processing software.
3) Create, and use spreadsheets to perform spreadsheet operations.
4) Plan and implement spreadsheet charts.
5) Integrate spreadsheet, database, and word-processing applications.
6) Use presentation techniques.
7) Create, and use databases to perform database operations.
8) Use computer network to communication purposes.

COURSE OUTLINE:

1.Word processing

1.1. What is word processing
1.2. Getting started and word environment: Elements of word window such as title bar, toolbars, status bar, menu bar, document window, insertion point, mouse pointer
1.3.Setting up pages
1.4.Entering text
1.5. Formatting attributes for text/paragraphs
1.6. Special symbols, bullets and numbering
1.7. Tables and cells
1.8. Adding graphics into a document
1.9. Mail Merge features
1.10. Print a document
1.11. Introduction to the use of Wizards & Templates

2. Spreadsheet Applications

2.1. What is spreadsheet, workbook and worksheet
2.2. Cell entries
2.3 Editing cell entries
2.4. Use formulas and Functions
2.5. Charts
2.6. Printing worksheets and Charts
2.7. An introduction to the use of advanced spreadsheet concepts

3. Database Applications

3.1. What is a database? Planning and Creating a blank database
3.2. Objects in a database window- tables, queries, forms, reports
3.3. Data tables - Fields, Records, Primary key and field properties
3.4. Working with tables
3.5. Working with simple queries and filtering records
3.6. Working with forms
3.7. Creating/Design a forms
3.8. Database wizard

4. Presentation Applications

4.1. Introduction to Presentations
4.2. Creating a new Presentation
4.3. Different slide views: Inserting, deleting and copying slides
4.4. Adding special effects: animation, transition, multimedia
4.5. Action buttons, hyperlink
4.6. Slide Master
4.7. Printing Presentations, Notes and Handouts

5. Internet usage & Web Authoring

5.1. Introduction to Internet
5.2. Internet facilities - email, File transfer, online updates
5.3. Searching information on World Wide Web
5.4 Introduction to HTML and Web Development: creating an HTML document, making headings, adding textual paragraphs, creating a hyperlink, using graphics and icons, customizing with color, tables, frames-designing a frameset, forms-designing forms, collecting special information with forms
5.5. Use of a Web Development tool

6. Computer Viruses

6.1. An overview of Computer viruses: What is a virus? Virus symptoms, How do they get transmitted? What are the dangers, general precautions, implementing precautions

COURSE ACTIVITIES: In order to use our time wisely within the term, adherence to the following completion schedule of activities is suggested:

COURSE PREREQUISITE: A bachelor's degree is the minimum requirement for admission to this course of study.

COURSE DELIVERY: This course shall be delivered completely through online interaction via the Internet or other acceptable distance learning medium(s). Due to this being a non-traditional program, traditional classroom residency is not required. Therefore, you are expected to independently read and analyze the subject matter with me performing the roles of an advisor and mentor.