| Preface |
|
xi | |
|
Chapter 1 Technology and the School |
|
|
1 | (5) |
|
What You Are Going to Learn |
|
|
1 | (1) |
|
|
|
1 | (1) |
|
About the Book and Using Technology |
|
|
1 | (1) |
|
|
|
2 | (1) |
|
|
|
2 | (1) |
|
Expectations of Administrators |
|
|
3 | (1) |
|
|
|
3 | (1) |
|
Copyright and the Classroom |
|
|
3 | (1) |
|
|
|
4 | (1) |
|
|
|
5 | (1) |
|
|
|
5 | (1) |
|
|
|
5 | (1) |
|
Chapter 2 Getting Started with Office |
|
|
6 | (6) |
|
What You Are Going to Learn |
|
|
6 | (1) |
|
|
|
6 | (5) |
|
Working with the Microsoft Office Suite |
|
|
6 | (1) |
|
Opening Office Applications |
|
|
7 | (1) |
|
|
|
7 | (1) |
|
The Ribbon in Microsoft Office |
|
|
8 | (1) |
|
|
|
8 | (1) |
|
The Help Function in Microsoft Office |
|
|
8 | (2) |
|
|
|
10 | (1) |
|
|
|
10 | (1) |
|
|
|
11 | (1) |
|
|
|
11 | (1) |
|
|
|
12 | (25) |
|
What You Are Going to Learn |
|
|
12 | (1) |
|
|
|
12 | (1) |
|
|
|
13 | (1) |
|
|
|
13 | (1) |
|
|
|
13 | (1) |
|
|
|
14 | (2) |
|
|
|
14 | (2) |
|
Project for Teachers: Writing a Newsletter |
|
|
16 | (5) |
|
Project for Students: Creating a Diagram |
|
|
21 | (4) |
|
Project for Administrators: Creating a Webpage |
|
|
25 | (6) |
|
Project for Everyone: Using a Template for Mailings |
|
|
31 | (4) |
|
|
|
35 | (1) |
|
|
|
35 | (1) |
|
|
|
36 | (1) |
|
Chapter 4 Powerpoint 2010 |
|
|
37 | (55) |
|
What You Are Going to Learn |
|
|
37 | (1) |
|
|
|
37 | (1) |
|
How You Can Use PowerPoint 2010 |
|
|
38 | (1) |
|
|
|
38 | (1) |
|
|
|
39 | (1) |
|
What Is New in PowerPoint 2010 |
|
|
39 | (1) |
|
|
|
40 | (1) |
|
|
|
40 | (1) |
|
Project for Students: Presenting Weather Data |
|
|
41 | (26) |
|
Creating a Title Slide and Inserting Text (Slide I) |
|
|
42 | (1) |
|
Title Only Slide (Slide 2) |
|
|
43 | (3) |
|
Title and Content Slide (Slide 3) |
|
|
46 | (2) |
|
Adding a Title, Text, and Picture to a Slide (Slide 4) |
|
|
48 | (1) |
|
|
|
49 | (5) |
|
Adding a Video Report (Slide 6) |
|
|
54 | (1) |
|
Adding Web Video (Slide 7) |
|
|
54 | (1) |
|
Adding a Title, Text, and Content Slide (Slide 8) |
|
|
55 | (1) |
|
Adding a Title Only Slide with an Object (Slide 9) |
|
|
56 | (1) |
|
Adding a Chart Slide (Slide 10) |
|
|
57 | (3) |
|
Inserting a Chart (Slide 11) |
|
|
60 | (1) |
|
Adding a Title and Text Slide Using the Slide Sorter (Slide 12) |
|
|
61 | (2) |
|
Adding a Title, Text, and Content Slide (Slide 13) |
|
|
63 | (1) |
|
Previewing a PowerPoint Presentation in the Slide Show View |
|
|
64 | (1) |
|
|
|
64 | (1) |
|
|
|
65 | (1) |
|
Spell-Checking a PowerPoint Presentation |
|
|
65 | (1) |
|
Printing a PowerPoint Presentation |
|
|
65 | (1) |
|
Packaging a Presentation on CD |
|
|
66 | (1) |
|
Project for Teachers: Using a Template for Scientific Investigation |
|
|
67 | (17) |
|
Title Only Slide (Slide 1) |
|
|
67 | (1) |
|
Title and Content Slide (Slide 2) |
|
|
68 | (1) |
|
Title and Content Slide (Slide 3) |
|
|
68 | (1) |
|
Title and Content Slide (Slide 4) |
|
|
68 | (2) |
|
Title and Content Slide (Slide 5) |
|
|
70 | (1) |
|
Title and Content Slide (Slides 6-8) |
|
|
70 | (1) |
|
Title and Content Slide (Slide 9) |
|
|
70 | (1) |
|
Two Content Slide (Slide 10) |
|
|
70 | (2) |
|
Title and Content Slide (Slide 11) |
|
|
72 | (1) |
|
Title and Content Slide (Slide 12) |
|
|
72 | (1) |
|
Title and Content Slide (Slide 13) |
|
|
72 | (1) |
|
Title and Content Slide (Slides 14-31) |
|
|
73 | (1) |
|
Title and Content Slide (Slide 32) |
|
|
73 | (1) |
|
Title and Content Slide (Slide 33) |
|
|
74 | (1) |
|
Title and Content Slide (Slide 34) |
|
|
74 | (1) |
|
Title and Content Slide (Slide 35) |
|
|
74 | (1) |
|
|
|
74 | (3) |
|
|
|
77 | (3) |
|
Allowing Others Access to Your File |
|
|
80 | (2) |
|
|
|
82 | (2) |
|
Project for Administrators: Making a Presentation to the School Board |
|
|
84 | (1) |
|
Title Only Slide (Slide I) |
|
|
84 | (7) |
|
Title Only Slide (Slide 2) |
|
|
85 | (1) |
|
Title and Content Slide (Slide 3) |
|
|
86 | (1) |
|
Two Content Slide (Slide 4) |
|
|
86 | (1) |
|
|
|
87 | (1) |
|
Title and Content Slide (Slide 6) |
|
|
87 | (1) |
|
Title and Content Slide (Slide 7) |
|
|
88 | (1) |
|
Title and Content Slides (Slide 8 and 9) |
|
|
88 | (1) |
|
Two Content Slide (Slide 10) |
|
|
89 | (1) |
|
Additional Activities Using PowerPoint |
|
|
90 | (1) |
|
|
|
91 | (1) |
|
|
|
91 | (1) |
|
|
|
92 | (51) |
|
What You Are Going to Learn |
|
|
92 | (1) |
|
|
|
93 | (1) |
|
|
|
93 | (1) |
|
|
|
93 | (1) |
|
|
|
94 | (1) |
|
|
|
94 | (1) |
|
|
|
94 | (1) |
|
|
|
94 | (1) |
|
A Word About the Excel Workspace |
|
|
95 | (1) |
|
Moving About in a Worksheet |
|
|
96 | (1) |
|
Creating a Workbook and Worksheets |
|
|
96 | (1) |
|
Project for Teachers: Tracking Weather Conditions |
|
|
96 | (18) |
|
Entering Data in a Worksheet |
|
|
96 | (2) |
|
Modifying Worksheets: Adjusting Columns and Rows |
|
|
98 | (1) |
|
|
|
99 | (1) |
|
Modifying Worksheets: Formatting Text |
|
|
100 | (2) |
|
Modifying Worksheets: Editing Data |
|
|
102 | (1) |
|
Saving a Workbook: The Backstage |
|
|
102 | (1) |
|
Saving and Naming a Workbook |
|
|
103 | (2) |
|
Modifying Worksheets: Inserting Rows and Columns |
|
|
105 | (1) |
|
|
|
105 | (2) |
|
|
|
107 | (2) |
|
|
|
109 | (1) |
|
|
|
109 | (2) |
|
|
|
111 | (1) |
|
Spell-Checking an Excel Workbook |
|
|
112 | (1) |
|
Printing an Excel Workbook |
|
|
113 | (1) |
|
Project for Teachers and Students: Creating a Checkbook Minder |
|
|
114 | (3) |
|
|
|
115 | (2) |
|
Project for Students: Calculating Future Value (How Much Do I Need to Save?) |
|
|
117 | (1) |
|
Project for Teachers: Creating a Mortgage Payment Calculator |
|
|
118 | (4) |
|
Calculating Principal and Interest |
|
|
118 | (2) |
|
|
|
120 | (1) |
|
Calculating the Loan Balance |
|
|
120 | (1) |
|
Formatting the Mortgage Payment Calculator |
|
|
121 | (1) |
|
Project for Administrators: Creating PivotTable and PivotChart Reports |
|
|
122 | (9) |
|
PivotTable Report: Defining a PivotTable Range |
|
|
123 | (4) |
|
Examining Communications Data |
|
|
127 | (1) |
|
|
|
128 | (1) |
|
Examining All Survey Results |
|
|
129 | (2) |
|
Project for Students: Using a PivotTable to Examine Data About the Presidents |
|
|
131 | (9) |
|
Defining a PivotTable Range to Study the Presidents |
|
|
131 | (9) |
|
|
|
140 | (2) |
|
Additional Activities Using Excel |
|
|
141 | (1) |
|
|
|
142 | (1) |
|
|
|
143 | (19) |
|
What You Are Going to Learn |
|
|
143 | (1) |
|
|
|
143 | (1) |
|
|
|
143 | (1) |
|
|
|
144 | (1) |
|
What's New in Access 2010 |
|
|
144 | (1) |
|
|
|
145 | (1) |
|
|
|
145 | (1) |
|
Project for Teachers: Creating a Classroom Library Database |
|
|
146 | (5) |
|
Project for Students: Creating a Planet Database |
|
|
151 | (4) |
|
Project for Administrators: Creating a Faculty Database |
|
|
155 | (1) |
|
Project for Everyone: Using Mailing Lists and Mail Merge |
|
|
156 | (5) |
|
|
|
161 | (1) |
|
|
|
161 | (1) |
|
|
|
161 | (1) |
|
|
|
162 | (23) |
|
What You Are Going to Learn |
|
|
162 | (1) |
|
|
|
162 | (1) |
|
How You Can Use Publisher |
|
|
163 | (1) |
|
|
|
163 | (1) |
|
What's New in Publisher 2010 |
|
|
163 | (1) |
|
|
|
164 | (1) |
|
|
|
164 | (2) |
|
Project for Teachers: Creating a Newsletter |
|
|
166 | (6) |
|
Project for Students: Creating a Brochure |
|
|
172 | (6) |
|
Project for Administrators: Creating a Professional E-mail Template |
|
|
178 | (4) |
|
Project for Everyone: Creating a Postcard |
|
|
182 | (1) |
|
|
|
183 | (1) |
|
|
|
184 | (1) |
|
|
|
184 | (1) |
|
Chapter 8 Integrating Office 2010 |
|
|
185 | (23) |
|
What You Are Going to Learn |
|
|
185 | (1) |
|
|
|
185 | (1) |
|
About Integrating the Office Products |
|
|
186 | (1) |
|
Project for Students: Creating a Multimedia Project |
|
|
186 | (16) |
|
Copying and Pasting Text from Word to PowerPoint |
|
|
187 | (1) |
|
Inserting PowerPoint Slides into Word Using Copy and Paste |
|
|
188 | (3) |
|
Inserting a Presentation Object and Converting It to a Slide Object |
|
|
191 | (1) |
|
Pasting an Excel Worksheet into a Word Document and a PowerPoint Slide Show |
|
|
192 | (1) |
|
Copying and Pasting a Worksheet into PowerPoint |
|
|
193 | (1) |
|
Creating a Chart That Shows the Time Members Have Spent on Project Tasks |
|
|
194 | (2) |
|
Inserting a Chart into PowerPoint from Excel |
|
|
196 | (1) |
|
Embedding an Excel Worksheet into a Word Document |
|
|
197 | (2) |
|
Creating a Credit Slide: Outlook and Access |
|
|
199 | (3) |
|
Project for Teachers: Creating a Question and Answer Game |
|
|
202 | (1) |
|
Project for Administrators: Posting School Board Files on SkyDrive |
|
|
203 | (3) |
|
|
|
206 | (1) |
|
|
|
207 | (1) |
|
|
|
207 | (1) |
|
Chapter 9 Multimedia and Web Technologies |
|
|
208 | (27) |
|
What You Are Going to Learn |
|
|
208 | (1) |
|
|
|
208 | (1) |
|
Project for Teacher and Students: Sharing Multimedia |
|
|
209 | (20) |
|
|
|
209 | (3) |
|
|
|
212 | (3) |
|
|
|
215 | (5) |
|
Copying Media from Cameras and Portable Devices |
|
|
220 | (1) |
|
Uploading Media to the Group Space |
|
|
221 | (8) |
|
Project for Administrators: Making an Equipment Inventory |
|
|
229 | (3) |
|
|
|
232 | (1) |
|
|
|
233 | (2) |
|
|
|
235 | (22) |
|
|
|
235 | (2) |
|
|
|
236 | (1) |
|
|
|
236 | (1) |
|
|
|
236 | (1) |
|
|
|
236 | (1) |
|
|
|
237 | (1) |
|
|
|
237 | (1) |
|
|
|
238 | (1) |
|
|
|
239 | (1) |
|
|
|
240 | (1) |
|
|
|
240 | (1) |
|
|
|
240 | (1) |
|
|
|
241 | (1) |
|
|
|
241 | (1) |
|
Shut Down/Turn Off Computer |
|
|
241 | (1) |
|
Repositioning and Resizing Windows |
|
|
241 | (1) |
|
Working with Programs and Files |
|
|
242 | (3) |
|
|
|
242 | (1) |
|
|
|
243 | (2) |
|
Opening Multiple Programs |
|
|
245 | (3) |
|
|
|
245 | (1) |
|
Switching Between Programs |
|
|
245 | (1) |
|
Repositioning and Resizing Program Windows |
|
|
245 | (2) |
|
|
|
247 | (1) |
|
|
|
248 | (1) |
|
|
|
248 | (2) |
|
|
|
248 | (1) |
|
|
|
249 | (1) |
|
Managing Files: Moving and Copying Files |
|
|
250 | (3) |
|
|
|
250 | (2) |
|
|
|
252 | (1) |
|
Deleting Files and Folders |
|
|
253 | (1) |
|
Using a Shortcut Menu to Delete Files |
|
|
253 | (1) |
|
Using the Delete Key to Delete Files or Folders |
|
|
253 | (1) |
|
|
|
253 | (1) |
|
|
|
254 | (1) |
|
|
|
254 | (1) |
|
Searching for Files or Folders |
|
|
254 | (2) |
|
Shutting Down Your Computer |
|
|
256 | (1) |
|
|
|
256 | (1) |
|
|
|
257 | (6) |
|
|
|
257 | (1) |
|
|
|
257 | (1) |
|
|
|
257 | (1) |
|
|
|
258 | (1) |
|
|
|
258 | (1) |
|
|
|
258 | (1) |
|
Repositioning and Resizing Windows |
|
|
258 | (1) |
|
Working with Programs and Files |
|
|
259 | (1) |
|
|
|
259 | (1) |
|
|
|
259 | (1) |
|
Opening a File Using the Application That Created It |
|
|
259 | (1) |
|
Accessing and Opening a File by Using the Macintosh HD Icon |
|
|
259 | (1) |
|
Opening a File by Using Recent Items |
|
|
259 | (1) |
|
Opening Multiple Programs |
|
|
259 | (1) |
|
|
|
260 | (1) |
|
Switching Between Programs |
|
|
260 | (1) |
|
Repositioning and Resizing Program Windows |
|
|
260 | (1) |
|
|
|
260 | (1) |
|
|
|
260 | (1) |
|
Viewing the Contents of Your Computer |
|
|
260 | (1) |
|
|
|
261 | (1) |
|
Managing Files: Moving, Copying, Deleting, and Renaming Files |
|
|
261 | (1) |
|
|
|
261 | (1) |
|
|
|
261 | (1) |
|
Deleting Files and Folders |
|
|
261 | (1) |
|
|
|
262 | (1) |
|
|
|
262 | (1) |
|
|
|
262 | (1) |
|
Searching for Files or Folders |
|
|
262 | (1) |
|
Shutting Down Your Computer |
|
|
262 | (1) |
|
The Microsoft Office Workspaces: Macintosh and Windows |
|
|
262 | (1) |
| Glossary |
|
263 | (2) |
| Index |
|
265 | |
