ITS 12s - Beginning Spreadsheet

Credits: 1
Prerequisites: Computer knowledge level equivalent to ITS 080.
Corequisites : None
Instructor Permission Required: No
Course Status: Approved


Course Description:
Basic creation and manipulation of data within an electronic spreadsheet including planning and creating workbooks, using formulas and functions, creating charts, and formatting spreadsheet objects. Students with minimal computer skills will take longer in completing the assigned tasks and may want to consider taking ITS 080, Computer Fundamentals.

Course Goals and Learning Objectives:
1. Use a spreadsheet to summarize basic numeric information by:

  • Define Spreadsheet Software
  • Opening and Saving a Workbook
  • Entering Labels and Values
  • Naming and Moving a Sheet
  • Previewing and Printing a Worksheet
  • Using the Help facilities
  • Closing a Workbook

2. Plan, design and build a worksheet by:

  • Editing Cell Entries and Working with Ranges
  • Entering Formulas
  • Using Excel Functions
  • Copying and Moving Cell Contents
  • Understanding Relative and Absolute Cell References
  • Copying Formulas with Relative and/or Absolute Cell References

3. Use formatting techniques to make the worksheet easier to read by:

  • Formatting Values
  • Using Fonts and Font Sizes
  • Changing Attributes and Alignment of Labels
  • Adjusting Column Widths
  • Inserting and Deleting Rows and Columns
  • Applying Colors, Patterns, and Borders
  • Using Conditional Formatting
  • Checking Spelling

4. Use charts to graphically communicate the relationship of data in a worksheet by:

  • Planning and designing a chart
  • Creating a Chart
  • Moving and Resizing a Chart
  • Editing a Chart
  • Formatting a Chart
  • Annotating and Drawing on a Chart
  • Previewing and Printing a Chart

5. Analyze data using different types of formulas and functions by:

  • Creating a Formula with Several Operators
  • Using Named Ranges in a Formula
  • Generating Multiple Totals with AutoSum
  • Using Dates in Calculations
  • Building a Conditional Formula with the IF Function
  • Using Statistical Functions
  • Calculating Payments with the PMT Function
  • Displaying and Printing Formula Contents

6. Manage workbooks for better display, printing and web presentations by:

  • Freezing Columns and Rows
  • Splitting the Workbook Display
  • Inserting and Deleting Worksheets
  • Consolidating Data with 3-D References
  • Hiding and Protecting Worksheet Areas
  • Saving Custom Views of a Worksheet
  • Controlling Page Breaks and Page Numbering
  • Creating a Hyperlink between Files
  • Saving a file as an HTML Document

Clark State General Policies:
Assessment of Student Academic Achievement - Student learning is central to all that we do at the College. Faculty assess student learning in a variety of ways, including in-course assessments, portfolios, certification examinations, employer surveys, transfer studies, and many others. The College measures its effectiveness through the results of our assessment of student learning and uses those results to improve student learning.

Students with Disabilities - It is
Clark State's policy to provide reasonable accommodations to students with disabilities. Our goal is to help students succeed in this course. If you have a physical, mental, or learning disability and you need a reasonable accommodation to help you achieve success, please contact Maryrae Kearney, Disability Services Specialist (RH 127B, 328-6019). To best provide the accommodation you need, make this request as soon as possible, since accommodations cannot be made to change a grade you have received for course work already completed.

Tutoring Services - Tutoring services are available for most courses. These services are provided free of charge. Tutoring is provided by professional and student tutors. Tutor request cards are located at the Brinkman Receptionist's desk and in
Rhodes 220. For information, please call 328-3847.

Course Withdrawal - If for any reason you cannot complete this or any other course, you must officially withdraw from the class. Even if you never attend class, if you are officially enrolled in a course, you will receive a grade for the course unless you complete and submit a drop form with appropriate signatures to the registrar. If you have not completed all of the work, that grade can only be an F. Drop forms are available in the division office, in the counseling office, or from the registrar.

After midterm, you must have the instructor's permission to withdraw from a class; therefore, his or her signature must be on the form before you submit it to the registrar. For the last date to withdraw without the signature of the instructor, check the quarterly schedule. If you do decide to withdraw from a class and have any kind of financial aid, you should consult with the financial aid office prior to the withdrawal to determine what, if any, effect it will have on your financial aid status.

Incomplete Grade - If you have been progressing satisfactorily in a course, but for reasons beyond your control (death in family, personal illness, etc.) you cannot complete all of the requirements for the course, you can request an incomplete grade (I) from the instructor. If the instructor agrees, you will work out a mutually agreeable completion schedule. The instructor will complete a grade change form once the course work is completed. If the grade change is not submitted by the Friday of the fifth week of the following term (fall for both spring and summer), the grade will automatically change to an F.

Academic Dishonesty - Using the ideas, expressions, writings, etc., of another person and representing them as your own is one form of academic dishonesty and can result in severe penalties, including failure on a project or in a course. Plagiarism includes not only word-for-word copying but also the use of the general ideas of another without giving appropriate credit to the source. Students are responsible for knowing the Law and Order Regulations in the college catalog.

Children in Classes - Children are not allowed in classes without the prior approval of the instructor. No children are allowed in lab classrooms or lab sessions. If permission is granted to bring a child into a class, it is the parent's responsibility to see that the child in no way disturbs other students or the class in general. Even after permission is granted, the instructor always has the right to ask a parent and child to leave a class if any kind of disruption takes place. Individuals who bring children to the college for any reason are expected to supervise them at all times.

Student Username/Login ID and Password - Students are provided a username/login ID and password to access the College's network, Campus Cruiser and WebCT. The username/login ID is the first five letters of your last name followed by your first initial followed by the last four digits of your student identification number. (If your last name is less than five characters, use your entire last name, first initial, last four digits.) Do not include any spaces, special characters, or capital letters. The password is the 7-digit student identification number. The username/login ID and password are printed on your quarterly schedule/invoice. Secured login assistance is available at https://www.clarkstate.edu/login.html.