Course Contents

• • Introduction: Definition and characteristics of computers, Evolution of computers, Computers generations and Classifications. • Input Devices: Keyboard, Pointing and Draw Devices, Source data entry & Scanning Devices, Voice recognizing Devices, Visio-Input System. • Output Devices: Monitors, Printers, Plotters, Multimedia Projector and Voice Response Systems. • Basic Computer Organization: Input unit, Output Unit, Storage Unit, ALU, Control Unit and CPU. • Processor and Memory: The Central Processing Unit, Machine cycle, Processor Evolution, System clock, Main Memory Organization, Memory Capacity, RAM, ROM, Cache Memory, and Registers. • Number Systems: Non-positional number systems, Positional Number systems and Conversion from one number system to another, Fractional Numbers. • Computer Codes: BCD code, EBCDIC code and ASCII code, Collating Sequence. • Computer Arithmetic: Binary Arithmetic: Addition, Subtraction, Division and Multiplication. • Storage Devices: Sequential and Direct access Storage Devices, Magnetic Disk, Optical Disk, Removable Storage Devices and Storage Hierarchy. • Final project: • Microsoft Office: Microsoft Word, Microsoft Power Point and Microsoft Excel • MS Excel o Create workbook and spread sheet using different formula, functions. o Charts: How to Sort Data in Excel, Create an Excel Chart, Move and Resize your Chart, Chart Styles and Layouts, Chart Titles and Series Titles, Chart Layout Panel, The Format Chart Panel, Create a Pie Chart in Excel, Format Pie Chart Segments, Create a 2D Line Chart, Format your Axis Titles o Conditional logic in excel: IF function, CountIF function, Conditional formatting, SumIF function o Data Analysis in excel: Data Analysis in spread sheet, Basic sort, Auto filter, creating subtotal, Pivot Table, Goal seeking and data validation • MS Word o Creating a Basic Document: The Word Environment, Get Help Using Word, Enter Text, save a New Document, 7 Previews a Document, Print a Document. o Editing and Formatting Document: Navigate in a Document ,Insert Text ,Select Text ,create an AutoText Entry ,Move and Copy Text ,Delete Blocks of Text ,Undo Changes ,Find and Replace Text. Change Font and Size, Apply Font Styles and Effects, Change Text Color, Highlight Text, Copy Formats, Clear Formatting, Find and Replace Text Formatting. Set Tabs, Change Paragraph Alignment, Indent Paragraphs, Add Borders and Shading, Apply Styles, Create Lists, Change Spacing Between Paragraphs and Lines. o Proofing a Document: Use the Thesaurus, Check Spelling and Grammar, create a New Default Dictionary, Check Word Count, Modify a Document in Print Preview. o Adding Tables :Create a Table ,Enter Data in a Table ,AutoFormat a Table,Convert Text to a Table o Inserting Graphic Elements: Insert Symbols and Special Characters, insert a Clip Art Picture, Add a Watermark. o Controlling Page Appearance: Set Page Orientation, Change Page Margins, Apply a Page Border, Add Headers and Footers, Insert a Page Break. o Managing Lists: Sort a List, Restart a List, Create an Outline Numbered List, And Customize List Appearance. o Customizing Tables and Charts and Formatting: Sort a Table, Modify Table Structure, Merge or Split Cells, Position Text in a Table Cell, Apply Borders and Shading, Perform Calculations in a Table, Create a Chart from a Word Table, Modify a Chart. Modify Character Spacing, Add Text Effects, Control Paragraph Flow. o Working with Custom Styles: Create a Character or Paragraph Style, Modify an Existing Style, Create a List Style, and Create a Table Style. o Modifying Pictures: Set Picture Contrast or Brightness, Crop a Picture, Wrap Text around a Picture. o Creating Customized Graphic Elements: Draw Shapes and Lines, Insert WordArt, Insert Text Boxes, Create Diagrams. o Controlling Text Flow: Insert Section Breaks, Insert Columns, and Link Text Boxer. Run a Macro, Create a Macro, Modify a Macro, Customize Toolbars and Buttons, Add Menu Items. o Automating Document Creation: Create a Document Based on a Template ,Create a Document by Using a Wizard ,Create or Modify a Template Change the Default Template Location ,Insert a Macro Button Field in a Template. o Performing Mail Merges: The Mail Merge Process, Perform a Merge on Existing Documents, Merge Envelopes and Labels, Use Word to Create a Data Source. • MS Power Point o An Orientation to PowerPoint and Presentation: The PowerPoint Environment, Orientation to Views, Navigate Through a Presentation, Edit Slide Text,Save the Presentation,Run a Slide Show. Create a New Presentation, Change Background Color, Add Slides to a Presentation, Enter Text, Create a Presentation from a Microsoft Word Outline. o Formatting Text Slides adding tables: Apply Character Formats, Align Text, Change Line Spacing, and Change Indents. Create a Table, Format Tables; Insert a Table from Microsoft Word. o Charting Data: Create a Column Chart, Edit Chart Data, Change Chart Type, and Insert a Chart from Microsoft Excel. o Modifying Objects: Resize Objects, Copy and Duplicate Objects, Move Objects, Changing Object Orientation, Format Objects, Group and Ungroup Objects, Change the Order of Objects. o Adding Images to a Presentation: Add Clip Art, Add a Picture from a File, Draw Lines and Shapes, Insert WordArt. o Preparing to Deliver a Presentation : Spell Check ,Arrange Slides ,Add Transitions ,Create Speaker Notes ,Send a Presentation to Microsoft Word ,Print the Presentation ,Package a Presentation for CD. o Creating a Custom Design Template: Define Design Template Characteristics, Create a Custom Color Scheme, Set Up a Slide Master, Format Custom Bullets, Add Footer, Modify the Notes Master, Save a Custom Design Template. o Adding Organization Charts and Diagrams: Working with Organization Charts, Update an Organization Chart, Applying a Chart Layout, Create a Diagram, Draw a Flowchart. o Adding Special Effects: Add Sound and Movies, Add Animation, Emphasize Objects, Set a Motion Path, Set the Order of Effects. o Creating Web Presentations: Create a Group Home Page with the AutoContent Wizard, Hyperlink to a Web Page, Publish as a Web Page. o Collaborating in PowerPoint: Set Password Protection, Work with Comments, Send a Presentation for Review, Merge Revision Copies, And Apply Reviewer Changes. o Delivering a Presentation: Hyperlink Within PowerPoint, Add an Action Button, Set Up a Custom Show, Annotate a Presentation, Working with Narrations and Slide Timings, Set Up a Slide Show to Repeat Automatically.

Course Synopsis

This is the elementary course of computer sciences to give an introduction of computer fundamentals and commonly used application programs as Word, Excel, Power point and Access in an interesting, logical and informative manner. Main focus of the lab work will be on Excel and Access.

Course Learning Outcomes

The student will be able to: • Explain the functions of a computer. Determine the scope and applications of computers in industry. • Evaluate appropriate applications for commonly available software used in computer systems. • Evaluate appropriate applications for commonly available peripherals used in personal computer systems. • Demonstrate the ability to operate a personal computer. • Analyze the computer needs of a selected workplace situation to specify computer system components appropriate to the requirements of that situation.