Making your job easier with Microsoft Excel

I’m sure most of you know how we teachers-to-be will eventually come to that stage in life where most of our work concentrates on grading, marking, adding the total scores of our students, finding the average scores of the class, the average scores of the school and to see the statistics of he grades, whether it is falling or rising. But of course these things are not the highlights of our future careers right. Yes, some might go to the troubles of listing them scores down, then calculate it manually using a calculator or using the computer to do it for you one by one but with the use of Microsoft Excel you can save much time and carry on with your other work. Because using this method save you time and gets your job done faster.

Say you want to calculate the average scores of your students in your class (figure 1)

To find the average scores they get for each subject all you have to do is:

on the subjects columns, on the row that reads average type in =AVG( (highlight the row that you want to find the average) ) then press enter . figure below shows the example.

after pressing enter, the average of the numbers will then appear. To find average, you can also use another method and not entering what was instructed earlier, by doing the following.

1-press the function button as shown

2-you will find this box to appear, just select average and press ok

3- make sure you click on the columns of the subjects you want to find the average before clicking the f button.

with these functions, not only you can use to find the average of numbers but you can also use to find the sum, statistics and etc. All you have to do is choose the term you want to look for just after clicking the f button

I hope this brief explanation has help you understand how you can use more with excels and not just mere tables and rows in when using Microsoft excels.

Why should I reformat the computer?

Sometimes, the computer frustrates you so much that despite most of the time and effort you have to invested to fixing the damaged software or removing a virus to no avail. You have tried all sorts of ways to revive your system but it still runs so slowly, unless we have expertise knowledge on certain areas of troubleshooting. Therefore, when this happens, reformatting the computer usually helps – a clean reformat eradicates all problems and brings your computer back to a ‘healthy’ state!

Understanding the Reformatting Process and Its Causes

A full formatting means clearing everything in your hard disk, checks and mark bad sectors and installs a fresh new working operating system. Therefore, reformatting means get to start over, getting rid of old data, leftover files, and unused programs that were cluttering your hard disk. But, before reformatting process starts, backup any important files, especially those that reside in MY DOCUMENTS folder. This is because once you format your computer, you might have a hard time saving those files which you might have missed out on backing-up even with data recovery.

What Should You Do Before You Start

Before you start, the following is a must-have, that is,

• Windows operating system installation disc with CD-KEY
• Device Drivers
• Antivirus software (that you prefer)

If you do not have the following items, you will encounter a hard time in fixing certain issues once the new system awaits you.

Click on the link below for the steps on how to reformat your computer.
Reformatting your computer

Written by: Registration number 05B1460

Speed Up Your PC

There are several ways to make your PC faster. For desktop computers, you could upgrade the RAM and VGA card (graphics card). Major upgrades involve changing the processor and motherboard. Nonetheless upgrading requires investment. Let’s say you want to make your computer run faster without investing new hardware. I can show you the trick. This works for desktop and laptop computers. These tips are recommended for Windows XP users. Nonetheless I have tried this on Vista, and it works too. It involves three steps, mainly:
1. Modifying ‘Msconfig’
2. Setting Advanced System Properties
3. Performing ‘Regedit’