Week 7(part 2)

Week 7(part 2)

This class was so important for all us.Because next week, we are going to give our lab text and this test was about Ms excel and Ms word.In this week our lecturer taught us about the some other features of the MS excel which ,I am going to describe below.

Sparklines:

A spark line is a small embedded line graph that illustrates a single trend. Sparklines do not include axes or labels; context comes from the related content.

Types of Sparklines:

There are three main types of spark line such as

• Line Sparklines
• Column Sparklines
• Win/Loss Sparklines

Pivot table:

In data processing, a pivot table is a data summarization tool found in data visualization programs such as spreadsheets or business intelligence software.

Reviewing and sharing Workbooks:

• To track changes
• Add comments
• Compare two version of a worksheet
• To prepare a final version for sharing including how to check spellings

Week 7(part 1)

Week 7(part 1)

It was our first class after the midterm exams.Everyone was so excited to know about their marks in the exams.Before announced the result our lecturer gave us introductory speech about the midterm result and he also encourage us for the the final exams.So that we can get good marks in the final marks.In this week we learnt about the Microsoft excel.Now, I am going to share my understanding with my blog.

Introduction:

Software developed and manufactured by Microsoft Corporation that allows users to organize, format, and calculate data with formulas using a spreadsheet system broken up by rows and columns. Microsoft Excel usually comes bundled with Microsoft Office and is compatible with other applications offered in the suite of products. The first software program similar to Excel was released in 1982 and was called Multiplan

.

Cell basic Include:

In excel we can use cell to organize the data and also for analysis.In which we can copy the text,paste the text,and also drop the cell.

Modifying columns,rows and cell:

According to the size of the text we can modify columns and rows width.We can also merge the cell.

Use of formula on MS Excel:

Microsoft Excel, you can enter numbers and mathematical formulas into cells. Whether you enter a number or a formula, you can reference the cell when you perform mathematical calculations such as addition, subtraction, multiplication, or division. When entering a mathematical formula, precede the formula with an equal sign.

Formatting:

By formatting we can change the style of our document.We can change the font size and also we can change the style of the text to make it more professional.We can also put margins in the document.

Week 6( part 2)

Week 6( part 2)

It was our last class before going to sit in the MID TERM.In the class our lecturer gave us some important notes for the preparation of mid term.My lecturer also taught us little bit about the Advanced skills of ms word.Now, I am going to discuss about these term whatever my lecturer taught us during the week 6.
Advanced Skills of Microsoft Word:

Advanced Microsoft word include the three features such as,

• Creating mail merge Document:
• Working with templates and styles
• Customize tables and charts

Creating mail merge document:

The main purpose of the mail merge document is to produce multiple letters,documents and it also used to send multiple mails at a time.

 

Working with templates and styles:

This feature is use to change the style and template of the document to make it more professional.

Customize tables and charts:

This feature is used to put charts and tables in the document to make it more understandable.

Week 6 (part 1)

Week 6 (part 1)

Alhamdulillah!Now I am going to share my understanding about week 6.I was so depressed in this week because I have mid term exam and also alot of assignments that I have to do during the week.In this week , we learnt about the Word processing skills.I was little bit familiar with this topic, So it become very easy for me to understand during the class.

Microsoft office:

Microsoft office includes a variety of programs such as,

• Microsoft word 
• Microsoft Excel
• Microsoft Access
• Microsoft Outlook
• Microsoft Publisher
• Microsoft One Note
• Microsoft Info Path
• Microsoft SharePoint work space
• Microsoft Communicator
• Microsoft Web apps

Introduction to Microsoft Word:

Microsoft word is one of the most powerful and widely used word processing programs.Whether you want to type a simple letter or produce a complex book,Word can handle the job for you.Microsoft Word is a software to aid in the composition,revision,filing and printing of text.It is not limited to text, however, we cal also edit the graphics,clip-art.

Starting of Microsoft word:

Features of Microsoft Word:

• Ribbons
• Mini toolbar
• Quick access toolbar
• Formatting

Ribbons:

The purpose of the ribbon is to provide quick access to commonly used tasks within each program. Therefore, the ribbon is customized for each application and contains commands specific to the program. Additionally, the top of the ribbon includes several tabs that are used to reveal different groups of commands. For example, the Microsoft Word ribbon includes Home, Insert, Page Layout, References, and other tabs that each display a different set of commands when selected.

Mini toolbar:

A mini toolbar allowing quick access to related objects.

Quick access toolbar:

The Quick Access Toolbar (QAT) is a small, customization toolbar that exposes a set of Commands that are specified by the application or selected by the user.

Formatting:

Format feature automatically formats a document as you type it by applying the associated styles to text.

Week 5 (part 2)

Week 5 (part 2)

Thank GOD finally week 5 has been finished.In this week ,we learnt about the Ms Windows OS and also learnt about how to manage files and folders in windows OS.
Window 7 File management:
There are five main ways of file management in windows 7.

1. Get to know the document library
2. Use libraries for quick access
3. Avoid the home groups password pitfall
4. Save time with jumps list
5. Work efficiently with two instances of windows explorer
6. 
   

Managing files and folders:
There are many ways to manege files and folders.But some of them are very important which,I am going to discuss below.

1. Keep names short
2. Separate ongoing and completed work
3. Store like with like
4. Avoid large folder structure

Types of libraries:
There are four types of libraries.

1. Music
2. Pictures
3. Video
4. Document

Disk cleaner:
Disk cleaner is a free source tool to quickly and easily clean your hard disk from temporary files those in the system,temporary folders,the internet Explorer Cache and Cookies folder and the Recycle bin.

Windows Special folders:

System restore:
System restore is a feature first introduced in windows XP.It allows users to restore their computers to a previous state without losing personal data files.System restore automatically creates restore points,which you can use to revert your system to the way it was at a previous time.

Week 5 (part 1)

Week 5 (part 1)

In this week we learnt about the MS window. At first, I don't know even a sin gal word about it.But now after the end of this week I have something to share about the windows.Thing that I understand about windows is, windows is a piece of software on any computer is the operating system.The operating system gives the framework upon which all other services and applications run.

In this week , we learnt about the

• History of windows OS
• Microsoft windows
• Anatomy of Windows 7

History of windows OS:
Microsoft released a number of windows operating system ranging from windows X,NT,server from 1985 till now.The latest is windows 7 released in 2009.Window 8 also has been released.
Microsoft Window:
A family of operating system for personal computers.Windows dominates the personal computer world,
by some estimates,on 90% of all personal computers.The remaining 10% are mostly Macintosh computers. Like the multitasking ,and support for many peripheral devices.

Anatomy of window 7:

1. Aero view
2. Taskbar
3. Search
4. Libraries
5. Gadgets

Aero view:
Aero is hardware-based graphical user interface in window 7.It is intended to offer more advanced features than are available in the standard interface,including new transparencies and animations.

Taskbar:
The Taskbar is long horizontal bar at the bottom of your screen.Unlike the desktop,which can get obscured by the windows on the top of it, the Taskbar is visible almost all the time.

Search:
In windows 7 search is the quick way to search something.As soon as you start typing in the search bar in the start menu.Then you will find the list of the relevant topic.

Libraries:
An organizational features of the windows 7 file system that provides a top-level view into files and folders.Window 7 comes with 4 libraries such as Document,Music,Pictures and Videos

Gadgets:
Gadgets is a software widget or a small application,that is designed to sit on a user's desktop scree in much the same way that apps reside on smartphones and tablets.

Week 4( part 2)

Week 4( part 2)

Finally week 4 has been ended.In this week ,we learnt about the communications medium for networking and also learnt about the types of networking .
Networking communication medium:

• Communication channel 
• Network media
• Physical media 
• Physical medium 
• Digital communication 
• Wireless Networking

Now I am going to discuss about the types of networking.There are three main types of networking.
Types of networking :

LAN (Local area network)
WAN(Wide area network)
MAN(Metropolitan area network)
LAN(Local area network):
Local area network is the group of two or more computers, physically close together usually in the same building that are linked to gather to each other.LANs can contain devices other than computers, For example, Printers,Print servers,Storage devices,etc

WAN(Wide area network):
 A network that spans a relatively large geographical area. Typically a WAN consist of two or more local area network.Computers connected to a wide area network are often connected through public networks, such as the telephone system.

MAN(Metropolitan area network):
A metropolitan area network is a computer network that usually spans a city or large campus.A MAN usually interconnected a number of local area networks (LAN) using a high-capacity backbone technology,such as fiber-optic links, and provides up link services to wide area network and the internet.

At first , I was so confused between three main types of Networking but now I have alot of knowledge and understanding about them.