Objective: SWBAT Create an original work as a means of expression
Construct a screen layout of the Excel screen and label the appropriate parts of the Excel environment
Language Objective: SWBAT Use content vocabulary correctly
|
No assignment today, finish up any missing work. If you are caught up your time is your own. Remember we are on Early release schedule today. Enjoy your vacation and have a very merry Christmas.
Objective: SWBAT Create an original work as a means of expression Construct a screen layout of the Excel screen and label the appropriate parts of the Excel environment Language Objective: SWBAT Use content vocabulary correctly
0 Comments
City Format Assignment:
We will have a lesson on how to format the various parts of the assignment, however there are instructions of where to go and how to create the different parts of the assignments. When you are finished your copy should look exactly like mine. On edmodo the assignment is "City Format Assignment." Read all instructions before you start. 1. Insert a Header with you first and last name, header and footer are found on the Insert tab. 2. Town Name, (Emmett Idaho) size 12 font, Times New Roman in column B and C row 1, must merge cells, so highlight those cells, right click, select format cells, then alignment and select merge. 4th Street, (merged in column B and C, row 3 ) and Main Street, (merged in column B and C, row 21 ) should be done just as you did Emmett. 3. Names of business/places need to be on the edge of the cell, as shown. Right Align names in Column A. Names in column D should be on the left as shown. Resize columns A and D to about 26MM or 1.5 inches. Click up in the column heading on the boarder of the two columns with the double lines and you can see the column width and change it. Business names go in row 2, 5-20 and 23 in columns A and D. 4. Format borders- street lines (curbs) heavy and center lines should be lighter or dotted. Highlight the area you want to place the boarder and right click, select format cells, and then boarders. You must be careful and think about where you are placing the boarder and what you need to highlight. 5. Next type Washington Ave in cell B5. Highlight column B from row 5 to row 20, right click, select format cells and select alignment. On horizontal select right and on vertical select center. Then select merge cells and change the orientation 90 degrees by dragging down on the arrow. 6. Finally include twelve clip art which is on the insert tab. Once you select a clip art you will need to resize them to fit in your document. Put them next to the the business that the clip art represents. See the example. Keys: Merging cells, boarders, alignment, widening cells, and highlighting. Remember to capitalize! Objective: SWBAT Create an original work as a means of expression Language Objective: SWBAT Use content vocabulary correctly Today we will begin by looking at the Excel screen. We will also look at how to write a basic math formula. Remember that all formulas must begin with an equal sign =.
Lunch Budget Why are we doing this? I would like you to get a feeling for what it might cost to eat out every day for a week. You are to pretend that you are attending a five day, Monday through Friday, business conference in Boise. Each day you will go out to lunch at a different restaurant. You will find the exact price of each lunch and the total price for the week from each restaurant listed below. You do not need to figure/include tax. Key terms/concepts: widening columns, formatting money, cell reference/addresses, formulas, formulas with cell addresses, word art, clip art, header, link Internet research: You must search the internet and find the menu prices of each meal listed below, Your Google search is underlined. When you do these searches remember you are looking for the actual business. Know that the web site you are looking for will most likely have the business name in the web address. When you get to the correct web site find the area you are looking for, don’t be afraid to click things, that is how you increase your ability in web site navigation. If you feel like you have gone in the wrong direction click the back arrow, or reenter your search. Write down the price of each meal as you find them. When you have found the price of each meal then begin you spreadsheet. 1. Olive Garden, Boise Town Square- Pronto lunch menu- Grilled Chicken Flatbread 2. El Gallo Giro- Boise- #1 combination 3. Mongolian BBQ Boise - Barbarian Khan, all you can eat, lunch price. 4. Old Chicago down town Boise- must select location- Sandwich, Chicken Pesto Panini. 5. RAM Boise- Fire Grilled Burgers- The All American Once you have completed your research create a spreadsheet named Lunch Budget that details the price of your lunches: 1. Create A header with your first and last name. 2. A Title on your spreadsheet (Lunch Budget) using word art. Title should not go below row 4 or 5 and not past column G. 3. Put the names of the restaurants in cells A6-A10 starting with Olive Garden, use Times New Roman size 12 font. You must widen column A so the names of the restaurants will fit. Click on boarder of the column heading and with the double line you can widen the cell. In Cells C6–C10 put the price of each lunch. In cell A11 put the title Total Cost, and in cell C11 create a formula that calculates the cost of your lunches for a week. Use cell addresses for your formula, and remember all formulas must begin with an equal (=) sign. Format your prices as Accounting or currency, click the arrow above number on the ribbon to open the drop down menu. 4. Add a clip art to go with your theme of lunch. (Clip art must be similar in size to your lunch spreadsheet, no more than 6/7 rows.) 5. Finally attach the document to the edmodo assignment, "Lunch Budget and turn it in. Objective: SWBAT Create an original work as a means of expression Language Objective: SWBAT Use content vocabulary correctly Test over Access on edmodo
When you are finished with the test and your name is not on the board for missing work you may do as you wish, but stay in your seat and keep it quiet. Objective: SWBAT Demonstrate knowledge of Access by completing test Language Objective: SWBAT Use content vocabulary correctly on exam Today we will begin working with Excel. You will create a screen capture just as before by doing a print screen capture, (CTRL & print screen) of the Excel screen and paste it, (CTRL & V) to a word document named Excel Screen Layout. You will then label the screen with text boxes and arrows as shown on the example. The Excel vocabulary list is also here and I would like you to type out the definitions. You will not have another assignment until Wednesday so you have plenty of time to do this. You can use the textbook that is on the bookshelf by the flag. One of the words, formula bar is done for you. I have also created a Quizlet called "Access Review." This is designed to help you study for the test. It would be wise to spend some time with this today. Objective: SWBAT Create an original work as a means of expression Construct a screen layout of the Excel screen and label the appropriate parts of the Excel environment Language Objective: SWBAT Use content vocabulary correctly Excel Vocabulary List Active Cell AutoFill- Look in index Cell Cell Reference Column Heading- what identifies the column heading p. 320 Range Row Heading- What identifies the column heading p. 320 Workbook Worksheet Formula Bar- Special tool bar in Excel Label Value Spreadsheet There will be a test over Access next Tuesday
Presentations/Late work If you have finished all work I want you to go to code.org. Spend what ever time you have on this site creating code. I will play the into video. If you have experience with this you can move to what ever level you need to. Objective: SWBAT Create an original work as a means of expression Language Objective: SWBAT Use content vocabulary correctly Test review over Access
Final Database Assignment: 1. Open Access and create a new table named family that would have the following information about you and four other family members, total of five people. The information does not have to be real, so make someone up if you need to. Field Names: First Name Last Name Age Hobby Fav Beverage Fav Food Fav TV Show Fav Music 2. When finished sort your table into descending, (Z-A) order by first name and save. 3. Create a Query using the wizard with one of the favorites as a topic. Select a simple query and title it, MY Query. When you have finished sort the Query A-Z. 4. Create a one page Report using the wizard titled My Report, include all of the info. Give the last name field priority. Choose outline, or stepped for style and landscape for orientation. 5. When finished attach the database to the assignment, Final Database Assignment, on edmodo and send it to me. Objective: SWBAT Create an original work as a means of expression Language Objective: SWBAT Use content vocabulary correctly Email Enigma presentations
Unless you or your partner were missing yesterday you will be expected to present your case today. Everyone that is finished will be a good audience and not talk while people are presenting. If we need to we can do presentations during lunch. Objective: SWBAT Create an original work as a means of expression Language Objective: SWBAT Use content vocabulary correctly Email Enigma- Work on your database and your report. Would like to start presentations Wednesday
Objective: SWBAT Create an original work as a means of expression Language Objective: SWBAT Use content vocabulary correctly The Case of the Email Enigma
Working with partners that I choose you will study this case in an effort to solve the murder of Vernon C Byte. Using the handout each group will create a database and a written paper that details the evidence that shows who they think the killer is. The project will also involve a class presentation. The group that does the best job of convincing me of who the killer was will win a treat. Read through the handout to discover clues and piece together your evidence. Before you begin the will be a Power Point presentation of the case. Objective: SWBAT Create an original work as a means of expression Language Objective: SWBAT Use content vocabulary correctly |