Office Hours: TBA

Office Hours: TBA

Class Location: TBA

Class Hours: Mon/Wed 5:00 - 6:20 PM

Lab Location: TBA

Lab Hours: Mon/Wed 6:30 - 9:20 PM

Open Lab: Thu 5:00 - 7:50 PM

Students will attend any one lab session per week

About the Course

This course is designed to give concept and hands-on experience of computer applications on Word Processing, Spreadsheet, and Databases, and integration of the applications. The course provides individuals with the opportunity to develop personal projects in varieties of current software mentioned above, which cannot take place in courses where time is given to learn a software package, but not to use it for personal project design and implementation. The course is suitable for all types of students, not only for CSE, who need to learn computer applications for their personal projects and want to get a better job, as well as for employees who want to improve their skills in these areas.

The following is a tentative list of topics which we will attempt to cover:

Ø      Introduction to computer application (word processing, spreadsheet and databases) and examples in real world applications

Ø      Word Processing:

·        Basic and Useful Formatting & Editing Techniques

·        Advanced Formatting & Editing Techniques

·        Tables, Form Letter, Templates, Mail Merge, Graphics

·        Real World Applications

Ø      Spreadsheet:

·        Introduction, Basic and Advanced Formatting

·        Operations, Calculations, Functions

·        Advanced Functions and Calculations

·        Sorting, Filtering

·        Charts & Graphs

·        Macro and Visual Basic

·        Real World Application

Ø      Database:

·        Introduction to Database and Database Systems

·        Modeling (E-R Diagram), Relationship

·        Introduce Access, Populating and Maintaining Data

·        Creating New Database and Tables

·        Import and Export Data from Access and Other Sources (Spreadsheet, Text File, ..)

·        SQL - Basic Queries, Queries with Constraints, Reports

·        Real World Database Application

Projects and Labs

In this course we will try to understand and practice some of the real world application projects such as:

Word Processing: Flyer with picture, Research Paper, Resume, Mail Merge.

Spreadsheets: Sales and Sales Projection, Financial Analysis, Payroll, College Cost and Tuition Analysis.

Databases: University Student Database, Job Searching Database, Restaurant Database, Rental Database, Library Catalogs, Retail and Service Databases

Outcomes

After completing the course the student should be able to:

• Explain the role and importance of word processing in today’s workplace.

• Apply word processing for improving personal and work effectiveness.

• Create and manipulate advanced word processing documents.

• Define common spreadsheet terms and the concepts of spreadsheet structure, text and numbers, formulas and functions, and productivity commands.

• Create spreadsheets, charts, and formulas for simple problem solving and decision making.

• Analyze data with spreadsheet.

• Apply techniques to manage and use large worksheets.

• Print spreadsheet reports and charts.

• Identify the importance of database management in today’s world.

• Demonstrate the real world database applications.

• Apply database concepts to personal and business applications using Microsoft Access.

• Define, create, and edit a database using Microsoft Access.

• Create useful queries, forms, and reports using the databases they have created.

Course Flyer

Textbook

Gary B. Shelly, Thomas J. Cashman, Misty E. Vermaat: Microsoft Office 2007: Introductory Concepts and Techniques, Windows XP Edition, 2007, Thomson Course Technology, ISBN10: 141884327X, ISBN13: 9781418843274

Evaluation 

Detail Schedule

TBA

TBA