background image
10
1. Format cells to
text.
2. Sort data in
ascending order
(A-Z).
A
driver's educati on course is a criti cal component in producing safe and
responsible drivers. Driver's educati on courses provide students with
the tools necessary to minimize the chances of a vehicular accident and help
to keep everyone on the road safe. Students gain valuable insight on driving
responsibiliti es and develop good driving habits that should last a lifeti me.
Students learn about lights and signals, right of way and stop sign procedures,
the proper distance to leave between vehicles, the implicati ons of drinking
and driving, the dangers of talking or texti ng on a cell phone while driving, and
other informati on.
Driver's educati on instructi on begins in the classroom and, aft er passing a
writt en test, on-the-road instructi on begins. This usually progresses from
parking lots to back roads and unpopulated areas and then on to busier
streets. Aft er completi ng classroom and on-the-road instructi on, a test is
administered. Licensing and license renewal procedures vary by state.
The following acti vity illustrates how spreadsheets can be used to create the
class roster of a driver's educati on course and then alphabeti ze the names.
1. Create a NEW spreadsheet.
Unless otherwise stated, the font should be 10 point Arial.
2. Type the data as shown.
3. Bold cells A2 and A7.
4. Bold and underline cells B10 ­ E10.
5. Select cells B12 ­ D35 and format cells to text.
6. Format the width of column A to 6.0 and left align.
7. Format the width of columns B and C to 16.0 and left align.
8. Format the width of column D to 10.0 and center align.
9. Format the width of column E to 12.0 and center align.
10. To alphabeti ze students by their last names, select cells B12 ­ E35 and sort in
ascending order (A-Z). Use the column labeled "LAST" to Sort by.
11. Carefully proofread your work for accuracy.
12. Save the spreadsheet as CLASS ROSTER.
13. Analyze the changes made to the data in the spreadsheet.
14. Set the Print Area to include all cells containing data in the spreadsheet.
15. Print Preview and adjust the Page Setup so that the spreadsheet fi ts on one page.
5
Class Roster
NEW SKILL
NEW SKILL
ACTIVITY
For Evaluation Purposes Only