Learning Microsoft Office 2007, Deluxe Edition, 1st Edition © 2008, (Weixel, et al) Correlated to: Texas TEKS for 130.272. Principles of Information Technology (High School) TEXAS ESSENTIAL KNOWLEDGE AND SKILLS FOR CAREER AND TECHNICAL EDUCATION

Learning Microsoft Office 2007, Deluxe Edition, 1st Edition © 2008, (Weixel, et al)

Subchapter K. Information Technology 130.272. Principles of Information Technology (One-Half to One Credit). (a) General requirements. This course is recommended for students in Grades 9-10. (b) Introduction. Students develop computer literacy skills to adapt to emerging technologies used in the global marketplace. Students implement personal and interpersonal skills to prepare for a rapidly evolving workplace environment. Students enhance reading, writing, computing, communication, and reasoning skills and apply them to the information technology environment. (c) Knowledge and skills. (1) The student demonstrates the necessary skills for career development, employability, and successful completion of course outcomes. The student is expected to: (A) identify and demonstrate positive work behaviors that enhance employability and job advancement such as regular attendance, promptness, attention to proper attire, maintenance of a clean and safe work environment, appropriate voice, and pride in work;

SE: 93, 144, 162-163, 217, 355, 831, 848, 887, 895, 903

(B) identify and demonstrate positive personal qualities such as flexibility, open-mindedness, initiative, listening attentively to speakers, and willingness to learn new knowledge and skills;

SE: 9, 144, 189, 217, 355, 831, 848, 887, 895

(C) employ effective reading and writing skills;

SE: 35-36, 43, 61-66, 72-80, 92, 104, 125, 144, 164-166, 180, 231, 249-250, 263, 290, 580, 584, 863, 903 TE: 266

(D) employ effective verbal and nonverbal communication skill;

SE: 6, 9, 52, 66, 71, 80, 202, 286, 295, 308, 378, 519, 555

SE = Student Edition

1

TE = Teacher’s Edition

Learning Microsoft Office 2007, Deluxe Edition, 1st Edition © 2008, (Weixel, et al) Correlated to: Texas TEKS for 130.272. Principles of Information Technology (High School) TEXAS ESSENTIAL KNOWLEDGE AND SKILLS FOR CAREER AND TECHNICAL EDUCATION

Learning Microsoft Office 2007, Deluxe Edition, 1st Edition © 2008, (Weixel, et al)

(E) solve problems and think critically;

This standard is addressed throughout the text, representative citations include the following: SE: 2-9, 32-40, 43, 88-92, 103, 115, 124-129, 137, 168-172, 192-197, 206, 220-226, 252256, 302-308, 312, 358-364, 396-399, 426, 428-435, 474-482, 516-519, 536-541, 566570, 586-588, 618, 620-625, 650-654, 678682, 702-709, 722-727, 760-765, 806, 818823, 842-848, 890-891 TE: 41-46, 93-98, 130-133, 173-176, 198-202, 227-234, 257-268, 309-315, 365-371, 400406, 436-440, 483-488, 520-525, 542-548, 571-574, 589-597, 626-634, 655-660, 683687, 710-714, 728-732, 766-771, 824-827, 849-856, 892-893

(F) demonstrate leadership skills and function effectively as a team member;

SE: 9, 189, 217, 355, 831, 848, 887, 895 TE: 290, 555

(G) identify and implement proper safety procedures;

SE: 267, 314, 334, 903

(H) demonstrate an understanding of legal and ethical responsibilities in relation to the field of information technology; and

SE: 781, 848

(I) demonstrate planning and time-management skills such as project management and storyboarding.

SE: 868-875, 876-884, 887

(2) The student identifies various employment opportunities in the information technology field. The student is expected to: (A) identify job opportunities and accompanying job duties and tasks;

SE: 2, 72, 78, 80, 92, 163, 295, 312, 459, 580, 597, 639, 654, 806, 831, 895, 903

(B) research careers of personal interest along with the education, job skills, and experience required to achieve personal career goals; and

SE: 639, 654, 895

(C) describe understanding of the functions of resumés and portfolios.

SE: 72-80, 103, 107, 182, 192, 459, 580, 919

SE = Student Edition

2

TE = Teacher’s Edition

Learning Microsoft Office 2007, Deluxe Edition, 1st Edition © 2008, (Weixel, et al) Correlated to: Texas TEKS for 130.272. Principles of Information Technology (High School) TEXAS ESSENTIAL KNOWLEDGE AND SKILLS FOR CAREER AND TECHNICAL EDUCATION

Learning Microsoft Office 2007, Deluxe Edition, 1st Edition © 2008, (Weixel, et al)

(3) The student uses emerging technologies to exchange information. The student is expected to: (A) identify and describe functions of various new and emerging technologies;

This standard is addressed throughout the text, representative citations include the following: SE: 19-25, 32-40, 88-92, 124-129, 168-172, 192-197, 220-226, 252-256, 302-308, 358364, 396-399, 428-435, 474-482, 516-519, 536-541, 586-588, 620-625, 678-682, 722727, 842-848, 906-908 TE: 41-46, 93-98, 130-133, 173-176, 198-202, 227-234, 257-268, 309-315, 365-371, 400406, 436-440, 483-488, 520-525, 542-548, 571-574, 589-597, 626-634, 655-660, 683687, 710-714, 728-732, 766-771, 824-827, 849-856, 892-893

(B) send and receive text information and file attachments using electronic methods such as email, electronic bulletin boards, and instant message services;

SE: 183-186, 242-243, 849-856, 857-867, 877878, 891, 899, 902, 904, 913 TE: 168, 188, 903

(C) demonstrate effective Internet search strategies, including keywords and Boolean logic using various available search engines;

SE: 43, 103, 115, 137, 164, 186, 206, 244, 249, 256, 268, 290, 299, 312, 378, 426, 519, 584, 618, 806, 848, 897 TE: 27, 49, 50, 66, 86, 182, 208, 245, 269, 270, 272, 296, 304, 327, 332, 335, 389, 411, 472, 506, 583

(D) dissect and identify the various components of a Uniform Resource Locator;

SE: 45, 378, 584, 598, 612 TE: 375

(E) demonstrate ability to effectively test acquired information from the Internet for accuracy, relevance, and validity;

SE: 897 Opportunities to address this standard may also be found on the following pages: SE: 43, 103, 115, 137, 164, 186, 206, 244, 249, 256, 268, 290, 299, 312, 378, 426, 519, 584, 618, 806, 848 TE: 27, 49, 50, 66, 86, 182, 208, 245, 269, 270, 272, 296, 304, 327, 332, 335, 389, 411, 472, 506, 583

(F) explain issues concerning Internet security protocols such as computer viruses, online predators, hacking, and identity theft;

SE: 859, 863, 903, 904

(G) define and identify unethical practices such as hacking, phone fraud, online piracy, and data vandalism; and

SE: 859, 863, 903, 904

SE = Student Edition

3

TE = Teacher’s Edition

Learning Microsoft Office 2007, Deluxe Edition, 1st Edition © 2008, (Weixel, et al) Correlated to: Texas TEKS for 130.272. Principles of Information Technology (High School) TEXAS ESSENTIAL KNOWLEDGE AND SKILLS FOR CAREER AND TECHNICAL EDUCATION

Learning Microsoft Office 2007, Deluxe Edition, 1st Edition © 2008, (Weixel, et al)

(H) demonstrate ethical use of Internet and online resources, including citation of source.

SE: 256, 269-270, 290 TE: 276

(4) The student demonstrates knowledge of the hardware components associated with information systems. The student is expected to: (A) identify the different computer classifications such as minicomputer, mainframe, and microcomputer;

Opportunities to address this standard may be found on the following pages: SE: 2-9, 35, 137, 914

(B) identify major hardware components and their functions such as the central processor unit, input and output peripherals, and storage systems and devices;

SE: 2-9, 35, 137, 914

(C) use available reference tools such as user manuals, both online and written, as appropriate;

SE: 47-52, 54, 88, 376, 836

(D) demonstrate understanding of the process of connecting peripheral devices; and

Opportunities to address this standard may be found on the following pages: SE: 4-5, 43, 74, 98, 125, 302-303, 329, 600, 706, 754, 851, 914

(E) demonstrate proficiency in the use of a variety of input devices such as mouse, keyboard, microphone, digital camera, printer, scanner, and optical disk reader.

SE: 4-5, 43, 74, 98, 125, 302-303, 329, 600, 706, 754, 851, 914 TE: 41-42, 45-46, 202, 314, 435, 673, 680, 856

(5) The student demonstrates knowledge of the different software associated with information systems. The student is expected to: (A) differentiate between systems and application software;

SE: 2-3, 109, 367, 629, 725, 782, 834, 914, 920

(B) identify and understand major operating system fundamentals and components;

SE: 4-5, 35-37, 89-90, 108, 110

(C) identify the function and operation of compilers and interpreters;

Opportunities to address this standard may be found on the following pages: SE: 2-3, 4-5, 35-37, 89-90, 108, 109, 110, 367, 629, 725, 782, 834, 914, 920

(D) identify various computer languages and how the languages are used in software development;

SE: 3, 32, 35, 109, 367, 913

(E) recognize data representation in software development such as string, numeric, character, integer, and date;

Opportunities to address this standard may be found on the following pages: SE: 3, 32, 35, 109, 367, 913 TE: 77

SE = Student Edition

4

TE = Teacher’s Edition

Learning Microsoft Office 2007, Deluxe Edition, 1st Edition © 2008, (Weixel, et al) Correlated to: Texas TEKS for 130.272. Principles of Information Technology (High School) TEXAS ESSENTIAL KNOWLEDGE AND SKILLS FOR CAREER AND TECHNICAL EDUCATION

Learning Microsoft Office 2007, Deluxe Edition, 1st Edition © 2008, (Weixel, et al)

(F) demonstrate understanding of file extensions and the purpose of file types across software products;

SE: 35, 108-110, 118, 337, 367, 586, 605, 725, 913

(G) recognize computer numbering systems and internal data representation;

SE: 139-141, 253-254, 259, 270, 400, 402, 671, 714

(H) identify appropriate use of application software;

Opportunities to address this standard may be found on the following pages: SE: 2-3, 4-5, 35-37, 89-90, 108, 109, 110, 367, 629, 725, 782, 834, 914, 920

(I) identify new and emerging classes of software;

Opportunities to address this standard may be found on the following pages: SE: 2-3, 4-5, 35-37, 89-90, 108, 109, 110, 367, 629, 725, 782, 834, 914, 920

(J) identify open source and proprietary licenses;

Opportunities to address this standard may be found on the following pages: SE: 2-3, 4-5, 35-37, 89-90, 108, 109, 110, 367, 629, 725, 782, 834, 914, 920

(K) demonstrate proper use of system management tools; and

Opportunities to address this standard may be found on the following pages: SE: 4-5, 35-37, 89-90, 108, 110

(L) demonstrate proper file management techniques such as creating, naming, organizing, copying, moving, and deleting files.

SE: 11-12, 232, 238, 244, 417-421 TE: 108, 290, 392

(6) The student analyzes network systems. The student is expected to: (A) identify hardware associated with telecommunications and data networking such as servers, routers, switches, hubs, and network connectors;

Opportunities to address this standard may be found on the following pages: SE: 9, 26, 35, 98, 168, 372, 516, 519, 566, 781, 849, 897, 915, 922

(B) identify and describe various types of networks such as peer-to-peer, local area networks, wide area networks, wireless token ring, and Ethernet;

SE: 9, 26, 35, 98, 168, 372, 516, 519, 566, 781, 849, 897, 915, 922

(C) identify and describe functions of network operating systems; and

Opportunities to address this standard may be found on the following pages: SE: 9, 26, 35, 98, 168, 372, 516, 519, 566, 781, 849, 897, 915, 922

(D) explain troubleshooting techniques for various network connection issues.

Opportunities to address this standard may be found on the following pages: SE: 9, 26, 35, 98, 168, 372, 516, 519, 566, 781, 849, 897, 915, 922

SE = Student Edition

5

TE = Teacher’s Edition

Learning Microsoft Office 2007, Deluxe Edition, 1st Edition © 2008, (Weixel, et al) Correlated to: Texas TEKS for 130.272. Principles of Information Technology (High School) TEXAS ESSENTIAL KNOWLEDGE AND SKILLS FOR CAREER AND TECHNICAL EDUCATION

Learning Microsoft Office 2007, Deluxe Edition, 1st Edition © 2008, (Weixel, et al)

(7) The student applies word-processing technology. The student is expected to: (A) identify the terminology associated with wordprocessing software and its functions;

SE: 32, 41, 47, 108, 124, 130, 173, 183, 192, 269, 279, 287, 347

53, 61, 67, 72, 134, 138, 145, 203, 209, 220, 302, 309, 316,

88, 93, 99, 104, 151, 157, 168, 235, 241, 252, 326, 336, 342,

(B) improve the touch-system skill using the keyboard and keypad to input data;

SE: 4-5, 53-54 TE: 55, 59

(C) edit a variety of text documents using functions such as pagination, appropriate white space, tab settings, and font style, size, and color;

SE: 124-129, 130-133, 134-137, 138-144, 145150, 151-156, 157-161, 162-163, 164-166 TE: 120

(D) create professional letters using advanced wordprocessing features;

SE: 61-66, 68, 92, 104, 107, 144, 249-250

(E) apply formatting techniques to a multipage research paper using approved publication standards such as American Psychological Association and Modern Language Association;

SE: 256, 269-278, 286

(F) produce desktop publishing documents incorporating both text and graphics such as business cards, newsletters with mastheads, and advertisement flyers; and

SE: 316-325, 326-335, 336-341, 342-346, 351354, 355-356

(G) demonstrate file protection and security.

Opportunities to address this standard may be found on the following pages: SE: 610, 613-615, 835 TE: 368

(8) The student applies spreadsheet technology. The student is expected to: (A) identify the terminology associated with spreadsheet software and its functions;

SE: 358, 365, 372, 379, 387, 396, 400, 407, 412, 417, 428, 436, 441, 446, 453, 460, 474, 483, 489, 493, 497, 502, 507, 516, 520, 526, 536, 542, 549, 554, 566, 571, 575

(B) format and organize numerical content to perform mathematical processes such as addition, subtraction, multiplication, and division; percentages and decimals; and order of operations principle;

SE: 379-386, 387-390, 428-435

(C) employ both student-created formulas and preprogrammed functions to produce documents such as budget, payroll, statistical tables, and personal checkbook register;

SE: 387-390, 428-435, 436-440, 441-445, 446452, 536-541, 542-548, 549-553, 554-560

SE = Student Edition

6

TE = Teacher’s Edition

Learning Microsoft Office 2007, Deluxe Edition, 1st Edition © 2008, (Weixel, et al) Correlated to: Texas TEKS for 130.272. Principles of Information Technology (High School) TEXAS ESSENTIAL KNOWLEDGE AND SKILLS FOR CAREER AND TECHNICAL EDUCATION

Learning Microsoft Office 2007, Deluxe Edition, 1st Edition © 2008, (Weixel, et al)

(D) create and analyze spreadsheets incorporating advanced features such as lookup tables, nested IF statements, subtotals, cell protection conditional formatting, charts, and graphs; and

SE: 428-435, 436-440, 441-445, 446-452, 453459, 460-468, 516-519, 520-525, 526-530, 536-541, 542-548, 549-553, 554-560

(E) edit a variety of spreadsheets by performing data management procedures using simple and multiple search parameters to locate, sort, search, and filter data.

SE: 428-435, 436-440, 441-445, 446-452, 536541, 542-548, 549-553, 554-560

(9) The student applies database technology. The student is expected to: (A) identify the terminology associated with database software and its functions;

SE: 586, 589, 597, 604, 610, 620, 626, 635, 640, 650, 655, 661, 667, 678, 683, 688, 694, 702, 710, 715

(B) create, populate, edit, maintain, and save database files;

SE: 589-596, 597-603, 604-609, 610-615

(C) differentiate the nature and interrelationships of fields and records;

SE: 587-588, 593, 597-603, 607, 620-625

(D) perform data management procedures such as locating, sorting, searching, querying, organizing, and outputting data;

SE: 678-682, 683-687, 688-693, 694-698, 702709

(E) use data management procedures using multiple search parameters; and

SE: 678-682, 683-687, 688-693, 694-698

(F) produce organized reports with calculated figures.

SE: 702-706, 710-714, 715-718, 719, 720

(10) The student applies presentation management technology. The student is expected to: (A) identify the terminology associated with presentation software and its functions;

SE: 722, 728, 733, 740, 746, 752, 760, 772, 777, 782, 788, 796, 801, 807, 818, 824, 833

(B) create, save, edit, and produce presentations with appropriate handouts and speaker notes; and

SE: 722-727, 728-733, 740-745, 746-751, 752756, 757, 758

(C) create a non-linear presentation incorporating links, hyperlinks, audio, and graphics.

SE: 772-776, 777-781, 782-788, 788-795, 796800, 807-811, 812-814, 815-816

(11) The student applies design and web publishing techniques. The student is expected to: (A) identify the terminology associated with web page editing software and its functions;

SE: 168, 173, 177, 183, 566

(B) identify the terminology associated with interactive media;

SE: 168, 173, 177, 566

SE = Student Edition

7

TE = Teacher’s Edition

Learning Microsoft Office 2007, Deluxe Edition, 1st Edition © 2008, (Weixel, et al) Correlated to: Texas TEKS for 130.272. Principles of Information Technology (High School) TEXAS ESSENTIAL KNOWLEDGE AND SKILLS FOR CAREER AND TECHNICAL EDUCATION

Learning Microsoft Office 2007, Deluxe Edition, 1st Edition © 2008, (Weixel, et al)

(C) identify and describe design principles such as contrast, repetition, alignment, and proximity;

Opportunities to address this standard may be found on the following pages: SE: 168, 173, 177, 183, 566 TE: 176

(D) identify and describe types and styles of typeface used for publications such as serif and sans serif; and

SE: 72-80

(E) create a web page containing links, graphics, and text.

SE: 168, 173, 177, 183, 566 TE: 176

(12) The student understands and demonstrates legal and ethical procedures as they apply to the use of information technology. The student is expected to: (A) demonstrate ethical use of online resources;

SE: 781, 848

(B) adhere to copyright rules and regulations;

SE: 256, 269, 290

(C) differentiate between copyright and trademarks;

Opportunities to address this standard may be found on the following pages: SE: 256, 269, 290

(D) explain the concept of intellectual property;

Opportunities to address this standard may be found on the following pages: SE: 256, 269, 290

(E) examine the consequences of plagiarism; and

Opportunities to address this standard may be found on the following pages: SE: 256, 269, 290

(F) describe the function of a non-disclosure agreement.

Opportunities to address this standard may be found on the following pages: SE: 781, 848

http://www.tea.state.tx.us/index4.aspx?id=2206

SE = Student Edition

8

TE = Teacher’s Edition