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

[Faizah Abdullah]

[Helena Aishah binti Nordin]

Today we learnt about Mail Merge. Before this, I had no idea what it was. Thanks to Dr. Ravi, I now know what it is and how to use it. Basically, you can draft your letters to different recipients within a very short time. In other words, it somewhat is like a shortcut. Mail Merge will definitely benefit me in the future. Most importantly, it can save me a lot of precious time.

[Elisa Naomi Tibok]

Today Dr. Ravi thought us about a function of word and excel that is Mail Merge.

It is a useful tool that helps merge a database(made from Excel) with a single document in Word.

The steps are to create the original document in Word with the variables stated but left blank.

Then to create a database in Excel with the variables from Word, we are then to save the Excel document.

We then return to the documents in word where we merge the 2 documents by clicking Mailings> Start Mail Merge > Follow Step-by Step Merge and then on to follow the instruction wizard that will guide us through the merging that is we have to select the excel document and the variables it goes with.

I find this tool very useful.

[Fiona Yeoh Joe Sin]

What an exciting lesson today! I have never known that a tool such as Mail Merge existed in Microsoft Office. So silly of me to manually type all my letters for the past 19 years! The following steps are the methods to use the Mail Merge Tool; 

Step 1 : In Microsoft Office Excel, key in Name, Venue, Date and Time on the first row (It is important to key in              the variables on the FIRST ROW) followed by the list of recipients and their particulars under each                    variable. Save and exit.

Step 2 : In Microsoft Office Word, type the letter. Then, click Mailings >> Start Mail Merge >> Step by Step                   Mail Merge Wizard

Step 3 : On the tab on the right, click next (twice as I recall) until a Browse button is shown. Open the                           Microsoft Office Excel document. A list will be shown containing all the information. Click okay.

Step 4 : Move the cursor to the empty space on the letter where the particular (eg Name) is supposed to be.                  Click on it and click Insert Merge Field >> Name

Step 5 : Repeat Step 4 with all the other particulars.

Step 6 : To preview, click Preview Results and the '>' button to view each letter. The letters can now be saved                  and printed.

I am definitely going to utilise this tool in my future letter printings. It would save me so much time! :)

Fiona Yeoh Joe Sin (7276/Block 3)

[fatihahtul hanan md nor]

 Having elected as secretaries for numbers of clubs and societies before, it was my task to deliver emails and letters to other students. I had a hard time before managing the emails as I did not know that there is an easier method to merge names in your letters instead of typing them out one by one. As of today, I learnt something valuable which is to Mail Merge. 

The steps are as follows.

1) Type in the name, venue, and other necessary particular informations needed in the letter on Microsoft Word.

2) Open Microsoft Excel

3) Type in on the boxes provided the details i.e names, venue,date

4) Save the excel file preferabbly on desktop

5) Open Microsoft word again and press the button Mailings

6) Press start mail merge

7) Press Step by step start mail merge wizard and follow the 6 steps given

8) Press Browse and choose the file you saved just now

9) Press select table and mail merge recipient

10) Press Finish and Merge

 Done!

[Helena Aishah binti Nordin]

Step 1: Draft out the letter on Microsoft Word. Let the variables (Name, Venue, Date and Time) empty.

Step 2: Open Microsoft Excel. On the first row insert Name, Venue, Date and Time. Then fill in all the particulars.

Step 3: Save the file.

Step 4: Open the Word document again. Click on Mailings, then Start Mail Merge. At the bottom will be the wizard. And it will help you through 6 easy steps.

Step 5: And just like magic, you'll get all your recipient details on separate letters.

Can't wait to learn more things!! :)

[Koh Yun Xin]

1)Word-key in data...

2)excel-first row for group names---insert data---save to "desktop"...

3)word-mailings---start mail merge---step by step mail merge wizard---nxt---nxt---browser---select doc from excel ---ok---insert merge fields---preview result.....

.....^^.it will be a handy tool when dealing with invitation cards,letters and questionnaires...

[NOR FATIN SHAZLIN AMELIA SALLEH]

Today I learn how to use the Microsoft Word EXCEL and Microsoft Word facilities to send an email to different people in faster way.This way is very easy and make my job.I've never encounter mail merge facility before and this made me very facsinating to be in ICT class.With Dr. Ravi's help we can finish it in just about 20 minutes.

[Amirah Hanoum binti Amin Ariff]

Today we learned about Mail Merge. The function of it is to ease the process of printing the same document, take for example, an offer letter to different recipients.

Steps :

1. Open Microsoft Word and type out the document. Include the heading of the varying component. (address, e-mail, name, venue, time etc)

2. Save the document and close it. Next, open Microsoft Excel and type out the varying headings in each column. Fill in the details respectively. Save and close it.

3. Open the same previous word document, and click the following :

 Mailings > Start Mail Merge > Step by Step Mail Merge Wizard > Next: Staring Document > Next: Select Recipients >    Browse > Select the saved Excel file

4. You can ensure that everything is in order at the preview results.

5. Once satisfied, click print and the printer will print multiple documents with different recipients. :)

[Wan Aemellia Elisha]

Today i learnt about mail merge during the class. 

Step 1: Prepare a mail template on Microsoft Word

Step 2: Prepare database on Microsoft Excel Spreadsheet and save the document

Step 3: Go back to Microsoft Word and click 'Mailings' tab>Start Mail Merge>Step by Step Mail Merge Wizard

Step 4: Follow the step by step mail merge on right panel and click browse file to find the database of recipient list that we have made in Excel

Step 5: Click 'Insert Merge Field' and add any field from the recipient list to the document

Step 6: Click 'Preview Results' to see what it looks like when actual data from the recipient list is being added to the merge fields in the document.

Step 7: Print it and the printer will print multiple documents with different recipients

[nurul asnida binti aziz]

i studied the most superb technology that will help us to finish the works in making something like offer letter to many persons easier and super fast. we don't need to write it again and again...just use the microsoft word and microsoft excel ...

it is something good experience... excited to learn more....      

[Nazhatul Shahirah binti Hasbulla]

Today I learnt about mail merge during ICT class.

Step 1 Open Microsoft Word and prepare a template of an interview letter

Step 2 Minimise the document

Step 3 Open Microsoft Excel and use the spreadsheet to prepare a database of names, dates, venues and times for the interviewees

Step 4 Save the database on Desktop

Step 5 Return to the letter template on Microsoft Word and click on Mailings. Select Mail Merge

Step 6 Follow the step by step mail merge provided on the right panel

Step 7 Click Preview Results to see the result

Step 8 The names from the database will be incorporated into the letter template document, together with the respective dates, venues and times

Step 9 From here, the document can be printed to generate multiple letters for different interviewees

This is a new thing for me and I am grateful for having learnt this. I am sure in future occasions, this mail merge technique will come in handy for me.