Week 8 MS Excel

In the Name of Allah

This week was amazing! I learnt how to use MS Excel. Our lecturer Mr. Azamuddin taught us the main basis of MS Excel.

First, CELL BASICS

•Basic cells and cell content in Excel able use to calculate, analyse  and organize data.

• Cell basics include:

  -  Select cells, insert content and delete cells and    

      cell content. 

Second, MODIFYING COLUMNS, ROWS AND CELL

- Change row height and column width

- Insert and delete rows and columns

Merge cells

Third, CREATING SIMPLE FORMULA

ADD OPERATION

 Forth, SPARK-LINES

Fifth, PIVOT TABLES

Pivot Table reports (or, simply Pivot Tables) make the data in worksheets much more manageable by summarizing the data and allowing user to manipulate it in different ways. 

Sixth, Reviewing and Sharing Workbooks

• This sub topic will discuss on how:

   - to track changes

  - add comments

  - compare two versions of a worksheet.

  - to prepare a final version for sharing, including how

  to check spelling.

seventh, TRACK CHANGES

Eighth, Adding and Deleting Comments

Ninth, Finalizing and Protecting Your Workbook

               

Finally, By the the end of this trimester I would have learnt many many things about computer and Internet, at the same time, I will not stop gaining knowledge, never ever.  I hope I will satisfy my God first, then my community, and myself by learning any thing about any thing. Hopefully, Mr. Azamudine will give me full mark for my blog assignment, also.
Assalamu Alikum.

Week 7 MS Powerpoint

In The Name of Allah

This week I learnt how to use MS power-point which we use to present our ideas by it. We have learnt many things:

First, Applying a theme

Second, Inserting Images

• Working with images will learn on how:

- to insert and work with pictures

- to insert clip art

- screenshots in your slides.  

Third, Screenshots 

•Select the Insert tab.

•Click the Screenshot command in the Images group.

•The Available Windows from your desktop will appear.

•Select the window you would like to capture as a screenshot.

•The screenshot will appear in your slide.

Forth, Transition

Fifth, Word art and shapes

Sixth,Animating Text and Objects

Seventh, Inserting Video

Eighth, Rehearse And Record Slide Shows

Ninth, Hyperlink and Action Button

Finally, MS power point is one of the best programmes that I have ever known. I will carry on and try to learn more and more.

Week 6 MS word

                In the Name of Allah

 This week we got the main principle of Microsoft Word. Our lecturer taught us how to use it and what is the function of it. We have been told many things about Microsoft Word to understand and to use them.

First, How to start a Microsoft Word : 

Second, Document Window,

Ribbon

Short cut menus,

Second, Basic Text Operations:

1-  Insert

2- Delete

3- Select

4- Copy, cut and  paste text

5- Drag and drop text

6- Find and Replace Text

7- Save

8- Printing

Formatting,

Third, Working with graphics:

Forth,Advanced Microsoft Word:




Styles and Templates: -Styles and themes are powerful tools in Word that can help you easily create professional looking documents.

Fifth,Customizing Tableland Creating Charts:

Finally, by the end of this week I should have learnt many things about Microsoft Word and By God willing I will be ready to get more information and knowledge.

Week 5 MS Windows

                 By The Name of AllahThis week was really crucial in my life because I learnt the main idea about the operating system    that I use which is Windows 7.

First, Windows OS History

Second, Windows 7 Aims:

•Decrease Start Up and Shut down times by 20 seconds

•Go to Sleep and Resume faster

•Use up less Memory

•Pop up Search results faster

•Reconnect to your Wireless Network more quickly

•Recognize USB devices faster

Third, Upgrades from Vista/ XP:

•New Task bar and System Tray

•Quick Desktop View button

•Improved Start Up, Sleep and Resume performance

•Improved power management saves memory and battery life

•Libraries to improve file access and organization

•Action Centre for system maintenance, back ups, troubleshooting and more

•User Account customization of notifications

•Improved back up

•New wallpapers and themes

•Improved Gadgets

•New premium games include Chess Titans, Mah jong Titans and Ink ball

•Advanced Calculator functions including saving history

•Improved networking via Home Groups

•Passkey protection with networks

•Device Stage for recognizing USB devices faster

•Windows Mail replaced by Windows Live


Forth, Main elements of Windows 7 :-

•Aero view

• Task bar

•Search

•Libraries

•Gadgets

Fifth, Windows7 File Management




Sixth, Finding Files and Folders




Seventh, Windows Special Folders

1.Application Data : pre-user application-specific files

2.Cookies : Internet Explorer browser cookies

3.Desktop Directory : files stored on the user’s desktop

4. Favourites : user’s favourites

5.Fonts : container folder for installed fonts

6.History : user specific browser history

7.Internet Cache : user-specific temporary Internet files.8.Local Application Data : user specific and computer-specific application settings

         9. My Documents : user’s documents

10. My Music : user’s music

11. My Pictures : user’s pictures

12. My Video : user’s video files

13. Programs : user-specific “all programs” groups and icons

14. Recent : user-specific “My Recent Documents”

15. Send To : user-specific “Send To” menu items

16. Start Menu : user-specific “Start Menu” items

17. System : The Windows system directory

18. Saved Games : user’s saved games

19. Templates : user-specific document templates

Eighth, Disk Cleaner


 Disk Defragmenter



Windows 7 Advanced Disk Defragmentation


Control Panel System Maintenance Tool



Finally, I have learnt many many things about Microsoft Windows 7 Operating System, hopefully, I will learn more and more later by God willing.