ICT August 2013 batch

[Ravichandran]

Dear ICT students of AUG 2013 batch under Dr.Ravichandran, I welcome you all this Web portal, which you will be using for your entire course. This http://as-computing.ning portal is were you will have to upload / post all the classroom based activities.

The CIE ICT task will have to be handed to be in person at the end of each CIE task class and the question paper/ CIE folder should not be take with you under any circumstances. That is, the folder should be given to me after your use in class once you complete your Cie task for that particular class.

For further doubts and queries please contact me or you can even send a message using this Web portal.

FROM NOW ON YOU WILL USE THIS WEB PORTAL. AND REMEMBER TO POST ONLY IN THE FORUM NAMED ICT JAN 2013 BATCH. NOT ON OTHER FORUMS WHICH IS MEANT FOR OTHER BATCHES.

WE WILL DO 5 TASKS OF CIE , WHICH MEANS YOU NEED TO COMPLETE, WORD, EXCEL, POWERPOINT, DATABASE AND HTML TO GET QUALIFIED FOR A DIPLOMA.

Regards,

Dr.Ravi

[Farah Nadia Abd Aziz]

It feels so good to know how this mail merge works!

Excel spreadsheet isn't just used for sorting but may be coming handy for database. The document is linked with the saved database that came from Excel for a start. Then, insert the merge field accordingly before the magic really happens once we click the preview results.

Looking forward to learning new things in the next classes.

[Nabilah Binti Muhammad Najib]

I've never encounter 'mail merge' term before this ( or maybe i have) .

Earlier, I learned how to use it ( with Dr Ravi's help, of course ! ). Using both Microsoft Word and Excel, we can send letters or emails to hundreds of people in , i can say, quite a short time.

First, I type the letter's template in Word and then I type all the recipients and their details in Excel. After saving the data in Excel, I open Word again. I click on Mailings tab and I merge the details from Excel to Word and that's it, DONE :D.

Thanks Dr. Ravi.

[Anis Suraya binti Kamaruddin]

You have an interview letter that needs to be send but the list of interviewers are way too long. The dateline is near and it's impossible to type about 50 letters with the same contents but different name, venues, date and time. There's only one solution. Merge the database in Excel with Word. Impossible?It seems impossible but it isn't once you know the trick. Here's how you do it.

STEP:

1. Press Mailings in Microsoft Word

2. Press Start Mail Merge and click step by step mail merge wizard (a panel will appear at the right-hand side)

3. Press next:Starting documents at the step 1 of 6 (at the bottom of the panel)

4. Click next again and again until step 3

5. A pop-up box will appear. Choose your database

6. In Word, click at the place where you one to place like venue for example

7. Click Insert Merge Field and choose venue.

8. After your done with everything, click preview results and check if there's any error.

9. If you click print, it will print all the 50 letters.

10. And your done

[NUR SHAHERA BINTI YAYAH@YAHYA]

Today we had a very short but important lesson. I've never had any idea about how to use Mail Merge in Microsoft Word. Well, it's actually my first time hearing about it. Thanks to Dr. Ravi. This lesson will definitely benefit me. Now I know how I can write letters to different recipients in a very short time. I can do so by merging database in Excel with a single document in Microsoft Word. 

[Faris Iskandar]

[Salsabila Khuzairi]

[Salsabila Khuzairi]

[Salsabila Khuzairi]

[Salsabila Khuzairi]

[nurul asnida binti aziz]

http://gickr.com/results4/anim_51509d23-2d2a-9514-95b9-2b196f26b9bf...

[Fiona Yeoh Joe Sin]

[Anis Suraya binti Kamaruddin]