2019-2020 Course Descriptions by Santa Monica Community College

More catalogs by Santa Monica Community College | 2019-2020 Course Descriptions | 180 pages | 2019-11-14

Ads

Page 32 of 2019-2020 Course Descriptions

santa monica college catalog 2019–2020 195 quickbooks students will work with the various components of an accounting system in an ongoing business as well as set up an accounting system for a new company topics include the creation of a quickbooks company processing daily accounting entries the analysis of financial statements creation of reports and graphs students will gain experience in the creation and use of invoices purchase orders inventory bank accounts and payroll in addition students will be able to complete the entire accounting cycle including recording adjusting entries and making corrections on the transactions as needed hands-on experience is provided in a microcomputer lab this class covers the objectives necessary for the quickbooks certification cis 30 microsoft excel 3 units transfer csu • prerequisite none • advisory cis 4 this course includes a detailed study of business applications using microsoft excel spreadsheet package topics include the commands formats and functions of excel with emphasis on its use as a problem solving and financial analysis tool students will also learn to create macros customize ribbons and tabs and integrate excel with other applications and the world wide web students will also have an introduction to writing visual basic code this course uses microsoft excel 2016 professional cis 35b quickbooks online 3 units transfer csu • prerequisite none • advisory accounting 1 or accounting 21 and cis 4 this course provides the student with a business approach to computerized integrated accounting principles using quickbooks online students will work with the various components of an accounting system by setting up an accounting system for a new company topics include the creation of a quickbooks company processing daily accounting entries working with payroll online maintaining inventory the creation and the analysis of financial statements and other managerial reports hands-on experience is provided this class covers the objectives necessary for the quickbooks online certification cis 32 microsoft access 3 units transfer csu • prerequisite none • advisory cis 4 this course presents an introduction to relational database management systems using microsoft access it is designed to familiarize the student with microsoft access and its application in the business world topics include designing maintaining and querying a database creating forms reports and macros and an introduction to writing visual basic code hands-on experience is provided in a microcomputer lab this class covers the objectives necessary for the mos certification in access this course uses microsoft access 2016 cis 34 advanced excel with visual basic for applications 3 units transfer csu • prerequisite none • advisory cis 30 this course provides excel users with the knowledge skills and techniques needed to write macros using visual basic for applications vba within the excel environment the course helps users to automate repetitive tasks customize excel menus buttons and screens and create user friendly interface for input and output the course covers basic programming techniques used in visual basic and vba this course uses microsoft excel 2010 cis 35a quickbooks desktop 3 units transfer csu • prerequisite none • advisory cis 1 or cis 4 and accounting 1 or accounting 21 formerly cis 35 formerly same course as accounting 35 this course provides the student with a business approach to computerized integrated accounting principles using cis 36c microsoft excel – short course 1 unit transfer csu • skills advisory cis 36f or working knowledge of windows this short introductory course in excel spreadsheet software acquaints the student with basic features of the software including creating editing formatting and printing of electronic worksheets it is offered as a brief overview of the software cis 36f introduction to windows – short course 1 unit transfer csu • prerequisite none this hands-on course covers the basic to intermediate features of the microsoft windows operating system — from personalizing your windows environment to finding files and data students will learn how to organize files and search for information using windows explorer this course uses windows 10 cis 36g introduction to internet – short course 1 unit transfer csu • prerequisite none • skills advisory working knowledge of windows this hands-on course on the internet provides students with the opportunity to learn basic and advanced features of the internet topics include browsing navigating proper use of favorites effective searching for information creating web pages and using e-mail students will learn about the development of the internet proper netiquette and social and ethical issues additional topics include finding and downloading graphics freeware and shareware programs from the internet course descriptions cis 9b technology project management ii 3 units transfer csu • prerequisite none • advisory cis 9a or cs 9a this course covers advanced topics of project management theory and practice students will learn how to manage projects with changing tasks and schedules and to adjust their resources and budgets also covered are leadership and communication skills students will complement the theory with case studies and the use of project management software cis 9b is the same course as cs 9b credit may be earned for one not both.