5) The results are categorise as Merit, Pass or Fail. Explain how you will determine whether a student has achieved a Merit, a Pass or a Fail. Your answer should include cell references to indicate the cells where the calculations will be done, the cells that will be required for the calculations, and the formula to be used. Use Microsoft Excel to test your explanations.

5) The results are categorise as Merit, Pass or Fail. Explain how you will determine whether a student has achieved a Merit, a Pass or a Fail. Your answer should include cell references to indicate the cells where the calculations will be done, the cells that will be required for the calculations, and the formula to be used. Use Microsoft Excel to test your explanations.

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter3: The Relational Database Model

Section: Chapter Questions

Problem 25P: Create the ERD. (Hint: Look at the table contents. You will discover that an AIRCRAFT can fly many...

See similar textbooks

Similar questions

Create an ERD for the given scenarios. Thank youu!! Each publisher has a unique name; a mailing address and telephone number are also kept on each publisher. A publisher publishes one or more books; a book is published by exactly one publisher. A book is identified by its ISBN, and other attributes are title, price, and number of pages. Each book is written by one or more authors; an author writes one or more books, potentially for different publishers. Each author is uniquely described by an author ID, and we know each author’s name and address. Each author is paid a certain royalty rate on each book he or she authors, which potentially varies for each book and for each author. An author receives a separate royalty check for each book he or she writes. Each check is identified by its check number, and we also keep track of the date and amount of each check. As you develop the ERD for this problem, follow good data naming guidelines.
PLEASE SHOW HOW YOU WOULD WRITE YOUR DATA IN THE EXCEL SHEET AND SHOW THE FORMULAS TOO. IT WOULD BE BETTER IF YOU JUST SHOW IT IN PICTURE INSTEAD OF TYPING IT PLEASE.
Please show all steps in excel, thank you! Let’s mirror Exercise 2 from the Topic 3, Set 1 notes, except that we’ll calculate the semester GPA from a student taking four classes: 1. First get the user’s name. 2. Then ask for the expected grade (as a number, i.e., A = 4.0, A− = 3.7, B+ = 3.3, B = 3.0, etc.) in the first class. 3. Repeat Step 2 three times (for each of the other classes). Be sure to repeat the user’s name in each of these input boxes. 4. Have the results box provide the user’s name and the GPA for the semester (i.e., add the four entered numbers together and divide by 4).
When creating formulas and models in Microsoft Excel, what kinds of problems and hazards do users often run into?
1. Retrieve the names of employees who work on the ‘Newbenefits project. 2. Retrieve name and salary of all male employees who have dependents3. Retrieve name of all department managers
Create an ERD based on the Crow’s Foot notation with Microsoft Visio, using the following business rules or requirements: An INVOICE is written by aSALEREP. Each sales representative can write many invoices, but each invoice is written by a single sales representative. The INVOICE is written for a single Customer. However, each customer can have many invoices. An INVOiCE can include many detail lines (LINE), each of which describes one product bought by the customer. The product information is stored in a PRODUCT entity. The product's vendor information is found in a VENDOR entity.
Which of the following facets of the programme are frequently tested using black box testing? Please check all that apply. Usability and functionality Compatibility with Non-Functionality
Which of the following are true about 'test data approach'? Select the three options that are correct. a. Test data must be representative of the conditions the auditor wants to test b. Test data must be removed from the client’s records. c. Test data should be selected from only one specific period throughout the year being audited. d. Application programs tested by the auditor must be the same as used by the client throughout the year
answer the following questions about excel and formulas __________________3. The area of the excel window in which you enter and edit data. __________________4. Display the cell address of the active cell. __________________5. This is the horizontal bar that contains various buttons or icon as shortcuts to the different commands. __________________6. Displays the contents of the active cell. __________________7 . The bar which is positioned immediately above the window taskbar at the bottom of the screen. __________________8. A box in which you can enter a single piece from an array of data. __________________9. Made up of rows and columns just like a ledger sheet. _________________10. Various menus that provide access to different commands.
B. Please complete the following question. Make sure you are responding to all parts of the question and show all your work. As a tip let the marks assigned be a guide as to how much information is required to respond. The attached datafile awards_data.csv contains two variables: the type of program [prog] in which the student was enrolled (i.e., general, academic, or vocational) and the score on their final exam in math [math]. Use α = .05 for all analyses. 1. Use the information about the variables to develop a research question for a one-way ANOVA and conduct the analysis. Are the assumptions met? Please include the appropriate statistics or information to support your answer. What do you conclude? Present your answer in APA.
Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
Excel 2016 by Microsoft has several improved features. Tell me, what do you find to be the most helpful function in Excel 2016? Potentially, a brief summary of the advantages you may expect to get from using it will be provided.

SEE MORE QUESTIONS

Recommended textbooks for you

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:

9781337508841

Author:

Carey

Publisher:

Cengage

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:

9781337508841

Author:

Carey

Publisher:

Cengage

SEE MORE TEXTBOOKS