Download Dual Credit Exam Preparation: Competencies and Grading Scale for IT and Networking Courses and more Quizzes Information Technology in PDF only on Docsity!
DUAL CREDIT REVIEW SHEET
COMPUTER NETWORKING
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-Programing in Visual Basics
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-
CPSC 2820/2821 Cisco Networking Fundamentals and Lab
Credit Hours- (3)
A= 90-
B= 80-
C= 70-
D= 60-
F= 0-
CPSC 2830/2831 Cisco Router Fundamentals and Lab
Credit Hours- (3)
A= 90-
B= 80-
C= 70-
D= 60-
F= 0-
CPSC 2840/2841 Cisco Advanced Routers and Lab
Credit Hours- (3)
A= 90-
B= 80-
C= 70-
D= 60-
F= 0-
CPSC 2850/2851 Cisco WAN Technologies and Lab
Credit Hours- (3)
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 profi- ciency in computer applications. The student will demonstrate a working knowledge of word processing, electronic communication, and on-line databases, and spread- sheets. 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 capabili- ties. _______ 14. Discuss utility programs and their functions. _______ 15. Describe security risks that can threaten a computer system. _______ 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 college 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 footnotes _______ 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, func- tions 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 devel- oping 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 systems. 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 check mark ( ) indicates competencies that have been addressed at the secondary level.
Using the Visual Basic environment. The students should be familiar with the following terms and be able to describe the functions and usage of each of the following: _______ 6. Tour and get familiar with the Visual Basic environment. _______ 7. Place Visual Basic objects. _______ 8. Create, maintain and save Visual Basic files. _______ 9. Compile and run Visual Basic programs. _______ 10. Create executable files. _______ 11. Menu bar and toolbar _______ 12. Form window _______ 13. Project window _______ 14. Properties window _______ 15. Printing a project Programming fundamentals. The student should be able to write programs using: _______ 16. Variables, Expressions, and Statements. _______ 17. Data types. _______ 18. Program documentation. _______ 19. Interactive input and output. _______ 20. Divisibility _______ 21. Using counters, running totals, and loops. _______ 22. Strings and string functions. _______ 23. Menus _______ 24. Scrollbars _______ 25. Pixels and twips Program structures. The student should be able to employ structures and related features to write programs that use or exhibit: _______ 26. Relational operators and logical operators. _______ 27. If-Then Statements _______ 28. Strings and Menus _______ 29. Formatting, Modules and Code reusability. _______ 30. The scope of variables. _______ 31. Arrays. _______ 32. User defined data types _______ 33. Fundamental sorting algorithm _______ 34. Loops (do-while, do-until, for-next) _______ 35. Subprograms and functions
Programming in
Visual Basic - CPSC1230 3 Hours
Course Description: This course is designed to introduce the concepts of programming. The course will use a visual programming tool such as Microsoft Visual BASIC to intro- duce procedural/structured programming concepts. The course is designed to introduce programming to students with limited computer backgrounds. Course Objectives : At the end of the course the student should be able to have a compre- hensive understanding of the basic concepts of programming and the related terms and defi- nitions, the concepts of object oriented programming and be familiar with the environment of Visual Basic. The students are expected to be able to design and implement programs using Visual Basic at the end of the course. To accomplish this, instructions will be given to the following areas: _______ 1. Definitions of basic concepts relating to programming such as bits, bytes, words, the binary and hexadecimal number systems, ASCII and EBCDIC. _______ 2. Explain the social and legal ramifications of computer use. _______ 3. Explain the program development life cycle. _______ 4. Describe the diversity of programming languages. _______ 5. Concepts of object oriented programming such as class,
Web Design - INTC 1060 3 Hours
Course Description: Training includes design, image manipulation, hy- pertext language, hyperlinks, image maps, graphic images, tables, frames, forms, Cascading Style sheets, multimedia, Web editors, and JavaScript. To accomplish this, instructions will be given to the following areas: A. Complete understanding of HTML (Hypertext Markup Language) _______ 1. Basic Tags - can write the code for a web page _______ 2. Graphics / Images - can use tags _______ 3. Image Maps - can use tags _______ 4. Tables - can use tags _______ 5. Frames - can use tags _______ 6. Forms - can use tags _______ 7. Multimedia - audio, video, Java Applets - can use tags B. Cascading Style Sheets - can understand and utilize in conjunction with HTML C. JavaScript - has a working knowledge of JavaScript language and is able to incorporate into a web page D. Editors - has a working knowledge of HTML software E. Development of a personal Web site - articulating students must provide evidence of web site development to be included with articulation application and must design web page to include all elements of competencies checked above Teacher Date A check mark ( ) indicates competencies that have been addressed at the secondary level. Teacher Date A check mark ( ) indicates competencies that have been addressed at the secondary level.
Teacher Date A check mark ( ) indicates competencies that have been addressed at the secondary level. Teacher Date
______ n. Troubleshoot routers.
_______ o. Troubleshoot networks.
CPSC 2840 Cisco Advanced Routers
CPSC 2841 Cisco Advanced Routers Lab
3 credits (2 hrs lecture, 2 hrs lab)
This course introduces advanced router configuration, advanced
LAN switching theory and design, VLANS, Novell IPX, and
threaded case studies. Topics include router elements and op-
erations, adding routing protocols to a configuration, monitoring
IPX operations on the router, LAN segmentation, and advanced
switching methods.
Competencies:
1. Understanding of advanced router concepts and terminology.
At the end of the course the student should be able to:
_______ a. Develope Classless Routing. _______ b. Describe CIDR _______ c. Describe Route Aggregation and Supernetting. _______ d. Describe VLSM _______ e. Develope RIPv2 networks. _______ f. Develope Single-Area AXFp and EIGRP net- works. _______ g. Configure Enhanced Interior Gateway Routing Protocol networks. _______ h. Configure OSPF networks. _______ i. Name and desribe two switching methods. _______ j. Describe Ethernet/802.3 LANs. _______ k. Describe the basic operation of switches. _______ l. Describe teh benefits of network segementation with routers. _______ m. Describe the benefits of network segmentation with switches. _______ n. Distinguish between cut-through and store-and- forward LAN switching. _______ o. Describe the operation of the Spanning Tree Pro tocol and its benefits. _______ p. Describe the benefitsof virtual LANs.
- Hands-on experience. At the end of the course the student should be able to: _______ a. Add EIGRP routing protocol to your configuration. _______ b. Add OSPF routingprotocol to your configuration. _______ c. Create VLANs. _______ d. Configure trunk lines on switches. _______ e. Trouleshoot routers. _______ f. Troubleshoot networks.
CPSC 2850 Cisco WAN Technologies
CPSC 2851 Cisco WAN Technologies Lab
3 credits ( 2 hrs lecture, 2 hrs lab)
This course also introduces WAN theory and design, WAN technol-
ogy, PPP, Frame Relay, ISDN, and additional case studies. Topics
include network congestion problems, TCP/IP transport and network
layer protocols, advanced routing and switching configuration, ISDN
protocols, PPP encapsulation operations on a router.
Competencies:
- Understanding of advanced router concepts and terminology. At the end of the course the student should be able to: _______ a. Differentiate between the following WAN services: APB, Frame Relay, ISDN/LAPD, HDLC, PPP, and DDR. _______ b. Recgonize key Frame Relay terms and features. _______ c. Identify PPP operations to encapsulate WAN data on Cisco routers. _______ d. State a relevant use and context for ISDN BRI. _______ e. Identify ISDN protocols, function groups, reference points and channels. _______ f. Describe Cisco’s implementation of ISDN BRI. _______ g. Describe the DHCP process. _______ h. Describe NAT and PAT. _______ i. Describe Network Management. _______ j. Describe the concept of Server Service.
- Hands-on experience. At the end of the course the students should be able to: a. List commands to configure Frame Relay LMIs, maps and subinterfaces. b. List commands to monitor Frame Relay operation in the router. c. Troubleshoot routers. d. Troubleshoot networks. A check mark ( ) indicates competencies that have been addressed at the secondary level.
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
