1. Save this file as COL110FinalS08Your NameID. (or according to professor's
instructions)
2. Read each question carefully.
3. When using Excel formulas, use cell references (addresses) whenever possible.
4. When creating an Excel formula at the top of
Average price of gold from1985 to March 2008.
Data from Kitco.com, World Gold Council and Gulf
News were used to complete Table 3.
Year
1985
1986
1987
1988
1989
1990
1991
1992
1993
1994
1995
1996
1997
1998
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
COL 110004 Quiz1
Date: Wednesday, September 16th, 2015
Name: _
ID: _
Q4. Use Excel functions Unit
Q1. The Excel Scientific Notation of
Conversion tab to answer the
following questions:
34568932 is:
+7
a. 3.4568932* 10
b. 3.4568932E+07
c. 3.4568932E07
d.
University College Mission
University College offers high quality foundational education, the Colloquy, to
students and prepares them for their future majors and eventual employment.
The experience instills in the students a desire for lifelong learning,
Lesson XL04 Unit Conversions
This lesson will introduce you to converting fromone set of units to another. You will
also learn the basics of absolute cell referencing. These basics will assist in the use of
Excel to understand data.
1. Copy the files from
Formulas
=
Order of Operations
Brackets
( )
Exponentiation
^
Division
/
Multiplication
*
Addition
+
Subtraction

Create a formula in the green cell in Column F that will give
the correct answer to the formula shown in Column E.
93*2 =
3
(93)*2 =
12
3+2
Lesson XL05 Percent and Percent Change
This lesson will introduce you to the use of percent and percent change. These basics will assist
in the use of Excel to understand data.
1. Copy the files from the XL05Percent folder on Blackboard to your COL110 XL
Lesson 01 I ntroduction, Basic and Formatting Excel Skills
This lesson will introduce you to the vocabulary, navigation and basic m skills of Excel. These
ath
basics will assist in the use of Excel to understand data.
1. Copy the files from the 01 Intro&
Lesson XL04 Unit Conversions
This lesson will introduce you to converting fromone set of units to another. You will
also learn the basics of absolute cell referencing. These basics will assist in the use of
Excel to understand data.
1. Copy the files from
Lesson 10 Excel/Data Analysis  Graphing (charting) the data
Most presentations and displays of data are enhanced by attractive and informative charts. Charts are a pictorial
presentation of data  often found in tables. Some data can be represented by m
Histogram
A histogram is similar to a column chart but with a few very important differences.
The vertical height represents the frequency of occurrence of the range of values indicated in the width of the column. This means that the width of
the column h
Lesson Plan Life v. Television
Kim Schoenborn & Alicia Berginski
Objectives:
Students will explore data transformations, and consider if a casual connection is
necessary for one variable to be a useful predictor of another.
Students will use this set of d
E15 Data Analysis1
Data come in many different forms and often it is necessary to categorize it in some way. Data that is collected and not analyzed is referred
to as raw or primary data. In this raw form, data is simply data. Your task will be to take r
Trendlines OR Line of Best Fit OR Least Squares Line,
380
When a reasonable correlation exists between two variables, then a line of best fit can
drawn. This could be done by "hand" in such a way that the points are as close to the line
as they can be. Th
XL13: Correlation
A correlation is a relationship between two events (or variables), where one event may affect another event. For example, you might want to find out whether smoking more cigarettes will
affect the number of times smokers will be inflect
Data Descriptors
How do you transform large sets of numerical data into a form that is relatively simple to analyse
and understand? The answer is Data Descriptors (something that describes or explains data).
Data descriptors can be divided up into Numeric
XL14: Correlation Coefficient (r)
In previous lesson, Correlation was investigated visually by
building a scatter plot and examine its trend.
Mathematically Correlation can be determined by using
the excel function CORREL and the R2 value. The
correlatio
These are the results of four tests for a class
of COL 110 students. Each test is out of a
Total (using the
Total (by adding Excel function,
maximum of 100.
cell addresses)
Max
Samira
Hind
Shaikha
Khawla
Salma
Rabea
Nada
Marwa
Badriya
Muna
Maisoona
Layla
Le s s o nE0 4 Unit Co nve r s io ns
This lesson will introduce you to converting from one set of units to another. You will
also learn the basics of absolute referencing. These basics will assist in the use of Excel
to understand data.
1. Copy the files
Le s s o nE0 3 Co m m o nEx c e lFunc t io ns
This lesson will introduce you to the use of the common excel functions of: SUM,
COUNT, MAX, MIN AND AVERAGE. These basics will assist in the use of Excel to
understand data.
1. Copy the files from the E03Ex
Formulas
=
Create a formula in the green cell in Column F that will give
the correct answer to the formula shown in Column E.
Order of Operations
Brackets
()
Exponentiation
^
Division
/
Multiplication
*
Addition
+
Subtraction

db00e760be3257dfe8bed931cbb
Le s s o nE0 1 I nt r o d uc t io n,Bas ic and For m at t ing Ex c e lS kills
This lesson will introduce you to the vocabulary, navigation and basic math skills of
Excel. These basics will assist in the use of Excel to understand data.
1. Copy the files
Instructions: (Read each question very carefully)
Save your test as COL110YourNameID
1. Whenever a cell reference (address) can be used in an excel formula or
function, it must be used.
2. Whenever excel formulas or functions are copied down a column or
GDP (Gross Domestic Product) per capita in 2006
Maximum
Mark
Grade
1. Write your name and ID in cell JUN2010
1
1
2. Create a formula in cell D4, using cell references from each of the orange cells (C4,G2 and I2), to calculate
the GDP in dirhams (AED). Com
GDP (Gross Domestic Product) per capita in 2006
Currency Conversion
2.5 US $ =
Amount in Amount in Status of
Region Countries
US dollars AED
Country
Europe Luxembourg
89563.6
Europe Norway
66964.4
Europe Iceland
53029.3
Europe Ireland
52892.9
Middle East
1. Save this file as COL110FinalS08Your NameID. (or according to professor's
instructions)
2. Read each question carefully.
3. When using Excel formulas, use cell references (addresses) whenever possible.
4. When creating an Excel formula at the top of
Le s s onE0 5 Pe r c e nt and Pe r c e nt Ch ange
This lesson will introduce you to the use of percent and percent change. These basics
will assist in the use of Excel to understand data.
1. Copy the files from the E05Percent folder on Blackboard to you