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.
Your assignments will be graded following these expectations: