A: For students who are NOT at PIDE, they can take ANY data series from the WDI data set and work the midterm on this data series. I have posted SOME data series on the website in an EXCEL spreadsheet -- download WDIData.xlsx from MIDTERM page. They can submit midterm by email to UZMA like others, and they will also be graded like others.
B: Remember that data sets will require some cleaning, by deleting blank rows and columns. That will make it easier to do the spreadsheet calculations. DELETING a row or column is DIFFERENT from deleting data in that row (which is easy). DELETING the row makes the entire row DISAPPEAR from the spreadsheet. In EXCEL 2007 and 2010 there is a menu item on top right hand side which you can click on after highlighting the row or column. To highlight row or column just CLICK on the COLUMN NAME (Letter) or the ROW NAME (number). After that you can delete the row.
C: HEADING LINE of the data has been removed. This is ANNUAL DATA which starts with c oluimn E being 1960, F is 1961, G 1962, ..., O is 1970, Y is 1980 and so on. It goes upto about 2010 which is column BC - but each series has different amounts of data. You should label the data with these headers so that you KNOW which years your data is for. In many cases, data is available only for a few years (not for all). So delete the BLANK years, and also delate the BLANK countries. Note that blank countries will not usually bother the EXCEL functions, which work correctly -- however, sometimes you need to take into account the SIZE of the data set, so you need to count how many non-blank entries there are.
D: AFTER doing calculations in EXCEL, you must copy over all necessary information to the WORD document you submit as solution. In the word document, EVERYTHING required for the answer MUST BE PRESENT. YOU CANNOT SAY look at the EXCEL spreadsheet for the solution to this. YOU must copy relevant diagrams and figures into the word document. EXCEL spreadsheet must be submitted separately, so that we can verify the calculations. PLEASE USE YOUR OWN NAME as the name of the documents you submit -- both for WORD and for EXCEL spreadsheet.
B: Remember that data sets will require some cleaning, by deleting blank rows and columns. That will make it easier to do the spreadsheet calculations. DELETING a row or column is DIFFERENT from deleting data in that row (which is easy). DELETING the row makes the entire row DISAPPEAR from the spreadsheet. In EXCEL 2007 and 2010 there is a menu item on top right hand side which you can click on after highlighting the row or column. To highlight row or column just CLICK on the COLUMN NAME (Letter) or the ROW NAME (number). After that you can delete the row.
C: HEADING LINE of the data has been removed. This is ANNUAL DATA which starts with c oluimn E being 1960, F is 1961, G 1962, ..., O is 1970, Y is 1980 and so on. It goes upto about 2010 which is column BC - but each series has different amounts of data. You should label the data with these headers so that you KNOW which years your data is for. In many cases, data is available only for a few years (not for all). So delete the BLANK years, and also delate the BLANK countries. Note that blank countries will not usually bother the EXCEL functions, which work correctly -- however, sometimes you need to take into account the SIZE of the data set, so you need to count how many non-blank entries there are.
D: AFTER doing calculations in EXCEL, you must copy over all necessary information to the WORD document you submit as solution. In the word document, EVERYTHING required for the answer MUST BE PRESENT. YOU CANNOT SAY look at the EXCEL spreadsheet for the solution to this. YOU must copy relevant diagrams and figures into the word document. EXCEL spreadsheet must be submitted separately, so that we can verify the calculations. PLEASE USE YOUR OWN NAME as the name of the documents you submit -- both for WORD and for EXCEL spreadsheet.
No comments:
Post a Comment