How do I do Excel basics and NHDI calculation on excel?

Anonymous
timer Asked: Jul 8th, 2018
account_balance_wallet $15

Question Description

This question has 2 parts. One is to "watch" videos to learn how to do some basic things on excel; This practice sheet must be submitted. The second part is NHDI calculation on excel that needs to follow a certain format. Please read instructions carefully and I will attach necessary files. The course textbook is available online but I don't think you will need it.

Unformatted Attachment Preview

Excel: Week 1 July 2nd -July 6th Due July 6th (5 PM) In this first week, you will get familiar with Microsoft excel. To do so, please watch the videos below and try to apply the examples on your own version of excel. It is best if you download the recent version from Binghamton University’s website by following the instructions: https://www.binghamton.edu/its/software/msoffice.html An older version of excel will work but will give you trouble later-on during the course. Please do not use google sheets. It is NOT the same thing. The goal of these videos is to teach you a set of basic skills of excel that you need moving forward in the course. You don’t have to follow each video in great detail, but you need to make sure that you can apply the skills in each video. Learning these skills will take a large chunk of your first week, and spending a lot of time watching and applying these videos will be expected. I will test your learned skills through the different homework and possibly one or both midterms. You can learn these skills in the videos in any way that best fits you. I suggest that you create your own “fake” data on excel (Fill up a few columns and rows with numbers and characters as needed), and apply each skill you learn from the videos. You can always duplicate the data used in each video if you find that easier to do. Submission: At the end of the week, namely July 6th by 5 p.m., submit the excel file that you experimented with. IMPORTANT: I will not grade this file, I will simply look at it to make sure that you have been doing something. When it comes to this kind of non-graded excel submission, please don’t stress on what to include and not include in the file. Just do your best. Since this is an online course, I want to make sure that everyone As mentioned earlier, I will test your skills using the homework each week and midterms. Unlike this submission, for excel files submitted for homework, I will be very particular, and I require them to be printed as PDF (details in homework instructions). 1. 2. 3. 4. 5. 6. 7. 8. 9. Introduction: https://www.youtube.com/watch?v=rwbho0CgEAE Add Cells/Columns: https://www.youtube.com/watch?v=5WI-Do14f34 Formatting Cells: https://www.youtube.com/watch?v=etAMC0KRuBE Basic Math in Excel: https://www.youtube.com/watch?v=5HHSyKEJd2c (uses older version but should generalize well) More Basic Math: https://www.youtube.com/watch?v=xc14gFFyiTw More on Basic Math: https://www.youtube.com/watch?v=J-W3thqtDpQ Basic Excel Math Functions: https://www.youtube.com/watch?v=-9d4m79twdA Paste/Special: https://www.youtube.com/watch?v=q3fV8ALYkU8 (You don’t need to watch past minute 15) More on Paste/Special: https://www.youtube.com/watch?v=0aPbpngJeqg 10. Excel Shortcuts (Very Important): https://www.youtube.com/watch?v=k_MIeDLEgC8 (All are useful but first 10 – shortcuts are most important, and you will won’t succeed in the course without) 11. Freeze Pans in Excel: https://www.youtube.com/watch?v=zuhsUNBeNHw 12. Work with multiple worksheets on excel: https://www.youtube.com/watch?v=qRShQcv3LI 13. Relative and Absolute References (Very Important): https://www.youtube.com/watch?v=iDg9s7BJ2m4 14. Important match functions on Excel: https://www.youtube.com/watch?v=LzZ3k3rKswk 15. Cubic Roots: https://www.youtube.com/watch?v=ikoCCkabrn4 16. Geometric Means: https://www.youtube.com/watch?v=3xb_e1o5kQg 17. Print work into a PDF (Extremely important for homework submissions): https://www.youtube.com/watch?v=tpdu0pp4Zho 18. More on Printing: https://www.youtube.com/watch?v=8XcFTeCu98k If one or more of the links don’t work. Please let me know what number is not working. Also, feel free to google your own tutorials. Homework 1 Calculating the NHDI on Excel Due July 6th at 5 pm You need to have finished the response sheet and seen all the videos and learned the skills before doing this homework. Also, this homework as well as all others need to be printed as PDF as explained below. Follow the following instructions to do the homework: 1. Go to the technical notes to compute the NHDI through this link: http://hdr.undp.org/sites/default/files/hdr_2013_en_technotes.pdf 2. Go to Page 2. There are two tables: (1) Goalposts for the HDI (2) Table for Ghana. Input both tables in your excel sheet in a very organized and clear manner. You can stack them on top of each other or next to each other. You decide. Use formatting techniques you learned to make them look like a table. You can color it or bold it as you see fit. Just make sure you make the tables stick out on the sheet. 3. Underneath the tables, calculate the NHDI entirely on Excel. Use formulas as you see fit. BE CAREFUL HERE: Don’t simply input the numbers, I want you to use call references to do the math. In other words, don’t re-enter the number but reference them through the cells from the table you created in (2). Do the calculation in several steps as follows: a. Calculate each one of the dimension indices: Life Expectancy, Mean years of Schooling, Expected Years of Schooling, and Income Index b. Reference the Mean Years of Schooling and Expected Years of Schooling cells to calculate the Education Index c. Calculate the final NHDI using the previous calculations When you do this, your NHDI will automatically update as soon as you change any number in the original table. This is because your formulas are all interrelated. Change a number to check? Did your Final NHDI change? If it did, then you are doing this correctly. 4. I need you to organize your submission as follows: a. Write the general formula to calculate each index underneath the tables and before the calculations as text. To write anything in excel as text, you have to include quotations before and after the entry. For example, “Homework 1” as opposed to simply typing Homework 1, which will give you an error. Also, write down the equation to calculate the NDHI in the same manner. A division sign of “/” is acceptable, you can’t input the fraction division sign in excel. b. For each formula you calculated under step 3, I need you to do the following: i. Click at a given cell and press: Ctrl + ` for Windows and Command + ` for Mac. The key ( ` ) is in the upper left corner of most keyboards. Do you see that now, instead of displaying a final number, the cell shows the formula? ii. For each calculation, I want you to have two cells. One Cell showing the formula and another showing the final result. iii. Use sub-titles and formatting to make this look organized. You might want to insert “ = “ to make things look as organized as possible 5. YOU NEED TO PRINT YOUR RESULTS AS PDF. Once you do all the above, you need to print your excel sheet as PDF. Refer back to the printing videos on the Excel Sheet to learn how to do that. To print as PDF, go to the printer name after you click print and change it to PDF. Are you able to see that? ALL YOUR WORK SHOULD LOOK NEAT AND FIT ON ONE PAGE ONLY. HOMEWORK NOT PRINTED ACCORDINGLY WILL BE PENALIZED. Grading Criteria: Your final product will have the following components that will be graded as follows: 1. Formatted Tables inputted from Text and formulas inputted as text with subtitles for all calculations (5 pts) 2. Cells containing the calculated formula (5 pts) 3. Cells containing the solution for each formula (5pts) 4. Document does not exceed one page and well organized as PDF (5 pts) ...
Purchase answer to see full attachment

Tutor Answer

Nyctutor
School: University of Maryland

Hey, I've uploaded an excel file f...

flag Report DMCA
Review

Anonymous
Tutor went the extra mile to help me with this essay. Citations were a bit shaky but I appreciated how well he handled APA styles and how ok he was to change them even though I didnt specify. Got a B+ which is believable and acceptable.

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors