Reflection on Mail Merge

Reflection on Mail Marge

The work done on mail marge enrich my knowledge on information communication Technology in different directions. It also provide a gate way to make the difficult work easier. By doing mail marge on this module I have learned that, merging is a useful feature to send a same letter to a group of people.

It simplified a mass communication. Addressing each individual letter group of people take a lot of time. Sending a letter to parents is something I always come across in my working field. But when I learn mail marge this allow me to create a template file and edit it manually to add names, addresses and other individualized details. The amount of time and effort required to create each letter one at a time proved discouraging, however, especially for a large list with which I communicate frequently. Rather than resort to printing contact information and salutations on a photocopied form letter, look to Microsoft Word's mail merge capabilities to simplify the process of sending a unified message with customized detail.

In Addition to that, I learned how to design, format and graphic the content created to serve as the main mail merge document. This make me to take full advantage of all the formatting features of Microsoft Word. It is also a great thing I have learned that mail marge support all the structure, photo graphic style elements of colour created in word or dynamically linked from other Microsoft Office applications. In addition to that, I also came to know that any styling or visual element that have been incorporate directly into the main document appears in each customized iteration of the merged result. This is a great feature I have leaned which allow me to make my work more creative and attractive.

Furthermore, I also learned that Marge mail allow to personalise my documents for its intended recipient, with condition options, depending on other conditions specify. This options allow to change the documents based on the needs and recipients and occasions. This is very useful tool to make the document more familiar to the occasions, save our time and make our work more efficient and effective. 

FOR MORE INFORMATION VISIT

https://www.youtube.com/watch?v=cx6Ve-kwLxU

https://support.office.com/en-ca/article/Use-mail-merge-to-create-and-print-letters-and-other-documents-f488ed5b-b849-4c11-9cff-932c49474705

Read More

Reflection on "if" condition

                        

Reflection on "IF" Conditioning

“IF” statements in excel is a powerful ways to streamline or automate parts of our work or build in quality checks. I have found that “IF” condition in Excel is very useful tool in decision making when a defined criteria is given. This tool make the decision accurate and faster. From this module I have learned how to use “if” function to the grades when marks are entered to the excel sheet. This reduce the mistakes and save time compare to the time we spend on entering the grades manually. 

Additionally, I also learned that “IF” condition can highlight the applied cell in different colours with certain criteria. This feature enable us to easily identify failed or passed students. Furthermore it can also be used to do calculation within a second. For example making salary sheets and calculating overtime duration take lot of time if we it manually. I believe this useful feature will make my work more efficient and accurate.  

FOR MORE INFORMATION VISIT

https://www.youtube.com/watch?v=a6KbSOLSO_Y

Read More

Mail Marge

MAIL MERGE 


FIRSTLY PREPARE A DATA SOURCE 

In a data file, information is organized into columns and rows. Each column represents a category, such as first name, last name, company, or street address. Each row, except for the first row, represents one complete record or set of data. The first row is special. Called the Header row, it contains the column names.

Read More

Conclusion

 Conclusion

Your electronic portfolio serves as a comprehensive compilation of work developed across diverse contexts, offering a dynamic platform for sharing text, videos, graphics, and coursework. It facilitates learning by enabling students and faculty to effectively organize, archive, and showcase their work.

This e-portfolio highlights key areas covered in the ICT Skills for Teaching and Learning (EDUC1002) module. Throughout this course, I have acquired essential skills in Microsoft Office, including mail merging, referencing, and e-form development in MS Word. Additionally, I have expanded my knowledge by integrating hyperlinks in MS PowerPoint to enrich the teaching and learning process. Moreover, I have gained confidence in utilizing MS Excel and various other technologies to enhance the effectiveness and appeal of the learning process.

Furthermore, the reflections included in this blog provide readers with insights into the benefits I have gained from this work. I have found this module immensely valuable in enhancing my skills and knowledge in information technology, igniting a deeper interest in acquiring further technological skills for application in both my personal life and work environment.

Overall, this module has been instrumental in advancing my proficiency in information technology and fostering a greater enthusiasm for continuous learning and the application of technology in various aspects of my life.

Read More

Hyperlink

In Microsoft PowerPoint, you can easily create hyperlinks to navigate between slides within the same presentation, link to external websites, link to email addresses, or even link to specific files. Here's how you can create different types of hyperlinks in PowerPoint:

Hyperlink to Another Slide in the Same Presentation:

Select the text or object (such as a shape or image) that you want to turn into a hyperlink.

Right-click on the selected text or object, and then select "Hyperlink" from the context menu.

In the "Insert Hyperlink" dialog box, click on "Place in This Document" on the left side.

Select the slide you want to link to from the list of available slides.

Click "OK" to create the hyperlink.

Hyperlink to an External Website:

Select the text or object you want to hyperlink.

Right-click and choose "Hyperlink" from the context menu.

In the "Insert Hyperlink" dialog box, enter the URL of the website in the "Address" field.

Click "OK" to create the hyperlink.

Hyperlink to an Email Address:

Select the text or object you want to hyperlink.

Right-click and choose "Hyperlink" from the context menu.

In the "Insert Hyperlink" dialog box, select "Email Address"

Read More

IF Function

Read More

Welcome

Read More

E-Forms

An eForm, short for electronic form, refers to a digital document designed for data entry and submission via electronic devices such as computers, tablets, or smartphones. These forms serve various purposes across industries, including business, government, education, healthcare, and more. They have become increasingly popular due to their efficiency, accessibility, and environmentally friendly nature.

eForms streamline processes by eliminating the need for paper-based documentation, reducing errors, and enabling faster data processing. They often include interactive elements such as dropdown menus, checkboxes, and text fields, allowing users to input information easily. Additionally, eForms can incorporate validation rules to ensure data accuracy and completeness before submission.

Organizations utilize eForms for diverse applications, including job applications, surveys, registration forms, order forms, feedback forms, and compliance documentation. They can be customized to match specific branding guidelines and integrated with backend systems for seamless data transfer and storage.

The adoption of eForms has led to significant cost savings by reducing paper consumption, printing, and manual data entry efforts. Moreover, they enhance user experience by offering accessibility features and the convenience of filling out forms remotely at any time. As technology continues to advance, eForms will likely become even more prevalent, revolutionizing traditional paper-based processes across various sectors.

Read More

Reflection on E-Forms

Reflection on Electronic Forms

Electronic Forms is an important tool for communication. Electronic forms can be used in variety of purposes in teaching and learning process. From this module I learned how to create an e-form and its uses. It can be used in collecting information and feedback from parents and children about their classes. This form can be uploaded in school web site or school blog and students or parents can communicate with school on different topics. Similarly, E- forms can be used as application form for different post like school captain, Vice-captain etc. This will make the process faster as computer can select student for school captain as well as other posts if the conditions and criteria is installed in the computer. In addition to that, I have learn that e-form can be made using different templates to make it more attractive. 

FOR MORE INFORMATION VISIT

 http://smallbusiness.chron.com/create-electronic-forms-ms-word-55165.html

https://www.youtube.com/watch?v=KQrvd3bW1wo

Read More

Introduction

Establishing an optimal learning environment can significantly elevate student motivation and enhance their engagement. The integration of technology in education plays a crucial role in bolstering learners’ motivation and nurturing the development of their learning skills.

Blogs emerge as one of the most widely utilized technologies for information dissemination. They facilitate interaction and grant access to information for both educators and students, regardless of their location. This blog constitutes a component of my assignment for the ICT Skills for Teaching and Learning (EDUC1002) module, aimed at sharing some of the coursework completed within this course. Additionally, I have incorporated materials from the GCE O' Level contest for self-learners. These materials encompass various topics such as referencing in MS Word, mail merging, e-form creation, hyperlinks in MS PowerPoint, as well as the "IF" function in MS Excel and mathematics resources.

I am confident that this information will prove invaluable to readers, aiding them in enhancing their proficiency in these areas.

Read More

Hyperlink

Reflection on Hyper-link

In Microsoft Power-point, a hyper-link is a connection from a slide to another slide, a custom show, a Web page, or a file. From this module I have learned that hyper-link itself can be text or an object such as a picture, graph, shape, or Word-art. Additionally I also learned that, hyper-links can be given to mails, Images, another slides, internet source etc. In Power-point, hyper-links become active when we run our presentation, not when we are creating it.

It is really interesting tool in power point rather more important for my field of teaching. This will make students more interesting when we make a small presentation with questions, giving a hyper link to correct and wrong answers with interesting pictures. This also can be used to assess students’ level of understanding the topic. Similarly I have found this tools as crucial while as it can be given Hyper-link to any shape or actions button link video or important sites and other slides etc. I believe this will bring a positive change to class room teaching. 

FOR MORE INFORMATION VISIT

• https://www.youtube.com/watch?v=53QJAAqm-EA
• 
  
• https://support.office.com/en-in/article/Create-a-hyperlink-459946fe-0747-4474-84e8-273d734466fe 

Read More

Referencing

APA (American Psychological Association) referencing in Microsoft Word involves utilizing the built-in referencing tools to cite sources within your document and generate a bibliography in the APA style. Here's a guide on how to do it:

1. Inserting Citations:

   • Click on the "References" tab in Microsoft Word.
   • Select "Insert Citation" and then choose "Add New Source" to input citation details manually or select "Insert Citation" to insert a citation from existing sources.
   • Enter the required information such as author name, publication title, year, etc.
   • Click "OK" to insert the citation into your document.

2. Choosing APA Style:

   • After inserting all citations, ensure that APA style is selected for your document.
   • Go to the "References" tab and click on the dropdown menu in the "Citations & Bibliography" group.
   • Choose "APA" from the list of citation styles.

3. Creating Bibliography/References:

   • Once you've inserted all citations, place your cursor at the end of your document where you want the bibliography to appear.
   • Click on "Bibliography" in the "References" tab.
   • Select "Insert Bibliography" to generate a list of all the sources you cited in APA style.

Example:

Suppose you're writing a research paper on the effects of social media on mental health. Here's how you would reference sources using APA style in Microsoft Word:

1. Insert a citation for a journal article:

   • Click on "Insert Citation" > "Add New Source".
   • Enter author name, article title, journal name, publication year, etc.
   • Insert the citation where needed in your document.

2. Insert a citation for a book:

   • Click on "Insert Citation" > "Add New Source".
   • Enter author name, book title, publisher, publication year, etc.
   • Insert the citation in the appropriate place in your document.

3. Once you've finished inserting all citations, go to the end of your document.

   • Click on "Bibliography" > "Insert Bibliography".
   • Word will generate a bibliography listing all the sources you cited in APA style.

Read More

Reflection on Referencing

Reflection on Referencing Referencing is one of the difficult and time consuming work in academic writings. Microsoft Office offered an easy way of inserting referencing and bibliography. This tool enable me to insert in text as well as insert reference list on one click. From this, I have learned how to edit the in text and keep referencing as “end text” referencing or “beginning text” referencing. This tool also give options for different style such as APA, Chicago and IEE etc. 

Similarly, I also came to know that inserting reference from Ms Word reduce the mistakes we do while referencing. We just have to make sure the information entered to Ms Word is placed correctly. It avoid double citation of same source in the reference list as well as not citing a source in the reference list which is given at, in text reference. This make my work faster increasing its effectiveness. Because manual siltation require inserting reference on both in text as well as to list manually. But by learning this feature in Ms-Word provide me the reference just by one click. This saving our time and reduce mistakes. This is very useful tool I have learned from this module which make my works more efficient.

FOR MORE INFORMATION VISIT

https://www.youtube.com/watch?v=1JIbo0z-yVw

http://www.c-sharpcorner.com/UploadFile/8ea152/how-to-create-cross-referencing-in-word-2013/

Read More