Module 1 – SLP

Data, Information, and Organizational Knowledge

Excel 2016 is free to you as a TUI Student just logon to mytlc.trident.edu and then go to your email. Here you will see Office 365 at the top. Click the Office 365 button and you can download the Microsoft Suite which includes Excel 2016.

Data, Information, and Organizational Knowledge

In this module, you will be introduced to Excel and some of its basic functions. Here are some lectures to help you with this SLP

Module 1 SLP Lecture 1: Explore the Excel Window:https://vbrick.com/fliqz/aa146c8f62da4deaab44a2b75064dd67.swf

SLP 1 Review Quiz: This quiz will not count toward your grade but allows you to assess your knowledge.

Enter the information in the spreadsheet below.

	A	B	C	D	E	F	G
1	ITM 389
2	Fall 2020
3			Test1	Test2	Test3		FINAL
4	STUDENT NAMES	STUDENT ID	#1	#2	#3	PART.	AVERAGE
5	Tilly, Susan	999-25-5683	84	65	89	90
6	Shulz, Ben	999-52-6938	93	71	97	70
7	Raymond, Dorthy	998-71-2838	62	83	58	90
8	Smith, Betty	997-74-4447	95	94	80	90

Adjust the size of the columns as needed.

Calculate the final average in G – average the 3 test grades and multiply them by .90 (90%) add in the 10% of the participation grade. =c5*.3+d5*.3+e5*.3+f5*.1

Now calculate the average for columns C, D, and E.

After completing the Excel exercises, please upload the Excel file with your results to SLP 1 Dropbox.

SLP Assignment Expectations

Your assignments will be graded following these expectations:

• The assignment file must be developed in Excel and saved as .xls file.
• Precision: The questions asked are answered.
• Clarity: Your answers are clear and show your good understanding of the topic.