7th Gr. Assignment #8

Learning Goals:

Learn how to use a spreadsheet, document and web page AT THE SAME TIME.

 Learn to run a business by trial and error on a simulation (two parts):

a.) running the business effectively

b.)Improving business/make more money

Directions:

1. Download the spreadsheet here. Save it, open it, minimize it and have it ready.Spreadsheet click here.

2. Download the guide here. Save it, open it, minimize it and have it ready.

3.Read this AND the next direction before going to the website. Then, go to the website for the coffee shop game by clicking on the link. CAREFULLY READ THE TUTORIAL AS THE GAME STARTS DO NOT SKIP IT. Coffee Shop Website click here.

4. Everytime you buy supplies STOP AND GO TO THE SPREADSHEET TO ENTER HOW MANY SUPPLIES YOU BOUGHT

YOU HAVE TO INPUT A FEW AREAS OF DATA BEFORE AND AFTER EACH DAY.

Download the first reflection document here.

8th Gr. Assignment #8

Learning Goals:

*Re-learn the four steps of making a math formula on a spreadsheet.

*Transfer a specific skill taught to a similar but different situation.

Directions:

THIS WILL BE GRADED AS A PERFORMANCE TEST

To view the grading rubric click here

1. Overview: I am giving you a guide you have used in the past and want you to do your best to apply what is shown to a DIFFERENT  spreadsheet. The skills asked for are EXACTLY THE SAME.

2. Download the spreadsheet from the link given here, open it, minimize it, and have it ready. Spreadsheet site click here.

3. Download the guide here open it, minimize it and have it ready.

4. Use the guide to put math formulas in the spreadsheet that MULTIPLY the sales to get the amount of money made, then make a math formula to ADD the columns that show how much money was made into a daily total.

THINK: How will you go back and forth from the guide to the spreadsheet? Use the window list to go back and forth between the guide and spreadsheet.

5.When you are done with all the spreadsheet math download the worksheet here and answer the questions:

Make sure you show your work to Mr. Litt when you are done.

7th and 8th Assignment #7

We are still training you, our students, in a business simulation on PREDICTING TRENDS

1.Download the spreadsheet from this site, Its called “Rainbow Lollipop_2nd_practice.xls”. Spreadsheet download site click here.

I am giving you a guide already printed. Here is the digital version of it. DO NOT DOWNLOAD IT, DO NOT PRINT IT. Click here for guide if needed.

Download the worksheet and and have it ready. Worksheet click here..

2. The skills you are practicing are:

-making averages

-copying and pasting formulas

-copying and pasting numbers only

-making graphs

-interpreting graphs for trends

3. First, go to the spreadsheet and do the work needed there. Put in all the average formulas on sheet1, sheet2, and sheet 3. Then put the data onto sheet 4 and make a graph.

4. Do the worksheet when you are done with the spreadsheet practice.

5. When you are done, print the worksheet only and show the spreadsheet to  Mr. Litt.

7th and 8th Gr. Assignment #6

Learning Goals:

*How to use a spreadsheet functions wizard.

*Use a spreadsheet to organize information to predict a trend.

Directions:

We are expanding our business simulations in spreadsheets to something new: PREDICTING TRENDS.

1.Listen to the podcast it explains much. the worksheet is going to have questions from the podcast. This podcast has some pops and cracks, I’m sorry, so be careful with the volume. The podcasy is called Lollipop Company Averages and Trends Podcast click here

2.Make sure you have a the lollipop spreadsheet, worksheet and guide, a total of three things labeled a, b and c here:

a.)Download the spreadsheet from this site, Its called “Rainbow Lollipop.xls”. Spreadsheet download site click here.

b.)I am giving you a guide already printed. Here is the digital version of it for the future and emergencies. Please do not download it. Spreadsheet math guide click here, Spreadsheet graphing guide click here

c.)Download the worksheet by clicking here.

3. Find the averages for each of the six columns at the bottom of each column in the box marked averages.

4. Do the same for sheet 2 and sheet 3 on the same spreadsheet. Remember the tab on the bottom left corner lets you switch between sheets.

5. Answer the questions on the worksheet, show your spreadsheet and worksheet to Mr. Litt to check off.

7th and 8th Grade Assignment #5

Learning Goals:

*Complete a worksheet from a website on the same computer. Move back and forth between programs by using your window list.

*Become aware of types of cyberbullies.

Directions:

1. Download the worksheet by clicking here. Save it to the computer, open it, then minimize it so it is ready.

2.You will need to click on different links below to answer different questions on the worksheet.

To answer question #1 on the worksheet click here.

To answer  question #2 click here

To answer question #3, 4, 5 and 6 click here.

To answer question #7 click here.

3, Do not print the worksheet today. Show it to Mr. Litt for check off.