DETAILED SYLLABUS

CEO

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 



No.

Title of the Subject

Duration/Hrs

  1.  

Operating system(Windows and Linux)

20

  1.  

 Documentation using MS Word

20

  1.  

Spread Sheet Preparation using MS Excel

20

  1.  

Slide Preparation using MS Power Point

20

  1.  

Database concepts using MS Access

10

  1.  

Internet Applications

10

  1.  

Software Lab

20

Total

120

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

CEO - 1

 OPERATING SYSTEMS

(WINDOWS AND LINUX)

 

 

1.          INTRODUCTION

             What is a Computer? Purpose of using a computer, Why it is used (characteristics of computer), Instruction, Program

 

2.          TYPES OF COMPUTER

             Analog, Digital, and Hybrid type, Hardware, Software, System software, Application software, Firm ware, Human ware, Stored Program Concept, Evolution of computers, Generation of computer.                   

 

4.          PROGRAMMING LANGUAGES

             Machine language, Assembly language, High level language

 

5.          ORGANISATION OF A DIGITAL COMPUTER

             Input unit, Output unit, Central Processing unit, Memory

 

6.          OPERATING SYSTEM

             Introduction, Different Operating Systems, Loading and Quitting the Operating Systems, Important DOS Commands (Internal and External), File and Directory System Concepts in DOS

 

 

WINDOWS

 

 

1.       WINDOWS INTRODUCTION

          Operating System

 

2.       Desk top icons

          My Computer, Recycle Bin, Internet Explorer, Network Neighborhood, My Documents

 

3.       Working with windows

          How to create a Folder, Copying and cutting files, Renaming

 

4.       START ICON

          Programs, Favorites, Documents, Settings, Find, Run, Shut down

 

5.       APPLICATION ICONS

 

 

 

 

LINUX

1.                  HISTORY

2.                  DISTRIBUTIONS

3.                  DEVICES AND DRIVES IN LINUX

4.                  FILE SYSTEM HIERARCHY

5.                  COMPONENTS: KERNEL, DISTRIBUTION, SAWFISH, GNOME.

 

ceo - 2

  documentation using ms word

 

1.       AN INTRODUCTION TO WORD

          The Word workspace, Starting and quitting Word, Creating and Manipulating Various documents, Editing of proofing files, Merging documents and macros

 

2.       HOW TO USE MOUSE AND MENU

          Working with dialog box

 

3.       PRIMARY COMMANDS IN FILE MENU

          The Open Commands, The File name commands, The New commands, The Save , Save As, and Save all  commands, The Close command, The Page setup, The Print commands, The Exit commands

 

4.       EDIT MENU COMMANDS

          The Cut, Copy, and Paste commands, The Undo and Repeat commands

 

5.       FORMAT COMMANDS

          Font commands, Paragraph commands

 

6.       OTHER MENU

          The view menu, The Insert menu, The tool menu, The table menu, The Window menu

 

ceo - 3

 spread sheet preparation using ms excel

 

1.       BUILDING A SIMPLE WORKSHEET

          Entering Text, Entering Values, Entering Dates and Times, Moving Around, Selecting Ranges, Using Menu, Using Tool Bar, Using Shortcut Menus, Changing entries, Copying entries, Moving Entries, Inserting and Deleting cells

 

2.       FORMATTING BASICS

          Changing Character Style, Changing Alignment, Changing Column Width,

 

3.       WORKING WITH MULTIPLE WORKSHEET

          Copying entries between work books, Moving sheets between work books, Deleting sheets,       Quitting Excel

 

4.       OPENING EXISTING WORKBOOKS

          Simple calculations, Doing Arithmetic, Totaling column of values, Naming cells and Ranges

 

5.       FORMATTING TEXT

          Displaying dollars and cents, Formatting decimal places, Formatting dates, Copying style and formats

 

6.       FORMULAS THAT MAKE DECISIONS

          Using the IF function, Using the nested IF function, Copying formulas                              

7.       Checking Spelling, Printing Worksheets, Preview Worksheets, Setting up the pages,

 

8.       Sorting data, Keeping Leading in View, Finding records, Adding and deleting Records, Filtering Records

 

9.       Plotting charts, Sizing and moving charts, Updating charts, Changing the chart type, Using chart auto format

         

10.     Creating Macros, Recording Macros, Running Macros

 

ceo - 4

 slide presentation using ms power point

 

1.       POWER POINT

          Main Features of Power Point

 

2.       Making the Presentation

          Creating Template with the Auto Content Wizard. Creating a Presentation with a Template.  Creating a presentation from Scratch

 

3        Different Views

          Normal Slide, Outline, Slide Sorter, Slide Show, Notes, Slide Master

 

4        Animation, Art and Sound

          Controlling Transitions between slides.  Animating Different Parts of a slide.  Inserting a Motion Clip.  Including Sounds in slides.

 

5.       Including Graphs, Charts, Tables and Columns

          Organisation Chart Slide, Creating a table Slide.  Creating two column Slide, Module  1: Showing  A Presentation, Rehearsing/ Timing a Presentation, Designating some slides as “Hidden”, Viewing Slides Anywhere in a Slide Show.

6.       TECHNIQUES FOR MAKING A SHOW LIVELIER

 

7.       Office Connections

          Presenting with the help of other Office Programs Importing the text from a Word Document.

8.       PRINTING A PRESENTATION

 

ceo - 5

database concepts using ms access

 

 

1.          Introduction to Database

             Database System Concepts, DBMS and RDBMS

 

2.          Planning and Designing a Database

 

3.          Creating a Database

            

             Sorting Data in Tables, Fields, Records, Two ways to Create a Database, Creating a Database with Database Wizard

 

4.          Building and Modifying Tables

             Create Tables by using the Table Wizard, Create Tables from Scratch, Field Names

             Data Types and Filed Properties, Modify Tables Using Design View, Entering Data in a Data sheet, Editing Data in a Datasheet, Changing the Width of Columns and Height of Rows, Changing the Order of Columns, Setting of Primary Key

 

5.          Defining Relationship

             Establish Relationship, Enforce Referential Integrity

 

6.          Querying a Database

             Constructing a Query, Creating the Query, Choose the Tables to Query, Field to Query, Entering the Query criteria, Saving the Results of a Query

 

7.          Different kinds of Queries

             CrossTab, Update, Delete, Append, Make Table

 

8.          Building and Modifying Forms

             For Entering and Viewing Data, Creating a Form (Design View of Form Wizard), Use the Control Toolbox to Add Controls, Modify Format Properties (Font Style, Size, Color, Caption, etc.) of Controls, Use of Form Sections (Header, Footers and Detail), Use of Calculated Control on a Form

 

 

ceo - 6

 internet  applications

 

1.       INTRODUCTION TO INTERNET

          Understanding Networks, Getting to know web browsers, Getting to know the Internet Explorer Window

 

2.       APPLICATIONS

          Internet Electronic Mail, Setting up E-mail, Creating Mail Messages, Editing Mail Messages, Attaching a file to a Mail message, Sending and receiving mail messages, Creating and using an Address Book

 

3.       SEARCHING AND BROWSING ON THE INTERNET

          Internet Searching, Tools for Specialized Searches, Finding Specific Topics

 

4.       Browsing the Educational and informative Sites

 

 

ceo -7

SOFTWARE LAB