Saturday, January 3, 2015

BLOG#3- EASY TABLE OF CONTENTS (open office)

HOW TO MAKE THE MAIN TABLE OF CONTENTS


1.    Open your paper using the open office.
2.    Highlight and assign “heading 1” to all the main parts of your paper like the introduction, materials and methods, RRL, results and discussion and other.

3.    Highlight and assign “heading 2” to the sub parts of your paper like for example under your introduction you have the background of the study, significance, time and place, scope and limitations. 




1.    After this, go to the page where you want to place your table of contents and go to insert>indexes and tables>indexes and tables>title (table of contents)>type (table of contents)>OK.



1.    Right click the word “table of contents”> update index/table.
2.    This is how your table of contents will look like.



HOW TO MAKE LIST OF TABLES

1.    Again, go to the next page where you want to put your list of tables, go to insert>indexes and tables>indexes and tables>title (list of tables)>type (index of tables)>OK.



1.    Go to the tables in your paper (usually, tables are located in the results and discussion). Highlight the title>copy>right click anywhere inside the table itself>caption>paste title>category (table)> separator (.<space>)>position (above)>OK.


1.    Do this to all the tables, then go back to your list of tables page>right click the word “list of tables”> update index/table.
2.    This is how it will look like.




HOW TO MAKE LIST OF FIGURES

1.    Again, go to the next page where you want to put your list of figures, go to insert>indexes and tables>indexes and tables>title (list of figures)>type (illustration index)>OK.



1.    Go to the figures in your paper (usually, figures are located in the methodology and results and discussion). Highlight the title>copy>right click the figure itself>caption>paste title>category (illustration)> separator (.<space>)>position (below)>OK.




1.    Do this to all the figures, then go back to your list of figures’ page>right click the word “list of figures”> update index/table.
2.    This is how it will look like.







HOW TO MAKE LIST OF APPENDIX

1.    Again, go to the next page where you want to put your list of appendix, go to insert>indexes and tables>indexes and tables>title (list of appendix)>type (illustration index)>OK.


2.    Go to the appendices in your paper. Highlight the title>copy>right click the figure itself>caption>paste title>category (illustration or table)> separator (.<space>)>position (above)>OK.


3.    Do this to all the appendix, then go back to your list of appendix’s page>right click the word “list of appendix”> update index/table.
4.    This is how it will look like.






HOW TO MAKE LIST OF APPENDIX FIGURES

1.    Again, go to the next page where you want to put your list of appendix figure, go to insert>indexes and tables>indexes and tables>title (list of appendix figure)>type (illustration index)>OK.


2.    Go to the appendix figures in your paper. Highlight the title>copy>right click the figure itself>caption>paste title>category (illustration)> separator (.<space>)>position (below)>OK.



3.    Do this to all the appendix figures, then go back to your list of appendix figures’ page>right click the word “list of appendix figure”> update index/table.
4.    This is how it will look like.




HOW TO MAKE BIBLIOGRAPHY

1.    Again, go to the next page where you want to put your bibliography, go to insert>indexes and tables>indexes and tables>title (bibliography)>type (bibliography)>OK.



2.    Go to your bibliography, click tools>bibliography database, and insert all the available information of your reference.



3.    Go back to your bibliography page>right click the word “bibliography”> update index/table.
4.    Now if you want to enter it again to your paper, find the authors in your paper and replace them with your recorded data of that author in your bibliography database.
5.    Delete the name, go to insert>indexes and tables>bibliography entry> find the author>insert.





6.    Do this to all the authors listed in your paper.
7.    This is how it will look like.




HOW TO MAKE LIST OF INDEX

1.    Again, go to the next page where you want to put your list of index, go to insert>indexes and tables>indexes and tables>title (list of index)>type (alphabetical index)>OK.



2.    Go to your paper and highlight the word that you want to put as an index.
3.    Go to insert button>indexes and tables>entry>the highlighted word should appear in the entry space>insert. Do this to all the words you want to be seen in the index.



4.    Go back to your list of index’ page>right click the word “list of index”> update index/table.
5.    Now you want to alphabetize your index and show it to a minimal view for easy searching, so you go right click the word list of index>edit>click entries>alphabetical delimiter>then go to columns> choose 2 columns>OK.
6.    This is how it will look like.




You won’t worry anymore to your table of contents because you already have a control to the different positions and pages of your paper. Very useful! 

Blog#2: STEPS TO CREATE SIMPLE GRAPHS (open office)


1.      Prepare all your data. Drag all the data that you want to show in your graph then click the “chart” symbol. In there you’ll have different graphs and style choices.

2.      Now in that chart wizard, fill in all the data you wanna out in place.

a.       For my example, I wanna use pie chart

b.      For the data range, I dragged the grades and count column, then click “first column as label”

c.       For data series, I dragged the column count for my “range for name”

d.      Then the title “grade distribution”

3.      Now, I wanna show the actual count of grades in  my chart, so I …

a.       Right click the chart itself, click “insert data labels” and BWALA!

b.      My pie chart is doneJ



1.      Same as through with a line graph…

a.       Just choose line graph as your chart type

b.      Follow the same procedure

c.       In this chart you can label your x and y axes, just right click the chart itself and select “insert titles”, type the label of your x and y axis and BWALA!

d.      You have your line graphJ


Thursday, November 20, 2014

Subject: Blog#1- Friday 9:30-12:30


The Lookup Table





Using open office spreadsheet, the grades of students are calculated without a problem.
Let’s say for example you have 50 students named s1-s50, and as a professor it is your obligation to submit their grades before another semester start, this are the steps to follow to easily finish your grade computations using open office spreadsheet. Ready? O’right.
·         Grades for 1st term, 2nd term and final term are already given. So, the first thing to do is to find the average grade of each student, average is computed using the formula: =average(cell1,cell2,cell3)/3


·         After getting the average, proceed to make your look up table composed of the list of grades and their equivalent values prior to the values of the average. This are my equivalents:


·         After you’re done with your lookup table, you are now ready to easily compute the grades of your students by just using this formula:



Example: (take note of the positions of the dollar sign)
=VLOOKUP(E2,$H$2:$I$10,2,TRUE)

·         Now that you’ve easily calculated the grades of your students, the open office also gives you another easy way to count specific grades also in percentage, let me show you how it’s done…

How to count? use this formula:


                             How to see the percentage?
                             Follow this guided formula:
                             =cell that you want to get the percentage, total no. of values of your count

(take note of the dollar signs)

Example:



·        Maximum and minimum values are known using:
=max()
=min()

·        Using the increment to count the no. of passers for a specific grade.





Example: the passing is 60, using the formula above left,
=(100-the value of passing)/the no. of grade values which is 9.
So, if the passing is 60, there will be 4 students out of 50 who will pass.