CIS216

Drag to rearrange sections
Rich Text Content

CIS 216 Excel Spreadsheet Applications

Welcome to distance education at Cuesta College! My name is Marilyne Cleeves, and I will be your instructor in the upcoming online version of Introduction to Spreadsheet Applications using Microsoft Excel (CIS 216). This is a full semester course designed to give you the tools to become Microsoft Certified in Excel.

This welcome letter is to inform you of some important details prior to the commencement of this online class. Please read this page carefully!!

COURSE DESCRIPTION AND REQUISITES

Introduces the basics of an electronic spreadsheet program using Microsoft Excel. Students learn to analyze, identify, and apply the principles of macros and databases. Class covers data tables,
amortization schedules, charting, mapping, pivot tables and summary reports.

Transfers to CSU

TOPICS AND SCOPE

CREATING A WORKSHEET AND A CHART
  • Excel Workbook Window, Ribbon, and Elements Common to Office Apps.
  • Customize Quick Access Toolbar
  • Enter text and use help menus
  • Create a 3-D Pie Chart
  • Change a worksheet name and sheet tab color
  • Change document properties
  • Enter simple functions

FORMULAS, FUNCTIONS AND FORMATTING IN WORKSHEETS

  • Simple Formulas - add/subtract, multiply/divide, if statements, average, maximum and minimum
  • Complicated Formulas - PMT, Countif (technical term) and solver
  • Conditional Formatting - build a condition to change color in a cell based on specified criteria
  • Themes and Styles - formatting techniques used to make a uniform document. 
  • Verify Formulas - using range finder

WORKING WITH LARGE WORKSHEETS, CHARTING AND WHAT-IF ANALYSIS

  • Create Series - apply concept using months of the year and days of the week.  
  • Absolute and Mixed Cell References - creation of formulas using the mixture of the two cell reference types.
  • Chart Type and Style - change chart types and styles using defined data structure.
  • Goal Seek - use goal seek to find answers to what-if analysis questions

FUNCTIONS, DATA TABLES, AND AMORTIZATION SCHEDULES

  • Functions
    PMT - Determine the monthly payment of a loan using the financial function PMT. 
    PV and FV - Understand the financial functions PV (present value) and FV (future value)
  • Data Tables
    Data tables are used to automate data analyses and organize the results returned by the spreadsheet.
  • Amortization Tables
    An amortization schedule shows the beginning and ending balances of a loan and the amount of payment that is applied to the principal and interest during each payment period.

WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS

  • Consolidation
    The process of summarizing data gathered from multiple worksheets onto one worksheet
  • Functions - Date, Time, and Round
  • Worksheet Reference - Reference cells in other worksheets within a single workbook.
  • 3-D Reference - When a reference is the same on several sheets, that information can be consolidated using the 3-D reference feature.

CREATING TEMPLATES, IMPORTING DATA, WORKING WITH SMARTART

  • Template - A template is a special purpose workbook you can create and use as a pattern for new, similar workbooks or worksheets.
  • Import Data - Bring in data from a various external sources such as Text, Access, Word, Web Data and XML files.
  • Convert Data - Convert text to columns
  • SmartArt Graphic - SmartArt is a a customizable diagram that can be used to pictorially present lists, processes, and relationships.

SECURITY, ETHICAL AND PRIVACY ISSUES

  • Safeguards against digital compromise
  • Malware - An umbrella term used to refer to a variety of forms of hostile or intrusive software, including computer viruses, worms, Trojan horses, ransomware, spyware, adware, scareware, and other malicious programs.
  • Ethics and Privacy - research project to determining professional ethics in computer professionals apply standards of good practice.

STUDENT LEARNING OUTCOMES

The Student Learning Outcomes statements are a list of expected knowledge, skills, attitudes, competencies, and habits of mind that students are expected to acquire in this course. The outcomes for CIS216 are defined as follows:

  1. Use a spreadsheet program to successfully plan and create worksheets.
  2. Demonstrate advanced skills in spreadsheet applications and creation of an integrated project.
  3. Analyze business scenarios using spreadsheet software.
  4. Discuss security, ethical and privacy issues resulting from the use of computer technology.

TEXTBOOK

Textbook Image

Microsoft Excel 365 Complete; In Practice 2021

By Randy Nordell and Kathleen Stewart

ISBN: 9781266773495

This is a specially priced loose leaf version that includes the SIMNet online tutorials. The bundle is half-price to the Cuesta Bookstore.

You also have the option of purchasing the digital-only version through the publisher (SIMNet 2021 In Practice Excel).  If you prefer digital, you will signup in the Cuesta Canvas portal after the course opens be ready with your payment information then.

SOFTWARE

Software – This course requires Office 2016.  The book demonstrates techniques for Office 365 As a Cuesta student, you can obtain a free 1-year subscription to Office 365/Office 365 program for 1 year.

MAC USERS (Suggestion)

Office 365 does have a Mac version of Office 365; however, there are some significant differences in the Mac version Excel that I have found to make it difficult for students to learn some of the processes we are teaching in this course.  If possible this is what I suggest for Mac users:

  1. Install a version of ParallelsLinks to an external site. on your Mac (Journey Ed has this for Cuesta Students - $39.95Links to an external site.)
  2. Purchase a download of Windows 10Links to an external site. (Journey Ed has this for Cuesta Students - $144Links to an external site.). After you have installed a Windows 10 version, install your free WINDOWS version of Office 365.  It will work on your Mac and you will then have the programs you need including MS Access that will not work on the Mac operating system. 

CANVAS

After you have registered for the class you will find you are now registered for Canvas. You will need to follow these steps:

  1. From the Cuesta Website, Click on the Canvas Link
  2. You will be asked for a username and password. That information is the same as you myCuesta username.
  3. You will see all of the classes you are currently enrolled in listed in this area. If you have an additional questions. I suggest watching the following video (Canvas TutorialLinks to an external site. Links to an external site..)

SCHOOL POLICY

Each student is required to follow all school guidelines and comply with all school deadlines including personal responsibility for adding and/or dropping this class. Each student is responsible for obtaining updates or changes to the syllabus and/or assignments for the course.

If you have any further questions prior to the first day of class, please feel free to e-mail me. Otherwise, I will look forward to meeting you on
our scheduled meeting date.

Sincerely,

MARILYNE CLEEVES

mcleeves@cuesta.edu 

 

 

rich_text    
Drag to rearrange sections
Image/File Upload
text-1.jpg
attachment 7958735  
Drag to rearrange sections
Rich Text Content
rich_text    

Page Comments