Distance Learning
Home > Academics > eLearning > Course Formats > Online > CMSY Online Courses > CMSY 101 Beginning Spreadsheets - Online

CMSY 101 Beginning Spreadsheets - Online

After successful completion of this course, the student will be able to use features of Microsoft® Excel that include functions and formulas, formatting, charts, and lists. This course may be completed in fewer than 14 weeks. All of the work (except tests) may be done outside of class if student has compatible software.

Credits                                      1
Prerequisites                              None
Instructor                                  Joanne Kearns
Office Technology Classroom       DH 301
Phone                                       (443) 518-4876
Email                                         jkearns@howardcc.edu

Registered Students | Overall Course Objectives | Major Course Topics | Course Format| Orientation | Course RequirementsText and Materials | Exams


Registered Students

Immediately after enrolling, go to www.howardcc.edu/elearning, choose the semester, and complete the pre-semester notification form.


Overall Course Objectives

Upon completion of this course the student will be able to:

  • Create, save, and print a worksheet.
  • Format a worksheet.
  • Enhance a worksheet.
  • Insert formulas and functions.
  • Move data within and between workbooks.
  • Create and modify charts.
  • Use styles, themes, and templates.
  • Insert Hyperlinks, Images, SmartArt, WordArt, and shapes.
  • Filter list and sort data

Top of Page

Major Course Topics

  • Preparing a Worksheet
    • Creating, saving, and printing
    • Editing cell data
    • Selecting cells
    • Using Help
  • Formatting a Worksheet
    • Changing column width and row height
    • Formatting cell data
    • Inserting/Deleting rows and columns
    • Adding borders and shading
    • Using the Format Painter
  • Inserting Formulas and Functions
    • Using Sum
    • Writing formulas with Mathematical operators
    • Using the AVERAGE, MAX, MIN, COUNT, PMT, FV, DATE, NOW, and IF functions
    • Creating absolute and mixed cell references
  • Enhancing a Worksheet
    • Inserting headers, footers, and page breaks
    • Changing margins and centering worksheets
    • Printing titles, gridlines, and headings
    • Finding and replacing data
    • Sorting data and filtering a list
  • Maintaining Workbooks
    • Working with multiple worksheets and workbooks
    • Moving, copying, pasting, and linking data and worksheets
    • Using styles, themes, and templates
  • Creating Charts
    • Creating, sizing, moving and formatting charts
    • Adding and editing chart elements
  • Enhancing Workbook Display
    • Creating Hyperlinks
    • Inserting and editing images
    • Creating diagrams
    • Creating WordArt
    • Drawing and modifying shapes and lines

Top of Page


Course Format

  • The course is not self-paced. However, students may accelerate their pace so that you may finish the course in fewer than 14 weeks.
  • The syllabus lists course requirements.
  • This schedule is posted in the learning management system and is available for students all semester.
  • No on-campus meetings are required.  However, this course does require on-campus attendance for tests. The tests may be taken during any open hours in the Office Technology classroom. Please note, however, that all CMSY-101 students are welcome to come to the Office Technology classroom to do classwork and/or to get personal help from an instructor.
  • Modules contain course instructions.
  • E-mail is the method of communication.
  • Real-time chats are not required.

Top of Page


Orientation

This course has a mandatory face-to-face orientation held on the Saturday morning prior to the semesteer start.  Please click on  http://www.howardcc.edu/academics/e_learning/ to view the orientation schedules.

Top of Page


Course Requirements

For complete technical requirements, specific course instructions, and information to help you assess options that best fit your lifestyle and learning style, visit http://www.howardcc.edu/academics/e_learning/faq/rightfor.html.

  • Come to the Office Technology classroom to take tests which have deadlines for completion. 
  • Microsoft Excel 2010.
  • Although there are no prerequisites for the course, having basic knowledge of Microsoft Word or another software program will make Excel easier to learn as you will understand the basic concepts using Windows.
  • Complete three homework assignments which have deadlines for completion.

Top of Page


Texts and Materials Required:

Microsoft Excel 2010 Level 1, Benchmark Series
Rutkosky and Rutkosky | Course Technology, Cengage Learning, 2011 | ISBN: 978-0-76384-314-4

2 Flash Drives

Additional textbook information:  Please visit www.howardccbooks.com and follow the instructions for selecting textbooks.

Technical Requirements for Online Courses:
Review the Technical Requirements link above. The course requires

  • A Web Browser

Top of Page

Exams

For purpose of verification and assessing learning outcomes, this course has three theory exams and three production exams, which have deadlines for completion.  The exams must be taken at the college during any open hours in the Office Technology classroom.


If you have any questions or comments about this course, please send a message to Cindy Garnsey, cgarnsey@howardcc.edu

Last updated on July 3, 2013

  © Howard Community College, 2012

Top of Page | Online Courses Home | eLearning Home | HCC Home


Student Profile - Maribel