Cs1 Course Outline

CS1 (BSN, BSMT, BSPT, BS Chem., BS Bio., BS Psych., BS Social Work, BS Math)

Course Title: Basic Computer Concepts & Office Productivity Tools Course Description: This course will provide non-ITE students with background on computers systems; hands-on training on office productivity tools such as word processing, spreadsheet, & presentation softwares; demonstrated knowledge on the use of Internet. Credit: three (3) units Central Objective: At the end of the course, the student is expected to • Operate a personal computer and identify the basic components • Gain knowledge on the use of Internet – i.e. browsing, use of search engines, email • Have a working knowledge on the use of office productivity tools Course Outline: I. Introduction to Computers • What is a computer? (Data vs. Information, Information Processing Cycle) • History of Computers • Classification of Computers • Components of a Computer System (Hardware, Software, Peopleware) • Impact of Computers in Society (Advantages and Disadvantages) • Emerging Trends of Information Technology II. • •

Operating Systems Definition and examples of Operating Systems Functions Of Operating Systems (DOS, WinXP Operations)

III. • • • •

Internet Definition of Internet History Of Internet Internet: A Resource for All of US Security and Privacy: Computers and Internet

IV.

Office Productivity •

Word Processing Using MS Word i. Understanding Word ii. Creating, Saving And Printing Documents iii. Basic Editing Tasks iv. Fonts, Borders And Shading v. Indents And Justification vi. Tabs And Line Spacing vii. Margins, Pages And Sections viii. Page Numbers, Headers And Footers ix. Numbered And Bulleted Lists x. Working With Tables xi. Using Columns In A Document xii. Working with Graphics

•

Spreadsheet Application i. Understanding Excel ii. Creating, Saving and Printing Workbook Files iii. Entering Different Kinds Of Data iv. Changing How Numbers Look v. Editing Entries vi. Working With Ranges vii. Inserting And Removing Cells, Rows And Columns viii. Performing Calculations With Formulas And Functions ix. Copying Formulas And Functions x. Creating Charts

•

Presentation Application using MS PowerPoint i. Understanding PowerPoint ii. Creating, Opening, Saving a presentation iii. Working with slides in different views (Copying, Inserting, Deleting slides) iv. Working with objects v. Applying templates, layout, color schemes vi. Animation (objects and slides) vii. Hyperlink & Action Buttons viii. Working with multimedia ix. Editing Design Templates (Using Master View)

References Shelly, G., Cashman, T. and Vermaat, M. Discovering Computers 2007: A Gateway to Information. Thompson Learning Inc., 2007. Capron, H.L. and Johnson, J.A. Computers: Tools for an Information Age. Pearson Education, Inc., 2002.

Nelson, S.L. Office XP : the complete reference. McGraw-Hill, 2001. Hutchinson, S.E. Microsoft Excel 2002. McGraw-Hill/Irwin, c2002. Methodology 1. Lecture 2. Hands-On Basis of Evaluation 1. 2. 3. 4. 5.

Exercises Written Exams Hands-On Exams Assignments/Projects Attendance

Grading System A. Midterm • Attendance • Exercises • Quizzes/Exams • Assignments/Projects • Midterm Exam GRADE

10% 20% 25% 15% 30% 100%

B. Post Midterm • Attendance • Exercises • Quizzes/Exams • Assignments/Projects • Midterm Exam GRADE

10% 20% 25% 15% 30% 100%

Midterm Post Midterm Final Grade

40% 60%__ 100%