CIS 216 Spring 2019

Drag to rearrange sections
Rich Text Content

 

title.jpg

DISTANCE LEARNING COURSE: CIS 216
CRN: 33863 (4 Units)
BEGINS: January 22, 2019
ENDS: May 24, 2019

Cuesta.jpg

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 2016 (CIS 216). This letter is to inform you of some important details prior to the commencement of the this online class. Please read this page carefully!! self-1.jpg

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.

text.jpgTEXTBOOK

Microsoft Office 2016, In Practice: Excel Complete

By Randy Nordell

ISBN #9781260411560

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 2016 In Practice Excel $70.75).  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 2016. As a Cuesta student, you can obtain a free 1-year subscription to Office 365/Office 2016 program for 1 year.

Click on the link, choose Cuesta College and you will see the special pricing for Cuesta Students.

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 (https://guides.instructure.com/m/4210/l/141852-canvas-overview-video)

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
self-1.jpg
attachment 790137  
Drag to rearrange sections
Rich Text Content
rich_text    

Page Comments