ST.

CLARE’S CONVENT SCHOOL

IT PROJECT
Submitted By: Srashti Rawat
Submitted To: Mrs. Pooja Srivastava
Class: 10 ‘C’

Roll No: 44
Subject Code: 402
Signature:
 Acknowledgement
I would like to express my special thanks of gratitude
to my Information Technology teacher “Mrs. Pooja
Srivastava” for their able guidance and support in
completing my project.
I would also like to extend my gratitude to the
Principal “Sr. Seline Maria Josephine” for providing me
with all the facility that was required.
Date: Srashti Rawat
27/01/2025 10 ‘C’
Table of Contents
S. No. Contents
Practical 1

01
Practical 2

02
Practical 3

03
Practical 4

04
Practical 5

05
Practical 6

06
Practical 7

07
Practical 8

08
Practical 9

09
Practical 10

10
Practical 11

11
Practical 12

12
Practical 13

13
Practical 14

14
Practical 15

15
Practical No. 01

Q. Create a document on the topic “India is a Developing Nation”.

-Add a suitable heading style to the title.

-Apply a paragraph style on the first paragraph as ‘Text body indent’.

-Apply fill format feature to the rest of the paragraphs.

-Save and close the document.

Step 1: Write three paragraphs on the topic “India is a Developing Nation”.

Step 2: Copy the heading and apply style as heading 1.

Step 3: Copy the first paragraph and then click on Format tab > Styles and Formatting > Text body
indent.

Step 4: Again copy the first paragraph and click on fill format icon and click on the rest two paragraphs
one by one.

Step 5: Press Ctrl+S shortcut key to save the document. Name it as you want and close the software
Open Office Writer.
Practical No. 02

Q. Create a new style with mentoned formatting options such as font style.
“Baskerville Old Face”, font color “Blue”, text highlight color as “Red”, and font
size “18”.Text should be written in “bold”. Save this style as “My list”.
Step 1: Type one paragraph as content.

Step 2: Copy the paragraph and click on Format tab > Styles and Formatting or F11.

Step 3: In the dialog box under the close button there is an option that says 'New style from Selection',
then in the drop down box again click on New Style from Selection. A box will open asking the Style
name enter 'My list' after setting the font style as “Baskerville Old Face”, font color “Blue”, text highlight
color as “red”, and font size as “18” and press the “Bold” icon.

Step 4: Save the style by clicking on OK.

Practical No. 3

Q. Write a paragraph on 'Artificial Intelligence' and update that paragraph

with the'Text body indent' style.
Step 1: Write a paragraph on 'Artificial Intelligence' and type the heading as the topic given.
Step 2: Copy the paragraph then click on Format tab > Styles and Formatting or F11.
Step 3: In the dialog box find the paragraph style 'Text body indent' and click on it.
Step 4: Save the document using Ctrl+S shortcut key or the save option from the Ribbon.
Practical No. 04

Q. Create a ‘Resume’ or ‘Bio data’ and add suitable title, subtitle and page style
on it.
Step 1: Find a resume template online and download it and open in your document or make it on your
own.

Step 2: Enter the details asked.

Step 3: Add title in the document.

Step 4: Add subtitle style to all the rest content.

Step 5: Add a suitable page style on it and save the document.

Practical No. 05

Q. Write on the topic “Importance of Discipline” in a student’s life. Add

relevant pictures at the top of the page after the title.
Step 1: Type “Importance of Discipline” and apply ‘Align Centre’ and ‘bold’ and underline the heading.

Step 2: Write a few important topics related to that topic.

Step 3: Insert an image after the heading and resize it as your needs.

Step 4: Save the document.

Practical No.6

Q. Creating a Table in Access

1. Open Microsoft Access

 Open your Access application.

 Create a new database by clicking on File → New → Blank Database, or
open an existing database.

2. Open the Table Design View

 Navigate to the Create tab on the Ribbon.

 Click Table Design to start defining a table manually.

3. Define the Table Structure

 In the design view, you can define the columns (fields) for your table:
o Field Name: Enter the name of each column.
o Data Type: Choose the type of data (e.g., Short Text, Number,
Date/Time).
o Description (Optional): Add a description for each field to clarify its
purpose.
4. Set the Primary Key
Select the field that will uniquely identify each record (e.g., ID field).

 Click the Primary Key button on the toolbar (a key icon) to set it as the
primary key.

5. Save the Table

 Press Ctrl + S or click the Save icon.

 Enter a name for the table (e.g., Customers, Orders) and click OK.

6. Add Data to the Table

 Switch to Datasheet View by clicking on the View button in the toolbar or

Ribbon.
 You can now enter data directly into the table's rows and columns.
7. Adjust Table Properties (Optional)

 Modify field properties like field size, input masks, or validation rules:

In Design View, click on a field and use the Field Properties section at the
bottom of the window.

8. Save Changes

 After making any modifications, save your table again to ensure all
changes are retained.
Practical No. 7
Q. Creating a Relationship between Tables

1. Open the Database

 Open the Access database containing the tables you want to relate.

2. Open the Relationships Window

 Go to the Database Tools tab in the Ribbon.

 Click on Relationships.
This opens the Relationships window where you can manage table
relationships.

3. Add Tables to the Relationships Window

 In the Relationships window, click on Show Table (a dialog box will

appear).
 Select the tables you want to relate and click Add.
 Click Close once all the required tables are added
4. Define the Relationship

Drag and Drop Fields:

o Drag the primary key (e.g., CustomerID) from one table to the
corresponding foreign key (e.g., CustomerID) in another table.

Edit Relationship Options:

o The Edit Relationships dialog box will appear.
o Confirm the fields being related (ensure they are of the same data
type).
o Choose relationship type (e.g., One-to-Many, One-to-One, or
Many-to-Many using junction tables).
5. Enforce Referential Integrity

 In the Edit Relationships dialog box, check the Enforce Referential

Integrity option if:
o You want to prevent orphaned records in related tables.
o Example: You can’t delete a customer if there are associated orders
in the orders table.

6. Enable Cascade Options (Optional)

 You can check:

o Cascade Update Related Fields: Automatically updates foreign key
values when the primary key changes.
o Cascade Delete Related Records: Automatically deletes related
records when a record in the primary table is deleted.

7. Save the Relationship

 Click Create to establish the relationship.

 The relationship will now appear as a line connecting the fields in the
Relationships window:
o 1 (One): Primary key side.
o ∞ (Many): Foreign key side.

8. Test the Relationship

 Enter data in both tables to ensure the relationship is working correctly.

 If you enforce referential integrity, Access will block invalid entries.

9. Save the Relationships

 Click Save (Ctrl + S) in the Relationships window to retain your changes.

Practical No. 8
Q. Creating a Form:

1. Open the Database

 Open the Access database where you want to create the form.

2. Use the Form Wizard (Optional)

If you want more control during the process, use the Form Wizard:

1. Go to the Create tab in the Ribbon.

2. Click Form Wizard in the Forms group.
3. In the wizard:

o Select the table or query you want to base your form on.
o Choose the fields you want to include in the form.
o Select a layout (e.g., Columnar, Tabular, Datasheet).
o Name the form and click Finish.

3. Create a Form Automatically

If you prefer quick creation:

1. Go to the Create tab in the Ribbon.

2. Select Form in the Forms group.
o Access will automatically generate a form for the selected table or
query, displaying all its fields.

4. Create a Form in Design View

For more customization, you can create a form manually:

1. Go to the Create tab.

2. Click Form Design.
3. Add fields and controls to your form:

o Use the Field List pane (click Add Existing Fields in the Design
tab) to drag fields onto the form.
o Use tools from the Design or Format tab (e.g., text boxes, labels,
buttons) to customize the form layout.

5. Adjust Form Layout

  Switch to Layout View to rearrange and resize controls visually.
 Use Design View for more detailed adjustments, such as modifying
properties, adding conditional formatting, or customizing controls.

6. Save the Form

 Press Ctrl + S or click the Save icon.

 Enter a name for the form and click OK

7. Test the Form

 Switch to Form View (in the bottom-right corner or via the Ribbon).

 Use the form to add, edit, or view records.

8. Customize the Form (Optional)

 Add buttons for navigation or actions (e.g., saving, deleting records) using
the Button tool in Design View.

Modify form properties (right-click the form and choose Properties) to fine-tune
behaviors like default views, filters, and themes.
Practical No. 9
Q. Creating a Simple Query Wizard

1. Open Your Database

 Open the Access database where you want to create a query.

2. Choose a Query Creation Method

Access provides different ways to create a query:

1. Query Wizard: For beginners or simple queries.

2. Query Design: For advanced customization.
3. SQL View: For writing SQL code directly.

3. Create a Query Using the Query Wizard

1. Go to the Create tab in the Ribbon.

2. Click on Query Wizard in the Queries group.
3. In the wizard:
o Select the query type (e.g., Simple Query Wizard).
o Choose the table or query and the fields to include.
o Add any grouping or summary options (optional).
o Name your query and click Finish.
4. The query results will open in Datasheet View.

4. Create a Query Using Query Design

1. Go to the Create tab.

 2. Click Query Design.

1. Add the tables or queries you want to include:

o Use the Show Table dialog box to select tables/queries.
o Click Add for each one, then close the dialog.
2. Select the fields:
o Double-click fields in the table window to add them to the query grid,
or drag them down to the grid manually.

5. Run the Query

 Click Run (red exclamation mark) on the Ribbon.

 The query will display results in Datasheet View.

6. Save the Query

 Press Ctrl + S or click the Save icon.

Enter a name for the query and click OK.

OUTPUT:
Practical No. 10
Q. TABLE ON EMPLOYEES INFORMATION:

Query on modification:

Set Criteria to Filter Results

 In the Criteria row of the query grid, specify conditions to filter results.
o Example: To filter for customers in New York, type "New York" in
the Criteria row under the "City" field.
o Use operators like >, <, = for numeric comparisons or LIKE for
partial matches (e.g., LIKE "J*" for names starting with "J").
OUTPUT:
Practical No. 11
Q. Consider a workbook which contains data expenses on stationary items for
four quarters in a year. The data is broken into four quarters and stored in
four different worksheets

Columns Breakdown:

1. Item: Name of the stationary item.

2. Quantity Purchased: Number of units bought.
3. Unit Cost: Price per unit of the item.
4. Total Cost: This would be calculated as Quantity Purchased * Unit Cost.
5. Date of Purchase: Date when the item was purchased.

Quarterly Worksheets:

You’ll have one worksheet for each quarter (Q1, Q2, Q3, Q4), and each of these worksheets will
have a similar structure.

Example Quarterly Breakdown:

1. Q1 (January - March): This sheet contains all stationary purchases made in the first
quarter.

2. Q2 (April - June): This sheet contains all stationary purchases made in the second quarter, and
so on.
Create a “Consolidated Summary” sheet which will show total
expenditure in a year.

Consolidated sheet:
Practical No. 12

Q. Use the subtotal command to display the Total Fee collected for each class.

Also, display Grand Total Fee collected from all classes.

Step 1: Select the range of cells with values for which ‘subtotal’ function needs to be implemented.

Step 2: Click on ‘Data’ tab and then click on ‘Subtotals’ command in the ‘Outline’ command group.

Step 3: The ‘Subtotal’ dialog box will appear on the screen. Click on tge drop-down arrow for the ‘At
each change in’ and select the desired field.

Step 4: Click the drop-down arrow for the ‘Use Function’ field to select the desired function.
Step 5: In the ‘Add subtotal to’ field, select the desired column and then click on ‘OK’ button.

OUTPUT-
Practical No. 13
Q. Using Subtotal calculate the revenue generated from the sale of each good.

GOODS PRICE
Pen 1000
Pencil 2000
Pen 500
Pencil 1200
Pen 500
Pencil 200

Step 1: Select the range of cells with values for which ‘subtotal’ function needs to be implemented.

Step 2: Click on ‘Data’ tab and then click on ‘Subtotals’ command in the ‘Outline’ command group.

Step 3: The ‘Subtotal’ dialog box will appear on the screen. Click on tge drop-down arrow for the ‘At
each change in’ and select the desired field.

Step 4: Click the drop-down arrow for the ‘Use Function’ field to select the desired function.
Step 5: In the ‘Add subtotal to’ field, select the desired column and then click on ‘OK’ button.

OUTPUT:
Practical No. 14
Q. Create a student’s plant to score greater than 90% aggregate marks (in five
different subjects), if he has secured 95, 87, 89, 91 in four different subjects
(Subject A, Subject B, Subject C, Subject D, respectively).

Step 1: Navigate to the Data tab in the top menu. Click What-If Analysis (found in the Forecast
group). Select Scenario Manager from the dropdown menu.

Step 2: In the Scenario Manager dialog box, click Add. Enter a name for your scenario (e.g.
“Minimum Goal")

.
Step 3: In the Changing Cells field, select the cell for Subject E Marks (e.g., B6). Click OK to
proceed.
Step 4: Enter the marks you want to test for Subject E (e.g., 88). Click OK to save the scenario.
Practical No. 15
At the end of the course, a student participants in 3 exams. The passing score
is 85%. All the exams have the same weightage, so the overall score is
calculated by average of their 3 scores. The student has given 2 out of 3 exams
and secured 82%. Apply ‘Goal Seek’ method to find what score the student
requires in the third exam to pass the entire course.
Steps in Excel

1. Open Excel:
o Open a new Excel file.
2. Set Up the Table:
o Create the following structure in your spreadsheet:

Exam Score (%)

Exam 1 82

Exam 2 82

Exam 3 [Enter a formula here]

Average Score [Formula]

 In cell B4, enter this formula to calculate the average score:

=AVERAGE(B1:B3)

3. Open Goal Seek:

o Go to the Data tab in Excel.
 o Click on What-If Analysis and select Goal Seek.
4. Set Up Goal Seek:
o In the Set Cell field, select the cell that calculates the average score (e.g., B4).
o In the To Value field, enter 85 (the passing score).
o In the By Changing Cell field, select the cell for Exam 3 (e.g., B3).

5. Run Goal Seek:

o Click OK.
o Excel will calculate the score needed in Exam 3 to reach an average of 85%.
6. Result:
o Excel will display the required score for Exam 3 in the selected cell.
 Bibliography
The websites and applications used in the
project:

 Wikipedia.com
 docs.google.com
 Open Office Writer
 Microsoft Excel
 Microsoft Access
 Microsoft Word