Autotutorial 3 Microsoft Excel – Advanced Formulas 20 Points NOTE: AUTOTUTORIALS ARE WORTH MORE THAN HOMEWORKS!! A.General Instructions a. To begin the assignment, download and open the file AT3_SQ25.xlsx. Your completed assignment should be named “Section_LastName_FirstName_AT3.xlsx” b. Once the file is open, you will see a spreadsheet with five unfinished columns: “Total Sales”, “Commission & Bonus”, “Total Salary”, “Years w/ Firm”, and “Training Required?”. c. Above the columns for Quarterly Sales is a Commission & Bonus table. You will use this table to complete one of the unfinished columns. d. Use Excel Help and Section E of these instructions to read about the Excel Lookup, Now(), and If functions. After reading the descriptions for each function, you will be able to apply them to the correct unfinished columns. e. You will also be creating a chart to summarize the data and formatting the spreadsheet to be more legible. B. Completing Formulas a. In the “Total Sales” column, calculate the total sales for each employee’s first through fourth quarter sales. In cell F12, enter the correct formula and fill down the formula through F24. b. In cell F25, calculate the Average Total Sales using the Average Function. c. In the “Commission & Bonus” column (H), use the Lookup function*. Apply the correct formula to cell H12 (based on total sales) and fill down the formula through H24. (Hint: At one point, you will need to use absolute referencing on certain ranges so that your formula works for the entire column.) d. In the “Total Salary” column (I), you will need to sum together the employee’s “Salary” and “Commission & Bonus.” e. In the “Years w/ Firm” column (K), you will need to use the Now() function* to calculate how many years each employee has been with the firm (Hint: Difference between Now() and ‘Date hired’ will give the duration in days which you will need to divide by # of days in a year). f. In the “Training Required?” column (L), you will need to use the Iffunction* to indicate who requires training based on their Total Sales. Employees with sales greater or equal to $100 do not require training (No), whereas employees with sales less than $100 require training (Yes). *See Section E for more information C. Chart a. Create a Stacked Column Chart using the employees’ names and their first through fourth quarter sales. b. Title the chart “PLS21 SQ25 Quarterly Sales” and center align. c. The first through fourth quarters should automatically appear in the legend, and the employee’s names should automatically appear along the x-axis if you highlight the chart’s columns correctly. Make sure both are on your chart. d. Place your chart under your data. D.Formatting a. Insert three rows above the first line that’s titled “PLS 21 Associates Sales Employees Report”. On the first of the three rows you inserted, type “U.C. Davis ()”. Make the title bold, size 32 font, and centered between A1:M1 (you can decide what method to use to center it). Make the row taller so you can read the text if necessary. b. Move ranges B13:L28 to C13:M28 (All the cells should shift to the right). In the range B15:B27, insert a Sparkline to represent the first through fourth quarters of each employee (the range of cells C15:F27). c. In the range C15:F27, insert Conditional formatting such as Data Bars, Color Scales, or Icon Sets (This will show up as well as the number). You only have to choose one. d. On the bottom of row 2, insert a thick bottom border for the range A2:M2. After that there should be a blank row (row 3) in between your border and the PLS 21 Associate Sales Employees Report Title. e. Apply all borders to the range A13:M27 (Don’t include diagonal borders across every cell). Apply a thick box border around the outside of the range C28:G28. f. Apply dollar signs to the range C15:J27. g. Next to where it says “Comments” on row 30, place thin bottom borders in between ranges B30:G30 and B31:G31. h. Format your spreadsheet to have landscape orientation and set it to fit to: 1 page wide by 2 pages tall. (Your data should end up on the first page and your chart on the second). Ensure that both table and chart are centered vertically and horizontally in the pages. i. Locking cells: i. Finally, after all of this hard work you don’t want anyone inappropriately changing the information. Check to make sure that the range A13:M28 is locked. (Hint: Go to Format Cells). ii. After the range is locked, protect the sheets so users cannot modify your spreadsheet. Do not check the boxes for “select locked cells” and “select unlocked cells”. iii. Do NOT add a password to your sheet. E. Function Help a. Here are some details and descriptions ofthe functions you will use in Section B. b. Feel free to YouTube any of these functions for further help. LOOKUP Function 1. LOOKUP is a function that fetches a value from a lookup table on the worksheet. This lookup table can consist of two vectors: a lookup vector and a result vector. A vector is a range of cells and is written as two cell addresses separated by a colon. For example, the cells between and including A3 and A7 are written as A3:A7. 2. To use the LOOKUP function, click on the FX button next to the formula bar. In the “Insert Function” or “Formula Builder” dialogue box, type LOOKUP in the search box to find the LOOKUP function. Then, click OK. At this point, you will be asked to choose one of two formulas. Choose this formula: =LOOKUP(lookup_value, lookup_vector, result_vector) 3. Now, you will be asked to enter the appropriate information for each line. The lookup_value line requires only one cell. The lookup_vector requires a group of cells. Looking at the Bonus Table provided, which column do you think might be the lookup value and the lookup_vector? Finally, the result_vector requires a group of cells. Which group do you think this might be? 4. At the bottom of the dialogue box you will see Formula Result = a reasonable number. You can check calculations and formulas by hand. Now click OK. 5. Once again, a plausible number will appear in cell H12 (H12 becomes I15 after inserting formatting rows). NOW() function 1. NOW() is a date/time function that returns the number of days and fraction since 0:00:00 Jan. 1, 1900. 2. To use the NOW() function, click on the FX button next to the formula bar. In the “Insert Function” or “Formula Builder” dialogue box, type NOW() in the search box to find the NOW() function. Then, click OK. 3. NOW() is a code for today’s date, so if you wanted a cell to include today’s date, all you would do is type in: =NOW() 4. Use the NOW() function to calculate how long it has been since something started by subtracting the starting date from NOW(). 5. Remember that NOW() returns days, so if you want to calculate the number of years you must apply the factor necessary to go from days to years (does not require another function). 6. You should have a sensible answer in cell K12 (K12 becomes L15 after inserting formatting rows). IF (Logical Expression, Result if TRUE, Result if FALSE) Function 1. This is a logical function that returns one value if the given logical expression is true and another message if the expression is false 2. To use the IF function, click on the FX button next to the formula bar. In the “Insert Function” or “Formula Builder” dialogue box, type IF in the search box to find the IF function. Then, click OK. 3. In the dialogue box, all employees with sales less than $100 do require training. What do you think the logical test might be? In the second box, you need to type in a response if the logical test is true, and the third line should have a response if the logical test is false. What do you think the appropriate responses would be? (Hint: No/Yes). 4. When finished, click on ENTER and you should have a logical answer in cell L12 (L12 becomes M15 after inserting formatting rows).
Web Design 1 DC4012-B Client 1: Dad's Bistro Reminder: Do kindly create a logo for the designated client and construct the required content with respect to the listed order (descending). Student is required to source for their own images to use either via online or offline. Last but not least, students will be penalized for poorly organized files/ folders and messy codes. EDM (25%) – HTML & Inline CSS: 1. Main body content: o Company s logo o 1 image background (i.e. covers from top to bottom with the exception of the footer area) o 1 anchor link (i.e. button) Linked to constructed website (i.e. index.html) Text content • Visit Us o Body content — Group 1 Header text content • VIP card holders Usage of 1 image Body text content • 10% OFF a la carte main course and sides • Discount is valid until 10 April 2020 • Discount cannot be combined with any other promotions and/or discounts • For a la carte food items, discount is only applicable to 1 card holder per bill o Body content — Group 2 Header text content • Dining Hours Usage of 1 image Body text content • Selected beverage at $3++ • Valid from 1st April — 31st May 2020 • Available daily from 2pm — 5pm • Promotion cannot be combined with any other promotions and/or discounts
PLS 021 Spring 2025 Homework 6 Rstudio Part 2 Instructions This homework is due four (4) days after your registered lab section before 11:55 pm. Please read and follow the directions. If you have any questions, contact your TA or attend office hours. Assignment Overview For this assignment, you will be presented with several scenarios requiring computational solutions. You are expected to use RStudio software to develop and run your R code to derive the necessary answers. Your submission should consist of a single R script file containing your solutions. Ensure that you follow the submission instructions provided at the end of this homework to receive full points. Note: The use of Artificial Intelligence tools for generating code is strictly prohibited. You are required to solve the tasks independently, following the instructions provided during class. Task 1: Thermal profile of water in Lake Berryessa Solar radiation heats water bodies on the Earth’s surface, though not all of the energy is absorbed by the water. Approximately 6-7% of the incoming radiation is reflected back due to the water’s albedo. In pure water, nearly 70% of solar radiation is absorbed within the top 5 meters of the water’s depth. The penetration depth of solar radiation can vary depending on the clarity of the water, leading to variations in water temperature with increasing depth, particularly during the summer months. Marvin E. Jensen measured water temperature at various depths in Lake Berryessa during July 2003 and observed the same phenomenon. The resulting dataset was used to correlate ‘Depth’ and ‘Temperature’ using a simple sigmoidal curve fit. The equation is: Your task is to help visualize the temperature of water at different depths of the water based on the instructions provided below. 1. Create a variable named Depths that contains values ranging from 5 to 25 incre- menting by a value of 5. (1 pt.) 2. Use for-loop to iterate among the different depth values in Depths and calculate Temperature for each values of Depths using the equation provided above and print them. Store the printed values in a single variable called WaterTemp.(2 pt.) 3. Create a scatter plot with WaterTemp in y axis and Depths in x axis. (1 pt.) Task 2: Identifying odd and even digits in your Stu- dent ID For this task, you will identify the odd and even digits in your Student ID. Note that “0” should be considered an even number. Follow the instructions provided below: 1. Create a variable MyID by concatenating the numerical digits from your Student ID. Make sure to use your actual SIS Student ID. Hint: if your student ID is 919198498, you will need to concatenate 9, 1, 9, 1, 9, 8, 4, 9, and 8. (1 pt.) 2. Use a for-loop to iterate through the digits in MyID. For each iteration, print whether the numerical digit is odd or even. (2 pt.) Share your R code along with the results, and include an explanation of how you personalized the input values by adding comments. Ensure that your code is well- documented, with comments that clarify your choice of input values and explain each step of your solution. Task 3: Calculating investment pay-back period You recently decided to help your family install solar panels on the roof of your home. The total cost of the solar panels was $X (replace X with a value you choose). Each year, your family saves $Y on electricity bills because of the solar panels (replace Y with a value you choose). Write an R program using a ‘while’ loop to calculate how many years it will take for your family to recover the entire initial investment through the annual savings based on the instructions provided below- 1. The value for X (total cost) and Y (annual savings) depends on your birth month and day. X = 10, 000 + (month × 1000) Y = 500 + (day × 10) For example: If your birthday is April 15th, you might choose X = 10, 000 + (4 × 1000) and Y = 500+(15 × 10). If your birthday is December 3rd, you might choose X = 12, 000 + (12 × 1000) and Y = 600 + (3 × 20). 2. Write the full equation that you have used to calculate the value of X and Y in you Rscript. Make sure to adjust your values for X and Y so they reflect a realistic scenario. Put your actual birthday (month and day number) that you have used to calculate value of X and Y as comment. (1 pt.) 3. Implement the solution using a ‘while’ loop to determine the number of years re- quired to recover the initial investment. (2 pt.) Share your R code along with the results, and include an explanation of how you personalized the input values by adding comments. Ensure that your code is well- documented, with comments that clarify your choice of input values and explain each step of your solution. Instructions for Submitting Coding Tasks 1. Complete all three coding tasks using the desktop version of RStduio software. 2. Ensure that each task is clearly separated within the same R script file. You can do this by adding comments to label each task. Use the format below: # Task 1: # (Your code for Task 1 here) # Task 2: # (Your code for Task 2 here) # Task 3: # (Your code for Task 3 here) 3. Save all tasks in a single R script file named Section LastName FirstName HW6 . R (e.g., A01 Bailey Brian HW6. R). 4. Upload your R script file to Canvas, which should include the necessary code for all the above-mentioned tasks. 5. Important: Do not upload any other type of file except for an R script file with the . R extension. Failure to follow this instruction will result in 0 points for this homework. Note: Ensure that the code is properly formatted and commented so that each task is easy to identify and review.
CMT216 Computer and Network Forensics Assignment 1. Scenarios Taurus Smith and her accomplice may be involved in illegal activity. The suspect’s address was searched by the local police officers. In Taurus Smith’s house, one mobile phone, clothing, some cooking books, toiletries, and a USB flash drive were found. In a further investigation of Taurus Smith’s mobile phone (Exhibit A) and USB flash drive, it is found that the mobile phone is liquid damaged, and the USB flash drive includes an image of a laptop hard drive. Taurus Smith refused to answer any questions. You are a forensic investigator and will be given the image of USB flash drive. You need to conduct examination and identify the relationship between Taurus and her accomplice and any other supporting evidence that pertains to the case. 2. Supplied Materials • Instructions • Scenario • Taurus’ laptop image on a USB flash drive • Pcap files • Mobile exhibits • NTUSER.DAT retrieved from another machine in the same network 3. Basic Requirements Your task is to demonstrate adherence to basic forensic methodology in your examination of the USB image. You are expected to produce a scientific report detailing the methods employed, the results obtained, and answers to the following questions: 1. Is there anyone else implicated? If so, who? Show any evidence sup-porting your findings. 2. Where was Taurus Smith planning to travel to? Show any evidence supporting your findings. 3. Please identify as many as the recipes and present all techniques were used to hide it in the provided materials. 4. What analyse the network activity involved in this case and present detailed evidence items. 5. From the given NTUSER.DAT can you find what did the user search? How many times did the user use EXCEL.exe? What is the latest typed URL? Hints: 1. Look for deleted data. 2. Look for suspicious emails or files. 3. Build a “dirty word list” and search the image. 4. Look for artefacts from different browsers, google search, Bin files, pcap files, etc. Basic steps to follow: If you are starting the case in AUTOPSY. Then here are a few steps to get you started. 1. When it asks for an image use the [image name].e01 supplied. 2. Ensure you select “partition” . 3. Although you have not been given a specific time you should still revise the steps given in the lectures and create a timeline. 4. Then start the analysis. All this can be done through the AUTOPSY interface. Remember that it uses all the tools we have covered.
ECON 3023 International Finance Semester 2, 2024-2025 Assignment 2 1. Consider the following DD-AA model. Consumption is given by C = (1 — s)Y. The current account balance is given by CA = aE — mY The good market equilibrium condition is Y = C + I + G + CA . The interest parity condition R = R* +(Ee — E)/E holds. The equilibrium condition of the money market is Ms/P = 2Y — 2000R. Suppose initially the I = G = 100, s = 0.3, m = 0.2, a = 200, R = 0.05. The initial exchange rate is E = 1. a. Assume that the central bank can hold the exchange rate E constant. What is the effect of an increase in government spending G by 50 on output Y? b. How will the fiscal expansion affect the CA? c. Find the change in real money supply Ms/P that can keep the exchange rate from changing. d. What will happen if the central bank does not change the money supply? Will the fiscal expansion become more or less potent? 2. Using the DD-AA model, analyze the output and balance of payments effects of an import tariff under fixed exchange rates. How would the tariff affect other country? Discuss what would happen if all countries in the world simultaneously try to improve employment and the balance of payments by imposing tariffs. 3. (20 marks) Suppose we are using the CPI (consumer price index) to compute the Japanese Yen real exchange rate per Euro. The real exchange rate is determined by the relative demand and relative supply conditions between Japanese goods and European goods. The residents of Japan consume relative more of Japan export good than residents of Eurozone residents. In other words, Japanese export goods have a higher weight in the Japan CPI (consumer price index) than they do in Eurozone. Use the relative demand-relative supply diagram to analyse the changes below. a. In the diagram with the real exchange rate based on CPI, is the relative demand curve (Japanese goods/European goods) upward sloping? Why? b. What would be the effect on the Japanese Yen real exchange rate of a rise in the world demand for Japanese products? c. How would the change in part b affect the nominal Yen/Euro exchange rate? d. There is a one-off increase in the money supply of the Eurozone while the money supplies of Japan remains the same. How would the change affect the Yen/Euro real and nominal exchange rates? e. Suppose an earthquake destroyed many production facilities in Japan. Thus the output of Japan becomes lower. What would be the effects on the Yen/Euro real and nominal exchange rates?
ECON20532/30532 Macroeconomic Analysis IV Resit paper 2023/24 INSTRUCTIONS SPECIFIC TO THIS EXAM: . Answer both questions. Each question carries the same overall weight. . You should type in your answers, but can include pictures of hand written equations if necessary. . Candidates are expected to demonstrate to the examiners a competent knowledge of all computations. . Candidates are also advised that the examiners attach considerable importance to the clarity with which answers are expressed. . Electronic calculators may be used in accordance with the University regulations. Exam Questions 1. Consider a random-relocation economy where each young person receives 100 units of the consumption good. There are 500 young people in the economy at time 1, and the population grows at 2% per year. The total stock of money at time 1 is equal to $40,000, and it grows by 1% every year. Suppose a personís preferences are such that they only want to consume when old, and they dislike risk. We also assume that the probability that a person is relocated is 40% (known to everybody) and if relocated they need to move at the end of the first period, before capital matures. Endowment goods can be transformed into capital, which gives a gross rate of return of 1.02 after one period. Capital cannot be sold or transformed back into consumption goods before maturity. Individual agents don't have the technology to convert goods into capital, but there exists a (perfectly competitive) banking sector that accepts deposits and can invest in capital. (a) Write down the money-market clearing condition for this economy. Where is the demand for money coming from? How does the value of money change over time? (30% of total question mark) (b) What is the state contingent rate of return o§ered by banks on deposits? (20%) (c) Compute the equilibrium value of money at time 1 for this economy. (30% of total question mark) (d) Assume now that both population and the stock of money remain constant over time. What would change in your answers to points (a), (b) and (c)? (20% of total mark) 2. Consider an overlapping generations economy with 100 young people born in every period. Government debt and capital both pay real net rates of return equal to 5 percent. The fiat money stock is fixed. Each young person wishes to save 50 goods in each period and, for equal rate of return, prefers government debt over capital. In period 0, the government issues a total amount of real government debt equal to 2; 000 goods. The government attempts to roll over this initial debt in subsequent periods. (a) What are the real holdings of capital and bonds of each young person in period 0 and in period 1? (30% of total question mark) (b) In what period does it become impossible for the government to continue to roll over its debt? (30% of total question mark) (c) Now suppose that the number of young people born in each period grows at the net rate of 10 percent. There are 100 young people born in period 0. Reconsider your answer to part (b) and explain how things would di§er now. (20% of total question mark) (d) What if instead population grows that the rate of 2% per year? Will the government be able to roll over its debt forever, and if not when will it stop being able to do so? (20% of total question mark)
Statistical Learning (STAT3040) Final Project - Semester 1, 2025 • INSTRUCTIONS: 1. The project must be typed (not handwritten). You should produce a reproducible document through Quarto in RStudio [https://rmarkdown.rstudio.com] for the project. The report should be no longer than 16 A4 pages [single sided] with a font size no smaller than 11 point. This does not include an appendix. 2. The project due date is listed on the Wattle (Turn-it-in) site. Upload the project through Wattle using Turn-it-in. You should submit your project in three different parts. Note that there are three tabs when submitting to Turnitin. (a) A pdf file or Word file of your report (this will likely include important R code to highlight what you have done). (b) A ‘.qmd’ file [a quarto file]. (c) A ‘.r’ file [provide all the R code from the ‘.qmd’ and any additional R code used that was done outside of the ‘.qmd’ file.] To get the ‘.r’ file from an ‘.qmd’ file use: > library(knitr) > purl("xxx.qmd") 3. When putting together your report, write clearly and succinctly. Make sure to utilise ideas from throughout the course. Use appropriate graphs, tables, mathematics, and code to aid in describing your point or thinking process. Do not just “print” a set of results. Every result should be discussed and have a reason for being presented. No points will be awarded unless you clearly discuss what you are doing. 4. As this is a final project you may not discuss the project (questions, solutions, code, etc.) with your classmates or other individuals. You can discuss these with me or your tutor during our consultation times. You must independently write your own solutions. This includes all computer code, written language, and mathematics. Please see the university resources on Academic Integrity https://www.anu.edu.au/ students/academic-skills/academic-integrity for more details. For this assignment, you do not have to cite material from either of the two textbooks or class slides. Any other material should be appropriately cited, including websites. You must also cite any use of Artificial Intelligence (AI). Additionally provide a single paragraph discussing your use of AI for the assignment. 5. No late projects will be accepted. Note that this final project is considered similar to a final exam. 6. You may post questions to the discussion board, however please let myself or Mr. Zheng Xu answer the questions. 7. Have fun with the exploration! The project consists of analysing and statistically modelling data on U.S. medical insurance claims over a several year period. Beyond the prediction competition, you should determine and discuss important co- variates (statistically and scientifically) and also appropriately account for and discuss uncertainty. Data fields: • claim (Y1 ) - claims in USD. • comp (Y2 ) - medical complications (1 = yes, 0 = no). • age - in years. • proc - number of medical procedures (Low, Medium, High). • drugs - number of prescribed drugs the individual is taking. • emerg - number of emergency room visits. • comorb - number of comorbidities. • duration - number of days spent hospitalized. The project should be written as report. Within the report there will be two data modelling and prediction components. Each one of these is described below. For each of the two components, you should consider at least 5 different classes of models/algorithms. Each of the models should be clearly outlined and compared (possible items to consider: k-fold cross-validation, uncertainty, predictive rank, etc). Also outline, discuss, and compare several naive predictions. Your best predictive model for each of the two components should be discussed in terms of statistically and scientifically important covariates. Additionally you should discuss the limitations. If you feel your best predictive model is not the best model for discussing the relationship between the covariates and a response, you may discuss another model (or combination of models) as well. • Modeling Components: 1. claims: Based on any of the other variables in the training data, build models to predict and understand claims. The criterion for the predictions is Mean Squared Error. Make sure that all predictions are justified by a model. If a perfect score (or even top 10% score) is achieved without justification, a high penalty will be applied. — The private link for the competition (which should not be shared outside of the class) is: https://www.kaggle.com/t/f837aa93ce3c46bbb41e8537aec64811 2. comp: Based on any of the other variables in the training data, build models to predict and understand the classification of comp. The criterion for the predictions is the Correct Classification Rate. Make sure that all predictions are justified by a model. If a perfect score (or even top 10% score) is achieved without justification, a high penalty will be applied. — The private link for the competition (which should not be shared outside of the class) is: https://www.kaggle.com/t/5370523fef184651b969957b8945cf10 Marking Components: 1. Introduction and conclusion/discussion sections [15 points] 2. Exploratory data analysis [15 points] 3. Modelling component 1 [30 points] 4. Modelling component 2 [30 points] 5. Top predictions [10 points] - For each of the two prediction competitions the top 10% of individuals on the Private Leaderboard (when the competition closes) will be awarded 2.5 points while the top individual will be awarded 5 points. The predictions must be justified by a model and its discussion. Note that there is a Public Leaderboard which you are able to see and a Private Leaderboard which you cannot see until the competition closes. The evaluation of the test data are randomly and approximately evenly split between the public and private leaderboards. Your writing, organisation, and presentation will be considered when grading.
BUS3023 - BRM Assignment 3 (Research Report) Guidelines Research Report BRM Deadline: End of Week 13 Submission: via TURNITIN ispace folder One submission per group The title of your file must be as follows: ‘BRM – Research Report Group YY, Your final report is the development and continuity of your research proposal. It means that you need to conduct a research project based on the research proposal that you have submitted. You will need to collect data and analyze them to answer your research question(s) and hypothesis. For the format of your report, you may refer to the assignment guidelines, FYP report guidelines, and those used in published research papers. If you have any questions, do not hesitate to book an appointment with your instructor to discuss your research. Finally, you will need to present your research in class in addition to the submission of your full report. 1. Report Format: • The first page needs to include your title, your class section, your group members' name & ID, and the date. • The second page will include the table of contents. Indicate page numbers of different sections and subsections. • The third page will be the stat ofthe main body of your research report. The length should be from 5000 to 10000 words (quality is more important than quantity) • You can use your proposal as a base to write your report. But you need to have a more comprehensive development than the proposal. The literature review should be more extensive with at least 20 references. • Same as the research proposal, please use the APA standards for tables, figures, and references. • Use 12 font-size Times New Rome and 1.5-line space between lines. 2. Report requirements: You can find supplementary materials for RESEARCH REPORT on iSpace to help you to write your research report. Generally, we want to see the following in your research report (Example of guidelines from FYP research report): 1. Problem Development and Objectives o The background of the problem has been adequately explained. o Objectives are clearly stated. 2. Literature Review and hypotheses o The literature review has been fully developed. o The relevance of the literature reviewed has been clearly explained o The hypotheses are proposed based on appropriate arguments 3. Methodology o The subjects to be studied are specified. o The procedures have been adequately defined and justified. o The data collection and analysis are appropriate. 4. Analysis Procedures and Findings o The procedures have been used correctly to analyze the data. o The results of the analysis have been clearly stated. 5. Discussion and Recommendations o The findings have been properly interpreted. o The contributions of the study have been clearly stated. o The limitations of the study have been clearly stated. o The recommendations are related to the findings and reflect real business practice o The conclusions present an overall synthesis of the results. In addition to the above structured components, we also expect good Presentation o The report is written clearly. o The report is organized logically. 3. Research ethics: Be aware of plagiarism issues. Plagiarized work will receive zero. Report with more than 30% similarity will be rejected directly. Reports between 20% and 30% will be checked in detail. Any AI tools should not be used in writing the research report.
CIT 348 – Information Management and Retrieval Exam Part 2 of 2 (160 of 255 total points) Be clear, forthright, and thorough. If I need to dig or am confused by your answer, you will lose points. Integrate ALL answers into this word document. Submit a single document. NO Tableau files. Pre and post surveys were given for all CIT courses. We will look at two of these to determine how well the learning outcomes were achieved and where we should focus our future efforts to help improve the courses. First concentrate on CIT154. Use the CIT154 Course Learning Survey spreadsheet provided. (150 total points). Do not create visualizations for CSE174 for this exam. 1. For questions 2-5 below keep a strict log of each step you take (successful or not). This log should be able to be handed to someone else and used to recreate your actions (5 points for each log a-d). Create visualizations for the data answering the listed questions. Each question needs a different visual (or you are not thinking about the questions deeply enough). Summarize your findings for each question in written form. as well (a summary should be at least 2 full paragraphs). You will be evaluated on accuracy (content (5 points each), calculations (5 points each), and conclusions (5 points each)) and effectiveness (choice of visualization (5 points each), answering the question (5 points each), and summary (5 points each)). 2. Overall, at the end of the course, did the students achieve the learning outcomes? 3. How does the student achievement for each learning outcome compare (comparing outcomes to each other)? 4. Has the course improved their ability to achieve the learning outcomes (from the beginning of the class to the end)? 5. Which learning outcome(s) should we concentrate our efforts in subsequent classes? 6. From your answers to questions 2-5 above, choose two answers to critique. a. Identify the answer you feel best represents your work. Explain why you believe this to be true. Be specific. Vague, hand waving responses will receive no credit. (5 points) b. Identify the answer you feel least represents your work. Explain why you believe this to be true. Be specific. Vague, hand waving responses will receive no credit. (5 points) 7. Consider the CSE174 evaluation spreadsheet. Though similar, there are unique challenges in producing the visuals. Discuss the challenges you have identified and approaches that you would take to produce effective visuals to convey analysis for CSE174. (10 points)
BEX5131 S1 2025- ASSIGNMENT Due date: Tuesday, 20 May 2025, 11:55 PM Weighting: 60% This version: modified 18 April, 2025 This is an individual assignment. Note: The final submission should be in Word or PDF format. You also need to submit the Excel with formulas for Question 1 and 2. If you cannot submit Excel, please state the steps and formulas you used to work out Question 1 and 2 clearly in the Word or PDF document you submit. If any two submissions from different students are the same, both will get zero points. Use of ChatGPT or other AI composition software is not permitted. The extra documents provided to work on this assignment: 1. Excel file with multiple indices for Question 2 2. Documents from Hostplus and UniSuper for Question 3 Question 1 (35 points) You will build a strategic asset allocation consistent with your risk profile. Each of you will be assigned a risk profile. Find your assigned level of risk tolerance from the following table: your risk tolerance is assigned based on your first name. gins with thefollowing letters.Very lowA, B, C,D,E,F,G,HLowI, J,K,L, MModerateN, O,P,Q,R,SHighT, U, V, W, XVery highY, ZRisk ToleranceMaximum acceptable lossVery low10%Low15%Moderate20%High30%Very high35%SAAPortfolioVolatilityGlobal EquityGlobal BondHedged*AlternativeInvestmentsCashPortfolio1 – Conservati te29%38%15%18%4.98%Portfolio 3 – Balanc owth78%2%18%2%10.57%Maximum acceptable lo gins with thefollowing letters A, B, C, D E, F, G, H, I, J, K L, M, N O, P, Q, R, S, T U, V, W, X, Y Z
FBUY2104 FASHION COMMUNICATION AND BRANDING START UP BRAND LIVE PROJECT Little Legends Club Brand Introduction Little Legends Club was created with a bold vision: to offer an alternative to the typical kidswear found on the high street. Gone are the days of cliché dinosaur and unicorn prints — we believe that every child is an artist, and their creativity should be celebrated. Inspired by the incredible artwork we see from children during our free community art events, we set out to empower kids by turning their designs into wearable pieces of art. At Little Legends Club, we create more than just clothes — we create a platform. for self-expression. From t-shirts adorned with children’s original artwork to cozy hoodies, sweaters, and joggers perfect for weekend adventures or cozy days at home, our designs are all about positive messages and comfort. Proudly based in Leicester, we’re committed to manufacturing as much as possible right here in the heart of the city, supporting local craftsmanship and sustainability. Whether your child is out exploring nature or relaxing indoors, Little Legends Club is there to keep them comfortable and inspired. Little Legends Club Target Audience At Little Legends Club, we create cool apparel that kids love and want to wear on repeat. While our clothing is designed with kids in mind, our primary customer is the parent, auntie, or uncle looking for something special. Our brand is a perfect choice for unique clothing gifts, offering fun, creative, and comfy pieces that both kids and gift-givers will appreciate. SOS Brand Introduction: Super Ocean Studios was born from my experience as a fashion buyer in the industry, where I saw a unique opportunity within the yachting sector. With a deep understanding of style, quality, and functionality, I created a brand that provides luxurious, tailored uniform. solutions for yacht crews. But Super Ocean Studios is more than just uniforms. We’ve expanded into offering premium casual wear for those moments off duty. Our focus is on high-end, versatile clothing that blends sophistication and practicality, designed for those who value both style. and substance, whether on the water or beyond. SOS Target Customer: Our target customers are individuals who appreciate the balance between luxury, functionality, and style. At Super Ocean Studios, we cater to superyachts, offering sophisticated uniform. solutions for their crews, ensuring they look and feel their best while on the water. We also appeal to surfers and those who call coastal areas home, with clothing designed for both the active and laid-back lifestyle. that the ocean inspires. Whether you’re out on the waves or enjoying life by the shore, our premium casual pieces—like crisp t-shirts, polished polo shirts, cozy sweaters, and breezy linen shorts—are perfect for anyone who loves clean, understated fashion. Super Ocean Studios is for those who seek timeless style. with a contemporary edge. Brief Aims & Objectives Aims: · Research, justify, propose and design a new brand building campaign for a new start up brand. All to be professionally presented in a CAD portfolio. Objectives: · Research into appropriate low budget marketing methods for a start up brand. · Select either the Little Legends Club (Boyswear) or Super Ocean Studio (menswear) brand for your campaign. · Identify a key selling period when you want to launch campaign and justify your choice. · Propose viable low-budget marketing strategies to enhance brand awareness suitable for a start-up. · Create engaging content that supports brand storytelling and communicates the brand’s mission, vision and values using strong copywriting skills mixed with creative visuals. · Explore experiential marketing opportunities and propose interactive methods to increase brand visibility. · Apply marketing theories and models to underpin and justify your creative decisions. Task Requirement · Research: From the guest lecture presentation of Little Legends Club and Super Ocean Club gain an understanding of the brands mission, vision and values for the brand. Then research into appropriate marketing methods for a start up brand, along with utilising brand building theories and models to gain and understanding of how that brand can grow. · Evidence of research in appendix: Include all pages of your research of the brand, marketing methods and inspiration from other brands marketing methods. The appendix can include imagery, charts and tables with a small amount of annotation if needed for any of the appendices content (50 words each piece of content only if needed) · Campaign Creation: In groups (this is not a group project but the content is shared in groups of 5 people) you will be given the opportunity to plan and carry out a photoshoot for the brand . In your team you will: o Agree on which of the 2 brands you will use. o Decide if you want to do a location /studio or still life shoot (kids models will be provided). o Get shoot inspiration of the type of shots/videos you want to take. (you can use an Iphone or hire equipment from AV loans. o Plan and create a shoot schedule o Get props if needed o Carry out the shoot o Share the content for you to use for your marketing creative work. · CAD creative work: Using the content you created on the photoshoot, plan, propose and design creative artwork for the brand. Demonstrate your marketing campaign ideas in a creative and visual way using the Adobe Creative Suite (In-Design, Photoshop and Illustrator). You are required to create the following as a minimum: o Plan a pop-up event that will build up the brand awareness based on the brands values. Think of how you will advertise this event. Try to create an immersive experience that brings Instagram-able opportunities for social media sharing. o Design content for your social media campaign and how the idea is developed (stills or video or both) conveying the brand identity o Email marketing create an email or series of emails that get across the brand story and advertise the event o Website show various product pages of the website including a page about their mission, vision and values that demonstrates your copywriting skills o Branding, Labelling and packaging: Create 1 or 2 design boards that convey the brand identity well and creates a pleasurable experience when unboxing the product once received that adds value to the brand experience. o You can add annotation to explain your ideas, but this should be between 1000-1500 words · Promotional Calendar: Create a promotional calendar for the campaign. Consider the main campaign, the run up to the campaign and after the campaign to keep the audience engaged to generate engagement and a desire to become a loyal repeat customer. Design this in a creative visual way · Create digital artwork using Adobe (In Design, Photoshop and Illustrator) with the final piece of work created in In Design. For submission you must save your final work as a PDF and submit to Turnitin, but also upload your in design file (packaged up files) and any video content as separate files. Considerations · Brand Storytelling: Craft a compelling narrative that communicates the brands Values, Mission, and vision. · Visual Identity: Develop visually appealing content that reflects the brands brand aesthetic while showcasing its product range. · Content Strategy: Create engaging and informative content across various platforms (e.g., social media, website, email) to grow brand awareness with the target audience. · Influencer Partnerships: You may want to consider a collaboration with influencers and brand ambassadors who embody the brands values and have a strong presence within the target demographic, Give justifications for your decisions. · Events: Propose an exciting idea for an event with visuals and text to explain the idea · Messaging: what do you need to get across and how. · Pre and Post event activity: how do we let customers know what’s happening and to keep them interested afterwards. · During the event: how can we stand out. What could we activate to make it memorable and a special experience for our customers? · Channels: what are you going to talk about and where? · Theoretical underpinning: Ensure relevant theories are imbedded within the research to show your understanding of theory and how it applies to the marketing methods. Module Learning Outcomes · Identify and analyse areas for development leading to suggestions for improvement. · Evidence a critical understanding and the relevance of historical, theoretical, critical and global contexts within your work. · Draw upon a range of sources to select and use data to support and justify ideas for development, direction and/or innovation. · Communicate and present information clearly and professionally in a range of relevant visual or verbal styles. Marking Criteria You will be graded on the following criteria: Grading will be in accordance with the Fashion & Textiles mark descriptors (see attached sheets) and will be based on the following: 40% Design of Presentation and referencing The strength of design for the project finished to a professional standard. Demonstrating creative innovative and original evidence demonstrating strong development in CAD skills (Application of design and correct referencing) (Application of design and correct referencing) 20% Research and analysis Strong evidence of background research and theoretical underpinning demonstrating a strong understanding of the brand to justify the project (Background research and academic writing and theoretical underpinning) 40% Outcomes The development and effectiveness of the brand building campaign and event ideas aimed to the relevant targeted audience (Marketing ideas and thought process). Layout The layout of the project should follow a similar basic structure to below (please note this is just a guide, you are encouraged add further theories and analysis). · Front cover · Abstract · Table of Contents page o Aims and objectives of the report o Brief discussion of your brand vision, mission and values · CAD work o Website designs (product pages and the brand vision, mission and values o Social media campaign development o Email o Event o The branding, labelling and packaging experience (1-2 pages) o Other extra digital and traditional marketing methods if you wish. · Promotional calendar · Academic references · Image references by page number your own contents doesn’t need to be referenced · Appendix Word count This is a CAD portfolio project so is a more creative project equivalent to (4000 words in workload) You can add annotation to explain your ideas but must be between 1000-1500 words. The front cover, abstract, references and appendices are NOT included within the word count. Appendices Appendices should be used to show a copy of any primary research findings and any further supporting evidence which may not be deemed appropriate to include within the main body of the report. You can include theoretical models. Make sure you refer to the appendix from your main body of text to show where the theory has been applied.
ECS7028U/P: Data Semantics – Final Coursework (Mini project) The goal of this mini project is to apply the semantic data modeling, ontology design, logic, data validation, and rule-based reasoning skills acquired through lectures and labs. This coursework is intentionally open-ended, allowing you to make your own decisions regarding the dataset you choose to work with, identify relevant data sources, and determine the most effective way to document your work. While examples and potential data sources are available on the QM+ module page, you are encouraged to explore and select data that align with your interests. Your primary task is to define, populate, and query an ontology, incorporating both a T-Box (terminological component) and an A-Box (assertional component) on a topic of your choice. The ontology should be designed to integrate and reuse existing semantic data, ensuring interoperability with external knowledge bases. To achieve this, at least three concepts in your T- Box must be sourced from external semantic data repositories, enabling the ontology’s A-Box to be populated with real-world data. For implementation, you will use Protégé to design the ontology and leverage Python-based semantic tools to populate it with actual data. Your final submission should include both a structured report and the corresponding code, demonstrating your methodology, design choices and reasoning processes. You should specifically achieve the following: Basic Task (data engineering): Define your ontology using OWL2. The T-Box must be created using Protégé and should be your own work (not an existing ontology but may import existing ontologies). Populate the knowledge base from an external semantic data repository using SPARQL 1.1 (or the 2025 update 1.2). Verify that you can also query the local ontology using SPARQL. Document your work and submit the ontology and queries. Intermediate Task (data integration): Complete data collection as above, but your ontology should allow fusing information from at least two distinct external data repositories. The query to your local ontology should answer questions that cannot be answered by either remote knowledge bases alone. You may use semantic (typically graph structured data with an ontology) or non-semantic (e.g. dumps of data tables, CSV files etc.) sources as long as you describe your process of populating your ontology. Advanced Task (reasoning): Use Description Logic (DL) to define as many concepts as possible with the help of SWRL rules to compensate for the limitations of the Protégé inference engines with DL. The A-Box (incl. individuals) must be created such that it demonstrates the correctness and effectiveness of the defined logic rules. You should submit a PDF and a zip file with the following elements: Report: A PDF document describing how you constructed the ontology: you should say where you got the data from, and you should also say what difficulties you encountered and how you solved them. The document must have also a final section explaining what source code files and models are included, and the required steps torun the code. You are expected to submit a report explaining your assignment. If you fail to submit a report with your ontology and python files, you might receive 0% as it is the only way of proving the work is yours. Code and Ontology: The code including SPARQL queries and ontology should be submitted as a single .zip compressed file (not exceeding 50MB). In cases where a very large database is used for demonstration, your code should access the data from a remote resource instead of including the database in the submission. The zip should include at least the following elements: • A Protégé-OWL ontology (.owl file) • A python script. (.py) that can be used to populate the ontology from a SPARQL endpoint. • Another python script. that queries the local store to demonstrate to the user that information can be easily accessed. To test the system, the user should be able to execute any arbitrary query supported by your ontology. Further support: This assignment is intended to be open ended and exploratory in nature. However, for illustration, examples of possible tasks could be: • Create and populate an ontology covering movies and cities, enabling queries such as finding movies filmed in cities with a population of less than 1 million. • Develop an ontology about companies, including details on location, employees, and profits, which could be queried to identify UK-based companies with the highest profit per employee. • Construct an ontology focused on music, incorporating information about artists, genres, and concert venues, which could be queried to find jazz musicians who have performed in European venues with a capacity of over 5,000. Some publicly available semantic web data sources that can be useful for this coursework are listed below: • Dbpedia (https://www.dbpedia.org/) provides an RDF version of the information available in the regular Wikipedia. It also provides an SPARQL endpoint for remote access (https://www.dbpedia.org/resources/sparql/ ) • Wikidata is a free and open knowledge base that can be read and edited by both humans and machines (https://www.wikidata.org/). Wikidata acts as central storage for the structured data of its Wikimedia sister projects including Wikipedia, Wikivoyage, Wiktionary, Wikisource and others, with a SPARQL end point: https://query.wikidata.org/ • You can access open governmental datasets from data.gov.uk and data.gov. In some cases, you might need to download the dataset, as they don’t provide a SPARQL endpoint. • Datasets with SPARQL end points (updated in March 2025 but may include broken links): https://www.wikidata.org/wiki/Wikidata:Lists/SPARQL_endpoints • A broad set of datasets from https://datahub.io/collections (some are in RDF). • There are additional links to resources and examples on QM+. Marking criteria: Basic task (60% coursework marks): Correctly designed ontology with basic taxonomy and property hierarchy (15%), correct domain and range restrictions (5%), correct and effective use of object properties (including constraints and characteristics such as functional, transitive and irreflexive), correct and effective use of data properties, logical and correct use Description Logic to define concepts (10%), Ontology population python script. and SPARQL queries (20%), justification explanation and validation of the ontological modeling decision in the report (10%). Intermediate task (20% coursework marks): Use of appropriate, diverse data sources (5%), correct mechanism to retrieve and transform. data to fit your ontology (10%), explanation of the mechanism in the report (5%). The data sources can be RDF dumps (e.g., loaded into a local database) and SPARQL end-points, and may include a non-semantic dataset you convert into RDF locally for it to be queried. Advanced task (20% coursework marks): Correctly working (inferencing) ontology with one of the reasoners provided with Protégé and use of SWRL rules: object and data properties and SWRL built-ins (10%). A correct A-Box with enough individuals to use with the defined logic rules, expecting majority of the relations defined by the data properties and concepts to be inferred by the engine, not hard coded (5%), correctly commented rules and explanations in the report (5%). Fig. 1. SWRL rule examples in Protégé (using the SWRLTab plugin) Coursework is due on QM+ in the exam period. Please check the date specified in the coursework area of the module page. Please do not be late with the coursework otherwise a late submission penalty is applied automatically. There is a final cut-off point after one week. About four-six weeks should be sufficient to complete this coursework. All sources including the use of tools must be referenced and acknowledged.
Web Design 1 DM-ADV-721-03X Web Design & Development (Electronic Direct Mail) Individual Assignment. 1. Objective The module provides students with essential knowledge and skill sets to build a solid foundation in web design. Using industry standard web development tools, students will be guided to explore both the technical and aesthetic aspects of front-end website creation with emphasis on accessibility, usability, and user experience. The guidance will take the form of lectures, tutorials, technical demonstrations, practical, and critique sessions. The components of the module include website structure analysis, content flow, information navigation and hierarchy, HTML (Hypertext Markup Language), CSS (Cascading Style. Sheets), creative implementation of web standard interfaces, etc. 2. Expected Learning Outcome • Define the technical terminology and basic requirements of front-end web development • Interpret the underlying concept of layout and navigation principles in web design • Apply essential coding knowledge and techniques in structuring user-friendly webpages 3. The Task The student is required to design and develop an EDM based on the client’s project brief given. The approved concept and visualized layout shall then be hand-coded via HTML/CSS. It is mandatory for the website to be fully functional without any broken navigation or media links. 4. Assignment Weightage 25% 5. Assessment Criteria Assessment will be based on the following criteria: • Creativity and design : 30% • Development progress review : 30% • Website coding : 40% 6. Submission Deadline and Policy Project due: Week 6 • EDM (i.e. 1 web page) o HTML o Cascading stylesheet (Inline) o Media assets (e.g. images and etc.) o Sketches and wireframe (PDF) o Mockup design layout (PDF) o Work files (i.e. PSD, AI)
FEEG2002W1 SEMESTER 2 EXAMINATIONS 2023-24 TITLE: MECHANICS, MACHINES AND VIBRATION Q1 (i) In the 5-bar linkage mechanism with a suspension link that is shown in Figure 1.1, the crank AD that rotates about fixed axis A, has a pin D which slides in the straight slot of link CE. Link BC turns about joint B. Figure 1.1 Schematic of a hydraulic excavator mechanism Determine the mobility of this mechanism and state any assumptions you make in calculating the mobility. [5 marks] (ii) In the crank and slotted-lever, quick-return mechanism shown in Figure 1.2, the link OA with 40 mm length rotates at a constant angular speed of 100 rad/s. A sliding link which is pin joined to OA at A, slides along the link BC and hence makes BC rotate about B, as shown in the figure: Figure 1.2. Crank and slotted-lever, quick-return mechanism The ground link length is 70 mm. For the position shown, i.e., when the angle of OA is 60°, calculate the angular velocity of the link BC. [16 marks] (iii) For the same four-bar linkage mechanism in Figure 1.2: a) Locate all the possible instantaneous centres of velocities. [7 marks] b) Calculate the angular velocity of the slider, using the “angular velocity ratio” theorem. [6 marks] TOTAL [34 MARKS] Q2 A technician is given two identical elastic springs of stiffness k equal to 2500 Nm-1 and a single viscous damper c. The technician is asked to support a motor of mass m equal to 5 kg and cannot decide which of the two configurations shown in Figure 2.1 to use. For any calculations take g the acceleration due to gravity to be 10 ms-2. Figure 2.1. Mounting configurations using two identical springs, a single viscous damper and a supported mass. (i) Mounting options and comparisons. (a) What is the frequency above which any motor vibration to the ground will begin to be isolated for the two configurations? [6 marks] (b) What will be the static deflection of the mount which gives the widest frequency range of isolation? [2 marks] (c) What is the value for the viscous damping constant in the two cases such that the combined loaded mount (mass supported by the springs plus damper) has critical damping? [4 marks] (d) The technician uses both mount options and measures equal vibration on the motor mass when the motor is operating at 3000 rpm. Why is the vibration level the same irrespective of the mount option chosen? Estimate the motor out of balance (mee) when the motor mass acceleration is 10g at this speed. [4 marks] (ii) A novel mount installation An academic proposes to use a massless bar that is pivoted at its midpoint with one bar end supporting the mass via one spring and the other bar end restrained by an identical elastic spring k as shown in Figure 2.2. One can assume that the bar is free to rotate by an angle θ and displacements are small from the equilibrium position. Figure 2.2. Isolation comprising a massless bar and the two identical springs and the attached mass. (a) What are the displacements of points A and B at the bar ends in terms of the bar rotation? Hence draw the free body diagram for the supported mass m and the massless bar from the static equilibrium position. [6 marks] (b) Considering the equation of motion for the bar, show that the ‘novel’ system is identical in its dynamic behaviour to one of the systems presented in part (i) when the damper is not present. [7 marks] (c) A single viscous damper is to be added either in parallel with the upper or lower spring. Explain why there is no preferable position to add it. [4 marks] TOTAL [33 MARKS] Q3 A uniform horizontal sign of length 8L is represented by a rigid bar supported by two vertical elastic springs each of stiffness Kv as shown in Figure 3.1 below. The bar has a mass M equal to 8PAL , where PA is the mass per unit length. The bar has a moment of inertia J about its centre equal to 6ML2 . Figure 3.1. A horizontal sign in its equilibrium position. (i) (a) Derive expressions for the potential and kinetic energies of the system in terms of the small vertical displacement y of its centre and small rotationθ in radians about its centre. [4 marks] (b) Using Lagrange’s equations, or otherwise, obtain the equations of motion for the system in matrix form. [8 marks] (c) Show that the system has no rigid body modes in this plane. [3 marks] (ii) The bar is observed to be bending when the wind is gusting and it is necessary to estimate the fundamental natural frequency treating the bar as having a bending stiffness EI. (a) Show that the function φ(x) = W (x2 + Lx) is suitable to use in Rayleigh’s method. [2 marks] (b) Using Rayleigh’s method, show that the estimated fundamental natural frequency w0 , in rad/s, is given by the expression: [11 marks] (c) The elastic springs have stiffness Kv equal to 40 kNm-1. The sign has a total length 8L= 8 m, mass per unit length PA equal to 10 kgm-1 and a bending stiffness EI about its neutral axis of 2 MNm-2. Evaluate the estimated fundamental natural frequency in Hz to two decimal places. [3 marks] (d) To avoid a resonance due to the wind loading both springs are repositioned to be at the left-hand end of the beam. Why is this a wrong decision? [2 marks] TOTAL [33 MARKS]
MDM4U- Mathematics of Data Management Activity #1 Census at School Data The data below was collected by Census at School. The data was collected as part of an international educational project in which schools participated voluntarily. The survey was answered by 6,220 elementary and secondary students across Canada during the 2020/2021 school year. The elementary category includes grades 4 to 8 (secondary 2 in Quebec) and the secondary category includes grades 9 to 12 (secondary 3 to 5 in Quebec). 1. Graphing the Data: (a) Consider the data above. Think about what type of data it is? Create appropriate graphs for both questions which accurately represent the data. Be sure to show all of your work. (b) Now try to create a graph for one question which misrepresents the data. 2. Thinking about the Data: (a) Do you think that this data is representative of elementary and secondary students? Why or why not? (b) If the data is not representative, suggest a way to collect the data that would make it more representative. 3. Drawing Conclusions from the Data: (a) Who would want to collect such data? What could this data be useful for? (b) Imagine that you work for the Ministry of Education and that you need to allocate funding for schools. Based on the data above, give an argument to suggest which area or areas the government should fund more.
ECON20532/30532 Macroeconomic Analysis IV Semester 2 2024/24 INSTRUCTIONS SPECIFIC TO THIS EXAM: . Answer both questions. Each question carries the same overall weight. . You should type in your answers, but can include pictures of hand written equations if necessary. . Candidates are expected to demonstrate to the examiners a competent knowledge of all computations. . Candidates are also advised that the examiners attach considerable importance to the clarity with which answers are expressed. . Electronic calculators may be used in accordance with the University regulations. Exam Questions 1. Consider an overlapping generations economy in which capital pays a 10% net rate of re- turn. The population of a generation grows by 10% each period. In the initial period (pe- riod 1), there are 100 young people and a pre-existing fiat money stock of M0 = $900; 000. Because of a political impasse, government expenditures exceed (non-seigniorage) tax rev- enues by 50 goods per young person in every period. Each young person wishes to hold real money balances, denoted q1, worth 200 goods regardless of the rate of inflation. Assume that there is no debt coming into the first period (b0 = 0). (a) Use the government budget constraint to find the rate of fiat money creation that is required to finance the excess of government expenditures over taxes. (20% of total question mark) (b) Find the fiat money stock and the price level in periods 1 and 2. Use these results to verify that the increase in money supply can finance the government deficit. Verify also that the gross rate of inflation is indeed equal to z=n, where z is the growth rate of money and n the growth rate of population. (30% of total question mark) (c) Suppose instead now that in the initial period (period 1), the monetary authority hesitates to print new money, forcing the government to issue debt at the market rate of interest. In the second period, the monetary authority relents, printing enough new money to pay off the debt as well as to pay for the second period's excess of government expenditures over taxes. Find the fiat money stock in period 2 and compare it with your answers in part a. Explain the difference. (35% of total question mark) (d) Using results from point (c), find the price level in period 2 and the rate of ináation between period 1 and period 2. (15% of total question mark) 2. Consider an economy in which there are 1; 000 workers. Each worker is endowed with 200 units of the consumption good when young and nothing when old. Half of the workers consume 60% of their endowment when young, the other half only consume 40% of their endowment when young. Let the (gross) return offiered by banks on deposits be 1.03, but workers need to pay a fixed fee of 3 goods in order to use a bank. Let the stock of fiat money be constant over time, with M = 50; 000. (a) What is the aggregate level of savings in the economy? (20% of total question mark) (b) Write down the money market-clearing condition and compute the price level in this economy. (30% of total question mark) (c) What is the total nominal stock of money (outside plus inside) and what is the aggregate (real) value of fiat money balances in the economy? Why? (30% of total question mark) (d) What would happen to the price level if the rate of return on banks deposit was to increase to 1.05 and banks were to increase the fee from 3 to 5 goods? (20% of total question mark)
ACC102 2nd SEMESTER 2024-25 Assessment of Part B (Financial Analysis) BA Accounting – Year 2 Final · Objective Students will work in groups (4 students per group) to design and implement AI agent(s) that automatically generate the content of a company valuation report. The report must include the same sections as the previous years’ ACC102 assignment: · Introduction and Company Background · Industry Analysis and Corporate Strategy Analysis · Financial Analysis (using financial statements and other public data) · Financial Modelling and Equity Valuation Instead of manually writing these sections, students must develop: · One comprehensive AI agent that can generate all report sections, or · Multiple specialized AI agents where each agent is responsible for one or more specific parts of the report (e.g., data collection, analysis, or visualization). Additional submissions must include: · AI Agent(s) Link: A live link or repository URL where the AI solution can be accessed. · User Manual (in the format of video demo): A detailed guide explaining how to operate the AI agent(s). · Product Report for Investors (in the format of ppt): A concise document targeting potential investors that outlines the AI solution’s capabilities (function), the underlying methodology (detailed prompts and plugins), and key financial insights. The assignments related to the final project are listed as follows. The submission deadline for all the parts is 23:59 pm 25th May 2025. · Assignment Requirements 1. AI Agent(s) Development o Design Options: § A single integrated AI agent that automatically produces the entire company valuation report (including industry and company analysis, financial analysis, and valuation model), or § Multiple specialized AI agents where each one generates a specific section of the report (e.g., one agent for data collection, another for analysis, etc.). o Functional Requirements: § Data Collection: Automate retrieval of financial and non-financial data (e.g., from WRDS, Yahoo Finance). § Data Processing & Analysis: Process the data and perform. financial analysis and modelling. § Visualization: Generate charts and graphs as needed. § Report Generation: Compile the outputs into the standard valuation report format. o Submission: § Provide a functional link (or repository URL) to your AI agent(s). 2. User Manual: o A clear guide detailing how to use the AI agent(s) to generate the results. o Submission: a video demo 3. Product Report for Investors: o A document aimed at potential investors that highlights the AI solution’s benefits (function), its underlying methodology (prompts and plugins), market potential, and the sample valuation report generated by the AI. o Submission: a ppt 4. Peer Review o Each student will complete a confidential peer review to assess individual contributions. o Impact on Mark: 40% of the final individual mark is determined by the peer review scores. Students who do not review their team members will receive a penalty of 50% of their peer review score. o The peer review is based on five criteria, as described in Appendix B. o Example Calculation: If the group receives an 80% for the group assignments (AI Agent(s), User Manual, and Product Report for Investors) and a student’s peer review score is 85%, then the final individual mark is calculated as: Part B Final Mark = (80% * 60% + 80% * 40% * 0.85) * 95% + BMC(Pass:5%, Fail:0) = 71% + 5% if pass BMC or 0% therwise = 76% if pass BMC or 71% otherwise Appendix C describes how peer review scores are derived. · Assessing assignment The total mark for Part B is 100%, and Part B contributes 60% to the final module mark. 95% of the individual’s Part B mark is based on the overall group assignment mark, and 40% of this is adjusted by the peer assessment. 5% of the individual’s Part B mark is based on the BMC certificate. The group assessment will be marked as follows: FAIL 0-39 ADEQUATE 40-49 SATISFACTORY 50-59 GOOD 60-69 VERY GOOD 70-79 EXCELLENT TO OUTSTANDING 80+ · Evaluation Criteria Appendix A is the Assessment form. for the group assessment. The allocation of marks to the group assessment is as follows: Criteria Marks AI Agent Design and Functionality § Effectiveness of automation in generating each section of the report. 15 § Innovation in prompt design and workflow integration. 15 Report Quality and Presentation § Clarity of the AI-generated results. 10 § Structure and the professional presentation of the AI-generated results. 10 Financial Analysis and Interpretation § Depth of financial analysis, and accuracy of financial modelling 10 User Manual § Completeness, clarity, and usability of the user manual. 10 Investor Report § Completeness, clarity, and usability of the ppt 30
FINN3003 Derivative Securities Written Assignment (Individual) Semester 1, 2025 Weight: This assignment is worth 25% of the total assessment for the unit. Refer to the unit guide on Canvas. Total Marks: 25 Due time and date: 11:59pm Sunday, Week 10 Important notes: 1. You need to use the last digit of your student ID to get the correct version of the task requirements in part I. 2. Some students may need to start trading (i.e. collecting futures price information) as soon as Monday 31 March 2025, so it is important that you review the assignment task and get started right away. 3. To perform. simulated trading, you will need regularly collect/keep a record of actual market price information on related derivative securities from the ASX website/FACTSET. You must use the previous (last) settlement price of relevant derivative contract, which is usually listed on the ASX website at the end of the trading day or on the next trading date. Below are the links to pricing information on ASX website: · Trading Prices of Short-term Derivatives on ASX: https://www2.asx.com.au/markets/trade-our-derivatives-market/derivatives-market-prices/short-term-derivativesLinks to an external site. · Bond Derivatives on ASX: https://www2.asx.com.au/markets/trade-our-derivatives-market/derivatives-market-prices/bond-derivativesLinks to an external site. · Index Derivatives on ASX: https://www2.asx.com.au/markets/trade-our-derivatives-market/derivatives-market-pricesLinks to an external site. Submission Instructions: 1. Maximum word length: 1500 words. 2. You need to submit the assignment in PDF/MS Word format, with an assignment cover sheet included, via Turnitin by the due date. 3. In addition, an Excel file with supporting calculations must be submitted online to Assignment_Supporting Excel File link on Canvas by the due date. You will need to include your student ID and your name in the Excel file name (for example, cxxxxxxx_FirstName_LastName). The word file should be a stand-alone report which will be marked. The Excel spreadsheet will also be reviewed. It must be submitted so that your working steps can be checked as required. 4. You may make reasonable assumptions in solving the problem (if necessary). 5. Submission by other means (email/hard copy) or forms (scanned copy) will attract no marks. Penalties: 1. In the case of late submission without an approved extension of time, a penalty of 10% will apply for each day the assignment item is late. 2. Penalties will also apply if academic misconduct is found (refer to the Course Outline for more information). Futures and Options Trading Assignment - Part I and Part II Part I information Part I of the assignment is worth 15 marks. 5 marks will be awarded for performing simulated trading using correct logic and pricing information; and for demonstrating an understanding of speculation strategies using the 90-day bank bill futures contract. 10 marks will be awarded for performing simulated trading using correct logic and pricing information; and for demonstrating an understanding of hedging strategies and evaluation of hedging performance using the SPI200 futures contract. For this part, you need to use the last digit of your student ID to get the correct version of the task requirements set out below. If the last digit of your student number is 1 or 2, your instructions are Set A; if the last digit of your student number is 3 or 4, your instructions are Set B; if the last digit of your student number is 5 or 6, your instructions are Set C; if the last digit of your student number is 7 or 8, your instructions are Set D; and if the last digit of your student number is 9 or 0, your instructions are Set E. To perform. simulated trading, you will need regularly collect/keep a record of actual market price information on related derivative securities from the ASX website/FACTSET. You must use the previous (last) settlement price of relevant derivative contract, which is usually listed on the ASX website at the end of the trading day or on the next trading date. Below are the links to pricing information on ASX website: · Trading Prices of Short-term Derivatives on ASX: https://www2.asx.com.au/markets/trade-our-derivatives-market/derivatives-market-prices/short-term-derivativesLinks to an external site. · Bond Derivatives on ASX: https://www2.asx.com.au/markets/trade-our-derivatives-market/derivatives-market-prices/bond-derivativesLinks to an external site. · Index Derivatives on ASX: https://www2.asx.com.au/markets/trade-our-derivatives-market/derivatives-market-pricesLinks to an external site. Part I instructions You are required to provide a report on all of your trading activity and an Excel file demonstrating all supporting calculations. The following will be your trading instructions over coming weeks: Part I - Set A Trading in the 90-day bank-accepted bill futures contract On Monday 31 March 2025, you will be required to enter into five June 2025 90-day bank-accepted bill futures contracts. You may enter into these contracts as a buyer or as a seller. Whether you enter into these contracts as a buyer or a seller will depend on your expectations as to the likely direction of short-term interest rates. You should state a logical basis for entering into these contracts as a buyer or seller. For example, you might speculate that short-term interest rates are likely to rise or fall. Note that the basis of your speculation is of lesser importance here than is demonstrating that you understand fully the nature of the transactions that you enter into. On Monday 28 April 2025, you must close out your position and do so at the settlement price of the June 2025 90-day bank-accepted bill futures contract. Using the settlement price of the June 2025 90-day bank-accepted bill futures contracts on the days that you trade, detail your financial position after you have entered and evaluate your trading performance. Hedging with the SPI200 futures contract On Monday 31 March 2025, you will be notified that your company has a reasonably broadly based portfolio of Australian shares valued on that date at $70,587,239. You will be required to seek protect the value of that portfolio as the company intends to liquidate the portfolio. You will seek to do this by entering into a number of June 2025 SPI200 futures contracts as either a buyer or a seller. On Monday 28 April 2025, you will be notified that the portfolio of shares has been sold for $75,987,431. The increase in the value of the portfolio was largely due the fact that it was not as broadly based as you had been told, and two companies that formed a large part of the portfolio had been subject to takeover offers during the period. You must now close out your position and do so at the settlement price of the June 2025 SPI200 futures contract. Provide a report how the hedge performed and explain why you could not achieve a perfect hedge. Show all related calculations to demonstrate all relevant factors attributable to an imperfect hedge in this case. Part I - Set B Trading in the 90-day bank-accepted bill futures contract On Monday 31 March 2025, you will be required to enter into six June 2025 90-day bank-accepted bill futures contracts. You may enter into these contracts as a buyer or as a seller. Whether you enter into these contracts as a buyer or a seller will depend on your expectations as to the likely direction of short-term interest rates. You should state a logical basis for entering into these contracts as a buyer or seller. For example, you might speculate that short-term interest rates are likely to rise or fall. Note that the basis of your speculation is of lesser importance here than is demonstrating that you understand fully the nature of the transactions that you enter into. On Tuesday 29 April 2025, you must close out your position and do so at the settlement price of the June 2025 90-day bank-accepted bill futures contract. Using the settlement price of the June 2025 90-day bank-accepted bill futures contracts on the days that you trade, detail your financial position after you have entered and evaluate your trading performance. Hedging with the SPI200 futures contract On Monday 31 March 2025, you will be notified that your company has a reasonably broadly based portfolio of Australian shares valued on that date at $60,587,239. You will be required to seek protect the value of that portfolio as the company intends to liquidate the portfolio. You will seek to do this by entering into a number of June 2025 SPI200 futures contracts as either a buyer or a seller. On Tuesday 29 April 2025, you will be notified that the portfolio of shares has been sold for $65,987,431. The increase in the value of the portfolio was largely due the fact that it was not as broadly based as you had been told, and two companies that formed a large part of the portfolio had been subject to takeover offers during the period. You must now close out your position and do so at the settlement price of the June 2025 SPI200 futures contract. Provide a report how the hedge performed and explain why you could not achieve a perfect hedge. Show all related calculations to demonstrate all relevant factors attributable to an imperfect hedge in this case. Part I - Set C Trading in the 90-day bank-accepted bill futures contract On Monday 31 March 2025, you will be required to enter into five June 2025 90-day bank-accepted bill futures contracts. You may enter into these contracts as a buyer or as a seller. Whether you enter into these contracts as a buyer or a seller will depend on your expectations as to the likely direction of short-term interest rates. You should state a logical basis for entering into these contracts as a buyer or seller. For example, you might speculate that short-term interest rates are likely to rise or fall. Note that the basis of your speculation is of lesser importance here than is demonstrating that you understand fully the nature of the transactions that you enter into. On Wednesday 23 April 2025, you must close out your position and do so at the settlement price of the June 2025 90-day bank-accepted bill futures contract. Using the settlement price of the June 2025 90-day bank-accepted bill futures contracts on the days that you trade, detail your financial position after you have entered and evaluate your trading performance. Hedging with the SPI200 futures contract On Monday 31 March 2025, you will be notified that your company has a reasonably broadly based portfolio of Australian shares valued on that date at $50,587,239. You will be required to seek protect the value of that portfolio as the company intends to liquidate the portfolio. You will seek to do this by entering into a number of June 2025 SPI200 futures contracts as either a buyer or a seller. On Wednesday 23 April 2025, you will be notified that the portfolio of shares has been sold for $55,987,431. The increase in the value of the portfolio was largely due the fact that it was not as broadly based as you had been told, and two companies that formed a large part of the portfolio had been subject to takeover offers during the period. You must now close out your position and do so at the settlement price of the June 2025 SPI200 futures contract. Provide a report how the hedge performed and explain why you could not achieve a perfect hedge. Show all related calculations to demonstrate all relevant factors attributable to an imperfect hedge in this case. Part I - Set D Trading in the 90-day bank-accepted bill futures contract On Monday 31 March 2025, you will be required to enter into six June 2025 90-day bank-accepted bill futures contracts. You may enter into these contracts as a buyer or as a seller. Whether you enter into these contracts as a buyer or a seller will depend on your expectations as to the likely direction of short-term interest rates. You should state a logical basis for entering into these contracts as a buyer or seller. For example, you might speculate that short-term interest rates are likely to rise or fall. Note that the basis of your speculation is of lesser importance here than is demonstrating that you understand fully the nature of the transactions that you enter into. On Thursday 24 April 2025, you must close out your position and do so at the settlement price of the June 2025 90-day bank-accepted bill futures contract. Using the settlement price of the June 2025 90-day bank-accepted bill futures contracts on the days that you trade, detail your financial position after you have entered and evaluate your trading performance. Hedging with the SPI200 futures contract On Monday 31 March 2025, you will be notified that your company has a reasonably broadly based portfolio of Australian shares valued on that date at $40,587,239. You will be required to seek protect the value of that portfolio as the company intends to liquidate the portfolio. You will seek to do this by entering into a number of June 2025 SPI200 futures contracts as either a buyer or a seller. On Thursday 24 April 2025, you will be notified that the portfolio of shares has been sold for $45,987,431. The increase in the value of the portfolio was largely due the fact that it was not as broadly based as you had been told, and two companies that formed a large part of the portfolio had been subject to takeover offers during the period. You must now close out your position and do so at the settlement price of the June 2025 SPI200 futures contract. Provide a report how the hedge performed and explain why you could not achieve a perfect hedge. Show all related calculations to demonstrate all relevant factors attributable to an imperfect hedge in this case. Part I - Set E Trading in the 90-day bank-accepted bill futures contract On Monday 31 March 2025, you will be required to enter into five June 2025 90-day bank-accepted bill futures contracts. You may enter into these contracts as a buyer or as a seller. Whether you enter into these contracts as a buyer or a seller will depend on your expectations as to the likely direction of short-term interest rates. You should state a logical basis for entering into these contracts as a buyer or seller. For example, you might speculate that short-term interest rates are likely to rise or fall. Note that the basis of your speculation is of lesser importance here than is demonstrating that you understand fully the nature of the transactions that you enter into. On Tuesday 22 April 2025, you must close out your position and do so at the settlement price of the June 2025 90-day bank-accepted bill futures contract. Using the settlement price of the June 2025 90-day bank-accepted bill futures contracts on the days that you trade, detail your financial position after you have entered and evaluate your trading performance. Hedging with the SPI200 futures contract On Monday 31 March 2025, you will be notified that your company has a reasonably broadly based portfolio of Australian shares valued on that date at $30,587,239. You will be required to seek protect the value of that portfolio as the company intends to liquidate the portfolio. You will seek to do this by entering into a number of June 2025 SPI200 futures contracts as either a buyer or a seller. On Tuesday 22 April 2025, you will be notified that the portfolio of shares has been sold for $35,987,431. The increase in the value of the portfolio was largely due the fact that it was not as broadly based as you had been told, and two companies that formed a large part of the portfolio had been subject to takeover offers during the period. You must now close out your position and do so at the settlement price of the June 2025 SPI200 futures contract. Provide a report how the hedge performed and explain why you could not achieve a perfect hedge. Show all related calculations to demonstrate all relevant factors attributable to an imperfect hedge in this case. Part II instructions Speculation strategy using a pair of futures contracts In this course, you have learned about different trading strategies that speculate on the price difference between a pair of futures contracts of your choice, namely straddle and spread. In this task, you are asked to employ one of the two strategies and perform. simulated trading using use futures contracts listed and traded on the ASX exchange. You are required to open your trading position in the weeks starting on Monday 7 April 2025 or Monday 14 April 2025 and keep your position open for at least 2 weeks. In any circumstance, you will need to close your position by Fri 2 May 2025 at the very latest. You are required to answer the questions below to demonstrate your understanding of the strategy employed and its practical implementation. Questions to answer 1) Discuss the nature of the trading strategy used? (1 marks) 2) Provide reasoning for your speculation of expected movements in the price/price difference of the pair of contracts? You should provide an analysis of relevant information/data to support your argument. (2 marks) 3) Discuss the logical basis for your trading position? (2 marks) 4) Using the settlement price of the relevant futures contracts on the ASX on the days that you trade, detail your financial position and evaluate the performance of your trading strategy. Provide reasoning for the profit/loss generated from your trading strategy. (5 marks)
