LANJUTAN PRAKTIKUM MICROSOFT EXCEL_MUHAMMAD SYAFEI DZULFADHLI.xlsx

	B	C	D	E	F	G	H	I
1	PRAKTIKUM MICROSOFT EXCEL
2
3	LATIHAN 1
4
5	No	Nama	Nilai Ujian			Rata-Rata Nilai
6	No		Matematika	B. Indonesia	B.Inggris	Rata-Rata Nilai
7	1	Ahmad	80	81	87	82.667
8	2	Bambang	86	80	88	84.667
9	3	Joko	84	82	89	85
10	4	Widodo	82	86	81	83
11	5	Ara	83	89	79	83.667
12	6	Juna	87	92	80	86.333
13	7	Putri	88	91	86	88.333
14	8	Febri	89	87	83	86.333
15	9	Atiqah	81	80	78	79.667
16	10	Edi	79	90	90	86.333
17	11	Hari	80	92	80	84
18	12	Agus	86	93	90	89.667
19	13	Alicia	83	94	92	89.667
20	14	Bagus	78	86	93	85.667
21	15	Dani	90	85	85	86.667
22	16	Akbar	75	82	80	79
23	17	Dimas	77	88	82	82.333
24	18	Wawan	80	93	80	84.333
25		Jumlah	1488	1571	1523
26		Rata-rata	82.667	87.278	84.611
27
28
29	LATIHAN 2
30
31	No	Nama	Nilai Ujian				Nilai Akhir
32	No	Nama	Kehadiran (5%)	Tugas (15%)	UTS (35%)	UAS (45%)	Nilai Akhir
33	1	Ahmad	100	80	81	87	84.5
34	2	Bambang	100	86	80	88	85.5
35	3	Joko	100	84	82	89	86.35
36	4	Widodo	90	82	86	81	83.35
37	5	Ara	80	83	89	79	83.15
38	6	Juna	90	87	92	80	85.75
39	7	Putri	100	88	91	86	88.75
40	8	Febri	100	89	87	83	86.15
41	9	Atiqah	100	81	80	78	80.25
42	10	Edi	100	79	90	90	88.85
43	11	Hari	100	80	92	80	85.2
44	12	Agus	100	86	93	90	90.95
45	13	Alicia	100	83	94	92	91.75
46	14	Bagus	100	78	86	93	88.65
47	15	Dani	100	90	85	85	86.5
48	16	Akbar	100	75	82	80	80.95
49	17	Dimas	95	77	88	82	84
50	18	Wawan	100	80	93	80	85.55
51		Jumlah	1755	1488	1571	1523
52		Rata-rata	97.500	82.667	87.278	84.611
53
54
55	LATIHAN 3
56
57	No	Nama	Nilai Ujian				Nilai Akhir	Nilai Mutu
58	No	Nama	Kehadiran (5%)	Tugas (15%)	UTS (35%)	UAS (45%)	Nilai Akhir	Nilai Mutu
59	1	Ahmad	100	80	81	87	84.5	A
60	2	Bambang	100	86	80	88	85.5	A
61	3	Joko	100	84	82	89	86.35	A
62	4	Widodo	90	82	86	81	83.35	A
63	5	Ara	80	83	89	79	83.15	A
64	6	Juna	90	87	92	80	85.75	A
65	7	Putri	100	88	91	86	88.75	A
66	8	Febri	100	89	87	83	86.15	A
67	9	Atiqah	100	81	80	78	80.25	A
68	10	Edi	100	79	90	90	88.85	A
69	11	Hari	100	80	92	80	85.2	A
70	12	Agus	100	86	93	90	90.95	A
71	13	Alicia	100	83	94	92	91.75	A
72	14	Bagus	100	78	86	93	88.65	A
73	15	Dani	100	90	85	85	86.5	A
74	16	Akbar	100	75	82	80	80.95	A
75	17	Dimas	95	77	88	82	84	A
76	18	Wawan	100	80	93	80	85.55	A
77		Jumlah	1755	1488	1571	1523
78		Rata-rata	97.500	82.667	87.278	84.611
79
80			Nilai	Huruf Mutu
81			80,00 - 100	A
82			77,00 - 80,00	A-
83			74,00 - 77,00	B+
84			68,00 - 74,00	B
85			65,00 - 68,00	B-
86			62,00 - 65,00	C+
87			56,00 - 62,00	C
88			46,00 - 56,00	D
89			≤ 46	E
90
91
92	LATIHAN 4
93	No	Nama Barang		Harga Satuan	Harga Total
94	1	USB 16GB Toshiba		85000	340000
95	2	USB 32GB Toshiba		155000	620000
96	3	USB 16GB Kingston USB 3.0		75000	300000
97	4	USB 32GB Scandisk USB 3.0		100000	400000
98	5	MicroSD 16GB Scandisk Class 4		110000	440000
99	6	MicroSD 16GB Scandisk Class 10		195000	780000
100	7	MicroSD 32 Visipro Class 10		40000	160000