For the data set shown below, complete parts (a) through (d) below. x y 20 102 30 95 40 91 50 81 60 68 ​(a) Use technology to find the estimates of beta 0 and beta 1. beta 0 ~ b 0=_____​(Round to two decimal places as​ needed.) beta 1 ~ b 1=_____(Round to two decimal places as​ needed.) (b) Use technology to compute the standard error, the point estimate for o' (o with a little tag on the top) S e =_____(Round to four decimal places as needed.) (c) Assuming the residuals are normally distributed, use technology to determine Sb1 Sb1 =_____ (Round to four decimal places as required) (d) Assuming the residuals are normally distributed, test H0: B1 =0 versus H1:B1 =/ at the a = 0.005 level of significance. Use the P - value approach. The P - value for this test is _____ (Round to three decimal places as needed.

Question 1 [20 marks]

Clearly explain the following terms, highlighting areas of their use or application in technology:

a. Supercomputer

b. Mainframe Computer

c. Microcontroller

d. Microcomputer

Question 2 [20 marks]

2.1 For the following networking equipment, explain each in a manner which clearly distinguishes it from the rest, where possible giving advantages and disadvantages. Data Connections

a. Hub

b. Router

c. Switch

The Internet

2.2 Explain the following terms in a manner which shows the particular difference, if any between them.

a. Internet

b. World Wide Web

Question 3 [20 marks]

Write a short essay about the very integral concept of miniaturization in Information Technology highlighting the advantages and disadvantages, if any that the concept has brought along into the domain of Information Technology. You may include issues of speed, affordability and access to other technological innovations occasioned by miniaturization.

Ch. 16 1. Read the following scenario and answer the question in 5-10 sentences. You are the president of a HumTech, a technology consulting company, and have received some startling news. Richard is one of your information technology supervisors. You learn that Richard has been emailing Brenda, an information technology technician who reports to him, pornographic photos and sexually-directed jokes. Brenda told Richard to stop, but Richard continued to send the emails to Brenda. In response to Richard's conduct, Brenda abruptly quit and filed a claim with the Equal Employment Opportunity Commission. Preventing sexual harassment has been a major priority for you, and you have established extensive complaint procedures, dispute resolution mechanisms, and sexual harassment prevention policies. You are surprised that Brenda didn't use these resources before seeking legal redress. Evaluate whether your company may be held liable for Richard's conduct.

This is a study on minimum wage and poverty thresholds.  I have included the procedure for one year, 2009, below.  You will calculate all variables for all years 1968 – 2013.  You will have three graphs.  Check the attached excel data sheet to see what info. you already have.  You will need to calculate a few variables for each year.  Use the excel data sheet to do quick and easy cut and paste formulas.  If you need help, or are hyperventilating now, just drop me a line or come by the office.     JB

Step 1. Start off by using the 2009 and 2010 data.  You have this data on the excel data sheet:

1. Minimum wage/Nominal minimum wage (NMW)
2. Consumer Price Index (CPI) Use CPI-U for Urban Consumer, annual average
3. Poverty level income threshold for a household of 2 (H2)
4. Poverty level income threshold for a household of 4 (H4)

(NMW, H2 and H4 are nominal variables)

5. You must calculate this one.  CPI in hundredths = CPI/100. Divide all nominal values by CPI in hundredths to convert nominal values to real values.

Step 2. Convert nominal minimum wage (NMW) to real minimum wage (RMW).  

Minimum wage (NMW) from data source in 2009 = $______, the CPI for 2009 = ______

Formula 1:  RMW= NMW/CPI in hundredths

                                _____________ for 2009

Step 3. Calculate yearly percent change in RMW (PP). % chg PP represents annual percent change in purchasing power.

Formula 2: % chg PP from 2009 to 2010:

= (RMW in 2010–RMW in 2009)/RMW in 2009) x 100, = _____________________; an       (increase or decrease) in purchasing power.

Step 4. Calculate the yearly percentage change in the CPI (INFLT). INFLT represents annual percent change in inflation.

Formula 3: INFLT from 2009 to 2010:

                      = (CPI₂₀₁₀ – CPI₂₀₀₉/ CPI₂₀₀₉ x 100;       

                      = (CPIY₂₀₁₁ – CPI₂₀₁₀)/ CPI₂₀₁₀ x 100;     

                        = __________________, an (increase or decrease) in inflation from 2009 to 2010

Step 5. Graph 1. For every year, graph % chg in PP and Inflation (INFLT) on the same graph. Title of graph should be Trend in Purchasing Power and Inflation for Selected Years    

Step 6. Calculate real annual income 1(INC1):  RMW x 40 hours per week x 50 weeks per year.

Formula 4:    INC1 for 2009 = ______________, H2 =________ , this is a nominal value

Formula 5:   Convert to real value (RH2) = h2/CPI (2009) in hundredths = _______________

Shari Patel of the controller's office of Sheridan Corporation was given the assignment of determining the basic and diluted earnings per share values for the year ended December 31, 2020. Patel has gathered the following information.

1.The company is authorized to issue 8 million common shares. As at December 31, 2019, 2 million shares had been issued and were outstanding.2.The per share market prices of the common shares on selected dates were as follows:

Price per Share July 1,

2019 $18.00 Jan. 1,

2020 22.00 Apr. 1,

2020 24.00 July 1,

2020 13.00 Aug. 1,

2020 8.50 Nov. 1,

2020 8.00 Dec. 31,

2020 9.00

3.A total of 800,000 shares of an authorized 1.2 million convertible preferred shares had been issued on July 1, 2019. The shares were issued at $25, and have a cumulative dividend of $2 per share. The shares are convertible into common shares at the rate of one convertible preferred share for one common share. The rate of conversion is to be automatically adjusted for stock splits and stock dividends. Dividends are paid quarterly on September 30, December 31, March 31, and June 30.4.Sheridan Corporation is subject to a 30% income tax rate.5.The after-tax net income for the year ended December 31, 2020, was $11,600,000.

The following specific activities took place during 2020:

1.January 1: A 5% common stock dividend was issued. The dividend had been declared on December 1, 2019, to all shareholders of record on December 29, 2019.2.April 1: A total of 400,000 shares of the $2 convertible preferred shares were converted into common shares. The company issued new common shares and retired the preferred shares. This was the only conversion of the preferred shares during 2020.3.July 1: A 2-for-1 split of the common shares became effective on this date. The board of directors had authorized the split on June 1.4.August 1: A total of 600,000 common shares were issued to acquire a factory building.5.November 1: A total of 21,000 common shares were purchased on the open market at $8 per share and cancelled.6.Cash dividends to common shareholders were declared and paid as follows:

April 15:$0.30per shareOctober 15:$0.20per share

7. Cash dividends to preferred shareholders were declared and paid as scheduled.

Determine the number of shares to use in calculating basic earnings per share for the year ended December 31, 2020.

Number of shares

Enter your answer in accordance to the question statement

shares

Determine the number of shares to use in calculating diluted earnings per share for the year ended December 31, 2020.

Number of sharesEnter your answer in accordance to the question statement

shares

Calculate the adjusted net income amount to use as the numerator in the basic earnings per share calculation for the year ended December 31, 2020.

Adjusted net income$

Enter your answer in accordance to the question statement

You are a financial planner for Kelly Roberts. Kelly has just started a new job as an IT programmer for the Australian government. They will pay her a salary of AUD$70,000 p.a. She expects her salary to grow at 3% p.a. each year based on previous data. Inflation in Australia is 1%. After a detailed discussion, she has decided that she will deposit 20% of her salary by automatic withdrawals: half into a TFSA; half into a taxable account. The income on the TFSA is never taxed. The income in the taxable account is taxed at 35% p.a. She is an aggressive investor who expects a nominal annual return of 8% p.a. on both accounts.

a) Calculate the following amounts after 8 years, all payments made at year end.

1. The nominal value in the TFSA
2. The after-tax nominal value in the taxable account

b) Explain to Kelly, using calculations, whether inflation is a major concern for her investments or not.

c) Explain to Kelly two assumptions you have made in your calculations and explain two examples which would make your calculations inaccurate.

In response to question 4.2 from the textbook, demonstrate your understanding of the differences in the design, applications, and usage of the relational database as compared to the use of spreadsheets.

Question 4.2 Most DBMS packages contain data definition, data manipulation, and data query languages. For each of the following, indicate which language would be used and why. A database administrator defines the logical structure of the database. The controller requests a cost accounting report containing a list of all employees being paid for more than 10 hours of overtime in a given week. A programmer develops a program to update the fixed-assets records stored in the database. The human resources manager requests a report noting all employees who are retiring within five years. The inventory serial number field is extended in the inventory records to allow for recognition of additional inventory items with serial numbers containing more than 10 digits. A user develops a program to print out all purchases made during the past two weeks. An additional field is added to the fixed-asset records to record the estimated salvage value of each asset.

16. A developer of video game software has seven proposals for new games. Unfortunately,
the company cannot develop all the proposals because its budget for new projects
is limited to $950,000, and it has only 20 programmers to assign to new projects.
The financial requirements, returns, and the number of programmers required by each project are summarized in the following table. Projects 2 and 6 require specialized
programming knowledge that only one of the programmers has. Both of these
projects cannot be selected because the programmer with the necessary skills can be
assigned to only one of the projects. (Note: All dollar amounts represent thousands.)
Project Programmers Required Capital Required Estimated NPV
1 7 $250 $650
2 6 $175 $550
3 9 $300 $600
4 5 $150 $450
5 6 $145 $375
6 4 $160 $525
7 8 $325 $750
a. Formulate an ILP model for this problem.
b. Create a spreadsheet model for this problem and solve it.
c. What is the optimal solution?

In parallel computing, what is the meaning of “skew”?

Select one:

a. The number of operations in one of the parallel processors starts increasing exponentially.

b. In the distribution of work among the processors, some processors are getting a larger number of tuples than others.

c. One of the parallel processors overheats and in a chain reaction the same happens to all other processors.

d. One parallel processor runs hotter than the others.

e. The number of operations rises beyond reasonable limits.

What operation is responsible for the retrieval of information from a database in a transaction schedule?

Select one:

a. Get

b. Pull

c. See

d. Read

e. Retrieve

Logical, physical and view levels are elements of the model of…

Select one:

a. Entity Relationship (ER)

b. Data Abstraction

c. Domain Model Language (DML)

d. Domain Object Model (DOM)

e. Backup and Recovery

Which of the following is NOT commonly understood as a type of database user?

Select one:

a. Naïve user

b. Sophisticated user

c. Specialized user

d. Native user

e. Application programmer

Topic 1

TRUE OR FALSE Q's

1.            Computer software is the collection of programs that provide the instructions that a computer carries out.

2.            An abstraction is a mental model that removes or hides complex details.

3.            The abacus was the world's first electronic digital computer.

4.            Ada Augusta, Countess of Lovelace, is credited with being the first programmer.

5.            A vacuum tube was a device used in the third generation of computers.

6.            The fourth generation of computer hardware was characterized by large-scale integration.

7.            The personal computer was introduced in the fourth generation of computer hardware.

8.            The Internet is descended from a U.S. government-sponsored network called the ARPANET.

9.            Assembly-language is first generation software.

10.          Earliest machine programs were hard wired.

11.          Algorithmic thinking is a necessary skill in Computer Science.

12.          Computational Science is one of the Systems areas.

13.          Spreadsheets and word processors are known as software applications.

14.          Applications programmers use the tools built by systems programmers.

15.          An algorithm is a set of steps that defines how a task is performed.