I.
Image Placement
A. In Line with Text
This is the default setting for images that are inserted or integrated in
your document. It treats your image like a text font with the bottom side totally
aligned with the text line. This setting is usually used when you need to place
your image at the beginning of a paragraph. When placed between texts in a
paragraph or a sentence, it distorts the overall appearance and arrangement of
the texts in the paragraph because it will take up the space it needs vertically,
pushing whole lines of texts upward.
[Link]
This setting allows the image you inserted to be placed anywhere with the
paragraph with the text going around the image in a square pattern like frame.
C. Tight
This is almost the same as the Square setting, but here the text “hug” or
conforms to the general shape of the image. This allows you to get a more
creative effect on your document. This setting can mostly be achieved if you are
using an image that supports transparency like a .GIF or .PNG file.
[Link]
This setting allows the text on your document to flow even tighter taking
the contours and shape of the image. Again, this can be best used with .GIF
or .PNG type of image.
[Link] and Bottom
This setting pushes the texts away vertically to the top and/or the bottom
of the image so that the image occupies a whole text line on its own.
F. Behind Text
This allows your image to be dragged and placed anywhere on your
document but with all the texts floating in front of it. It effectively makes your
image look like a background.
G. In Front of Text
As it suggests, this setting allows your image to be placed right on top of
the text as if your image was dropped right on it. That means whatever part of
the text you placed the image on, it will be covered by the image.
II. Key Terms
Mail Merge – a feature that allows you to create documents and combine or
merge them with another document or data file.
Form Document – the document that contains the main body of the message we
want to convey or send.
Data File – includes the individual information or data or the recipient‟s information.
Merge Field/Place Holder – marks the position on your form document where
individual data or information will be inserted.
.JPG – file extension for the Joint Photographic Experts Group picture file.
.PNG – file extension for Portable Network Graphics image file.
.GIF – file extension for the Graphics Interchange Format image file.
Clipart – line art drawings or images used as a generic representation for ideas
and objects.
Smart Art – predefined sets of different shapes grouped together to form ideas
that are organizational or structural in nature.
Text Wrap – adjusts how the image behaves around other objects or text.
What’s More
Activity 1
Read carefully and answer the following questions. Encircle the letter of
the correct answer.
1. It is the use of computer to create, edit and print document.
A. Microsoft Word C. Word Processing
B. Word Document D. Word Processor
2. What software program is capable in creating and printing document?
A. Microsoft Word C. Word Processing
B. Word Document D. Word Processor
3. What feature of Microsoft word used to create documents that have
the same general content but may have different purpose or
recipient?
A. Mail Merge C. Send Merge
B. Print Merge D. View Merge
4. The following are the components of mail merge, EXCEPT.
A. Address C. File Name
B. Data File D. Form Document
5. What are the steps in creating a simple mail merge?
A. Create form document; preview; insert place holders; print
B. Preview; insert place holders; create form document; print
C. Create main document; create data source; insert place holders; preview
D. Create data source; insert place holders; preview; print
Activity 2
Create a simple flow chart that summarizes the steps in creating a merge document.
Activity 3
Create a simple flow chart that summarizes the steps in creating a merge envelop or
label generation.
Activity 4
Video yourself on how use the mail merge in word processing.
Upload it on the LMS assignment or send it to my gmail account
([Link]@[Link]).
What I Have Learned
Questions:
1. In your own words, explain the advantage of being a computer literate in word
processing.
What I Can Do
At the end of the lesson, write two or three sentences to complete the following:
I realized that:
I resolved that:
Assessment
I. Shade the letter of the correct answer.
1. What features of Microsoft Word allows you to efficiently create documents
that have the same general content but may have different recipients or
purpose?
mail merge send merge
print merge view merge
2. Which of the following are not a component of the mail merge?
address filename form document data file
3. What are the steps in creating a simple mail merge?
Create form document; preview; insert place holders;print
Preview; insert place holders; create form document; print
Create main document; create data source; insert place holders;
preview Creatr data source; insert place holders; preview; print
4. Where can you find the start mail merge button?
file tab references tab
mailing tab home tab
5. What type of document can you create using mail merge?
letter document envelop posters
6. What button allows you to see the result of your mail merge even before you
print or send it out?
preview results address block
insert merge field greeting line
7. What file contains the information that you need to merge with your
main document?
address block data file
contact list directory
8. What essential component of mail merge is required from users when
generating labels?
data file place holder
form document merge field
9. What image compression/file type is capable of displaying simple animation?
.bmp .gif
.jpg .png
[Link] image compression type allows you to display images in full color just
like in digital pictures?
.bmp .jpg
.gif .tiff
[Link] inserting charts on your document, what Microsoft Office application
pops up to allow you to enter and manage the parameters of your chart?
access note
excel word
[Link] external material allows you to insert organizational or structural
templates like organizational charts and flow charts on your document?
chart screenshot
pictures smart art
[Link] mail merge, it is the the main body of the message we want to convey
or send.
file data Form document
mail merge text
II. Write the letter of the correct answer on the blank before each number.
14. It allows the image you inserted to be placed
anywhere within the paragraph with the text going around the image in a square
pattern like a frame.
15. This image setting is usually used when you need to
place your image at the beginning of a paragraph.
16. This image setting allows the text on your document
to flow even tighter, taking the contours and shape of the image.
17. An inage setting that almost the same on square
setting but it conforms to the general shape of the image.
18. This image setting allows your image to be place
right on top of the text as if your image was dropped right on it.
19. This setting pushes the text away vertically to the top
and or bottom of the image so that the image occupies a whole text line on its
own.
20. This allows your image to be dragged and placed
anywhere on your document but with all the text floating in front of it.
21. .JPG stands for .
22. .PNG stands for .
23. .GIF stands for .
III. How important is the mail merge feature of Microsoft Word in different
organizations? Minimum of 50 words.
Bibliography
Word Procesing. (n.d.). Retrieved from [Link]
%20Books/BCA%20I%20SEM/BCA- 124%20Office%20Automation%20(W,E,P,A).pdf
Word Processing skills. (n.d.). Retrieved from
[Link]
Information Technology
Application Tools in
Business
Module 6
Advanced Spreadsheet Skills
This module has the following parts and corresponding icons:
What I Need This will give you an idea of the skills or competencies
to Know you are expected to learn in the module.
What’s New In this portion, the new lesson will be introduced to you
in various ways such as a story, a song, a poem, a
problem opener, an activity or a situation.
What is It This section provides a discussion of the lesson. This
aims to help you discover and understand new
concepts and skills.
What’s More This comprises activities for independent practice to
solidify your understanding and skills of the topic.
What I Have This includes questions or blank sentence/paragraph to
Learned be filled in to process what you learned from the
lesson.
What I Can Do This section provides an activity which will help you
transfer your new knowledge or skill into real life
situations or concerns.
Assessment This is a task which aims to evaluate your level of
mastery in achieving the learning competency.
At the end of this module you will also find:
References This is a list of all sources used in developing
this module.
The following are some reminders in using this module:
1. Read the instruction carefully before doing each task.
2. Observe honesty and integrity in doing the tasks.
3. Finish the task at hand before proceeding to the next.
4. Return this module to your teacher/facilitator once you are through with it.
If you encounter any difficulty in answering the tasks in this module, do not
hesitate to consult your teacher or facilitator. Always bear in mind that you
are not alone.
We hope that through this material, you will experience meaningful learning
and gain deep understanding of the relevant objectives. You can do it!
What I Need To Know
This module will assist you to learn about the IT tools used in day to day
practice of computers and data base operations. IT has been designed to provide
knowledge on various hardware and software components of computer,
operating system, various packages used for different applications, data base
concepts & operations and various issues related to IT and application of IT.
At the end of this module, you are expected to:
1. Familiarized the most commonly used functions in Microsoft Excel
2. Use several conditional functions available in Microsoft Excel
3. Use Microsoft Excel as a viable tool in market research and product
development
Chapter
Advanced Spreadsheet
6 Skills
Whether you work in the field of accounting or not, the truth is whatever
you do should be accounted for. This is because the resources you use cost you
expenses. Whether you become a scientist, an engineer, a yoga instructor, etc. it
is important to understand how a company spends to be able to deliver a product
or service. These factors could be easily being computed using spread sheet
programs like MS Excel or Google Spread sheets.
What is a Spreadsheet Software?
• allows users to organize data in rows an columns and perform
calculations on the data
• These rows and columns collectively are called worksheet.
Examples of Spreadsheet Software:
• LibreOffice Calc
• [Link] Calc
• Google Sheets
• Apple iWork Numbers
• Kingsoft Office Spreadsheets
• StarOffice Calc
• Microsoft Excel
• To open Microsoft Excel, Press “Windows Logo” + R then type “excel”
then enter.
Key Terms in MS Excel:
• Row - horizontal line of entries in a table
• Column – vertical line of entries in a table
• Cell - the place where info. is held in a spreadsheet
• Active Cell – the selected cell
• Column Heading – the box at the top of each column containing a letter
• Row Heading – the row number
• Cell Reference – the cell address of the cell usually combine
letter and number (ex. A1, B4, C2)
• Merge – combining or joining two or more cells
• Formula – is an expression which calculates the value of a cell.
• Functions – are predefined formulas and are already available in Excel
• Formula Bar – the bar that displays the contents of a cell
FUNCTIONS
BASIC MATH OPERATIONS:
• =SUM(x,y) or =SUM(range) – returns the sum of x and y or (all the numbers within the
range)
• =PRODUCT(x,y) – returns the product of x and y
• =QUOTIENT(x,y) – returns the quotient of x divided by y
• =x-y – returns the difference of x subtracted by y
• =x+y – returns the sum of x and y
• =x*y – returns the product of x and y
• =x/y – returns the quotient of x divided by y
• =x-y – returns the difference of x subtracted by y
OTHER FUNCTIONS:
• =ABS(x) – returns the absolute value of x
• =AVERAGE(x,y) – returns the average of x and y
• =CONCATENATE(x,y) – joins x and y
• =IF(Condition, x, y) – returns x if the condition is true, else it returns y
• =ISEVEN(x) – returns true if x is an even number
• =ISODD(x) – returns true if x is an odd number
• =COUNT(range) – counts the number of cell containing a number within a range
• =COUNTIF(range, criteria) - count the number of cell that fits with the criteria within the
range
• =ISNUMBER(x) – returns true if x is a number
• =ISTEXT(x) – returns true if x is a text
• =LEN(x) – returns the length of characters in x
• =PROPER(x) – returns the proper casing of x
• =LEFT(x,y) – returns the characters of x specified by y (from the left)
• =RIGHT(x,y) – returns the characters of x specified by y (from the right)
• =PI() – returns the value of pi
• =MIN(x,y) – returns the smallest number between x and y
• =MAX(x,y) – returns the largest number between x and y
• =MIN(range) – returns the smallest number within the range
• =MAX(range) – returns the largest number within the range
• =POWER(x,y) – returns the value of x raised to the power of y
• =ROUND(x,y) – rounds x to a specified number of digits (y)
=COLUMN(x) – returns the column number of x
• =ROW(x) – returns the row number of x
• =SQRT(x) – returns the square root of x
• =TRIM(x) – removes extra spaces in x
• =UPPER(x) – returns x in all capital form
• =LOWER(x) – returns x in non- capital form
• =TODAY() – returns the current date
• =NOW() – returns the current date and time
Exercises:
Consider this data:
ACTIVITY 1: FIRST TABLE. Give the formulas to get :
• Mark‟s , Pete‟s, Ana‟s and Rea‟s averages
•The highest grade that Ana got
•The lowest grade that Mark got?
•Sum of all Math Grade? Science? A.P.?
•Sum of all Rea‟s Grades
•The Lowest Number among all grades
•The remarks (Passed or Failed)
ACTIVITY 2 : SECOND TABLE. Give the formulas to get :
•Mark‟s Full Name
•Ana‟s Full Name in Proper Case
• Count the number of letters that Pete‟s Last Name has
•“COLL” from Rea‟s Last Name
•“LOEY” from Pete‟s Middle Name
• Combining “WILL” and “LINS” from Mark and Rea‟s Last Names respectively
Information Technology
Application Tools in
Business
Module 7
BASIC DATA ANALYSIS USING
SPSS
This module has the following parts and corresponding icons:
What I Need This will give you an idea of the skills or competencies
to Know you are expected to learn in the module.
What’s New In this portion, the new lesson will be introduced to you
in various ways such as a story, a song, a poem, a
problem opener, an activity or a situation.
What is It This section provides a discussion of the lesson. This
aims to help you discover and understand new
concepts and skills.
What’s More This comprises activities for independent practice to
solidify your understanding and skills of the topic.
What I Have This includes questions or blank sentence/paragraph to
Learned be filled in to process what you learned from the
lesson.
What I Can Do This section provides an activity which will help you
transfer your new knowledge or skill into real life
situations or concerns.
Assessment This is a task which aims to evaluate your level of
mastery in achieving the learning competency.
At the end of this module you will also find:
References This is a list of all sources used in developing
this module.
The following are some reminders in using this module:
1. Read the instruction carefully before doing each task.
2. Observe honesty and integrity in doing the tasks.
3. Finish the task at hand before proceeding to the next.
4. Return this module to your teacher/facilitator once you are through with it.
If you encounter any difficulty in answering the tasks in this module, do not
hesitate to consult your teacher or facilitator. Always bear in mind that you
are not alone.
We hope that through this material, you will experience meaningful learning
and gain deep understanding of the relevant objectives. You can do it!
What I Need To Know
This module will assist you to learn about the IT tools used
in day to day practice of computers and data base operations. IT
has been designed to provide knowledge on various hardware
and software components of computer, operating system, various
packages used for different applications, data base concepts &
operations and various issues related to IT and application of IT.
At the end of this module, you are expected to:
1. To apply software statistical tests in our research endeavors.
2. To identify the right statistical tests based on
research objectives/hypotheses/framework.
3. To perform software statistical tests using SPSS.
To analyze and interpret SPSS results in a scholarly manner using applicable stat