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

[Izzatul Iman Binti Hanafi]

Hi! I'm Izzatul Iman from Johor Bahru, Johor. I'm in Batch 15.0.

I look forward to learn new ICT skills that I may have been unaware of and finish the course well.

[Faiz Zakwan Bin Che Abdullah]

hey there . I'm Zakwan from batch 15.0 ! I am expecting to learn some new knowledge pertaining to the microsoft office softwares & further develop my 'ICT' skills ... 

[hani hamizah bt nor hashim]

Hii, I'm Hani Hamizah of 15.0. I'm very grateful to be in this class and hopefully I can brush up my IT skills by the end of this course (especially excell T.T) Hope i can keep up!:D

[Chan Hooi Mui]

Noon people,

Hi, I'm Chan, batch 15.0. Hail from Penang. Am not embarrassed to admit that I know nothing but just a little basic knowledge of computing ( Couldn't even grasp all the terms that Dr. Ravi was saying a few minutes ago =/ ) Hmm.. so what am i looking forward for..?? Haha, I hope that I could learn a lot of new and interesting things from this ICT lessons =) Enjoy while the lesson last people! =D

[JASMINE TAY WAN LING]

Hi.I hope we will grow together in this class. Let's work as the best group!!!

[Nurul Jannah bt Mohd Jailani]

Hello Dr Ravi,

Today we learned about how to make a database of information using Excel and how to merge it with Word. This enables us to make multiple letters (for example, invitation letters) for different sets of people with different sets of information using the same letter format. I think this is very useful information, and I'm glad I've been able to learn it today. 

[LIM GEK TENG]

MAIL MERGE

Step 1

Insert the data you require eg: name, venue, date and time in Microsoft Excel and save it.

Step 2

Go  to Mailings, select Start Mail Merge : Start Step By Step Mail Merge Wizard.

Click on “next” on the bottom of your right hand side until you reach step 3 of 6.

You will see  “Browse”, click it and choose your previous Microsoft Excel database.

Go to “Insert Merge Field” and fill in the details accordingly.

Step 3

Click on the "Preview Results" before the letters are printed.

[Emily Ong Hui Xian]

Step 1

Insert data that you require such as Name, Venue, Date and Time in Microsoft Excel.After that,save your data.

Step 2

Type the letter using Microsoft Word.

Go to mailings and click ' Start Mail Merge' and select ' step by step mail merge wizard.

Step 3

Click on 'next:starting document' on the bottom of your right hand side until you see 'next:select recipients' ,click on it again.Then,u will see the word 'browse' above it.Click on it and select the data you have saved.

Step 4

Insert the merge fail at the correct positon in your letter.

Step 5

Click 'preview results' before you print it.

[Afeeq Shaszwan Bin Zambre]

Greetings friends,

Today we learned how to use the mail merge feature in Microsoft Word. This powerful feature helps us to save time when typing documents.

The steps are written below

1) Finish typing in the details in both the row record (name, venue, address, time) and the column field (individual particulars)

2) Save the document.

3) Run Microsoft Word and type an email, leaving the details for the name, venue, address and time blank.

4) Now to use the mail merge feature in Word. Click on mailings > start mail merge > step by step mail merge wizard > starting document > select recipients > browse (under use an existing list) > select document and click okay > insert merge field (where you ant the information to come out) > preview

5) As an added note, be sure that the time format in the control panel of the computer is set to the UK format, or else your date may come out in the American form. Printing the above single document will also produce the multiple documents which have undergone the mail merge.

[QURRATA AINI MOHAMMAD TINGGAL]

hello there! today, we have learned about how to create multiple emails to send it to a group of people by using Microsoft excel. First,we opened up excel grid and inserted the name,venue,date and time in to the first row. then, we filled in the details needed. Saved it to the desktop. After that, used Microsoft Word to write a letter to send leaving the details empty. Finally, click the 'start mail merge' and filled in the details. Click 'preview results'. Finished!

[Saw Ran Sing]

I am lucky to be taught how to use the Mail Merge this morning. Here's the steps:

1. Open Microsoft Excel. Type in the Records' Names and its field
2. Save the spreadsheet
3. Open Microsoft Word
4. Click the "Mailings"
5. Click "Start Mail Merge"
6. Click "Step by Step Mail Merge Wizard"
7. At the bottom of right hand side corner, click "Next: Starting document", then click "Next: Select recipients"
8. Browse the file created from Microsoft Excel previously
9. At the specific site of the word document, click "Instant Merge Field" to enter the field at the correct place.
10. Ensure that the dates are in UK format
11. Preview results to complete the merge

 

[Kong Wee Lee]

Today, we have learnt how to use mail merge to create form letters in Words.

1. List out the name, venue, date and time using Excel ( the record names)

2. Save it as a docx

3. Open Words, on the Mailings tab, click Start Mail Merge, and then click Step by Step Mail Merge Wizard

4. In the Mail Merge task pane, click Letters

5. Click Next: Starting document

6. Open the document saved as docx to use as the mail merge main by selecting it from Browse

7. Add the field codes where we want the variable information to appear ( name, venue, date, time)

8. Preview the letter to complete the merge