Practicals

Practical’s List

                                                                                                                            

1)      Paint Brush

i)        Drawing any Picture

ii)      Saving in a Folder

2)      Typing Master

i)        Level I

ii)      Level II

iii)    Level III

iv)    Level IV

v)      Checking Typing Speed

3)      MS Word

a)      Design an Advertisement Using

(1)   Change Font/Style

(2)   Change Layout

(3)   Change Line spacing

(4)   Use Bullets and Numbering

(5)   Change Page Color

(6)   Insert

(a)  Picture

(b) Clip Art

(c)  Shapes

(d) Word Art

(7)   Spell Check

(8)   Change Background

(9)   Insert Table

10.  Page break

11.  Page Margins

4)      MS Powerpoint

1.    20 Slides with

a.   Picture

b.  Table

c.   Chart

d.  Clip Art

e.  Slide Animation

f.   Slide Transition

g.  Slide Show

5)      MS Excel

a)      Create and Save the file

b)      Create 5 sheets and Name them by

(a)  Double Click

(b) Rename Option

c)      Sheet 1

i)     Numbers

ii)   1 to 100 (Filling Method)

d)     Sheet 2

i)     Calendar

ii)   For the Month - September

iii) Mark the holidays with Red

e)      Sheet 3

i)     Chart

ii)   Car Sales Data

iii) Choose any Chart Type

f)       Sheet 4

i)        Student List

(1)  Name

(2) ID NO

(3) Department Name

g)      Sheet 5

i)        Mark List

(1)  Name

(2) ID NO

(3) Department Name

(4) 5 Subjects

(5) Total

(6) Average

(7) Rank

6)      Internet

a)    Email

i)     Send a letter to multiple recipients

ii)   Send a letter with attachment

b)   Google Calendar

i)     Put your Schedule

ii)   Check List

c)    Google Drive

i)     Store your files online

ii)   Virus free

d)   Google Blogger

i)     Create a blog

ii)   Five posts

MS Excel

MS EXCEL

Excel is the spreadsheet program created by Microsoft.  Although you can use any spreadsheet program for analyzing data, the instructions given here are specific for Excel and you must use Excel for the three Excel quizzes.  NOTE: Microsoft also makes a less powerful spreadsheet program as part of Microsoft Works or some similar title.  Some of the features that we will use in these exercises are not found in MS Works, so you will not be able to complete all the exercises using MS Works.

Excel is, in its most basic form, a very fancy calculator.  The information given in this quick tutorial is meant to give a working knowledge of how to use Excel.  There are usually several different ways to perform the same function in Excel, this tutorial will usually just give one way.  If you need more information on how to use Excel, there are many web sites dedicated to using Excel, a simple 'google' search will find many of them.  In addition, accessing the HELP menu from within the program can also be useful!
The first figure shows the typical Excel sheet with the important parts of the programs interface labeled.  Please become familiar with these.

The Interface:

Editing and Saving

You are essentially finished with data manipulation for this exercise.  However, the spreadsheet is not clearly labeled.  In order to make the sheet easier to understand, you will now insert some labels.
Highlight cell A1.  Use the right mouse button (the one you normally do not use!).  This will bring up a menu specific for dealing with cells.  An example is shown below.All these menu items deal with cells.  Note, any changes you make will only occur on the highlighted cells.  In this case, the changes will only occur to cell A1.  If you highlight several cells and then right click, the changes will occur to all the highlighted one.  Also, you will find that the right click is a very convenient trick in Excel.  You can right click over almost anything and get a menu specific for that item.  It always pays to try it.  Play with the various menu items to see what they do.
In any case, let us select the INSERT item.  This will bring up a new dialog box, check "entire row" and press OK.  This will insert a new, empty row and shift all other rows down 1 row.  Insert a column to the left of column A using the same technique.  You should now have an empty row 1 and an empty  column A.

Type "Dogs" into cell B1, "Cats" into cell C1 and "Aardvarks" into cell E1.  In A8 and A9, type in "Total".  Finally, in F1, type "Total Animals".  By using labels, you can identify what the values in the spreadsheet represent.

You are now done with the exercise and must now save the file.  From the FILE menu item, select save and complete the dialog box.  Name the file firstinitiallastnamequiz1 (using you first initial and last name - my file would be named emeyertholenquiz1.xls - the xls extension will be added automatically).  Save the file in some place where you will be able to access it so that you can email the file to your instructor if required. Good luck.

Enter a series of numbers, dates, or other items

Do any of the following:
Quickly enter repeated column items into a cellIn the column, type the first few characters for the entry.
If the characters that you type match an existing entry in that column, Excel presents a menu with a list of entries already used in the column.
Press the DOWN ARROW key to select the matching entry, and then press RETURN .
NOTES:
Excel automatically completes only those entries that contain text or a combination of text and numbers. Entries that contain only numbers, dates, or times are not completed.
Entries that are repeated within a row are not included in the list of matching entries.
If you don't want the entries that you type to be matched automatically to other entries, you can turn this option off. On the Excel menu, click Preferences. Under Formulas and Lists, click AutoComplete   , and then clear the Enable AutoComplete for cell values check box.
Quickly enter repeated column items into many cells at onceSelect the cells that contain the data that you want to repeat in adjacent cells.
Drag the fill handle    over the cells that you want to fill.
NOTE: When you select a range of cells that you want to repeat in adjacent cells, you can drag the fill handle down a single column or across a single row, but not down multiple columns and across multiple rows.
Click the Auto Fill Options smart button   , and then do one of the following:

To	Do this
Copy the entire contents of the cell, including the formatting	Click Copy Cells.
Copy only the cell formatting	Click Fill Formatting Only.
Copy the contents of the cell, but not the formatting	Click Fill Without Formatting.

How to Auto Fill Using the Fill Handle

The easiest example of a linear series of numbers is 1,2,3,4,5. In a linear series, the next number in the series is always obtained by adding a constant, or step value to the previous number. Said another way, each subsequent number is incremented by the same value.

A linear series can consist of decimals (1.5, 2.5, 3.5, 4.5), decreasing values (100, 98, 96, 94), or negative numbers (-1,-2,-3,-4). But in each case we ADD (or subtract) the constant or step value.

Let's see how we can autofill a column using the Fill Handle.

1. Open the Excel worksheet. In the first cell enter 1, and enter 2 in the cell immediately below.
2. Highlight the two cells, and hover the cursor over the bottom right corner until you see the Fill Handle (+) - see figure 1.
3. Press the LEFT mouse button and drag down the column as far as you want Excel to auto fill - see figure 2.
4. Release the mouse button and Excel fills the column with the linear series as shown in figure 3.

Alternate Option

If you want a linear series with a step value of 1, you can enter the first number only, click and drag the Fill Handle with the RIGHT mouse button, and click Fill Series on the small menu that displays. The default step value for Fill Series is one.

If you have trouble using the Fill Handle, you may accomplish the same task using the Fill button on the Editing section of the ribbon's Home tab (Excel 2007 and higher). To use the Fill button on the ribbon:

• Enter the two numbers in the worksheet.
• Highlight these numbers and the rest of the column you want auto filled.
• Click the Fill Button, and click Series.
• In the Series window, make sure "Linear Series" is selected with a step value of 1, and click OK.

MS Powerpoint

Basic tasks for creating a PowerPoint presentation

PowerPoint presentations work like slide shows. To convey a message or a story, you break it down into slides. Think of each slide as a blank canvas for the pictures, words, and shapes that will help you build your story.

NOTE: For information about earlier versions of PowerPoint, see Create a basic presentation in PowerPoint.

Choose a theme

When you open PowerPoint, you’ll see some built-in themes and templates. A theme is a slide design that contains matching colors, fonts, and special effects like shadows, reflections, and more.

1. Choose a theme.
2. Click Create, or pick a color variation and then click Create.
   

Read more: Apply color and design to my slides (theme)

Insert a new slide

• On the Home tab, click New Slide, and pick a slide layout.
  

Read more: Add, rearrange, and delete slides.

Save your presentation

1. On the File tab, choose Save.
2. Pick or browse to a folder.
3. In the File name box, type a name for your presentation, and then choose Save. 

NOTE: If you frequently save files to a certain folder, you can ‘pin’ the path so that it is always available (as shown below).

TIP:  Save your work as you go. Hit Ctrl+S often.

Read more: Save your presentation

Add text

Select a text placeholder, and begin typing.

Format your text

1. Select the text.
2. Under Drawing Tools, choose Format.
   
3. Do one of the following:
4. To change the color of your text, choose Text Fill, and then choose a color.
5. To change the outline color of your text, choose Text Outline, and then choose a color.
6. To apply a shadow, reflection, glow, bevel, 3-D rotation, a transform, choose Text Effects, and then choose the effect you want.

Read more:

• Change the fonts
• Change the color of text on a slide
• Add bullets or numbers to text
• Change the color and style of a bulleted or numbered list
• Format text as superscript or subscript

Add pictures

On the Insert tab, do one of the following:

• To insert a picture that is saved on your local drive or an internal server, choose Pictures, browse for the picture, and then choose Insert.
• To insert a picture from the Web, choose Online Pictures, and use the search box to find a picture.
  

• Choose a picture, and then click Insert.

Add speaker notes

Slides are best when you don’t cram in too much information. You can put helpful facts and notes in the speaker notes, and refer to them as you present.

1. To open the notes pane, at the bottom of the window, click Notes  .
2. Click inside the Notes pane below the slide, and begin typing your notes.
   

Read more:

• Add speaker notes to your slides
• Print slides with or without speaker notes

Give your presentation

On the Slide Show tab, do one of the following:

• To start the presentation at the first slide, in the Start Slide Show group, click From Beginning.
  
• If you’re not at the first slide and want to start from where you are, click From Current Slide.
• If you need to present to people who are not where you are, click Present Online to set up a presentation on the web, and then choose one of the following options:
  • Present online using the Office Presentation Service
  • Start an online presentation in PowerPoint using Skype for Business
    TIP:  For information about viewing your notes as you give your presentation without the audience seeing them, see View your speaker notes as you deliver your slide show.

Get out of Slide Show view

To get out of Slide Show view at any time, on the keyboard, press Esc.