You are required to set up a mark sheet that calculates the final grade (in
percent) for all the students (20 of them) of a computer class.
You will be given all the data needed to do all the calculations.
also be given some other requirements that you must satisfy.
You will
Here is a breakdown of all the evaluations for this course:
Evaluation
Value
Maximum Score
Assignment #1
5%
20
Assignment #2
5%
20
Assignment #3
5%
20
Quiz #1
10%
20
Quiz #2
10%
30
Quiz #3
10%
50
Mid-Term Exam
25%
100
Final Exam
30%
100
Total
100%
After you have entered all the data values and completed all the
calculations, you are also required to format the spreadsheet to make it
look presentable.
You will also be required to create a few charts to
explain some of the critical calculations.
You will find all the data values on the next page.
Student Data:
Student
Number
Student
300456789
Name
A#1
A#2
A#3
Q#1
Q#2
Q#3
MT
Final
Smith, John
18
19
17
18
27
44
78
82
301902348
Watson, Tom
14
16
15
15
23
46
65
75
300196359
Adams, Sandra
17
17
18
16
21
40
73
70
300428736
Lock, Joe
19
20
19
19
26
45
84
78
301200084
Rawson, Tony
12
13
14
13
20
39
66
70
301603782
Green, Randy
20
19
19
19
26
42
70
65
301402178
Matthews, Sam
20
20
19
20
28
48
91
84
300604186
Parker, Sally
18
17
17
16
24
43
89
81
300777265
Larson, Joyce
16
19
17
18
27
46
88
85
300819025
Mitchell, Ann
11
14
15
14
21
39
78
76
300330618
Bullock, Mike
19
19
17
17
25
42
84
79
301094682
Cordova, Gina
16
17
18
18
25
43
80
71
301554903
Thompson, Jill
18
18
17
19
29
46
81
70
301429075
Brown, Walter
19
18
16
16
24
45
90
84
301802194
Dobson, Cindy
20
19
18
19
25
43
85
80
300552288
Hill, Maggie
17
20
17
16
23
41
87
79
300990012
White, Andy
18
19
17
18
22
40
79
69
301356820
Iverson, Jim
15
14
16
15
20
40
79
68
301902489
King, Nina
19
17
15
16
21
38
70
66
300110595
Young, Jessica
20
20
19
20
27
46
90
90
INSTRUCTIONS:
(*) Use COURIER NEW 12 as the font.
1) Put down the label ¥port Date:)n A1. Set up the report date in B1 by
using a built-in function. This system date will change everyday.
2) Enter the label ÐSC100 – SECTION 1
any formatting.
MARKS REPORT)n A3 before you do
3) Enter the label !te of Marks Received:)n A5.
4) In A6, enter the built-in function to show the date February 28, 2023
before any formatting.
5) Enter all the labels as shown in the suggested solution for Part 1.
6) The first row of data values will start in Row 11.
7) All the student numbers are LABELS.
8) The column widths are as follows:
Columns A, B: 21
Columns C to H: 8
Columns I, J: 10
Column K: 12
9) All the formulas for the final percentage calculation MUST use ABSOLUTE
CELL REFERENCE.
10)
Use built-in functions for all the statistical calculations.
11)
Use YOUR FULL NAME as the footer.
12)
Format the spreadsheet according to the suggested solution. Save this
file and call it MARKS
13)
All the spreadsheet reports will be displayed in LANDSCAPE FORMAT and
they are all ONE-PAGE reports. You are NOT allowed to use ©t to 1
page&unction or scaling to reduce the font size in the reports.
ITEMS TO BE SUBMITTED:
1) Submit the original spreadsheet called MARKS (similar to the suggested
solution) in LANDSCAPE FORMAT. This report is ONLY 1 page long. This is
Part A of the assignment. Submit this file online.
2) Display the cell formulas (in formula view) for the original spreadsheet
in Part A. It can be in Portrait or Landscape format. Save this file as a
PDF file and call it FORMULAS This is Part B of the assignment. Submit
this file online.
3) Change the following data values:
Quiz #1: 5%
Quiz #2: 5%
Mid-term: 30%
Final: 35%
Display the modified spreadsheet in LANDSCAPE FORMAT. This report is ONLY
1 page long. Name this file MODIFIED This is Part C of the assignment.
Submit this file online.
4) Create THREE charts of different types. Use the data from Part 1 or Part
3 to create the charts. Each chart MUST be a meaningful chart as per the
class discussion. Save these charts on a worksheet in the MARKS file. Name
this worksheet as CHARTS This is Part D of the assignment.
5) Your assignment MUST include a title page that contains your name,
course name and number, section number, instructor’s name, assignment
name and the due date. Your assignment will NOT be graded until you
have submitted a title page WITHIN 5 calendar days after the
instructor has informed you of the missing title page file via
Blackboard.
MARKING SCHEME/CRITERIA
This assignment is out of 60 MARKS. Here is the allocation of the marks:
orrect Formulas: 25 marks
ell Formatting: 12 marks
roper Footer: 5 marks
ata Entry: 3 marks
hart: 5 marks each
ach spelling mistake is 1 mark off.
OTHERS:
1) You will lose 5 MARKS for naming a file incorrectly.
2) You will lose 3 MARKS for using extra columns to do the spacing.
3) You will lose 3 MARKS for shrinking the font size or scaling to make the report
fit on 1 page.
4) You will lose 5 MARKS for using UNNECESSARY built-in functions to waste memory.
5) You will lose 5 MARKS for creating a chart that is not meaningful.
6) 2 BONUS MARKS will be given to a student who submits a perfect title page with
all the correct information and no spelling mistakes.

Purchase answer to see full
attachment