|
Cycle 1 Intermediate Personal, Academic, And Business Information Management Skills |
|
|
|
Assessing Basic Computer Skills |
|
|
2 | (3) |
|
Unit 1 Managing Digital Information |
|
|
5 | (41) |
|
1 Computers in the 21st Century |
|
|
5 | (8) |
|
2 Exploring Your Computer |
|
|
13 | (5) |
|
|
18 | (3) |
|
4 Keeping Resources Secure |
|
|
21 | (6) |
|
5 Improving Internet Skills |
|
|
27 | (6) |
|
Digital Citizenship and Ethics |
|
|
33 | (1) |
|
|
33 | (13) |
|
Academic and Career Connections |
|
|
39 | (1) |
|
Capitalization, Composition, Math Skills |
|
|
39 | (1) |
|
Introducing Career Clusters |
|
|
40 | (1) |
|
|
41 | (1) |
|
|
41 | (1) |
|
Assessing Basic Word Processing Skills |
|
|
42 | (4) |
|
Unit 2 Communicating Clearly |
|
|
46 | (33) |
|
21st Century Skills: Digital Citizenship and Ethics |
|
|
49 | (3) |
|
|
52 | (4) |
|
|
56 | (4) |
|
21st Century Skills: Initiative and Self-Direction |
|
|
59 | (1) |
|
|
60 | (4) |
|
10 Communicating Clearly with Letters |
|
|
64 | (3) |
|
11 Modified Block Format Letters with Additional Letter Features |
|
|
67 | (2) |
|
12 Additional Letter and Memo Features |
|
|
69 | (2) |
|
13 Multiple-Page Letters and Memos |
|
|
71 | (2) |
|
14 Memo and Letter Applications |
|
|
73 | (6) |
|
Academic and Career Connections |
|
|
76 | (1) |
|
Terminal Punctuation, Listening, Math Skills |
|
|
76 | (1) |
|
|
77 | (1) |
|
|
78 | (1) |
|
|
78 | (1) |
|
Unit 3 Analyzing Table Information |
|
|
79 | (25) |
|
15 Table Tabs, Indentations, and Lists |
|
|
81 | (4) |
|
16 Tables to Text and Text to Tables |
|
|
85 | (3) |
|
17 Tables with Repeated Headings |
|
|
88 | (3) |
|
|
91 | (4) |
|
21st Century Skills: Access and Evaluate Information |
|
|
94 | (1) |
|
19 Table Applications and Analysis |
|
|
95 | (9) |
|
Digital Citizenship and Ethics |
|
|
96 | (3) |
|
Academic and Career Connections |
|
|
99 | (1) |
|
Commas, Reading, Math Skills |
|
|
99 | (1) |
|
|
100 | (1) |
|
|
101 | (1) |
|
|
101 | (1) |
|
Assessing Basic Spreadsheet Skills |
|
|
102 | (2) |
|
Unit 4 Using Spreadsheets to Make Economic Choices |
|
|
104 | (34) |
|
20 Format Cells and Columns |
|
|
106 | (4) |
|
21 Worksheet Views, Page Setup, and Print |
|
|
110 | (5) |
|
22 Proofread and Print Settings |
|
|
115 | (3) |
|
23 Formatting and Worksheet Skills |
|
|
118 | (4) |
|
24 Freeze, Hide, Zoom, Print Titles, and Sort |
|
|
122 | (3) |
|
25 Charts, PDF Files, and Sparklines |
|
|
125 | (4) |
|
Digital Citizenship and Ethics |
|
|
128 | (1) |
|
26 Spreadsheet Applications |
|
|
129 | (9) |
|
21st Century Skills: Communicate Clearly |
|
|
131 | (1) |
|
|
132 | (1) |
|
Academic and Career Connections |
|
|
133 | (1) |
|
Number Expression, Speaking, Science |
|
|
133 | (1) |
|
|
134 | (1) |
|
|
135 | (1) |
|
|
135 | (1) |
|
Assessing Basic Database Skills |
|
|
136 | (2) |
|
Unit 5 Data Mining and Analyzing Records |
|
|
138 | (35) |
|
27 Data Mining and Analysis Using Queries |
|
|
142 | (7) |
|
Digital Citizenship and Ethics |
|
|
142 | (7) |
|
28 Data Mining and Analysis Using Computed Fields |
|
|
149 | (2) |
|
21st Century Skills: Use and Manage Information |
|
|
150 | (1) |
|
29 Creating Forms for Data Analysis |
|
|
151 | (4) |
|
30 Creating Reports for Data Analysis |
|
|
155 | (5) |
|
31 Using a Database to Create a Mail Merge |
|
|
160 | (4) |
|
|
164 | (9) |
|
Academic and Career Connections |
|
|
168 | (1) |
|
Quotation Marks, Italics, Composition, Math Skills |
|
|
168 | (1) |
|
|
169 | (1) |
|
|
170 | (1) |
|
|
170 | (1) |
|
Assessing Basic Presentation Skills |
|
|
171 | (2) |
|
Unit 6 Building Effective Presentations |
|
|
173 | (33) |
|
33 Build Slide Show Presentations with Screen Clippings |
|
|
178 | (4) |
|
34 Build Slide Show Presentations with Graphics, Animations, and Transitions |
|
|
182 | (6) |
|
21st Century Skills: Information, Communications, and Technology (ICT) Literacy |
|
|
186 | (2) |
|
35 Build Slide Show Presentations with Sound |
|
|
188 | (3) |
|
Digital Citizenship and Ethics |
|
|
190 | (1) |
|
36 Use Pen, Highlighter, and Shortcuts to Deliver an Effective Presentation |
|
|
191 | (4) |
|
37 Deliver an Effective Presentation |
|
|
195 | (1) |
|
38 Apply What You Have Learned |
|
|
196 | (10) |
|
|
198 | (3) |
|
Academic and Career Connections |
|
|
201 | (1) |
|
Other Internal Punctuation, Listening, Math Skills |
|
|
201 | (1) |
|
|
202 | (1) |
|
|
203 | (1) |
|
|
203 | (1) |
|
|
204 | (2) |
|
Unit 7 Real World Application I |
|
|
206 | (12) |
|
39-43 "HOOPS I" Jobs 1--13 |
|
|
208 | (10) |
|
Unit 8 Creating Effective Reports |
|
|
218 | (22) |
|
44 Report with Textual Citations |
|
|
222 | (3) |
|
45-46 Report with Footnotes |
|
|
225 | (4) |
|
Digital Citizenship and Ethics |
|
|
225 | (4) |
|
47-48 Collaborative Report with Footnotes |
|
|
229 | (3) |
|
49 Two-Column Report with Pictures |
|
|
232 | (2) |
|
|
234 | (6) |
|
Academic and Career Connections |
|
|
237 | (1) |
|
Abbreviations, Reading, Markups and Discounts |
|
|
237 | (1) |
|
|
238 | (1) |
|
|
239 | (1) |
|
|
239 | (1) |
|
Unit 9 Using Design to Enhance Communication |
|
|
240 | (23) |
|
51 Agendas and Meeting Minutes |
|
|
242 | (4) |
|
|
246 | (3) |
|
21st Century Skills: Make Judgments and Decisions |
|
|
248 | (1) |
|
53 Itineraries and Invitations |
|
|
249 | (2) |
|
Digital Citizenship and Ethics |
|
|
250 | (1) |
|
54 Purchase Orders, Invoices, Thank You Cards, and Certificates |
|
|
251 | (2) |
|
55 Business Documents Applications |
|
|
253 | (10) |
|
Academic and Career Connections |
|
|
258 | (1) |
|
Sentence Types, Speaking, Probability |
|
|
258 | (1) |
|
|
259 | (1) |
|
|
259 | (1) |
|
|
260 | (1) |
|
Assessing Basic Personal Information Management (PIM) Skills |
|
|
261 | (2) |
|
Unit 10 Managing Communications and Schedules |
|
|
263 | (26) |
|
|
269 | (3) |
|
57 Create and Edit Contact Groups |
|
|
272 | (2) |
|
Digital Citizenship and Ethics |
|
|
273 | (1) |
|
58 Organize and Manage Emails |
|
|
274 | (2) |
|
21st Century Skills: Productivity and Accountability |
|
|
275 | (1) |
|
59 Manage Emails by Rules |
|
|
276 | (2) |
|
60 Schedule Meetings with Calendars |
|
|
278 | (2) |
|
61 Share and Print Calendars |
|
|
280 | (9) |
|
|
283 | (3) |
|
Academic and Career Connections |
|
|
286 | (1) |
|
Subject-Verb Agreement, Composition, Math Skills |
|
|
286 | (1) |
|
|
287 | (1) |
|
|
288 | (1) |
|
|
288 | (1) |
|
Unit 11 Creating Websites |
|
|
289 | (20) |
|
62 Word and Excel Web Pages |
|
|
291 | (4) |
|
Digital Citizenship and Ethics |
|
|
293 | (2) |
|
63 Web Page Tables, Graphics, and Pictures |
|
|
295 | (4) |
|
21st Century Skills: Creativity and Innovation |
|
|
297 | (2) |
|
64 Web Page Hyperlinks and Bookmarks |
|
|
299 | (5) |
|
|
304 | (3) |
|
Academic and Career Connections |
|
|
306 | (1) |
|
Pronoun Agreement, Listening, Geography |
|
|
306 | (1) |
|
|
307 | (2) |
|
|
308 | (1) |
|
|
308 | (1) |
|
Unit 12 Becoming a Successful Digital Citizen |
|
|
309 | (16) |
|
67 Digital Etiquette and Well-Being |
|
|
309 | (3) |
|
68 Digital Communications |
|
|
312 | (3) |
|
Digital Citizenship and Ethics |
|
|
314 | (1) |
|
|
315 | (2) |
|
21st Century Skills: Use and Manage Information |
|
|
316 | (1) |
|
70 Security Risks and Precautions |
|
|
317 | (3) |
|
|
320 | (5) |
|
Academic and Career Connections |
|
|
322 | (1) |
|
Spelling and Modifiers, Reading, Simple Interest |
|
|
322 | (1) |
|
|
323 | (1) |
|
|
324 | (1) |
|
|
324 | (1) |
|
Unit 13 Real-World Applications II |
|
|
325 | (16) |
|
72-76 "HOOPS II" Jobs 14--25 |
|
|
326 | (15) |
|
|
339 | (2) |
|
Unit 14 Assessing Intermediate Information Management Skills |
|
|
341 | (15) |
|
77 Input Skills, Correspondence, and Table Formatting Skills |
|
|
341 | (4) |
|
78 Spreadsheet and Database Skills |
|
|
345 | (3) |
|
79 Presentation Skills and Report Formatting Skills |
|
|
348 | (3) |
|
80 Special Document Formatting Skills, Personal Information Management |
|
|
|
And Web Page Design Skills |
|
|
351 | (5) |
|
Cycle 2 Advanced Personal, Academic, And Business Information Management Skills |
|
|
|
Unit 15 Managing Written Communication |
|
|
356 | (23) |
|
81 Business and Personal-Business Letters and Memos |
|
|
357 | (3) |
|
82 Mail Merge and Data Source Files |
|
|
360 | (5) |
|
Digital Citizenship and Ethics |
|
|
361 | (4) |
|
83 Main Document Files and Mail Merge |
|
|
365 | (2) |
|
84 Mail Merge Management Skills |
|
|
367 | (2) |
|
85 Mail Merge and Envelopes, Labels, and Directories |
|
|
369 | (3) |
|
21st Century Skills: Collaborate with Others |
|
|
371 | (1) |
|
86 Mail Merge Applications |
|
|
372 | (7) |
|
|
375 | (1) |
|
Academic and Career Connections |
|
|
376 | (1) |
|
Semicolons, Composition, Measures of Central Tendency |
|
|
376 | (1) |
|
|
377 | (1) |
|
|
378 | (1) |
|
|
378 | (1) |
|
Unit 16 Preparing and Analyzing Financial Documents |
|
|
379 | (26) |
|
|
380 | (3) |
|
Digital Citizenship and Ethics |
|
|
383 | (1) |
|
88 "What If" Questions, IF Function, and Formatting |
|
|
383 | (5) |
|
21st Century Skills: Financial Literacy |
|
|
387 | (1) |
|
89 Integrating Worksheet and Word Processing Documents |
|
|
388 | (2) |
|
90 Integrating Worksheet and Word Processing Documents |
|
|
390 | (3) |
|
91 Future Value and Present Value Functions |
|
|
393 | (3) |
|
|
396 | (3) |
|
93 Spreadsheet Applications |
|
|
399 | (6) |
|
Academic and Career Connections |
|
|
402 | (1) |
|
Word Usage, Listening, Personal Finance |
|
|
402 | (1) |
|
|
403 | (1) |
|
|
404 | (1) |
|
|
404 | (1) |
|
Unit 17 Using Design to Create Effective Business Documents |
|
|
405 | (24) |
|
94 Using Design to Create Newsletter Publications |
|
|
407 | (3) |
|
95 Using Design to Improve Newsletter Publications |
|
|
410 | (3) |
|
96 Using Design to Enhance Newsletter Publications |
|
|
413 | (3) |
|
97 Using Design to Create Charts and Advertisements |
|
|
416 | (3) |
|
Digital Citizenship and Ethics |
|
|
418 | (1) |
|
98 Using Design to Create Business Documents |
|
|
419 | (3) |
|
99 Using Design to Create Booklets |
|
|
422 | (2) |
|
100 Applying Design to Create Business Publications |
|
|
424 | (5) |
|
Academic and Career Connections |
|
|
426 | (1) |
|
Proofreading, Speaking, History |
|
|
426 | (1) |
|
|
427 | (1) |
|
|
428 | (1) |
|
|
428 | (1) |
|
Unit 18 Analyzing Information Efficiently and Effectively |
|
|
429 | (31) |
|
101 Data Mining and Analysis Using Computed Fields and Column Totals |
|
|
431 | (5) |
|
21st Century Skills: Civic Literacy |
|
|
435 | (1) |
|
102 Data Mining and Analysis Using Queries Created from Multiple Tables |
|
|
436 | (3) |
|
103 Using a Database to Create Form Letters, Envelopes, and Labels |
|
|
439 | (3) |
|
104 Creating Word Documents from Database Tables and Queries |
|
|
442 | (3) |
|
105 Creating Documents to Analyze Information Efficiently and Effectively |
|
|
445 | (5) |
|
106 Apply What You Have Learned |
|
|
450 | (10) |
|
|
453 | (1) |
|
Digital Citizenship and Ethics |
|
|
454 | (1) |
|
Academic and Career Connections |
|
|
455 | (1) |
|
Pronoun Case, Reading, Science |
|
|
455 | (1) |
|
|
456 | (1) |
|
|
457 | (1) |
|
|
457 | (1) |
|
|
458 | (2) |
|
Unit 19 Real World Application III |
|
|
460 | (10) |
|
107-111 Central Valley Education Foundation |
|
|
462 | (8) |
|
Unit 20 Becoming an Entrepreneur |
|
|
470 | (14) |
|
Digital Citizenship and Ethics |
|
|
473 | (1) |
|
|
474 | (10) |
|
21st Century Skills: Entrepreneurial Literacy |
|
|
481 | (1) |
|
Academic and Career Connections |
|
|
482 | (1) |
|
|
482 | (1) |
|
|
482 | (1) |
|
|
483 | (1) |
|
Unit 21 Enhancing Visuals to Communicate Effectively |
|
|
484 | (22) |
|
118 Reuse Slides and Combine Files |
|
|
486 | (5) |
|
Digital Citizenship and Ethics |
|
|
487 | (2) |
|
21st Century Skills: Media Literacy |
|
|
489 | (2) |
|
119 Enhance Visuals with the Convert to SmartArt Feature |
|
|
491 | (9) |
|
120 Enhance Visuals with Advanced Transition and Animation Features |
|
|
500 | (6) |
|
Academic and Career Connections |
|
|
504 | (1) |
|
|
504 | (1) |
|
|
504 | (1) |
|
|
505 | (1) |
|
Unit 22 Understanding Our World |
|
|
506 | (25) |
|
|
506 | (6) |
|
|
512 | (4) |
|
21st Century Skills: Global Awareness |
|
|
513 | (3) |
|
123 Protecting Your Environment |
|
|
516 | (6) |
|
124 Exploring Today's Legal and Ethical Issues |
|
|
522 | (4) |
|
125 Evaluating Media Messages |
|
|
526 | (5) |
|
Digital Citizenship and Ethics |
|
|
528 | (1) |
|
Academic and Career Connections |
|
|
529 | (1) |
|
|
529 | (1) |
|
|
529 | (1) |
|
|
530 | (1) |
|
Unit 23 Preparing for the Workplace |
|
|
531 | (19) |
|
126 Preparing a Career Portfolio and Reference List |
|
|
531 | (3) |
|
Digital Citizenship and Ethics |
|
|
533 | (1) |
|
127 Preparing Print Resumes |
|
|
534 | (3) |
|
21st Century Skills: Environmental Awareness |
|
|
536 | (1) |
|
128 Preparing Digital Resumes |
|
|
537 | (2) |
|
129 Preparing Employment Application Letters |
|
|
539 | (1) |
|
130 Preparing for the Personal Interview |
|
|
540 | (3) |
|
131 Preparing Application Forms and Post-interview Documents |
|
|
543 | (7) |
|
|
547 | (1) |
|
Academic and Career Connections |
|
|
548 | (1) |
|
|
548 | (1) |
|
|
549 | (1) |
|
|
549 | (1) |
|
Unit 24 Being an Effective Employee |
|
|
550 | (17) |
|
132 Understanding Employer Expectations |
|
|
550 | (6) |
|
Digital Citizenship and Ethics |
|
|
551 | (2) |
|
21st Century Skills: Flexibility and Adaptability |
|
|
553 | (3) |
|
133 Establishing Yourself in a New Job |
|
|
556 | (4) |
|
134 Being Effective and Advancing Your Career |
|
|
560 | (7) |
|
Academic and Career Connections |
|
|
565 | (1) |
|
|
565 | (1) |
|
|
565 | (1) |
|
|
566 | (1) |
|
Unit 25 Real-World Applications IV |
|
|
567 | (12) |
|
135-141 Central Valley Education Foundation |
|
|
568 | (11) |
|
|
576 | (3) |
|
Unit 26 Assessing Advanced Information Management Skills |
|
|
579 | (13) |
|
142 Input and Mail Merge Skills |
|
|
579 | (3) |
|
143 Spreadsheet Skills and Column Document Formatting Skills |
|
|
582 | (3) |
|
144 Database and Report Formatting Skills |
|
|
585 | (2) |
|
145 Presentation and Input Skills |
|
|
587 | (5) |
Reference Guide |
|
592 | |
Glossary |
|
1 | (1) |
Index |
|
1 | |