Create a file in excel that describes a grading system

Assignment Help Mathematics
Reference no: EM131221263

Assignment #1

Submit your spreadsheet(WorkBook that contains the following parts of this assignment) to BlackBoard using the following file name format: LastNameFirstNameA1 i.e. if your name appears as Phuong Thanh on Black Board, then your workbook file name must be PhuongThanhA1.xlsx, Phuong being your last name or family name and your other name on Black Board is Thanh.

You are required to follow the rule below in your model:

• Separate numbers from formulas

There are two questions. You need to turn in one Excel workbook with two worksheets, one for each question. Name the first worksheet as Q1 and the 2nd as Q2.

Q1

1.Create the worksheet (shown at the end of this document).

2.Add yourself and two more employees to the spreadsheet (include hours worked and level).

3. Based on each person's level use nestedIF function to calculate Hourly Wage:

Level

Hourly Wage ($)

1.0~1.9

16.00

2.0~2.5

22.00

2.6~2.9

29.00

3.0 or higher

36.00

Levelis a value that has one decimal place.

Note: manually entering hourly wages in the "Hourly Wage" column will receive 0 for the whole assignment.

4.Fill in the Gross Pay column by using a formula which multiplies the Hours Worked times the Hourly Wage.

5.Using the built-in function 'sum', calculate the total gross pay.

Name

Hours

Level

Hourly Wage

Gross Pay

Lachance

40.5

1.1

 

 

Warner

39.5

3.2

 

 

McKaig

27.75

2.7

 

 

Shaw

38

3.5

 

 

Brooksbank

29

3.2

 

 

Darrach

15

1.2

 

 

Ruypers

14.75

2.1

 

 

 

 

 

Totals:

 

6.Sort the employees into alphabetical order.

7.Be sure your name is on the spreadsheet.

Q2. Short Description:

Spreadsheets are useful for many other things besides financial tasks, such as progress reports and for keeping track of descriptive data. For this assignment, you will create at least one table and an accompanying graphic visual that will help you write functions and learn simple programming techniques using advanced Excel features.

Requirements:

General

- Create a file in Excel that describes a grading system for a class.

Technology Features - Your results will include:

- One Excel worksheet with appropriately labeled worksheets.

- The correct formulas are important and will be graded.

Content

1 You should create a table on a worksheet titled "class list" that includes the names and test scores of your students. You have 7 students in your class, their names are: Allen, Borlin, Catlin, Dorsey, Eugene, Finneran, and Greco.

2 Also include your name to the list and scores on the first 3 tests are as follows:


Test 1

Test 2

Test 3

Allen

94.8

82.1

93

Borlin

67

56

66

Catlin

81.2

79.3

79.4

Dorsey

56

34

45

Eugene

85.5

100

99.4

Finerran

98

98

97

Greco

78

87

88

Yourname

*

*

*

(*) enter your scores here

Tasks

1) Using an Excel function, show each student's average in an additional column labeled "Average"

2) Using an Excel function, show each student's rounded average in an additional column labeled "Rounded Average" rounded to one decimal place. Make sure you round the value using the round function rather than format the value.

3) If a student's rounded average is 95 or above, he/she has received "honors" in the class. In an additional column titled "Honors", insert a function that will return the word "Yes" if they have received honors, otherwise would return the word "No".Make sure you put 95 in a cell, and in your formula you use the cell reference rather than value 95.

4) If a student's rounded average is 90 or greater, they receive an "A". Between 80 and 89.99 is a "B", between 70 and 79.99 is a "C", between 60 and 69.99 is a "D", and lower than 60 is an "F". Somewhere on your sheet, enter this information in cells. Create an additional column titled "Grade" and insert a nested IF function that returns the appropriate grade for each student. Use an absolute cell references in your nested IF function to indicate each cut-off point between grades. Hint: You will need to place the "cut-off grade" values in cells somewhere on your worksheet (for example, in range J2:J7 as shown in figure above) and use cell references such as J2 rather than values such as 90.You will lose at least 50% of the scores for nested IF function if you use values directly in the functions.

- Your work sheet should look like the figure above (but should be different as your table includes your scores).

A

B

Test 1

C

Test 2

D

Test 3

E

Avenge

F

G

H

Rounded

Average

Honors

Grade

Allen

94.8

82.1

93

89.97

90.0

No

B

Borlin

67

56

66

63

63.0

No

D

Catlin

81.2

79.3

79.4

79.96667

80.0

No

B

Dorsey

56

34

45

45

45.0

No

F

Eugene

85.5

100

99.4

94.96667

95.0

Yes

A

Finerran

98

98

97

97.66667

97.7

Yes

A

Greco

78

87

88

84.33333

84.3

No

B

John

77

88

82

82.33333

82.3

No

B

Reference no: EM131221263

Questions Cloud

Tremendous capital investment required to enter industry : Exxon/Mobil and Shell are two of the relatively few sellers in the oil-refining industry. Due to the tremendous capital investment required to enter this industry, these companies are insulated significantly from the threat of new competitive entr..
Examples of inelastic products that you have purchased : When looking at a business, you will find that we are focused on how much consumers are willing to spend on each product. We do this through the use of elasticity. What are examples of inelastic products that you have purchased?
Code an sql script to populate the wpc department : Code an SQL Script to populate the WPC DEPARTMENT and EMPLOYEE tables in the WPC-CH10-PQ database. Run your script to populate the tables.
Problems of creating information technology plans : About the problems of creating information technology plans that work within the scope of the organization''s strategic objectives. It is also about all the reasons why this is a very difficult thing to do, particularly when the process gets down ..
Create a file in excel that describes a grading system : Using an Excel function, show each student's rounded average in an additional column labeled "Rounded Average" rounded to one decimal place. Make sure you round the value using the round function rather than format the value.
Absolute advantage in producing both products : Two women, Michelle and Tracy, are stranded on an island. Michelle can catch 8 fish per hour or gather 10 coconuts per hour. Tracy can catch 10 fish per hour or gather 40 coconuts per hour.
Create test data and demonstrate that your trigger works : Code an SQL Server trigger named Allow_Deletion_Of_DEPARTMENT to allow the deletion of a department if it only has one employee. Assign the last employee to the Human Resources department. Create test data and demonstrate that your trigger works.
Jeffrey utility depends on the amount of time spent : Suppose Jeffrey's utility depends on the amount of time spent watching You Tube videos (Y) and theamount of time playing video games (V), and his utility function is equal to
Equation for this constrained maximization problem : Luke only consumes strawberries (S) and turnips (T) each week with his $36 income. The price of strawberries is PS = $3/basket, while the price of turnips is PT = $1.50/turnip. Luke's preferences are given by the following utility function

Reviews

Write a Review

Mathematics Questions & Answers

  Questions on ferris wheel

Prepare a Flexible Budget Gator Divers is a company that provides diving services such as underwater ship repairs to clients in the Tampa Bay area.

  Logistic map

This assignment has two question related to maths. Questions are related to bifurcation cascade and logistic map.

  Finding the probability of cards

This assignment has questions related to probabiltiy.

  Systems of ode

Find all the xed points, and study their stability and Draw the phase portrait of the system, as well as the graphs of the solutions in all relevant cases.

  Derive the boolean expression

Derive the Boolean Expression and construct the switching circuit for the truth table stated

  System of equations

Evaluate which equations are under-identified, just-identified, and over-identified.

  Linear programming problem

Linear programming problem consisting of only two constraints with one objective function.

  Find the natural domain

Find the natural domain of the given functions.

  Introduction to numerical methods

Compute the coecients of the polynomials using the term recurrence relation.

  Chart of the topological manifold

De?nition of smoothness of functions on a smooth manifold is chart independent and hence geometric.

  Mathematics in computing

Questions related on mathematics in computing.

  Complex problems

Complex problems

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd