Lessons
- Using the list of companies you developed yesterday, you will setup an Excel spreadsheet where you will track the prices of each company daily.
- In addition to logging the new price per share, you will multiply the new price by the number of shares purchased in each company and calculate the percentage increase to date.
- After you check the stocks, you will complete a series of 9 self-paced Excel lessons, related to your stock spreadsheet.
- We must keep our stock spreadsheets synchronized- if you are absent or fall behind, it is very important we catch you up.
- To begin: Excel Spreadsheet Setup for the Stock Market Game
- Today you will choose 10 tech companies for our stock market game. We will track the share price of your companies for about 10 days.
- Use the CNN/Money website to choose 10 technology companies for our stock market game.
- In Word, list the 10 companies. Save this Word document as p#_username_companies in your P: drive. We will track the stock prices for these companies in Excel.
- Use proper MLA heading and page numbering.
- Complete Tuesday's lesson.
- Use the CNN/Money website to choose 10 technology companies for our stock market game. Click on the following categories on the CNN/Money site to see the companies.
- In Word, list the 10 companies. Save this Word document as p#_username_companies in your P: drive. We will track the stock prices for these companies in Excel.
Cable and Satellite
Chips
Computers Peripherals
Contract Manufacturers
Internet
Networking
Software
Storage
Tech Blue Chips
Telecommunications
Telecommunications Global
Wireless
- In Word, list the 10 companies. Save this Word document as p#_username_companies in your P: drive. We will track the stock prices for these companies in Excel.
Start Excel
Monday, March 27th
- Complete the MLA citation assignment below, if you have already done so.
- Technology News Scavenger Hunt: Use Google to answer the following questions in Word. Also copy the address of the page where you found the answer. You may copy and paste the questions, but not the answers. You must write the answers in your own words, or you will not receive full credit. Save the document as: p#_username_news in your P: drive. You may turn it in if you finish.
- When is Microsoft supposed to release the new Vista operating system?
- What is a carbon nanotube" molecule?
- How old will iPod maker Apple be this week?
- Download an image of the total solar eclipse that will occur this week and save it to your P: drive. Copy and paste it in your Word document.
- Who was the creator of the Alta Vista search engine?
- What is search engine optimization?
- Download an image taken by the Mars Reconnaissance Orbiter last week. Copy and paste it to your Word document.
- What did Fujio Masuoka invent?
Computer Questions: - 1GB=______bytes
- How is a worm different from a virus?
- What is IEEE 1394 also known as?
- Who is cedited for inventing the World Wide Web, and what is he doing now?
- What is SVGA?
- What is bandwidth, as it relates to data transmission?
- What was the base price for an IBM 5100 personal computer in 1975?
Friday, March 24th
Wrapping up the Word Unit:
- Hanging indent
- Headers and footers
- Automatic page numbers
- Turn in p#_username_lesson1 to the [Hand In] folder on the T: drive
- Work on p#_username_mla
Monday, March 20th
Complete lesson 1 from Friday. To turn in the assignment: In [My Computer], click the [Folders] button at the top. Locate your assignment on the right side of the screen and drag it to the [Hand In] on the left. The [Hand In] folder is located in the [Teacher on wssdshms (T:)] drive in the [Ms. Finn] folder.
Move on to the next lesson...
The next assignment is to write MLA citations in Word, as if you had to write a Bibliography or Works Cited page. MLA format requires indenting the 2nd, 3rd, and 4th lines of a citation 1/2 inch, YOU DO NOT HAVE TO INDENT- we will do that together when we've finished all of the citations. Just complete the necessary information for the citations in the proper order. In general, if information is missing, such as an author's name or publication date, you skip it and move on to the next piece of information that is available.
- Open a new blank Word document.
- Save this document as: p#_username_mla to your Computers folder in the P drive
- Go toOWL- The Online Writing Lab at Purdue University and scroll down a little more than half way to "Basic Forms for Electronic Sources".
- In another Window, open the following websites and write proper MLA citations for them in Word, as if you used them as sources for a research paper.
- http://lincoln.lib.niu.edu/biography1.html
- http://xroads.virginia.edu/%7EHYPER/wpa/wpahome.html
- http://americanhistory.si.edu/sports/exhibit/firsts/gibson/index.cfm
- http://news.nationalgeographic.com/news/2006/03/0315_060315_volcano.html
- http://water.usgs.gov/cgi-bin/dailyMainW?state=us&map_type=dryw&web_type=map
Today's Lesson
Thursday, March 16th
- Toolbars
- Setting tabs
- Image and text layout
Rotation 4
PowerPoint
Wednesday, March 8th
Copying and editing Excel Charts in Power Point.
Wrapping Up Excel
- Go over the Excel quizzes
- How to incorporate your independent Excel charts in PowerPoint
- Remaining time: complete the charts from your independent assignment and copy them into PowerPoint
Monday, March 6th
When you are asked to do so, please click on the link for the appropriate quiz. You are asked to write out the complete answer. You may use a blank Excel file for help.
- Quiz Part 1
- Quiz Part 2
- Complete your independent chart assignment from Friday.
- Remember: 2x Quiz Monday.
- Complete: the Chart Wizard assignment
- Check: Then you must complete the following spreadsheet formatting checklist:
- Do you have check dates in F1, H1, K1, N1, R1, U1, Y1 and AB1? (work backwords from yesterday if not).
- Do you have the word Total in E13, G13, J13, M13, Q13, T13, X13, and AA13 and bold?
- Are the appropriate columns formatted for currency($) and percentage(%)?
- Do you have a bottom border under row 12 from A12-AE12?
- Submit: Drag your spreadsheet project into my Hand In folder: Open [My Computer] and open your group folder. Click the [Folders] button at the top. Click the "+" signs next to the folders on the left until you see the [Hand In] folder in [Ms Finn]. Drag your Excel Stock file on the right, to my Hand In folder on the left.
- New: Individually, open a new blank Excel file. Save it to YOUR P: drive as p#_username_excel2. Collect data on a the appropriate topic of your choice from a reliable website. Ideas: sports statistics, tv ratings, surveys, weather, census data, etc. You must enter data into at least 10 cells (does not include labels). Organize the data in the spreadsheet. Create 2 charts from the data. Your charts must have at least 10 data points.
Common issues with charts:
- Choosing a chart type: which kind of chart do I need for what I am trying to show? Microsoft Chart Help
- Highlighting the correct data: which cells do I need to highlight to create my chart?
- Labeling: Are the titles, axes, and legend labeled with clear descriptions and units of measure?
- Your group must complete Lesson #8: Wrapping up the spreadsheet: this lesson includes stock check #7.
- Then you must complete the following spreadsheet formatting checklist:
- Do you have check dates in F1, H1, K1, N1, R1, U1, Y1 and AB1? (work backwords from yesterday if not).
- Do you have the word Total in D13, G13, J13, M13, Q13, T13, X13, and AA13 and bold?
- Are the appropriate columns formatted for currency($) and percentage(%)?
- Do you have a bottom border under row 12 from A12-AE12?
- Go back and work on Lesson 5-7, if needed.
- Finally, you may begin Chart Wizard.
- Your group must complete Lesson #8: Wrapping up the spreadsheet: this lesson includes stock check #7.
- Then you must complete the following spreadsheet formatting checklist:
- Do you have check dates in F1, H1, K1, N1, R1, U1, Y1 and AB1? (work backwords from yesterday if not).
- Do you have the word Total in D13, G13, J13, M13, Q13, T13, X13, and AA13 and bold?
- Are the appropriate columns formatted for currency($) and percentage(%)?
- Do you have a bottom border under row 12 from A12-AE12?
- Go back and work on Lesson 5-7, if needed.
- Complete the extra credit:
In a new, blank spreadsheet, set up a spreadsheet that utilizes either:
1.Your own if function (minimum of 3 arguments), or
2. Your own drop down menu (minimum of 10 choices in the drop down menu). - Finally, you may begin Chart Wizard.
- Your group must complete Lesson #8: Wrapping up the spreadsheet: this lesson includes stock check #7.
- Then you must complete the following spreadsheet formatting checklist:
- Do you have check dates in F1, H1, K1, N1, R1, U1, Y1 and AB1? (work backwords from yesterday if not).
- Do you have the word Total in D13, G13, J13, M13, Q13, T13, X13, and AA13 and bold?
- Are the appropriate columns formatted for currency($) and percentage(%)?
- Do you have a bottom border under row 12 from A12-AE12?
- Go back and work on Lesson 5-7, if needed.
- Complete the extra credit:
In a new, blank spreadsheet, set up a spreadsheet that utilizes either:
1.Your own if function (minimum of 3 arguments), or
2. Your own drop down menu (minimum of 10 choices in the drop down menu). - Finally, you may begin Chart Wizard.
Tuesday, February 28th
- Quiz Change: rather than taking a quiz this week, we will take two quizzes next Monday, March 6th.
Check out the practice quiz. - Lesson #8: Wrapping up the spreadsheet: this lesson includes stock check #7.
- Check your stocks:
- X- Stock Price
- Y- Check 6 (important: if you shifted column C to the left in Lesson 6, your cell references have changed for calculating check 5 and % change).
- Z- % Change
- Lesson #5: Drop Down Menus
- Lesson #6: CONCATENATE function
- Lesson #7: IF function
- In a new, blank spreadsheet, set up a spreadsheet that utilizes either:
1.Your own if function (minimum of 3 arguments), or
2. Your own drop down menu (minimum of 10 choices in the drop down menu).
- Check your stocks:
- S- Stock Price
- T- Check 5 (important: if you shifted column C to the left in Lesson 6, your cell references have changed for calculating check 5 and % change).
- U- % Change
- Lesson #5: Drop Down Menus
- Lesson #6: CONCATENATE function
- Lesson #7: IF function
- 8th Pd. only: in a new, blank spreadsheet, set up a spreadsheet that utilizes either:
1.Your own if function (minimum of 3 arguments), or
2. Your own drop down menu (minimum of 10 choices in the drop down menu).
- Check your stocks:
- P- Stock Price
- Q- Check 4 (P*D)
- R- % Change (Q-E)/E
- Lesson #3: Average Price to Date
- Lesson #4: Hyperlinks
- Lesson #5: Drop Down Menus
- Lesson #6: CONCATENATE function
- Lesson #7: IF function
- Check your stocks:
- L- Stock Price
- M- Check 3 (L*D)
- N- % Change (M-E)/E
- Lesson #2: AVERAGE, MIN, MAX, COUNT functions
- Lesson #3: Average Price to Date
- Lesson #4: Hyperlinks
- If you haven't already, check your stocks for the first time (F, G, H): Stock check #1.
- We are one stock check behind schedule, so repeat the previous lesson in I (stock price), J (Check 2), K (% Change). The stock prices in column I should only vary slightly from column F.
- Lesson #2: AVERAGE, MIN, MAX, COUNT functions.
- Complete yesterday's assignment: Excel Spreadsheet Setup .
- Check your stocks for the first time: Stock check #1.
- Remember to rotate recorders.
- Have a safe, enjoyable long weekend!
- Testing the new group folders in the T: drive
- Excel Spreadsheet Setup for the Stock Market Game
In your new groups, nominate a member to be the recorder. Save a new Word document to the recorder's P: folder as p#_username_companies. Start by making a proper MLA heading and page number (use all team member names). The title is "[Team Name] Stock Market Game Companies".
The recorder should list the 10 technology-based companies in which you will buy stock. We will use CNN/Money to track the stock prices. The recorder should list the group member names and the 10 companies in Word. Along with the company name, also list the company's sector (example: Cable) and symbol (example: Amazon=AMZN). You may visit the websites of unfamiliar companies to see what they do, or click on the "Snapshot" tab in CNN/Money to learn more. The recorder should save this document as p#_username_companies and drag it to the "Hand In" Folder in the T: drive.
Some things to think about:
- Use the graphs on each company profile. Do you see a trend in the stock price? In general, is it on its way up, or down?
- Does your group want to diversify is a broad range of sectors, or load up on one area that seems to be doing well?
- Keep in mind, this is a fun class assignment, not a reflection of how smart investors buy stocks.
In your new groups, one member should record the 10 technology-based companies in which you will buy stock. We will use CNN/Money to track the stock prices. The recorder should list the group member names and the 10 companies in Word. Along with the company name, also list the company's sector (example: Cable) and symbol (example: Amazon=AMZN). You may visit the websites of unfamiliar companies to see what they do, or click on the "Snapshot" tab in CNN/Money to learn more. The recorder should save this document as p#_username_companies and drag it to the "Hand In" Folder in the T: drive.
Some things to think about:
- Use the graphs on each companies profile. Do you see a trend in the stock price? In general, is it on its way up, or down?
- Does your group want to diversify is a broad range of sectors, or load up on one area that seems to be doing well?
- Keep in mind, this is a fun class assignment, not a reflection of how smart investors buy stocks.
Thursday, February 9th, 2006
- Word/MLA Quiz
- Final Word Wrap-up
Follow MLA Style to write citations for the following websites. You may use the PowerPoint presentations and the OWL Online Writing Lab page for help. Remember to indent 1/2 inch on the 2nd, 3rd and 4th lines by hitting the [Tab] key at the beginning of the line. The 1st line should all the way to the left.
- http://www.archives.gov/genealogy/about-research.html
We will begin the MS Word Unit.
Important Links:
Wednesday, January 6th- Wednesday, January 25th
Renewable Energy Web Design Project work. Here are the Instructions for putting a stripe in your background.
Friday, January 6th, 2006
Next Tuesday will have have the first of three HTML quizzes. Each will be 10 questions, multiple choice.
HTML: Posting images on your page; images as hyperlinks
Thursday, January 5th, 2006
The following lesson should be completed individually, at your own pace. You may help your immediate neighbors if you wish. Carefully read the instructions to complete today's assignment.
Wednesday, January 4th, 2006
HTML- Hexadecimal code, typeface, hyperlinks
Tuesday, January 3rd, 2006
Today we start HTML!
Thursday, December 22nd, 2005
Website Design Project Research
Research the topic that was assigned to your group Wednesday. Specifically, groups should be looking for:
- How your technology works (diagrams are particularly useful)
- Benefits of your renewable energy source
- Disadvantages of your renewable energy source
Monday, December 19th, 2005
Periods 2 and 3: Today you will begin research on the renewable energy web design project. Click here for today's lesson.
Thursday, December 15th, 2005
- Periods 2, 4, and 8, proceed with the instructions for the CD cover as we covered on Wednesday.
- Periods 3 and 7, please read the instructions for the CD Cover below:
Final Photoshop Elements Lesson:
Congratulations! As a successful graphic designer, you have been hired by a top record label to design a CD cover for a new release.
Create a CD cover for a jewel case. Start with [File] then [New]. The width= 9.5 inches and height= 4.75 inches. Mode= RGB Color. Background=White.
The right side of the rectangle is the front cover. The left side is the inside flap.
Include all of the elements you have learned so far, and the Text tool (the letter "T" on the tool bar). After clicking the "T" click the insertion point where you would like to start typing. Note the options bar for the Text tool at the top- font, size, color and direction. Suggestions:- CD title
- Song titles
- Artist images
Final Photoshop Elements Lesson:
Congratulations! As a successful graphic designer, you have been hired by a top record label to design a CD cover for a new release.
Create a CD cover for a jewel case. Start with [File] then [New]. The width= 9.5 inches and height= 4.75 inches. Mode= RGB Color. Background=White.
The right side of the rectangle is the front cover. The left side is the inside flap.
Include all of the elements you have learned so far, and the Text tool. Suggestions:
- CD title
- Song titles
- Artist images
Tuesday, December 13th, 2005
- Complete Photo Editing from yesterday. Remember, you need at least 2 new sky images for your original image.
- New for today:Filters- Please disregard the use of digital cameras for this lesson. Use Google Advanced Image Search and remember to turn "Use Strict Filtering" on.
- For Thursday: Photoshop/beginning HTML Quiz
- Today:On your own Photo Editing- Use Google Advanced Image Search and remember to turn "Use Strict Filtering" on.
We will continue with yesterday's lesson.
Wednesday, December 7th, 2005
- Make folders
- Review Photoshop
- On your own: Layers and Shapes Lesson
- 2. On your own Photo Editing- Use Google Advanced Image Search and remember to turn "Use Strict Filtering" on.
- Behavioral reminders
- Respect the learning community (includes Ms. Finn!).
- Respect the equipment.
- General overview
- Login procedures
- Making a "My Documents" folder on your local machine
- Adobe Photoshop Elements Introduction- Why Photoshop? Layers, Layers, Layers!
Second Rotation Lessons
Monday, December 5th, 2005
- Last Day! The Web Design Projects are amazing! Great job!
- When you are asked to do so, please click on the Quiz 4 link.
- Presentations
- Loose ends
When you are asked to do so, please click on the Quiz. This is the quiz that was postponed several times due to problems with Quizstar.
Monday, November 28th- Friday, December 2nd:
The web design project is due at the end of class on Friday, December 2nd.
The last day of this rotation is Monday, December 5th .
The Introduction, Benefits and Disadvantages pages should be complete by Tuesday, 11/29. Please stop in during homeroom, lunch, or after school if you need more time on these 3 pages. Concentrate on the Conclusion and Works Cited/Links pages this week. Remember, there is an essential question posted in the instructions for the Conclusion page. The conclusion is not a summary.
Monday, November 21st- Wednesday, November 23rd: Continue to work on your projects. Please refer to the project instructions on the left if you have questions.
Tuesday, November 15th, 2005- Friday, November 18th
- Project Work.
- In your agenda books for Thursday, 11/17: Quiz 3.
- Today: Setting up the template for your project
- Web design project instructions overview
Complete the research assignment with your group as we discussed yesterday. Remember that the group's recorder is the only student who should open the Word document. Use the Resources page in addition to Google Advanced Search.
Thursday, November 10th, 2005
- Return last quiz
- When you are asked to do so, click on the link for Quiz 2
- Project research. To focus your search, locate the answers to the following questions. One group member should serve as the recorder. The recorder will note the answers and sources. The other group members are searching for the answers and giving them to the recorder. You must find 3 sources for each question. Don't forget to look for diagrams and images too. Save images to your group's "Images" server folder.
Questions:- Explain how your renewable energy source works (scientific principals, diagrams, steps, procedures).
- What are the benefits of your renewable energy source?
- What are the disadvantages of your renewable energy source?
The quiz scheduled for Thursday, 11/3 is now scheduled for Monday, 11/7. It will cover HTML tables.
Friday, November 4th, 2005
- Complete Creating Background Stripe in PhotoShop.
- If you complete the stripe, practice HTML code in p#test6.htm.
- Periods 2, 3, 4: Trip to Hedgerow
- Period 7,8: Fixing the width of tables in HTML
- When you are asked to do so, please click on the Quiz 1
- Tables
- Due to technical problems with QuizStar, the today's quiz is postponed until Tuesday, 11/1.
- Monday-Wednesday: HTML
- Thursday: Quiz and PhotoShop Introduction
- Friday, 11/4 and Monday, 11/7: PhotoShop
7th and 8th Periods only:
Photoshop Lesson. On your own, complete at least two of the following choices. You may use Google Image Search to collect images for your assignments The instructions will tell you what kind of image you need to find, if any. When you find an image you would like to use, right click on it, choose "Save Picture As" and save it to your folder in "My Documents". You can then "Browse for File" or do a "File" then "Open" in Photoshop. Photoshop is the program on your desktop with the sunflower icon. Save all work to your folder in My Documents. If you were not here on Friday when we made folders, please as a neighbor to help you.
- Beginner (some of you did this last year)
- Intermediate- The lessons refer to a digital camera. Get a picture using Google image search instead and start on #3.
- Advanced
- If you finish these there are more at: Adobe Digital Kids Club
Friday, October 21st, 2005
Let's start HTML!- HTML- A very brief history
- The tools
- Simple text formatting
- Saving and viewing your page
First Rotation
Wednesday, October 12th, 2005:
- Important Reminders:
- The project is due Monday, October 17th. I am here during homeroom and after school.
- Quiz: Tuesday, October 18th. Hyperlinked parenthetical citations, image files, and all HTML code
- Please do not underestimate the importance of proper citation. Please take a packet from my desk if you need help with parentheticals.
- Review the project instructions.
- Turn in the signed interim form
- Project work- start to focus on the hyperlinked parenthetical citations
- Don't forget about the quiz Thursday. Home sick? If it is ok with your parents or guardian, you may take it from home during class time. If you can't take it from home, you can make it up Friday.
- Page layout and images.
- With your group: complete the PhotoShop Background Stripe Lesson.
- Project work.
- Quiz
- "Content of your page" placeholder explained.
Quiz Star account setup.
Tuesday, September 27th, 2005:
- Complete page creation
- Tables explained
- Server folders explained
- Add titles to each page
- Group organization: who is doing what?
- The project template instructions.
- Stop when you get to number 6.
- Choosing colors: VisiBone Hexadecimal Color Chart.
- Note change: the pros and cons pages will be written in paragraph format, not bullets as previously stated. Projects should have a minimum of 3 paragraphs on the pros page and 2 paragraphs on the cons page.
- Continue working on project
- Return to PhotoShop!