SGS Computer Literacy TeacherWeb Update Prescott's Café

UPDATE: \| Keyboarding Games \| Graphics Links \| I Love Math! \| Prescott's Café \| Nvu Resources \| I Love Science! \| I Love History! \| Roller Coaster Physics \| Garage Band Resources \| Virtual Field Trips \| I Love Art! \| Internet Basics \| HTML Tutorials \| Web Design Links \| Internet Hunts \| MS Office Tutorials \| DTP Sites \| About Mrs. Prescott \| UpdateIndex \| Help

VIEW: Home \| Keyboarding Games \| Graphics Links \| I Love Math! \| Prescott's Café \| Nvu Resources \| I Love Science! \| I Love History! \| Roller Coaster Physics \| Garage Band Resources \| Virtual Field Trips \| I Love Art! \| Internet Basics \| HTML Tutorials \| Web Design Links \| Internet Hunts \| MS Office Tutorials \| DTP Sites \| About Mrs. Prescott

Update Prescott's Café If you have previously made changes to this page, in this Internet session, you may have to click on your Reload/Refresh button to see those changes reflected below and to preserve those changes as you make new changes.
small medium large http://www.esu7.org/~sgsweb/cafe.html You are the café manager in this online game. It is your goal to successfully run Prescott’s Café during class Monday through Thursday. You will also need to design TWO advertisements, one warm weather poster to help sell your lemonade, and one to promote your hot chocolate. Be creative! Turn in your journal, posters, and completed spreadsheet at the end of the week. 1) First, create a spreadsheet to keep track of your business and progress for the week. Open a new spreadsheet in MS Excel (bright green X icon in your dock). 2) Go to File --> Page Setup and choose landscape orientation so your spreadsheet will print out horizontally. 3) Click the gray box located above Row 1 and left of Column A to highlight your spreadsheet. 4) Go to Format --> Cells --> Border and choose Outline and Inside (this will give you dark lines around each cell) 5) Click the Number tab --> Currency 6) Type $100.00 in Cell A2. This shows the amount of your starting funds. 7) Now, starting with Day 1, set up your spreadsheet to show the following for the days you run the business. Widen your columns as needed so your titles show completely. Cell A1: Starting Funds Cell A3: Day 1 Cell B1: Café Cell B2: Rent Cell C1: Hot Chocolate Cell C2: Bought Cell D1: Hot Chocolate Cell D2: Sold Cell E1: Lemonade Cell E2: Bought Cell F1: Lemonade Cell F2: Sold Cell G1: Advertising Cell G2: Costs Cell H1: Total Daily Cell H2: Expenses Cell I1: Total Daily Cell I2: Income Cell J1: Overall Cell J2: Loss Cell K1: Daily Ending Cell K2: Balance 8) Highlight Cells A1 to K2, and go to Edit --> Copy. 9) Click in Cell A5 and choose Edit --> Paste. 10) In Cell A7, type Day 2. Repeat the above steps for each of the days you play Prescott’s Café. Be sure to consult the weather forecasts! At the end of each “day”, use the “Financial Report” to enter the data. Your “Daily Ending Balance” is the amount left at the end of the day in the “Retire with $___” box. To get your Starting Funds for Day 2, type the amount in the “Daily Ending Balance” cell for Day 1.
Password:	Forgot your password?

SGS Computer Literacy

Update Prescott's Café

© 2000-2008 TeacherWeb.com