Thursday, 16 November 2017

Data Analytics and Personal Development Training

Abisund Research Institute® (ARI), an establishment endowed with the capability of performing  academic and business researches, in partnership with the training arm of Friends of De-Light (FDL), are making  learning data analytics affordable for young professionals.  ARI and FDL are organizing a 3-day training on Data Analytics and Personal Development respectively, each being taught by competent facilitators daily.
Due to the cost of the training, both organizations have decided to reward the brightest applicants a 95% scholarship. The brightest applicants will be selected after having being successful in the application process.
Designing a study
Preparing a codebook, data file and getting to know SPSS
Preliminary analyses (Descriptive statistics, Manipulating the data, Checking the reliability of a scale and choosing the right statistics)
Statistical techniques to explore relationships among variables (correlation, multiple regression, logistic regression and factor analysis)
Statistical techniques to compare groups (T-tests, Analysis of Variance ANOVA, Multivariate Analysis of Variance MANOVA, Analysis of Covariance ANCOVA and MANCOVA)
Non-parametric Statistics (Chi-square, Mann-Whitney U Test, Friedman Test and Spearman's Rank Order Correlation)
Results interpretation and policy recommendations 
And lot more ...
露However, due to the rigor of the training, the organizers have made arrangements for free lunch, SPSS installation package and Data file for practice for all participants.
In addition, after completion of the training, every successful participant will be issued a certificate.
*To apply for this training, click the link below.* 

Friday, 4 August 2017

Most Used Excel Keyboard Shortcuts By Michael Olafusi


I remember my Excel genius Indian senior colleague telling me in 2011, "Michael you are too slow!" I couldn't understand. I never felt faster. I was moving the mouse furiously and pounding on the keyboard. If I was faster it would look like I was on drugs.

So I asked him, "Why? I am working really fast."

"Nope, you are not. You are using the mouse. In Excel, if you use the mouse then you will be very slow. Use keyboard shortcuts."

That advice changed my Excel life. In a few weeks I had memorized enough keyboard shortcuts that I could be on Excel making complex reports and switching between eight different Excel files without touching the mouse. I even close Excel files without clicking on anything, I use CTRL + W.

Today, I will be sharing with you my most used keyboard shortcuts.

I will start with a list of the ones we all know and move to less known ones.

  • CTRL + C = Copy
  • CTRL + V = Paste
  • CTRL + X = Cut
  • CTRL + F = Find and Replace
  • CTRL + B = Make cell entry bold
  • CTRL + U = Underline cell entry
  • CTRL + I = Make cell entry italic
  • CTRL + A = Select all (within current region). Do CTRL + A twice to select entire Excel sheet
  • CTRL + O = Launch the file opening dialog box. To open an Excel file,
  • CTRL + P = Print
  • CTRL + S = Save 
  • CTRL + Z =Undo
  • CTRL + Y = Redo (more like undo undo)
  • CTRL + T = Convert your cells records to a table. Tables are more colorful and formula friendly. Try it for any Excel list you have created.
Now to the less known.

CTRL + down arrow key
This will enable you jump from the top of an Excel table to the bottom.


And the cool thing is that it works with the other arrow keys. If you want to jump from bottom to the top, just press CTRL + up arrow key. Also try it with the left and right arrow keys.

CTRL + SHIFT + down arrow key
This will enable you select everything from top to the bottom of an Excel table. Saves a lot of precious time clicking and scrolling.


F2
The one thing every new user of Excel finds very frustrating in Excel is making a correction to what you've typed in Excel. It's not like Microsoft Word where a backspace will let you correct OPENE to OPEN. In Excel doing a backspace will wipe out the entire cell entry. And this is where F2 comes to the rescue. Pressing on F2 lets you work with the cell record like you would in Microsoft Word, and pressing a backspace will now work as expected.

F2 is one of the function keys at the top of your keyboard.

CTRL + D
Sometimes I need to drag a formula down. You can use the mouse to drag the formula down or simply select the cell with the formula and all the cells below that you want to drag the formula down to, and do CTRL + D.



The great thing is that you can drag formula to the right too, by doing CTRL + R

ALT keyboard shortcuts
In Excel (and other Microsoft office programs) if you press the ALT key, you will see a bunch of letters at the menu bar. Pressing one of the letters you see will make Excel act like you've clicked the menu option the letter represents.

In the screenshot below I pressed ALT and the letters came up. Then I pressed letter P, which is for Page Layout. Notice what happened, in the second screenshot.




If I press another letter for the options under Page Layout, I will be doing the same thing as clicking that option with my mouse.

And that's the magic of using the ALT keyboard shortcuts. Try it. Remember that you shouldn't press the keys at the same time. Press ALT and wait for Excel to catch up and show you the set of letters available, the press the letter you want and wait again. 

My favourite ALT keyboard shortcuts are 
  • ALT, H, V, V => To paste what I copied as values
  • ALT, H, K => To format number as comma style (10000 to display as 10,000.00)
  • ALT, H, 9 => To remove decimal points (change the 10,000.00 to 10,000)
  • ALT, H, E, A => To erase everything in the cells I selected, including borders and color formatting. The usual Delete only removes content not borders and colors. So I use this a lot.
  • ALT, A, M => To remove duplicates
  • ALT, N, V, T => To insert a Pivot Table. It's ALT, N, V for Excel 2013
  • ALT, A, F, T => To import a text file into Excel
  • ALT, H, V, S, V, D => To add one cell's value to another cell's. Equivalent of copy, paste special, paste as value and add to existing value.
  • ALT, H, V, S, E = > Paste as transpose. I use this a lot too.
  • ALT, H, V, S, V, M => To multiply a cell with the value of another cell. Same as copy paste special, paste as value and multiply. I use this to convert numbers stored as text to numbers by multiplying them all with a cell I typed 1 into. 
And those are my most used Excel keyboard shortcuts.

There is one more, it is ALT + TAB. I use it to switch between different opened Excel files.


Saturday, 29 July 2017

WE DO RESEARCH EVERYDAY



Humans are 'intuitive' scientists ....always asking questions and testing theories about themselves, others, events, the environment and the world around them.
Research is asking a question and finding out the answer.....
  1. It is looking into something.
  2. It is looking for something.
  3. It is comparing and contrasting things.
  4. It is finding out more information...it is counting things ...making enquiry  ...being curious...finding out what people think...finding out what people do....finding out what works.... finding out what doesn't work...finding out what people want...
What research have you conducted recently?
  1. What decisions have you made about your day?
  2. What decisions have you made today?
  3. What influenced your decision to take this course?
  4. How do you prepare and write assignments?
  5. How do you decide how to provide the best quality of service for your service users?
We all engage in or do social research as we act on the basis and results of our own research and theorising, therefore, what we think affects the way we behave....


Friday, 28 July 2017

STRUCTURE OF A TYPICAL RESEARCH ARTICLE


The structure of a research paper might seem quite stiff, but it serves a purpose: It will help find information you are looking for easily and also help structure your thoughts and communication.

An empiric paper frequently follows this structure:

Title
Abstract
Introduction
Literature review 
Methodology
Data presentation and Analysis
Results 
Discussion
Conclusion
References


Academic Layout of a Research Paper

The layout for a research paper is important because it can influence how your data is interpreted by the reader.  While you may not like the task of writing the paper, you do want to present your data in an appropriate manner.  How you arrived at your conclusion is one matter, but if it isn’t presented well, how do you expect people to take your work seriously especially if you put a lot of time in studying.  Breaking your research paper into sections can help you stay focused on presenting details in a positive manner.  The following tips can help you identify steps you need to take on developing a layout for your paper.

  • Your layout may depend on the length of your research paper.  For instance, a longer paper may include a citation page.  Review layout samples to give yourself an idea of what parts are included.
  • Know the basic components that make up your paper. The introduction, results and conclusion are a few sections commonly included.  The abstract, table of contents, reference & citations and appendices may be other sections to add depending on what your paper calls for.
  • A title page may be required which details pertinent information about the paper.  While this page is one of the shortest included, it can be one of them most challenging to complete when you are unsure what needs to be mentioned and proper format. The good news is this page can be created last, after the paper has been typed.  You have time to think of a good title based on information comprised through research. 
  • The abstract is an important section that is often read first before the rest of the paper.  It summarizes other sections of your research into 1 paragraph, usually about 200 to 250 words. 
  • The introduction may include several pieces of significant information such as your thesis statement and brief history of your research.  Seek helpful tips to help you construct your introduction; it should be written in a way to help others understand what the topic is about with.
  • The method section of a research paper details what you did to collect your data.  This may entail mentioning equipment, sample collections, locations visited and techniques used to perform experiments. 
  • The results section may include graphics or tables to show information collected. Other sections that would follow results include discussion, summary & conclusion, references, acknowledgements and appendices.

Thursday, 27 July 2017

How to Write a Great Research Proposal


How to Write a Research Proposal

Regardless of whether you are applying for the Master or PhD programmes, your research proposal should normally include the following information:

1. Title

This is just a tentative title for your intended research. You will be able to revise your title during the course of your research if you are accepted for admission.

2. Abstract

The proposal should include a concise statement of your intended research of no more than 100 words. This may be a couple of sentences setting out the problem that you want to examine or the central question that you wish to address.

3. Research Context

You should explain the broad background against which you will conduct your research. You should include a brief overview of the general area of study within which your proposed research falls, summarising the current state of knowledge and recent debates on the topic. This will allow you to demonstrate a familiarity with the relevant field as well as the ability to communicate clearly and concisely.

4. Research Questions

The proposal should set out the central aims and questions that will guide your research. Before writing your proposal, you should take time to reflect on the key questions that you are seeking to answer. Many research proposals are too broad, so reflecting on your key research questions is a good way to make sure that your project is sufficiently narrow and feasible (i.e. one that is likely to be completed with the normal period for a MJur, MPhil or PhD degree).

You might find it helpful to prioritize one or two main questions, from which you can then derive a number of secondary research questions. The proposal should also explain your intended approach to answering the questions: will your approach be empirical, doctrinal or theoretical etc?

5. Research Methods

The proposal should outline your research methods, explaining how you are going to conduct your research. Your methods may include visiting particular libraries or archives, field work or interviews.

Most research is library-based. If your proposed research is library-based, you should explain where your key resources (e.g. law reports, journal articles) are located (in the Law School’s library, Westlaw etc). If you plan to conduct field work or collect empirical data, you should provide details about this (e.g. if you plan interviews, who will you interview? How many interviews will you conduct? Will there be problems of access?). This section should also explain how you are going to analyse your research findings.

6. Significance of Research

The proposal should demonstrate the originality of your intended research. You should therefore explain why your research is important (for example, by explaining how your research builds on and adds to the current state of knowledge in the field or by setting out reasons why it is timely to research your proposed topic).

7. Bibliography

The proposal should include a short bibliography identifying the most relevant works for your topic.


Tips for Writing Your Research Proposal


1. Know yourself: Know your area of expertise, what are your strengths and what are your weaknesses. Play to your strengths, not to your weaknesses. If you want to get into a new area of research, learn something about the area before you write a proposal. Research previous work. Be a scholar.

2. Know the program from which you seek support: You are responsible for finding the appropriate program for support of your research.

3. Read the program announcement: Programs and special activities have specific goals and specific requirements. If you don’t meet those goals and requirements, you have thrown out your chance of success. Read the announcement for what it says, not for what you want it to say. If your research does not fit easily within the scope of the topic areas outlined, your chance of success is nil.

4. Formulate an appropriate research objective: A research proposal is a proposal to conduct research, not to conduct development or design or some other activity. Research is a methodical process of building upon previous knowledge to derive or discover new knowledge, that is, something that isn’t known before the research is conducted.

5. Develop a viable research plan: A viable research plan is a plan to accomplish your research objective that has a non-zero probability of success. The focus of the plan must be to accomplish the research objective.

6. State your research objective clearly in your proposal: A good research proposal includes a clear statement of the research objective. Early in the proposal is better than later in the proposal. The first sentence of the proposal is a good place. A good first sentence might be, “The research objective of this proposal is…” Do not use the word “develop” in the statement of your research objective.

7. Frame your project around the work of others: Remember that research builds on the extant knowledge base, that is, upon the work of others. Be sure to frame your project appropriately, acknowledging the current limits of knowledge and making clear your contribution to the extension of these limits. Be sure that you include references to the extant work of others.

8. Grammar and spelling count: Proposals are not graded on grammar. But if the grammar is not perfect, the result is ambiguities left to the reviewer to resolve. Ambiguities make the proposal difficult to read and often impossible to understand, and often result in low ratings. Be sure your grammar is perfect.

9. Format and brevity are important: Do not feel that your proposal is rated based on its weight. Use 12-point fonts, use easily legible fonts, and use generous margins. Take pity on the reviewers. Make your proposal a pleasant reading experience that puts important concepts up front and makes them clear. Use figures appropriately to make and clarify points, but not as filler.

10. Know the review process: Know how your proposal will be reviewed before you write it. Proposals that are reviewed by panels must be written to a broader audience than proposals that will be reviewed by mail. Mail review can seek out reviewers with very specific expertise in very narrow disciplines.

11. Proof read your proposal before it is sent: Many proposals are sent out with idiotic mistakes, omissions, and errors of all sorts. Proposals have been submitted with the list of references omitted and with the references not referred to. Proposals have been submitted to the wrong program. Proposals have been submitted with misspellings in the title. These proposals were not successful. Stupid things like this kill a proposal. It is easy to catch them with a simple, but careful, proof reading. Don’t spend six or eight weeks writing a proposal just to kill it with stupid mistakes that are easily prevented.

12. Submit your proposal on time: Duh? Why work for two months on a proposal just to have it disqualified for being late? Remember, fairness dictates that proposal submission rules must apply to everyone. It is not up to the discretion of the program officer to grant you dispensation on deadlines. Get your proposal in two or three days before the deadline.

ReferenceDr. Hafizal Yahaya

Wednesday, 26 July 2017

ABOUT US

Abisund research institute® (ARI) is an establishment endowed for doing academic and business research. ARI specializes in basic academic research for effective and efficient policy recommendations.

ARI is responsible for management and processing of survey data having demonstrable experience working with statistical softwares such as E-views, SPSS,  Stata, and SAS among others. ARI staffs have analytical minds  and are comfortable working with data, with experience in ODK programming.

ARI currently publishes reviewed academic journals and hosts academic conferences to support the research and publication needs of college and university faculty. ARI journals accept submissions in education, ethics, technology, instructional pedagogies, legal issues, economics and all business fields.

Our mission is to provide a quality research publication venue for academic authors and students from colleges and universities whose primary focus is teaching. ARI data analysts, editorial staff and reviewers will work with authors to develop and improve submissions, providing constructive commentary, data analyzing, results interpretation and evaluation to improve the submission and the author's writing capabilities.

Abisund Research Institute®  is a privately-owned, for-profit research institute and operating in Ibadan, Nigeria. ARI is not affiliated with any other organization or university.