ITEC1001:ProficiencyTest:StudentInformation

From GGCWiki
Jump to: navigation, search

Contents

Introduction to Computing Proficiency Exam Student Information Sheet



Location: Proctored at GGC Testing Center, Building D, Suite 1301, Phone- 687-407-5322,Email-GGCTesting@ggc.edu

Overview

ALL GGC students must take a minimum two (2) ITEC courses ( a total of 8 credit hours) in order to graduate:

All students can choose Option A, B or Option D. In order to do Option C without taking ITEC 1001 first, you must take and pass a proficiency exam that covers content taught in ITEC 1001. This proficiency exam does NOT give you any course credit for ITEC 1001. If you pass the exam, you may still choose Option A, B, or C.
(For IT majors: enroll in ITEC 2140 instead of ITEC 2120.)

The proficiency exam is the tool we use to determine if you are given the option to place out of ITEC1001. This exam will neither give you credit for ITEC1001 nor will the result of the exam exempt you from any of the General Education requirements. The result you receive on the exam is only used for placement - it will not appear anywhere on your transcript and will not affect your grade in any course. You can only take the exam once.
a student seeking to receive credit for ITEC 1001 should talk to the Testing Center about taking the CLEP test.

Registering for the Exam

You must schedule and register to take the exam at the Testing Center. Instructions will be provided at the Testing Center.

Topics Covered in the Exam

The exam is primarily based on the textbooks: 1) Investigating Technology (By Todman and Wilhem) and 2) MS Office 2016 (by Randy Nordell) Microsoft Office Suite – Word, Excel, PowerPoint, and Access
However, any textbook covering the topics listed below could be used to help you prepare:

Concepts

  1. Software
    1. System Software
      1. Operating System
      2. Utilities
      3. File Management
    2. Application Software
      1. Types of Application SW
      2. Mobile Apps
      3. Social Media Apps
    3. Ethics in IT
  2. Hardware
    1. Inside the Computer
    2. System Unit and Motherboard
    3. CPU and Memory
    4. Storage
    5. Input and Output
  3. The Internet
    1. History and Structure
    2. Overview of Internet Services
    3. Web Browsers
    4. Exploring the Web
    5. Finding Information
    6. The Social Web
    7. Netiquettes
    8. Electronic Commerce
  4. Networking and Immersive Reality
    1. Computer Networks
    2. Topologies of Networks
    3. Virtual Reality
    4. Augmented Reality
    5. Mixed Realities
  5. Security
    1. Basic Security Concepts
    2. Safeguarding Data
    3. Legal and Ethical Issues
    4. Piracy and Copyright
    5. Personal Conduct
    6. Privacy and Surveillance
  6. Emerging Technologies
    1. Computer Careers

MS Office

MS Word

  1. Creating and Editing Documents
    1. Creating, Saving and Opening Documents
    2. Entering and Selecting Text
    3. Moving and Copying Text
    4. Changing Fonts, Font Sizes, and Attributes
    5. Changing Text Alignment, Line Spacing, and Paragraph Spacing
    6. Checking Spelling and Grammar and Using the Thesaurus
    7. Customizing Document Properties
  2. Formatting and Customizing Documents
    1. Customizing Margins and Page Layout
    2. Setting, Using, and Editing Tabs
    3. Using Indents
    4. Inserting Page Numbers, Headers, and Footers
    5. Using Page and Section Breaks
    6. Using Bulleted and Numbered Lists
    7. Using Styles and Themes
    8. Using Find and Replace
    9. Using Borders, Shading, and Hyperlinks
  3. Working with Reports and Multipage Documents
    1. Using Footnotes and Endnotes
    2. Creating a Bibliography and Inserting Citations
    3. Inserting a Table of Contents
    4. Inserting a Cover Page
    5. Using Bookmarks
    6. Using Advanced Headers and Footers
  4. Using Tables, Columns and Graphics
    1. Creating and Editing Tables
    2. Arranging Text in Tables
    3. Formatting and Editing Tables
    4. Working with Graphics

MS Excel

  1. Creating and Editing Workbooks
    1. Creating, Opening and Saving Workbooks
    2. Working with Text and Numbers
    3. Using the Sum Function
    4. Formatting a Worksheet
    5. Editing Columns and Rows
    6. Customizing Worksheets
    7. Finalizing a Workbook
  2. Working with Formulas and Function
    1. Creating and Editing Basic Formulas
    2. Working with Cell References
    3. Applying Mathematical Order of Operations
    4. Working with Common Functions
    5. Working with Financial, Logical, and Lookup Functions
    6. Working with Math and Trigonometry Functions
  3. Creating and Editing Graphs
    1. Creating a Chart Object and a Chart Sheet
    2. Designing a Chart with Quick Layouts and Styles
    3. Editing a Chart
    4. Formatting Chart Elements
    5. Using Images, Shapes, and WordArt in a Chart
    6. Creating and Editing a Pie Chart and a Combination Chart
    7. Inserting Sparklines in a Worksheet
  4. Importing, Creating Tables, Sorting and Filtering, and Using Conditional Formatting
    1. Importing Data
    2. Creating Excel Tables
    3. Sorting Data
    4. Filtering Data
    5. Using the Subtotal Command and Creating Outlines and Groups
    6. Apply Conditional Formatting
    7. Using Goal Seek and Worksheet Protection

MS Access

  1. Creating a Database and Tables
    1. Understanding Database Concepts
    2. Creating and Managing a Database
    3. Creating and Using a Table in Datasheet View
    4. Exploring Datasheet View
  2. Using Design View, Data Validation and Relationships
    1. Creating a Table in Design View
    2. Setting Field Properties
    3. Understanding Data Integrity and Data Validation
    4. Integrating Data Validation in Tables
    5. Changing Field Properties After Records Are Added Into a Table
    6. Understanding and Designing Relational Databases
    7. Importing Data Records from Excel
    8. Printing the Contents of a Table
    9. Managing a Database Using the Compact & Repair Database Utility
  3. Creating and Using Queries
    1. Understanding Queries and Using the Simple Query Wizard
    2. Creating, Running and Editing a Query in Design View
    3. Adding a Criterion to a Query
    4. More Query Options
    5. Defining Multiple Criteria in a Query
    6. Creating and Using a Simple Parameter Query
    7. Adding Calculated Fields to a Query
    8. Creating and Using a Summary Query

MS Power Point

  1. Creating and Editing Presentation
    1. Creating, Opening, and Saving Presentations
    2. Adding and Editing Presentation Text
    3. Rearranging Slides
    4. Working with Themes
    5. Inserting Headers and Footers
    6. Working with a Picture from a File
    7. Applying Transitions
    8. Explore Print Options
    9. Applying Properties
  2. Illustrating with Pictures and Information Graphics
    1. Work with Shapes, Colors and Styles
    2. Adding Text Effects and WordArt
    3. Working with Pictures
    4. Creating a Table
    5. Enhancing a Table
    6. Creating a SmartArt Graphic
    7. Enhancing a SmartArt Graphic
    8. Creating a Chart
    9. Enhancing a chart
  3. Preparing for Delivery and Using a Slide Presentation
    1. Creating Custom Theme Colors and Background Styles
    2. Applying Animation
    3. Linking to an Online Video
    4. Using Rehearsal Techniques
    5. Controlling Display Options
    6. Presenting Using Projection Equipment
    7. Using Annotation Pens
    8. Preparing a Self-Running Presentation
    9. Packaging a Presentation to a CD or Folder

Format of the Exam

This Proficiency Exam uses a web-based simulation program called SimNet. In order to take this exam, you must register your credentials in SimNet in order to obtain a free temporary access code. Please come to the testing center at least 30 minutes prior to your scheduled appointment in order to register in SimNet and obtain the necessary access code that will enable you to take the exam. The exam has two parts: 1) A concepts test that contains 100 multiple choice and true/false questions and 2) A simulation test that has 60 simulation-based questions from MS Word, Excel, PowerPoint, and Access. A score equal to or greater than 70% in EACH exam gives you the option of placing out of ITEC1001. Even if you pass the proficiency exam, you may still opt to take ITEC1001. Please be aware that doing well on the proficiency exam does not mean you are guaranteed a high grade in ITEC1001. All students taking ITEC1001 must complete many outside of class assignments, projects and labs that count significantly toward the final grade in ITEC1001.

Frequently Asked Questions

  • I took Computing Concepts at GPC and it seems like ITEC1001 is the same course. Do I really need to take the exam? Why don't my credits from GPC transfer over as ITEC1001?
Computing Concepts at GPC is a 1 credit-hour course whereas ITEC1001 at GGC is a 4 credit-hour course. This is the reason the credits do not transfer to ITEC1001 from Computing Concepts. If your Computing Concepts at GPC prepared you well enough to score high on the ITEC1001 proficiency exam, you may elect to take Digital Media and Intro. to Programming without having first taken ITEC1001.
  • I took Computer Course X at College Y that seems very similar to ITEC1001 at GGC. Did this course transfer and give me credit for ITEC1001?
You'll need to log into Banner and check your Academic Transcript. If the course you took transferred over to ITEC1999 or ITEC2999, this means that you received transfer credit, but the course does not match any of the courses we offer (that is what the 999 at the end means in general, not just for ITEC classes).
  • My question is not answered here. Who can I contact for more information?
Email Dr. Kamal Kakish for more information (kkakish@ggc.edu).
Personal tools