CA151 Introduction to Spreadsheet Applications

Sample Syllabus (Word document)

Course Description

A practical introduction to the creation, design, and use of spreadsheets in the business environment. Emphasis will be placed on basic functions including creating, formatting, maintenance, graphing, and printing of spreadsheets. This course is designed for beginning spreadsheet users. Lessons can be applied to budgets, marketing and sales reports, expense reports, invoices and purchase orders, basic financial statements, and spreadsheet information for use on the Intranet/Internet.

Prerequisites/Corequisites

CA106 Microcomputer Operating Systems
Assessment levels:EN101/101A, MA100, RD110

Goals and/or Objectives

Upon successful completion of this course, the student should be able to

• Development and enhancement of non-technical skills
  • Speak and write about the course topics with sufficient proficiency
  • Apply critical thinking to a variety of topics in the course
• Electronic spreadsheet software
  • Explain the purpose of electronic spreadsheet software and its application to solve common business problems
• Spreadsheet creation
  • Open electronic workbooks
  • Enter text and numbers
  • Enter formulas
  • Save workbooks
  • Close workbooks
• Modify spreadsheet data
  • Delete cell contents and worksheets
  • Revise text, numbers and formulas
  • Rotate and indent text
  • Copy and move data
  • Insert, modify and delete rows and columns
  • Use references
  • Sort data
• Print spreadsheet
  • Preview and print worksheets
  • Print screen and ranges
  • Print using headers and footers
• Save spreadsheets for web use
  • Save spreadsheets as HTML files
• Format spreadsheet data
  • Modify cell size and alignment
  • Apply general numbers formats
  • Apply font formats
  • Apply outlines
• Create and apply ranges to data
  • Create and name ranges
  • Clear and format ranges
  • Copy and move ranges
  • Integrate range names
• Use functions and solve mathematical problems
  • Use AVERAGE, MAX, MIN functions
  • Use worksheet and date functions
  • Use the Scenario Managers
  • Use the Goal Seeker and the Solver
• Use draw tools to enhance worksheets
  • Create and modify lines and objects
  • Create and modify 3D shapes
• Use charts
  • Create, format and modify charts
  • Preview and print charts

Please note that the information provided here is only a guideline and may occasionally be out of date. Official current semester course description language can be found at:

• http://webdb.montgomerycollege.org/Internet/
  courses/SubjectSelect.cfm (current courses)
• http://www.montgomerycollege.edu/curricula/
  descriptions/cdcompapp.htm (current CA certificates and degree programs)
• http://www.montgomerycollege.edu/credit/ (current semester course schedule)