Category: Uncategorized

Exam Instructions The exam consists of 11 questions worth a total of 225 points. Point allocations are shown. The exam is 3 hours long. NO late submissions! NO exceptions! NO excuses. NO “I had” technical difficulties.” The exam is open course lecture notes, which means Professor Wasley’s lecture notes ONLY. NO other sources are allowed. You MUST answer the exam questions directly on BB. Your answers to the calculation-oriented questions must be entered into the Excel file on BB. For ALL calculation-oriented questions, the cells in the Excel file MUST show ALL of your work. ALL OF THE STEPS/NUMBERS USED TO GET YOUR ANSWER. IF YOU DO NOT SHOW YOUR WORK, YOU WILL NOT EARN FULL CREDIT, OR PARTIAL CREDIT, BECAUSE THE GRADER MUST BE ABLE TO VERIFY YOUR WORK. To be clear, to potentially receive partial credit you MUST show ALL of your work. The grader cannot assign any credit if you do not show your work. Under NO circumstances does the grader attempt to infer what you did. The grader cannot grade what you don’t show.  At the end of the exam, you will submit your Exam Excel file answer sheet. Exam’s Excel File: (required for exam) Exam Excel File..xlsx

After we excecute a SQL statement, when must we get back a result set and loop through that result set?  

(If you like, you can enter your answer to Q10 in the Exam’s Excel file.)Verify that YY36’s forecasted Depreciation and Amortization (D&A) of $3,748.2 reported in the Income Statement was correctly calculated. (15 points) 

What is the parent class of FileNotFoundError?

Assume we have the following code.  What should the missing statement be? i = int(input(“Enter the isbn you wish to update: “))p = float(input(“Enter the new price: “))sql = “update book set price = ? where isbn = ?” # insert missing statement here db_cursor.execute(sql, tuple_of_values)  

What is true about the code below?       def __str__(self):        print(“{:s} {:s}”.format(self.fname, self.lname))

When we wrote a Python program that worked with a database, we performed “sql binding”.  What is it?

After which of these database commands should do a commit? 

(If you like, you can enter your answer for Q5 in the Exam’s Excel file.)Ignore the earlier valuation calculations you performed in the exam. If P&G’s estimated common stock price on the valuation date was $54.33:a) What target price would you place on P&G’s common stock one year out from the valuation date? (7 points)b) How many shares of common stock is P&G forecasted to repurchase or issue (be sure to state which) in YY31 (3½ points)c) What ANNUAL EPS forecast would you make for YY31? (4½ points)

Assume we have the following transfer_from method:       def transfer_from(self, amount, to_account):        self.withdraw(amount)        to_account.deposit(amount)   In the main function, assume we have the code below.  If we want to transfer 100.00 from acct2 to acct1, what new statement should we write?       acct1 = BankAccount(123, ‘Joe’, ‘Smith’)     acct1.deposit(500.00)     acct2 = BankAccount(234, ‘Jane’, ‘Doe’)     acct2.deposit(500.00)