Maseno University

Information Technology Department

UCI 104: Introduction to Data Analysis & Manipulation with Spreadsheets
Cohort: School of Education, School of Biological & Physical Sciences, School of Public
Health and School of Medicine
Course Outline/Schedule
Course Lecturer: Saka D.

Week Topic Subtopic/Key Concepts

1. 1. Introduction to Spreadsheets  Spreadsheets
 Example Spreadsheets Packages
 Spreadsheets Application Areas
 Advantages of Spreadsheets
2. 2. Introduction to MS Excel  MS Excel
 Starting MS Excel 2016 Session
 Excel Terminologies
 Elements of Excel Window
 Excel Data Types
 Entering Text and Numbers
 Using AutoSum Button
 Adding a Worksheet
 Entering Fractions
 Using Autofill Feature
 Saving a Workbook
 Closing a Workbook
 Reopening a Workbook
3. 3. Worksheet Formatting  Reasons for Formatting a Workbook
 Number Formatting
 Font Formatting
 Alignment Formatting
 Conditional Formatting
 Styles Formatting
 Spell Checking
 Insert Row/Column
 Delete Row/Column
 Rename a Worksheet
 Change Worksheet Color
 Copy Worksheet
 Move Worksheet
4. 4. Charts  Chart
 Elements of a Chart
 Types of MS Excel Charts
 Creating a Column Chart
 Resizing a Chart
 Week Topic Subtopic/Key Concepts
 Moving a Chart
 Adding a Chart Title
 Adding other Chart Elements
 Creating a Pie Chart
 Exploding a Pie Chart
5. 5. Excel Formulae  Formula
 Building a Formula
 Complex Expressions
 Operator Order of Precedence
 Types of Cell Reference Modes
 Using Reference Table
 Creating Formula Involving Multiple Worksheets
6. 6. General Math, Logical & Text  Excel Function
Functions  Function Categories
 General Math Functions
 Logical functions
 Text Functions
7. 7. Statistical Functions  Rounding Functions
 Counting Functions
 Ranking Functions
 Measures of Central Tendency Functions
8. - 8. Date/Time & Lookup Functions  Entering Date Values into a Worksheet
 Date Functions
 Entering Time Values
 Time Functions
 Manipulating Date and Time Values Arithmetically
 Lookup Functions
9. 9. Financial Functions  Excel Financial Terminologies
 Future Value (FV) Function
 Payment Amount (PMT) Function
 Number of Payment Periods (NPER) Function
 RATE Function
10. 10. Excel Tables and Data Analysis  Excel Tables
 Data Tables
 Pivot Tables
 Subtotals
 Summarizing Data
 Sorting and Filtering Data
 Pivot Charts
11. 11. Advanced Data Analysis  Manual What IF Analysis
 Reverse What IF Analysis/Goal Seek
 Scenario Manager
 Solver
12. 12. Collaboration and Workbook 
Sharing
Key Text: Mulbery K., Davidson J., et al. Exploring MS Excel 2013: Comprehensive. Pearson Education, New
Jersey, 2014.