Microcomputer
Applications Using Spreadsheets (Excel I)
CIS
115 or ADM 215
COURSE OVERVIEW:
This course introduces you to the use of which is the latest version of Microsoft's electronic workbook software. It is a powerful spreadsheet program that allows you to organize data, complete calculations, make decisions, graph data, develop professional looking reports, publish organized data to the Web, and access real-time data from Web sites. Major topics include:
Developing worksheets. Worksheets are the basis of all spreadsheet functions. Topics include creating and formatting a worksheet, absolute and relative cell referencing, functions, advanced formulas, dates and time calculations, financial functions.
Creating charts. Charts pictorially represent data. A variety of two- and three-dimensional charts are available in Excel.
Working with multiple worksheets. This includes saving a workspace file and linking and consolidating worksheets.
Advanced functions. These include VLOOKUP, Lists, PivotTables, Scenarios, and Macros.
REQUIRED
TEXT
and MATERIALS:
It is
STRONGLY advised that you purchase the required items listed below from the UCC
bookstore, to make sure you obtain the correct materials. You cannot
successfully complete the course unless you have ALL of them!
You will also
need the medium of your choice (preferably a USB drive) on which to save your
work.
New Perspectives on Microsoft Office Excel 2007, Comprehensive, Second Edition. Thomson/Course Technology
CaseGrader: Microsoft Office Excel 2007 Casebook. Thomson/Course Technology.
ADDITIONAL REQUIREMENTS IF COURSE IS TAKEN !!!
DO NOT enroll in an online section of this course if you do not have the required software and a computer that will run it! ALL course work will be done on your computer and submitted via the Internet. Check the link below--Is Online Learning for Me?--to see if online classes provide the right learning environment for you.
HARDWARE REQUIREMENTS:
Computer with Internet connection (to connect to class website)
SOFTWARE REQUIREMENTS:
Microsoft Excel 2007
Need more information? marsee@ucc.edu