Party Planner Quests
This Party Planner activity focuses on the use of spreadsheets, and starts with the basics assuming you know nothing about a spreadsheet, and will introduce you to more advanced features as you complete the party planning activity. Your teacher may choose Microsoft Excel, Google Sheets, Office 365, or another similar spreadsheet program.
A spreadsheet is a tool that helps you manage data (enter, track, order, graph, chart, plan parties, budget your money, and much more).
What is a Spreadsheet?
If you went to the links you may have noticed that a program called Excel was mentioned. Microsoft Excel is a program that is used to create spreadsheets. Google sheets, Office 365, and other spreadsheet applications have many similar features, so once you learn one, you will be able to use the others.
Special Note to Students: If you don't have access to Google Spreadsheets or Microsoft Office you can do these Quest activities using an application such as: Calc in OpenOffice, iWork (Mac Suite), Free Spreadsheet or Numbers (iPad). The process is very similar across all of the applications.
Quest 1 The Party Planning Begins!
Imagine that you are going to have a celebration and you will be inviting people to your party. You could use a spreadsheet to keep track of who you invited and how many people are coming. The spreadsheet will do the calculations for you and help you to stay organized. You will learn how to name a document and enter data, learn the difference between a cell, row, and column.
Quest 2 Format, Insert & Merge
Learn how to format your spreadsheet: add a border, highlight cells, change alignment, wrap text, resize a cell, and format numbers
Learn How to Insert a Row or Column & Merge Cells
Quest 3 Formulas
Learn to make the spreadsheet calculate numbers for you!
Quest 4 Make it Visual
Learn how to create a great looking chart from your information.
Quest 5 Share It
Learn how to share your spreadsheet with a friend, your teacher, invitees...
Check off these Quests on the 21t4s roadmap
ISTE and Common Core Standards
1. Empowered Learner
b. Build networks and customize their learning environments in ways that support the learning process
d. Understand the fundamental concepts of technology operations, demonstrate the ability to choose, use and troubleshoot current technologies, are able to transfer their knowledge to explore emerging technologies
2. Digital Citizen
a. Cultivate and manage their digital identity and reputation and are aware of the pemanence of their actions in the digital world
c. Demonstrate an understanding of and respect for the rights and obligations of using and sharing intellectual property
6. Creative Communicator
c. communicate complex ideas clearly and effectively by creating or using a variety of digital objects such as visualization, models or simulations
d. Publish or present content that customizes the message and medium for a variety of audiences
Common Core Standards
CCSS.ELA-Literacy.CCRA.L.1 Demonstrate command of the conventions of standard English grammar and usage when writing or speaking.
CCSS.ELA-Literacy.CCRA.L.2 Demonstrate command of the conventions of standard English capitalization, punctuation, and spelling when writing.
CCSS.ELA-Literacy.CCRA.W.4 Produce clear and coherent writing in which the development, organization, and style are appropriate to task, purpose, and audience.