Scribd
Upload
386 views4 pages

CAIM Practical Exercises Overview

The document provides a list of practical exercises to be completed in Microsoft Word, PowerPoint, Excel, and Access. In Word, tasks include creating a bio-data, inserting text features, and using mail merge. In PowerPoint, tasks involve creating presentations and using various slide features. Excel exercises include creating student and employee data sheets, using formulas, sorting, filtering, and generating graphs. Access exercises involve creating relational databases with tables, relationships, forms and queries.

Uploaded by

Shakti dodiya
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
386 views4 pages

CAIM Practical Exercises Overview

The document provides a list of practical exercises to be completed in Microsoft Word, PowerPoint, Excel, and Access. In Word, tasks include creating a bio-data, inserting text features, and using mail merge. In PowerPoint, tasks involve creating presentations and using various slide features. Excel exercises include creating student and employee data sheets, using formulas, sorting, filtering, and generating graphs. Access exercises involve creating relational databases with tables, relationships, forms and queries.

Uploaded by

Shakti dodiya
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
  • MS POWERPOINT
  • MS EXCEL
  • MS WORD
  • MS ACCESS
  • Adding New Records

CAIM PRACTICAL EXERCISE LIST

MS WORD

1. Prepare your bio-data in Ms Word.


2. Create a macro to draw smily in Ms Word document.
3. Write a letter to wish “Happy New Year” and send it to 5 friends using mail merge.
4. Type a paragraph (10 lines) about “Uses of Computer” and use following features.

1) Bold 10) Picture


2) Italics 11) Clip art
3) Underline 12) Shapes
4) Page border 13) Word art
5) Header and footer 14) Spelling and grammar
6) Page number 15) Line spacing
7) Page layout and margin 16) Text alignment (Left, right,
8) Font type justify, center)
9) Date and time

MS POWERPOINT
1. Prepare a photo album using PowerPoint. (10 slides, automatic slide change)
2. Create a presentation on “Uses of Computer” and use following features.

1) Slide layout 7) Custom animation


2) Header and footer 8) Slide transition
3) Slide number 9) Slide show
4) Date and time 10) Slide sorter view
5) Slide orientation 11) Slide handout master view
6) Slide background 12) Slide notes view

MS EXCEL

1. Prepare student mark sheet as given below and filter the data by grade.

Roll No Name Subject Subject Subject Total Average Result Grade


(1 to 5) 1 2 3 (Pass/ >70 A
fail) >50 B
>35 C
< 35 Fail
2. Prepare student mark sheet as given below.

Result
Roll No Subject Subject Subject
Name Total Average (Pass/
(1 to 5) 1 2 3
fail)

1) Enter the data for 5 students.


2) Use conditional formatting to highlight subject marks < 35 with red color and
subject marks >35 with blue.
3) Sort the data by name.

3. Prepare a worksheet as shown below.

====================================================================

EMP NO EMPNAME JAN FEB MAR APRIL TOTAL AVG

====================================================================

A0001 MANISH 10000 12000 10000 13000 45,000.00 11250

B0001 RAMAN 20000 12600 32000 42000 106,600.00 26650

C0001 DHIREN 12000 30000 12500 16500 71,000.00 17750

A0001 DIPESH 20000 10200 18200 15600 64,000.00 16000

A0002 VIPUL 15000 40000 35000 25000 115,000.00 28750

B0002 JATIN 15500 25500 35000 12000 88,000.00 22000

C0003 BHAVIN 35000 15500 15500 13000 79,000.00 19750

====================================================================

1) Calculate the total sales made by each salesman.


2) Find out maximum sale in each month.
3) Find out minimum sale in each month.
4) Find out the average sales of each salesman.
5) Sort above data on emp-name in ascending order.
6) Draw a bar graph/pie for total corresponding to salesman.
MS ACCESS
1. Create two Tables Customer and Supplier as given below.

Customer Data Type Supplier Data Type

C _no Counter S_no Counter

C _name Text S_name Text

C _add Text I_code Text

C _city Text I_desc Text

C _phone Text Price Number

S_no Counter Tax Number

Qty Number S_ctiy Text

1) Create the primary key on s_no to s_no.


2) Relationship between two tables on s_no to s_no
3) Create form for two table and enter 3 records in each table.

2. Create a Student Database which contain a table named studinfo, The structure of table
is as following and give answers of questions.

Field Name Field Type Length Description.

ss_name Text 20 Surname of Student.


sn_name Text 20 Name of Student.

sl_name Text 20 Father name of Student.

sadd_1 Text 20 Address-1 of Student.

scity Text 15 City Name of Student.

spin Text 6 Pincode.

sdi Text 10 District Name of student.

sb_date date Birth Date of Stuednt.

1) Enter 5 Records in table in DataSheet view.


2) Save & Close Table and Database and exit from Access.
3) Load Access & Retrieve your saved table.
4) Add New Records at the Bottom of your table.

Common questions

Powered by AI

Slide orientation in PowerPoint can significantly affect the visual impact of a presentation. A landscape orientation is most common and suitable for wide content, enhancing readability for larger audiences. Portrait orientation can focus on detailed vertical content, but may limit space for graphics. Choosing the right orientation helps in effectively organizing and presenting information to suit the audience and content needs .

The Slide Sorter view in PowerPoint provides a beneficial overview of the presentation layout, facilitating easy reordering, organizing, and managing of slides. It is useful for identifying and correcting presentation flow issues, ensuring logical sequence and effective storytelling. This view also assists in applying uniform transitions and timing adjustments across slides .

To formulate a macro for drawing a smiley face in Microsoft Word, record a sequence of drawing shapes such as circles for the face and eyes, and a semi-circle for the mouth. Use the 'Record Macro' feature to automate these actions, then assign the macro to a button for future use. This requires understanding of the Word drawing toolbar and basic VBA scripting .

Using a primary key in Access tables ensures unique identification of records, preventing duplicates and maintaining data integrity. It allows for efficient indexing, which enhances search and sort performance. Additionally, primary keys enable relational database functionalities by allowing tables to link through relationships, crucial for maintaining referential integrity .

Excel bar graphs visualize sales data, making trends and comparisons clear, such as contrasting sales figures across different employees. They enhance understanding of performance metrics by providing immediate visual insights into total and average sales over time, highlighting significant differences and identifying top performers. This supports informed decision-making and performance tracking .

To creatively present the 'Uses of a Computer' in Microsoft PowerPoint, employ custom animations and transitions to introduce topics dynamically. Utilize slide layouts and backgrounds to maintain a coherent theme, and add headers, footers, and relevant images or clip art to enhance understanding. Use slide sorter and handout master view for organizing content and delivering a polished presentation .

Access forms streamline data entry by providing a user-friendly interface for inputting data into tables. Tables like 'studinfo' in a Student Database allow for structured storage of student details, ensuring data integrity and ease of retrieval. The relationship between tables ensures consistent data across entries, and forms enable efficient data modification and querying .

When creating a "Happy New Year" letter using mail merge in Microsoft Word, emphasize the features such as bold, italics, and underline for text emphasis, and utilize mail merge to personalize and send to multiple recipients. Additionally, the inclusion of page borders, headers, and footers can enhance the presentation of the letter .

To use conditional formatting in Excel for highlighting data thresholds, first select the range of cells to format. Then, set rules such as marking values less than 35 with red and greater than 35 with blue. This involves applying 'New Rule' under the 'Conditional Formatting' menu and choosing 'Format cells that contain' option to define the criteria .

Mail merge in business personalizes mass correspondence by integrating a data source with a Word document, allowing unique data fields like names and addresses to be inserted into standardized letters. This customization ensures communication is personalized at scale, enhancing recipient engagement and maintaining consistency across bulk mailings .

CAIM PRACTICAL EXERCISE LIST MS WORD 1. Prepare your bio-data in Ms Word. 2. Create a macro to draw smily in Ms Word document
>35 C < 35 Fail 2. Prepare student mark sheet as given below. Roll No (1 to 5) Name Subject 1 Subject 2 Subject 3 Total Av
MS ACCESS 1. Create two Tables Customer and Supplier as given below. Customer Data Type Supplier Data Type
4) Add New Records at the Bottom of your table.

You might also like