Download Pc Packages Lecture Notes By Amit Sharma For Bca 1st Semester and more Study notes Computers and Information technologies in PDF only on Docsity!
B.C.A – 1st^ Semester
LAB ASSIGNMENT
OF
PC PACKAGES
GUIDED BY: SUBMITTED BY:
Prof.Amit Sharma
Vikram University, Ujjain
INDEX
WINDOWS:-
- Creating folder, cut, copy, paste, Managing file and folder
- Arrange icons, set display properties
- Adding and removing S/W and H/W
- Setting date and time, screen saver and appearance
- Using windows accessories
- Settings of all control panel items
- Search file
MS-WORD:-
- Creating a Document
- (^) Find and Replace
- Headers and Footer
- Spell Check
- Insert Picture
- Insert Table
MS-EXCEL :-
- Terms
- Inserting Row and Column
- Border and Shading
- Functions
MS-POWERPOINT :-
- Starting
- Creating a Presentation
- Different Views
- Inserting Slide
WINDOWS
; Internet Connection Wizard : Net Meeting : Network Connections : Network Setup Wizard : New Connection Wizard : Phone Dialer : Remote Desktop Connection
Entertainment : CD Player ; Sound Recorder : Volume Control : Windows Media Player
System Tools : Backup ; Character Map : Disk Cleanup : Disk Defragmenter : File and Settings Transfer Wizard : Scheduled Tasks : System Information : System Restore Address Book Calculator Command Prompt Notepad Paint Program Compatibility Wizard Synchronize Tour Windows XP Windows Explorer WordPad
System Tools: The System Tools category of accessories are used to enhance the working of computer with different tools. This tool not only speeds up the computer but also keeps the system clean of any unwanted elements. There are eight options used in this category.
- Backup: The Backup option allows you to take backup of your files from hard disk to a removable media. When you click on this option, the Backup or Restore Wizard windows appears which is shown.
- Character Map: The Character Map Option helps you to view the various characters of the fonts available in your Windows. After seeing the format of character, you can decide whether to use it or not.
- Disk Cleanup: The windows operating system ceates a mass of temporary files and cached files. These all are designed to speed up the performance of the graphical interface. These files do a pretty good job but often do not get deleted when they should be. This result in a lot of files cluttered up on your hard drive. The Disk Cleanup option helps you to create more space on hard disk. It searches your drive and lists, temporary files, Internet cache files and other unnecessary program files that you can delete safely.
- Disk Defragmenter: While writing files on hard disk, Windows keeps the files at random. This option is used to organize files on hard disk. It helps in fast execution of the programs. It is advised that once you run the Disk Defragmenter, you must run Disk Cleanup after it.
- System Information: This command is mainly used by the people who are supposed to correct your computer. It gives the specific information about your computer when he is troubleshooting your configuration. It quickly finds the data that is needed to resolve your system problem.
- System Restore: The System Restore option restores system to chosen restore point.
MS-Word
Creating & editing Document
MAIL MERGE
The mail merge facility enables you to print a large number of letters/documents with more or less similar text. For example, same invitation letter is to be sent to invitees, only the names and addresses are to be changed.
Saving a Document
- Select FILE MENU a drop down list will appear.
- From this drop down list click on SAVE OPTION a save dialog box will appear.
- Type VIRTUAL and SAVE OPTION. With this our document is save for future which name is virtual.
Find and Replace
Find :-
- First choose the paragraph in the document by clicking.
- Click on EDIT MENU from menu bar a drop down list will appear.
- From this drop down list select FIND option a dialog box will appear.
- In this dialog box FIND WHAT option appear type any word in fonts of it. We are finding the DATA WORD.
- After typing word select FIND NEXT option. By these steps the cursor indicates the DATA WORD which is to se find in the document.
REPLACE :-
- First choose the paragraph in the document by clicking on it.
- Click on EDIT MENU from menu bar a drop down list will appear.
- From this drop down list select REPLACE option a dialog box will appear.
- In this dialog box REPLACE WITH option appear types any word in fonts of it.
- After typing word select FIND NEXT option.
Headers and Footer
Its use for entering page number, file name, author name
and other information about document on the top of the document
called header and at the bottom of document called footer.
Header :-
- Select the document in which we have to open paragraph.
- Select VIEW option from menu bar a drop down list will appear.
- From this drop down list select HEADER a dialog box will appear.
- Select any one option from dialog box examples DASH LINES.
- After inserting choose CLOSE option.
- From this drop down list select the PICTURE option a right side list will appear.
- After these we select the CLIPART option a dialog box will appear.
- Choose any one PICTURE to click it.
Inserting table in a Document
MS-Word has very useful facility that is inserting, table in the document. A table is a collection of rows and columns.
Row and column make a cell contains text numbers and graphics.
STEPS :-
- Select the DOCUMENT in which we insert the table.
- Select the INSERT option from the menu bar a drop down list will appear.
- In this drop down list we choose TABLE option so a dialog box will appear.
- In this dialog box we type number of row and column.
- Then click OK option.
- In this way the table is inserted in the document.
MS-EXCEL
Starting MS-Excel
- If MS-Excel option present in desktop double click it using mouse.
- Click on START MENU present on task bar, a drop up list will appears
- From this drop up list select option PROGRAM a right side list will appears.
- From right side list we choose MS-Excel by this our MS- Excel will be open.
Terms of MS-Excel
Spreadsheet: - It is a group of worksheet which contains rows and columns. It is software which is used to create list, time table, graphs etc.
Worksheet: - It is the group of cell and cell addressed, each page in workbook is called worksheet.
Cell : - Each worksheet consists of rows and columns. The intersection of row and column is called cell.
Workbook: - It is a multiple page excel document. Every worksheet had three sheets we can add or remove sheet as per our need.
Inserting rows and columns
We can insert row and columns at any place of the worksheet
in the following ways:-
Rows:-
- Select the ROW before or after which a new row is to be inserted.
- Click on INSERT OPTION on menu bar, a drop down list will appears.
- From this drop down list, select ROW OPTION.
In this way a new row is inserted.
Column:-
- The format cell dialog box has different option, Select SHADING OPTION.
- The click OK OPTION, after choosing needed shading.
In this way shading will be inserted in the cell.
Statistical Functions
Excel statistical functions are used on data same of them
function are:-
1. Average ( ): - This functions returns the average of values given
in a cell.
Syntax:- =AVG(, ……...)
2. Maximum( ):- This function returns the maximum value of a
given in a cell. Syntax:- =MAX(, ………)
3. Minimum( ):- This function returns the minimum value of a
given in a cell. Syntax:- =MIN(, ………)
Math’s Functions
MS-Excel provides multiple math’s function to perform a
variety of calculation. Such as sum mod and count etc.
- SUM( ):- The function help to calculate total range of give cell. Syntax:- =SUM(range of cell) =SUM(number1, number2)
- ABS( ):- The function return absolute value ignoring negative sine. Syntax:- =ABS()
- ROUND( ):- This function return nearest integer value of a give number. Syntax:- =ROUND()
- INT( ):- This function return integer value ignoring value after decimal. Syntax:- =INT()
- MOD( ):- This function return the remainder of a given number. Syntax:- =MOD()
- SQRT( ):- This function return square root of a given value. Syntax:- =SQRT()
MS-Power Point
- Select any of the patterns and click OK with help of these a new slide will appear.
Opening a Presentation
To open a given presentation we have to follow following steps.
- Select FILE option from menu bar a drop down list will appear.
- From this drop down list select OPEN option from a dialog box will appear.
- In the dialog box so many file name, we choose the file which we want and these file double click. Then the file we will be open.
Difference View
Ms-Power point provides difference views.
- Normal View: - These view help to display three panes that show the outline, the slide and notes area.
- Slide Sorter View: - These view help to display the slides in the order of appearance in the presentation. It shows each slide in there complete from. In this views we can also add edit the slide show.
- Slide Show View: - These view help to run the presentation one slide at a line in sequins automatically.
- Outline View: - These view help to run work only with slide titles and main text in outline. It help to developed the contains quickly.
- Notes Page View: - With the help of these views both notes and slides can be seen together during the presentation.
Inserting a New Slide
- (^) Select INSERT menu from menu bar a drop down list.
- From this drop down list select the NEW SLIDE option a dialog box will appear. Which have two options.
2.)a Blank presentation 2.)b (^) Auto Wizard
- Choose BLANK PRESENTATION from that.
- Select any layout from the given layouts.
- Click OK.
