Scribd Logo
Upload

Welcome to Scribd!

  • 901 views

    Project File Structure Class X It

    Uploaded by

    RC Sharma
    This document contains instructions for practical assignments to be completed for an Information Technology course. It includes 6 questions - creating a poster on air pollution in MS Word, making a student list table, writing an article on Gandhi & Modern India using MS Word features, designing a student mark sheet and column chart, creating a presentation on various topics, and performing SQL commands to create a database table and insert, display, modify, delete and order records. Students are asked to take prints of completed assignments.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Project File Structure Class X It

    Uploaded by

    RC Sharma
    901 views3 pages
    This document contains instructions for practical assignments to be completed for an Information Technology course. It includes 6 questions - creating a poster on air pollution in MS Word, making a student list table, writing an article on Gandhi & Modern India using MS Word features, designing a student mark sheet and column chart, creating a presentation on various topics, and performing SQL commands to create a database table and insert, display, modify, delete and order records. Students are asked to take prints of completed assignments.

    Original Description:

    PROJECT FILE

    Original Title

    PROJECT FILE STRUCTURE CLASS X IT

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains instructions for practical assignments to be completed for an Information Technology course. It includes 6 questions - creating a poster on air pollution in MS Word, making a student list table, writing an article on Gandhi & Modern India using MS Word features, designing a student mark sheet and column chart, creating a presentation on various topics, and performing SQL commands to create a database table and insert, display, modify, delete and order records. Students are asked to take prints of completed assignments.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    901 views3 pages

    Project File Structure Class X It

    Uploaded by

    RC Sharma
    This document contains instructions for practical assignments to be completed for an Information Technology course. It includes 6 questions - creating a poster on air pollution in MS Word, making a student list table, writing an article on Gandhi & Modern India using MS Word features, designing a student mark sheet and column chart, creating a presentation on various topics, and performing SQL commands to create a database table and insert, display, modify, delete and order records. Students are asked to take prints of completed assignments.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 3

    SYMBIOSIS PUBLIC SCHOOL

    BARWADDA, DHANBAD

    PRACTICAL FILE
    ON
    INFORMATION TECHNOLOGY
    CODE : 402

    SESSION : 2020-21

    SUBMITTED BY: SUBMITTED TO:


    STUDENT NAME : ...... TEACHER’S NAME
    ROLL NO. : ........
    CLASS & SECTION : ...........
    INDEX
    Sr. No. NAME OF PRACTICAL
    INFORMATION TECHNOLOGY
    SUBJECT CODE-402
    PRACTICAL FILE

    Note:- Following assignments to be done in practical File

    Q1- Create a poster for “Air Pollution” in Ms-Word with the following features.
    1. Font face 2. Font size 3. Font color 4. Header & Footer
    5. Images

    Q2: Create a list of 10 students by inserting a table in Ms-Word with the following fields-
    1. Sr. No. 2. Student Name 3. Father’s Name 4. City

    Q3:- Create an article on “Gandhi & Modern India” using maximum feature of MS-Word.

    Q4- Design a mark sheet for a student as shown in figure below and create column chart based on the
    below data:

    Q5:- Create a presentation (6-8 slides) on any one of the following topics.
    1. Air Pollution
    2. Traffic Rules
    3. Water Conservation
    Note: - Take the print of all
    slides. Q6:-
    FIELD NAME DATA TYPE CONSTRAINT
    BOOKID NUMERIC PRIMARY KEY
    SUBJECT VARCHAR(30)
    BOOKPRICE NUMERIC
    a) Write the SQL command to create above table.
    b) Write the SQL command for inserting the following values in the given table.

    BOOKID SUBJECT BOOKPRICE


    1001 INFORMATION TECHNOLOGY 180
    1002 SCIENCE 100
    1003 MATH 125
    1004 ENGLISH 150

    c) To Display those records whose BOOK ID is ‘1001’.


    d) Modify the price by increasing value from ‘125 to 175’ for BOOKID 1003.
    e) Delete the record of BOOKID ‘1004’.
    f) Display the records of all BOOKS in descending order of SUBJECT.

    You might also like