May 21, 2024  
Basic Course Information Catalog 2019-2020 
    
Basic Course Information Catalog 2019-2020 [ARCHIVED CATALOG]

CGS1510 - Spreadsheet Fundamentals







3 hours Lecture, 3 credit(s)

Lower-Division College Credit

Prerequisite(s): CGS 1061C or CGS 1100

AA Elective: Yes

Academic Dean’s Contact Information

LAKELAND DEAN’S OFFICE: LLC 2255              PHONE: (863) 297-1024
WINTER HAVEN DEAN’S OFFICE: WSC 101      PHONE: (863) 297-1020



Course Description:
This course provides students with hands-on experience and skills with an electronic worksheet and its use as a financial planning tool for business. Students apply the various functions and commands of the electronic spreadsheet for applications such as sales forecasts, financial statements, cash flow analysis, stock market calculations, expense analysis and control, budgets, and plans, as well as other functions. Hands-on labs are used to reinforce class work.



Polk State College Mission and Program Outcomes

Polk State College, a quality-driven institution serving Polk County and beyond, transforms students’ lives through the power of teaching and lifelong learning by providing access to affordable associate and baccalaureate degrees, career certificates, and workforce employment programs, delivered through various modalities and innovative technologies and by diverse, qualified faculty and staff. In line with this purpose, Polk State’s Associate in Science and baccalaureate degree programs develop competence in various career-related skills. This course focuses on the development of competencies related to the following program outcomes:


1.  Develop a spreadsheet application utilizing a current, industry standard spreadsheet program.
2.  Apply standard spreadsheet editing functions, formulas, and formats to existing spreadsheets.

 
Course Objectives:

Upon successful completion of this course, students will be able to: edit functions, formulas, and formats to existing spreadsheets.
 

  1. Distinguish the key features of a spreadsheet.
  2. Illustrate how a spreadsheet is used. (1)
  3. Demonstrate a spreadsheet’s more powerful accessories. (2)
  4. Produce completed projects with the required software. (1,2)
  5. Create automated solutions executed with macro buttons. (2)
  6. Solve practical business problems.


Course Content:

Getting Started with Excel

Formatting a Workbook
Working with Formulas and Functions
Working with Charts and Graphics.
Working with Excel Tables, PivotTables, and Pivot Charts
Managing Multiple Worksheets and Workbooks.
Using Advanced Functions, Conditional Formatting, and Filtering.
Developing an Excel Application
Developing a Financial Analysis
Performing What-If Analyses

Connecting to External Data
Expanding Excel with Visual Basic for Applications

 

Textbook and Other Requirements

Textbook information is provided in the course syllabus, at the campus bookstore, on the campus bookstore website (www.polk.bncollege.com), or via the “Shop Textbooks” button on the PASSPORT schedule of classes.



College-Level Communication and Computation Skills

State Rule 6A-10.030 does not apply to this course.



Student Help

The professor is available for help during posted hours and by appointment during other non-class hours. Each student is encouraged to seek assistance from the professor. To further the educational process, the Learning Resources Centers, comprised of the campus Teaching/Learning and Computing Centers (TLCCs), JDA Student Success Center, and campus libraries, are available for student use. Each resource provides qualified staff and up-to-date equipment and facilities to promote academic success. The TLCCs and JDA Student Success Center provide tutoring services, computing resources, and other instructional support. The library provides information resources, individual and group study space, research assistance, information literacy instruction, and computing resources. Each facility provides free wireless access to the Internet. The Polk State College Library, Student Success Center, and TLCC hours of operation and tutoring schedules are posted at each facility and on the College website.



Withdrawing From a Course

A student may officially withdraw from a course during any given term, provided he or she follows the appropriate policy and procedure. Following the conclusion of the Drop period, students may officially withdraw without receiving a grade from any course, provided they do so no later than the published withdrawal deadline. The published deadline reflects approximately (but no more than) 70% of the term, based upon the course’s scheduled duration. It is the student’s responsibility to submit these withdrawal forms; failure to do so may result in a grade of F in the course. Under the Forgiveness Policy, a student is allowed only three attempts in any one course: one initial enrollment and two repeats. A student is not allowed to withdraw from a third course attempt. Limited admission programs may have specific guidelines regarding course withdrawal that vary from this policy; these guidelines are listed in the specific program handbooks. If a student stops attending class, the grade earned, usually an F, is assigned and posted. Prior to withdrawing from a course, the student should consult with the Financial Aid Office to determine what impact, if any, withdrawal from the course will have on his or her financial aid status. A student cannot use course withdrawal to avoid academic dishonesty penalties. A student who has been penalized for academic dishonesty in a course is not eligible to withdraw from the course.



Repeating a Course

Under the Forgiveness Policy, a student is allowed only three attempts in any one college credit course: one initial enrollment and two repeats. Under certain circumstances, a student may petition to repeat a credit course beyond the third attempt. Limited admission programs may have specific guidelines regarding repeating courses that vary from this policy; these guidelines are listed in the specific handbooks. The student should be aware that repeating a course may result in a higher course cost. A course cannot be repeated unless the previously earned grade is a D, F, or W (the Polk State Catalog provides further details regarding this process). Prior to repeating a course, the student should consult with the Financial Aid Office to determine what impact, if any, repeating the course will have on his or her financial aid status.



Academic Dishonesty

Each student is responsible for his or her work. It is assumed that each student is honest and will abide by this standard; however, in the event that there is an indication or suspicion of cheating or plagiarism, the situation shall be dealt with in accordance with the published College policy. Copies of this policy are available in the Student Services Office. More specific information can be found in the Course Syllabus.



Information Technology Access/Use Policy

The information technology resources provided by Polk State College (this includes, but is not limited to, telephones, computers, the Polk State Local Area and Wide Area Networks, and the Internet) must be used for academic purposes only. Use of these resources is a privilege, not a right. Inappropriate use can result in revocation or suspension of this privilege.



Equal Access/Opportunity

Polk State College is an equal access/equal opportunity institution committed to excellence through diversity in education and employment. The College complies with all state and federal laws granting rights to students, employees, and applicants for employment or admission to the College. Polk State College does not discriminate on the basis of race, color, national origin, ethnicity, sex, age, religion, sexual orientation, marital status, veteran status, genetic information, disability, or pregnancy in its programs, activities, or employment.

The following person has been designated to handle inquiries regarding the non-discrimination policies:
Valparisa Baker
Director, Equity and Diversity (Title IX Coordinator)
999 Avenue H NE
Winter Haven, FL 33881
Office: WAD 227
Telephone: (863) 292-3602
e-mail: vbaker@polk.edu



Equal Opportunity For Students With Disabilities

The College complies with The Americans with Disabilities Act and provides equal educational opportunity for qualified individuals. A student with a disability who requires special accommodations or auxiliary aids under The Americans with Disabilities Act (ADA) should contact the Coordinator or Director of Disability Services. Note: Limited admission programs may have performance restrictions that apply. Restrictions (where applicable) are outlined in each program’s student handbook.



Evaluative Criteria:

Your final grade will be the weighted average of your grades on the programming assignments, exams, and final exam given during the term. 
 
 
CATEGORIES & WEIGHTS

Assignments                50%
Exams                          30%
Final Exam                   20%

GRADING SCALE
90 – 100%       A
80 -    89          B
70 -    79          C
60 -    69          D
Below 60%      F 

Assignment and exam submissions must be accurate and complete to gain full credit. Errors and omissions will result in varying point deductions.

 

Attendance:

Regular and prompt attendance to class is the student’s responsibility and is considered an essential part of the course. Students are expected to be punctual and remain in class during its entire duration. Classes begin punctually as scheduled and students are expected to be in their seats properly prepared to participate. Eating food and drinking beverages is, of course, not permitted as a matter of college policy. There are no “excused or “unexcused” absences. You are there or not there, and material missed is the responsibility of the student.

 


Search for Open Classes