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:
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.