This activity will help you meet these educational goals:

Content Standards: You will learn about data formatting options in a spreadsheet.
21st Century Skills: You will use critical thinking and problem-solving skills to create a worksheet to display data.
Directions
Read the instructions for this self-checked activity. Type in your response to each question, and check your answers. At the end of the activity, write a brief evaluation of your work.

Activity
In this activity, you will use the data formatting options of a spreadsheet program.

Part A
Using a spreadsheet program of your choice, create a worksheet to display the following data.

Serial Number Name of Student Physics Chemistry Mathematics Computer Science Total Score
1
James
56
78
60
91
285
2
Susan
75
54 77 82 288
3
Sally
45
43
55
66
209
4
Tyson
80
88
74
70
312
5
Sam
78
65
56
58
257
6
June
67
48
55
59
229
7
Timothy
72
67
78
88
305
8
Jason
49
50
56
60
215
9
Sarah
50
67
77
60
254
10
Peter
76
89
93
70
328
11
Janet
91
80
75
79
325
12
Jennifer
48
59
66
70
243
13
Thompson
87
95
98
80
360
14
Laura
95
85
78
76
334
15
Rachael
84
73
88
77
322
16
Emanuel
84
57
68
71
280
17
Justin
54
65
71
60
250