ITM 301 MODULE 2 SLP LATEST-TRIDENT
Visit Below Link, To Download This Course:
http://bit.ly/2FkSi1h
ITM 301 Module 2 SLP Latest-Trident
ITM301
ITM 301 Module 2 SLP Latest-Trident
Module 2 – SLP
IT GOVERNANCE AND DECISION MAKING
Working with the Excel Environment
Excel allows us to calculate numerical
information using formulas. In Module 2, we learn how to use cell references to
create formulas. In order to create a formula, we need to learn about Excel
standard operators for formulas. These operators are a plus sign (+) for
addition, a minus sign (-) for subtraction, an asterisk (*) for multiplication,
a forward slash (/) for division, and a caret (^) for exponents. Excel uses =
sign to start a formula, and that cell must be equal to the formula which is
calculated for.
SLP2 Excel Operations
Source:
http://www.gcflearnfree.org/excel2013/13
Excel 2013 uses features like the Ribbon and
Quick Access toolbar to perform common tasks. The Ribbon in Excel 2013 uses a
tabbed Ribbon system rather the traditional menu. Below is the description of
the different tabs in Excel 2010-2013.
Understanding cell references
A cell is recognized by its address. The
intersection of a columns and a row represent a cell address. For instance,
column B and row 3 is the cell B3. The cell value is the value of what we
calculate for a specific cell. For instance, if we B1 = 15, B2 = 25, then the
value of B3 = B1+B2 or B3 = 15+25=40, therefore, the value of B3 = 40 as shown
below.
In formula section we have, Fx =A1+A2
15
25
B1+B2= 40
Please review the following link and watch the
following section videos.
Refer to tutorials at
http://www.gcflearnfree.org/excel2013
Formatting Cells (video 9)
Worksheet Basics (video 10)
Page Layout (video 11)
Printing Workbooks (video 12)
Simple Formula (video 13)
Complex Formulas (video 14)
Relative Absolute Cell References (video 15)
Functions (video 16)
SLP Assignment
Use the table below to do the following.
A B C D
11 30 36 20
2
70 31 11 35 45 35 14
= A1+A2+A3+A4
= B4 – B2
= C4/B2
= C3/5
A4^2
Write the cell address according above table
for the following:
Gas used for June
36
Gas used for May
45
Total used gas
81
Use the below table to calculate the total for
each item; however, instead of manual work, use the formula function. For
example, to calculate each item, you need to do the following.
Place = on the formula bar in the Total column
|
Fast Shop
|
Item
|
Quantity
|
Unit price
|
Total
|
|
Lighter
|
25
|
$1.99
|
||
|
Pepsi
|
17
|
$1.73
|
||
|
Hot dog
|
47
|
$1.05
|
||
|
Ice bag
|
11
|
$2.21
|
After completing the Excel exercise above,
please continue developing the Abacus Excel spreadsheet exercises located at http://triplecsa.fhost.com.au/Blog/wp-content/uploads/2013/09/Basic-Spreadsheet-Concepts-Exercises.pdf
and as noted below.
Exercise 1 – Sales for the Month
Exercise 2 – Sales and Produce Department
Exercise 3 – Mike’s Stationery Order
Create an Excel file with designated folders
1-4 to develop the above exercises.
SLP Assignment Expectations
The SLP should be developed in Excel. Your
assignments will be graded following these expectations:
- Precision: The
questions asked are answered.
- Clarity: Your
answers are clear and show your good understanding of the topic.
- Breadth and depth: The
scope covered in your paper is directly related to the questions of the
assignment and the learning objectives of the module.
- Critical Thinking: It is important to read the “required readings” posted in the background material plus others you find relevant. Your paper should include important concepts from these readings and incorporate your reactions and examples that illustrate your reflective judgment and good understanding of the concepts.
Comments
Post a Comment