独联体2010 Literacy Screening Test

关于 the 独联体1020 Screening Test

For the 独联体2010 course the prerequisites are:

• completion of 独联体/CS 1010 course with a grade of C or better, or
• appropriate score on the Computer Information System computer literacy screening test.
• 2010年独联体 also requires completion of 英格1010, eng1020, mat1310 (may be taken as a co-prerequisite) 和CAS1010

The test is available in the Assessment and Testing Center in 蒂沃利347房间. For their office hours, policies and procedures, and other useful information, check the 测试网站. To make a reservation, call the Testing Center during their regular office hours.

General instructions for the test:

1. Part A of the exam has 50 computer concepts questions worth one point each. All 50 questions must be answered within 60 minutes.
2. Part B of the exam has 50 Access and Excel questions. All 50 questions must be answered within 60 minutes.
3. Scores are available within two business days of taking the test. The scores are arrived at by combining the points earned from both Parts A and B of the exam.
4. Students scoring 75% or higher will be able to register for 独联体2010.
5. Students scoring below 75% may register for 独联体/CSS 1010.
6. Students may take the test twice in a five year period. 学生可以不参加考试
   同一天两次.

概念:

• Main memory (RAM, ROM, PROM, etc.)
• Firmware/essential business applications
• Types of computers (Super, mainframe, micro)
• What determines computer speed
• Microprocessing chips (types, uses, size, speed, data size)
• 输入设备
• 输出设备
• 互联网
• 电子商务
• Basic Security and privacy issues

技能/工具:

• Reading-writing in English
• 口头交流
• Disk maintenance and backup; file copies, backups; housekeeping; output control
• GUI skills, window manipulation, integrated files, clipboard, cut copy and paste functions
• Windows accessories (WordPad, Paint)
• Basic Windows file and folder management
• Sending messages and files, within and without the domain
• Addressing, uploads and downloads
• 使用浏览器
• Spreadsheet constants and variables, making a dynamic spreadsheet with formulas and functions, and absolute and relative cell references
• Spreadsheet Charting, graphing embellishments
• Database tables, queries, forms and reports

For study materials go to: 2010年独联体 Literacy materials (PDF，第1部分)及 2010年独联体 Literacy materials (continued) (PDF，第2部分).

For study materials on Excel and Access, we recommend this site: http://www.gcflearnfree.org. Click on Microsoft Office and then on Office 2016 to read training materials and watch short videos on Excel and Access.