practical assignment ms word practical exercises pdf free

Subject Explorer

School Subjects

Math & Science

Business & Technology

Electives & Health

Board & Administration

Teaching & Learning

Audio/Video Lectures

Books & Documents

Classifieds

Jobs & Resources

Discussions

Language & Literature

Practice Projects for Microsoft Word

Word 9 Table

In this practice project for Word, students create a document with a title and table. The table has two columns that have different font alignment and incluces various fonts. …

Word 8 Formatting Text

In this practice project for Word, students create a document using a different size and color font for the title than the rest of the paragraph. …

Word 7 Bullets

In this practice project for Word, students create a document with two different types of bullets showing points and subpoints. …

Word 6 Letter

In this practice project for Word, students create a letter. Included in the letter is a heading on the right, indented paragraphs, and the closing and signiture near the middle of the document. …

Word 5 Text And Outline

In this practice project for Word, students create a document that contains several paragraphs of text and also includes an outline with key points and subpoints. …

Word 4 Modified Text

In this practice project for Word, students create a document with the heading on the right, a boldfaced, centered title, and indented paragraphs. The document is double-spaced. …

Word 3 Basic Text

In this practice project for Word, students create a document with the heading on the right, a boldfaced title that is centered, and several paragraphs that are indented. …

Word 22 Preset Headings

In this practice project for Word, students create a document using the preset headings to create a title bar. The document has different alignment and font, blanks, and a short outline. …

Word 21 Formatting Options

In this practice project for Word, students create a document that shows some different effects that can be used with the same font. …

Word 20 Numbered List

In this practice project for Word, students create a document that includes a centered title followed by a numbered list. …

Word 2 Heading 2

In this practice project for Word, students create a document that has a centered title, a heading in the upper right corner, and indented paragraphs. …

Word 19 Advanced Table

In this practice project for Word, students create a document with a table showing a school schedule. The blocks in the table are different sizes and will take individual work within the blocks to …

Word 18 Columns

In this practice project for Word, students create a document with a header and two colomns. The columns include boldfaced and italic font and different alignment. …

Word 17 Columns

In this practice project for Word, students create a document with two identical columns in landscape orientation. Included in each are indented lines and different alignment and font. …

Word 16 Lesson Notes Handout

In this practice project for Word, students create a document like a student handout. This includes an outline with several levels, blanks for students to write on, and different font. …

Word 15 Lesson Notes

In this practice project for Word, students create a document with a header and two outlines. Students are asked to use the automatic numbering and outlining features in Word. They must use different …

Word 14 Table

In this practice project for Word, students create a scoresheet using a table. Students must use different sizes, colors and styles of font, including different alignment. …

Word 13 Outline

In this practice project for Word, students create an outline using the automatic outline in Word, including many levels of subpoints. …

Word 12 Formatting

In this practice project for Word, students create a document with a centered title in all capitals, the first letter of each word slightly larger than the rest. Throughout the document the font is …

Word 11 Formatting

In this practice project for Word, students create a document similar to a test or quiz. They must include points and subpoints, blanks, boldfaced text, tabs, and spacing. …

Resource Type:

Pass it on:

Leave a Reply

Ace your Assessment with Accurate Prep - MS Word Practical Questions

• Downloadable Microsoft Office Training Software 
• Full-length Microsoft Word Practice Tests
• Over 200 Additional MS Word Practice Questions
• Detailed Explanations for Every Microsoft Word Question
• Smart Score Reports

Bonus - Full preparation courses for MS Office: Excel, PowerPoint, Outlook, and more!

• Microsoft Assessments Preparation

MS Word Practical Questions

Microsoft Word is by far the most popular word processing software in use today, and as such, many leading organizations require a high level of proficiency from any candidate applying for a spot. An MS Word assessment can be a challenge even for experienced users, and may include questions regarding functions that you are not familiar with or might have forgotten how to use. 

This is why preparing for your test is the best thing that you can do to improve your chances of passing the test and landing the job. On this page we will answer different types of MS Word practical questions to help you get your prep going, and provide you with the info you need to prepare in the best way you can. 

Preparing with our MS Word PrepPack gives you full access to specialized Microsoft Word training software, where you can prepare for every difficulty level with accurate MS Word test questions and answers.

As a bonus, you will also receive extensive practice resources for all the essential Microsoft Office programs - including Excel , Outlook, PowerPoint , and more. Start practicing today and become a Microsoft Office Ace. 

Arbel , Microsoft Exam Expert at  JobTestPrep .

MS Word Practical Exam

The Microsoft Word practical exam is used to measure your proficiency with MS Word and its many functions. The test format and difficulty depend on the position you are applying for, however most exams will aim to cover basic, intermediate, and advanced Word skills. 

For example, basic Microsoft Word practical questions might as you to perform small alterations to the page layout such as landscape orientation, justify alignment, create Word art, or change the font type. Advanced questions on the other hand could ask you to perform more uncommon and complicated tasks, such as creating a Word document that updates automatically based on the data found in a separate Excel sheet. 

*The Microsoft Word PrepPack supports older versions of the software too - including Microsoft Word 2016. 

Microsoft Word Practice Software

JobTestPrep's Microsoft Word PrepPack gives you access to the Gmetrix platform, which is specialized software that allows you to answer your tests directly in a MS Word document - giving you an authentic practice experience. While using this software, you will be able to toggle between two modes:

• Practice Mode - here you can practice with no time limit, and with the option of revealing the answer.
• Testing Mode - here you can experience the real pressure of a timed test, and if you don't know the answer, the software won't tell you. 

Through accurate and diverse Microsoft Word practice questions and in-depth answers and score reports which all combine in the specialized Gmetrix Word software, you will finish your preparation with more Microsoft Word skills and knowledge than ever before. 

Let's answer a few MS Word practical questions to understand exactly what you can expect on the actual test. The answers to the questions appear on this PDF - however to get a good understanding of your current level, we recommend trying to answer the questions one time on your own first. 

To answer the Microsoft Word practical questions on this page, you must first copy and paste the text in the box below to a clean Word document (left click, hold and drag to mark the text, right click – choose "copy", at the Word document, right click – choose paste).

Once you've done this, implement the instructions in the questions below in the new Word document.

MS Word Practice Questions - Basic

1. Change the page margins to narrow

2. Sort the students’ names alphabetically in ascending order

3. Add numbering to the “Students” and “Teachers” lists separately

4. Change the layout of the students list into two columns

5. Create an annual style header

MS Word Practice Questions - Advanced

1. Add a Developer tab to the Ribbon

2. Record a macro that will apply a yellow highlighting. Name the macro: “Approved” and assign it the shortcut ALT+k

3. Insert a bookmark next to the “Attendance list” title. Name it “Title”.

4. Add the word “Back” below the list and make it a Hyperlink to the “Attendance list” title

5. Change the document settings to show readability statistics

Done answering the questions? Click here to see how you did on our Microsoft Word practical test questions and answers PDF, and keep scrolling for more questions. 

MS Word exams measure much more than just the basic skills that the average user has, and will challenge you with tasks that may have never encountered before. 

JobTestPrep's accurate PrepPack gives you access to hundreds of MS Word practical questions with full answers, a specialized practice platform and smart score reports - making sure your Microsoft Word skills reach at their maximum.

 MS Word Practical Questions - Multiple Choice

1. Which of the following methods can't you use to zoom in?

Performing the actions specified in options (A), (B) and (D) will allow Zooming in on the document. The shortcut Ctrl+Shift+z, as specified in option (C), does not.

2. I want to create a second copy of an opened document under a different name. What should I do?

Copying and pasting the text (option A) is a very inefficient way of completing the task. Ctrl+s (choice C) will save the document in its original name. Reopening the file (Choice D) will open it in Read-Only mode. Choice B is the only correct answer.

3. The following ribbon is the:

(C) Is the correct answer. In the Review tab you will find features related to auditing and checking the document such as: Spelling & Grammar check, tracking changes, inserting comments etc.

4. What does a wavy blue underline under a word mean? 

A blue wavy underline signifies a grammar issue such as using the wrong pronoun or failure to capitalize when it is required. Word cannot tell when a word is out of context and underlines in red “wavy” line misspelled words or a words appearing twice in succession.

5. The Thesaurus feature:

The thesaurus is a very useful tool to freshen up the vocabulary you use!

Prepare For Your Microsoft Word Exam

From straightforward tasks such as adding a page number, changing the font color or adding smart art to more complicated ones like building interactive organization charts - there is a lot to know about Microsoft Word. In a Microsoft Word assessment, you can be sure that the questions will touch subjects that you don't usually handle in your regular daily life. 

To be sure you arrive at the actual test with your Microsoft Word skills on point, preparation is key.  

With the Microsoft Word PrepPack you will gain access to specialized software on which you can practice with hundreds of Microsoft Word test questions and answers. The software allows you to practice in different modes and different levels. With each Microsoft Word practice test you answer, your abilities will grow giving you an edge over the other candidates. 

As a bonus, you will also have access to Microsoft Office software prep, including Excel , PowerPoint & Outlook practice tests. 

Academia.edu no longer supports Internet Explorer.

To browse Academia.edu and the wider internet faster and more securely, please take a few seconds to  upgrade your browser .

Enter the email address you signed up with and we'll email you a reset link.

• We're Hiring!
• Help Center

MICROSOFT OFFICE PRACTICE QUESTIONS

2019, MICROSOFT OFFICE PRACTICE QUESTIONS

MICROSOFT OFFICE PRACTICAL QUESTIONS

Related Papers

Kumu Rockey

British journal of educational …

Andrew Deacon

Powerful applications such as Microsoft Office's Excel and Word are widely used to perform common tasks in the workplace and in education. Scripting within these applications allows unanticipated user requirements to be addressed. We show that such extensibility, intended to support office automation-type applications, is well suited to the creation of learning activities and learning environments. We have developed a range of tutorial activities using Excel and Word in introductory mathematics, writing and economics courses. These tutorials have the dual purpose of teaching academic concepts and practical computer literacy skills. The software architecture of our learning environment includes a database-supported back-end to automatically record students’ responses, which allows for greater control over what students do. Additionally, this allows one to automate common procedures to improve usability and feedback automation to support learning. We have been applying our ideas for the last six years and currently 1,500 students are using the environment. We suggest that this pragmatic solution can provide a high degree of interactivity and flexibility in a range of learning contexts that represents a cost-effective alternative for use alongside traditional approaches.

101 BD Tech

S.M. Nurnobi

Microsoft Office Application Programme Details : 1. Basic Computer Fundamentals​​​​ 2. Microsoft Word 3. Microsoft Excel 4. Microsoft Access 5. Microsoft PowerPoint 6. Internet & E-mail Operating System

Mahendra Kumar

 While highly recommended as preparation for the Word and Excel Assignment, this practice exercise is optional and will not be graded.  Solutions to this assignment have been posted.  Please note that this exercise is not exhaustive and does not cover all tasks required on the Word and Excel Assignment. Purpose The purpose of this practice exercise is to help prepare you to complete the Word and Excel Assignment. This exercise requires you to use the following:  Microsoft Excel for creating tables, scatter plots, and completing data analysis.  Microsoft Word for creating a summary document containing the results and discussion from two Excel exercise. Specifically, Word will be used to import tables/plots; create text, equations, captions, and drawings; and to use built-in tools for heading styles, automatic referencing and citations, and tables of contents. Relevant Resources The Microsoft Excel tutorials and Microsoft Office Learning Resources are available at http://engineering.queensu.ca/Current-Students/First-Year-Studies/Incoming-Students.html You should read this tutorial and refer to these resources while completing the exercise. If you have any additional questions about the exercise, you may contact [email protected] for assistance. Required Software This practice exercise can be completed on both PCs and Macs. You will need the following software and plug-ins: 1. Microsoft Excel-Ensure the "Analysis ToolPak" plug-in is installed in your version. 2. Microsoft Word-Ensure you have the option to use the IEEE reference style in the Word citation management tool. Detailed installation instructions are included in the Microsoft Excel and Word tutorials mentioned previously in 'Relevant Resources.'

AFRICAN INTERNATIONAL JOURNAL OF EDUCATION LEARNING (EGYPT 2022)

Nojeem Ishola

The study examined Microsoft access and excels skills needed by office technology and management students for quality service delivery. Descriptive survey design was adopted. The. population of this study comprised all the secretariat administration students of Tai Solarin University of Education (TASUED), Ijagun, Ogun State. A total of 250 secretariat administration students of Tai Solarin University of Education (TASUED), Ijagun, Ogun State were selected through the use of simple random sampling technique as sample size. Researcher-developed instrument; tagged Microsoft Access, Excels Skills and Quality Service Delivery Questionnaire (MAESSQDQ) with 0.78 as reliability coefficient was used for data collection. Mean and standard deviation was used for answering research questions. All the hypotheses were tested using t-test at 1.05 level of significance. The findings revealed that competency in adding and deleting records from database, skill in linking information from different environment, sharing information among different workstations, use tags for various types of objects, planning a data base before creating it, designing of tables, designing of fields, ability to relate or join tables to one another, knowing how to define a field, knowing the types of field names and their tags such as binary, cur for currency, knowledge of various data types such as text, memo among others were among the Microsoft access skills needed by office technology and management students for quality service delivery. It was also revealed that ability to start micro soft excel, planning of numerical table titles, use of columns and rows, ability to plan spreadsheet, move from cell to cell in ms-excel; change a spreadsheet look, entering, edit and manipulation of data, produce a basic spreadsheet with formulae, creation of arithmetic formulae, using common functions, use of common numerical formatting and alignment, linking of line data from one spreadsheet to another, use spreadsheet to solve problems and project results, manage and print spreadsheet documents, apply typing techniques when typing symbols and design and modify appearance of chart and graphics were among the Microsoft excel skills needed by office technology ' and management students for quality service delivery. There is significant difference in the mean ratings of' respondents based on the micro soft access skills needed by office technology and management students for quality service delivery. There is significant difference in the mean ratings of respondents based on the micro soft excel skills needed by office technology and management students for quality service delivery. The study recommended improvement in student training and acquisition of necessary facilities and equipment needed for computer aided instruction in OTM department. Government should make a stringent policy regarding the use of ICTs in instructional delivery and that tertiary institutions should package professional development programs for lecturers to upgrade their ICT competencies. Keywords: Microsoft Access, Excels Skills, Office Technology and Management, Students, Quality Service Delivery

Meljun Cortes

A component of the Microsoft office system that handles and primarily conceded with wordprocessing, and the creation of documents. I. COMPONENTS OF AN MS WORD SCREEN I..1 Title Bar displays the program name and the name of the document being written or edited. Carrying the usual Minimize, Maximize/Restore and Close application buttons.

INSTRUCTIONAL MANUAL MS Word 2010

McCladdie Curtis

Edetania: estudios y propuestas socio-educativas

Maria de El Puig Andrés Sebastiá

Waseem Shahid

Loading Preview

Sorry, preview is currently unavailable. You can download the paper by clicking the button above.

RELATED PAPERS

hp-//~ w. tc. 1lmn. edu/1ilambrec/teeh nology/ …

Judith Lambrecht

sidharth k pillai

Piyapong Khumrin , Ariyaphong Wongnoppavich

HOLISTICA – Journal of Business and Public Administration

Ali Darejeh

Zenodo (CERN European Organization for Nuclear Research)

Alexander Cochanco

Ariyaphong Wongnoppavich

Siyazini Vhutuzah

mustapha moshood

Monica Elias

Moshé Zloof

Kevin McManus

honey thind

Dr. Rizik Al-Sayyed

Shelley Kinash

International Journal for Research in Applied Science & Engineering Technology (IJRASET)

IJRASET Publication

Domenico Cunico

Waseem Khurshid Butt

Stephen Powell

Richard Fikes

Vijay Tadikamalla

Proceedings of the XVIIth Triennial International Ergonomics Association

Michael S . Wogalter

Desireé McKie

Acm Transactions on Information Systems

RELATED TOPICS

•   We're Hiring!
•   Help Center
• Find new research papers in:
• Health Sciences
• Earth Sciences
• Cognitive Science
• Mathematics
• Computer Science
• Academia ©2024

• Interactivity
• AI Assistant
• Digital Sales
• Online Sharing
• Offline Reading
• Custom Domain
• Branding & Self-hosting
• SEO Friendly
• Create Video & Photo with AI
• PDF/Image/Audio/Video Tools
• Art & Culture
• Food & Beverage
• Home & Garden
• Weddings & Bridal
• Religion & Spirituality
• Animals & Pets
• Celebrity & Entertainment
• Family & Parenting
• Science & Technology
• Health & Wellness
• Real Estate
• Business & Finance
• Cars & Automobiles
• Fashion & Style
• News & Politics
• Hobbies & Leisure
• Recipes & Cookbooks
• Photo Albums
• Invitations
• Presentations
• Newsletters
• Sell Content
• Fashion & Beauty
• Retail & Wholesale
• Presentation
• Help Center Check out our knowledge base with detailed tutorials and FAQs.
• Learning Center Read latest article about digital publishing solutions.
• Webinars Check out the upcoming free live Webinars, and book the sessions you are interested.
• Contact Us Please feel free to leave us a message.

All Categories

lOMoARcPSD|9421338 Ms Word Practical Assignment Pdf Computer Engineering (Dar es Salaam Institute of Technology) StuDocu is not sponsored or endorsed by any college or university Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 MS-WORD Microsoft Word is a word processor developed by Microsoft. It was first released in 1983 under the name Multi-Tool Word for Xenix systems. MS Word is a popular word-processing program used primarily for creating documents such as letters, brochures, learning activities, tests, quizzes and students' homework assignments. There are many simple but useful features available in Microsoft Word to make it easier for study and work. That's why so many people would prefer to convert the read-only PDF to editable Word and edit PDF in Word. PRACTICAL -1  Type the paragraph above as it is using “Calibri font” , font size 12.  Change the font type to “Lucida Calligraphy” and size to 14  Alignment to your paragraph to right margin.  Save this file as ms-word.doc in “my documents” folder using save as option.  Edit some part of your document and save again using save option.  Close the file.  Open this file again using open option from office button.  View the file you have created using print preview option.  Take a print out of this document through print option.  Create a new file using new option.  Select some part of your document of PRACTICAL -1 and copy it to new file created in bullet 1. Use shortcut keys for copy and paste.  Highlight “Microsoft Word is a word processor developed by Microsoft.”  Search for word “document” using find option.  Replace the word “Microsoft” with “MS”. Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 PRACTICAL-2  Select your document by using select all option and change the font size of your document.  Underline the “Microsoft –word” using underline option.  Draw a line through the middle of the selected text using strikethrough option.  Create small number below the text baseline of the word “Multi-Tool” using subscript ( ctrl+=) as shown below Multi-Tool1  Create small number above the text baseline using superscript ( ctrl+shift++) as shown below. Multi-Tool2 Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 PRACTICAL-4 Microsoft office package includes MS word, PowerPoint, Excel, Outlook, OneNote and Access.  View your document in portrait and landscape view using orientation option in page layout menu.  Change the color of the text using font color option.  Create a bulleted list like :  MS word  Powerpoint  Excel  Access PRACTICAL-5  Using the insert > break option insert a page break in your document.  Insert page number at the bottom of the page using page number option.  Insert a table like this: Roll no. Name Course Language 1. Kapil BCA HTML 2. Suresh MCA ASP.NET 3. Shushma B.COM. TALLY 4. Sandy B.COM. C  Draw the borders of the table using draw table option.  Select the last row of the table and delete the entire row.  Insert some more columns to the right in the table. PRACTICAL-6  Insert a picture in the file like this: Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338  Place the picture into the center of the page.  Add a thick red border around the picture.  Crop the picture 0.5 inches from the left.  Change the size of the picture by pressing right click of the mouse on the picture .  Insert caption to the picture. PRACTICAL-7  Insert a clip art of computer in the file using clip art option .  Draw a star using shapes option .  Draw a figure like this using SmartArt option and add some text in the figure. :  Insert date & time and symbol date option &symbol option.  Using WordArt ,write the following “THANK YOU” .Use any style you wish and give it a font size of 20 points. PRACTICAL-8  Insert header &footer using the header and footer option.  Draw a text box and insert the following text in the textbox: “Computer is an electronic device that performs complex calculations easily.” Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338  Insert Excel worksheet using object option in insert menu.  Create a hyperlink & attach a file to the hyperlink.  Insert Bookmark using bookmark option in insert menu. PRACTICAL-9  Choose the paper size for the document using size option.  Split the text in three columns by using columns option.  Type the following lines and give numbers to that lines using line numbers option: Computer is a device. Computer is a machine Computer is an electronic device Computer is very useful. PRACTICAL-10  Make the word “MS-WORD” as the watermark of the document.  Set the background color of the document as RED using page color option.  Change the border of the page using page border option.  Choose the indents tab.  Change the spacing between paragraphs by adding space above the paragraph. PRACTICAL-11  Add a table of contents to the document.  Update the table of contents.  Insert footnote to the document.  Insert an endnote to the document.  Insert an index into the document.  Create labels to the document. PRACTICAL-12  Type this paragraph &checks the spelling &grammer using spelling &grammar tool. Microsoft Word is a word processor developed by Microsoft. It was first released in 1983 under the name Multi-Tool Word for Xenix systems. MS Word is a popular word-processing program used primarily for creating documents such as letters, brochures, learning activities, tests, quizzes and students' homework assignments. There are many simple but useful features available in Microsoft Word to make it easier for study and work. That's why so Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 many people would prefer to convert the read-only PDF to editable Word and edit PDF in Word.  View the document in full screen using full screen reading option.  View the document as draft using draft tool.  View the screen in full mode and zoom mode.  Add a bibliography of the document. MS Excel-Assignment Practical-1  Create a database Club and table Member. The following are the details of the table. Number Fname Lname Address Home phone Joining date S1465T Jone Johnson 1234 Country Club (713)-555-7890 01-02-04 Texas J1050S Bill Smith 1112 Peter Avenue (713)-556-6556 30-11-04 Texas S1300T Lisa Stanley 985 Venton Circle (713)-558-1227 11-11-04 Texas  Do the following: 1) Create Business table by using Design Wizard with year own data (atleast 6 fields and 10 records) 2) Create Personal table by using Design Wizard with your own data (atleast 6 fields and 10 records)  Create a employee database and table ‘emp’. Emp.No Ename Job DOJ Basic Deptno Sex Due prom Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 101 Ajya Clerk 17-12-01 6000 20 Male Male 102 Arvind Salesmen 20-02-02 5000 30 Male Male 103 Rahul Salesmen 22-03-01 5500 20 Male 104 Rehman Manager 01-04-01 12000 40 105 Sahil Manager 20-09-02 11500 10  Create a database ‘Library’ and create a table as ‘Books’ and execute the queries given below: Author Lname Author Fname Book title Book type Year of publication Gupta Sharma Accounting 2002 Management Nain Patel Accounting Accounting 2000 Reddy Ram Accounting 1990 Financial Corporate accounting a) Display Book title, Book type, author name where author = Ram and book type = Accounting. b) Display Author Fname, Book type year of publication where year above 2000 Practical-2  Create a database ‘Student’. Also Create table ‘stdtable’& execute the following. SRoll no Sname Class State DOB Marks Grade A 101 Raj BCA AP 21-09-82 80 B A 105 Ram BCA MP 31-08-81 70 C C 104 Rakesh BCA UP 30-06-80 90 103 Ramesh BCA AP 25-07-82 38 105 Rajesh BCA MP 02-02-83 45 a) Sort the data by SRoll no. b) Display SRoll no., Sname, State and Marks where marks > 80. c) Display SRoll no., Sname, State and Marks where Grade = A. Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338  Create ‘employee database and table ‘emp’ create a Report. Emp.No Ename Job DOJ Basic Deptno Sex Male 101 Ajya Clerk 17-12-01 6000 20 Male Male 102 Arvind Salesmen 20-02-02 5000 30 Male Male 103 Rahul Salesmen 22-03-01 5500 20 104 Rehman Manager 01-04-01 12000 40 105 Sahil Manager 20-09-02 11500 10  Create ‘Student database table ‘and also create a Report . SRoll no Sname Class State DOB Marks Grade 101 Raj 21-09-82 80 A 105 Ram B.Com-I AP 31-08-81 70 B 104 Rakesh 30-06-80 90 A 103 Ramesh B.Com-II MP 25-07-82 38 C 105 Rajesh 02-02-83 45 C B.Com-III UP B.Com-II AP B.Com-I MP Practical-3  Create a employee database and Create a Report . Emp.No Ename Job DOJ Basic Deptno Sex 20 Male 101 Ajya Clerk 17-12-01 6000 30 Male 20 Male 102 Arvind Salesmen 20-02-02 5000 40 Male 10 Male 103 Rahul Salesmen 22-03-01 5500 104 Rehman Manager 01-04-01 12000 105 Sahil Manager 20-09-02 11500  Apply Auto formatting for the following Table and find total by using Auto Sum option Downloaded by raj SINGH ( [email protected] )

ROLLNO NAME lOMoARcPSD|9421338 IOM 101 Radhika 80 102 Sarika QT FIT 60 103 Geethika 50 90 75 104 Bhoomika 60 80 80 105 Karthika 50 70 84 80 60 84 57  The following are the marks obtained by the students in three subjects ROLLNO NAME QT FIT IOM 101 Pravalika 50 90 80 102 Aryaman 40 80 60 103 Akosh 38 70 75 104 Prajaktha 80 60 80 105 Trisha 84 57 84 Using Conditional Formatting list out students who secured ( a) Less than 50 in QT, ( b ) More than 65 in FIT, ( c ) Between 60 and 80 in Accounts . Practical-4  The following are the marks obtained by the students in three subjects Draw a Bar Diagram. ROLLNO NAME QT FIT IOM 101 Pravalika 50 90 80 102 Aryaman 40 80 60 103 Akosh 38 70 75 104 Prajaktha 80 60 80 105 Trisha 84 57 84 Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338  Type the following table and find out the total marks average obtained by each student. ROLLNO NAME ECONOMICS BANKING MARKETING 1 Ajay 50 90 80 2 Vijay 40 80 60 3 Arnay 38 70 75 4 Prathista 80 60 80 5 Bhoomi 84 57 84  From the table given below reduce the total expenditure to RS.16000 by reducing sales department’s Expenditure by applying Goal Seek . Department Expenditure Rs. Production 4000 Sales 6000 Marketing 3000 Finance` 5000 Total Expenditure 18000  Principal Amount 2,00,000 Rate of Interest 5% Time Period 10 Years Amount to be Paid ? From the above , Calculate the amount payable per annum and also show the effect on amount by changing : a) Rate of Interest to 3% and 8% b) Time Period to 5 Years and 3 Years. Practical-5  Employee Name Department Salary Rs. Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 A Sales 3000 B Accounts 4000 C Marketing 5000 D Sales 6000 E Accounts 4000 F Marketing 8000 Obtain Department wise Sub Totals .  Employee Name Department Salary Rs. A Sales 3000 B Accounts 4000 C Marketing 5000 D Sales 6000 E Accounts 4000 F Marketing 8000 Prepare Pivot Table .  Create the following table: Pay ROLLNO Name Salary Rs . Part Time Rs. Accounts 1011 Prasanna 12000 900 1800 1012 Anitha 14000 800 1600 1013 Ravi 18000 700 1700 1014 Saritha 15000 600 1600 Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 1015 Mallika 17000 500 1800 Using Conditional Formatting list out employees who got (a ) Less than Rs. 15000 as Salary ( b ) More than Rs. 700 as Part Time ( c ) Between Rs.1600 and Rs.1800 as Arrears . Practical-6  The following are the marks obtained by the students in three different subjects Draw a Pie Diagram. ROLLNO NAME QT FIT IOM 101 Radhika 50 90 80 102 Sarika 60 80 60 103 Geethika 50 70 75 104 Bhoomika 80 60 80 105 Karthika 84 57 84  Create a pie graph for the following data of sales of XYZ co. YEAR 1998 1999 2000 2001 2002 SALES 5000 10000 25000 3000 20000  Show a Pie graph for the following data with different colors for each category Total Population Distribution (in crores) 0–5 20 Downloaded by raj SINGH ( [email protected] )

6 – 12 lOMoARcPSD|9421338 13 – 20 21 – 35 10 36 – 60 15 60 & above 25 Total 15 15 100  Draw a multiple bar diagram from the following data: YEAR SALES GROSS PROFIT NET PROFIT (‘000 Rs.) (‘000 Rs.) (‘000 Rs.) 2005 120 2006 135 40 20 2007 140 45 30 2008 150 55 35 60 40 Practical-7  Create a file in Excel that describes a grading system for a class. 1) One Excel workbook file with 3 separate, appropriately labeled worksheets. 2) Tables, a graph, and a list of descriptive statistics. 3) For this exercise, the correct values in each cell are important and will be graded. 4) The graph will be graded on appropriate content, appropriate axis scaling, and clear labeling. Content You should form a table on a worksheet titled “class list” that includes the names and test scores of your students. You have 7 students in your class, their names are: Allen, Borlin, Catlin, Dorsey, Eugene, Finneran, and Greco. Their scores on the first 3 tests are as follows: Test 1 Test 2 Test 3 Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 Allen Test 89 Test 78 Test 89 Borlin Test 67 Test 56 Test 66 Catlin Test 78 Test 76 Test 76 Dorsey Test 56 Test 34 Test 45 Eugene Test 26 Test 100 Test 99 Finerran Test 99 Test 98 Test 97 Greco Test 78 Test 87 Test 88 I. Using an Excel function, show each student’s average in an additional column labeled “Average” II. Using an Excel function, show each student’s rounded average in an additional column labeled “Rounded Average” III. If a student’s rounded average is above “95”, he/she has received “honors” in the class. In an additional column titled “Honors”, insert a function that will return the word “Yes” if they have received honors, otherwise would return the word “No” IV. If a student’s rounded average is 90 or greater, they receive an “A”. Between 80 and 90 is a “B”, between 70 and 80 is a “C”, between 60 and 70 is a “D”, and lower than 60 is an “F”. Somewhere on your sheet, enter this information in cells. Create an additional column titled “Grade” and insert a nested IF function that returns the appropriate grade for each student. Use an absolute cell references in your nested IF function to indicate cut-off points between grades. Hint: You will need to place the “cut-off grade” values in cells somewhere on your worksheet… V. Below your table, create a graph showing the students’ rounded averages. Be sure to include appropriate labeling and spacing, so that the graph is non-repetitive and the scale is appropriate. Hint: A score of 100 is the highest possible… VI. Insert a new worksheet. Use the Goal Seek feature to find the value that Eugene needed on Test 1 in order to earn honors for the course. Show your work by displaying an updated table. Title the worksheet “Eugene’s dream.” Hint: Do not worry about rounding Eugene’s new “score” for Test 1. If done properly, the rest of your table should update accordingly. Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 VII. From the data on your “class list” worksheet, provide the Descriptive Statistics of your students’ rounded averages. For the output, create a new worksheet and choose to display “summary statistics”. Rename this worksheet “Descriptive Statistics”. Practical-8 Type the following data in excel worksheet and save it as first.xls Type the following data in excel worksheet and save it as first.xls A BC D E 513 501 504 513 511 516 532 504 432 501 510 517 479 494 498 Do the following (a) Highlight column A and copy it to column C (b) Sort the data in column C in ascending order (c) What is the lowest number in the list (use a function) (d) Copy the data in column A to column E and sort it in descending order (e) What is the highest number in the list (use a function) (f) How many numbers in this list are bigger than 500 (use a database function) (g) How many numbers in column A are between 520 and 540 inclusive (use a database function) Practical-9 Type the following data in excel worksheet and save it as second.xls. A BC D People per physician Life Expectancy Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 XY X*Y 370 70.5 6166 53.5 684 65 449 76.5 643 70 1551 71 616 60.5 403 51.5 Do the following (a) Complete column C for finding product x * y (b) Find sum of x column at the end of data (c) Find sum of y column at the end of data (d) Find sum of x * y column at the end of data (e) Find sum of x^2 (f) Find sum of y^2 Practical-10  Enter the following data and save it in grade .xls Name Marks1 Marks2 Marks3 Total Percentage Grade Amit 80 70 80 Renu 70 60 90 Rajeev 60 50 80 Manish 50 30 90 Sanjeev 40 40 80 Anita 70 70 90 Do the following (a) Compute the total marks and percentage of each student by entering appropriate formula. (b) Compute the grades based on following criteria If percentage >= 90 then grade = A If percentage >= 80 and <90 then grade = B If percentage >= 70 and <80 then grade = C If percentage >= 60 and <70 then grade = D If percentage < 60 then grade = E  Using grade.xls to perform the following formatting operations (a) Draw a border around the worksheet (b) Change the font size of heading to 14 points and underline it and hide column c (c) Increase the width of column A to 15 characters (d) Right Align the values in column B, C, F Practical-11 A university maintains a year wise result for four courses and then generates an average report as given below Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 Sr no. Year Course1 Course2 Course3 Course4 Average 1 2002 356 300 300 400 2 2003 200 400 200 450 3 2004 256 500 400 600 4 2005 400 600 500 550 5 2006 456 450 550 450 6 Total (a) Complete the report to calculate the course wise average in row 6 (b) Provide formula to calculate year wise average in column G (c) Generate a column chart to compare data Practical-12 A person wants to start a business and he has four schemes to invest money according to profit and years. Find out which scheme is the most profitable. Investment Amount Percentage for Profit No of years 20000 10% 6 years 40000 20% 5 years 14000 30% 4 years 12000 15% 5 years 2) A company records the details of total sales (in Rs. ) sector wise and month wise in the following format Jan Feb March April Sector 30 12000 17000 14000 15000 Sector 22 14000 18000 15000 16000 Sector 23 15000 19000 16000 17000 Sector 15 16000 12000 17000 18000 (a) Enter the data in a worksheet and save it as sector.xls (b) Using appropriate formula, calculate total sale for each sector (c) Create a 3-D column chart to show sector wise data for all four months (d) Create a 3-D pie chart to show sales in Jan in all sectors AGGARWAL COLLEGE BALLABGARH MS-POWERPOINT Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 PRACTICAL-1  Make a PowerPoint presentation of at least 5 slides.  Add a new slide in the presentation using new slide option.  Copy & paste the 2nd slide after 5th slide.  Delete the 2nd slide using delete option.  Make the selected text bold using “B” option.  Save this presentation as ms-ppt.ppt in “my documents” folder using save as option. PRACTICAL-2  Edit some part of your document and save again using save option .  Close the presentation.  Open this presentation again using open option from office button.  View the file you have created using print preview option.  Take a print out of this document through print option. PRACTICAL-3  Search for some word using find option.  Replace the word “Microsoft” with “MS”.  Select your document by using select all option and change the font size of your document.  Underline the “Microsoft –word” using underline option.  Select the text and draw a line through the middle of the selected text. PRACTICAL-4  Create the small letters below the text line  Create the small letters above the base line  Change the selected text to uppercase or lowercase.  Select the text and highlight it with BLUE.  Change the color of the selected text. PRACTICAL-5  Insert bullets to the text.  Create a numbered list having 10 items in the list.  Select the text and align the text to the centre of the slide. Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338  Change the spacing between the lines of the text.  Increase the indent level of the paragraph.  Change the background color behind the selected text.. PRACTICAL-6  Draw an e-r diagram using shapes tool.  Fill the shapes used in e-r diagram with appropriate color using shape fill option.  Give the outline with black color to every shape using shape outline option.  Use any shape effect in the diagram. PRACTICAL-7  Insert a table like this: Roll no. Name Course Language 1. Kapil BCA HTML 2. Suresh MCA ASP.NET 3. Shushma B.COM. TALLY 4. Sandy B.COM. C  Draw the borders of the table using draw table option.  Select the last row of the table and delete the entire row.  Insert some more columns to the right in the table.  Put a picture on the slide. PRACTICAL-8  Insert a clip art of computer in the file using clip art option .  Draw a star using shapes option .  Draw a figure using SmartArt option and add some text in the figure.  Insert date & time using date & time option..  Using WordArt ,write the following “THANK YOU” .Use any style you wish and give it a font size of 20 points. PRACTICAL-9  Insert header &footer using the header and footer option.  Draw a text box and insert the following text in the textbox: Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 “Computer is an electronic device that performs complex calculations easily.”  Insert Excel worksheet using object option in insert menu.  Create a hyperlink & attach a file to the hyperlink.  Insert slide number at the bottom of the slide using slide number option. PRACTICAL-10  Set the slide orientation as landscape.  Apply the civic theme to the all slides of the presentation.  Set the background style for the theme.  Animate the slides as wipe using animate option. PRACTICAL-11  Check the spelling of the text using spelling option.  View the presentation in black and white using pure black and white option.  View the presentation in grayscale.  View the screen in full mode and zoom mode. PRACTICAL-12  Insert a column chart to the presentation using chart tool.  Create an organization chart in smart art.  Insert slides from another presentation.  Save the presentation again using save option(ctrl+S).  View the slide show of the presentation using slide show option. AGGARWAL COLLEGE BALLABGARH Class-B.C.A.-2nd sem Programming in C Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 PRACTICAL 1 1.Type the following program in C Editor and execute it. Mention the Error. void main(void) { printf(“ This is my first program in C ”); } 2.Add the following line at the beginning of the above program. Recompile the program. What is the output? #include<stdio.h> 3. Write a program that display a message ‘hello world’ on the output screen. 4. Save the program in your own directory. PRACTICAL 2 1. Write a program which shows the function of each escape sequence character. eg printf(“alert ring bell rings like \\a\\a”); printf(“the tab is inserted like \\t this”); 2. Write down C statements to perform the following operations: z = 4.2(x+y)5/z – 0.52x/(y+z) 3. What will be the out put of the mix mode use of integers and float. a=5/9; b=5.0/9; printf(“%f,%f”,a,b); PRACTICAL 3 1. What will be the output if a=5, printf(“%d”,++a); printf(“%d”,a++); 2. Write some simple statements to check the working of logical and relational operators. Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 3. Point out the Errors, if any, in the following C statements: (a). 3.14 * r * r * h = vol_of_cyl ; (b). volume = 3.14 * r ^ 2 * h ; PRACTICAL 4 1. Write a program to generate a series of first 50 even numbers. 2. Write a program to generate a FIBONACCI series . 0, 1, 1, 2, 3, 5, 8, 13, 21 3. Write a program to generate tables from 2 to 20 with first 10 terms . PRACTICAL 5 1. Write down the output of the following program statements i. for (i=1; i<=10;i++) printf(“%d \

”,i); ii. int a = 10, b = 10; for(inti=1;i<=a;i++) { a++; b--; printf(“a = %d,b=%d\\t”,a,b); } 2. Write a program to find the greastest among three numbers. 3. Write a program to find the average of n natural numbers using for loop. PRACTICAL 6 1. Write a program to enter the numbers till the user wants and at the end it should display the count of positive, negative and zeros entered. 2. Write a program to find the range of a set of numbers. Range is the difference between the smallest and biggest number in the list. PRACTICAL 7 Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 1. Write a program which Prints the following pattern up to 10 lines 0 111 22222 3333333 2. Write a program to produce the following output: ABCDEFGFEDCBA ABCDEF FEDCBA ABCDE EDCBA ABCD DCBA ABC CBA AB BA AA PRACTICAL 8 1. Write a program that inputs an integer – determine if it is even or odd (USING IF ELSE STATEMENT). 2. Write a program to find the given year is a leap year or not. 3. Write a program to find the area of a triangle using area= sqrt(s(s-a)(s-b)(s-c)), where s=(a+b+c)/2 PRACTICAL 9 1. Write a program to make a simple calculator which should be able to do +,-,*,/,% Operations.( using case statement) 3. Write a program which takes 10 integers as input and prints the largest one. PRACTICAL 10 1. Write a program to print the find the sum of the given series, take first 8 terms A=1! +2! +3! +4! +…….. (USING FACT FUNCTION) 2. Write a program to find a. Surface area (A=4pr 2 ) b. volume(v=4/3 p 3 ) of a sphere using functions make a function for finding powers of radius. 3. Write a program using functions to evaluate up to 8 terms Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 sin(x)= x - x 3/3! + x5/5! - x7/7! + x9/9! - ……. PRACTICAL 11 1. Write a program which calculates and returns the area and volume of a sphere using define directive . 2. Write a program that takes input for array int a[5] and array int b[5] and exchanges their values. 3. Write a program that takes 10 integers as input and prints the largest integer and its location in the array. PRACTICAL 12 1. Write a program which takes a string as input and counts total number of vowels in that. 2. Write a program to copy the contents of one array into another in the reverse order. 3. Write a program to sort an integer array in descending order. PRACTICAL 13 1. Write a program that adds up two 3x3 arrays and stores the sum in third array. 2. Write a program which takes names of five countries as input and prints them in alphabetical order. 3. Write a program to maintain the library record for 100 books with book name, author’s name, and edition, year of publishing and price of the book. 4. Determine the output of the following program: void main(void) { int x=3,y=4,z=6; int *p1,*p2,*p3; p1=&x; p2=&y; p3=&z; *p1=*p2+*p3; *p1++; *p2--; Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 *p1=(*p2)*(*p3); *p2=(*p2)*(*p1); x=y+z; printf(“%d”,x); printf(“%d”,y); printf(“%d”,z); printf(“%d”,*p1); printf(“%d”,*p2); printf(“%d”,*p3); } PRACTICAL 14 1. Write a program to find the factorial of a given number using recursion. 2. Write a program for swapping of two numbers using Call by value Call by reference Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 AGGARWAL COLLEGE BALLABGARH Class-B.C.A.-3rd sem Subject-SQL Commands, Data Structures Practical-1 Create a table Table name—Table 1 Column name- Emp_no, Emp_name, Salary, Address No. of rows-10 Practical-2 1.Show al record in table 1 2. Find al employee number,emp_name from Table1 3. Select all employees whose salary >10000 4. Select emp_no. emp_name who are living in Faridabad Practical-3 1. Add new column in table 1 having column name -Designation 2. Fill all records in designation column Practical-4 1. Show al typoe of Designations in Table 1( Distinct) 2. Show all records according to name in ascending and descending order(A-Z) Practical-5 1. Creating a new Table from Table1 2. Inserting data into a new table from table1 Practical-6 Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 1. Delete Record from Table1 whose employee number is 0010 2. Change the address in Table1 from FBD to Faridabad 3. change the table name from Table1 to Employee . 4. Draw new table. Practical-7 1. Use primary, foreign, Unique, Not nul constraint in Employee table Practical-8 1. Use Arithmetic and Logical in Employee table Practical-9 1. Select all employees name whose name start by A in Employee table (Like, , %, _) Practical-10 1. Use all aggregate functions in Employee table 2. Use all Scalar Functions with dual table Practical- 11 to 14 Create a mini Project based on oracle Assignment Data Structure -I Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 Practical 1: Q1) Write a C program that prints below shape of triangle using nested loop ***** **** *** ** * Q2) Write a C program that prints below shape of rectangle using nested loop ********* ********* ********* ********* ********* Q3) Write a C program that prints below shape using nested loop * ** *** **** ***** ***** **** *** ** * Practical 2: Q4) Write a program to implement Linear Array with insertion and Deletion Operations Q5) Write a program to find the smallest number from an Array. Q6) Write a program to find the biggest number from an array. Practical 3: Q7) Write a program to convert Decimal number to its equivalent Binary number. Q8) Write a program to find transpose of an array of order m x n. Q9) Write a program to find the first and second largest number of an array. Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 Practical 4: Q10) Write a program to Arrange Array elements in Ascending order. Q11) Write a program to Marge two linear arrays. Q12) Write a program to reverse array elements Practical 5: Q13) Write a program to read a line of text using getchar function. Q14) Write a program to read and write multiple lines of characters using arbitrary character to end inputting. Q15) Write a program to reverse a given string. Practical 6: Q16) Write a program to conut the number of characters, words and lines in a text. Q17) Write a program to check weather a given string is a palindrome or not. Q18) Write a program to convert a string to uppercase. Practical 7: Q19) Write a program to implement 2D Array. Q20) Write a program to Add Two 2D Arrays. Q21) Write a program to find Multiplication of two 2D Arrays. Practical 8: Q22) Write a program to implement stack using array. Use functions to write Push and Pop operations of stack. Q23) Write a program to calculate factorial of a given number. Practical 9: Q24 ) Write a program to convert an infix expression in to prefix expression. Q25) Write a program to convert an infix expression in to postfix expression. Q26) Write a program to convert postfix expression in to infix expression. Practical 10: Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 Q27) Write a program to implement Queue using array . Use functions to write insertion and deletion operations. Q28 ) Write a program to implement Circular Queue. Practical 11: Q29 ) Write a program to implement linear linked list using pointers. Q30 ) Write a program to implement Circular linked list using pointers. Practical 12: Q31 ) Write a program to implement Doubly linked list using pointers. Q32) Write a program to implement Stack Using linear linked list . Q33) Write a program to implement Queue Using linear linked list. Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 AGGARWAL COLLEGE BALLABGARH Class-B.C.A.-4th sem Subject-HTML, C++ PRACTICAL 1 1. Apply formatting tags(bold, italic ,underline) on the below paragraph:- 2. Apply paragraph tags (<p>),break tag(<br>)on below paragraph:- 3. Give title and heading to your documents.(title=First program of H TML, heading= My first program). A history of every thing It start with a bang. Then everything inflates like a super balloon tieds up with super-strings, until the whole mess curdles into millions of milky ways. Starlight hits the volcanic rocks, and cooks up some tasty double-helix treats. They get eaten by each other, the fittest survive, a meteor kills the big ones and when it all freezes over the smart ones move into caves and start a fire Wonders of the World Vacations are not cheap. But who needs them anymore, with so many live cameras connected to the World Wide Web? Pack a picnic, and you can visit spacious pastures in allowed, New Jersey or the more scientifically minded at IBM’s Alma den Research Center. Or if it’s scenery you’re after adventure to ta half payer backyard in Fremont California. Practical 2 1. Apply heading tags(h1,h2,h3,h4,h5.h6) on the following line: %age I love my India I am proud on my India. 2. Change font face, color ,size , alignments on the above paragraph:- 3. Apply <pre> tag on the marks of 5 student in a following format:- Stud roll stud name sub1 sub2 sub3 sub4 sub5 total Practical 3 1. Apply Definitions are indented with respect to the terms. banana a tropical yellow fruit apple one a day keeps the doctor away lemon basis of lemonade 2. Insert an image by using suitable path of the image on your html documents like:- <IMG SRC=\"protocol://server:port/path/filename.ext\" WIDTH=\"#\" HEIGHT=\"#\"> Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 Practical 4 1. Create order and unordered list by using html tags on the below elements:-  Vehicals 1. Two wheelers  Bike  Bicycle  Companies of two wheelers 2. Three wheelere  Auto Companies of three wheelers 3. Four wheelers o Car  Companies of four wheelers You should create more than that list like fruits, electrical equipment’s etc. and add at least five entries in each part of list. 2. Make a documents by using <small>,<big>,<sup>,<sub> , <strike>, <strong> tags on the following paragraph:- Newsuperstrength H2O plus will strike out any stain, big or small. Look for new super strength H2O plus in a stream near you. Practical 5 1. Insert an background image and color on your document by using the following tag:- <body background=”filename or URL”> 2. Apply marquee tag on the following points:- 1. Make a conference alert 2. Make an admission alert (form date ,submission date, last date of submission of the form). 3. Any breaking news flash about your document. 4. Fresh results announcements and give an link page. 5. New roll no. Issue to the students of BCA class . Also give an alignment like up, down, left or right. Practical 6 1. Create link from one page from another by the following code on the all above marquee alerts:- <a href=”filename.html”>admission alert symbol</a> Practical 7 1.create a table according to BASIC TABLE This table: Row 1, Col.1 Col. 2 Col. 3 Col. 4 Row 2 aaa bbb Ccc Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 Row 3 ddd eee Fff Is produced by this code: <TABLE BORDER=\"1\" CELLPADDING=\"4\" CELLSPACING=\"0\" BGCOLOR=\"#FFFF66\"> <TR><TH>Row 1, Col.1</TH><TH>Col. 2</TH><TH>Col. 3</TH><TH>Col. 4</TH></TR> <TR><TD>Row 2</TD><TD>aaa</TD><TD>bbb</TD><TD>ccc</TD></TR> <TR><TD>Row 3</TD><TD>ddd</TD><TD>eee</TD><TD>fff</TD></TR> </TABLE> where: <TABLE> starts the table </TABLE> ends the table <TR> starts a row </TR> ends a row <TH> makes a column header </TH> ends a column header <TD> starts a column </TD> ends a column By default:  a column header, <TH>, is displayed in bold and centered  a regular cell entry, <TD>, is left aligned and in plain text, and  the contents of cells in a row will be aligned vertically to the middle of the row from top to bottom. Create atleast 10 rows and 10 columns in a table and make two tables as results of the students and a table of employees (at least 10 records in each table). Note:- use alignment in tables like center, left or right. Practical 8 Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 1. Make frames on your document as per the above image. Practical 9 1. Make admission form for college, job description form . Practical 10 1. Make website on one of the following or as per your choice topics: 1. Solar system 2. Hospital management system 3. Library management system 4. Hotel management 5. Flight reservation system 6. Bank 7. Departmental store 8. Railway reservation 9. Incredible india 10. Customer care system on any of “ e based system. Practical 11-12 1. Preparing of web site and revision of various tags. Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 C++ PRACTICAL -1 1. WAP to calculate the compound interest for the entered value of principal, period and rate. 2. WAP to print the following output 1 22 333 4444 55555 3. WAP to calculate the root of a quadratic equation. 2x2 + 4x +15 PRACTICAL -2 1. WAP to represent a Prime no. series 1 2 3 5 7 11 13 ……… 2. WAP to display Fibonacci series upto entered n numbers. 3. WAP to find the largest among entered n numbers. 12,34,55,0,11,77,100,2,4,5 PRACTICAL -3 1. WAP to calculate the multiplication of two matrices. 2 56 478 4 73 * 26 0 2 52 01 5 2. WAP to calculate the addition of above two matrices. 3. WAP for implementing an inline function . PRACTICAL -4 1. WAP for illustrating scope resolution operator. 2. Write a function power() to raise a number m to a power n. The function takes a double value for m and int value for n and returns the result correctly. Use a default value of 2 for n. write a main that gets the values of m and n from the user. 3. WAP for implementing friend function using two classes. PRACTICAL -5 1. WAP for using object as function arguments(e.g. adding hours and minute in the class time) 2. WAP for returning objects as addition of two Complex numbers. 4+5i and 7+9i Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 3. Define a class to represent a bank account. Include the following members: Data members 1. Name of depositor 2. Account number 3. Type of account 4. Balance amount in the account Member functions 1. To assign the initial values. 2. To deposit an amount. 3. To withdraw an amount after checking the balance. 4. To display name and balance. PRACTICAL -6 1. WAP for implementing a constructor. 2. WAP for implementing all types of constructor. 3. WAP for dynamic initialization of constructor. 4. WAP for implementing destructor. PRACTICAL-7 1. WAP for unary minus operator overloading. 2. WAP for binary operator overloading. 3. WAP for overloading of operator using friend function. PRACTICAL -8 1. WAP for implementing single inheritance. 2. WAP for implementing multilevel inheritance. 3. WAP for implementing multiple inheritance. 4. WAP for implementing hybrid inheritance. PRACTICAL -9 1. WAP for implementing the concept for virtual base class. 2. WAP for deriving constructor in the derived class. 3. WAP for implementing virtual functions. PRACTICAL -10 1. WAP for illustrating the use of THIS pointer. 2. WAP for illustrating pointer to object. Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 3. WAP for array of pointer to object. 4. WAP for pointer to derived object. PRACTICAL -11 1. WAP for implementing compile time polymorphism. 2. WAP for implementing run time polymorphism. 3. WAP for working with multiple files. PRACTICAL -12 1. WAP for working with class template. 2. WAP for working with function template. 3. WAP for function template with multiple parameter. 4. WAP for member function template. PRACTICAL -13 1. WAP for exceptional handling by try catch and throw statement. 2. WAP for implementing multiple catch statement. 3. WAP for implementing rethrowing an Exception. PRACTICAL -14 For revision and Practical file. Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 AGGARWAL COLLEGE BALLABGARH Class-B.C.A.-5th sem Subject- Graphics, Visual Basic COMPUTER GRAPHICS PRACTICAL1: Create a menu driven program to draw Line, circle, Ellipse, rectangle, Square. PRACTICAL2: W.A.P. to draw HUT. PRACTICAL3: W.A.P. to draw STAR. PRACTICAL4: W.A.P. for Natural scene with moving bird. PRACTICAL5: W.A.P. for solar system. PRACTICAL6: W.A.P. to for clock PRACTICAL7: W.A.P. to for concentric circles PRACTICAL8: W.A.P. for Blinking circles PRACTICAL9: W.A.P. for flying kite PRACTICAL10: W.A.P. for generating different line styles on screen PRACTICAL11: Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 W.A.P. for making light house W.A.P. to draw flag PRACTICAL12: W.A.P. for moving ball ASSIGNMENT ON VB PRACTICAL 1  Use the properties window to set – Main framas the form name. – Myprogramsasthecaption. – BackColortoWhite. – BorderStyletoFixedSingle. – WindowStatetoMaximised.  Find the Menu icon and click on it to select it. Enter the following menu headings: Quit Introduction with indented subheadings of Example 1 Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 Click on Quit menu heading and enter the following code. This procedure is used to exit from running the project display and return to the design screens. Private Sub Quit_Click() Unload me End Sub Practical 2  Use the <F5> function key to run the application to verify that the Menu structure is correct and that the Quit procedure is free from error. Set the following form properties: 1. form name as Welcome caption to Example1 2. BackColor to White 3. BorderStyle to Fixed Single 4. WindowState to Maximised  Click on the Example 1 main menu heading and enter the following code: Private Sub Example1_Click() Welcome.Show End Sub  Save your work and run <F5> to ensure that it is free of errors.  Add two labels, an image and a command button to create a welcome screen.  Select label icon from the toolbox. Click towards the centre-top of your form and position and resize your label as required. With the label selected, use the properties window to 1. Change the caption to WELCOME TO VISUAL BASIC 2. Choose a bright back colour 3. Set the font (Arial, underline, alignment centred, size 24 point, forecolour blue) 4. Repeat to add the Enjoy label. 5. Use the image icon on your toolbox to add the image to your form. Use the 6. properties window of the image to select a picture.  Use the file menu to save your work and use <F5> to run the application.  DON’T FORGET TO SAVE (AND BACK UP TO FLOPPY) ALL YOUR WORK. Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 Practical 3  Open anewform and change itsnametoColourChanger. Placethefollowingobjectson this form. 1. A heading label2 (Caption = Colour Changer) 2. 3 horizontal scroll bars (Set the max value property of all three to 255) 3. 3 other labels (2red, 3Green, 4Blue) 4. a command button to quit the form (Caption = Return) 5. another small label5 under the button with its visible property set to false.  Double click each scroll bar and add the following code to its_on Change()event. Use cut and paste to make the task easier. 1. Label1.BackColor = RGB(HScroll1.Value, HScroll2.Value, HScroll3.Value) 2. Label5.BackColor = RGB(HScroll1.Value, HScroll2.Value, HScroll3.Value) 3. Label1.ForeColor = RGB(255 - HScroll1.Value, 255 - HScroll2.Value, 255 - HScroll3.Value) 4. Label5.ForeColor = RGB(255 - HScroll1.Value, 255 - HScroll2.Value, 255 - HScroll3.Value) 5. Label5.Visible = True Label5.Caption = “WOW!” 6. Label2.BackColor = RGB(HScroll1.Value, 0, 0) Label3.BackColor = RGB(0, HScroll2.Value, 0) 7. Label4.BackColor = RGB)0, 0, HScroll3.Value)  Doubleclickthereturnbuttonandaddthefollowingcodetoits_onClick()event Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 Unload Me PRACTICAL 4 function is a segment of code that accepts zero, one or more arguments and returns a single result. Visual Basic includes many built-in functions (intrinsic functions). Some perform basic mathematical tasks. Others manipulate string data such as converting text to upper Case or lower Case letters. An argument is a value you pass to a function so the function has data to work with. Function names have parentheses at the end to hold the function arguments. Even if a function has no arguments, the parenthesis are required. Two intrinsic functions include message boxes and input boxes. Message and input boxes Message and input boxes are intrinsic functions in Visual Basic 6.0 which allow the end user to interact with the program. Follow the instructions Add new form to menu at the end of Practical 1 to create a new form with a menu heading on the main form. Call this “Message and Input Boxes”  Make the Form.Caption = “Message and Input Boxes”  Put a label on the top of the form “Computer Conversation”. Underneath have a command button with the caption “Talk to me!” Name the command button cmdTalk.  Double click the command button to add the following code sequence. Private Sub cmdTalk_Click() Dim strQuestion As String Dim intAnswer As Integer ‘First you must declare your variables’ ‘Then use the input and message box functions’ strQuestion = InputBox(“Type in your name!”, “Ebeneezer”) intAnswer = MsgBox(“Hello there” &strQuestion, vbOKCancel, “Chat”) End Sub  Add a return button, called cmdBack as you did in the ColourChanger, using the code Private Sub cmdBack_Click() Form1.Show End Sub  Run your program using <F5>. Don’t forget to save your work. Here are some handy literals (values that don’t change). You don’t have to learn them as the help prompt supplies a drop down list as you start to type. Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 PRACTICAL 5 Create a calculator that can add, subtract, multiply and divide two numbers given by the user. PRACTICAL 6 Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338  Write a program to convert inches to centimetres OR centimetres to inches (using the conversion 1 inch = 2.54 centimetres).  Use option buttons (from the toolbox) for the user to indicate whether the conversion is inches to centimetres or centimetres to inches.  Use IF statements to determine which formula to use based on which option button is selected. Option buttons are mutually exclusive, i.e. only one can be selected at a time. PRACTICAL 7 Design a project that allows a user to enter the weight in a text box and calculate the postage. Use Case statements in your code. Link this as CaseWeights under the Multiway menu heading in your main form. Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 PRACTICAL 8 Create a program to generate the first 20 Fibonacci numbers. This time use a counter to control the number of iterations. By using For Loop, Do While Loop, While Loop. PRACTICAL 9 Writean event procedure to perform the following in vb:  Reverse a string  Determine whether the given string is palindrome  Change the case of a string to upper or lower. PRACTICAL 10 Create a menu with the following menu optins:  Style(which includes bold, italic and underline)  Colour (which includes blue, green and red)  Change Case (which includes uppercase, lowercase). PRACTICAL 11-12 Write a VB program to create a product table and to perform the following database operation :  Insert the records  Delete the records  Update the records Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 AGGARWAL COLLEGE BALLABGARH Class-B.C.A.-6th sem Subject- Java Programming JAVA ASSIGNMENT Practical-1 1. Write a simple java program to print “Hello” word on the screen. 2. Write a simple command line argument program. 3. W.A.P swapping of two number. Practical-2 4. W.A.P to compute the area of circle. 5. W.A.P to find the perimeter & square. 6. W.A.P to generate this output * ** *** **** ***** Practical-3 7. W.A.P to generate this output 0 12 345 6 789 7. W.A.P to print this output 1 22 33 3 44 4 4 8. W.A.P to calculate the sum of digit of a given number. Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 Practical-4 9. W.A.P to calculate the Fibonacci series using do while. 10. W.A.P to display volume of a Box. 11. W.A. Simple Constructor program. Practical-5 12. W.A.P of parameterized constructor. 13. W.A.P of Method overriding 14. W.A.P of Method overloading. Practical-6 15. W.A.P to show use of Abstract class. 16. W.A.P of single inheritance. 17. W.A.P of multiple inheritance. Practical-7 18. W.A.P of hierarchical inheritance. 19. W.A.P to create a single interface. 20. W.A.P to create your own package. Practical-8 21. W.A.P of Exception Handling. 22. W.A.P to show multiple catch block. 23. W.A.P to show multiple try block. Practical-9 24. W.A.P to show use of exception handling with finally method. 25. W.A.P to show use of a string 26. W.A.P to show use of a string buffer. Practical-10 27. W.A.P to show use of a vector class. 28. W.A.P to show multi threading. 29. W.A.P to show use of simple applet. Practical-11 30. W.A.P to draw a hut using applet with graphics. 31. W.A.P to draw a human face using applet with graphics. 32. W.A.P to draw a light house using applet with graphics. Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 Practical-12 33. W.A.P to read a file. 34. W.A.P to write a file. 35. W.A.P to reverse of already exist file. 36. W.A.P to accept a no. from used and count the no. of digits. 37. W.A.P check no. is Armstrong or not. Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 AGGARWAL COLLEGE BALLABGARH Class-B.C.A.-6th sem DotNet PRACTICAL 1:  Create a console based application to display output on the screen.  Create a console based application to accept input from user.  Create a console based application to accept command line arguments from user. PRACTICAL 2:  Create a console based application to accept student detail(student name, roll no) at command line and display them on screen.  Write a program to generate a window form with a simple message. PRACTICAL 3:  Write a program to generate a series of first 50 even numbers.  Write a program to generate a FIBONACCI series . o 0, 1, 1, 2, 3, 5, 8, 13, 21  Write a program to generate tables from 2 to 20 with first 10 terms .  Write a program to find the greastest among three numbers. PRACTICAL 4:  Write a program to find the average of n natural numbers using for loop.  Write a program that inputs an integer – determine if it is even or odd (USING IF ELSE STATEMENT).  Write a program to find the given year is a leap year or not.  Write a program to find the area of a triangle using Area= sqrt(s(s-a)(s-b)(s-c)), where s=(a+b+c)/2 PRACTICAL 5:  Write a program to create a structure.  Create a structure with constructor.  Write program for matrix multiplication using array. PRACTICAL 6:  Write a program which calculate area of different shapes entered by user using switch case.  Write a programwhich iterates over the elements of the string array using foreach loop.  Execute the following program and recognise the output: Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338 using System; public class WhileLoopSample { public void RunForAwhile() { TimeSpan durationToRun = new TimeSpan(0, 0, 30); DateTime start = DateTime.Now; while (DateTime.Now - start < durationToRun) { Console.WriteLine(\"not finished yet\"); } Console.WriteLine(\"finished\"); } } PRACTICAL 7:  Create a class which have attributes, methods, consturctor and finalizer and create its objects as reference type as well as value type.  Write a program to create a string indexer that returns a string value.  Write a program which have overloaded constructors. PRACTICAL 8:  Write a program for handling exceptions.  Wtrie a program to create nested namespaces.  Write a program which have a static class.  WAP for implementing single inheritance. PRACTICAL 9:  WAP for implementing multilevel inheritance.  WAP for implementing multiple inheritance.  WAP for implementing hybrid inheritance.  WAP for implementing the concept for virtual base class.  WAP for deriving constructor in the derived class.  WAP for implementing virtual functions. PRACTICAL 10:  Write a program for reading a file.  Write a program for writing in a file.  Write a program to append the text in an existing file.  Write a program to copy the data of one file to another. PRACTICAL 11: Downloaded by raj SINGH ( [email protected] )

lOMoARcPSD|9421338  Write a program to create a window based application for making a student registration form.  Write a program to create a text editor. PRACTICAL 12:  Practical and Revision Downloaded by raj SINGH ( [email protected] )