week 8

Session 1

On 8^th week we have learnt about Microsoft PowerPoint basic. Actually I am familiar with the Power Point but I could repeat them. We had activities about making presentations .

 Session 1 included Introduction to Power Point(overview), Basic Ms, Power Point(Slides & views), Applying theme and background, Working with images and clipart, Screenshots and Transitions, Working with WordArt and Shapes, working with videos and bookmarking and finally Summary.

All these were just the basics of Power Point which is start of learning it.

 Our lecturer taught us how to insert images, audios, videos and design them. Usually our lecturer teach us in the beginning of class and gives us the task which is related to topic and gives us certain time to finish it.

Session 2

2^nd session included just recap previous lessons, Smart Art illustrations, Rehearse and Record Slide Shows, Broadcasting a presentation, Hyperlink and Action buttons and Summary as well.

Week 8 – session 2

Presentation Skills: Microsoft Power Advanced

Session 2 included Introduction to Power Point(overview), Basic Ms, Power Point(Slides & views), Applying theme and background, Working with images and clipart, Screenshots and Transitions, Working with WordArt and Shapes, working with videos and bookmarking and finally Summary.

Learn more advanced techniques in PowerPoint such as working with slide masters, creating new design templates or themes, automate your presentations, rehearse the timings, copy or move slides between presentations and working with multiple computers.

week 7

 Microsoft Excel
In this week, I've got plenty of new information about Microsoft Excel and how to use it.
In first session, we have learnt about Microsoft Excel basis

Cell basics. In general, basic cells and cell content in Excel is able to use calculating, analyzing , and organzing data.

 Cell basics include:
  - Insert content, select cells, cell content and delete cells
  - Cut, copy and paste cells as well as drag,drop cells and fill cells using the fill handle.

After becoming aware of this, we did in class activity(approximately 5 minutes), namely we watched the video to learn about cells and cell content in Excel workbooks.
Then,briefly,lecturer expained about the ways of modifying columns, rows and cells. These ways are: change row height and column width, insert and delete rows and columns, wrap text in a cell, merge cells.
In addition, i became familiar about formating in excel. Formating in excel includes following commands: 1)change font and font size;2)use the bold,italic,and underline commands;3)Add a border;4)Change the font color and add fill color;5) Change horizontal and Vertical text alignment.

As a summary i can say that by now, i have been familiar already with these :

 *Cell basics including modifying and formatting Columns, Rows, and Cells
 *Saving and printing a worksheet
 *Working with basic functions
 *Sorting, outlining and filtering data
 *Formatting Tables.

In second session, i have strengthened my knowledge about Microsoft ExcelFirs of all, i've been introduced to Spark lines. As a rule, Sparklines are miniature charts that fit into a single cell.
Why we use sparklines? We use it, because they are ideal for situations where you just want to make the data clearer and more easy-catching. Also, they are ideal for situations where you want to represent the data in greater detail, and they are often better for comparing different data series.

There are 5 phases of using Sparklines:
 -Select the cells that you will need for the first Sparkline
 -Click the Insert tab. In the Sparkline, select Line. A dialog box will appear.
 -Make sure the insertion point is next to Location Range. Click the cell where you want the Sparkline to be.
 -Click OK. The Sparkline will appear in the document. Click and drag the fill handle downward.
 -Sparkline will be created for the remaining rows.

Second of all, i've became aware of using pivot tables in Microsoft Excel. In fact, Pivot tables make the data in worksheets much more manageable by summarizing the data and allowing user to manipulate it in different ways. Likewise, Pivot tables can be beffiting when used with large, complex spreadsheets, but they can be used with smaller spreadsheets as well.
After that, watched tutorial video about using Pivot Tables as well as using filters,slicers, and Pivot Charts.
To tell the truth, by the time of this session i felt headache and i missed the summarizing part of lecture.

In third session, our class was fully covered by activity.
 Instuction to this activity was:
 *You need to do the exercise and mark will be awarded upon completion
 *You also need to complete the task given and email to your lecturer

 Requirements: *Referring to Activity sheet in our module and follow the instruction.
 *Save and Email exercises to your lecturer with the subject "FCC113 Microsoft Excel-'your name'" into one folder.

Time allocated: 55 minutes.That activity was mainly about calculating the percentages,grades,total using different formulas and tools.
As a summary, this session will give an exposure to the me with tools that i can apply to enhance my learning process. Besides that, at the end of this session, i am able to create and develop my own document a using appropriate application software.
To be honest, that activity which has been held in third session was very easy in case of difficulty, because i've already known about using Microsoft Excel tools and formulas. Thus, I finished that activity within only 15 minutes.

week 6

Session 1

 

Word processing skills: MS Word Basic

 

I would have never thought this week to be extremely beneficial in a way of enhancing and making the skills those have been gained in days of yore more durable than ever before. It is because this week we repeated and remembered some skills which we took out of the mind for a while.

This week was about the word processing skills, particularly, MS word basic.

The organization of the lesson was quite satisfactory.

It was as following:

Microsoft Office

Introduction to Microsoft Word

Getting started with Word

Text Basics

Formatting

Working with Graphic

Finally, Summary.

Before moving to the topic teacher explained that Microsoft Office includes various programs

Then the introductory part was explained. According to that, Using Microsoft Word, user easily can change the shape, size color of text, shading, add tables pictures, charts and web addresses in documents.

In Addition, it was said that word is full featured word processing program that allows user to create many types of personal and business documents including flyers, memos, reports and etc.

In order to get started with Word we should go following link:

http://www.gcflearnfree.org/word2010

In sequence, word window was explained, According to that, Microsoft Window consist of variety components. This include the document window, Ribbon, Mini Toolbar, Shortcut menus and Quick Access Toolbar

The Microsoft Word 2010 screen

• When the Microsoft Word 2010 program loads, your screen will look something like this. 

TIP: 

If you have seen previous versions of Microsoft Word, such as Word

2003, you will notice that at first glance the screen looks different from the way Microsoft Word used to look. Don't panic however, you will find that in fact it is not all that different, and is in many ways easier to use than older versions.

• You will find that if you move the mouse pointer over icons at the top of the screen a help popup is displayed explaining the function of each item. As you can see, Microsoft Word is telling you what the function of this particular button is. Try moving the mouse pointer over the Change Case icon and you will see information about this icon, as illustrated below. 

Ribbon Tabs

• When you first start Microsoft Word, you normally see the Home tab displayed, as illustrated. This tab contains icons and other controls that are most commonly used within Microsoft Word, such as making text display as bold or underlined. You can also find more advanced options such as paragraph alignment, numbering and bulleting. Move the mouse pointer over some of the icons and get a feel for what options are contained within this tab. 

• Click on the Insert tab and you will see commands and options relating to inserting items within your Microsoft Word document. Again, move the mouse pointer over the items and see what is available.

 

Quick Access Toolbar:

What is text formatting?

• You can format a document at different levels within Microsoft Word. The most basic level is called text formatting. This relates to formatting characters and words within a document and covers the font type, font size, font color and font attributes such as bold italic or underlining.

Font type

• Open a document called Text formatting.

• By default Microsoft Word 2010 uses a font called Calibri.

• Make sure that the Home tab is displayed. 

• Select the paragraph starting with the text FONT TYPE within your document (by quickly clicking three times within the paragraph) and experiment with applying different font types. To do this, make sure that theHome tab is selected, and then click on the down arrow, to the right of the text within the Font control. 

You will be able to select a different font from the drop down list supplied.

• Experiment with formatting your paragraphs using different fonts.

You can also experiment with applying different font types to individual words or sentences.

Highlighting

• The highlighting feature is great if you are reviewing a document and is used in the same fashion as you would use a pen highlighter on a printed copy. You can change the highlighting color but if you intend to print the document in black and white, do not use a very dark highlighting color, as you may find the highlighted words are blacked out and unreadable. 

• Within the paragraph relating to   highlighting, select some text and then click on the Text Highlight Color icon (located in the Font section of the Home tab). This will apply highlighting to the selected text.

• To change the highlighting color click on the down arrow to the right of this icon. You can click on one of these  colors to change the highlighting color the next time you apply highlighting.

 

• Select another portion of text and try applying a different highlight color. 

Week 6 – Session 2

Word Processing skills: MS Word Advanced

Add or remove titles in a chart

To make a chart easier to understand, you can add titles, such as a chart title and axis titles, to any type of chart. Axis titles are typically available for all axes that can be displayed in a chart, including depth (series) axes in 3-D charts. Some chart types (such as radar charts) have axes, but they cannot display axis titles. Chart types that do not have axes (such as pie and doughnut charts) cannot display axis titles either.

This scatter chart displays a title that is centered above the chart, and an axis title for both the horizontal and vertical axis.

You can also link chart and axis titles to corresponding text in worksheet cells by creating a reference to those cells. Linked titles are automatically updated in the chart when you change the corresponding text on the worksheet. If you no longer want to display the titles, you can remove them from the chart.

What do you want to do?

• Apply a chart layout that contains titles
• Add a chart title manually
• Add axis titles manually
• Link a chart or axis title to a worksheet cell
• Remove a chart or axis title from a chart

Apply a chart layout that contains titles

1. Click anywhere in the chart to which you want to apply a chart layout.

This displays the Chart Tools, adding the Design, Layout, and Format tabs.

2. On the Design tab, in the Chart Layouts group, click a layout that contains titles.

Add a chart title manually

1. Click anywhere in the chart to which you want to add a title.

This displays the Chart Tools, adding the Design, Layout, and Format tabs.

2. On the Layout tab, in the Labels group, click Chart Title.

3. Click Centered Overlay Title or Above Chart.
4. In the Chart Title text box that appears in the chart, type the text that you want.

 Tip   To start a new line, press ENTER. To insert a line break, click to place the cursor where you want to break the line, and then press ENTER.

5. To format the text in the title box, do the following:
1. Click in the title box, and then select the text that you want to format.
2. On the Mini toolbar, click the formatting options that you want.

 Tip   You can also use the formatting buttons on the Ribbon (Home tab, Font group), which is a component of the Microsoft Office Fluent user interface. To format the whole title, you can right-click it, click Format Chart Title, and then select the formatting options that you want.

Creating Mail Merge Documents:

Instructions.Things You'll Need

  1.Close all open Word documents and create a new one.

  2.Go to the Tools menu and select Mail Merge

  3.Select Create and then Form Letters, and then click the Active Window button.

  4. Click the Edit button and select the document you just created.

  5. Go to the Insert menu, choose the third Date and Time (month, date, year) choice and click OK.

  6.  Press Return four times and begin typing the contents of your letter with only the salutation followed by a colon (for example, "Dear:"); do not include the name or address of any of the people to whom you are writing.

  7.  As you write the letter, leave blank any place you want to fill in later with a name or other personal information.

  8. After you've written the letter, position the cursor where you want to insert the first "merge field," or item to be filled in later (probably the name after "Dear:"), and then click Insert Merge Field on the Mail Merge toolbar. Do this with each merge field until you've placed all of them in the correct position in the mail merge form letter.

   9.Save the letter as Merge Main Letter.

  10.  Go to "How to Set Up a Mail Merge Data Source in Microsoft Word" to learn how to set up the names and addresses to be merged into your letter.

Work with Hyperlink:

·         Hyperlinks: navigate from one web page to another

·         Hyperlinks have two basic parts:

a.       The address of the web page, email address, or other location that they are linking to

b.      The display text (or image).

Summary:

 

By the end of this session we have learnt:

·         Modifying Page Layout

·         Checking spelling and grammar Working with Lists, Breaks , Columns, Tables, and Hyperlinks

·         Working with Shapes, Styles

·         Using Mail Merge