Principles of Information Systems in Business and Organization
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: