1 / 16

Excel Battleship

Excel Battleship. Mrs. Stevens March 19, 2013. Table of Contents. Pre-planning your Battleground - Link Creating your Excel Workbook - Link Creating Excel Worksheets - Link Creating your Excel Battlegrounds - Link Formatting your “My Ships” Worksheet - Link

turner
Download Presentation

Excel Battleship

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Excel Battleship Mrs. Stevens March 19, 2013

  2. Table of Contents • Pre-planning your Battleground - Link • Creating your Excel Workbook - Link • Creating Excel Worksheets - Link • Creating your Excel Battlegrounds - Link • Formatting your “My Ships” Worksheet - Link • Placing youy Ships - Link You can navigate through this presentation from start to finish, or you can click on the “Link” to go to a specific location where you need help.

  3. Pre-planning your Battleground • Need • Excel Battleship Overview Handout – Page 2 • Blank Battleship Layout & Results Log Book Sheet • Battleship Layout Grid – Top half of Sheet • Screenshot of Excel Worksheet • Column Names - Letters • Row Names – Numbers • Results Log Book – Bottom half of Sheet • List of Ship Types • Column for Ship Cell Ranges • Columns to Record Game Results per each Ship Table of Contents Next

  4. Battleship Descriptions • Count – How many of each type of ship • Ship Type – Name of the type of ship • Key – The two-letter code for each type of ship • Size – The total number of cells for the length of each ship • Color – The color you will fill the cells for each type of ship Table of Contents Next

  5. Results Log Book • Ship Type • Row for Each Ship • Cell Range • First & Last Cell Name • Double Check Accuracy • Use During Games • Game 1 – 4 Columns • # Hits, Missed, Sunk • Each Ship’s Results • Record End of Each Game Table of Contents Next

  6. Battleship Layout Sheet • Place your 13 ships anywhere within the dark border • Up and Down or Left to Right • Draw a Border around Each Ship • Label the First and Last Cell Name and the Ship’s Key Table of Contents Next

  7. Creating your Excel Workbook File Location: Your “Z” Drive – “Problem Solving Folder if you have one… File Name: Last Name_ID#_Battleship Example: Stevens_123456_Battleship Table of Contents Next

  8. Creating Excel Worksheets • Default – 3 Worksheets • Sheet 1 • Sheet 2 • Sheet 3 • Need 2 More Worksheets • Add Sheets Icon • To Right of Sheet 3 • Click – Adds Sheet 4 • Click – Adds Sheet 5 Table of Contents Next

  9. Naming Excel Worksheets • Rename Worksheets • Right Click on Tab • Choose Rename • Type New Name • Repeat for Each Sheet • Worksheet Names • My Ships • Game 1 (or Battle 1) • Game 2 (or Battle 2) • Game 3 (or Battle 3) • Game 4 (or Battle 4) Table of Contents Next

  10. Creating your Excel Battlegrounds • ALL 5 Worksheets! • Format Columns A-S • Click on Letter A • Drag to Letter S • Right Click Letter A • Select “Column Width…” • Set Column Width to 5 • Click “OK” Table of Contents Next

  11. Row Height • Format Rows 1 - 22 • Click on Number 1 • Drag to Number 22 • Rows 1 to 22 highlighted • Right Click Number 1 • Select Row Height • Set Row Height to 20 • Click “OK” Table of Contents Next

  12. Framing the Battleground • Click in Cell B2 • Column B • Row 2 • Drag to Cell R21 • All Cells Highlighted • Create Border • Click Pull-down Arrow • Thick Box Border • All Cells have border • Repeat - All Worksheets Table of Contents Next

  13. Formatting your “My Ships” Worksheet • Click Gray Cell • Upper Left Corner • Left of Letter A • Above Number 1 • Highlights Worksheet • Format Font • Right Click Mouse • On Any Cell • Cells Remain Highlighted • Dialog Box Appears Table of Contents Next

  14. Formatting the Font • Font Name • Aharoni • Pull Down Arrow • By Calibri • Font List Appears • Font Size • 18 Point • Pull Down Arrow • Font Color • Red • Pull Down Arrow by A • Standard Colors Table of Contents Next

  15. Placing your Ships • Ship Location & Results Log Book • Use to Place Ships in Excel Battleground • Same Cell Ranges on Sheet & Worksheet • Sheet and Worksheet Differ • Correct one or the other • May need new Location Sheet • Excel Test Overview Pg 2 • List of Ship Colors • List of Ship Counts & Sizes to Confirm Table of Contents Next

  16. Let the Battles Begin! Your Battleground should look something like this one. Table of Contents Next

More Related