Introduction
Excel Online Christmas
Shopping Project
Hello shoppers! It's that time again! It's Christmas time and your parents gave you only $300.00 to shop with! You can only spend that much money without going over.
(click on task)
Task
Here is what you have to do......
Follow these steps very carefully. If you have a question after you have read through the steps you can ask me by sending me your questions at tisha.faulkner3@gmail.com
Step 1: Sign into www.google.com
Step 2: Open a new Google Sheet
Step 3: Sheet 1, In C1 type EXCEL CHRISTMAs SHOPPING PROJECT
- In A3 to A5 type the names of the group members.
Step 4: Change the color of title to red.
Step 5: In Sheet 2, The Title is Walmart.com. Type this in C1 and change the color to Blue and make the font size 47.
Step 6: Open a new tab in your browser, type www.walmart.com and shop for toys of your choice. In A6 type TOYS and change the color to pink. IN A7 - A12 type the toys that you chose in Walmart.
In B6 type the prices of each item. If you need help let me know.
Step 7: In sheet 3 follow the directions as you did in step two when shopping in www.amazon.com.
Step 8: In Sheet 4 follow the directions as you did in steps one and when shopping in toys are us. Go to www.toysrus.com
Step 9: In Sheet 2 tab type your name.
In Sheet 3 tab type your name.
In Sheet 4 tab type your name.
(click on process)
Process
What you need to do is type your names, teacher's name, grade, date, and school in sheet one.
The leader will shop in Walmart.com
THe second person will shop in Amazon.com
THe THird person will shop in Toys R Us.com
When the group is done click share and then type my email address in the share box like I have shown you before.
My email address is tisha.faulkner3@gmail.com
This assignment is due by December 4th, 2015
(Click on Evaluation to see how this project will be graded)
Evaluation
| Graphing : Excel Christmas Shopping Project | ||||
| Teacher Name: Mrs. Grant | ||||
| Student Name: ________________________________________ | ||||
| CATEGORY | 10 | 8 | 6 | 0 |
| Neatness and Attractiveness | Exceptionally well designed, neat, and attractive. Colors that go well together are used to make the graph more readable. A ruler and graph paper (or graphing computer program) are used. | Neat and relatively attractive. A ruler and graph paper (or graphing computer program) are used to make the graph more readable. | Lines are neatly drawn but the graph appears quite plain. | Appears messy and \\"thrown together\\" in a hurry. Lines are visibly crooked. |
| Data Table | Data in the table is well organized, accurate, and easy to read. | Data in the table is organized, accurate, and easy to read. | Data in the table is accurate and easy to read. | Data in the table is not accurate and/or cannot be read. |
| Title | Title is creative and clearly relates to the problem being graphed (includes dependent and independent variable). It is printed at the top of the graph. | Title clearly relates to the problem being graphed (includes dependent and independent variable) and is printed at the top of the graph. | A title is present at the top of the graph. | A title is not present. |
| Names are typed on Sheets | Names are typed on the sheet tabs. | _ | _ | Name are not typed on the sheet tabs. |
| Heading is present | Heading is present and neatly typed on sheet 1. | Heading is present and somewhat neat on sheet 1. | Heading is present but solppy. | Heading is not present. |
| Use Pie Graph | Graph fits the data well and makes it easy to interpret. | Graph is adequate and does not distort the data, but interpretation of the data is somewhat difficult. | Graph distorts the data somewhat and interpretation of the data is somewhat difficult. | Graph seriously distorts the data making interpretation almost impossible. |
| Date Created: November 20, 2015 | ||||
Conclusion
I hope that this was an enjoyable learning experience for you. I hope that you will take what you have learned from this assignment into your real life experience.
Mrs. Grant :)
