FIT Lab Record
FIT Lab Record
Procedure:
Step1: Open Microsoft Word Document
       Start  All Programs  Microsoft Office  Microsoft Office Word 2007
Step2: type about some news at least 5 paragraphs with 2-3 lines each (Monsoon to
rage till October-end)
Step3: Select the text that you want to convert into two columns
Step5: MS-Word will automatically adjust your selected text into the number of
columns you chose.
                                                                     KMICS       2
BCOM I YEAR I SEM (COMP_APP)                                          FIT LAB RECORD
a) Make five lists of numbering which contains details of the courses offered in
your college.
b) Make the five list of bullets having hand symbol which describes about
facilities in your college.
c) Keep a footnote to any one of the word of the first paragraph.
d) Center the heading of your document.
Procedure:
Step1: Open Microsoft Word Document
      Start  All Programs  Microsoft Office  Microsoft Office Word 2007
Step2: Type a paragraph about Kmics College.
a) Make five lists of numbering which contains details of the courses offered in
   your college.
                                                                        KMICS        3
BCOM I YEAR I SEM (COMP_APP)                             FIT LAB RECORD
                                                           KMICS     4
BCOM I YEAR I SEM (COMP_APP)                                              FIT LAB RECORD
Procedure
Go to insert tab  tables  insert table  insert table wizard will be opened.
Enter number of columns and rows required. Here columns 7 and rows 6
Then press Ok
Step4: Enter data into table i.e. your class time table
Step6: to apply the table styles, keep mouse cursor anywhere in the table then
                                                                            KMICS     5
BCOM I YEAR I SEM (COMP_APP)                                         FIT LAB RECORD
Procedure
Step1: Open Microsoft Word Document
       Start  All Programs  Microsoft Office  Microsoft Office Word 2007
Step2: Go to Mailings Tab, select start mailing and select letters option from the
drop-down list.
Step3: Click select Recipients option on the ribbon and select Type New List
from the drop-down menu, customize the list and enter details and save.
Step4: click select Recipients option on the ribbon and select Use Existing List
from the drop menu and the select the address book from the database.
Step5: click the address block on the ribbon it will be selected. Click Greeting
Line on the ribbon and then Insert Merge Field option on the ribbon to complete
mail merge.
Step6: click Finish & Merge option on the ribbon on complete mail merge.
                                                                       KMICS       6
BCOM I YEAR I SEM (COMP_APP)                                          FIT LAB RECORD
Step3: type college name, address details and insert image if required.
                                                                          KMICS      7
BCOM I YEAR I SEM (COMP_APP)                                        FIT LAB RECORD
Step4: click the keyboard button to assign a keyboard short to the macro, type a
keyboard shortcut combination and click on Assign button and then click Close
button.
You are now recording a macro in word. Everything you do is recorded, from
typing text to choosing commands and setting options.
Step5: to stop recording, choose Macros  stop recording. The macro is saved.
Step6: to run the macro, press the keyboard shortcut you assigned. Word repeats
all actions taken while the macro was being recorded.
                                                                      KMICS        8
BCOM I YEAR I SEM (COMP_APP)                                      FIT LAB RECORD
Procedure
Step1: Open Microsoft Word Document
       Start  All Programs  Microsoft Office  Microsoft Office Word 2007
Step2: type text on “Features of Computer”.
Step3: Go to page Layout Tab and select a different “Themes” among the list of
themes.
                                                                    KMICS        9
BCOM I YEAR I SEM (COMP_APP)                                       FIT LAB RECORD
CO2
X2
                                                                     KMICS    10
BCOM I YEAR I SEM (COMP_APP)                                     FIT LAB RECORD
Procedure
Step1: Open Microsoft Word Document
      Start  All Programs  Microsoft Office  Microsoft Office Word 2007
Step2: type text about college in 5 pages
      Go to insert tab  header & Footer  Header  select the required header
format.
      Go to insert tab  header & Footer  Footer  select the required Footer
format
                                                                   KMICS     11
BCOM I YEAR I SEM (COMP_APP)                                         FIT LAB RECORD
Example:
 ROLL                          MARKS
         NAME                                       TOTAL       AVERAGE      RESULT
  NO             S1     S2     S3    S4   S5   S6
1       A        80     90     100   55   78   67
2       B        60     70     20    56   55   44
3       C        90     80     10    88   89   89
PROCEDURE: -
Step 1: - Click on start button All Programs MS-Office MS-Excel.
Step 2: - Now new work book will open. In sheet 1 type the data as given in the
above question.
Step 4: - Calculate Average by using the formula =I3/3 (OR) use Function
=Average (C3:H3)
Step 5: - Write the below formula under the result column heading
=IF(AND(C3>=40,D3>=40,E3>=40,F3>=40,G3>=40,H3>=40),"PASS","FAIL")
                                                                          KMICS   12
BCOM I YEAR I SEM (COMP_APP)                                    FIT LAB RECORD
PROCEDURE:-
Step 1:- Click on start button All Programs MS-Office MS-Excel.
Step 2:- Now new work book will open. In sheet 1 type the data as given in the
above question.
 Calculate Average by using the formula =I3/3 (OR) use Function =Average
(C3:H3)
Step 4:- b) Calculate Maximum and minimum of marks in Total marks column
Step 5: c) Count the number of students whose average score is>70 by using
COUNTIF (range, criteria) function
=COUNTIF ((J3:J7),">=70")
                                                                  KMICS     13
BCOM I YEAR I SEM (COMP_APP)                                          FIT LAB RECORD
PROCEDURE:-
Step 2:- Now new work book will open. In sheet 1 type the data as given in the
above question.
 Calculate Average by using the formula =I3/3 (OR) use Function =Average
(C3:H3)
Step 4:- b) to calculate student marks who score is greater than 90
A greater than dialogue box will appear. Type 90 in text box and select color then
click on ok button.
                                                                        KMICS    14
BCOM I YEAR I SEM (COMP_APP)                                    FIT LAB RECORD
PROCEDURE:-
Step 1:- Click on start button All Programs MS-Office MS-Excel.
Step 2:- Now new work book will open. In sheet 1 type the data as given in the
above question.
                                                                  KMICS     15
BCOM I YEAR I SEM (COMP_APP)                                    FIT LAB RECORD
PROCEDURE:-
Step 1:- Click on start button All Programs MS-Office MS-Excel.
Step 2:- Now new work book will open. In sheet 1 type the data as given in the
above question.
                                                                  KMICS     16
BCOM I YEAR I SEM (COMP_APP)                                       FIT LAB RECORD
Procedure
Step 1:- Click on start button All Programs MS-Office MS-Excel.
Step 2:- Now new work book will open. In sheet 1 type the data as given in the
above question.
              Second
First Name              Score
               name
  GEETA        JOSHI     89
   NEHA       HOODA      67
 SHEETAL     SHARMA      65
  GEETA       BOHRA      83
   NEHA       GUPTA      90
  NIKHIL        ROY      65
   NEHA         ROY      83
  SATISH      HOODA      56
   NEHA      SHARMA      86
Step 3: - Select First name and second name column
Step 4: - a) To Sort the data Select Data Tab sort& Filter groupSort Option
Then Sort window will appear on the screen, from Sort by dropdown box select
first Name, in order box A to Z click ok
Step5: b) To Sort the data Select Data Tab sort& Filter groupSort Option
Then Sort window will appear on the screen, from Sort by dropdown box select
first Name, in order box A to Z
Select “Add level “to add multilevel for sorting. In “Then by” box select “second
name”, in order box A to Z Click ok button
                                                                     KMICS      17
BCOM I YEAR I SEM (COMP_APP)                                          FIT LAB RECORD
Procedure
   1. Step 1: Click on start button All ProgramsMS-OfficeMS-
      Excel 2007
   2. Step 2: Now new workbook will open. In sheet1 Type the data as
      given in the above question.
      First name, last name, score. and then Enter few Records
   3. Step 3: To Filter, select the data first then,
      Click on Data tabSort and Filter Select filter option
      Then every column header display            symbol. Click on this symbol for
the column you want to filter. and then it will give drop down list.
          From the list select Number Filter (or) Text FilterThen it will
           Display:
                     Equal to,
                     Greater than,
                     Less than.
                     Between. etc.
   4. Step 4: -a) Select Greater than option from sub menu you will get a
      dialogue box. Type 70 in textbox and click ok.
      b) Select Between option from sub menu you will get a dialogue box. Type
      50 in first textbox and 70 in second text box then click ok button.
   5. Save it by selecting office button save or save as
                                                                        KMICS    18
BCOM I YEAR I SEM (COMP_APP)                                          FIT LAB RECORD
PROCEDURE
Step 2:- Now new work book will open. In sheet 1 type the data as given in the
above question.
Step 3:- first select the data then click on Insert tabPivot table
Then Create Pivot table window will open , and then select new work sheet, click
on OK button
Step8: To calculate Average, Right click on Grand total cell select “summarize
data by” option then select Average from Sub menu.
                                                                        KMICS    19
BCOM I YEAR I SEM (COMP_APP)                                      FIT LAB RECORD
PROCEDURE
Step 1:- Click on start button All Programs MS-Office MS-Excel.
Step 2:- Now new work book will open. In sheet 1 type the data as given in the
above question.
Step 4:- To Sort the data Select Data Tab sort& Filter groupSort Option
Then Sort window will appear on the screen, from sort by dropdown box select
department
                                                                  KMICS     21
BCOM I YEAR I SEM (COMP_APP)                                        FIT LAB RECORD
Step2: Take new slide: go to Home tab  slides  select new slide
                                                                      KMICS    22
BCOM I YEAR I SEM (COMP_APP)                                         FIT LAB RECORD
Procedure:
Step1: open power point application window
Step2: Take new slide: go to Home tab  slides  select new slide
                                                                       KMICS    23
BCOM I YEAR I SEM (COMP_APP)                                       FIT LAB RECORD
Procedure:
Step1: open power point application window
Step2: Take new slide: go to Home tab  slides  select new slide by selecting
required slide layout.
Step3: write the content regarding to topic i.e. about Global Warming.
                                                                     KMICS       24
BCOM I YEAR I SEM (COMP_APP)                                         FIT LAB RECORD
Procedure:
Step1: open power point application window
Step2: Take new slide: go to Home tab  slides  select new slide
Step3: write the content regarding to topic i.e. about Effects of overuse of Smart
Phone.
                                                                       KMICS     25
BCOM I YEAR I SEM (COMP_APP)                                           FIT LAB RECORD
Procedure:
Step1: open power point application window
Step2: Take new slide: go to Home tab  slides  select new slide
Step3: write the content regarding to topic i.e. about Side effects of smoking.
Step5: select text or content in slide to which you want to apply custom animation.
Step7: repeat step 5 and 6 until to apply custom animations to all slides.
                                                                         KMICS    26
BCOM I YEAR I SEM (COMP_APP)                                                FIT LAB RECORD
Procedure
step1: Create Directory with College Name
C:\>MD KMICS
C:\>CD KMICS
C: \ KMICS >
Step 4: Open the BCOM Sub directory with CD Command to create sub directory in it
C :\ KMICS \BCOM>CD..C
:\ KMICS >
Step 5: Open the BSC Sub directory with CD Command to create sub directory in it
                                                                              KMICS    27
BCOM I YEAR I SEM (COMP_APP)                                               FIT LAB RECORD
C :\ KMICS \BSC>CD..C
:\ KMICS >
Step 6: Open the BBA Sub directory with CD Command to create sub directory in it
:\ KMICS >
                                                                              KMICS   28
BCOM I YEAR I SEM (COMP_APP)                                                 FIT LAB RECORD
Procedure
step1: Create Directory with College Name
C:\>MD KMICS
C:\>CD KMICS
C: \ KMICS >
Step 3: Create Sub Directory in KMICS Directory with name Course NamesC: \
C: \ KMICS >TREE
                                                                               KMICS    29
BCOM I YEAR I SEM (COMP_APP)                                                       FIT LAB RECORD
       Procedure
step1: Create Directory with College Name
C:\>MD KMICS
C:\>CD KMICS
C :\ KMICS >
Step 3: Create Sub Directory in College Directory with name Course Names
Step 4: Create text file in all sub directory describing about respective course
     The Bachelor of Commerce degree is designed to provide students with a wide range of
managerial skills, while building competence in a particular area of business
        ^z
       C:\KMICS\BCOM>CD..C:
                                                                                     KMICS    30
BCOM I YEAR I SEM (COMP_APP)                                          FIT LAB RECORD
           ^z
      C:\KMICS\BSC>CD..C:
^z
                                                                        KMICS     31
BCOM I YEAR I SEM (COMP_APP)                                                       FIT LAB RECORD
Procedure
step1: Create Directory with College Name
C:\>MD KMICS
C:\>CD KMICS
C: \ KMICS >
Step 3: Create Sub Directory in College Directory with name Course Names
Step 4: Create text file in all sub directory describing about respective course
     The Bachelor of Commerce degree is designed to provide students with a wide range of
managerial skills, while building competence in a particular area of business
        ^z
       C:\KMICS\BCOM>CD..C:
                                                                                     KMICS    32
BCOM I YEAR I SEM (COMP_APP)                                                         FIT LAB RECORD
             ^z
       C:\KMICS\BSC>CD..C:
       ^z
Step 5: copy the text file into Kmics directory
       C: \ KMICS >CD BCOM
KMICS\BCOM>DEL COURSE_DESCRIPTION1
C:\KMICS\BCOM>CD..
                                                                                       KMICS        33
BCOM I YEAR I SEM (COMP_APP)                                                  FIT LAB RECORD
        1.    DIR
        2.    CLS
        3.    DATE
        4.    TIME
        5.    VER
        6.    VOL
        7.    EXIT
        8.    COPY CON
        9.    TYPE
        10.   COPY
        11.   REN
        12.   DEL
        13. MD
        14. CD
        15. RD
                                                                                KMICS      34
BCOM I YEAR I SEM (COMP_APP)                                                   FIT LAB RECORD
   2.   VER: This command shows the version of Operating System, which we are presently using in
        a computer.
        Syntax
        C:\>VER
   3.   COPY CON: This command is used to creating file.in which user can write any data. Use
        Ctrl+Z or F6 to save the file.
        Syntax
        E:\>COPY CON filename
        Type data
        Save with Ctrl+Z
        1 file(s) is copied
                                                                                  KMICS      35
BCOM I YEAR I SEM (COMP_APP)                                                       FIT LAB RECORD
     5.   COPY: This command is used to copy the content of one file to another. Copy command
          creates duplicate file.
          Syntax:
          E:\>COPY <SourceFile > <TargetFile >
EXTERNAL COMMANDS
External commands are the commands that are not automatically loaded when DOS is loaded into the
memory. The external commands are used less frequently and are stored in some external file which are
stored in secondary storage device like: Hard disk. Whenever an External command is to be executed
then the external device transferred from hard disk to main memory (RAM). Type and number of
external commands may vary from system to system.
                                                                                      KMICS       36
BCOM I YEAR I SEM (COMP_APP)                                                       FIT LAB RECORD
        Syntax
        C:\>MOVE <filename> <pathname>
        C:\>SONGS>MOVE *.MP3 C:\SONGS\OLD SONGS
        C:\>
   2.   FC (File Compare): This command is capable of comparing two files and display
        difference between two files.
   3.   TREE: This command displays all the directories, Sub-Directories and files contained in them
        in a hierarchical form.
        Syntax:
        C:\>TREE
Syntax
KMICS 38