A first course in Computers: based on Windows XP and office Xp /
Sanjay Saxena
- New Delhi : Vikas Publishing , 2009.
- 447p. ill. ;
Part I Introduction Part II Operating Systems 1. Introduction to Computers What is a Computer What's so Special About Computers Review^ Questions 2. History of Computers Evolution The First Computer Next Generations Review Questions 3. Basic Anatomy of Computers The Basic Components Functioning of the Components Memory Software Componehts Input/Output Devices Input Devices Output Devices External Storage Devices Types of Computers Personal Computer Work Station Mainframes : Supercomputers Review Questions 4. Operating Systems Introduction How Does \Mndows Differ From DOS? Benefits of )Mndows Part III 5. Windows XP MS Introduction WWiIInIdUoUwWs5 Featurweisn odfo Wwisn xdpo?ws XP Getting Started The Desktop About Icons Working with Windows Types of Widows Moving a Window . _ Minimizing, Restoring and Closing a Window Resizing a Wndow Start Menu and the Taskbar The Start Menu Switching between AH Programs Using Windows Help and Support Quitting Wndows Wndows Explorer—Files and Folders About Files and Folders Starting Wndows Explorer Moving Files Copying Files by Click and Drag Method Copying Multiple Files Copying a Continuous Range of Files Renaming a File Deleting Files Searching a File or Folder The Recycle Bin The Control Panel Change or Remove Programs Add New Programs Adding or Removing Windows Components Date and Time Changing the Date and Time Setting the Time Zone Display The Screen Saver Wallpaper or Background Customizing Your Desktop Fonts f Mouse Button Configuration Pointer Configuration Motion Configuration Mouse Pointers Printers and Faxes Scaimers and Camera Sound and Audio Devices Sounds System Properties Taskbar and Start Menu Settings User Accounts Network Accessories Media Playe*' Calculator Disk Defiragmenter Notepad Paint Games Windows Tour , ^ Help and Support Center 6. Windows Vista Introduction Background The Early Nineties Year 2000 and Later Windows Vista Guidelines for Basic Home Users Computer Setup Welcome Center Windows Easy Transfer Windows Experience Index New User Experiences >\^ndowsAero User Experience Start Menu Windows \^sta Start Menu >^ndows XP Start Menu New Windows Vista Explorers User Interface: Navigation and Usage Internet Explorer 7 Conclusion Partly 7. MS Office XP MS Office About MS Office Why MS Office 8. MS Office 2007 Introduction Background New Offerings at a Glance Editions New Features User Interface The Office Button Ribbon Contextual Tabs Mini Toolbar Super Tooltips Quick Access Toolbar Zoom Slider SmartArt File Formats User Assistance System Microsoft Office Groove 2007 Themes and Quick Styles What's New? Microsoft Office Word 2007 Outlook Excel Powerpoint OneNote Access Publisher Infopath Visio Project Microsoft Sharepoint Designer Server components PartV Word Basics MS Word Introduction Starting Word Creating Documents Parts of Word "Window Mouse Operations Keyboard Operations Individual Keys Things to Avoid Formatting Features Menus, Commands, Toolbars and their Icons LEARN BYDOD4G yford Exercise-I . Starting MS Word Word Exercise-U New Document Entering Text Entering Text in Text Box Changing Font Changing Font Size Altemative Method Aligning the Text Italicizing the Text Numbering Bullets Spelling Print Preview Print Saving Documents Closing the Document Opening the Document Exiting MS Word Word Exercke-IU Creating a Template Creating Tables Creating More Tables Inserting Columns Inserting Rows Moving Tables Drawing a Table Text Box Formatting Insert Picture Formatting a Picture Formatting Text Changing Fonts and Text Size Print Preview Save Creating Documents based upon Template Review Questions 10. Mail Merge Word Exercise-rV Creating the Main Document Creating Data Source Adding Fields Removing Fields Review Questions 11. Macros Introduction Inserting Header and Footer Inserting Current Date, Time and Page Numbers Do-It-Ypurself Exercises (I-XI) Review Questions Part VI 12. Excel Basics MS Excel Introduction Navigating Selecting Cells Selecting Cells with Mouse Entering and Editing Text Entering Numbers Entering Formulas Entering Dates Alignment Some Do's and Uon'ts Menus, Commands and Toolbars Standard Toolbar : Formatting Toolbar LEARNBY DOING Excel Exercise-I Starting Excel Opening Workbook Entering Text in Cells Colunm Width Alternate Method Series Fill Entering Formulas Copying and Pasting the Formula Summation jdv Contents Fonnatdng Cells Currency Notation Centering Across Selection, Changing Font and Size Column AutoFit Formatting Text (Bold, Italic) Inserting Rows Inserting Columns Formula Aligning Data Formatting Date Range Print Preview Page Setup Inserting Headers & Footers Saving a File Opening a File Excel Exercise-II Enterin^Text Summation Series Fill Centre Aligning Across Cells Changing Font lype & Size Currency Format Renaming a Worksheet Copying Text between Worksheets Deleting Cell Contents Editing Cell Contents Copying Data between Worksheets Deleting Cell Contents Entering Formula Pasting the Formula Creating a Chart Saving a File Excel Exercise-III Starting Excel What is a Database? • Data Forms Review Questions 13. Data Sort Data Filters Auto Filters Valid Criteria Invalid Criteria Redundant Criteria Review Questions Part VII MS PowerPoint Part VIII MS Access Part IX MS Outlook 14. Functions ROUND SQRT AVERAGE MBSf COUNT ,SUM ABS ROMAN UPPER CELL TODAY NOW Do-It-Yourself Exercises I-VIII MAX IF , SUMIF LOWER 15. PowerPoint Basics Introduction Navigating in PowerPoint Creating a New Presentation Opening a Presentation Creating a New Slide Deleting a Slide Copying a Slide Numbering the Slides Saving a Presentation Closing a Presentation Saving a Presentation with a Different Name Changing the Default Directory Auto Save Printing a Presentation Working with PowerPoint 16. MS Access Introduction What is a Database? Parts of an Access AMndow Starting Microsoft Access Creating a New Database Creating Tables Using Table Wizard Creating a New Table Rename Columns Saving the Database Relationships Creating Tables in Design View Query Forms Reports Exiting MS Access 17. MS Outlook Introduction Working with Outlook? Parts of An Outlook Window Part VII MS PowerPoint Part VIII MS Access Part IX MS Outlook 14. Functions ROUND : SQRT AVERAGE MIN COUNT JSUM ABS , ROMAN UPPER CELL TODAY NOW 16. MAX IF SUMIF LOWER 17. Do-It-YourselfExercises I-VIII 15. PowerPoint Basics Introduction Navigating in PowerPoint Creating a New Presentation Opening a Presentation Creating a New Slide Deleting a Slide Copying a Slide Numbering the Slides Saving a Presentation Closing a Presentation Saving a Presentation with a Different Name Changing the Default Directory Auto Save Printing a Presentation Working with PowerPoint MS Access Introduction What is a Database? Parts of an Access )A^dow Starting Microsoft Access Creating a New Database Creating Tables Using Table Wizard Creating a New Table Rename Colunms Saving the Database Relationships Creating Tables in Design View Query Forms Reports Exiting MS Access MS Outlook Introduction Working with Outlook? Parts of An Outlook )^ndow Starting Outlook ... The Address Book Adding Contacts Changing View Finding a Contact Filtering Contacts Sorting Contacts Calendar Tasks Journal Inbox Receiving E-mails Notes Part X 18. Internet Basics Internet Introduction Important Features Intemet Protocols IP Address Domain Naming System (DNS) ' Communication Protocols Connecting to the Intemet Dial-Up Connections Digital Subscriber Line (DSL) Cable Modems Integrated Services Digital Network (ISDN) Prerequisites for Intemet Hardware Software Others Factors Affecting the Speed of Intemet Coimectivity Configuring the Modem Configuring a TCP/IP Connection Search Engine How Search Engines Work Preliminary Searching Hints ' Boolean Searching Using a Search Engine E-Mail Creating an E-Mail Account Sending and Receiving E-Mails Receiving E-Mails Intemet Phone Google Earth