Download Review for Quiz - Using Information Technology | CPSC 1100 and more Quizzes Information Technology in PDF only on Docsity!
DUAL CREDIT REVIEW SHEET
COMPUTER AND INFORMATION SCIENCE
WALTERS STATE COMMUNITY COLLEGE
Dual credit is a process that provides a transitional vehicle between secondary and post
secondary institutions. It offers high school students the opportunity to receive
postsecondary credit for the skills they have attained at the secondary level. Students,
meeting requirements to qualify for dual credit exams in the courses listed within this
review sheet, should study the competencies as a self-assessment of their current skill
level in preparation for the dual credit exam.
CPSC 1100 Using Information Technology
Credit Hours- (3)
Grading Scale
A= 90-
B= 80-
C= 70-
D= 60-
F= 0-
CPSC 1230 Programming in Visual Basic
Credit Hours- (3)
Grading Scale
A= 90-
B= 80-
C= 70-
D= 60-
F= 0-
INTC 1060 Web Design
Credit Hours- (3)
Grading Scale
A= 90-
B= 80-
C= 70-
D= 60-
F= 0-
INTC 1085 Hardware Support
Credit Hours- (4)
Grading Scale
A= 90-
B= 80-
C= 70-
D= 60-
F= 0-
Using Information
Technology - CPSC 1100 3 Hours
Catalog Description: This course is designed to assist the student in achieving proficiency in computer applications. The student will demon- strate a working knowledge of word processing, electronic communication, and on-line databases, and spreadsheets. Competencies: Understanding of computer concepts and terminology sufficient to aid each student in their academic and/or business endeavors. At the end of the course the student should be able to: I. Terminology _______ 1. Define the four operations of the information processing cycle. _______ 2. Identify categories of computers. _______ 3. Differentiate system and application software. _______ 4. Define CPU and primary storage. _______ 5. Define bits, bytes, and words. _______ 6. Define binary and ASCII. _______ 7. Identify components of the system unit and describe their use. _______ 8. Differentiate storage and memory. _______ 9. Describe multimedia and virtual reality. _______ 10. Identify different types of display types. _______ 11. Define secondary storage, its purpose and how data is stored. _______ 12. Define and discuss data communications and networking. _______ 13. Describe the various operating systems, the differences in their capabilities. _______ 14. Discuss utility programs and their functions. _______ 15. Describe security risks that can threaten a computer sys- tem. _______ 16. Describe computer viruses and steps to prevent them. _______ 17. Discuss ethical and privacy issues relating to the information age. II. Word Processing (Word) The ability to use a modern word processor package to produce finished documents commonly found in the work place or associated with col- lege level course work. At the end of the course the student should be able to: _______ 1. Demonstrate file retrieval and storage _______ 2. Create a document _______ 3. Understand word wrap _______ 4. Enter text into a document _______ 5. Import and scale graphics _______ 6. Format documents using: a. Font, font styles, and font size of text b. Margins, tabs, indents, and columns c. Templates _______ 7. Edit documents using: a. Inserting and deleting, moving, copying, and repl- acing text b. Searching for text c. Spelling and grammar checkers and Thesaurus _______ 8. Work with multiple documents _______ 9. Work with long documents _______ 10. Demonstrate headers/footers, page numbering, and foot- notes _______ 11. Creating, editing, and formatting tables _______ 12. Creating page and section breaks and understanding the difference III. Spreadsheets (Excel) The ability to use an electronic spreadsheet to produce finished documents commonly found in the work place or associated with college level course work. At the end of the course work the student should be able to: _______ 1. Demonstrate file retrieval and storage _______ 2. Enter, use, and understand the difference between text, numbers, functions and formulas _______ 3. Edit spreadsheets by: a. Deleting, inserting, and changing cell contents b. Copying and moving contents and ranges of cells c. Running a spell check _______ 4. Testing the accuracy of spreadsheet math _______ 5. Format spreadsheets by: a. Using AutoFormat, toolbars(s), and menus b. Deleting and inserting cells, rows, and columns c. Resizing the height and width of cells d. Aligning cell contents e. Centering text across columns f. Adding borders, lines, and color g. Controlling spreadsheet display _______ 6. Distinguish between relative and absolute cell references _______ 7. Understand and print cell contents and formulas _______ 8. Print to fit - including portrait and landscape orientation _______ 9. Freeze rows and columns _______ 10. Create and modify charts _______ 11. Demonstrate decision making using the IF function IV. Presentation (MS PowerPoint) An understanding of the role of Microsoft Windows/operating systems. At the end of the course, the student should be able to: _______ 1. Understand the basic concepts for the use of color and images in developing a slide show _______ 2. Demonstrate file retrieval and storage _______ 3. Enter, use, text, numbers, and images to create a simple slide show _______ 4. Edit slide show by: a. Deleting, inserting, and changing slide contents b. Copying and moving contents between slides c. Running a spell check _______ 5. Testing the accuracy of a slide show V. Internet The ability to access and use the Internet. At the end of the course, the student should be able to: _______ 1. Define the Internet _______ 2. Access WWW _______ 3. Create and remove bookmarks ______ 4. Save and print Web pages _______ 5. Copy and paste from Web pages using the Clipboard _______ 6. Search the Web using a variety of search engines _______ 7. Retrieve files from the Internet _______ 8. Send and receive electronic mail _______ 9. Perform electronic mail management functions VI. Operating Systems (Windows) An understanding of the role of Microsoft Windows/operating sys- tems. At the end of the course, the student should be able to: _______ 1. Describe Microsoft Windows/operating systems _______ 2. Work with menus _______ 3. Start and exit an application _______ 4. Demonstrate an understanding of directories and subdirec- tories including directory structures and paths _______ 5. Create, save, open, and print a document _______ 6. Open, enlarge, and scroll a window _______ 7. Format and copy diskettes _______ 8. Copy a group of files _______ 9. Change drives _______ 10. Delete a file _______ 11. Switch between applications _______ 12. Activate, resize, and close a group window _______ 13. Arrange icons _______ 14. Maximize, minimize, and resize a group VII. On-line Databases _______ 1. Access and search online databases for research informati- on _______ 2. Use the online card catalog to find a book in libraries _______ 3. Find and check out an e-book
Teacher Date A checkmark ( ) indicates competencies that have been addressed at the secondary level. VI. Basic Networking
- Identify basic networking concepts, including how a network works and the ramifications of repairs on the network. VII. Operating System Fundamentals
- Identify the operating system’s functions, structure, and major system file to navigate the operating system and how to get to needed technical information.
- Identify basic concepts and procedures for creating, viewing, and managing files, directories, and disks. This includes procedures for changing file attributes and the ramifications of those changes (ex. security issues) VIII. Installation, Configuration, Upgrading
- Identify the procedures for installing Windows 9x and Windows 2000, Wnidowxs XP, and Windows 2003, and the steps to bring the software to a basic operational level.
- Identify the steps to perform an operating system up-grade.
- Identify teh basic system boot sequences adn boot methods including the steps to create an emergency boot disk with utilities installed for Windows 9x, Windows NT, WIndows 2000, Windows XP, and Windows 2003.
- Identify procedures for loading/adding and configuring application device drivers and the necessary software for certain devices. IX. Diagnosing and Troubleshooting
- Recognize and interpret the meaning of common error codes and startup messages from the boot sequence and identify steps to correct the problem.
- Recognize common problems and determine how to resolve them. X. Networks
- Identify the networking capabilities of Windows, including procedures for connecting to the network.
- Identify concepts and capabilities relating to the Internet and basic procedures for setting up a system for Internet access.
Hardware Support - INTC 1085 4 Hours
Course Description: This course addresses the necessary skills to
produce knkowledge and support for basic software and hardware configuration, troubleshooting and diagnosis, along with associated safety issues. Instruction provided will begin the preparation for tak- ing the A+ Certification Exam. To accomplish this, instructions will be given to the following areas: I. Installation, Configuration, Upgrading
- Identify basic terms, concepts, and functions of system modules, including how each module should work durng normal operation and during the boot process.
- Identify basic procedures for adding and removing field replacable modules for both desktop and portable systems.
- Identify available IRQ’s, DMAs and I/O addresses and procdeures for device installation and configuration.
- Identify common peripheral ports, associated cabling, and their connectors.
- Identify proper procudures for installing and configuring IDE/EIDE devices.
- Identify proper procedures for installing and configuring SCSI devices.
- Identify proper procedures for installing and configuring peripheral devices.
- Identify hardware methods of upgrading performance, procedures for replacing basic subsystem componenets, unique components and when to use them. II. Diagnosing and Troubleshooting
- Identify common symptoms and problems associated with each module and how to troubleshoot and isolate the problems.
- Identify basic troubleshooting procedures and how to elicit problem symptoms frm customers. III. Preventative Maintenance
- Identify the purpose of various types of preventative maintenance products and procedures and when to use them.
- Identify issues, procedures, and device for protection within the computing environment, incuding people, hardware and the surrounding workplace. IV. Motherboards, Processors, Memory
- Distinguish between the popular CPU chips in terms of their basic characteristics.
- Identify the catagories of RAM terminology, their locations, and their physical characteristics.
- Identify the most popular types of motherboards, their components, and their architecture (bus structures and power supplies)
- Identify the purpose of CMOS, what it contains, and how to change its basic parameters. V. Printers
- Identify basic concepts, printer operations, and printer components.
- Identify care and service techniques and common problems with primary printer types.
A checkmark ( ) indicates competencies that have been addressed
at the secondary level.
Teacher Date
