INFS1200/7900 Tutorial 3.3: SQL Advanced Introduction Purpose: The purpose of this tutorial is to provide you with experience in writing advanced SQL SELECT and CREATE VIEW queries. You will learn how to correctly use both correlated and non-correlated queries to return specific subsets of data. Learning Outcomes: By the end of this tutorial you will be able to: • Correctly use non-correlated queries • Correctly use correlated queries • Understand why and how to create views • Gain experience using techniques such a double negation to solve difficult problems in SQL Section A: Non-correlated Queries Based on the following relational schema, write non-correlated nested SQL queries to complete the tasks in this section. Reef [reefName, latitude, longitude] ReefTemp [reefName, dateOfReading, temperatureReading] Coral [coralCode, coralName, thermalThreshold] CoralSampling [sampleNumber, coralCode, reefName, dateOfSampling, bleachPercent] Foreign Keys: ReefTemp.reefName references Reef.reefName CoralSampling.coralCode references Coral.coralCode CoralSampling.reefName references Reef.reefName A.1 Return the details of all reefs which have recorded a temperature-reading above 22 degrees. A.2 What is the name of the coral that has the highest thermal threshold? A.3 Return the details of all reefs which have recorded a temperature reading below the average temperature reading across all reefs. A.4 What are the names of all reefs that do not have a sample of a coral with name including "Button”? Section B: Correlated Queries Based on the following schema, write correlated nested SQL queries to complete the tasks in this section. Reef [reefName, latitude, longitude] ReefTemp [reefName, dateOfReading, temperatureReading] Coral [coralCode, coralName, thermalThreshold] CoralSampling [sampleNumber, coralCode, reefName, dateOfSampling, bleachPercent] Foreign Keys: ReefTemp.reefName references Reef.reefName CoralSampling.coralCode references Coral.coralCode CoralSampling.reefName references Reef.reefName B.1 Which reef(s) have at least all the corals that the reef “Wreck Is.” has? B.2 Which corals are in ALL reefs? Section C: Views Based on the following schema, use SQL to create views to complete the following tasks and questions. Note: This may require you write several SQL queries per question. Blog [blogSite, owner, dateCreated] Article [blogSite, articleTitle, articleType, lengthInWords, authorName] Foreign Keys: Article.blogSite references Blog.blogSite C.1 The Australian Bureau of Statistics (ABS) needs to access a list showing the number of articles posted in the blogsites of each owner. In order to meet privacy regulations however, the blogsites themselves are not allowed to be identified with the owner. C.2 Return the owner(s) of the blog site(s) which have written the most articles on Technology, that is where ArticleType is “Technology” .
Diploma in Banking and Finance FIN5005 Credit Risk Analysis & Management Group Assignment (30% of course grade) Group Presentation/Viva (10% of course grade) 1. For this Group Assignment, form groups of 3 – 4 members. Each group member must contribute to the assignment compilation through processes including ideation, performing research and analyses and critical thinking. There are 2 parts to this assignment – Part A on personal home loans and Part B on company loans. 2. The maximum marks for this assignment are 100 marks, of which: • 75 marks shall be allocated to the analytical content of your report. • 25 marks shall be allocated to the group presentation/viva. The presentation should discuss salient points of your report. You may include a summary to reflect insights or soft skills acquired in this group assignment. You may consolidate your content in NOT more than TEN (10) PowerPoint slides. 3 PART A Please obtain relevant material from suitable sources including but not limited to the websites of any TWO (2) different banks operating in Singapore in respect of their housing loan (HDB apartment) products. Your group’s written report must address the following: a. From your research and the material culled from websites etc., describe/compare the housing loan products that your selected commercial banks in Singapore sell to their customers. In your group’s report, ensure that your group includes the purpose, maximum financing amount/quantum, tenure, usage, interest rate type, the basis of computing interest, repayment structure and any other relevant features of their home loan. Use a table to help you describe the above products and explain key concepts and terms used. (15 marks) b. Mary, 40-year-old senior corporate executives would like to buy a resale 4- bedroom HDB apartment at Pinnacle@Duxton, her first property for personal use in Singapore, with the expected purchase price of about $1.3 million. She would be living with her mother, an elderly dependent. She needs your advice and help to decide on a more suitable home loan package. She is not eligible to borrow directly from HDB. Hence, she needs to take up a bank loan. They are currently renting a private apartment. Mary’s personal cashflow statement for the last twelve months is as follows: Cash flow for last 12 months · Cash inflows Salary (net of CPF Contribution) S$ 225,000 Interest and dividend income 25,000 Total Cash inflows 250,000 Cash outflows Insurance premium 10,000 Recreation & holidays 20,000 Personal Income Tax 25,000 Car loan 20,000 Living expenses 100,000 Total Cash outflows 175,000 Net Cash flows 75,000 Based on the income profile of Mary (you may be creative with her financial profile such as net worth and savings) and the two sets of product information on the selected banks’ home loan, recommend the more suitable package for her based on her financial profile. Support your recommendation with reasons/comparisons of benefits and costs from her perspective as a consumer. Incorporate the Monetary Authority of Singapore (MAS) rules on HDB property housing loans. You may tabulate your findings when necessary. (25 marks) 4. Part B (a) Select a publicly listed company on the Singapore Exchange (SGX). Assume that the company you have selected requires a corporate loan of $200 million to expand their business. You are the credit officer of the lending bank. You are required to conduct a credit evaluation of the company with the following qualitative analysis of the borrower. (i) business viability; (ii) operational efficiency; (iii) management quality; and (iv) the stage of growth (20 marks) (b) Working capital credit facilities for a small and medium enterprise You are the bank officer of a local bank. Your client, Grace Stationery Company (GSC) has approached you for a working capital credit line. You have gathered information on GSC, as follows: - • Grace Stationery Company (GSC) is a wholesale stationery company. As a small and medium enterprise, GSC manages its working capital carefully. It sells stationery to its customers on credit basis as most of its customers are corporate clients. GSC estimated about $9,515,000 is tied up in trade debtors. • GSC purchases stationery from India and Southeast Asia on 3 months credit. • GSC keeps 2 months inventory of stationery. • A summary of GSC financial result is appended. Your task is to determine the working capital requirement of GSC. (15 marks) 5. Submit the softcopy of your group’s written report in Microsoft Word via Canvas by 8 May 2025, 11.59 am. Penalties will be imposed on late submission, i.e. marks will be reduced by 20% if the assignments are submitted late but within 24 hours of the due date. After 24 hours of the due date, assignments that are submitted will not be marked and will be awarded zero marks. The report must NOT exceed 4,000 words. Please ensure a word count is indicated in your report. The word count does not include your cover page, content page and appendices. Any relevant research materials should be included in the appendices of the report. Please use Times New Roman Font 12 foryour group’s report, and all pages must be numbered.
Requirements for the Applied Econometrics ECON 6910 Term Paper The final paper is due on 9th of May by 11:59pm (this is a few days after our last class session). Please email me a soft copy of your term paper at [email protected]. The Stata code should appear at the end of your paper as an appendix. In the last class session (May 6th in class) each person will present their findings (5-7 minute limit) in class. You will be graded by your classmates on your in-class presentation. The final grade of the term paper assignment is worth 45% of your overall grade. The in-class presentation grade is worth 20% of the term paper grade and will be assigned to you by your peers, I will assign the other 80% of the term paper grade based on the paper itself. A one-page proposal of your paper is due by the 4th of March. I will make comments on your one-page proposal and return them to you in class a week later. I encourage you to set up a time to talk to me about your proposals via zoom if you like (either before or after you have completed the one pager). You should identify a specific economic problem and focus on a well-defined research question that can be empirically tested. The following is expected from your term paper (1) It should identify a specific economic problem and focus on a well specified research question; (2) Research the topic of interest, include a brief review of the literature, not exceeding 2 pages; (3) Formulate an econometric specification, and determine what data you will need to collect to answer your research question; (3) Use or compile a data source to analyze the issue and to answer the question (identify the source in the text); (4) Empirically test your model using the estimation strategies taught in class (include all Stata programming code (appendix) and results with your paper); (5) test for estimation problems and make any necessary corrections; (6) Analyze your results; and (7) provide concluding remarks. Correct bibliographic/reference management is required. Here (https://www.youtube.com/watch?v=BQL_7C-YqBk) is a youtube video that shows how to use a free reference management software (Zotero or Mendeley), that will make this easy for you. Please use one of these software packages to keep track of your references! The text of the paper should be no more than ten pages (double-spaced, 1-inch margin, 12-point font). Papers will be graded on correct application of econometric methods, the logic of whether your proposed data analysis can answer the economic question you pose, correct grammar and spelling, and correct bibliography/reference management. The following may help you to structure your paper. Please do not feel that you must follow it directly, and do not limit yourself to just these questions. 1) Abstract: The abstract of the paper must provide a brief description of the problem in hand and the main findings. The abstract must not exceed 150 words. 2) Introduction: This is the most important section of the paper and should summarize the main objective and the findings of your research. I recommend following Keith Head’s “Introduction Formula” which you can find at this website. http://blogs.ubc.ca/khead/research/research-advice/formula 3) Literature Review: Discuss the main findings so far outlined by other authors in the field. Explain clearly the existing research methodology used to address the objective outlined by you. 4) Empirical Specification: Before you write out the empirical specification, describe the theoretical foundations or economic logic behind the specification. Carefully write out the econometric specification you wish to estimate along with the assumptions that are necessary to obtain unbiased and consistent estimates. 5) Data: Describe the data source, variable names and how each are defined or constructed. Why is this data appropriate to answer the empirical question in hand? The reader must have no difficulty in determining how the sample was constructed. Also discuss any potential problems and limitations with your data here. 6) Results: The results must include detailed discussion of the regression estimates, alternate functional form. specification; compare your findings across specifications. Discuss potential problem with the results obtained. Are you able to correct for these problems, if yes, do correct for them using the techniques taught in this course. Use all the regression techniques and methods taught in this class that can be applied to your work. 7) Conclusion: Briefly summarize the main findings of your paper. Discuss the use and application of your findings. List of data sources 1.The Fordham University Library Web page is an excellent starting point: http://www.library.fordham.edu/ . Once you are here you should click on the Data Bases and Indexes Link Under Electronic Resources. Next click on the General Periodical Indexes link. Here you will find links to Lexis -Nexus and JSTOR, among other useful sites. The Business and Economics Link (on the Databases and Indexes page) has many other great links to directories and company industry information. 2. Data sources for development: http://ipl.econ.duke.edu/dthomas/dev_data/index.html 3. World Bank Data, for a specific (free) data query on Development Data from past 5 years from the World Development Indicators, go to: http://devdata.worldbank.org/data-query/. 4. Hussman Econometrics, links to data sources for interest rates, stock market data, money supply, economic and fiscal data, exchange rates and commodity prices, international financial statistics: www.hussmanfunds.com 5. National Bureau of Economic Research (macroeconomics, international economics, business, consumer, etc.): http://www.nber.org/data_index.html 6. Bureau of Labor Statistics (U.S. Unemployment and Price Indices): http://www.bls.gov/data/ 7. Penn World Tables/International Macro Data: http://datacentre.chass.utoronto.ca/pwt/index.html 8. United Nations Statistics Division: http://unstats.un.org/unsd/default.htm 9. OECD Data: http://www.oecd.org/els/health/data. 10. Household level and individual level data from developing countries: World bank living standards measurement survey: www.worldbank.org/lsms/ 11. Sebastian Krantz has created a site that scrapes published paper websites that include the data and code for the paper. This site includes links to the data and code the authors provided when they published their paper for more than 8475 economics articles (as of Aug. 15, 2023). You can’t just copy someone else’s paper, but this could be a very useful site to find datasets. https://ejd.econ.mathematik.uni-ulm.de/ 12. This set of slides from Emilia Tjernstrom is useful in learning details of how to navigate google scholar to find papers for the background/literature review part your term papers. She also has some slides on how to use google scholar to find datasets. https://slides.com/emiliatjernstrom/finding-sources
Diploma in Information Technology Database Management and Security Instruction for CA2 Group Assignment April 2025 Semester Continuous Assessment 2 - Group Assignment 100 marks (This assignment constitutes 40% of the overall grade) Introduction: You have been recruited by GameForge Studios, an indie game development company, to help design and implement a player account and progression tracking system for their latest MMORPG (Massively Multiplayer Online Role-Playing Game), "Elbion Online". With a growing player base, the developers need a robust database to handle player accounts, character progression, inventory and quests. Your mission is to design and develop a new database system to manage these aspects efficiently. Part 1: Player Account and Character Management (40%) GameForge Studios stores user account data in a CSV file (see Elbion Online Test Accounts.csv). You must design a database schema that prevents data integrity issues (such as data anomalies and redundancies) and ensure that all tables are in 3NF. You have been tasked with the following: Tasks: ● Analyze the fields in the CSV file and create an appropriate data model for a MySQL database. ● Ensure all tables are normalized to 3NF. ● Write an SQL script to create the necessary tables. ● Write an SQL script to load the CSV data into your tables. What to submit: 1. ER diagram of the database (15 marks) 2. SQL script. to create tables (10 marks) 3. SQL script. to insert CSV data into tables (15 marks) Part 2: Course content and announcements (30%) In "Elbion Online” , players can complete quests and collect items. Your database must support these features. To help clarify your doubts, they have provided the following business rules: Business Rules: ● A PLAYER can complete multiple QUESTS, but each QUEST can only be completed once. ● Each QUEST has a title and description ● A PLAYER can collect multiple ITEMS. ● Each ITEM has a name, description, rarity, and type (weapon, armor, potion, etc.). NOTE: Not all business rules have been listed. Based on the rules given above, you will need to create a database that best fits the requirements of your company. Tasks: ● Update your ER diagram to include QUESTS and ITEMS. ● Write SQL scripts to create new tables and update existing ones. What to submit: 1. Updated ER diagram (15 marks) 2. SQL script. to create new and update existing tables (15 marks) Part 3: Player Statistics and Economy (30%) GameForge Studios wants to analyse player performance and in-game transactions. You need to write SQL queries to help track and analyze game data. Tasks: 1. Provide a query that counts the number of characters each user has, sorted by the character count. 2. Provide a query that counts the number of characters at each level range in the game, in increments of 30 up to Level 90 (i.e. Level 1 to 30, 31 to 60, 61 to 90). Use the following formula to determine a player’s Level from his Experience points: where n is the character’s level 3. Provide a query that ranks every user in the game, based on the total amount of experience all their characters have. What to submit: 1. SQL script. to generate a report of how many characters each player has (10 marks) SQL output columns for report: 1. Username 2. Number of Characters 2. SQL script. to generate a report of the number of characters at each level range, from Level 1 to 90 (10 marks) SQL output columns for report: 1. Level Range (string) 2. No. of Players 3. SQL script. to generate a report of player ranking. (10 marks) SQL output columns for report in (3): 1. Rank S/N 2. Username 3. Experience Penalty for Late Submission of Assignment By one day: 20% to be deducted from total marks. More than one day: submission will NOT be graded. CA2 Individual Assignment Deadline: 8 May 2025, 11.59 am Rubric Part Description Task Marks Total Marks 1 Player Account and Character Management ER diagram of the database 15 40 SQL script. to create tables 10 SQL script. to insert CSV data into tables 15 2 Quests, Achievements, and Inventory Management Updated ER Diagram 15 30 SQL script. to create new and update existing tables 15 3 Player Statistics and Economy SQL script. to generate a report of how many characters each player has 10 30 SQL script. to generate a report of players at each level range, from Level 1 to 100 10 SQL script. to generate a report of player ranking 10 TOTAL 100
CSE416 Introduction to Machine Learning Q1 Learning a Tree 1 Point Select one option. Consider the following dataset. If we use the decision tree algorithm to learn a decision tree from this dataset, what feature would be used as the split for the root node? h1(x) h2(x) h3(x) Q2 Decision Boundaries 4 Points Which of the following pictures show decision boundaries that are possible to represent with a decision tree only using the features Age and Income? The regions with the green background are predicted positive and the regions with the orange background are predicted negative. Q2.1 1 Point This decision boundary can be learnt by a decision tree classifier only using the features Age and Income. This decision boundary cannot be learnt by a decision tree classifier only using the features Age and Income. Q2.2 1 Point This decision boundary can be learnt by a decision tree classifier only using the features Age and Income. This decision boundary cannot be learnt by a decision tree classifier only using the features Age and Income. Q2.3 1 Point This decision boundary can be learnt by a decision tree classifier only using the features Age and Income. This decision boundary cannot be learnt by a decision tree classifier only using the features Age and Income. Q2.4 1 Point This decision boundary can be learnt by a decision tree classifier only using the features Age and Income. This decision boundary cannot be learnt by a decision tree classifier only using the features Age and Income. Q3 Tree Depth 2 Points Q3.1 Bias/Variance 1 Point A smaller depth decision tree will have __ bias and __ variance than a deeper decision tree. higher bias, higher variance higher bias, lower variance lower bias, higher variance lower bias, lower variance Q3.2 Comparing Trees 1 Point If decision tree T1 has lower training error than decision tree T2, then T1 will always have better test error than T2. True False Q4 Calculating Classification Error 1 Point Provide a numeric answer. Based on the implementation in lecture, compute the classification error of the following tree with two output classes safe and risky. Please give your answer to two decimal places. Make sure to not start with a dot, such as .5 (instead, you would write 0.5). Q5 Splitting on a numeric feature 1 Point Provide a numeric answer. In building a decision tree to classify whether a loan is risky or not, we choose to split on the feature Annual Income from 10 training examples. Here are the values of this column for examples of each output class: Risky: 10k, 15k, 40k, 100k Safe: 20k, 61k, 82k, 89k, 95k, 96k The below image shows another view of the same data: What is the classification error of the best split? Please give your answer to one decimal place. Make sure to not start with a dot, such as .5 (instead, you would write 0.5). Q6 Comparing Ensembles 2 Points Q6.1 Which Model? 1 Point Select one option. Which following choice describes an ensemble model where each of the models in the ensemble can easily be trained in parallel (i.e. in any order)? Decision Tree Random Forest AdaBoost Q6.2 More Trees? 1 Point Consider the following claim. Select which ensemble models we discussed in class that the claim is generally true for. Claim: This ensemble model needs to select the number of trees used in the ensemble as to avoid overfitting. Random Forest AdaBoost Q7 AdaBoost 1 Point Select one option. Suppose we are running AdaBoost using decision tree stumps. At a particular iteration, the data points have weights according to the figure (Large points indicate heavier weights.) Which of the following decision tree stumps is most likely to be fit in the next iteration? Hint: Notice the labels on the decision boundary. It shows the predicted label for a side of the decision boundary under/to the right of the word "Predict" Q8 ML Practitioner Scenarios 4 Points Consider the below scenarios, and determine whether you would or would not recommend the suggested idea. In your answer, state if the suggestion is "Correct" or "Incorrect" and provide a justification as to why that suggestion would or wouldn't be a good idea. Q8.1 2 Points Pavan's computer has 8 cores in the CPU, and each core can be responsible for a parallel task. He plans to use all of them for training a random forest classifier. On each core, he makes an exact copy of the original training dataset and trains a decision tree on that copy.
FINM1415 Introduction to Finance Share Valuation Report Task Sheet Semester 1, 2025 Due at: Fri, 9 May 2025, 2:00PM Submission: A pdf file of Part A, including a cover page, is submitted to both Turnitin and the Blackboard submission link. A pdf file of Part B and your Excel file are submitted through the Blackboard submission link only. This assignment has a total mark of 100. It contributes 20% to your final grade. Part A: Stock Valuation Report – 70 marks Objective This assignment aims to step you through a basic analysis of a stock. You will analyse your stock to calculate a target price and provide a clear “buy” or “sell” recommendation to your client. Scenario You are a junior equity analyst working for a reputable investment firm. Your senior analyst has assigned you the task of preparing a comprehensive valuation report on a publicly traded company. Your client, a high-net- worth individual with a long-term investment horizon, is considering adding this company to their portfolio and has requested a thorough analysis to inform their investment decision. Your task is to determine a fair value for this company’s stock and provide a recommendation to the client. You’ll do this by undertaking both a DDM and valuation multiples method analysis. Your report should present either an estimate of the target price for your stock or an estimated range of target prices, and you should provide a clear recommendation of either “buy” or “sell” . The target price date depends on the date of your company’s most recently released annual financial statements. If your company has a reporting year that ends in June, calculate a price for 30 June 2024. If the reporting year for you company ends in December, calculate a price for 31 December 2024 Preparation You get to choose what company to write a report on. The company has to be in the same sector as your group’s assigned company from your first presentation. Everyone in your group should choose a different company, and no one can choose the specific company from your first presentation. See the Database Access Instructions pdf in the Assessment folder on Blackboard for a guide to accessing the data that you’ll need to complete this assignment. Assignment Task – 65 marks You should write a report in a maximum of 5 pages that includes the following sections: 1. Introduction (5 marks) – Give a brief synopsis of your company. What business do they operate? What’s their history? Who are they competing against? Try to answer these questions and anything else that you think is relevant for the reader to have a basic understanding of your company. 2. Dividend Discount Model (DDM) Valuation (30 marks) – Calculate a valuation for your company’s stock using the DDM. Your analysis should include: a. (5 marks) An estimate of equity cost of capital (re ) using the CAPM. You can assume an expected return on the market of 10.5% and a risk-free rate of 5%. b. (15 marks) An estimate of the growth rate in dividends‘。). You need to clearly describe the process of coming up with a growth rate estimate. Are you choosing a historical variable to estimate growth rate, or calculating growth from the return on reinvested capital? If you re using a historical variable, which variable are you choosing and why? How much historical data are you using in your estimate and why? Are there qualitative factors that you ve taken into account to adjust your estimate? If you re calculating growth using return on reinvested capital, how are you calculating the components of the growth equation? What assumptions are you making that make it reasonable to calculate growth this why, and why do you think they re justified? Are there qualitative factors that you ve taken into account to adjust your estimate? In either case, you should also consider whether it makes sense to assume that the growth estimate for the present day should continue forever, or whether it would make more sense to estimate additional stage(s) of growth in the future. Where are you taking your long-run growth estimate from? Why do think this is justified for your company? c. (10 marks) Use the inputs you estimated in parts (a) and (b) to carry out a DDM valuation so that you obtain a stock price. What recommendation would you make about investing in this stock? 3. Valuation Multiples Method (15 marks) Provide an assessment of the company using at least 3 value multiples. Your analysis should include: a. (3 marks) A statement of which valuation multiples you re looking at and why you expect each of these multiples to provide a good comparison of value between your company and a set of comparable companies. b. (6 marks) For each multiple, calculate an implied share price using a measure of the average of that multiple across comparable firms. Which measure of average did you choose to look at and why? What recommendations would you make for your stock on the basis of each of these implied values on their own? Take care if you re using an NTM multiple to multiply by an estimate of the denominator value for the next year, rather than using the most recent reported value, and justify your estimation. c. (3 marks) For each multiple, consider how the value of the multiple for your firm has changed over time and make a qualitative assessment of what that means for your recommendation about the stock. d. (3 marks) Pull your recommendations from the three variables together into an overall recommendation based on your analysis of multiples. 4. Final Recommendation (5 marks) - Compare the recommendations you gave using the DDM and valuation multiples method. What are some strengths and limitations of each of the methods? How does it support your overall argument to discuss your analysis from both sections instead of just one? What is your final recommendation for the stock and why? 5. Report Update (10 marks) – Following your final recommendation, you should add an “update” to your report. For this update, imagine that you’ve already finished publishing and distributing your report when your company suddenly announces that they will increase their current dividend payout ratio by 10%. Provide an analysis of the impact that this announcement has on your recommendations. Your update should include: a. (4 marks) An evaluation of whether increasing the dividend payout ratio is expected to be profitable looking just at the expected and required return for this extra capital. b. (4 marks) A re-calculation of your DDM, being very careful to recognise both of the key variables in your calculation that need to be updated when dividend payout ratio changes. c. (2 marks) A conclusion about whether your final recommendation stays the same or changes. Communication & Formatting – 5 marks Structure Your submission should be written in a report style. It should begin with a cover page and should include an introduction and conclusion. Your introduction should include the introduction of your company in addition to introducing the purpose of your report. Your conclusion is where you should include your final recommendation for the stock, and this should come before the report update. You do not need another conclusion after the update, which should be written as though it’s an addendum to an otherwise complete report. You should break the body of your report into logical subsections and use clear subheadings to guide the reader. You must include all of the important steps of your working in the body of your report. The grader should be able to see everything they need to assess your work by reading only the body of your report. It’s not necessary to include an appendix, and anything placed within an appendix will not be directly marked, but you are allowed to include appendices if they would aid the reader in understanding your report. Writing Style. The report should be written in a professional tone and with language appropriate for a junior equity analyst submitting a written report to a client. The language should be clear, concise, and free of spelling or grammatical errors. However, you should balance this professional tone with language suitable for a university assessment. For example, you should avoid unnecessary jargon that isn’t in common use throughout the course and provide definitions for any terms drawn from external sources. You should also show the major working steps of your numerical analyses in your report even where this might be skipped in an actual report to a client. You are not required to explain basic concepts that have been taught in FINM1415. Formatting Your report should be a maximum of 5 pages, including any tables and figures in the body of the report, but not including the cover sheet, reference list or any appendices. The grader will stop reading after 5 pages and will treat the rest of the body of your report after this point as though it was not included. Your report should use a standard, easily readable font in size 12, use normal margins on all sides, use justified text (i.e., aligned to both the left and right margins), and include a page number in the bottom right- hand corner of every page. You must begin your report with the cover page that’s provided on Blackboard. You should include your name and student number as a header on every page. Referencing All external sources should be correctly cited using the either the Harvard or APA referencing style. Please note that UQ’s version of the Harvard referencing style, called UQ Harvard, is no longer maintained or supported, but you’re welcome to use any other version of the Harvard referencing style. If using APA, you should use APA 7th as per the UQ style guide:https://guides.library.uq.edu.au/referencing/apa7. You should reference the database you used to obtain your data, but you do not need to provide a source for ideas taught in FINM1415 and don’t need to include class materials or the class textbook on your reference list. Spreadsheet File In addition to your report, you need to submit a spreadsheet file that shows you undertaking a DDM analysis. Nothing on this spreadsheet will be graded, so make sure that all your answers and important working from the spreadsheet are included in your written report. The reason you need to submit this file is so the grader can verify that you actually did a working DDM and didn’t just make up a target price. You should place your DDM valuation on the first worksheet so that the grader can see it as soon as they open the file. Don’t include anything else on this first worksheet that isn’t a part of your DDM calculation. You may include other worksheets with your other calculations or data used in your analysis (ie, you don’t need to make a separate spreadsheet file for just your DDM), but these other worksheets won’t be reviewed by the grader. Part B: SEAL Reflection – 30 marks Self-reflection is the best way to develop your understanding of your own learning process for future improvement. The SEAL reflection method is a structure that guides you to think about your experience of the course in four aspects: Situation, Effect, Action and Learning. You will complete your self-reflection by filling in the FINM1415 SEAL Reflection template from Blackboard. You submit your completed reflection as a pdf file through the Blackboard submission link at the same time as you submit your report from Part A, but you don’t need to combine these two pdfs together. Your reflection needs to be critical. You need to move beyond merely describing your learning experience, to highlighting, explaining and analysing the changes in your understanding and approaches that resulted from the experience. Some of the aspects of your experience that you might want to write about include: • What have you learned about applying textbook knowledge to real-world situations? What are the challenges of dealing with real-world analysis? Is there anything particular to the company that you evaluated that you found challenging to address? • What have you learned about working collaboratively in a team? How effective was your team’s communication, and how well might you have fared if you’d been working in an actual firm with this team? What strategies did your group use to stay productive? Have you discovered your strengths and personal challenges when it comes to working in a team? • The implications of what you have learned for your future professional practice - how would you develop your professional capabilities, and how would you work on the areas that need further development? Submission Convert your report to pdf format and give it the title: [LAST NAME]-[FIRST NAME]_[student number]_Part A.pdf Example: ASTER-JON_12345678_Part A.pdf Convert your self-reflection to pdf format and give it the title: [LAST NAME]-[FIRST NAME]_[student number]_PartB.pdf Name your Excel spreadsheet as: [LAST NAME]-[FIRST NAME]_[student number]_Excel.xlsx Submit your Part A pdf only to the Turnitin submission link. This will run a plagiarism and AI-cheating check on your report. Submit all three files – your Part A pdf, your Part B pdf, and your Excel file – to the Blackboard submission link.
Assignment 3: Leadership Journey Reflective Essay Due date: before 23:55 of Sunday, May 30 Weighting: 40% Details of task: Provide an overall concluding discussion of the unit which draws together your major observations about leadership as studied during the semester. Hint: taking notes over the semester of things that interest you from your studies, in your organisation, or in the world generally, may help. This exercise should be written in the first person (I did, I learned, I will). Take your leadership definition from week one and discuss how your ideas have changed or been reinforced over the semester. What is your definition of leadership now? And why? You may format your discussion by addressing each topic and what you learned each week (e.g., liked/disliked/agreed with/disagreed with). However, please do not merely summarise each week's readings. Instead, explain how the readings, activities, discussions, video clips, and your observations have helped you understand and apply leadership concepts to your work or life experiences and/or goals, and where you will go from here to learn more and become a better leader. What have you learned about leadership through your studies that is of benefit to you and/or your organization? You may also choose to analyse the leadership skills of the people in your organisation/life generally. Who are good leaders? Who are bad leaders? Why? Whose leadership needs improvement? Why? How might that improvement happen? What implications do your studies of leadership have for you in the future? What more do you need to learn or do? How will you develop your own leadership knowledge and skills? Where are your developmental opportunities? How will you improve where improvement is needed? Word limit: 2000 words Presentation requirements: Although you need to write in the first person, this is an academic assignment and should be referenced in the normal manner. Otherwise, the format, is up to you but lots of headings will help you to organise your thinking. Submission requirement: Online submission using the Moodle site Estimated return date: 3 to 4 weeks after submission Criteria for marking: The marking rubric is available on the Moodle site. Penalties for late lodgement: Extensions must be according to the Faculty of Business and Economics’ policy and by arrangement with your lecturer. Generative AI tools cannot be used in this assessment task: In this assessment, you must not use generative artificial intelligence (AI) to generate any materials or content in relation to the assessment task.
FINC6013 International Business Finance Semester 1, 2025 Group Assignment Group Formation This is a group research project that must be completed and submitted as a group. To encourage collaboration, students are encouraged to form a group of 4-5 students during the first two weeks of the semester. Forming groups from the same tutorial is encouraged as you can work on the assignment in class with help from the tutor! The tutor will also facilitate group formation in the first two/three tutorial classes. The class tutor should be the first contact if you need any help with the assignment (group formation and preparation). The Discussion Forum on Canvas has a dedicated section on group formation and assignment preparation. Each group is required to complete the group registration by Week 4 on Canvas. Click on the tab “people”, then “assignment group” . You can choose to enrol into any of the unfilled groups in the list. Group registration will remain open until the start of Week 4 (Monday 9am). Students not registered in a group by Monday of Week 4 will be randomly assigned to an unfilled group. Please make sure to complete group registration before it closes. Please also note that by default the first listed group member shall be the group leader, who is responsible for submission of the assignment. Mark Allocation: This project will be marked out of 30 and constitutes 30% of your overall grade. Length: The length of the project must NOT EXCEED 12 typed pages with double spacing, 12 points Times New Roman, including executive summary and references but excluding the coverage (page only contains the title and group members’ IDs) and appendix, if used. Appendices must not exceed 5 pages. There will be a penalty of 1 mark per page for not meeting this requirement. What’s included in the 12-page limit? • Executive summary • Assignment body • Tables • Figures • Reference list What’s excluded from the 12-page limit? • Title (Cover) page • Table of contents • Appendices (maximum 5 pages) Due date: The due date for the project is 11:59pm May 16th, 2025 (Week 11). A late penalty of 5% mark per day is applicable (see Unit outline). Submission: The only acceptable form. of submission is electronic via the submission link in the unit’s Canvas site. Hardcopy and email submissions will NOT be accepted. Late submissions will be penalized. See below for penalty details. All submission will be checked through TURNITIN for similarity with external sources. Submission Format: Each group can only submit ONE project report. The group leader (designated within the group) is required to submit the assignment (do NOT submit if you are not the group leader). It is imperative that your project report is submitted in ONE document. Only a PDF format document will be accepted, and it is your responsibility to ensure all pages correctly display your original content. Missing or distorted figures and formulas will result in lower marks. Please make sure the group leader submits only the final version of the assignment, as there is only ONE submission allowed. Submitting multiple versions might result in a penalty of 1 mark. Cover Page: Ensure the Student Identification Number (SID) of EACH student is on the cover page of your assignment. Student names should NOT be included in the assignment to ensure anonymous marking. The cover page should be submitted as the front page of the assignment in a single file. Document Name: Your project PDF file must be named in the following format: FINC6013_Groupnumber_2025.PDF Example: FINC6013_Group23_2025.PDF There will be a penalty of 1 mark for incorrectly named projects. Referencing: List of references used and in-text citations must follow the Harvard referencing style http://libguides.library.usyd.edu.au/content.php?pid=160012&sid=1510179 Students are expected to use more than 6 references in total. Ensure to use academic reference (not solely web sources) to support your discussions/arguments. Presentation: Pay particular attention to presentation. A significant component of your mark will be based on presentation. Avoid overdoing formatting, and ensure that the assignment is very clear, logical, and professional. Pay attention to grammar. Clear and logical presentation is a major challenge. Preparing a concise report is another major challenge. Every part of the assignment should add to the end result otherwise it is superfluous and distracting. Use of AI: The use of automated writing tools and generative artificial intelligence is prohibited in this assessment. You are not allowed to use AI or other software to create information or answers, to alter your own original writing, or to generate or modify text from other sources. This includes translation software, editing/paraphrasing software and other generative AI tools. Unapproved use is considered a breach of the Academic Integrity Policy and may result in penalties, which can include a fail for the assessment. Note also that, if you do choose to use these tools, outputs and AI-generated content in the context of this assignment is known to be highly inaccurate. Information Sources: • FRED® database of the Federal Reserve Bank of St. Louis:https://fred.stlouisfed.org/ • Central bank web sites of relevant currencies • Web sites of international organizations – OECD, IMF, BIS, etc. • International Financial Statistics (online database available from Fisher Library’s website) • Newswire and financial newspaper reports (accessible via Factiva database from Fisher Library’s website) • Other Web sources – market commentaries of FX and money market movements Penalties: Late penalty: Refer to Unit outline. Incorrect format penalties: 1 mark per page for exceeding the page limit. 1 mark penalty for inappropriate referencing and formatting. 1 mark penalty for a failure to follow the naming convention of the project. Plagiarism: While discussion and collaboration are expected, plagiarism is a breach of the University of Sydney Code of Conduct and will be dealt with by the faculty. http://sydney.edu.au/student_affairs/plagiarism/index.shtml Be sure to acknowledge all of your source materials and provide proper citations for any quotes. Checks for similar content (web materials, other students’ projects, etc.) and plagiarism will be conducted by TURNITIN and the projects with a similarity index significantly above an acceptable level will be reported to the faculty and this may result in a zero mark being awarded for the project. Group Work Ethics: Every group member is expected to be actively engaged in the whole process of group assignment. Though it is hard to divide the work completely equally, “free riding” will not be tolerated. From week 4 to week 10, you are expected to meet at least four times to discuss the assignment tasks and to update your group members on your progress. At your first group meeting, please decide who will be the group leader. The group leader will be responsible for coordinating the work of the group and submitting the group report by the deadline. Each group member will complete the Peer Performance Assessment Form (available on Canvas) and submit the form. separately online. Due to the limited marking time, we must give all group members the same mark based on group performance. However, free riders will be penalised and the information you provide on the Peer Assessment Form will be used to determine whether a group member has made a reasonable contribution to the group's work. Assignment topic continued on the next page … . Carry Trade and U.S. Elections A currency carry trade involves investors’ arbitrage upon interest rate differentials between two currencies. Carry trade is typically profitable if the interest rate differential is greater than the appreciation in the funding currency against the investment curry. Historically, investors could borrow a low interest currency, such as the Japanese Yen, and invest in a higher interest currency, such as AUD. The potential for carry trade to be profitable depends on the impact of countries’ economic policies and monetary tools on financial markets. In most countries, government policy direction depends on the outcome of government elections. In particular, as a key player in global markets, outcomes of U.S. elections often generate material uncertainty about global economic and monetary policies, significantly affecting foreign exchange markets (Brogaard et al., 2020). In this assignment, you will examine how these effects impact the profitability of carry trade. Specifically, you will investigate how changes in investor expectations about countries’ economic and monetary policies around the 2016 and 2024 U.S. elections affected the profitability of carry trade, and you will generate a forecast of the profitability of carry trade for 2024-2025. A high-quality assignment should include a balanced quantitative and qualitative analysis, including argumentation well supported by either academic or/and industry references. Each group is required to select a SINGLE currency pair of YOUR OWN GROUP’S CHOOSING, with one currency the US Dollar (USD), for which carry trade is expected to be profitable. Once you have decided on a currency pair, you are required to find and collect the following real-world data from online sources: (i) exchange rate, and (ii) monthly (usually 30-day or alternative short-term) money market interest rates for both currencies (i and i* ). There are four parts of the assignment, listed below: 1. Examine UIP Violations Pre-2016 (8 marks) a. First, justify your choices for your currency pair and interest rates: why do you expect this currency pair to deliver carry trade profits prior to 2016? Then, predict the exchange rate at the end of each month for the period January 2014 to December 2015, assuming UIP is valid. Present: (1) a time-series of the predicted and actual realized exchange rates in one figure, and (2) a time-series of the deviations between them in another figure. b. Since the UIP condition can be represented in different ways, deviations from UIP can be represented in different ways as well. One form. of UIP deviations are differences between forecasted and actual exchange rates, as discussed above. Another form are differences between percentage changes in exchange rates and interest rate differentials. Present a scatter plot of the interest rate differential, and the percentage change in the exchange rate. Discuss whether your data points lie on the 45-degree line through the origin. c. Discuss the forecast accuracy of exchange rates and implications regarding validity of UIP during this two-year period. Identify the moments, if any, where UIP appears to have been significantly violated. Would you think you have identified a profitable carry trade strategy? 2. Empirical Testing of the UIP Pre- and Post-2016 (6 marks) Use a regression analysis to test the validity of UIP for your currency pair for the periods 2014-2015 and 2016-2019. You can use Excel’s data analysis add-in or any other statistical package you have access to. Do you observe more deviations from UIP after 2016? Why or why not? In your write-up, be sure to (1) clearly identify the regression model, (2) the null hypothesis you are testing, and (3) provide appropriate discussions on the results of the regression analysis. 3. Forecasted Profitability in 2024 (8 marks) Assume you are an analyst in December 2023 who does not yet anticipate the re-election of President Trump in 2024. You want to profit from a carry trade strategy based on your findings from Parts 1 and 2. a. Using the same currency pair and interest rate data that you collected in Part 1, calculate the monthly carry trade profits/losses in terms of your financing currency, assuming that investors invest a certain amount of money at the beginning of 2024. You can also try different holding periods, such as quarterly or semi-annually (you may need to collect more data). b. Had you employed the same trade identified in 2014-2015 (that is, the funding currency and investment currency) as in Part 1, would you make any profit/loss? Why or why not? What main factors contributed to the profit/loss of your strategy? How would you explain the changes in carry trade profits/losses over time (monthly, quarterly, or semi-annually)? c. Economists currently expect a Trump presidency to lead to economic policy changes that increase inflation, requiring the Federal Reserve to keep interest rates high, or to the introduction of high tariffs on foreign imports. If these expectations materialize, do you expect the returns from carry trade for your currency pair to increase or decrease in 2025? Why or why not? 4. Conclusion (3 marks) Do you think conducting carry trade with your chosen currencies is profitable in the current (2025) economic landscape? Why or why not? Additionally, 5 marks will be awarded for high quality executive summary presentation, references, and academic writing. References Brogaard, J., Dai, L., Ngo, P.T.H., and Zhang, B. 2020. Global Political Uncertainty and Asset Prices. Review of Financial Studies 33(4), 1737-1780.
INF6001 Information Systems Project Management Coursework Assignment 2024-25 1. Introduction The purpose of the assignment is to provide you with the opportunity to try out the various project management techniques and apply them to a case study. There are two components to the assessment: one group report (40%) and one individual report (60%). Each of these components have separate marking criteria, available in Blackboard. The assignment brief needs to be read together with the Marking Criteria sheets for the two assignments. 2. Learning Outcomes The assessment covers the following learning outcomes of the module: • Demonstrate awareness of the need for effective management of IS projects; • Understand and use techniques for estimating IS and IT activities; • Produce a project plan which indicates deliverables and milestones. • Understand human resource and team management issues in IS development; • Demonstrate the skills to schedule human and other resource for the development of an IS/IT system; • Show awareness of risk assessment and management issues for IS projects; • Show awareness of quality issues for IS projects. 3. Case Study: Project management of a new Customer Relationship Management (CRM) system Background The South Yorkshire based company ‘CraftBrew’ manufactures and supplies craft beer for the drinks industry. This beer is sold through its own chain of CraftBrew bars and through other independent bars and retailers. They also have an online shop and are stocked in selected large supermarket chains. In 2022, CraftBrew developed an idea for a new investment scheme through their own platform. ‘Apply4Shares’, approved by the Financial Conduct Authority (FCA) which offered 330,000 new shares in the brewery aiming to raise a total of £3 million. In exchange for their cash, investors get a stake in the business and perks such as discounts online and at CraftBrew bars and a complimentary beer on their birthday. Management expect sales to increase by 20% by the end of 2026, otherwise CraftBrew may lose out on market share and be unable to continue with its plans for international expansion. To support CraftBrew’s vision, the company intends to use some of the money raised to implement a new CRM system to help improve processes such as sales management, contact management and reporting. The Executive have commissioned a project to provide a new CRM system and estimate the cost of the project to be £1million. The project will purchase an existing CRM software package and will configure it to meet CraftBrew’s specific requirements. A team of consultants, experienced at implementing this package, has already been identified to lead the project, including the configuration, customisation and handover of the system. Scope of project The three phases of the project are to manage the (I) selection/acquisition, (II) configuration/development and (III) deployment/handover of a new CRM application and related hardware within a £1million budget. You will create and manage a project team to undertake this project. This assignment relates to the key elements of planning the project. Timing of project The Board of Directors has allocated funds from 1 June 2025 so the project can commence then. The project must be completed – the system fully tested and handed over for operational use – by 1 June 2026. Project governance CraftBrew will establish a Project Board which will meet monthly to control the project. 4. What you need to do 4.1. Scope Management Plan You need to develop the Scope Management Plan. This will include: • Work Breakdown Structure (WBS). The WBS needs to be based on the Project Lifecycle and the Systems Development Lifecyle. If following the waterfall approach, the WBS needs to be based on phases, activities etc. If you follow an Agile approach, the WBS is based on epics, user stories etc. You need to start off with creating a hierarchical chart that defines the project phases and the system development phases. The System development phases will depend on what development approach you will follow (waterfall or agile). This is a choice that you need to make and follow through with it for the entire project. After this, you need to develop the list of deliverables and milestones (see below) so you need to consider the WBS on the basis of deliverables and work-to-be-done. You are NOT expected to prepare use case diagrams etc, but you need to account for the work required to prepare these. • You need to convert your WBS to a Detailed Task List (DTL) and this DTL will need to contain the following: o a clear hierarchical structure o how these are associated to each other o Resource allocation: assign people to tasks (adding people may result in shorter completion times but will increase the budget) o Estimates for tasks: based on what needs to be done by when and by whom, estimate the time required for each task (these estimates will depend on the development approach you follow). Make sure you explain how you calculated these (timeboxing, lines of code etc). 4.2. Detailed Project Plan You have identified what is needed to complete the project in terms of work. You now need to focus on how you will achieve this. You need to develop a Detailed Project Plan. Based on the WBS and the DTL you need to consider whether you can shorten the project schedule (e.g., tasks can be executed in parallel if the resources are available). The detailed project plan (Gantt chart) needs to contain the following: • Linkages between tasks. Opportunities for shortening the duration of the project need to consider task dependencies. • Information on the beginning and end of the project (dates) and the number of days needed to complete the project (you need to consider weekends, bank holidays etc in your calculation) • Information of the resources usage (are there resources underused/overused? There has to be some kind of balance so you need to include information on how you can balance the load if there are concerns) • The above essentially will be depicted on the Gantt chart, but you also need to provide a narrative around the questions indicated above. The above are still relevant if you follow an Agile approach, but instead you will need to develop the release plan rather than a Gantt Chart and provide an overview of the Kanban Board you will be using for tracking the project. 4.3. Risk Management Plan Now that you have completed the project plan, KnowHow indicated that they feel comfortable with your proposal in that it meets their business needs, you need to develop the Risk Management Plan. • You need to identify risks (minimum 5, maximum 10). There should be at least one risk identified for each of the project lifecycle phases (a phase may have one risk, and others considerably more). • You need to analyse each risk using the tools you have been taught (matrix, register etc). • For each risk, you need to identify and describe a mitigation strategy. The risk management plan needs to take into consideration the SDLC method used. 4.4. Quality Management Plan Your report needs to contain a Quality Management Plan. The plan should include the following: • A brief statement describing the team’s approach to quality and your objectives for ensuring you deliver a system fit for purpose to your client. • Develop and describe the quality-based metrics you will use • Develop and describe the validation activities you need to complete The quality management plan needs to take into consideration the SDLC method used. 4.5. Implementation Plan Finally, you need to develop the Implementation Plan. Implementation/Deployment activities are needed to transform. a newly developed information system into an operational system for end users. The initial operation of a new information system generally requires a conversion process. • You need to provide a strategy for the conversion (releasing the system to the client). There are different conversion strategies (direct cutover, parallel, phased). You need to choose one of these, and explain why you consider this strategy to be more relevant for the particular project. • A number of implementation challenges can occur. Consider added complexities that often stem from having to adjust to new mindsets, communication patterns, and workflows. • You also need to critically review alternative project management approaches that could be taken to manage the successful delivery of this project, while highlighting any specific issues that may be faced if they are chosen. 5. Assignment Details The purpose of this coursework is to provide you with an opportunity to try out the various project management techniques and apply them to a case study. Sections 3-5 of this document provide you with the project brief and details on what you need to prepare. You need to use the information provided, alongside your knowledge of project management to carry out a thorough project plan. There are two components to the assessment. 5.1. Group Assignment (40% of mark): Project planning (2,000 words) Based on the project outline provided by the client, you need to develop the documents indicated by points 1-2 of Section 5: Scope Management Plan and Detailed Project Plan. You will work on this group assignment within the groups assigned for the seminars. The components required will need to be included in a single document. The document needs to be professionally looking, addressed to your client, KnowHow. This document will need to contain the following: • Executive summary (5%) - Briefly introduce the report and summarise the main aspects of your project plan for the client (e.g., important deadlines, primary deliverables) • Scope Management Plan (40%) – You need to provide the WBS for the project, considering both the Project Lifecycle and the Systems Development Lifecycle. You will need to choose an approach to development (waterfall or agile) and you will need to justify your decision on the basis of the information you have been given and the available literature. You will need to produce the DTL. Section 5.1 includes details with regards to what you need to cover exactly as part of the Scope Management Plan. • Detailed Project Plan (40%) – The detailed project plan needs to be based on the WBS and the DTL you have included as part of the Scope Management Plan. You are expected to produce a comprehensive Gantt Chart (or the equivalent release plan if you do an agile project). Remember to include overhead tasks (e.g., meetings for sign off, sprint planning), dependencies between tasks, resources, and time estimates. You need to justify your decisions on the basis of the information you have been given and the available literature. Section 5.2 includes details with regards to what you need to cover exactly as part of the Detailed Project Plan. • Appendix (pass/fail, i.e., you get no marks for including it, but you lose 3 marks if you don’t) – You need to include in the appendix the Team Contract (this refers to your Group work, NOT the project itself). You may need to update it as you move forward the assignment, and if you have included any updates, you need to include the first and the final version, and indicate and explain any such updates. The Team Contract should include: o Project team members, student ID, roles and responsibilities for the assignment: what are the skills and knowledge you will contribute to the assignment and what you have been tasked with doing o Means of communication: how you will communicate with each other (e.g., via , GMeet etc), when and where you will be meeting (e.g., every Tuesday, online) o Rules and Expectations: how you will make decision during conflict, what happens in you miss a meeting, or a team member does not contribute to the assignment. o This document is mandatory and very important and you need to think carefully what you will include in that as it is meant to hold you accountable to each other and to your tutor. If the Team Contract is not included, you will lose 3 points. Make sure that any important decisions you take are clearly presented, discussed and justified and that the report uses clear language (15%). To prepare the above you may want to use a software package such as MS Project, ProjectLibre, Lucidhart etc, or you can produce your content manually (hand written charts and figures). Irrespective of your choices, you need to ensure that everything is readable in your submission as outlined in Practical 1. You should submit a single copy of the group assignment including the student ID of all group members. ONLY one group member should submit the group report on behalf of the group. It is your responsibility that all group members contribute equally, that all group members have access to the final submission and that ultimately get access to the tutor feedback you receive for your submission. 5.2. Individual Assignment (60% of mark): Monitoring and implementation (2,000 words) You need to prepare your individual submission on the basis of the group submission. Based on the project outline provided by the client, you need to develop the documents indicated by points 3-5 of Section 5: Risk Management Plan, Quality Management Plan and Implementation Plan. You will work on the individual assignment individually. You may consult with your team members but the final submission needs to be made on an individual basis. The components required will need to be included in a single document. The document needs to be professionally looking, addressed to your client, KnowHow. This document will need to contain the following: • Executive summary (5%) - Briefly introduce the report and summarise its main aspects (e.g., critical risks, significant quality metrics, approach to system release). • Risk Management Plan (30%) - Identify and discuss key risks in this case and provide details of how you will mitigate selected risks that you identify. You need to prepare the Risk Matrix and the Risk Register. You need to justify your decisions on the basis of the information you have been given and the available literature. Section 5.3 includes details with regards to what you need to cover exactly as part of the Risk Management Plan. • Quality Management Plan (15%) - Provide details of quality assurance for the case to ensure that that you maintain quality. You need to use the table provided in the template and include information on quality assurance validation metrics per deliverable, include overhead costs, and an indication regarding the relevant milestone. You need to justify your decisions on the basis of the information you have been given and the available literature. Section 5.4 includes details with regards to what you need to cover exactly as part of the Quality Management Plan. • Implementation Plan (40%) – On the basis of the project brief and with support from the literature discuss how you will implement the project. You need to address the following: o Provide an explanation of the strengths and weakness of the SDLC approach you followed (agile/waterfall). Explain what changes would be needed if you had followed the alternative option. o Justify the release type you chose. o You need to justify your decisions on the basis of the information you have been given and the available literature. Section 5.5 includes details with regards to what you need to cover exactly as part of the Implementation Plan. You need to indicate your group number on the cover sheet of your submission. Make sure that any important decisions you take are clearly presented, discussed and justified and that the report uses clear language (10%). To prepare the above you may want to use a software package such as MS Project, ProjectLibre, Lucidhart etc, or you can produce your content manually (hand written charts and figures). Irrespective of your choices, you need to ensure that everything is readable in your submission as outlined in Practical 1. 6. General Advice • Use the Template for the assignments (section 8 and section 9) • Prepare your report with the word count in mind. You will need to add a cover page: for the group assignment, you will need to include the group number, the student IDs of each team member, and the word count of the submission; for the individual assignment, you will need to include the group number, your student ID and the word count. o If you fail to include the word count, or if the word count is not respected, a penalty is automatically applied (there is a +/- 10% buffer to the word limit). ▪ If your report is well below this word count, it means that it is underdeveloped. If it is well above it, it means that it includes repetitions or that some of the material may be outside the scope of the report. ▪ What’s included in the word count: everything except tables, figures, the cover page, the reference list, and any appendices. ▪ The wordcount shown in the template for the different sections is indicative: you can go up or down as long as the overall wordcount is respected. o If you fail to include the group number for the individual assignment, you will lose 3 marks (this is a pass/fail marking criterion). o If you fail to include the Team Contract for the group assignment, you will lose 3 marks (this is a pass/fail marking criterion). • You need to submit your report by the relevant deadline (see the Blackboard for the deadline). If you don’t submit by the deadline, a penalty is automatically applied. o All penalties (for deadlines, word counts and unfair means) are included in detail in the Student Handbook. o You need to submit via Turnitin – you will need to follow the on screen instructions. When you have finally submitted, you will receive an email notification. If you do not receive the email notification, you have not submitted. You will need to try again. Do not leave your submission until the very last minute because the system may get congested, may be down or the uploading (especially if it is a large file) may finish after the deadline has expired – this will count as late submission! • Make sure your diagrams, images, tables etc. are readable. If these do not comfortably fit within a single page, consider splitting them across 2-3 pages. o For the Gantt chart in particular, consider splitting it up horizontally, NOT VERTICALLY! This could be done phase to phase to ease readability. The tasks need to be seen together with the bars in the calendar view to be considered a Gantt Chart. o For the WBS (and the Gantt Chart) consider placing them on a landscape orientation. • Read the marking criteria carefully – they explain how you will be marked. • Read sections 5 and 6 very carefully – they explain what the report needs to contain and what is the relative weight of each part. Pay attention to the template and follow it diligently. It will guide you and help you make sure you are not missing important parts of the report.
ACFI 202 Session 2024-25 Accounting Theory (ACFI202) Coursework assignment Write an essay (max 2000 words) on the following topic: Discuss the differences between positive and normative accounting theories. Using examples from research and practice (such as IFRS adoption, earnings management, or regulatory changes), critically evaluate how these theories influence financial reporting, corporate decision-making, and standard-setting. Guidance 1. Write clearly and concisely. 2. Provide clear evidence of using academic literature in your coursework. 3. In order to get high marks, you will have to demonstrate that you have undertaken fairly wide-ranging research on the issues raised in the coursework. 4. If possible, use other data and evidence to support your arguments. Submission: 1. You must submit your assignment to Turnitin on CANVAS by midday 12 May 2025. Please see the Assessment section of the CANVAS website for ACFI202. Only online submissions are accepted. 2. Turnitin is a plagiarism and collusion detection system. If you do not submit to Turnitin your work will not be marked. 3. If you are not sure about plagiarism either look carefully into your student handbook or consult your personal tutor or the module leader.
Intelligent Volt/Var Control in Active Distribution Networks In recent years, distributed generations (DG) including renewable energy resources (RESs) have been increasingly integrated into distribution networks. In the conventional VVC, on-load tap changers (OLTC) and capacitor banks (CBs) are responsible for mitigating voltage violations caused by the fluctuation of load power. The penetration of DGs could improve the flexibility and economy of active distribution networks (ADN) but will also pose new challenges to the conventional Volt/Var control (VVC). Especially for RES like solar photovoltaics (PV), the intermittency and uncertainty of PV outputs may cause a sharp fluctuation of feed power, resulting in severe voltage violation problems. In this project, we focus on volt/var control problems and explore potential effective and fast-responding methods to mitigate voltage violations in different timescales. Students are required to submit a final report with runnable Matlab codes. Part 1: Day-Ahead Dispatch with Conventional Volt/Var Control In this part, you are required to implement day-ahead scheduling of OLTCs and CBs to minimize network power loss while maintaining voltage levels within acceptable bounds. 1. Data preparation and model the system: Use at least the IEEE 9-bus distribution network as the testbed. (IEEE 33-bus distribution network is preferred). Determine the capacity, operation parameters and placement of voltage regulation devices according to your specific network topology. 2. Formulate the problem: Define the optimization problem as a mixed-integer second- order cone programming (MISOCP) model. l Minimize the total power loss in the network. l Ensure voltage levels remain within specified limits. l Dist-flow constraints. l Operational constraints of OLTCs and CBs. l …etc. 3. Solve the problem: Use the hourly data (i.e., PV and load predictions) to simulate the day-ahead scenario. Implement the MISOCP formulation using Matlab. You can use any solver that is suitable for your specific optimization problem in Matlab. 4. Deliverables: l The mathematical formulation of your specific optimization problem l Explain the variables, objective function, each constraint in your specific optimization problem in detail. l Provide the Matlab code solving the MISOCP problem. l Demonstrate the results you obtained in figures or tables. Analyze the results (findings) based on the values you obtained. (i.e., voltage profiles before and after optimization and the switching actions of OLTCs and CBs, etc.) Fig. 1. Diagram of the IEEE 33-bus distribution network Part 2: Enhanced Volt/Var Control As discussed, the increasing penetration of DGs, while beneficial for flexibility and economy, introduces challenges due to the intermittent and uncertain nature of resources like solar PVs. Voltage violations resulting from rapid fluctuations in PV outputs require a more dynamic approach than what conventional devices like OLTCs and CBs can provide. In this part, we are going to explore the potential effective and fast-responding methods to mitigate voltage violations in different timescales. 1. At the beginning, please do the literature review on the existing methods for VVC based on the implementation mechanism. (At least five existing research in recent years) 2. What are the limitations of OLTCs and CBs in responding to fast voltage fluctuations? 3. Please provide a candidate approach to coordinate real-time voltage control across different timescales. Explain your idea first, then formulate your problem mathematically. 4. Implement your proposed enhanced methods, and discuss the improvements compared with conventional volt/var control method in part 1. Demonstrate your results in figures or tables. Also, are there any limitations of your proposed solution? 5. Provide the runnable codes.
Cloud Computing Architecture Assignment 2 Creating and deploying Photo Album website onto a simple OCI infrastructure Due date: 9 AM (AEST), Monday of Week 10 Prerequisite requirements: • Successfully completed Assignments 1A and 1B. • Completed all OCI Labs (weeks 7-9) • Knowledge of using OCI Network Security Groups. All supporting materials mentioned in this document can be found in the corresponding assignment page on Canvas. The PHP source code has been provided for this assignment. However, you will need to understand how this code works to be able to modify the missing parts. Each student is supposed to add their own specific information in this code; hence, you must not copy someone else’s code. Objectives This assignment has the following objectives: 1. Create a secure Virtual Cloud Network (VCN) with appropriate subnets, routing tables and security services. 2. Control access to and from your VCN via an Internet Gateway. 3. Modify the provided PHP code to create a website that stores meta-data information about photos uploaded to Object Storage in a MySQL database. The website should enable the user to search for and display photos using meta-data. 4. Deploy and test your PHP web site on an Apache web server running on an virtual machine instance. 5. Add an aditional layer of security by applying a Network Security Group to the web server. 1. Infrastructure deployment You will set up a VCN with the structure and services as illustrated in the diagram below. Figure 1: Architecture Diagram (OCI) NOTE: • All resources must be created in “Assignments_Compartment” compartment • Do not use the default VCN (if any). All services should be in your custom VCN. Below are the detailed requirements for each service. 1.1 - VCN: • Name: [FirstNameInitial][LastName]VCN. For example, if your name is Bill Gates, your VCN would be named “BGatesVCN”. • Region: us-ashburn-1 • Two availability domains each with a private and public subnet with suitable CIDR as specified in the diagram above. • Associate public subnets with a public route table that routes to the Internet Gateway. • Associate private subnets with a private route table. NOTE: due to some incompatibility issues, it is recommended to create your VCN manually (use the “Create VCN” button in VCN tab). Please do NOT use the “Start VCN Wizard” button in OCI dashboard. 1.2 – Network Security Groups Create the following network security groups, each is associated with each tier shown in the architecture diagram: NSG Name Ingress Egress Test-InstanceNSG All traffic from Anywhere ICMP to Public Subnet 2 Web-tierNSG HTTP (80) from Anywhere SSH (22) from Anywhere ICMP from Private Subnet 2 ICMP to Private Subnet 2 TCP (All ports) from Private Subnet 1 Table 1: Network Security Groups NOTE: by default, the “Default Security List” is attached to all subnets in Oracle Cloud. To simplify the process, you can REMOVE all Ingress and Egress rules of this default Security list to make NSG rules effective, for Private Subnet 2 of this assignment. 1.3 – Compute (Virtual machines) You will create two instances, a test instance and a bastion/web server instance. 1.3.1 – Bastion/Web server instance Your web server must be deployed on an instance in Public Subnet 2. This instance should be configured similar to the instance created in Assignment 1: - Machine Image: Oracle-Linux-8 - Instance type: VM.Standard1.1 (1 OCPU, 7GB Memory) OR VM.Standard.E2.1 (1 OCPU, 8GB Memory) OR VM.Standard3.Flex (1 OCPU, 6GB Memory) OR VM.Standard.A1.Flex (1 OCPU, 6GB Memory) - Has Apache web server and other PHP packages installed (bash script provided in the Assignment page). This instance will host the “Photo Album” web application, which was created in Assignment 1 – more details are in Section 2 of this specification document. This instance will also act as a bastion host for you to SSH into the Test instance, which resides in a private subnet. NOTE: [WebServer_public_IP_Address] will change every time the webserver instance restarts. To avoid this behavior. and to ensure your Webserver public IP address remains persistent, add a Reserved Public IP Address to this instance by allocating a Reserved Public IP address in the same region under the Networking/IP Management section. Once the IP address is reserved, go to the WebServer instance details and navigate to “Attached VNICs/IPv4 Addresses”. Click on the 3-dot menu and select “Edit”. In this menu you should be able to Unassign the attached Public IP address first by choosing “No public IP”, update and then selecting the “Reserved public IP”. 1.3.2 – Test instance This instance will be used for demonstration purposes only. It does not contribute to the functionality of Photo Album website. You will SSH into the web server and test its bidirectional/two-way connectivity to this Test instance (using “ping” command in Linux). You must be able to establish a connection (ICMP ping) between this instance and the Bastion/Web server instance that are running in two separate subnets. The configuration of this instance is entirely your choice. This instance does not host the web application. 1.4 – MySQL Database Your database instance must have the following configs: - DB engine version: MySQL 8.0.41 - Type: Standalone (Development or testing) - Shape: MySQL2 (ECPU model) - HeatWave cluster: Disabled - Data Storage Size: 50GB - Automatic Backup: Disabled - Administrator user: admin - Admin password: Oraclecloud@2023 - Resides in private subnet as per architecture diagram NOTE: your database needs to be in a private subnet. Only Public Subnet 2 can access it. However, you need to be able to access your database over the internet so that you can set it up and maintain it. There are several ways to do this. The easiest way is to install phpMyAdmin (a web-based MySQL administration tool) on your web server instance and manage your database through phpMyAdmin’s UI. Instructions on how to do this are in Install_phpMyAdmin_OCI.pdf file. Create a database in your database instance with a table called photosDB that stores meta-data of the photos stored in the object storage bucket. Create a table inside this database that has the following columns: • photo_title (varchar(255) type) • description (varchar(255) type) • creation_date (date type) • keywords (varchar(255) type) • object_reference (varchar(255) type) 1.5 – Security Lists PublicSubnet2SL: To add an additional layer of security to your web server, you have been asked to design and deploy a security list (named “PublicSubnet2SL”) that limits ICMP and other necessary traffic to the associated instance (Bastion/Webserver). This Security List must follow the least-privilege principle. In other words, irrelevant traffic from irrelevant sources must not be allowed. To be specific, the security list: - must ALLOW SSH(22) traffic from anywhere so that you can access the WebServer instance from your computer. - must ALLOW ICMP traffic only from the subnet that contains the Test instance. - must ALLOW other necessary traffic so that the Photo Album website is fully functional for users from anywhere and can access MySQL database. NOTE: default “Security List” is attached to all subnets in Oracle Cloud. Ensure this security list is removed from Public Subnet 2. PrivateSubnet1SL: This security list is applied to the subnet that MySQL database exists. Add the required security list rules to ensure required instances (e.g. Webserver) can successfully communicate with the database in this subnet in a least-privilege access model. NOTE: default “Security List” is attached to all subnets in Oracle Cloud. Ensure this security list is removed from Private Subnet 1. 2. Functional requirements of Photo Album website Your Photo Album website must have the following functional requirements. 2.1 – Photo storage Create an object storage bucket to store your photos. Manually upload some photos onto this bucket that you just created and ensure they have been successfully uploaded. All objects (photos) in this bucket must become publicly available. This can be done via OCI management console, changing the buckets visibility settings. NOTE: marks will be deducted if the bucket objects have been individually configured to be publicly available. 2.2 – Photo meta-data in MySQL Database The meta-data of the photos stored in the S3 bucket is stored in a database table, which has been created in Section 1.4. You need to populate the table with a few records. Below is an example of a record: - Photo title: Swinburne Logo - Description: Logo of Swinburne uni - Creation date: 2021-08-09 - Keywords: logo, university - Object Ref/URL: https://photo-bucket.oraclecloud.com/swinburnelogo.jpg NOTE: Object URL = Pre-Authenticated Request, generated by OCI storage bucket. 2.3 – Photo Album website functionality The website must be able to list all the photos (stored in the bucket) along with their meta-data (stored in the database). The full source code has been provided to you (photoalbum_OCI_v3.0.zip). Modify the constants.php file in the provided code (carefully read the comments in the file) using available information from the storage bucket and MySQL database that you created in the previous steps. NOTE: in constants.php file, variables/names that you add must not include space. You may use underscore “_” instead of space. Examples: define('DB_PHOTO_CREATIONDATE_COL_NAME', 'creationdate'); define('DB_PHOTO_KEYWORDS_COL_NAME', 'keywords_column'); The website should be accessible through http://[WebServer_Public_IP_Address]/cos80001/photoalbum/album.php if the directory structure in your web server is correctly created. Testing Manually upload several photos to the storage bucket and insert their meta-data into the database. Thoroughly test to make sure the photos and their meta-data are correctly displayed. Ensure the Security List satisfies the additional security requirement, by login into the Test instance (e.g. via SSH) and run a ping to the web server’s IP address. Submission Make sure your website is functional from the due date - check you can start the web server instance and stop it. (No need to start the Test instance). Submission is a single PDF document to Canvas. No demonstration is required. The document must contain the following: 1. A single PDF document, maximum 15 pages, in IEEE Conference Style in either one or two column mode submitted to Canvas by the due date. 2. Title page with your name, student ID, and tutorial class. 3. URL of the album.php pages on your EC2 so your marker can view your website from their browser using the URL that you have provided (Reserved Public IP address to be used). 4. If you have not created an instructor user in previous weeks, refer to week 8 lab instrucitons and ensure you have finished the lab, provided IAM admin user and the account details (account/tenancy name) to your tutor for marking purposes. 5. Well formatted Screenshot(s) of the data records in your database. 6. Well formatted Screenshot(s) of Linux terminal showing you have been able to ping the Web server Instance from your Test instance, or vice versa. 7. Well formated screenshot(s) and a brief explanation for each step that you have taken, problems that you faced and achievements during your deployment for this assignment. • Route tables with their route rules and associated subnets • MySQL Database configurations/settings • Security List Rules • Network Security Group Rules 8. Each screenshot must have your OCI Management Console username/student ID visible. 9. All screenshots must: • Have a Caption (e.g. Figure 2: MySQL table) • Be readable (reasonably high quality) NOTE: This assignment is to be completed in your free-tier OCI account, which is accessible through Oracle Cloud Login page. For further information of how to access this environment please refer to your Swinburne Canvas Page “Accessing OCI Resources”. This environment comes with $300 USD credits. It is your responsibility to use and manage this credit correctly to ensure there will be enough remaining credits for all assignments. Marks will be deducted if your assignment resources are not accessible due to insufficient credits.
MES104TC-2425-S2 Integrated Circuits Design and Fabrication Assignment Note: Coursework 2 is based on an assignment and contributes to 15% of the final marks, with a total of 100 marks allocated for this coursework. Question 1 (50 marks) 1. A PN junction diode has a concentration of 1016 acceptor atoms cm-3 on thep-side and a concentration of 1017 donor atoms cm-3 on the n-side. What will be the built- in potential for the semiconductor materials Ge, Si, InP, and GaAs? (10 marks) 2. Consider a p+n junction, which has a heavily doped p-side relative to the n-side, that is, Na ≫ Nd. Since the amount of charge Q on both sides of the metallurgical junction must be the same (so that the junction is overall neutral) Q = eNa Wp = eNd Wn it is clear that the depletion region essentially extends into the n-side. When Nd ≪ Na, the depletion region width (W0) is What is the depletion width for a pn junction Si diode that has been doped with 1018 acceptor atoms cm-3 on thep-side and 1016 donor atoms cm-3 on the n-side? (10 marks) 3. The capacitance (C) of a reverse-biased abrupt Sip+n junction has been measured as a function of the reverse bias voltage, Vr, as listed in the Table 1. The pn junction cross-sectional area is 500 μm × 500 μm. By plotting 1/C2 versus Vr, obtain the built-in potential, Vo, and the donor concentration, Nd, in the n-region. What is Na ? (10 marks) Table 1. Capacitance at various values of reverse bias (Vr) Vr (V) 1 2 3 5 10 15 20 C (pF) 38.3 30.7 26.4 21.3 15.6 12.9 11.3 4. Consider an idealized silicon npn bipolar transistor with the properties listed in the Table 2. Assume uniform doping in each region. The emitter and base widths are between metallurgical junctions (not neutral regions). The cross-sectional area is 100 μm × 100 μm. The transistor is biased to operate in the normal active mode. The base-emitter forward bias voltage is 0.6 V and the reverse bias base-collector voltage is 18 V. (20 marks) Table 2. Properties of an npn BJT Emitter width Emitter doping Hole lifetime in Emitter Base width Base doping Electron lifetime in Base Collector doping 10 μm 2×1018 cm-3 10 ns 4 μm 1×1016 cm-3 400 ns 1 × 1016 cm-3 Calculate the depletion layer width extending from the collector into the base and also from the emitter into the base. What is the width of the neutral base region? Question 2 (50 marks) 1. You are in charge of a CMOS fabrication line and you have a problem because the thresholds of your n-and p-channel MOSFETs, which are supposed to be +1 V and -1 V, respectively, are turning out to be +3 V and +1 V, instead. You suspect that the interface between the silicon and the 20 nm thick oxide is contaminated with ions. (a) What type of device is each transistor, enhancement mode (no channel when vGS = 0) or depletion mode (strongly inverted when vGS = 0)? Explain your answers. (10 marks) • n-channel MOSFET: Because: • p-channel MOSFET: Because: (b) If you are right about the ions being the problem, what sign must they have, positive or negative. Explain your answer. (10 marks) 2. These questions concern the low frequency linear equivalent circuits of MOSFETs. (a) Consider the n-channel MOSFET circuit pictured to the right. The circuit is biased with VAC = 2 Volts. The MOSFET has following parameters: (15 marks) • K = 2 mA/V2 • VT = 1V • α = 1 • λ = 0.01 V-1 • η = 0.2 A small signal voltage, vac(t), is added to the 2 V bias so now vAC(t) = 2 V + vac(t). First find the bias and small signal values of vGS, vDS, and vBS, and then draw a single element small signal linear equivalent circuit for this connection and give an expression for this element in terms of gm and go . VGS: VBS: VDS: vgs: vds: vbs: Linear equivalent circuit: (b) Consider two MOSFETs, one an n-channel MOSFET and the other a p-channel MOSFET. They have identical dimensions, and both are biased in saturation at the same drain current, |ID |. Which of the devices, if either, would have the larger transconductance, gm? Choose one and explain your answers. (15 marks) n-channel ________; p-channel_______; they are similar________ Because:
MTH1030/MTH1035: Project 2, 2025 From counting the number of banana trees (again!) to calculating the digits of π The same rules as for Project 1 apply! Also, as with Project 1, we will begin work on each of the four parts of this project during the seminars. You will then complete the remaining puzzles at home and write up your solutions in your own words. As always, perform. all calculations using Mathematica. 1 Banana trees vs. tree bananas (25 Marks) Remember the strange bananas from Project 1? Instead of growing on trees, there are trees growing in these bananas! As you showed in Project 1, just like the Fibonacci sequence, the banana tree number sequence b2 = 3, b3 = 8, b4 = 21, b5 = 55, . . . satisfies a simple recursion relation. a) (15 marks) Using this recursion relation, replicate all the steps in Part 4 of the Week 6 lesson quiz (the Fibonacci interlude) to calculate and explain a closed-form. counterpart of Binet’s formula for the banana tree numbers! In other words, derive an elementary function B such that bn = B(n), for n = 2, 3, 4, . . .. b) (5 marks) Find two numbers, e and f, such that bn is always equal to e f n rounded to the nearest integer. Justify your choice of numbers. c) (5 marks) Use Binet’s formula and the formula you derived in part (a) to prove that bn = f2n, where fn is the nth Fibonacci number. 2 Ranking the Arcane Manuscripts (25 marks) In the mystical realm of Arcanum, ancient manuscripts hold the secrets of untold power and wisdom. The royal archivists have discovered that these manuscripts, much like modern webpages, are interlinked by enchanted sigils (hyperlink references) that determine their prominence within the vast Library of Shadows. In a miniature model of this magical network, there are eight manuscripts. An arrow from manuscript. j to manuscript. i indicates that manuscript. j cites or refers to manuscript. i. Part of the entrance exam for junior archivists is to rank these manuscripts; that is, to determine which is the most prominent, which is the second most prominent, and so on—thus proving one’s mastery over the arcane ranking arts. The art of ranking these manuscripts involves magical mathematics based on the following principles: 1. The more manuscripts that reference a given manuscript, the higher its rank should be. 2. A reference coming from a manuscript. of low renown should contribute less to the rank than one from a manuscript. of high renown. 3. A manuscript. that cites many others should contribute less to the rank of those it references than a manuscript. that cites only a few. We begin by encoding our miniature enchanted network in the form. of an adjacency matrix A. In this matrix, if manuscript. i is referenced by manuscript. j, then the (i, j)th entry is 1; otherwise, it is 0. Since there are eight manuscripts, A is an 8 × 8 matrix. (a) (5 marks) Below is a partially completed version of the adjacency matrix: Complete this matrix. (Hint: Verify your answer carefully—everything else that follows depends on you getting this matrix right.) (b) (4 marks) Again, the first principle says:“The more manuscripts that reference a given manuscript, the higher its rank should be.” The numbers of times that manuscript. i is referenced are given by the entries in the ith row of A. Therefore, if we just use this first principle and neglect the other two, it would make sense to define the rank of manuscript. i to be: Let r be the vector whose ith entry is ri . We can then express these equations in matrix form. as r = As. Calculate r and, based on it, propose a first, rough ranking for the eight manuscripts. Find the vector s such that this matrix equation holds. (c) (4 marks) The second principle refines our ranking: a reference from a low-ranked manuscript. should count less. Thus, taking into account both the first and second principle, we refine the ranking definition to: In matrix notation, this becomes r = Ar. This equation implies that r is an eigenvector of A with eigenvalue 1. However, for this to make sense it is necessary that A indeed has 1 as one of its eigenvalues. Check this by calculating the eigenvalues of A and recording them in your answer. Although the result you obtain may seem discouraging, the quest continues. (d) (4 marks) The third property further refines the ranking: a manuscript. with many citations should contribute less influence per citation than one with fewer citations. To incorporate this third property into our ranking calculations we have to adjust the matrix A. The number of manuscripts that manuscript. i cites is just the sum of the entries in the ith column of A. To ensure that manuscripts with numerous citations contribute less per link, we normalize the matrix A by dividing each entry in column i by the sum of the entries in this column. This yields a new matrix D. Calculate the matrix D. (Check that the determinant of your D is −144/1 before proceeding.) (e) (4 marks) We arrive at our final ranking by replacing A with D in our last ranking formala, leading to: or equivalently, r = Dr. Thus, r is now an eigenvector of D corresponding to the eigenvalue 1. Since D is a so-called Markov matrix, we are guaranteed that 1 is an eigenvalue and that there exists a unique eigenvector (up to scaling) with nonnegative entries. So, find all eigenvalues of D and determine an eigenvector corresponding to the eigenvalue 1 whose entries sum to 1. Use this eigenvector to rank the manuscripts in our mini enchanted network. (f) (4 marks) Finally, envision replacing our mini enchanted network with the vast, sprawling Web of Wisdom—the World Wide Web itself. Although the same mathematical principles apply, additional challenges emerge when scaling up to such an immense network. Re-examine part d) and identify one problem that is bound to occur and that will (at least to start with) get in the way of constructing the matrix D. Can you think of an additional potential problem that may arise when we try to unleash our ranking strategy on other webs of wisdom? Hint: Have another close look at part e). Final Remarks 1. The challenges identified in part (f) can be surmounted with relatively straightforward modifications. 2. There are two insightful interpretations of the Markov process underlying D. One interpretation envisions countless seekers of knowledge, each randomly traversing the labyrinthine Web; after a long time, the distribution of these seekers approximates our final ranking vector. The other views it as a solitary wanderer whose long-term visitation frequencies reflect the relative importance of each manuscript. 3. Techniques similar to those described here are also employed to generate rankings in other domains, such as competitive sports. 3 Cursed L’Hˆopitals (15 marks) Deep within the hallowed halls of the Arcane University of Arcanum, the great wizards debate the mysteries of limits and indeterminate forms. a) (5 marks) One such enigma is the notorious form—a riddle that appears when we ponder f(x) g(x) where f(x) is a function that dwindles to 0 as x approaches a mysterious point a, while a companion function g(x) soars unboundedly to infinity. In precise terms, we examine the limit with the following properties: 1. f(x) = 0; 2. g(x) = ∞; 3. 0 ≤ f(x) (and, strictly speaking, f(x) > 0 for all x sufficiently near a for which g(x) is defined) so that the power is always meaningful. The ancient scrolls ask: Is 0∞ truly an indeterminate form? If you believe it is, conjure up dif-ferent functions f(x) and g(x) (satisfying properties 1–3) for which the limit limx→a f(x) g(x) takes on different values. Otherwise, provide a convincing argument that 0∞ is not indeter-minate in this context. b) (5 marks) The sages have also uncovered a curious incantation: You don’t have to show this! To test your numerical magic, approximate this limit by substituting x = 0.1, 0.01, 0.001, . . . , 10−10 into the expression First, use your favored Arcane Spell Calculator (ASC), then confirm your results with Math-ematica. Record your findings in a table and explain the value of this numerical experiment for any budding Arcanum mathematician. c) (5 marks) is an indeterminate form. of type . Show that applying l’Hˆopital’s rule to this indeterminate form. by differentiating both numerator and denominator does not help with finding this limit. Does the limit exist regardless, and if so what is it? May your computations be ever precise, and may the wisdom of L’Hˆopital illuminate your path! 4 Calculating the Sacred Digits of π (35 marks) In the ancient realm of Arcanum, the value of π is more than a mere number—it is a key to unlocking the deepest secrets of magic and the universe. The wise mages have long known that approximating such elusive constants as π, e, or sin(1) requires both mathematical prowess and mystical insight. The very devices that compute these values, from enchanted calculators to the great spellbooks of Mathematica, are built upon these arcane principles. One of the most wondrous incantations for expressing π is the Leibniz formula, attributed to the legendary sage Gottfried Wilhelm Leibniz (though its origins reach even further back into the lore of Madhava of Sangamagrama). The spell is given by: Alas, this series converges as slowly as a snail trudging through enchanted marshes. Let the following tasks guide you through the mystical challenge of finding miraculously good approximations of π using infinite series. a) (5 marks) Let an and Sn denote the nth term and the nth partial sum of the Leibniz series, respectively. Just in case you are wondering: a1 = 4. Your first task is to determine the smallest integer n such that |π − Sn| < 0.0001. To do so, you should derive an expression for an, write Sn using the Mathematica command Sum, and employ trial and error to pinpoint the smallest such n. As you will see, you need to add thousands of terms of the series to get an approximation of π as good as 3.1415. That’s pretty terrible!!! In 1706 the first 100 digits of π were calculated for the first time. Let’s say you are the crazy person who got it into their head to perform. this incredible task at that time and you want to use the Leibniz series for this task. Of course you know that by adding up enough terms of our series you will eventually achieve your aim, but how many terms will it take? And isn’t there some way to accelerate the convergence of this “snail” series? As we have seen, without already knowing the sum of a convergent infinite series it is usually quite tricky to figure out how many terms need to be added to be able to guarantee that the partial sum generated like this coincides with the true sum in a given large number of digits. However, for certain series like, for example, the Leibniz series it is a very easy to get a pretty good estimate as follows. As you can easily check the Leibniz series has the following two properties: 1. The terms alternate between being positive and negative numbers. This makes our series into an alternating series; 2. the absolute values of the terms are decreasing; 3. the terms have the limit 0. Now it is quite easy to show (you don’t have to do this) that any series that has these three properties has a finite sum, let’s call it S, and that |S − Sn| < |an+1|. This result is known as the alternating series remainder estimate. b) (5 marks) Find the smallest m such that |am+1| < 0.0001 in the case of the Leibniz series. The alternating series remainder estimate guarantees that for the m you just found |π −Sm| is also less than 0.0001. Now the m you found here is larger than the precise figure n that we found in a) and so is less useful. However, unlike n which was only accessible using Mathematica and using a good approximation of the true value of π built into Mathematica (we were using what we want to find which is cheating!), it is trivial to calculate m even without a computer. Also m gives you a good enough idea about what magnitude problem you are facing. Both results of a) and b) tell you that the straightforward approach of simply adding more and more terms of our series (by hand) will not get you the first 100 digits of π within your life-time. Luckily you have a really smart idea. From calculus we know that the Leibniz formula results when we set x = 1 in the Maclaurin series Substituting any positive number x < 1 into this identity will result in an alternating series on the right that converges much much faster than the one for x = 1 because of those powers of x becoming very tiny very quickly. Now the idea is to express π/4 in terms of a few numbers of the form. tan−1 (A) and then com-bine the corresponding series into a rapidly converging series that can be used to approximate π much more efficiently than if we used the Leibniz series. Okay, here we go. c) (10 marks) Let α = tan−1 (1/5). Using the addition formula show that Show that the last equation implies or d) (5 marks) Using Mathematica calculate an approximation of π by substituting the 3rd partial sums of the series corresponding to tan−1 (1/5) and tan−1 (1/239) for these numbers in the expression on the right. How many correct digits of π do you get this way (counting the 3 at the start as the first digit)? Pretty spectacular, right? e) (5 marks) Now for the real (1706) deal. Estimate using the alternating series remainder estimate how many terms of the two series you will need to add to calculate those precious first 100 digits of π. In doing so keep the following in mind. The series for tan−1 (1/239) converges much, much faster than that for tan−1 (1/5). This means that to guarantee 100 digits of π using this approach we want to find an n as small as possible such that (n + 1)st term of the series for 16 tan−1 (1/5) is less than 10−102. We use 10−102 instead of 10−100 just to be reasonably certain that carries won’t mess up things. Your answers to parts a) through e) will demonstrate whether the ancient incantations are potent enough to reveal the hidden, sacred digits of π—a key that unlocks the treasure trove of infinite wisdom in Arcanum.
ECMT1020 Introduction to Econometrics Semester 1, 2025 Group Assignment Due: 11.59pm Friday 23 May 2024 Instructions 1. This group assignment counts for 10% of your final grade. You may form. a group with any student enrolled in this unit (not necessarily from your tutorial), with a maximum group size of two. The assignment will be marked based on the final group submission, and group members will receive the same mark. 2. Once you have formed a group, make sure to register your group on Canvas (instruc-tions are provided on this Canvas page). Only one group member needs to submit the assignment on behalf of the group. Individual submissions are also permitted. If you complete the assignment on your own, there is no need to join a group on Canvas. 3. The assignment consists of 12 questions and is worth a total of 40 marks. Marks allocated to each question are indicated. You are expected to attempt all questions. 4. The dataset assigned to your group is provided in the Excel file EAWE#.xlsx, where # corresponds to the last digit of the sum of the last digits of the University of Sydney SIDs of your group members. For example, if student A and student B form. a group, and student A’s SID ends in 3 and student B’s SID ends in 8, then 3 + 8 = 11, and the last digit of 11 is 1. Therefore, this group should use dataset EAWE1.xlsx. 5. You must use your assigned dataset to answer the questions. Clearly indicate your dataset number and the SIDs of both group members on the front page of your submission. Use of the incorrect dataset may be treated as a case of Academic Dishonesty. 6. Round all numerical answers to three decimal places if applicable. When asked to “report the estimation results”, include both the relevant Stata commands and output tables in your answer (you may insert the screenshots into your document). A separate Stata do-file is not required. 7. Your answers must be typed—handwritten submissions will not be accepted. En-sure your answers are clear and concise. Lengthy responses that lack focus or understanding will be penalized. 8. Submit a single pdf file named EAWE# SID1 SID2.pdf where # is your assigned dataset number, and SID1 and SID2 are the 9-digit SIDs of the group members. Do not include your names or a cover sheet. 9. The submission is via a file upload under the Canvas module “Assignment”. You may submit up to two times, and only the most recent submission will be counted. Late submission will incur a penalty of 5% of the total 40 marks (i.e., 2 marks) per calendar day. Submissions more than 10 calendar days late will receive a mark of zero. These rules follow Section 7A of the University Assessment Procedures 2011. 10. Regarding the use of AI tools: I will not impose unenforceable restrictions. You are permitted to use AI to assist with this assignment; however, you must clearly declare any such use and explain how it contributed to your work. Questions 1. (3 marks) Create the following two scatter plots using the variables in your dataset: (i) EARNINGS (hourly earning in dollars) on the y-axis and S (education: years of schooling) on the x-axis. (ii) EARNINGS (hourly earning in dollars) on the y-axis and EXP (work experi-ence: years spent working after leaving full-time education) on the x-axis. Ensure that each plot includes clearly labeled axes. What are the observed values of S in your dataset? 2. (2 marks) Estimate a regression model with EARNINGS as the dependent variable and EXP as the only explanatory variable. Report the estimation results and write down the fitted regression equation. 3. (5 marks) Is the slope coefficient in the fitted model from Question 2 significantly different from zero at the 10% significance level? Explain how you can reach your conclusion based on the regression output. In your explanation, clearly state the null and alternative hypotheses, and describe the three ways to make your decision based on (i) the test statistic, (ii) the p-value of the test, or (iii) the confidence interval for the slope coefficient. 4. (4 marks) What are the confidence intervals for the intercept and slope coefficients in your regression output from Question 2? Explain how these confidence intervals are constructed. What are the center values of these confidence intervals? 5. (4 marks) Estimate another regression model with EARNINGS as the dependent variable and both EXP and S as the explanatory variables. Report the estima-tion results and write down the fitted regression equation. Carefully interpret the estimated intercept and slope coefficients. 6. (3 marks) Is the slope coefficient on EXP in the fitted model from Question 2 smaller or larger than the slope coefficient on EXP in the fitted model from Question 5? Provide a reasonable explanation for this difference. 7. (4 marks) What are the sample means of S and EXP in your dataset? Define two new variables, SDEV and EXPDEV, as deviations of S and EXP from their respective sample means: SDEV = S − S and EXPDEV = EXP − EXP. Estimate a regression model with EARNINGS as the dependent variable and both EXPDEV and SDEV as explanatory variables. Report the estimation results and write down the fitted regression equation. Interpret the estimated slope coefficients. 8. (2 marks) How does the regression with “demeaned” explanatory variables in Ques-tion 7 improve the interpretation of the fitted intercept compared to the regression in Question 5? 9. (3 marks) The variable TENURE in your dataset represents the number of years an individual has spent working with the current employer. Define a new variable PREVEXP = EXP − TENURE to represent prior work experience with previous employers. Also, define LGEARN as the natural logarithm of EARNINGS. Estimate a regression model with LGEARN as the dependent variable and PREVEXP, TENURE, and S as explanatory vari-ables. Report the estimation results and interpret each of the three slope coefficients. 10. (2 marks) What would happen if you include the variable EXP in the regression model from Question 9? Explain why this happens. 11. (2 marks) Based on the fitted relationship between LGEARN and the explanatory variables in Question 9, derive the corresponding fitted relationship between the original dependent variable EARNINGS and the variables PREVEXP, TENURE and S. 12. (6 marks) In your dataset, the variable HOURS represents the number of hours worked per week (a proxy for labor supply) and MARRIED is a dummy variable which takes value 1 if the individual is married, and 0 otherwise. Estimate the following regression model: LGHOURS = β1 + β2LGEARN + β3(MARRIED × LGEARN) + β4S + β5EXP + u, where LGHOURS is the natural logarithm of HOURS, and the other variables are as previously defined. Report the estimation results and carefully interpret the estimates of β2 and β3. Additionally, write out the fitted relationships between HOURS and the variables EARNINGS, S, and EXP separately for married and unmarried individuals.
COMP 272 Data Structures and Algorithms Sample Final Examination (Rev. 8) Instructions to the student: 1. You will be allowed three (3) hours to complete the examination. 2. This is an online and closed-book examination. Only materials distributed with this examination may be used by the student to answer examination questions. You are NOT allowed to use textbooks, workbooks, notes, tapes, cell phones, hand-held computers or laptop computers, other electronic/digital devices, or to consult with other people while writing this examination. 3. This examination has four parts and the structure of the examination is detailed below. • Part 1 (40%): Multiple-choice questions (20 questions, 2 marks each) • Part 2 (35%): Fill in the blanks (10 blanks, 3.5 marks each) • Part 3 (15%): Short answer questions (3 questions, 5 marks each) • Part 4 (10%): Programming question (1 question, 10 marks) 4. To answer a multiple-choice question, choose the letter corresponding to the best alternative provided. There is no penalty for guessing so you should attempt every question even though you may not be certain of the answer. If you choose more than one alternative, the answer will be marked wrong – except those problems where it is explicitly indicated otherwise. 5. Note that one of the requirements for obtaining three credits in Computer Science 272 is that you MUST score at least 50% (50 marks) in this examination. 6. Legibility is important; an examination that cannot be read cannot be graded. 7. Complete the information requested on the Final Grade Report included in your examination package. Part 1: Multiple-choice questions (20 questions, 2 marks each) 1. Which of the following traversals yields BADEC? A / B C / D E a. only in-order b. only level order c. only post-order d. only pre-order e. pre-order and level order f. in-order and level order g. none of the above 2. Which of the following is a post-order traversal ofthe BST? a. ACEDB b. ABDCE c. BDECA d. EDCBA e. BADCE f. BADEC g. one of the above 3. Given current (a reference to a list node), which statement may insert an item x correctly after the node referenced by current? a. current = new ListNode( x, current ); b. current.next = new ListNode( x, current.next ); c. current.next() = new ListNode( x, current ); d. current.next() = new ListNode( x, current.next ); e. current = new ListNode( x, current.next ); f. current.next = new ListNode( x, current ); g. none of the above 4. Two sorting algorithms whose worst-case running times are in O(n log n) are a. merge-sort, Shellsort b. heap-sort, quicksort c. heap-sort, Shellsort d. insertion sort, merge-sort e. heap-sort, merge-sort f. merge-sort, quicksort g. none of the above 5. The subarray of length 7 shown below is about to be partitioned by quicksort. 6 8 4 5 3 1 7 The pivot is selected by the “safe choice”; that is, it will be the middle element, 5. The pivot is then swapped with the last element, 7, and partitioning starts. At the end of partitioning, the pivot is swapped into place. At this point the state of the subarray is a. 1 3 4 5 6 8 7 b. 1 3 4 5 8 6 7 c. 1 4 3 5 6 8 7 d. 1 4 3 5 8 6 7 e. 1 3 4 5 6 7 8 f. 1 3 4 5 7 6 8 g. none of the above 6. Recursion is sometimes preferred to iteration because it a. is generally faster than iteration. b. requires less memory space. c. is based on proof by contradiction. d. may increase the complexity of the solution. e. is rooted in transfinite induction. f. is based on the pigeonhole principle. g. none of the above 7. Linked lists are often implemented with a dummy header node to a. reduce the execution time of the list operations. b. fulfill the specifications ofthe list ADT. c. identify the beginning of the list. d. be able to access the first element in Q (1) time. e. reduce code complexity. f. save memory space. g. none of the above 8. When an unordered list of n keys is searched sequentially for given key values, the average number of key comparisons made by an unsuccessful search is a. n b. log n c. n/2 d. n log n e. n + n2 f. n2 log n 9. Which data structure would you use in writing a program to check for balanced parentheses? a. binary search tree b. hash table c. priority queue d. queue e. stack f. list g. none of the above 10. Which of the following functions is not O(log(N))? a. log ( log( N ) ) b. 1000 + log( N ) c. 1000 log( N ) d. log( 1000 N ) e. log( N2 ) f. 1000 log( 1000 N1000 ) g. all of the above are O(log(N)) 11. And ten more questions in Part 1 on the final examination. … Part 2: Fill the blank questions (10 blanks, 3.5 marks each) 21. Given data structure D that represents connected nodes N1, N2, and N3 shown in the (real) examination question. Write pseudo-code in (blank 1) to implement the function of changing the connection between given nodes N1, N2, and N3. The running time of the function is (blank 2) 22. Given a stack of integers, S, a queue of integers, Q, and the following a series of stack and queue operations. S.push(11); S.push(12); S.push(36); S.add(); Q.enqueue(S.pop()); Q.enqueue(S.pop()); Q.enqueue(25); Q.mult(); Method add() pops the stack twice and pushes the sum of the two popped items back onto the stack. Method mult() dequeues two elements from the queue and enqueues their product in the same queue. If initially S and Q are empty, then after the above sequence of messages the content of queue Q (in front-to-rear order of the queue elements) is (blank 3) 23. And eight more questions in Part 2. Part 3: Short-answer questions (3 questions, 5 marks each) 31. Explain the concept of binary search tree. 32. And two other concept-related questions Part 4: Programming question (10 marks) 34. Describe, in pseudo-code, an algorithm for finding a node with a specific data value in a given data structure type by means of a given traversal method starting from a specific node. Please note, your real examination question will provide specific data values, data structure (type), required traversal method, and a specific node to be searched based on the algorithm you will implement in pseudo-code.
Project 3: Graph modeling and graph algorithmsCOT 4400, Spring 2025Due May 7, 20251 OverviewThis project requires you to model the problem below as graph and then use a known graphalgorithm to solve the problem. You are not allowed to use the internet or consult anyreferences. This is an individual project. This policy will be strictly enforced.This problem is based on the “Jumping Jim” maze problem (from “MAD MAZES: IntriguingMind Twisters for Puzzle Buffs, Game Nuts and Other Smart People” by Robert Abbott). Thetext of the problem is quoted below. A diagram of the maze is provided on the next page.Jumping Jim is about to begin his grand performance at the circus, but his jealous en emy, Dastardly Dan, has restrung all the trampolines. The number on each trampolineindicates how tightly strung each one is; in other words, the number indicates how farJim will have to move (horizontally or vertically, but NOT diagonally) when he bouncesoff the trampoline. Jim begins his routine by leaping onto the trampoline at the upperleft. He must get to the Goal at the lower right, where he will take his bow. How canhe get there?The diagram shows all of the trampolines with each represented as a square. Beginon the square at the upper left. That square is marked 3. From there you could, forexample, move three squares down to a square marked 2. From there, you might movetwo squares right to a square marked 4, and from there you could move four squaresright to another square marked 2. That path, incidentally, won’t get you to the goal.12 Modeling the problemBefore you write a program to solve this problem, you will first write a report describing (in Englishand pseudocode) how you will solve this problem. This report should answer two basic questions:1. What type of graph would you use to model the problem input (detailed in the Section 3.1),and how would you construct this graph? (I.e., what do the vertices, edges, etc., correspondto?) Be specific here; we discussed a number of different types of graphs in class.2. What algorithm will you use to solve the problem? Be sure to describe not just the generalalgorithm you will use, but how you will identify the sequence of moves Jim must take inorder to reach the goal.3 Coding your solutionIn addition to the report, you should implement your algorithm in C++ or Java so that it can solve“Jumping Jim” mazes. Your code may be in C++ or Java.Your code may be split into any number of files. In addition, you are allowed to make use ofany built-in library, and C++ users may use the Boost library in their implementations. Boost isa free, open-source library with a rich collection of mathematical functions, including several thatdeal with graphs. You may read more about Boost at www.boost.org.3.1 Input formatYour program should read its input from the file input.txt, in the following format. The inputbegins with a two positive integers on a line indicating the number of rows r and columns c ofthe maze, respectively. The next r lines detail all of the trampolines in the maze. Each line has cintegers, where each integer represents the number of spaces Jim will move when landing on thattrampoline. The goal square will always be in the lower right of the maze.For the original “Jumping Jim” maze, the input is:7 73 6 4 3 2 4 32 1 2 3 2 5 22 3 4 3 4 2 32 4 4 3 4 2 24 5 1 3 2 5 44 3 2 2 4 5 62 5 2 5 6 1 03.2 Output formatYour program should write its output to the file output.txt, in the following format. The outputshould consist of a path from the top left square to the bottom right square. It should be a singleline consisting of a sequence of moves, separated by spaces, where each move is a single letterrepresenting the direction of that move: N, E, S, or W. Of course, the sequence of moves describedin the file must solve the maze described in the input.3For example, if your first three moves take you 3 spaces right, 3 spaces down, and 2 spaces right,your output should begin with E S E.You are welcome to try figuring out the solution to the “Jumping Jim” puzzle on your own, butthat won’t get you any points. Your assignment is to model the maze as a graph and to solve theproblem using an appropriate graph algorithm.4 SubmissionYou must submit a zip archive containing 1) your report (described in Section 2) as a PDF doc ument, 2) your code (described in Section 3), and 3) a README file describing how to compileand run your code to Canvas. If your code is in Java, the main function should be located inJumpingJim.java. If your code requires more than a simple command to compile and run thenyou must also provide a Makefile and/or shell script. A simple command might be something like:g++ *.cpp -o jumpingjimor:javac *.javajava JumpingJimIf you are using Boost in your solution, you must provide a Makefile and/or shell script thatuses the environment variable $BOOST_HOME (pointing to the Boost installation directory) to compileyour code.As this is an individual project, your project report and code will be checked for plagiarism.5 GradingReport 50 pointsGraph model 30Algorithm description 20Code 50 pointsREADME file 5Follows input and output specs 10Compiles and is correct 30Good coding style 5Note: if your code is unreasonably slow, you will lose points for both your algorithm design andyour correct output grade.4
Programme: MSc Financial Technology Module: BUSI4620 Data Analytics and Machine Learning for FinTech Coursework 2 The deadline for submission of the coursework is 3 pm on Thursday 8th May 2025. The coursework is 3,000 words of your writings with a ±10% tolerance. Appendices, codes, and the outputs of codes are not in the word count. Submit all of your writings, codes, and the outputs of codes on one single file: a Word document, or a PDF file from a Word document, or a PDF file that is printed/exported from a Jupyter Notebook. Do not submit a Jupyter Notebook. Requirements: You should use Python and the libraries taught in the module to solve the questions. Choose your parameter values or keep default parameters in the Python library. You can use other Python libraries IN ADDITION TO what we covered in the module, but not some libraries to REPLACE what we have learned. Similarly, you can use some additional data that are not in the coursework requirements. These additional libraries and additional data are not compulsory. Students cannot use the operations from other languages/software/tools such as Stata, R, Matlab, Excel, etc. as the answers. Tasks: The following questions require the attached dataset "EM.csv", which is the credit status and characteristics of some firms in the UK. Do an EDA analysis of any three features that you choose. Present tables/figures and your discussions. You must create a new feature 'CreditLevel', which is 1 (or 0) for the firms with 'Creditscore' higher (or lower) than the mean of 'Creditscore'. Drop 'Creditscore' and ‘Previouscreditscore’. The 'CreditLevel' should be the target variable 'Y’, and the remaining numerical data are 'X' in all of the models. Make data preprocessing when it is necessary as follows: keeping numerical data; filling missing values by feature means; doing StandardScaler to X. Use three machine learning classification methods to predict 'CreditLevel', where one of them should be able to produce feature importance. Using each method, complete the following tasks: Run a cross-validation to calculate the mean and standard deviation of the accuracy; Predict the target based on your X_test data; Use the test set to obtain a classification report; Draw a plot of the confusion matrix and a ROC plot. Present an evaluation of these methods based on the outputs. Using one method that can produce feature importance, draw a plot of feature importance. Choose one of the assumptions: Machine learning can/cannot predict the credit status of the data. Provide interpretation and debate based on your results and your selected literature. Find and link your discussions to one or several sources in terms of the following qualitative forms: texts (news/posts/papers), audio, or video recordings online. Cite references. You can use the references provided by the module or the references found by you, or a mix of both sources of references. Marking scheme: see the marking rubric. This is an open-question coursework. There is no ‘correct or wrong’ answer. You can choose either assumption as long as that you support it with reasonable arguments and evidence. It is acceptable if the performance of your machine learning (precision, accuracy etc.) is not high. Guidance: All of the above data operations are shown in the examples of Jupyter Notebooks on Moodle for our lessons. You can copy these codes to do your coursework. Be aware of different names of variables/methods/instances/dataframes/parameters etc. when you re-use the codes. About Harvard style. references, there are a few formats. It is acceptable to follow one of them as long as you keep your reference format consistent in your coursework. The document lists the minimum compulsory requirements. Except for the above requirements, students can carry out other relevant ideas on their own. EXTENSIONS The module convenor cannot grant any extensions of the deadline. Students should apply for an extension to the university following a formal procedure below. There is a panel to evaluate applications. You can directly make an application, and you do not need to ask/inform. the module convenor. An application might be rejected and hence before you receive a formal extension, you should carry on your study assuming no extension. If you didn't get an extension before the deadline, you should submit your (in)completed work before the deadline in case that your application is rejected. If your application succeeds, you can update your work later before the extended deadline. An application takes time and you should make an application as soon as possible if you need it. Please refer to the University Quality Manual (in particular Sections, 1.5 and 1.6) at https://www.nottingham.ac.uk/academicservices/currentstudents/extenuatingcircumstances/extenuating-circumstances-procedure.aspx to see what constitute allowable extenuating circumstances (EC). Please note that extensions cannot be awarded for computer failure or loss, loss or damage to storage media, problems and delays collecting data and so on. Keep plenty of backups and stay organised! Other circumstances that cannot be awarded an extension include returning home, going on holidays and any quarantine requirements in other countries. For more examples of the kind of acceptable and unacceptable circumstances, please refer to the University Quality Manual (in particular Sections, 3 and 4) at: https://www.nottingham.ac.uk/academicservices/currentstudents/extenuatingcircumstances/guidance-on-acceptable-circumstances-and-evidence-ecprocedure.aspx Please bear in mind that all claims under the EC procedure must be in English and supported by independent, reliable documentary evidence of inability to comply with the requirements.
