关于 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:
- Part A of the exam has 50 computer concepts questions worth one point each. All 50 questions must be answered within 60 minutes.
- Part B of the exam has 50 Access and Excel questions. All 50 questions must be answered within 60 minutes.
- 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.
- Students scoring 75% or higher will be able to register for 独联体2010.
- Students scoring below 75% may register for 独联体/CSS 1010.
- 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.