PHS CyberSchool
Computer Studies SG
Modified 13 November 2004
Email logins in a computer shop
- Excel functions
Create a set of logins to the network for the staff in a computer shop. The
logins should have the First Name, then Surname, but should be three letters, hyphen,
three letters, e.g. Nicole Abrahams should be nic-abr.
The exercise can be done in one or two steps. We will do it in two steps.
- Copy the following names into an Excel worksheet. Use the LEFT text Function to make the names into the
first-three-letter names. Assistance can be found in the tip sheets under Excel Left
, and in Excel / Help / Index. The first example has been done for you.
The following may help: The formula in Cell C1 is LEFT(A1,3). The formula in
Cell D1 is =LEFT(B1,3).
| Nicole |
Abrahams |
nic |
abr |
| Tarin |
Alexander |
|
|
| Barry |
Cochrane |
|
|
| Redar |
Daniels |
|
|
| Shahied |
Daniels |
|
|
| Mujahied |
Ebrahim |
|
|
| Pesana |
Ebrahim |
|
|
| Melissa |
Erasmus |
|
|
| Michele |
Glossip |
|
|
| Helga |
Groenewald |
|
| Zita |
Hearne |
|
|
| Tara |
Hoole |
|
|
| Zuko |
Jack |
|
|
| Tamlynn |
Johnson |
|
|
| Bronwynne |
Jooste |
|
|
- Onto the same worksheet copy the following names. Use the CONCATENATION text Function to join the names into
logins such as wes-mat for Wessel Matthee. Find assistance in the tip sheets under Excel Concatenate or in Excel / Help / Index.
Capital or small letters do not matter.
| Wessel |
Matthee |
Wes |
Mat |
wes-mat |
| Ryan |
Maxwell |
Rya |
Max |
|
| Stephano |
Meyer |
Ste |
Mey |
|
| Erin |
Randall |
Eri |
Ran |
|
| Timothy |
Richert |
Tim |
Ric |
|
| Elena |
Romonova |
Ele |
Rom |
|
| Michael |
Roy |
Mic |
Roy |
|
| Dianne |
Steffen |
Dia |
Ste |
|
| Uzair |
Stellenboom |
Uza |
Ste |
|
| Jack |
Thonissen |
Jac |
Tho |
|
| Nicholas |
Thorne |
Nic |
Tho |
|
| Michelle |
Winterbach |
Mic |
Win |
|
| Felicity |
Stevens |
Fel |
Ste |
|
| Kelly |
Wheeler |
Kel |
Whe |
|
| Lauren |
Jones |
Lau |
Jon |
|
- Be sure that EACH sheet has the two groups of names.
- Add your name as a footer.
- Adjust the margins and orientation so that each fits on ONE page.
- Print the answers twice, as formulas (Tools / Options / Formulas) and as a normal Excel
worksheet.
- Print the work
and save in your portfolio.
- Online learners submit the work zipped together as an
email attachment. Phone two days after submitting the work to discuss the
task - no phone call results in a disappointed teacher.
Return to Computer Studies lesson plan index. This work may be
freely copied for non-commercial use only. Copyright © Pam Miller.