Computer Data Analysis (CGS 2518)

Computer Data Analysis

CGS 2518

Summer "B" Semester 2004

Read this first!

All documents are in MS Word '97 format.
Additional documents will be added throughout the semester.

NOTE:
Students must download, print, and bring copies of all documents for the current unit to class!

Download the Student Data Disk: Click the link above to download the files that accompany the textbook. They have been "zipped" into a single, self-extracting file. Simply save the file on your computer, and then double-click on the file icon. Then, specify the destination folder for the unzipped files. E.g., to unzip the files to diskette, choose A: .
The files will also be available in the BBC labs in the folder I:\clabs\Greg\2518\Data Disk

Table of Contents

Project 1 - Creating a Worksheet and Embedded Chart
Project 2 - Formulas, Functions, Formatting, and Web Queries
Project 3 - “What If” Analysis, Charting, and Working with Large Worksheets
Project 4 - Financial Functions, Data Tables, Amortization Schedules, and Hyperlinks
Project 5 - Creating, Sorting, and Querying a Worksheet Database
Project 6 - Creating Templates and Working with Multiple Worksheets and Workbooks
Project 7 - Using Macros and Visual Basic for Applications (VBA) with Excel
Project 8 - Formula Auditing, Data Validation, and Complex Problem Solving

Basic Mouse Skills: Clicking, double-clicking, right-clicking, dragging, and right-dragging
Skills Checklists (What you should know after completing this unit): Part A - Windows Basics
Part B - Windows File Management
Creating a Folder: How to create a folder on the Desktop or in an existing folder
Windows File Management: Selecting, copying, moving, deleting, and renaming files and folders
Assignment #1 - Windows File Management

Top Home

Skills Checklist and Notes
Excel Editing: Entering data, erasing and replacing cell contents, modifying cell contents, and clearing cell contents, formats, and comments
Selecting Cell Ranges: How to select any number of cells, ranges, rows, and columns
Intro to Text Formatting: Fonts, font sizes, font styles, and text colors
Saving a File: "Save" vs. "Save As...", specifying destination drive and folder, file name, and file type
Assignment #2 - Creating a Worksheet and Embedded Chart

Skills Checklist and Notes - Part 1
Skills Checklist and Notes - Part 2
Relative vs. Absolute Cell Referencing
The IF Function: The IF function will display one of two possible values (or labels or formula/function results) in a cell, depending on whether a condition is true or false
Excel Charts: This document explains everything you need to know to create and modify impressive-looking charts of several different types. The Chart Wizard makes it all very easy!
Assignment #4 - Relative vs. Absolute Cell Referencing and the IF Function

Skills Checklist and Notes - Part 1
Skills Checklist and Notes - Part 2
Assignment #5 - The FV Function, Data Tables, Clip Art, and Hyperlinks: Pay-Less Financial Services.htm - Create a hyperlink to this web page in your worksheet

Skills Checklist and Notes - Part 1
The VLOOKUP Function: The VLOOKUP function searches a table for a particular value, takes a related value from the same row of the table where the first value was found, and stores it in the cell containing the function!
Skills Checklist and Notes - Part 2
Assignment #6 - Databases, Lookup Tables, Sorting, and Subtotals
Skills Checklist and Notes - Part 3

Skills Checklist and Notes - Part 1
Skills Checklist and Notes - Part 2
Assignment #7 - Templates, Consolidating Data, and 3D Sheet References
Consolidating Data by Linking Workbooks: We have seen how to consolidate data stored in different sheets of a workbook. We can also consolidate data that is stored in separate workbooks

Top Home