District Syllabus
CGS2510
Spreadsheet


Credit Hours: 3
Contact Hours: 3
Laboratory Fee: $25
Prerequisites: CGS1570 Computer Concepts And Applications
Corequisites: There are no corequisites for this course.
Comments:
Catalog Description:
Spreadsheet applications will be taught by a combination of lecture 
and hands-on experience. Electronic spreadsheet and data management 
applications will be covered. 
Required Materials: Books:
  • Parson. New Perspectives on Microsoft Office Excel 2010 Comprehensive, 1st ed., Course Technology, 2011. ISBN: 9780538742917
Supplemental Materials: -->
Special Requirements: This course requires the use of a computer outside of class time to complete spreadsheet assignments--a minimum of approximately 3 hours
Program Learning Outcomes:
Global Learning Outcomes and Objectives:

I.  	CRITICAL THINKING: students will evaluate the validity of 
their own and other’s ideas through questioning, analyzing, and 
synthesizing results into the creative process.
C.  Apply understanding and knowledge to define, analyze, and devise 
solutions for new and different problems and issues.

III. 	SCIENTIFIC AND MATHEMATICAL LITERACY: students will apply 
an understanding of mathematical, natural and behavioral scientific 
principles and to solve abstract and practical problems.
A.  Engage in problem solving using various strategies that require 
presentation of questions, organization of information, performance 
of computations or estimation, drawing diagrams, analyzing 
situations, graphing and modeling, drawing conclusions, verifying and 
interpreting the results.
B.  Apply knowledge and understanding of principles of mathematical 
and scientific inquiry to real world situations using a modeling 
process to include identifying the problem, interpreting the problem, 
employing the theory and tools to determine a solution, testing and 
interpreting the solution within the problem, and refining the 
solution if necessary.
D.  Use appropriate technology to enhance mathematical and scientific 
thinking and understanding.

IV.  	INFORMATION MANAGEMENT: students will use effective 
strategies to collect, verify, document and manage information from a 
variety of sources.
A.  Use information-seeking strategies necessary to access 
information efficiently and effectively using a variety of sources 
and techniques.
B.  Understand how information is organized, including cataloging and 
indexing systems in Web and traditional locator tools and their 
biases and limitations.
D.  Identify and use appropriate technology, including computer and 
multimedia resources and visual symbols, to address a variety of 
tasks and problems.

V.	CULTURAL LITERACY: students will develop an appreciation of 
human culture and its diversity and the role of the creative arts in 
society.	
B.  Assess mass media messages, derive important news and other 
essential information from a variety of sources, and thoughtfully use 
this knowledge as a responsible citizen.

VI.	SOCIAL SKILLS:  students will develop and use skills and 
attitudes that integrate the individual into society.
C.  Recognize unethical behavior such as plagiarism and its 
implications.Embody honesty, respectability, and integrity.

VII.	PERSONAL MANAGEMENT: students will develop habits of 
conduct that result in fulfilling personal and occupational 
accomplishments.
A.  Engage in lifelong learning and intellectual curiosity.
B.  Apply knowledge, skills, and attitudes to occupational pursuits.

Major Learning Outcome:

This course should enable the student to: 

Understand the fundamental operation of a spreadsheet software tool 
and spreadsheet terminology. Distinguish common applications of 
spreadsheet tools.
Employ Excel 2002 as a software tool for solving generally recognized 
spreadsheet problems.


              
              
Course Learning Outcomes:
Upon the completion of Comprehensive Excel 2002 Tutorials 1-11 and 
the Windows Tutorials, students will be able to: 

Windows Tutorials: Launch and exit Windows; use mouse and keyboard; 
identify the components of the Windows desktop; launch and exit 
applications; organize screen-based desktop; switch tasks in a multi-
tasking environment; use Windows menus; explore Windows toolbars. 
Open and close the File Manager; format and make student data disks.

Tutorial 1: Start and exit Excel. Discover how Excel is used in 
business. Identify the major components of the Excel window. Navigate 
an Excel workbook and worksheet. Open, save, print, and close a 
worksheet. Enter text, numbers, formulas, and functions. Correct 
mistakes. Perform what-if analysis. Clear contents of cells. Use the 
Excel Help system. 

Tutorial 2: Plan build, test, document, preview, and print a 
worksheet. Enter labels, values, and formulas. Calculate a total 
using the AutoSum button. Copy formulas using the fill handle and 
Clipboard. Learn about relative, absolute, and mixed references. Use 
the AVERAGE, MAX, and MIN functions to calculate values in the 
worksheet. Spell check the worksheet. Insert a row. Reverse an action 
using the Undo button. Move a range of cells. Format the worksheet 
using AutoFormat. Add comments to a cell. Center printouts on a page. 
Customize worksheet headers. 

Tutorial 3: Format data using the Number, Currency, and Percentage 
formats. Align cell contents. Center text across columns. Change 
fonts, font style, and front size. Clear formatting from cells. 
Delete cells from a worksheet. Use borders and color for emphasis. 
Add text box and graphics to a worksheet using the Drawing toolbar. 
Remove gridlines from the worksheet. Print in landscape orientation. 
Hide and unhide rows and columns. 

Tutorial 4: Identify the elements of an Excel chart. Learn which type 
of chart will represent your data most effectively. Create an 
embedded chart. Move and resize a chart. Edit a chart. Change the 
appearance of a chart. Place a chart in a chart sheet. Select 
nonadjacent ranges. Work with 3-D chart types. Add a picture to a 
chart. 

Tutorial 5: Identify the elements of an Excel list. Freeze rows and 
columns. Find and Replace values in a worksheet. Change Zoom settings 
to display a worksheet. Sort data in a list. Use a data form to 
enter, search for, edit, and delete records. Filter data in a list 
using AutoFilters. Apply conditional formatting to a range. Use 
worksheet labels in formulas. Insert subtotals into a list and change 
the subtotals outline view. Insert page breaks using Page Break 
Preview. Summarize a list using pivot tables and create a pivot 
chart. 

Tutorial 6: Create and print a worksheet group. Edit multiple 
worksheets 
of at the same time. Create 3-D cell references and workbook 
references. 
Consolidate information from multiple worksheets and workbooks. 
Create a 
template and know how to store and access templates. Create a lookup 
table and use the lookup function. 

Tutorial 7: Use the spell checker. Audit formulas, Trace and edit 
cell comments. 
Track, highlight, and review changes to the workbook. Save the 
workbook as a 
Web page. Create and edit hyperlinks. 

Tutorial 8:  Create validation rules for data entry. Protect 
worksheets. Create 
and use range names. Learn about macro viruses and Excel's security 
features. 
Edit and print a macro using Visual Basic Editor. Assign a macro to a 
keyboard 
shortcut and a button.
 
Tutorial 9: Examine cost-volume-profit relationships. Learn the 
principles of multiple what-if analyses. Use one-variable data tables 
to perform a what-if analysis. Use two-variable data tables to 
perform a what-if analysis. Create scenarios to perform what-if 
analyses. Create a scenario summary report to save your conclusions. 

Tutorial 10: Formulate a problem. Perform what-if analyses. Try to 
solve a problem using trial and error. Use Goal Seek to automate the 
trial-and-error- process. Use Solver to find the best solution. Crate 
an answer report. 

Tutorial 11: Import data from a text file into an Excel workbook. 
Retrieve data from a database using the Query Wizard. Retrieve data 
from multiple database tables. Retrieve data from a database into a 
pivot table. Retrieve stock market data from the World Wide Web. Use 
hyperlinks to view information on the World Wide Web. 

Methods of Evaluation:
Evaluation of student progress towards achieving the stated learning 
outcomes and performance objectives is the responsibility of the 
instructor, within the policies of the college and the department.  
Detailed explanations are included in the expanded Syllabus developed 
by the instructor for each section being taught.
Flexibility: It is the intention of the instructor to accomplish the objectives specified in the course syllabus. However, circumstances may arise which prohibit the fulfilling of this endeavor. Therefore, this syllabus is subject to change. When possible, students will be notified of any change in advance of its occurrence.

Student Email Accounts: Pensacola State College provides an institutional email account to all credit students. Pirate Mail is the official method of communication, and students must use Pirate Mail when communicating with the College. In cases where companion software is used for a particular class, emails may be exchanged between instructor and student using the companion software.

Note: For students with a disability that falls under the Americans with Disability Act or Section 504 of the Rehabilitation Act, it is the responsibility of the student to notify Student Resource Center for ADA Services to discuss any special needs or equipment necessary to accomplish the requirements for this course. Upon completion of registration with the Student Resource Center for ADA Services office, specific arrangements can be discussed with the instructor.

Equity Statement: Pensacola State College does not discriminate on the basis of race, color, national origin, sex, disability, age, religion, marital status, pregnancy, sexual orientation, gender identity or genetic information in its programs, activities and employment. For inquiries regarding the College's non-discrimination policies, contact: The Executive Director of Institutional Equity and Student Conduct 1000 College Boulevard. Building 5, Pensacola, Florida 32504 (850) 484-1759