pravalika IT project

Download as odt, pdf, or txt
Download as odt, pdf, or txt
You are on page 1of 23

ACADEMIC

YEAR
2024-25
PROJECT
REPORT ON
SUBJECT
SPECIFIC SKILLS
IN IT 1
NAME: Pravalika.s
ROLL NO: 12
SUBJECT: Information Tecnology

INDEX
S. Page
Title
No. No.
1 Certificate 3

2 Acknowledgement 4

3 Introduction 5

4 Aim of the project 6

5 Practical Questions 7-22

2
CERTIFICATE
This is to certify that Ms
________________ of class ______ sec
______has successfully completed her
project on the topic
__________________________________as
prescribed by Ms ___________________
during the academic year 2024-25
as per the guidelines given by
CBSE.

____________
______________
Signature of Principal
Signature of Co-ordinator

3
_______________
Signature of Subject Teacher

ACKNOWLEDGEME
NT
I, Ms ____________________ would like to
give my warmest thanks to my subject
teacher
Ms ____________________. Her guidance and
advice carried me through all the stages of
completing the project.

I would also like to give special thanks to


our Principal,
Ms Aracha Sinha for her continuous
support.

4
I would also like to thank our co-ordinator,
Ms Devika Patil who helped me to discover
and learn more about the application.

Last but not the least I would like to thank


God and all the staffs of NPS, JP Nagar for
their support and guidance.

Ms ________________

INTRODUCTION
OpenOffice is an open-source office software suite developed by
the Apache Software Foundation, offering free tools for various
productivity needs. Compatible across Windows, macOS, and
Linux, it is a popular alternative to commercial suites.

OpenOffice Writer is a word processor similar to Microsoft Word,


allowing users to create documents with robust text formatting,
templates, and support for multiple file formats.

5
OpenOffice Calc serves as the spreadsheet tool like Excel,
providing data organization, analysis features, and compatibility
with .xls formats.

OpenOffice Base is the database management tool, akin to


Access, enabling users to create and manage databases with
forms, queries, and support for connecting to external systems
like MySQL.

OpenOffice is free, cross-platform, and supports various file


formats, making it ideal for users seeking a cost-effective and
versatile office suite.

AIM OF THE
PROJECT

The aim of this project is to explore the functionalities and


benefits of the Apache OpenOffice suite, focusing on its core
components: OpenOffice Writer, OpenOffice Calc, and
OpenOffice Base. This project seeks to demonstrate how these
tools can effectively serve as cost-free, open-source
alternatives to commercial office software. By examining their
features, compatibility, and practical applications, the project
aims to highlight OpenOffice's value in enhancing productivity
6
for individuals and organizations across various operating
systems. The ultimate goal is to provide insights into the suite’s
capabilities to aid users in making informed decisions for their
document processing, data management, and database needs

Practical Questions
1.Suppose, your school annual day is around the corner. Create a single page brochure to be distributed
among all the guests. It should show all the activities in the form of templates pasted on the brochure.
Use various styles, fonts, and colours of your choice to make the brochure attractive and colourful.
Write the steps to do so.

7
1. Open OpenOffice and Create a New Document

2. Set Up the Page Layout , header and footer

3. Create Margins for Your Brochure

4. Choose a Background Colour

5. Add a Title Section , use different styles,colours and fonts

2.Create your resume and add all the details using different styles.

a. Add your school’s name and address.

b. Add your passport-size photograph.

c. Highlight your achievements.

8
d. Add hobbies.

3.Write an article on the topic 'How is digital learning going to change schools and education?' in about
500 words. Give appropriate headings and subheadings. Create a Table of Contents using the hierarchy of
headings. After the TOC was inserted, you made some changes in the article but the changes were not
reflected in the TOC. Write the steps to update the TOC.

9
How is digital learning going to change schools and
education?

INTRODUCTION

WHAT IS DIGITAL LEARNING

Digital innovation can expand access to educational


opportunities to learners previously excluded - such as those
with disabilities or who speak a minority language - and
enhance learning quality. Open digital schools can make
education systems more inclusive of learners' diverse needs
and more resilient to crises.

Digital learning refers to the use of digital tools, technologies, and


resources to enhance the learning experience. It integrates various
digital platforms and devices—such as computers, tablets,
smartphones, and the internet—into education to support, facilitate,
and sometimes even replace traditional classroom learning methods.

10
ADVANTAGES
Digital learning is transforming schools and education in several profound ways, bringing
numerous advantages for students, teachers, and educational systems overall. Here are
some of the key advantages of digital learning and how it is changing the landscape of
education:

Enhanced Accessibility and Flexibility


• Anytime, Anywhere Learning: Digital learning provides students with the ability to access
educational content from anywhere at any time. Whether at home, on the go, or in school,
students can learn according to their own schedules, making learning more flexible and
convenient.
• Global Access: Digital learning eliminates geographical barriers, allowing students in remote
or underserved areas to access quality education. Students can attend classes online, access
digital libraries, and use learning resources that were previously unavailable to them.
• Inclusive Education: Digital platforms can be tailored to meet the needs of all students,
including those with disabilities, by offering assistive technologies like text-to-speech,
subtitles, and customizable fonts, ensuring equal access to learning.

DISADVANTAGES
While digital learning offers numerous advantages, it also comes with several disadvantages
that can affect students, teachers, and the overall education system. Here are some of
the key challenges and drawbacks:

Lack of Face-to-Face Interaction

• Reduced Social Interaction: Traditional classroom environments foster face-to-face


interactions, which help students develop important social and communication skills.
Digital learning, especially when conducted entirely online, can limit opportunities for
students to interact with their peers and teachers, leading to feelings of isolation or
disconnection.
• Impact on Soft Skills: Skills such as teamwork, empathy, and verbal communication
are often best developed through direct human interaction. The absence of these
experiences in digital learning environments can hinder students' ability to develop
these essential skills.

CONCLUSION

11
Digital learning is poised to significantly transform schools and education by making
learning more accessible, personalized, and engaging. It opens up opportunities for
students to learn from anywhere and at any time, bridging gaps caused by geographical
and socio-economic barriers. With the use of technology, education can be tailored to
meet individual needs, allowing for self-paced learning and greater student
engagement through interactive tools like simulations, videos, and gamification.

At the same time, digital learning fosters collaborative environments, connecting students
and teachers across the globe, promoting teamwork, and helping develop digital literacy
skills essential for the modern workforce. Furthermore, teachers are empowered with
digital tools to enhance their instructional methods, track student progress, and offer real-
time feedback.

However, for digital learning to be fully effective, challenges like the digital divide, lack of
access to technology, and the potential for social isolation need to be addressed.
Additionally, schools must balance digital tools with traditional in-person methods to ensure
that students also develop critical social and practical skills.

Ultimately, digital learning represents a powerful shift in the education landscape, making
learning more inclusive, flexible, and interactive, but it requires careful planning, support,
and investment to ensure that all students benefit from this technological evolution. As we
move forward, a balanced integration of technology and traditional teaching methods will
likely define the future of education.

4.Power Motors has 3 branches all over Bhopal. Each branch maintains monthly sales of different models
of electric scooter and at the end of month mails it to the State Head. Prepare a consolidated sheet
that shows total and average sales made for each model of the electric scooter. You are required to
identify the column headings for the various branches, enter data in three different spreadsheets
indicating different branches and consolidate data to find total sales and average sales for each model.

SHEET 1

12
SHEET 2

SHEET 3

13
SHEET 4

14
15
5.Anshuman created a document on G20 Summit 2023. He asks two of his friends to review the
document and add comments to it using the Track Changes feature of Writer. After receiving the
review, Anshuman wanted to accept or reject changes made by his friends. Lastly, he wanted to
compare the original document with the changed one. Write the steps for Anshuman to complete the
given task using all the required features.

G20 SUMMIT 2023


The 18th Heads of State and Government Summit of the Group of 20
(G20) will take place in September 2023 in New Delhi, India.
Under the Indian Presidency, the G20 in 2023 will focus on the
theme, 'One Earth, One Family, One Future'

Theme: The theme for India's G20 presidency was "Vasudhaiva Kutumbakam –
One Earth, One Family, One Future," reflecting a focus on collective global
responsibility, unity, and sustainability.

1. Agenda and Key Discussions:


• Climate Change: Strengthening global cooperation to address climate
change, promote green energy transitions, and work towards
achieving net-zero emissions.
• Global Health and Pandemic Preparedness: Ensuring equitable
access to vaccines, healthcare, and preparing for future health
emergencies.
• Global Economy: Discussions on global economic stability, supply
chain resilience, sustainable development, and addressing rising
inflation and global debt issues.
• Technology and Digital Transformation: Enhancing international
collaboration in technology and digital innovations, promoting digital
inclusion, and tackling cybersecurity threats.

16
•Geopolitical Tensions: The summit addressed ongoing conflicts,
including the war in Ukraine and tensions in the Indo-Pacific region.
2. Major Outcomes:
• New Delhi Declaration: A consensus-based declaration outlining
commitments for tackling global challenges, such as climate change,
sustainable development, and ensuring equitable growth.
• India’s Presidency: India took over the G20 presidency from
Indonesia, and the country used its leadership to focus on inclusivity,
development, and unity in addressing global issues.
• Russia-Ukraine Conflict: Despite tensions between Russia and
Western nations over the war in Ukraine, the summit managed to
issue a statement calling for a peaceful resolution. The text
emphasized the importance of respecting international law and
sovereignty.
3. Key Participants: The summit was attended by the leaders of G20 member
states, including:
• Prime Minister Narendra Modi (India)
• U.S. President Joe Biden
• Chinese President Xi Jinping
• German Chancellor Olaf Scholz
• French President Emmanuel Macron
• Russian President Vladimir Putin (via video)
• Brazil's President Luiz Inácio Lula da Silva (Lula)
• U.K. Prime Minister Rishi Sunak
Several invited guest countries and international organizations, including the
United Nations, the World Health Organization, and the World Trade
Organization, also participated.
4. Global South Representation: India made efforts to ensure that the voices
of developing and least-developed countries were heard, advocating for
inclusive growth and attention to the concerns of the Global South. This
included discussions on sustainable development, debt relief, and climate
financing.
5. Success in Expansion: During the summit, the African Union (AU) was
granted full membership in the G20, expanding the group to 21 members.
This was seen as a historic step to increase African representation in global
decision-making.

17
Outcomes:
The summit was considered successful in terms of creating a broad consensus
on critical global issues. However, disagreements on certain issues, such as the
Russia-Ukraine conflict, led to some compromises in the final declaration,
leaving out certain details on geopolitical tensions.
Overall, the G20 Summit 2023 highlighted the importance of multilateralism,
shared global responsibility, and collective efforts in tackling both existing and
emerging challenges.

18
6. Create a database to store the academic record of your class.
a. Use your name as the file name for your database.
b. Create the table Student_Info with the following fields: Admin_no, Roll_no, Name, English,
Language, Math, Science, SST, IT, Total and Average.
c. Assign appropriate datatype.
d. Set Admin_no as the primary key.
e. Enter the details of all your classmates.
f. Display the list of students who scored maximum marks.

1. Enable Track Changes in the Original Document:

Before sharing the document with his friends for review, Anshuman needs to enable the
Track Changes feature. This allows him to track all the changes and additions made by his
friends.
Steps:
• Open the document in OpenOffice Writer.
• Go to the Edit menu at the top of the screen.
• Select Track Changes and then click on Record. This will enable the Track Changes
feature.
• Now, Anshuman can save and send the document to his friends for review.

2. Friends Add Comments and Make Changes Using Track Changes:


Anshuman’s friends will follow these steps to review and make changes to the document:
• Open the document in OpenOffice Writer.
• Go to the Edit menu.
• Select Track Changes and then click on Record to start tracking their changes.
• They can make changes to the text or insert comments as needed. Each change (e.g.,
insertions, deletions, or formatting changes) will be highlighted and marked.
• To add comments, they can highlight a part of the text and then go to Insert in the
menu, select Comment, and type their feedback.

3. Accept or Reject Changes After Receiving the Reviewed Document:


After receiving the reviewed document, Anshuman can now choose to accept or reject each
change made by his friends.
Steps:
• Open the document containing the tracked changes.
• Go to the Edit menu.

19
• Select Track Changes and choose Manage Changes. This opens a dialog box where all
the tracked changes are listed.
• In the Manage Changes dialog box, you will see the following options:
• Accept: To accept a particular change made by a friend.
• Reject: To reject a particular change.
• You can either accept or reject changes one by one or use the Accept All or
Reject All buttons to process all the changes at once.
• After reviewing all changes, click OK to close the dialog box.

4. Compare the Original Document with the Changed Document:


After accepting or rejecting changes, Anshuman may want to compare the original
document with the final version to see the differences.
Steps:
• Open the final version of the document (the one with changes accepted or rejected).
• Go to the Tools menu.
• Select Compare Documents.
• In the Compare Documents dialog box, select the Original document (the one
without changes) and the Revised document (the one with accepted/rejected
changes).
• Click OK to start the comparison.
• OpenOffice will display a report showing all the differences between the two versions
(e.g., additions, deletions, formatting changes).
• Anshuman can review the comparison and make sure everything is as intended.

5. Finalizing the Document:


Once Anshuman is satisfied with the changes and comparison:
• He can save the document in its final form.
• To remove the tracking marks (if desired), go to the Edit menu, select Track Changes,
and choose Record to turn off the tracking feature.
• Save the document in the desired format (e.g., .odt or .docx).
By following these steps, Anshuman will be able to effectively use the Track Changes feature
in OpenOffice Writer to collaborate with his friends, review their comments and edits, and
compare the original and modified documents.

20
7. Ankush lives in Happy Home Society. He wants to create a database so as to store and manage the
maintenance dues received from flat owners of the society. Create the following tables for his
database.

21
8. Create a database with the name ‘Exhibition’ that should have the following two tables:
Paintings_Exhibition’ and ‘Student_Sales’ with the given fields. Also, assign the appropriate field type
to every field.
Paintings_Exhibition: The Painting_Exhibition table will have details of the paintings made by the
students.

22
23

You might also like