.

3
INDEX
[Link] TITLE MARKS SIGNATURE

1 LOGO creation using canva tool

2 Poster creation using canva tool

3 Invitation creation using canva tool

Document creation for recent trends in

4
AI using Chat GPT

5 Library Management using Chat GPT

6 Using linked in create a profile

Post a certificate in linked in using chat

7
GPT prompt

8 Installation of Power BI

Load data from various sources in the

9
Power BI

Perform common data cleaning

10
practices in Power BI
EX:NO:1 LOGO CREATION USING CANVA TOOL

AIM:

To Create a logo creation using canva tools.

ALGORITHM:

Step 1: Log In or Sign Up

 Sign in with your email, Google, Facebook, or Apple account.

 If you don’t have an account, click Sign up.

Step 2: Start a New logo Design

 On the Canva homepage, use the search bar and type "logo".

 Select logo (Portrait) or another size, depending on your need.

 Alternatively, click Create a design > Custom size if you have specific dimensions

Step 3: Choose a Template

 On the left sidebar, browse logo templates.

 You can filter by category (e.g., school, event, business, sale).

 Click a template to apply it to your design.

Step 4: Customize the logo

 You can now edit each element of the template or start from scratch.

Editable elements:

· Text – Click to edit font, size, color, alignment.

· Images – Upload your own or use Canva's free stock photos.

· Graphics – Add icons, illustrations, shapes from the Elements tab.

· Colors – Customize background or elements using the color palette.

Step 5: Add or Upload Content

 Click Uploads (left panel) to upload your images or icons.

 Drag and drop them into your design.

Step 6: Preview and Final Touches

 Review spacing, alignment, and spelling.

 Use the Position and Align tools to organize content.

 Preview the logo using the Preview or Present \

 button.

Step 7: Download or Share

 Click the Share button (top-right).

 Choose Download:

 File type: PDF (best for print), PNG or JPG (for digital use).

 Set quality and size if needed.

 Or, share via link, email, or social media directly from Canva.
OUTPUT:

RESULT:
Thus the logo creation using canva tool was successfully created.

EX:NO:2 POSTER CREATION USING CANVA TOOL

AIM:

To Create a poster creation using canva tools.

ALGORITHM:

Step 1: Log In or Sign Up

 Sign in with your email, Google, Facebook, or Apple account.

 If you don’t have an account, click Sign up.

Step 2: Start a New Poster Design

 On the Canva homepage, use the search bar and type "Poster".

 Select Poster (Portrait) or another size, depending on your need.

 Alternatively, click Create a design > Custom size if you have specific dimensions

Step 3: Choose a Template

 On the left sidebar, browse Poster templates.

 You can filter by category (e.g., school, event, business, sale).

 Click a template to apply it to your design.

Step 4: Customize the Poster

 You can now edit each element of the template or start from scratch.

Editable elements:

· Text – Click to edit font, size, color, alignment.

· Images – Upload your own or use Canva's free stock photos.

· Graphics – Add icons, illustrations, shapes from the Elements tab.

· Colors – Customize background or elements using the color palette.

Step 5: Add or Upload Content

 Click Uploads (left panel) to upload your images, logos, or icons.

 Drag and drop them into your design.

Step 6: Preview and Final Touches

 Review spacing, alignment, and spelling.

 Use the Position and Align tools to organize content.

 Preview the poster using the Preview or Present button.

Step 7: Download or Share

 Click the Share button (top-right).

 Choose Download:

 File type: PDF (best for print), PNG or JPG (for digital use).

 Set quality and size if needed.

 Or, share via link, email, or social media directly from Canva.
OUTPUT:

RESULT:

Thus the poster creation using canva tool was successfully created.

EX:NO:3 INVITATION CREATION USING CANVA TOOL

AIM:

To Create a invitation creation using canva tools.

ALGORITHM:

Step 1: Log In or Sign Up

 Log in with your email, Google, Facebook, or Apple account.
 Don’t have an account? Click Sign Up (it’s free).
Step 2: Start a New Invitation Design
 In the search bar at the top, type “Invitation” and press Enter.
 Choose a format:
 Invitation (Portrait or Landscape) – default size: 5 x 7 inches.
 Or click Create a Design > Custom size for specific dimensions.
Step 3: Choose a Template
 Browse hundreds of free and premium invitation templates.
 Use filters like:
 Theme: birthday, wedding, baby shower, party, etc.
 Style: elegant, minimalist, modern, floral, etc.
 Click on a template to begin customizing it.
Step 4: Customize Your Invitation
📝 Edit the Text

 Click on any text box to change the:

 Event title (e.g., You're Invited!)
 details (name, date, time, venue, RSVP info)
 Font style, size, color, alignment, spacing

🎨 Change Colors

 Click on elements to change their colors to match your event theme.

 Use your brand colors or Canva’s pre-made palettes.
🖼 Add Images or Logos

 Go to Uploads to upload personal photos or logos.

 Drag and drop them into your design.
 You can also use Canva’s free stock images and illustrations from the Elements tab.
✨ Add Design Elements
 Use stickers, shapes, icons, borders, or illustrations from the Elements tab to make it more
festive.
Step 5: Fine-Tune the Design
 Use Position to arrange elements (bring forward/backward).
 Align items using the Guides and Snap to grid.
 Zoom in to check details and fix spacing or alignment.
Step 6: Preview Your Invitation
 Use the Preview (eye icon) to see how the final invite looks.
 Double-check all details: names, date, time, venue, RSVP, etc.
Step 7: Download or Share
 Click Share > Download
 Choose format:
 PDF Print – best for printing.
 PNG or JPG – best for digital sharing (e.g., WhatsApp, email).
 Optional: Add bleed and crop marks for professional printing.
- Or, share directly via: Email,Social Media, Canva link (view-only or editable)

OUTPUT:
RESULT: Thus the invitation creation using canva tool was successfully created.

[Link] EMERGING TRENDS IN AI

 AIM:

To Create document for emerging trends in AI using Chatgpt.

1. Introduction

Artificial Intelligence (AI) is transforming the modern world by enabling machines to perform complex
tasks that typically require human intelligence. It combines data, algorithms, and computing power to
simulate learning, reasoning, and problem-solving. In today’s digital era, AI is a core component behind
automation, smart analytics, and decision support systems across multiple sectors such as healthcare,
finance, manufacturing, and education. The continuous growth of AI technologies has paved the way for
smarter, more adaptive, and efficient systems that redefine the future of innovation.

2. Emerging Trends in AI

AI is progressing rapidly, giving rise to new technologies and applications that are reshaping industries.
Some of the key emerging trends include:

•Generative AI: Advanced models like ChatGPT, Gemini, and Midjourney generate high-
quality text, code, and visuals, enabling creative automation and intelligent content design.

•AI-Powered Automation: Intelligent robots and software bots enhance productivity by

automating complex industrial and business processes.

•AI in Cybersecurity: Machine learning algorithms now detect and respond to cyber threats in
real time, ensuring stronger digital protection and incident response.

•Ethical and Responsible AI: New frameworks emphasize fairness, accountability, and
transparency to prevent bias and misuse of AI technologies.

•AI in Healthcare and Medicine: AI-driven analysis aids in early disease prediction, virtual
health assistants, and customized treatment recommendations.

•Quantum AI: The integration of quantum computing with AI promises faster data processing
and breakthroughs in optimization and cryptography.

3. Conclusion
The emerging trends in AI signify a shift toward smarter, autonomous, and ethical systems that enhance
both human life and industrial performance. However, as AI continues to advance, it also introduces
challenges such as data privacy, bias management, and the need for human oversight. Balancing
innovation with ethical responsibility will determine how beneficial AI becomes for society at large.

4. Future Enhancements

The future of Artificial Intelligence will continue to expand in the following directions:

•AI for Sustainability: Utilizing AI to monitor and manage resources, reduce carbon emissions,
and support climate research.

•Human–AI Synergy: Strengthening cooperation between humans and intelligent systems for
creative problem-solving.

•AI in Education: Personalized tutoring systems that adapt to individual learning styles and
progress levels.

•Autonomous Technologies: Self-driving vehicles, drone delivery systems, and intelligent

infrastructure for smart cities.

•Neuro-Symbolic AI: Combining neural networks with symbolic reasoning to make AI more
explainable and human-like in understanding.

RESULT:
Thus the document was created using chat GPT.

[Link] LIBRARY MANAGEMENT SYSTEM

 AIM:

To Create document for library managemnet system using Chatgpt.

1. Introduction

A Library Management System (LMS) is a software application designed to manage and automate
library functions efficiently. It helps in organizing books, tracking issued and returned items, and
maintaining member details. The system aims to streamline library operations while improving
accessibility and accuracy.

2. Objectives of the Library Management System

The main goal of a library management system is to simplify the process of managing library materials
and user interactions. It reduces manual work, saves time, and increases productivity. The system
ensures proper cataloging of books and provides easy access to users through digital means.

3. Key Modules of the System

A complete LMS consists of several integrated modules such as:

•Book Management: Stores and organizes information about all books and materials.

•Member Management: Handles registration, membership renewals, and user profiles.

•Transaction Management: Tracks book lending, returns, and renewals.

•Report Generation: Creates analytical and statistical reports for administrative purposes.

4. Database Design and Functionality

The LMS database serves as the backbone of the system. It contains detailed records of books, authors,
publishers, and users. The data is structured to allow quick searches, filtering, and updates. SQL-based
databases are commonly used for storing and retrieving information efficiently.
5. Automation in Library Operations

Automation in library systems reduces repetitive tasks such as manual record-keeping and fine
calculation. It provides real-time updates on book availability and borrowing history. The system also
sends automatic notifications for due dates, new arrivals, and membership reminders.

6. Digital and Cloud-Based Libraries

Modern libraries are evolving toward digital platforms that provide access to e-books, online journals,
and multimedia resources. Cloud-based LMS solutions allow users to access resources from anywhere,
anytime. These platforms support digital literacy and promote remote learning.

7. Advantages of Using a Library Management System

•Minimizes human errors and saves time.

•Improves the accuracy of data and records.

•Enhances the user experience through digital access.

•Enables librarians to focus on knowledge curation rather than manual administration.

•Supports scalability and integration with other educational platforms.

8. Security and Data Protection

Data protection is essential for maintaining confidentiality and integrity within the LMS. Access control
mechanisms, encryption, and regular backups safeguard user and library data. Proper cybersecurity
measures prevent unauthorized access and data breaches.

9. Challenges and Future Enhancements

Challenges such as limited funding, staff training, and software maintenance affect the adoption of
library systems. In the future, Artificial Intelligence (AI) and Machine Learning (ML) can be integrated
to recommend books, predict user interests, and enhance overall management efficiency.
10. Conclusion

The Library Management System is a vital tool for modern educational and research institutions. It
ensures organized, efficient, and digital management of resources. By adopting advanced technologies,
libraries can continue to serve as powerful centers of learning, information, and innovation.

RESULT:
Thus the library management using chat GPT was successfully created.

[Link] Using linked in create a profile

AIM:
To Create a profile in linkedin

ALGORITHM:
Step1:CreateYourAccount

* Open[[Link]]([Link]
* Signup with your email and password
* Enter your**name**,**location**,and**college name**

Step2:Uploada Professional Profile Photo

* Use a **clearheadshot**withgoodlighting
* Dress neatly(likehowyou’ddressfor aninterview)
* Smile gently–look approachable

Step3:Adda Headline**

*Use this formula:

**[Your Course] Studen t|Interested in[Field/Skills] |Open to Opportunities**

Example:
*[Link] ComputerScience Student| Passionate about Web Development &AI
|Seeking Internships*

---

Step4:Write the“About” Section

*Summarize:
* Who you are (student,course)
* Your skills
* Your goals
* What you’re looking for(internships ,learning ,networking)
Example:

> I’ma final-year [Link]. Computer Science student with a passion for coding, problem-
solving ,and learning new technologies. I’m currently exploring opportunities in
software development and open to internships that help me grow and apply my skills.

---

Step5:AddEducationDetails

* College name
* Degree (e.g.,[Link],[Link].,BBA)
* Years attended
* Add any achievements or activities

Step6:AddSkills

* Listatleast5–10skills,

e.g.:
* C /C++
* Python
* Teamwork
* MSExcel
* Communication
* Leadership
* Java,etc.

Step7:AddProjects(IfAny)

* Nameofthe project
* What youdid
* Toolsused(e.g.,Python,HTML,etc.)

Step8:Add Certifications(IfAny)

* From platforms like:

* Coursera
* Google
* LinkedIn Learning
 Step9:Connect with
People

* Start connecting with:

* Classmates
* Professors
* Alumni
* People in your field of interest

Step10:StayActive

* Like and commen ton posts

* Share interesting articles or your own learning
* Post when you complete a course ,project ,or achievement
OUTPUT:

RESULT:

Thus the linked in profile was successfully created.

[Link] Using linked in post a invitation

AIM:

Post a certificate or invitation in linked in using chat gpt

ALGORITHM:

1. Prepare the Content:

Make sure your certificate or invitation is saved in ac

Lean image(PNG/JPG) or PDF format. Write a short caption highlighting:

What the certificate/invitation is for

Why it’s meaningful or relevant

Any relevant tags(e.g. ,event names ,is using organization)

2. Log Into LinkedIn:

Go to [Link]

and login to your profile.

 3. Create a New Post:

Click on “Start a post” at the top of your homepage.

4. Write Your

Caption: Include:
 A short description of the achievement or event

A thank you to the is using organization or host(If applicable)

Relevant a tags(e.g., #Certificate, #Professional

Development ,#Networking) Optionally, tag people or organizations

involved

5. Upload the Certificate/Invitation:

Click on the photo icon (for images) or document icon (for PDFs).

Select the certificate/invitation file from your device and upload

it.

6. Review and Post:

Double-check spelling ,tags, and formatting.

Click “Post” to publish.

OUTPUT

RESULT:
Thus the linked in post was successfully created.

[Link] INSTALLATION OF POWER BI

AIM:

To Install PowerBI in windows 10.

ALGORITHM:

Install the Power BI Desktop application

Note

Power BI Desktop is only available on Windows operating systems. For Mac users consider
Boot Camp to setup a Windows partition on your Mac computer.
[Link]

You must first verify if you have a 32-bit or a 64-bit Windows operating system. To check
your operating system type:

Step 1. From your Windows operating system, open Control Panel, select System and
Security, and then choose System.

Step 2. You'll be able to identify if your operating system is 32-bit or 64-bit based on the
System type field as shown in the screenshot below.

Step3. If you have a 64-bit Operating System, select the PBIDesktopSetup_x64.exe box or if
you have a 32-bit Operating System select the [Link] box and select
Download.

Step 4. After the download is finished, open the file appropriately named either
PBIDesktopSetup_x64.exe or [Link].
Step 5. In the pop-up window for the Power BI Setup Wizard, select your preferred
Language and select Next.

Step 6. After the Setup Wizard computes the space requirements, select Next.

Step 7. Accept the terms in the License Agreement and select Next.

Step 8. Choose where Power BI should be installed and select Next. It's best practice to keep
Power BI in the Program Files of your C: drive, and should automatically install to the C:\
Program Files\Microsoft Power BI Desktop\ directory.

Step 9. Select Next after configuring the destination folder, then Install.

Step 10. Finally select Finish to complete the installation.

OUTPUT:
RESULT:

Thus the PowerBI software was successfully installed.

[Link] LOAD DATA FROM VARIOUS SOURCES IN THE POWER BI

AIM:

To create load data from various sources into Power BI

ALGORITHM

1. Open Power BI Desktop:

Launch Power BI Desktop only our computer.

2. Select “Get Data”:

Click on the Home tab→ select Get Data →choose the desired data source(such as
Excel, CSV, SQL Server, Web, etc.).
3. Choose Data Source Type:
A window appears showing multiple data source options .Select the type of source you want
to connect to, for example:
o Excel Work book
o Text/CSV File
SQL Data base
Web Data
Share Pointor Cloud Services
Connect to the Data Source:
Browse to the file location or enter the connection details(like server name ,credentials,
or URL) and click Connect.
4. Select the Required Data Tables:
[Link] the relevant ones
you need to load.
5. Preview and Transform Data:
Click Transform Data If you want to clean modify the data(remove columns, change data
types, filter rows, etc.) using Power Query Editor.
6. Load Data into Power BI:
After reviewing or transforming ,click Load to import the data into Power BI’s data
model.

7. Verify Data:
Check the Data View to ensure that all records have been loaded correctly and that relationships
between tables are set properly.

8. Save the Project:

Save your Power BI file(.pbix)to keep your imported data and applied.
OUTPUT:

RESULT:

Thus the load data from various sources into powerbi’s has been executed successfully.
[Link] PERFORM COMMON DATA CLEANING PRACTICES

AIM

Data preparation In this section, we explore methods to transform data.

Transforming the data by renaming tables, updating data types, and appending tables
together ensures that the data is ready to be used for reporting. In some instances, this
means cleaning the data up so that similar sets of data can be combined. In other
instances, groups of data are renamed so that end users more easily recognize them
and report writing is simplified.

ALGORITHM:

1 :Import the Data

o Open Power BI Desktop.

o Click on Home →Get Data →Excel/CSV/Text/SQL Server ,and import your

dataset.

2. Load the data into the Power Query Editor by selecting Transform Data.

3. Remove Unwanted Columns

o Identify un necessary or irrelevant columns.

o Right-click on the column header →Remove Columns.

4. Rename Columns

o Double-click on column header store name them with meaningful names

(e.g., “Emp_ID” →“Employee ID”).

5. Handle Missing Values

o Select a column→ Transform →Replace Values or Remove Rows →Remove Blank

Rows.

o Alternatively, replace missing values with a default(e.g.,0or“Unknown”).

6. Remove Duplicates

o Select all relevant columns →Home →Remove Rows →Remove Duplicates.

7. Chang e Data Types

Go to each column and set the correct data type(Text ,Whole Number, Date, etc.).

o Use Transform →Data Type.

8. Trim and Clean Text

o Select text columns→ Transform →Format →Trim(removes extra spaces).

o Transform→ Format→ Clean(removes non-printable characters).

9. Create Conditional Columns(if needed)

o Use Add Column →Conditional Column to create new data categories

based on conditions(e.g., “Sales>5000=High Performer”).

10. Merge or Append Queries(optional)

o Combine multiple data sets using Home →Merge Queries or Append

Queries.

11. Close &Apply

 OUTPUT:
BEFORE CLEARING THE DATA

AFTER CLEARING THE DATA

RESULT:

Thus the data set was successfully cleaned using Power.