Assignment 5 -- Create Your Own Subnetting Worksheet

In this assignment, the objective is to get you ready for one of the most significant parts of the certification -- subnetting

Subnet Calculator --

While you can get subnet calculators online, you cannot use them during the certification exam so it is best not to use them until you pass the exam. On the other hand, if you create one yourself, it will stick in your brain and that is exactly what we want

Your Calculator --

Create a spreadsheet with the following criteria:

1. Has a section for:
• IPv4
• IPv6
2. It identifies:
• The Octets in IPv4
• The primary sections in IPv6
3. It shows:
• The Binary for IPv4
• At least Hex for IPv6 (IPv6 Binary a plus)
4. For IPv4, it breaks the last Octet down into variable length segments

Each subnet size should include:

• Network Address
• First Usable Address
• Last Usable Address
• Broadcast Address

Hybrid Class Assignment -- Network Design #2

Now you will use your subnet calculator spreadsheet to solve a VLSM problem. I want to see the copy of your calculator with the solution in it

You have been hired to design and implement the following network. You have been asked to produce your design in Packet Tracer for the client to show you know what you are doing

In addition, the client is looking for a spreadsheet (a version of your subnet calculator) which shows how you broke down the address block into VLSM networks

You are to configure a network for a business with 5 segments using 3 routers. The segments have the following criteria:

Once again, we will use static IP addressing to learn the concept of variable length subnetting

For the purpose of this problem, you are on an internal network (behind the gateway router) so you do not have to specifically address turning on NAT, however, the concept should be a part of your design considerations

---

Assignment Submission Criteria

To turn in this assignment you will go to the NSC Canvas shell for this class and submit the following:

• Your calculator grid from the first part of your assignment as an attachment (again, you should use a spreadsheet software like to LibreOffice or Excel -- do not use Google docs or any other software to do this)
• Your Packet Tracer (.pka) file from the Hybrid part of your assignment

If you get stuck completing the assignment, turn in your work in progress for partial credit. After getting feedback on your work in progress, you can re-submit the assignment for full credit later

Return to Assignment Index