Lesson 1: Making the Folders
Welcome to the 7th grade technology class website. Your job in this class will be to read and go through each lesson at your own pace. In order to do this, you must read all of the directions that I will be posting here on our class website. The directions will be your guide, as I will be formatting them in a step-by-step manner. If all else fails, remember you have the Internet at your fingertips, so Google something if you have a question. Lastly, if you are wondering if you are able to play games, please read the directions within the lessons. Good luck this year in tech class.
- After you have read the welcome message above, shrink this page by clicking on the middle icon (the one that looks like 2 squares) in the upper right corner of this window.
- Adjust the contents in the window so that you are able to read these directions and perform tasks on the desktop. The desktop is the screen where all of the icons are located.
- This desktop is unique to you alone. Anything that you put on this desktop will only be seen by your teachers and yourself unless someone else knows the password you entered at the start-up screen.
- Click on the START button located on the bottom left side of the DESKTOP.
- Move the mouse over to MY COMPUTER.
- Here you will find all of the drives on the computer.
- I want you to now double-click on the Z drive.
- This drive is only accessible to you and me. This means that only you and I can see what you put into this space.
- The first thing I want you to do here is to create a new folder. This can be done by placing the mouse arrow anywhere in the drive space and clicking on the right mouse button, or right-clicking.
- When the menu pops up, move the arrow to NEW, then click on FOLDER.
- You will now see a new folder on the desktop. Rename this folder as TECHNOLOGY.
- Next, create 4 more folders and name them ENGLISH, MATH, SCIENCE, SOCIAL STUDIES.
- You should now have 5 different folders in the Z drive all with different names.
- It is important to understand that anything you save in your Z drive can be accessed from any computer lab on campus, so if you are working on something for another class and you want you save it to work on it later, you can in the Z drive.
- DO NOT SAVE ANYTHING ON THE DESKTOP AS IT WILL BE ERASED EVERY TIME THE COMPUTER SHUTS DOWN. We will talk about this as the year goes on.
- Close the Z drive window by clicking on the red X in the upper right corner.
- Now click here.
- You should now see the login screen for Google. I want you to login using your email address and password from last year with Mr. Shumate.
- If you have forgotten you login information you may follow the pattern of: 14 followed by your first name dot your last name @keis.k12.hi.us
- If I was logging in my email address would be: [email protected]
- For your password use the pattern of: your first name followed by keis
- Again if I was putting in my password, it would be: vincentkeis
- Once you have logged in click here.
- Once the page opens, I want you to type in you first and last name anywhere on the page for now. This will be how we take attendance for class. Do not erase anyone's name as I can see who is doing things on the page.
- This pages saves automatically to my computer.
- ONLY IF YOU ARE DONE WITH ALL THE ASSIGNMENTS UP TO THIS POINT CAN YOU
- Play a game. You are only allowed to play this game: FANTASTIC CONTRAPTION.
Lesson #2: My Biography
- IF YOU ARE NOT DONE WITH LESSON #1, PLEASE COMPLETE IT BEFORE MOVING ON TO LESSON #2.
- Please complete Lesson #2. Click here.
- When you are done with Lesson #2, open up Microsoft Word.
- Using Microsoft Word, you will be composing a 1 paragraph (5-7 sentences) letter to me (Mr. Venzon).
- Your letter needs to have the following:
- Your first name and last name, todays date, and period in the upper right-hand corner. (Use the formatting buttons)
- Give you letter a title. Your title needs to be centered on the page. Change its font to Arial and its size to 16. Your title should also be in bold and italics.
- When you start writing your letter be sure to indent your first line using the "tab" key in the left side of the keyboard.
- Next, start writing your letter. In your letter, you will be introducing yourself to me (Mr. Venzon). Tell me some things about yourself. What kinds of things do you like to do for fun, what is your favorite subject in school, how old you are, etc...
- When you are done with your letter, save it as "MY BIOGRAPHY" in your TECHNOLOGY folder in the "Z" drive.
- ONLY IF YOU ARE DONE WITH ALL THE ASSIGNMENTS UP TO THIS POINT CAN YOU
- Play a game. You are only allowed to play this game: FANTASTIC CONTRAPTION.
Lesson 3: Emailing your Biography
- If you are not done with LESSONS 1 and/or 2 please go back and complete them before moving on.
- Please complete Lesson #3.
- After completing Lesson #3, Login to your GOOGLE account.
- Using your GOOGLE email application, I want you to email your BIOGRAPHY from Lesson #2 to me.
- The SUBJECT of your email should be as follows. example: FirstName LastName My Biography. If I am emailing my biography my subject line in my email will read: "Vincent Venzon My Biography".
- You can email me at: [email protected]
- ONLY IF YOU ARE DONE WITH ALL THE ASSIGNMENTS UP TO THIS POINT CAN YOU
- Play a game. You are only allowed to play this game: FANTASTIC CONTRAPTION.
Lesson 4: My Image
- PLEASE COMPLETE ALL LESSONS IN ORDER. IF YOU HAVE NOT FINISHED ONE OF THE ABOVE LESSONS, PLEASE DO SO BEFORE MOVING ON.
- Complete Lesson #4.
- For Part 2, you will be figuring out how to insert a picture into a Microsoft Word document. Here's what you need to do:
- Open up Internet Explorer.
- Search the Internet for an image that best represent who you are as a person.
- Save this image into your TECHNOLOGY folder on the desktop. (hint: you can save images by right clicking on them)
- Open up Microsoft Word.
- Place your name, date, and period into the upper right-hand section of your document. Make them BOLD.
- Give this document a title: Type the words "MY IMAGE" at the top of the page. Make sure to center it. Use Times New Roman and size 20 font.
- Insert your saved image under the title. You may have to stretch it to make it bigger OR shrink it to make it smaller. Make sure to leave some space under your image for some typing.
- Under you image, write one paragraph about how you have selected this image and why this image represents who you are as a person.
- Save your document to your folder as "My Image" in your "Z" drive.
- EXTRA CREDIT: Use a creative WordArt to create your title instead of just typing it out.
- ONLY IF YOU ARE DONE WITH ALL THE ASSIGNMENTS UP TO THIS POINT CAN YOU
- Play a game. You are only allowed to play this game: FANTASTIC CONTRAPTION.
Lesson 5: Taking Screen-Shots
- IF YOU HAVE NOT COMPLETED LESSONS 1-4, PLEASE COMPLETE THEM BEFORE DOING THIS ONE.
- Click here to complete Lesson #5.
- Today you will be learning how to do screenshots. Follow the instructions below:
- Press the Print Screen key on your keyboard. It may be labeled [PrtScn].
- Open an image editing program, such as Microsoft Paint. --> START --> ACCESSORIES --> PAINT.
- Go to the EDIT menu and choose PASTE.
- If prompted to enlarge the image, choose Yes.
- Optional: Use your image editor's crop tool to crop out unnecessary portions of the screen shot.
- Go to the File Menu and choose Save As. Save you screenshot as MY SCREENSHOT.
- Navigate to the folder where you want to save the image. (HINT: your TECHNOLOGY folder)
- Type a file name for the image. (HINT: MY SCREENSHOT)
- Select a file type. Use either .GIF or .JPEG formats.
- Click the Save button.
- To show that you have mastered this skill, take a screen-shot of this page: CLICK HERE.
- Save this screen-shot as a .GIF or .JPEG and name it MY SCREENSHOT in your TECHNOLOGY folder in the "Z" drive.
- If you are all caught up, you can play Fantastic Contraption only.
Lesson 6: Google Chrome & Exploring Tables in Microsoft Word
- IF YOU HAVE NOT COMPLETED LESSONS 1-5, PLEASE COMPLETE THEM BEFORE DOING THIS ONE. CHECK YOUR "Z" DRIVE. IT SHOULD HAVE THE FOLLOWING FILES NEATLY LABELED: (1)MY BIOGRAPHY, (2) MY IMAGE, and (3) MY SCREENSHOT.
- Click here to complete Lesson #6.
- After you have done the typing warm up, click here.
- You should now see that you are on the Google home page.
- Do an Internet search by typing GOOGLE CHROME into the search field, then press ENTER OR you can just click here.
- Click on DOWNLOAD GOOGLE CHROME.
- Then click on ACCEPT and INSTALL button.
- If a scree pops-up and asks you if you would like to RUN, click on RUN.'
- You should not see the computer downloading the GOOGLE CHROME installer package. Wait patiently until it is done downloading.
- Once it is done downloading, you should see a menu that is asking you where you want to SAVE the installer package. Click on SAVE AS, rename the file as GOOGLE CHROME INSTALLER, and then save it in your TECHNOLOGY folder on the "Z" drive. IF YOU ARE ABLE TO DO THIS STEP, MOVE DOWN TO STEP 13, IF NOT, MOVE ON TO STEP 11.
- If #10 doesn't happen for you, click on START --> MY COMPUTER --> DOWNLOADS (on the left side).
- Once in the DOWNLOADS folder, look for a file named CHROMEINSTALL-7U5, right click on it, select CUT, and the PASTE it into your TECHNOLOGY folder on the "Z" drive.
- Once the file in saved in your TECHNOLOGY folder, double-click on it to install GOOGLE CHROME.
- Follow all the steps it gives to you.
- Once it says that you have successfully, click here for access to a GOOGLE CHROME TUTORIAL.
- Watch the video, read up on stuff that you may have questions about i.e. how to use Google Chrome, etc...
- Now, let explore TABLES in Microsoft Word.
- Today you will be learning how to insert and use tables in Microsoft Word. Tables are a good way to help you organize information.
- First, open up Microsoft Word.
- Go to File, Page Set-up. Change the layout of your document from Portrait to Landscape.
- Change your margins so they all read .5 for top, left, bottom, and right.
- Place your name, date, and period in the upper right-hand corner of the document.
- Next, give your document a title. Title it "The GLOs". Center it across the top. Change its size to 16, its color to green, and its font to Century Gothic.
- Then insert you table. (Hint: look at the very top under "TABLE")
- You will be creating a table that has 7 columns and 3 rows. Columns go up and down while rows go from side to side.
- Leave the upper left box of your table blank.
- Label each box to the right of this box as GLO#1, GLO#2, GLO#3, GLO#4, GLO#5, GLO#6. Make each label bold.
- Under the empty box on the left side, label this box as "NAME" under that box, label the box as "HAWAIIAN NAME".
- Type out the name for each GLO under its correct number in the "NAME" row.
- Type out the Hawaiian name for each GLO in the "HAWAIIAN NAME" row.Make "NAME" & "HAWAIIAN NAME" bold.
- Make sure all of the words inside of the table are size 12 and Century Gothic font.
- GLO#1: Self-Directed Learner
- GLO#2: Community Contributor
- GLO#3: Complex Thinker
- GLO#4: Quality Producer
- GLO#5: Effective Communicator
- GLO#6: Effective and Ethical User of Technology
Hawaiian Names for each GLO
- GLO#1: KULEANA
- GLO#2: HO'OLAULIMA
- GLO#3: MANA'O
- GLO#4: PONO
- GLO#5: 'OLELO
- GLO#6: 'IKE
- When you are done, save this document as "The GLOs" in your TECHNOLOGY folder in the "Z" drive.
- If you are all caught up, you can play Fantastic Contraption or TeenBiz 3000 only.
Lesson 7: My Typing Skills Setup
- IF YOU HAVE NOT COMPLETED LESSONS 1-6, PLEASE COMPLETE THEM BEFORE DOING THIS ONE. CHECK YOUR "Z" DRIVE. IT SHOULD HAVE THE FOLLOWING FILES NEATLY LABELED: (1)MY BIOGRAPHY, (2) MY IMAGE, (3) MY SCREENSHOT, and (4) The GLOs.
- Click here to complete Lesson #7.
- Today, you will be taking a timed typing test. You will be taking this test and tracking your progress using a table much like the one you created in Lesson 6..
- First, open up Microsoft Word: START-->MICROSOFT OFFICE-->MICROSOFT WORD.
- Go to FILE, then PAGE SET UP. Change the margins to 0.5 for the top, left, bottom, and right.
- Change the page's orientation from Portrait to Landscape.
- Place your name, date, and period in the upper right-hand corner of the document.
- Title this document as "My 1 Minute Typing Skills"
- Center you title. Change its size to 16, its font to Times New Roman. Make it bold and underline it.
- Press ENTER. Leave a space between the title and your table.
- Next, insert your table. (Hint: Click TABLE up at the top)
- The table that you will be inserting must have 5 columns and 2 rows. (columns are vertical while rows are horizontal)
- The top 5 boxes will be where you will label each section. Label the top left box as "Story". Label the next box in you table as "Typing Speed". Label the box to the right as "Errors". Label the next box as "Accuracy". Label the last box as "Adjusted Speed". Make all of these labels BOLD and size 12 in TIMES NEW ROMAN.
- Leave the bottom row blank for now.
- Highlight the entire top row, right-click on any highlighted portion, then click on BORDERS and SHADING. Shade only the top row 5 rows in BRIGHT GREEN.
- Highlight the entire top row again and CENTER all the labels. (Hint: use the center button at the top)
- Click here to see what your final product should look like: MY TYPING SKILLS
- Save this document as "My 1 Minute Typing Skills" in your TECHNOLOGY folder on the "Z" drive. Close this document and then open up your TECHNOLOGY folder.
- In your folder you will see all of the assignments that you have done thus far.
- In your folder, by right-clicking anywhere in the folder, moving the mouse to NEW, then clicking on FOLDER.
- I want you to rename the new folder as "My Typing Skills".
- Then, right click on the Word document named "My 1 Minute Typing Skills" and then click on CUT.
- Move your mouse over the new folder you just created, right click on it, and then click on PASTE.
- Open up the new folder. You should now see a Microsoft Word document in there named "My 1 Minute Typing Skills".
- Now, double-click on the document titled "MY 1 MINUTE TYPING" change the title to "MY 2 MINUTE TYPING SKILLS".
- Then click on FILE-->SAVE AS then name it "MY 2 MINUTE TYPING SKILLS".
- change the title again to "MY 3 MINUTE TYPING SKILLS".
- Then click on FILE-->SAVE AS then name it "MY 3 MINUTE TYPING SKILLS".
- MAKE SURE TO CHECK YOUR TECHNOLOGY FOLDER. IN YOUR TECHNOLOGY FOLDER THERE SHOULD BE ALL OF THE WORK THAT YOU HAVE DONE SO FAR AS WELL AS A FOLDER NAMED "MY TYPING SKILLS". INSIDE OF THE FOLDER NAMED "MY TYPING SKILLS", YOU SHOULD HAVE 3 MICROSOFT WORD DOCUMENTS NAMED "MY 1 MINUTE TYPING SKILLS", "MY 2 MINUTE TYPING SKILLS", & "MY 3 MINUTE TYPING SKILLS".
- Now, on to the typing challenge. Click here to go to the website: Typing Skills
- Change the time to 1 minute. The box below the time should say "AESOP"S FABLES". Change it if it doesn't.
- When you are ready click on START. The test will begin when you start typing.
- When you are done with the challenge, you will see your results.
- There will be a gray, red, and blue circle. There are also some words below each circle. Here is where you will find the information you need to fill in that table that you created earlier. (WPM = Words Per Minute)
- Now go to your TECHNOLOGY folder, double-click on the folder named MY TYPING SKILLS, then double-click on the file named MY 1 MINUTE TYPING SKILLS.
- Under the box that says STORY, type in AESOP'S FABLES and the hit the TAB key. This moves the cursor over to the next box.
- Enter in all of the required information using the results from the website. Remember to use the TAB key.
- Once you have completed typing in your ADJUSTED SPEED, hit the TAB key once more. You should now see that a new row has been created.
- Once you have gone through all of the above steps, click on FILE-->SAVE. This will save all of the information that you just entered in.
- Now go back to your MY TYPING SKILLS folder and double-click on MY 2 MINUTE TYPING SKILLS.
- Go back to the window that is showing the results for your 1 minute typing challenge and click on RESTART TEST. This will take you back to the main page.
- Change the time to 2 minutes and make sure it says AESOP'S FABLES, then click on START.
- Once you are completed, update the results into your 2 MINUTE TYPING SKILLS using the TAB key again.
- Lastly, complete the challenge again for 3 minutes and then update your 3 MINUTE TYPING SKILLS using the TAB key again.
- Do not forget to FILE-->SAVE all files before closing and moving on to step 45.
- If you are all caught up, you can play Fantastic Contraption OR TEENBIZ and/or ALEKS.
Lesson 8: The Typing Starts
- MAKE SURE TO COMPLETE ALL LESSONS BEFORE MOVING ON TO NEWER ONES.
- First, make sure that you are using GOOGLE CHROME, if you are not, close out this window and then come back to this page.
- Now click here.
- This should take you to a GOOGLEdocs page that is shared with everyone in our class. Follow the directions on the page
- Now, click here to complete Lesson # 8.
- Click here to go to the website: Typing Skills
- Change the story to RULES OF BASEBALL.
- Make sure the clock reads 1 MINUTE.
- Then click on START.
- Once you are done typing, leave the window open then Go to your "Z" drive and open the file called MY 1 MINUTE TYPING SKILLS.
- You can use the TAB key to add a new row.
- Update all of the information on the chart, then click FILE-->SAVE.
- Close out the file and OPEN the file named MY 2 MINUTE TYPING SKILLS
- Now go back to the TYPING SKILLS website and click on RESTART TEST.
- Change the TIME to 2 MINUTES.
- Change the story to RULES OF BASEBALL.
- Then click on START.
- After you are done typing, update your 2 MINUTE TYPING SKILLS chart, then click on FILE-->SAVE.
- Close out the file and OPEN the file named MY 3 MINUTE TYPING SKILLS
- Now go back to the TYPING SKILLS website and click on RESTART TEST.
- Change the TIME to 3 MINUTES.
- Change the story to RULES OF BASEBALL.
- Then click on START.
- After you are done typing, update your 3 MINUTE TYPING SKILLS chart, then click on FILE-->SAVE.
- If you are all caught up, you can play Fantastic Contraption OR TEENBIZ and/or ALEKS.
Lesson 9: Keep on Typing
- MAKE SURE TO COMPLETE ALL LESSONS BEFORE MOVING ON TO NEWER ONES.
- Warm up by clicking here to complete Lesson # 9.
- Click here to go to the website: Typing Skills
- Change the story to SPACE COWBOYS.
- Make sure the clock reads 1 MINUTE.
- Then click on START.
- Once you are done typing, leave the window open then Go to your "Z" drive and open the file called MY 1 MINUTE TYPING SKILLS.
- You can use the TAB key to add a new row.
- Update all of the information on the chart, then click FILE-->SAVE.
- Close out the file and OPEN the file named MY 2 MINUTE TYPING SKILLS
- Now go back to the TYPING SKILLS website and click on RESTART TEST.
- Change the TIME to 2 MINUTES.
- Change the story to SPACE COWBOYS.
- Then click on START.
- After you are done typing, update your 2 MINUTE TYPING SKILLS chart, then click on FILE-->SAVE.
- Close out the file and OPEN the file named MY 3 MINUTE TYPING SKILLS
- Now go back to the TYPING SKILLS website and click on RESTART TEST.
- Change the TIME to 3 MINUTES.
- Change the story to SPACE COWBOYS.
- Then click on START.
- After you are done typing, update your 3 MINUTE TYPING SKILLS chart, then click on FILE-->SAVE.
- If you are all caught up, you can play Fantastic Contraption OR TEENBIZ and/or ALEKS.
Lesson 10: No Hands Allowed
PART 1
- MAKE SURE TO COMPLETE ALL LESSONS BEFORE MOVING ON TO NEWER ONES..
- Completer Lesson #10.
- Click here to go to the website: Typing Skills
- Change the story to SPACE COWBOYS.
- Make sure the clock reads 1 MINUTE.
- Then click on START.
- Once you are done typing, leave the window open then Go to your "Z" drive and open the file called MY 1 MINUTE TYPING SKILLS.
- You can use the TAB key to add a new row.
- Update all of the information on the chart, then click FILE-->SAVE.
- Close out the file and OPEN the file named MY 2 MINUTE TYPING SKILLS
- Now go back to the TYPING SKILLS website and click on RESTART TEST.
- Change the TIME to 2 MINUTES.
- Change the story to SPACE COWBOYS.
- Then click on START.
- After you are done typing, update your 2 MINUTE TYPING SKILLS chart, then click on FILE-->SAVE.
- Close out the file and OPEN the file named MY 3 MINUTE TYPING SKILLS
- Now go back to the TYPING SKILLS website and click on RESTART TEST.
- Change the TIME to 3 MINUTES.
- Change the story to SPACE COWBOYS.
- Then click on START.
- After you are done typing, update your 3 MINUTE TYPING SKILLS chart, then click on FILE-->SAVE.
- Now Read this article.
- Complete the assignment at the bottom of the article.
- Save the Microsoft Word document that you created as "MS WORD NO HANDS" into you TECHNOLOGY folder on the "Z" drive.
- If you are all caught up, you can play Fantastic Contraption OR TEENBIZ and/or ALEKS.
Lesson 11: The Frayer Model
Part 1
- MAKE SURE TO COMPLETE ALL LESSONS BEFORE MOVING ON TO NEWER ONES.
- Complete Lesson #11.
- Click here to go to the website: Typing Skills
- Change the story to TIGERS IN THE WILD.
- Make sure the clock reads 1 MINUTE.
- Then click on START.
- Once you are done typing, leave the window open then Go to your "Z" drive and open the file called MY 1 MINUTE TYPING SKILLS.
- You can use the TAB key to add a new row.
- Update all of the information on the chart, then click FILE-->SAVE.
- Close out the file and OPEN the file named MY 2 MINUTE TYPING SKILLS
- Now go back to the TYPING SKILLS website and click on RESTART TEST.
- Change the TIME to 2 MINUTES.
- Change the story to TIGERS IN THE WILD.
- Then click on START.
- After you are done typing, update your 2 MINUTE TYPING SKILLS chart, then click on FILE-->SAVE.
- Close out the file and OPEN the file named MY 3 MINUTE TYPING SKILLS
- Now go back to the TYPING SKILLS website and click on RESTART TEST.
- Change the TIME to 3 MINUTES.
- Change the story to TIGERS IN THE WILD.
- Then click on START.
- After you are done typing, update your 3 MINUTE TYPING SKILLS chart, then click on FILE-->SAVE.
- Open up Microsoft Word.
- Go to FILE-->PAGE SETUP
- Change the MARGINS for the TOP, LEFT, RIGHT, and BOTTOM to 0.5.
- Change the ORIENTATION to LANDSCAPE.
- Put your name, date, and period in the upper right-hand corner.
- Title this document as "FRAYER MODEL".
- Center the title across the top and make it BOLD and UNDERLINE it.
- Then, click here: Frayer Model.
- You will be using Microsoft Word to create a replica of this graphic organizer.
- Remember you have the entire page to work with, so don't be afraid of using the space that is available.
- Hint: use the "DRAW" tool to create your circles and squares.
- If you have any questions use the INTERNET as a tool to help you. It is a powerful tool, so use it.
- When you are done click on FILE-->SAVE AS then change the location to your TECHNOLOGY folder on the "Z" drive.
- Save the document as "FRAYER MODEL GRAPHIC ORGANIZER" into your TECHNOLOGY folder on the "Z" drive.
- When caught up with ALL LESSONS please do Aleks or Teenbiz thnx love GIA :P >.<)
Lesson 12: Excel Battleship
MAKE SURE TO COMPLETE ALL LESSONS BEFORE MOVING ON TO NEWER ONES.
In this lesson, you will use MS Excel to recreate one of my favorite games...BATTLESHIP!
To create the battleship game, you will primarily use formatting features.
Setup
1) Open a MS Excel workbook.
2) You should see three tabs on the bottom named Sheet 1, Sheet 2, Sheet 3. You may delete Sheet three if you wish.
3) In the following steps you will create two formatted worksheets – one for your own ships, and one in which to mark hits on the “enemy’s” ships.
Rename Sheets
1) Click the Sheet1 tab at the bottom of your spreadsheet window. Right click to get the pop-up menu, then choose rename. Type the new name in the tab.
2) You can also double-click the sheet tab and type in the new
name. Call the first sheet Enemy Ships.
3) Click or double click Sheet2 tab and rename Sheet2 My Ships.
4) Return to the “Enemy Ships” tab to begin formatting the first game board.
Set up Game Board
1) Adjust column width and row height to create larger, square cells.
a) Put your cursor over the column label A, and drag over to column J. You should have columns A – J highlighted.
b) With your cursor still in the grey column heading area, position it over the boundary line between two column headings. The cursor should look
like a doubleheaded arrow. Click and drag the cursor to change the column width. As you drag, a yellow “sticky” label appears. Use that as a guide to set
the width to 50 pixels (or eyeball the size). When you release from dragging, all 10 columns should be the same narrower size.
c) Position your cursor over the row one heading number one. Drag down until 10 rows are highlighted. With your cursor still in the grey row heading area,
position it over the boundary between two of the rows so it looks like a double headed arrow. Drag the boundary down until the yellow “sticky” indicates
50 pixels (or eyeball the size).
2) Color the cells of the 10x10 grid and display all cell borders.
a) Highlight the range A1:J10. This should create a square 10 columns wide by 10 rows deep.
b) Using the paint bucket button on your formatting toolbar (far right), choose a light blue color to fill the highlighted area.
c) After setting a fill color, the gridlines disappear. While the game board area is still selected, use the borders button next to the paint bucket on the
formatting toolbar and choose the selection for All Borders.
3) Format cell alignment so text is centered vertically and horizontally in all game board cells.
a) With the range A1:J10 still selected, go to the Format menu>Cells>Alignment tab. Choose “center” for the horizontal and vertical cell alignment.
4) Copy game board to second worksheet My Ships.
a) With the range A1:J10 selected, choose copy. Click the tab for My Ships at the bottom of the workbook screen.
b) In the new worksheet, choose paste. This pastes the color, but you need to repeat step 1 from above to change the column and row sizes.
SAVE THE WORKSHEET AS "BATTLESHIP" IN YOUR TECHNOLOGY FOLDER ON THE "Z" DRIVE.
Your Ships
Use the following key for number and size of ships.
Number of Ships----Ship Length Color
1 Aircraft Carrier-----6 squares Orange
2 Battleships----------5 squares Yellow
2 Destroyers----------4 squares Light green
2 Submarines--------3 squares Grey
1 Cruiser---------------2 squares Light Red
Color Ships
1) Select the “squares” or cells where the ship should be located. Use the paint bucket on the formatting toolbar to change the fill color of those ships. Note
that the ships are entered only in the My Ships worksheet.
Playing the Game
1) Two students play together. You need to play where you cannot see each others’ screens.
2) Decide who goes first.
3) That player calls out the column and row – i.e. “C5”.
4) The opponent answers hit or miss.
5) On the sheet Enemy Ships (NOT where your ships are!), the player marks an H for hit, an M for miss, or an HS for hit and sunk (or color the cells of the
sunk ship black). If you get a hit, you get a second guess.
6) Now the opponent gets to call out a column and row. The player looks at the My Ships sheet and marks an H or an M, depending on if a ship is hit or not.
The first player to sink all of the opponents’ ships is the winner.
If you are all caught up, you can play Fantastic Contraption OR TEENBIZ and/or ALEKS.
In this lesson, you will use MS Excel to recreate one of my favorite games...BATTLESHIP!
To create the battleship game, you will primarily use formatting features.
Setup
1) Open a MS Excel workbook.
2) You should see three tabs on the bottom named Sheet 1, Sheet 2, Sheet 3. You may delete Sheet three if you wish.
3) In the following steps you will create two formatted worksheets – one for your own ships, and one in which to mark hits on the “enemy’s” ships.
Rename Sheets
1) Click the Sheet1 tab at the bottom of your spreadsheet window. Right click to get the pop-up menu, then choose rename. Type the new name in the tab.
2) You can also double-click the sheet tab and type in the new
name. Call the first sheet Enemy Ships.
3) Click or double click Sheet2 tab and rename Sheet2 My Ships.
4) Return to the “Enemy Ships” tab to begin formatting the first game board.
Set up Game Board
1) Adjust column width and row height to create larger, square cells.
a) Put your cursor over the column label A, and drag over to column J. You should have columns A – J highlighted.
b) With your cursor still in the grey column heading area, position it over the boundary line between two column headings. The cursor should look
like a doubleheaded arrow. Click and drag the cursor to change the column width. As you drag, a yellow “sticky” label appears. Use that as a guide to set
the width to 50 pixels (or eyeball the size). When you release from dragging, all 10 columns should be the same narrower size.
c) Position your cursor over the row one heading number one. Drag down until 10 rows are highlighted. With your cursor still in the grey row heading area,
position it over the boundary between two of the rows so it looks like a double headed arrow. Drag the boundary down until the yellow “sticky” indicates
50 pixels (or eyeball the size).
2) Color the cells of the 10x10 grid and display all cell borders.
a) Highlight the range A1:J10. This should create a square 10 columns wide by 10 rows deep.
b) Using the paint bucket button on your formatting toolbar (far right), choose a light blue color to fill the highlighted area.
c) After setting a fill color, the gridlines disappear. While the game board area is still selected, use the borders button next to the paint bucket on the
formatting toolbar and choose the selection for All Borders.
3) Format cell alignment so text is centered vertically and horizontally in all game board cells.
a) With the range A1:J10 still selected, go to the Format menu>Cells>Alignment tab. Choose “center” for the horizontal and vertical cell alignment.
4) Copy game board to second worksheet My Ships.
a) With the range A1:J10 selected, choose copy. Click the tab for My Ships at the bottom of the workbook screen.
b) In the new worksheet, choose paste. This pastes the color, but you need to repeat step 1 from above to change the column and row sizes.
SAVE THE WORKSHEET AS "BATTLESHIP" IN YOUR TECHNOLOGY FOLDER ON THE "Z" DRIVE.
Your Ships
Use the following key for number and size of ships.
Number of Ships----Ship Length Color
1 Aircraft Carrier-----6 squares Orange
2 Battleships----------5 squares Yellow
2 Destroyers----------4 squares Light green
2 Submarines--------3 squares Grey
1 Cruiser---------------2 squares Light Red
Color Ships
1) Select the “squares” or cells where the ship should be located. Use the paint bucket on the formatting toolbar to change the fill color of those ships. Note
that the ships are entered only in the My Ships worksheet.
Playing the Game
1) Two students play together. You need to play where you cannot see each others’ screens.
2) Decide who goes first.
3) That player calls out the column and row – i.e. “C5”.
4) The opponent answers hit or miss.
5) On the sheet Enemy Ships (NOT where your ships are!), the player marks an H for hit, an M for miss, or an HS for hit and sunk (or color the cells of the
sunk ship black). If you get a hit, you get a second guess.
6) Now the opponent gets to call out a column and row. The player looks at the My Ships sheet and marks an H or an M, depending on if a ship is hit or not.
The first player to sink all of the opponents’ ships is the winner.
If you are all caught up, you can play Fantastic Contraption OR TEENBIZ and/or ALEKS.
Lesson 13: My KWL Chart (Part I)
Part 1
- MAKE SURE TO COMPLETE ALL LESSONS BEFORE MOVING ON TO NEWER ONES.
- Complete Lesson #13.
- Click here to go to the website: Typing Skills
- Change the story to THE WONDERFUL WIZARD OF OZ.
- Make sure the clock reads 1 MINUTE.
- Then click on START.
- Once you are done typing, leave the window open then Go to your "Z" drive and open the file called MY 1 MINUTE TYPING SKILLS.
- You can use the TAB key to add a new row.
- Update all of the information on the chlart, then click FILE-->SpAVE.
- Close out the file and OPEN the file named MY 2 MINUTE TYPING SKILLS
- Now go back to the TYPING SKILLS website and click on RESTART TEST.
- Change the TIME to 2 MINUTES.
- Change the story to THE WONDERFUL WIZARD OF OZ .
- Then click on START.
- After you are done typing, update your 2 MINUTE TYPING SKILLS chart, then click on FILE-->SAVE.
- Close out the file and OPEN the file named MY 3 MINUTE TYPING SKILLS
- Now go back to the TYPING SKILLS website and click on RESTART TEST.
- Change the TIME to 3 MINUTES.
- Change the story to THE WONDERFUL WIZARD OF OZ .
- Then click on START.
- After you are done typing, update your 3 MINUTE TYPING SKILLS chart, then click on FILE-->SAVE.
- Open up Microsoft Word.
- Go to FILE-->PAGE SETUP
- Change the MARGINS for the TOP, LEFT, RIGHT, and BOTTOM to 0.5.
- Change the ORIENTATION to LANDSCAPE.
- Put your name, date, and period in the upper right-hand corner.
- Title this document as "KWL Chart".
- Center the title across the top and make it BOLD and UNDERLINE it.
- Now go to TABLE-->INSERT-->TABLE.
- Change the number of rows to 2 and the number of columns to 3.
- Highlight only the entire top row of the table, then click on the CENTER button. This centers all of the text in the row for each cell.
- In the upper-left cell, type in the letter "K" and hit ENTER.
- You should now see the cursor under the letter "K", but still in the same upper-left cell.
- Now type in "WHAT I KNOW".
- Hit the TAB key (this should move the cursor to the upper-middle cell), now type in the letter "W".
- You should now see the cursor under the letter "W", but still in the same upper-middle cell.
- Now type in "WHAT I WANT TO KNOW".
- Hit the TAB key once more (this should now take you to the upper-right cell), now type in the letter "L".
- You should now see the cursor under the letter "L", but still in the same upper-right cell.
- Now type in "WHAT I LEARNED".
- Now I want you to go back and highlight only the letters "K", "W", and "L".
- This can be done by first highlighting the letter "K" and while holding down the CTRL key, highlighting the letters "W" and "L" individually.
- You should now see only the letters "K", "W", and "L" highlighted.
- I want you to use the drop down menu and change their size to 20.
- You can see now that it changes all of the highlighted letters at the same time.
- Now while the letters are still highlighted, click on the BOLD button at the top OR hit CTRL+B.
- Next I want you to highlight only the entire top row again.
- Once you've highlighted it, right-click anywhere on the highlighted portion.
- When the pop-up menu appears, select BORDERS AND SHADING
- On the window that opens, click on SHADING from the top tab.
- Select the color BRIGHT GREEN. Then click OK.
- Click here to see what your paper should look like. The only difference is that you will have big letters "K", "W", and "L" in the top rows.
- Now click into the cell under the "K".
- Here I want you to type in all the things you KNOW OR THINK YOU KNOW about technology.
- When you are done, hit the TAB key (your cursor should now be in the cell under the "W").
- Here I want you to type in all the things you WANT TO KNOW about TECHNOLOGY.
- When you are done click on FILE-->SAVE AS then change the location to your TECHNOLOGY folder on the "Z" drive.
- Save the document as "MY KWL CHART" into your TECHNOLOGY folder on the "Z" drive.
- If you are all caught up, you can play Fantastic Contraption OR TEENBIZ and/or ALEKS.
Lesson 14: My KWL Chart (Part II)
Part 1
- MAKE SURE TO COMPLETE ALL LESSONS BEFORE MOVING ON TO NEWER ONES.
- Complete Lesson #14.
- Click here to go to the website: Typing Skills
- Change the story to ZEBRA - AFRICA'S STRIPED HORSE.
- Make sure the clock reads 1 MINUTE.
- Then click on START.
- Once you are done typing, leave the window open then Go to your "Z" drive and open the file called MY 1 MINUTE TYPING SKILLS.
- You can use the TAB key to add a new row.
- Update all of the information on the chart, then click FILE-->SAVE.
- Close out the file and OPEN the file named MY 2 MINUTE TYPING SKILLS
- Now go back to the TYPING SKILLS website and click on RESTART TEST.
- Change the TIME to 2 MINUTES.
- Change the story to ZEBRA - AFRICA'S STRIPED HORSE.
- Then click on START.
- After you are done typing, update your 2 MINUTE TYPING SKILLS chart, then click on FILE-->SAVE.
- Close out the file and OPEN the file named MY 3 MINUTE TYPING SKILLS
- Now go back to the TYPING SKILLS website and click on RESTART TEST.
- Change the TIME to 3 MINUTES.
- Change the story to ZEBRA - AFRICA'S STRIPED HORSE .
- Then click on START.
- After you are done typing, update your 3 MINUTE TYPING SKILLS chart, then click on FILE-->SAVE.
- Go to your TECHNOLOGY folder on the "Z" drive.
- Double-click on the file named "MY KWL CHART".
- You will need this chart to complete today's lesson.
- Next, click here and read the following article.
- After you have read the above article, go back to your KWL chart and fill in the "L" column with things that you learned about TECHNOLOGY from the article.
- To successfully complete this assignment, you will need to fill in the "L" column with 5 things you learned.
- If you are all caught up, you can play Fantastic Contraption OR TEENBIZ and/or ALEKS.
Lesson 15: The TeenBiz3000 Saga Continues
Part 1
- MAKE SURE TO COMPLETE ALL LESSONS BEFORE MOVING ON TO NEWER ONES.
- Complete Lesson #15.
- Click here to go to the website: Typing Skills
- Change the story to THE ENCHANTED TYPEWRITER.
- Make sure the clock reads 1 MINUTE.
- Then click on START.
- Once you are done typing, leave the window open then Go to your "Z" drive and open the file called MY 1 MINUTE TYPING SKILLS.
- You can use the TAB key to add a new row.
- Update all of the information on the chart, then click FILE-->SAVE.
- Close out the file and OPEN the file named MY 2 MINUTE TYPING SKILLS
- Now go back to the TYPING SKILLS website and click on RESTART TEST.
- Change the TIME to 2 MINUTES.
- Change the story to THE ENCHANTED TYPEWRITER.
- Then click on START.
- After you are done typing, update your 2 MINUTE TYPING SKILLS chart, then click on FILE-->SAVE.
- Close out the file and OPEN the file named MY 3 MINUTE TYPING SKILLS
- Now go back to the TYPING SKILLS website and click on RESTART TEST.
- Change the TIME to 3 MINUTES.
- Change the story to THE ENCHANTED TYPEWRITER.
- Then click on START.
- After you are done typing, update your 3 MINUTE TYPING SKILLS chart, then click on FILE-->SAVE.
- Quarter 1 is quickly coming to an end, and I want to make sure that you are on pace to meeting the goal for TeenBiz. The goal is 20 articles for each quarter. To see how many articles that you have completed, you can look next to the thermometer on your homepage. The number next to the greater than or equal to sign would be your number. That number needs to be ≥ (greater than or equal to) 20.
- Use the rest of today's class period to catch up on your TeenBiz articles: www.teenbiz3000.com.
- If you are all caught up, you can play Fantastic Contraption OR TEENBIZ and/or ALEKS.
Lesson #16 and continues
Part 1
- MAKE SURE TO COMPLETE ALL LESSONS BEFORE MOVING ON TO NEWER ONES.
- Complete Lesson #16.
- Click here to go to the website: Typing Skills
- Change the story to TEST INSTRUCTIONS.
- Make sure the clock reads 1 MINUTE.
- Then click on START.
- Once you are done typing, leave the window open then Go to your "Z" drive and open the file called MY 1 MINUTE TYPING SKILLS.
- You can use the TAB key to add a new row.
- Update all of the information on the chart, then click FILE-->SAVE.
- Close out the file and OPEN the file named MY 2 MINUTE TYPING SKILLS
- Now go back to the TYPING SKILLS website and click on RESTART TEST.
- Change the TIME to 2 MINUTES.
- Change the story to TEST INSTRUCTIONS.
- Then click on START.
- After you are done typing, update your 2 MINUTE TYPING SKILLS chart, then click on FILE-->SAVE.
- Close out the file and OPEN the file named MY 3 MINUTE TYPING SKILLS
- Now go back to the TYPING SKILLS website and click on RESTART TEST.
- Change the TIME to 3 MINUTES.
- Change the story to TEST INSTRUCTIONS.
- Then click on START.
- After you are done typing, update your 3 MINUTE TYPING SKILLS chart, then click on FILE-->SAVE.
- Quarter 1 is quickly coming to an end, and I want to make sure that you are on pace to meeting the goal for TeenBiz. The goal is 20 articles for each quarter. To see how many articles that you have completed, you can look next to the thermometer on your homepage. The number next to the greater than or equal to sign would be your number. That number needs to be ≥ (greater than or equal to) 20.
- Use the rest of today's class period to catch up on your TeenBiz articles: www.teenbiz3000.com.
- If you are all caught up, you can play Fantastic Contraption OR TEENBIZ and/or ALEKS.
Lesson #17 and continues
Part 1
- MAKE SURE TO COMPLETE ALL LESSONS BEFORE MOVING ON TO NEWER ONES.
- Complete Lesson #17.
- Click here to go to the website: Typing Skills
- Change the story to THE ENCHANTED TYPEWRITER.
- Make sure the clock reads 1 MINUTE.
- Then click on START.
- Once you are done typing, leave the window open then Go to your "Z" drive and open the file called MY 1 MINUTE TYPING SKILLS.
- You can use the TAB key to add a new row.
- Update all of the information on the chart, then click FILE-->SAVE.
- Close out the file and OPEN the file named MY 2 MINUTE TYPING SKILLS
- Now go back to the TYPING SKILLS website and click on RESTART TEST.
- Change the TIME to 2 MINUTES.
- Change the story to THE ENCHANTED TYPEWRITER.
- Then click on START.
- After you are done typing, update your 2 MINUTE TYPING SKILLS chart, then click on FILE-->SAVE.
- Close out the file and OPEN the file named MY 3 MINUTE TYPING SKILLS
- Now go back to the TYPING SKILLS website and click on RESTART TEST.
- Change the TIME to 3 MINUTES.
- Change the story to THE ENCHANTED TYPEWRITER.
- Then click on START.
- After you are done typing, update your 3 MINUTE TYPING SKILLS chart, then click on FILE-->SAVE.
- Quarter 1 is quickly coming to an end, and I want to make sure that you are on pace to meeting the goal for TeenBiz. The goal is 20 articles for each quarter. To see how many articles that you have completed, you can look next to the thermometer on your homepage. The number next to the greater than or equal to sign would be your number. That number needs to be ≥ (greater than or equal to) 20.
- Use the rest of today's class period to catch up on your TeenBiz articles: www.teenbiz3000.com.
- If you are all caught up, you can play Fantastic Contraption OR TEENBIZ and/or ALEKS.
Lesson 18 and continues
Part 1
- MAKE SURE TO COMPLETE ALL LESSONS BEFORE MOVING ON TO NEWER ONES.
- Complete Lesson #18.
- Click here to go to the website: Typing Skills
- Change the story to ZEBRAS-AFRICA'S STRIPED HORSE.
- Make sure the clock reads 1 MINUTE.
- Then click on START.
- Once you are done typing, leave the window open then Go to your "Z" drive and open the file called MY 1 MINUTE TYPING SKILLS.
- You can use the TAB key to add a new row.
- Update all of the information on the chart, then click FILE-->SAVE.
- Close out the file and OPEN the file named MY 2 MINUTE TYPING SKILLS
- Now go back to the TYPING SKILLS website and click on RESTART TEST.
- Change the TIME to 2 MINUTES.
- Change the story to ZEBRAS-AFRICA'S STRIPED HORSE.
- Then click on START.
- After you are done typing, update your 2 MINUTE TYPING SKILLS chart, then click on FILE-->SAVE.
- Close out the file and OPEN the file named MY 3 MINUTE TYPING SKILLS
- Now go back to the TYPING SKILLS website and click on RESTART TEST.
- Change the TIME to 3 MINUTES.
- Change the story to ZEBRAS-AFRICA'S STRIPED HORSE.
- Then click on START.
- After you are done typing, update your 3 MINUTE TYPING SKILLS chart, then click on FILE-->SAVE.
- Quarter 1 is quickly coming to an end, and I want to make sure that you are on pace to meeting the goal for TeenBiz. The goal is 20 articles for each quarter. To see how many articles that you have completed, you can look next to the thermometer on your homepage. The number next to the greater than or equal to sign would be your number. That number needs to be ≥ (greater than or equal to) 20.
- Use the rest of today's class period to catch up on your TeenBiz articles: www.teenbiz3000.com.
- If you are all caught up TEENBIZ and/or ALEKS.