Excel Birthday Party Assignment

ASSIGNMENT: Your grandmother gave you $30 to buy supplies for your birthday party. Using an Excel spreadsheet you will need to stay within your budget.

Excel - Lesson #1 - Learn how to set up Excel to make it easier to use
Excel - Lesson #2 - Using Formulas **SINGLE CLICK ON THE VIDEO TO PAUSE IT. DOUBLE CLICK TO RESTART**
Excel - Lesson #3 - Formatting cells
Excel - Lesson #4 - Printing to one page

Excel Amount of Daylight Assignment

ASSIGNMENT: Using the longitude and latitude for your city, you will calculate the sunrise and sunset for your city. You will then enter that data into your Excel spreadsheet and then calculate the amount of daylight and the average annual amount of daylight using Excel formulas. Once you have completed your calculations, you will use your results to create a chart in Microsoft Excel. In order to compare as a class the amount of daylight cities have around the world over a one year period, you will need to enter your results into a master Excel document which is located at the front of the room.

Daylight Assessment - This is how I will grade this project
Excel Assignment Directions PDF - Click to see a copy of the directions for the Microsoft Excel assignment

Atlas Query This database server is a reference source for private use by astrologers, to find longitude, latitude and time zone information.
Sun or Moon Rise Table The U.S. Naval Observatory created this page to provide a way for you to obtain a table of the times of sunrise/sunset, moonrise/moonset, or the beginning and end of twilight, for one year. Try this link if the first one doesn't work.

Excel - Daylight Lesson #1 - Important tips to keep in mind that will make your assignment a lot easier.
Excel - Daylight Lesson #2 - Find the longitude and latitude for your city and your city's time relative to Greenwich Mean Time.
Excel - Daylight Lesson #3 - Calculate the sunrise and sunset for your city. Enter that data into your Excel spreadsheet.
Excel - Daylight Lesson #4 - Calculate the amount of daylight and the average annual amount of daylight using an Excel formula. Create a chart with the data.
Excel - Daylight Lesson #5 - Print your project on one page twice - once with formulas and once without.

ASSIGNMENT: Create two web pages using Macromedia Dreamweaver. You may choose any topic as long as it is appropriate. Your goal is to become familiar with some of the many techniques used on web pages today. Click on the link "web page assessment" to familiarize yourself with this assignment's requirements.

Access your web page– this only works if you are inside Floyd Dryden

Web Page Assessment - click here if you want to know how I am going to grade your project.

Student Examples - click here to see examples of a finished product

Estimated time to complete assignment: 15 days.

SETTING UP YOUR WEB SITE

You need to follow the below steps FIRST before you start entering text into your web site.

Video #1 - Moving Your Templates - You first need to move the two templates and css file from Degener's folder to your sites folder.

Video #2 - Setting Up Dreamweaver - This will show you how to set up Dreamweaver to save to your Sites folder.

Video #3 - Changing your template to index.html

Video #4 -Renaming your template - **Remember, everytime you open up your page in Dreamweaver, always open index.html. You should never have to open 8th grade template page 1 (now renamed junk.html) again.

Video #5 - Viewing changes made on your web page. - After you make a change, how do you view that on Safari or Firefox?

Video #6 - Bookmarking your site - Only available in Firefox.

Video #7 - Adding a title to your site.

 

EDITING YOUR WEB SITE

Now that you have set up your web site, enter in all of your text into page 1 of your web page. Remember, page 1 should have been renamed index.html. Make sure to type in your favorite links into your NavBar. Two important things to keep in mind. 1. Do NOT format your text yet. 2. Do NOT type in anything in page 2 yet.

MAKING LINKS

After you've entered in all of your text, then build links in your NavBar.

Making a link from index.html to page 2 - Remember, only add links to your NavBar on page 1. Do not do anything yet to page 2.

Making a link from your page to an outside web page

Changing the color of your link

ADDING AND MOVING PICTURES

Adding a picture from the web to your web page

Positioning your picture in your web page - Remember, only add links to your NavBar on page 1. Do not do anything yet to page 2.

Linking your picture to the same picture - only bigger and in its OWN window

Linking a picture of your friend to their website

CSS

Formatting your page using CSS

Changing a small section of your page using CSS

Now that you know some basics in Dreamweaver, it is time to start your second page. The first step you need to complete is to do copy your NavBar from page one to page. Then once you've copied your NavBar then type in all of your necessary text into page two.

Copying your NavBar from page 1 to page 2

FLASH

Take your completed Flash movie, export it and convert it to a SWF file (this compresses your Flash movie for the web). Now move your Flash project into your sites folder and build a link to it off of your web page. See movie below for directions.

How to place your Flash project on your web page

FIREWORKS

Making your own background using Fireworks

Optimizing your page to load faster

 

PART B: BELLS AND WHISTLES

Remember - do not start Part B until Part A is completed - see web page assessment for details!

BEFORE you begin adding bells and whistles to your website you need to check to make sure you have all of the basics done.

DREAMWEAVER ASSIGNMENT - CHECKLIST

Remember, you need to choose at least four of the below listed bells and whistles.

GARAGE BAND

Go to the Garage Band section of this web page to learn how to make a song. Make a 45 second song, export it and then move the condensed song into your sites folder.

**A CHANGE: In Garage Band you now need to go to SHARE, SEND SONG TO ITUNES in order to move your song from Garage Band to iTunes.**

Exporting and linking your completed GarageBand song to your web page

Embedding Audio - have your GarageBand song continously play as soon as you open your web page

SNAP PRO Z

Create a movie using the program Snap Pro Z and build a link to it off of your web page. It should explain to the user how to do something that is related to your topic.

How to use Snap Pro Z

BUTTONS

How make a button on your web page

IMAGE ROLL OVER

How to make an image roll over on your web page

ANIMATED GIF

How to make an animated gif for your web page

COUNTER

How to make a counter for your web page

POP UP MENU

How to make a Pop Up Menu

FAVORITE ICON - only works in Firefox right now.

Learn how to make a favicon - That's the little icon/picture that shows up next to the URL (web address)

FavIcon creation site - Make your favicon on this site

POPUP MESSAGE

How to add a popup message to your web page

ANIMOTO

Create a cool slide show and add it to your web page.

Step 1: What is Animoto??

Step 2: Uploading your pictures.

Step 3: Adding music.

Step 4: Adding your finished slide show to your web page.

WORDL

Create a cool "word cloud" for your web page.

COMIC STRIP

How to make a comic strip for your web page.

BLABBERIZE

How to make an animal/person talk.

 

 

ASSIGNMENT: Using a block of balsa wood, design, cut and paint the fastest car. Your car must meet all race requirements.

 

Estimated time to complete assignment: 10 days

 

Spring 2011 Dragsters

Fall 2010 Dragsters

Spring 2010 Dragsters

Fall 2009 Dragsters

Fall 2009 Dragsters *MOVIE*

Spring 2009 Dragsters

Fall 2008 Dragsters

Spring 2008 Dragsters

Fall 2007 Dragsters

Spring 2007 Dragsters

Fall 2006 Dragsters

C02 Dragster Information and Examples

The-Blueprints.com - ***This is an awesome site with side, top, and front views of almost any car you can think of. They have over 12,000 cars in their database.

Race Requirements - If you want to compete for fastest car, you MUST follow these guidelines.

WorldBook Encyclopedia - this is only accessible with computers at school because you need a login and password.

Dragster Self-Assessment - grade yourself

ASSIGNMENT: Create a 1.5 minute song using GarageBand. Electronically drop off the completed song.

 

Estimated time to complete assignment: 4 days

 

GarageBand Assessment

Getting Started with Garageband - Just the basics for the beginner

Digitally altering your sound loops

How to find more sounds for your song

Adding your voice to your GarageBand song.

Turning in your song - WHITE eMacs

Turning in your song - SILVER iMacs

Don't have USERS on your DOCK to TURN IN your file? Click here to turn it in after you've renamed your file.

Burning your song to a CD

Interested in submitting your song in a statewide contest?

 

Day #1 - You will be working on the silver iMac computers for this assignment. Get your birthday and lunch information from Mr. Degener. Then watch videos #1 and #2 and play along using your birthday information.

Day #2 - Watch and play along with videos #3, #4, #5. Again, use the birthday slide you started on day #1.

Day #3 - Watch and play along with video #6. This includes submitting your project. Then begin on the lunch slide.

Day #4 - Finish the lunch slide and submit it to the drop box. If you have time you may consider watching the video "Adding Images" for an even cooler slide.

LiveType scoring Guide - Each LiveType is worth 30 points.

WARNING - I speak very quickly in these videos because there is alot of cool stuff to show you. Pay attention!!!

Step #1 - Entering text

Step #2 - Formatting text

Step #3 - In & out special effects for text

Step #4 - Adding backgrounds and special effects objects

Step #5 - Setting the timing ***YOU MUST ADJUST TIMING BEFORE YOU SUBMIT YOUR PROJECT***

Step #6 - Saving project and submitting your project

Advanced Stuff - Adding Images - How to add images to your project

Advanced Stuff - Working with Mattes - Adding textures to mattes to make a groovy look

ASSIGNMENT: Pick an upcoming event at Floyd Dryden. Prepare for the event (who are you going to interview during the event, what questions are you going to ask him/her). Video tape the event and interview its participants. Edit your footage and then turn in your finished imovie electronically.

Every group will be required to take a video basics quiz to ensure that everyone is familiar with camera/tripod/personal safety, basic tips to follow when shooting video, basic camera shots, lighting tips and classroom checkout producedures.

Before you start filming, make sure you've completed your NEWS SHOW handout and that you've looked at your iMovie assessment.

Estimated time to complete assignment: 12 days: 2 days to brainstorm and complete your NEWS SHOW handout. 4-5 days to film 4-5 days to edit your project.

When you are done with your project you will electronically drop it off. Then we will watch all the movies and your group will receive PEER FEEDBACK. Your peers will comment on the storyline, camera angles, transitions, sounds effects, etc. Your group will then read the feedback, have 2 more days to do some final editing and then submit your final project.

Step 1: Look at examples of completed iMovies and talk to your partners about what seems interesting.

Step 2: Print this handout begin filling it out. You will need to fill it out completely before your can go to step 3. Once you've filled out the handout, give it to your teacher to look over.

Step 3: Under video basics, read or watch the videos on the following topics: camera/tripod/personal safety, basic tips to follow while shooting video, camera shots, framing your subject correctly and lighting. Then take the online quiz. Once everyone in your group has passed the quiz, you are ready to check out a camera and start filming.

Step 4: Does your movie involve something dangerous like downhill skiing or skateboarding? Then EACH member of your group needs to sign this form.

Step 5: Review the FDTV news assessment (requirements for your assignment) BEFORE you start filming.

Step 6: Film your movie. Make sure to take your handout from step 2 when you film your movie (don't forget to actually look at the handout!).

Step 7: Load the movie onto a computer. Once you are done filming, you will need to load the video onto a computer. Need help with iMovie? Watch the below video:

Moving your video from your video camera to iMovie

Please keep in mind two VERY important things when doing this.

#1 ONLY import your movie to a computer that has the words "CD-R" or "DVD-R" written on the outside of it in black permanent marker.

#2 When loading your movie, if you start to run low on MEMORY on your computer, tell your teacher IMMEDIATELY otherwise you may LOSE your project. How do you know if you are running low? The numbers in the bottom right hand corner of the iMovie screen will start to turn yellow, then red. As soon as you see the numbers turn yellow, please ask for help.

Step 8: Edit your movie using iMovie. Don't forget you are welcome to add sounds or music from GarageBand. Need help editing? Check out these instructional videos:

Adding media to your movie

Splitting video in iMovie

Editing your iMovie

Emphasizing an action using iMovie

Turning your finished iMovie into a Quicktime movie

 

Step 9: POSTING YOUR MOVIE ON DRYDEN'S MORNING NEWS SHOW: Open up your finished iMovie, go to SHARE, Quicktime, Full Quality. Then drop off your Quicktime movie in the degeners drop off box.

 

ASSIGNMENT: Using no more than 4800 mm of balsa wood, you are going to construct and then crush a 3 or 4 sided tower. Two awards are given out for this project - one for the tower that tolerates the most compression before breaking (most weight) and one for the tower that has the highest efficiency. You will learn about compression, tension and how different shapes have different structural strengths. Remember, by building something small you can learn a lot about the big structure.

Tower Self-Assessment - Grade yourself... Click HERE to take the self-assessment if you are in 3rd period. Click HERE to take the self-assessment if you are in 4th period. Then scroll down to the bottom of the page.

PBS Towers Site - has lot of great information about towers.

PBS Forces Lab

PBS Shapes Lab

EXAMPLES of Student Towers breaking

Check out this bad glue job - pic1 and pic2

 

 

Access your web page

 

See an example of what you will make

Student Work

Web page assessment - how I am going to grade your webpage.

 

SETTING UP YOUR WEB SITE

You need to follow the below steps FIRST before you start entering text into your web site.

Video #1 - Moving Your Templates - You first need to move the two templates and css file from Degener's folder to your sites folder.

Video #2 - Setting Up Dreamweaver - This video will show you how to set up Dreamweaver so you will save your files to your sites folder.

Video #3 - Changing your template to index.html **Remember, everytime you open up your page in Dreamweaver, always open index.html. You should never have to open 8th grade template page 1 (now renamed junk.html) again.

Video #4 - Viewing changes made on your web page.

Video #5 - Bookmarking your site - Only available in Firefox

EDITING YOUR WEB SITE

Now that you have set up your web site, enter in all of your text into page 1 of your web page. Remember, page 1 should have been renamed index.html. Make sure to type in your favorite links into your NavBar. Two important things to keep in mind. 1. Do NOT format your text yet. 2. Do NOT type in anything in page 2 yet.

MAKING LINKS

After you've entered in all of your text, then build links in your NavBar.

Adding links to outside websites

Adding links to items/pages inside your site

Changing the color of your link

ADDING YOUR SCHOOL WORK TO YOUR WEB SITE

Adding your GarageBand tune

Adding your LiveType - You only have to add one of your LiveTypes. Pick which ever one you want. This video will show you how to convert the video into the correct format. To actaully add the video to your site do it the same way you are adding your tower video.

Adding your PowerPoint

Adding your Tower Video and Pictures - **Note - even though the video asks you to grab your tower video AND tower picture - you only need to grab your tower video. You do not have a tower picture to grab. INSTEAD, make sure to grab your DRAGSTER photo.

Linking a thumbnail to a larger picture - Do this with your DRAGSTER photo instead of your TOWER photo.

FINAL TOUCHES TO YOUR WEB PAGE

How to Make a Shortcut to SAVE ALL

Formatting your page using CSS

Positioning pictures in your site

Making backgrounds with Fireworks - this one can be tricky, but give it a try because it is alot of fun!!!

Adding thumbnail links to friend's websites - make a link to your friends site

Copying the NavBar from page one to page two

Adding a title to your web page

JUST FOR FUN - NOT PART OF YOUR FINAL GRADE

Making an animation using Fireworks - ONLY do this if you are done with every the required part of the assignment first!

***THE LAST STEP - OPTIMIZATION***

Optimize your site to load faster

WordPress Assessment - Click to see how I am grading you

 

IMPORTANT LINKS

AKSchools.net - Access your blog

Letter to Parents (pdf) - This is the letter that was sent home before the unit regarding email addressed.

Tech Blog - Access Mr. Degener's blog

Access AKSchools Email Account - Use this link to access your AKSchools email address (if you have one)

 

EARLY STUFF - THIS IS DONE BEFORE WE START ON THE WEB PAGE

Get an email address if you don't already have one (video: LAN | www) - Signup for SERRC email address

Select a theme for your site (video: LAN | www). Go to Wordpress Themes which has almost 1200 free themes to choose from.

 

TUTORIALS ABOUT IMAGES

Getting images for Wordpress (video: LAN | www) - This will show you how to get your dragster image and how to get images from the web

Uploading and editting images for Wordpress (video: LAN | www)

 

FOLLOW THESE STEPS

Step #1 - Create a Serrc Account / WordPress account (video: LAN | www) on AKSchools.net

Step #2 - Activate Serrc Account (video: LAN | www) on AKSchools.net

Step #3 - Make your first greeting post (video: LAN | www)

Step #4 - Activate and modify your theme (video: LAN | www)

Step #5 - Modify your WordPress widgets (video: LAN | www)

Step #6 - Modify WordPress settings (video: LAN | www)

Step #7 - Add a "Links" category and add a few links to otside sites (video: LAN | www)

Step #8 - Add a page about your dragster (video: LAN | www)

To get your dragster picture go to: 7th grade tech page, dragsters, spring 2011 dragsters, find your pictures, drag it to your desktop.

Step #9 - Add a Tower page. Make a link to your tower video and state on your page how much it held.

Where to find your tower video: 7th grade tech page, towers, examples of student towers breaking, spring 2011, your name.

Step #10 - Add links to three friends WordPress sites (video: LAN | www)

Step #11 - Make comments on other students WordPress sites (video: LAN* | www*)

 

Inspiration is a program designed to help you plan and organize projects or papers. We are going to use Inspiration to organize our non-sequential PowerPoint assignment. To begin this assignment, watch the video entitled, Inspiration Part A.

 

Inspiration Part A - When you've completed part A please print it out on ONE page and then hand it to the teacher for approval.

Part A - Example

Inspiration Part B - When you've finished following the directions in the Inspiration Part B movie, please do ONE MORE THING. You need to number each point in your Inspiration Project. Click on Part B - Example so see how your Inspiration Part B should be numbered. When done numbering, please print it out on ONE page and then hand it to the teacher for approval.

Part B - Example

*

What does it mean to pick an APPROPRIATE topic?

 

PowerPoint Assessment

PowerPoint Fishing Example

PowerPoint Assignment Directions PDF - Click to see a copy of the directions for the Microsoft PowerPoint assignment

Examples of student work - found on their web pages

 

Video #1 - Getting Started - Using your Inspiration project to begin your PowerPoint project.

Adding Clipart and Animations - Learn how to add clipart and animations to your PowerPoint or Word document

Adding Pictures from the Internet - Click, drag and drop!!!! 

Using Pictures as the Background - This will show you how to get a picture or clipart behind the text or another picture

Taking a Screen Shot - Do you want to add a picture of a web page or other document? You can take a shot of your computer screen and add that to your PowerPoint or Word document. APPLE - SHIFT - 4

Making Buttons - This will show you how to make, format, and copy buttons for your PowerPoint

Linking Buttons - Buttons only work if they are linked to a slide. Learn how...

Transitions - Add cool effects when going from one slide to the next 

How to electronically drop off your Powerpoint project  

7th Grade Classroom Policies and Syllabus

Technology Store Price List

Typing - How to calculate your grade

Typing - How to purchase All The Right Type

SafeKids.comis a website where you’ll find tips, advice and suggestions to make your family’s online experience fun, productive and safe.