CGS1570 Computer Concepts And Applications
There are no corequisites for this course.
Spreadsheet applications will be taught by a combination of lecture
and hands-on experience. Electronic spreadsheet and data management
applications will be covered.
- Parson. New Perspectives on Microsoft Office Excel 2010 Comprehensive, 1st ed., Course Technology, 2011. ISBN: 9780538742917
Additional materials may be assigned by the instructor to supplement the required materials. -->
||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
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
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
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
Employ Excel 2002 as a software tool for solving generally recognized
|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
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
Tutorial 6: Create and print a worksheet group. Edit multiple
of at the same time. Create 3-D cell references and workbook
Consolidate information from multiple worksheets and workbooks.
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
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
and use range names. Learn about macro viruses and Excel's security
Edit and print a macro using Visual Basic Editor. Assign a macro to a
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.
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.
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.
||Pensacola State College does not discriminate against any person on the basis of race, ethnicity, national origin, color, gender/sex, age, religion, marital status, pregnancy, disability, sexual orientation, gender identity, or genetic information in its educational programs, activities or employment. For inquiries regarding Title IX and the college’s nondiscrimination policies, contact the Associate Vice President for Institutional Diversity/Title IX Officer at (850) 484-1759, Pensacola State College, 1000 College Blvd., Pensacola, Florida 32504.