UGB 004 Assignment: Referencing Styles and Mail Merge

Desklib provides past papers and solved assignments for students. This assignment covers referencing and mail merge.

UGB 004
Question 1
Any article, assignment, course work or case study which is being submitted need to be
referred correctly based on the available sources which is used for the assignment. The
lecturers who tend to state the references state that they mean the acknowledgement of the
sources in the in-text as the citation in full aspect or in part of the references list. Citing the
sources used to prepare the assignment in an appropriate manner will assist the student to
avoid any plagiarism which is important for the assignment and also assist the tutors and
lecturers to locate the correct sources which is applied for preparing the assignment.
Furthermore, it will also help the readers to identify the right source of information for
preparing the assignment, the citation of the sources recognises the intellectual property of
the authors which has been noted in the research article. Furthermore, it will enable in
demonstrating the researcher to build on their assignment, it will provide them the essential
resources for applying the referencing.
There are various applications of referencing standards which tend to differ in low and in
which aspect, they tend to present in an essential information like the author(s) of the
research paper, the data in which it has been published, the title of the research topic, the
name of the publisher, volume number, page number etc. these will help the students and
tutors to quickly refer them and apply. In case of subjects like arts, commerce and
management the referencing system which is used is Harvard referencing format which is
also called as the author/date referencing system.
Since as a student of the University of Sunderland, the individuals tend to possess the access
to Cite Them Right Online which is the available resources and the universities recommend
to help in getting started with the referencing sources. It is highly important guide to
understand the Harvard referencing style though it also provide the guidance on the most
common formats which is involved in the referencing. The application of “Cite Them Right”
helps the students to use the appropriate sources for enhancing the quality of the assignment
prepared and applied. The first aspect to be noted is that the individuals have to think on the
identification of sources, it may vary like journal articles, books, online sources, newspapers
etc. if the sources is found to be highly significant for the application of the materials, then
the students should mention about the preparer and the work in a sentence format which will
introduce the citation. If in case the application is only citation is for a minor point, then the
student can consider in applying the parenthetical references or as an end notes to the
assignment. There are also various aspects of citation for different disciplines, for example
when the student want to cite the sources in a psychology paper the use of citation method
will be different, whereas in case of management or arts related paper the citation which is
applied tend to differ, same is the case in case of English class. Furthermore, the student need
to consult with the instructor so as to understand the overall form of citation appropriate for
the paper.
The following is the example of applying the citation in the assignments
Business magazine

Books
Sometimes, the researcher applies the citation at the footnotes, which means that they are
placed at the bottom of the page were the citation is being stated. The student tend to cite the
references in detail or may place a comment on the part of the text above it, say for example
in the numbering form like 1, 2 etc.
However, the footnotes are not interesting comments. Sometimes they only refer to the right
sources - they inform the reader of the source of certain documents and whether they can
search from other sources. To determine if you want to list your sources in footnotes or in the
document's text, ask your instructor or visit the chapter on transfer format. If possible, place a
footnote at the end of a sentence immediately after the point or other punctuation that
complements this sentence. Before the next sentence begins, two blank fields must be placed
after the footnote. If you need to insert a footnote in the middle of the sentence for clarity, or
if the phrase contains more than one footnote (try to avoid it!), Try placing it at the bottom of
the page. end of the most significant expression after a comma or other punctuation mark.
Otherwise, do the most important thing at the end of the word. If the footnote is not at the end
of a sentence, skip the space.
Question 2
The following is the family budget
Incomes Monthly Annual
Self income 3,000.00 36,000.00
Other Income 300.00 3,600.00
Total Income 3,300.00 39,600.00
Expenses Monthly Annual
Housing 1,000.00 12,000.00
Groceries 350.00 4,200.00
Telephone 100.00 1,200.00
Electric / Gas 70.00 840.00
Water / Sewer / Trash 15.00 180.00
Cable TV 50.00 600.00
Internet 100.00 1,200.00
Maintenance / Repairs 50.00 600.00

Childcare 0.00 0.00
Tuition 400.00 4,800.00
Pets 100.00 1,200.00
Transportation 300.00 3,600.00
Personal Care 100.00 1,200.00
Insurance 200.00 2,400.00
Other 0.00 0.00
Total Expenses 2,835.00 34,020.00
Gross Income before tax 465.00 5,580.00
Taxes at 18% 83.70 1,004.40
Net Income after tax 381.30 4,575.60
Creating the annual budget using formulas
Incomes Monthly Annual
Self income 3000 =+[@Monthly]*12
Other Income 300 =+[@Monthly]*12
Total Income =SUBTOTAL(109,[Monthly])
=SUBTOTAL(109,
[Annual])
Expenses Monthly Annual
Housing 1000 =+[@Monthly]*12
Groceries 350 =+[@Monthly]*12
Telephone 100 =+[@Monthly]*12
Electric / Gas 70 =+[@Monthly]*12
Water / Sewer /
Trash 15 =+[@Monthly]*12
Cable TV 50 =+[@Monthly]*12
Internet 100 =+[@Monthly]*12
Maintenance /
Repairs 50 =+[@Monthly]*12
Childcare 0 =+[@Monthly]*12
Tuition 400 =+[@Monthly]*12
Pets 100 =+[@Monthly]*12
Transportation 300 =+[@Monthly]*12
Personal Care 100 =+[@Monthly]*12
Insurance 200 =+[@Monthly]*12
Other 0 =+[@Monthly]*12
Total Expenses =SUBTOTAL(109,[Monthly]) =SUBTOTAL(109,

[Annual])
Gross Income
before tax
=+Income4[[#Totals],[Monthly]]-
Expense35[[#Totals],[Monthly]] =+C27*12
Taxes at 18% =+C27*0.18 =+C28*12
Net Income
after tax =+C27-C28 =+C29*12
Question 3
How to create Mail Merge
Mail merge is one of the essential tools which assist in creating multiple documents in a
quick manner, the documents which tend to possess similar layout procedures, formatting
systems, text aspects and graphics can be included in the mail merge. It should be noted that
only a specific section of the documents tend to differ and they are personalised, the
documents can create with mail merge which include bulk labels, letters, envelopes and
emails. There are three different documents which are involved in the mail merging process
The main document
The key data source
The merged document
The following are the key steps which is involved in creating the mail merge

Step 1
The key step in the process is to set up the data for which the mail merge is to be applied, the
individual need to apply the necessary steps so as to match the field names which wants to be
inserted in the mail merge, all the data which needs to be merged need to be presented in the
first sheet of the excel file
The necessary entries which are related to the mail merge like the percentages, currencies, zip
codes etc need to be formatted in the spreadsheet so that the word file can analyse the values
in a proper manner. The excel spreadsheet need to be applied in the mail merge is stored in
the local computer, the changes or the additional to the spreadsheet can be completed before
they are connected.
Step 2
In the MS Word , choose the file – new – blank document
Then in the mailing tab, click on the mail merge group, choose start mail merge option and
then kind of merge which needs to be run
The individual then need to choose the recipients and use the existing list which is already
available with the user

Then browse the excel and click on open
Step 3
In order to insert the address block on the envelope in the email
In the mailing tab, click on the write and insert field groups, choose Address book
In the insert address block, choose a format for the recipients name and the following will
appear

Choose OK, click on file and save.
References
Cite this for me. (2017). How to cite a Book in Harvard - University of Sunderland style.
http://www.citethisforme.com/guides/harvard-university-of-sunderland/how-to-cite-a-book
Microsoft (2017). Mail merge using an Excel spreadsheet.
https://support.office.com/en-us/article/mail-merge-using-an-excel-spreadsheet-858c7d7f-
5cc0-4ba1-9a7b-0a948fa3d7d3
University of Sunderland. (2017). Harvard - University of Sunderland style guides
http://www.citethisforme.com/guides/harvard-university-of-sunderland