Level 1
1A: Spreadsheets irl |
1B: The Basics |
1C: Cells & More Formatting |
1D: Cells Challenge |
1E: Uncover your Personal Code |
"What are spreadsheets?" video (discussed during class for Group A students on Wed 11/30) Click HERE to watch a brief video or, if your prefer, skim this article instead. "Is Learning about Spreadsheets worth it?" video Watch Video "Excel Funcs" parody video (OPTIONAL) I did not make this parody video...but it's somewhat amusing. Haha :) |
"The Basics of Excel" video series (discussed during class for Group A students on Wed 11/30 & Thurs 12/1) #1: Spreadsheets & Cell Addresses #2: Basic Formatting #3: 'Select' Mode v. 'Edit' Mode #4: Selecting Multiple Cells, Columns, & Rows #5: Moving Cell Data Words to Know - Basics of Excel (study set) Click HERE to access the study set on Quizlet. Please don't move on to section 1C until you fully understand everything ("The Basics of Excel") discussed in this section. |
"Resizing Rows & Columns" video (discussed during class for Group A students on 11/29 & 11/30) This video covers how data can "overflow" into a nearby cell and how to resize columns & rows in a spreadsheet. "Formatting Cells" video (discussed during class for Group A students on ------) This video covers merging cells and using borders. |
"What's Actually in the Cells?!" Challenge This will surely test your knowledge about cells & how data appears in spreadsheets. Begin Challenge Please don't move on to section 1E until you earn a 5/5 on this challenge. |
Uncover your Personal Code You need TWO things before you begin:
Once you finish this activity... submit your personal code to THIS FORM AND paste the shareable link to your Excel spreadsheet on Google Classroom. Then, you may move on to Level 2. |
Level 2
2F: Data, Data, Data! |
2G: Charts |
2H: Autofill |
2I: Level 2 Mastery Check |
"Awesome Stats on Big Data" video (OPTIONAL) "Formatting Data" video (discussed during class for Group A students on ------) This video discusses how to format data using the "Number Format" drop-down box on the Home tab. (This video is NOT talking about bolding, underlining, fonts, etc...it's completely different, so be sure to watch!) "Spreadsheet Tabs" video (discussed during class for Group A students on ------) This video discusses how to rename & customize spreadsheet tabs to better organize your data. |
"Excel: Charts" video (discussed during class for Group A students on ------) This video will cover how to use charts in Excel. It should automatically begin at 50 seconds. Charts, Charts, Charts! INSTRUCTIONS The purpose of this activity is to practice using charts in Excel. When you're done...SUBMIT the link to your spreadsheet to Google Classroom! |
"Basics of Autofill" video Autofill is a feature in spreadsheets that allows you to easily continue patterns in your data. Click the link above to learn about the basics of autofill. Autofill Challenge Download the "Autofill Challenge (SPD 2H)" file by clicking on it directly below this light green table. Then, upload the downloaded copy to OneDrive, so it becomes your own & you can edit it! More instructions about the challenge are available on the spreadsheet itself. Submit it to Google Classroom when you're done! |
Level 2 Mastery Check You must earn at least $200 on this GimKit for it to be considered complete. Your responses will be graded. Please know that...
|
AutofillChallenge (SPD2H).xlsx | |
File Size: | 12 kb |
File Type: | xlsx |
Level 3
3J: Intro to Formulas |
3K: Functions |
3L: Level 3 Support & Unit Test **UNIT GOAL** |
"Intro to Formulas" video Watch the video linked below to learn about formulas in Microsoft Excel: Watch Video When you're done watching the video, you may consider practicing some formulas in a blank spreadsheet before moving on below. Formula Practice Formulas are the purpose of using spreadsheets. A full understanding is expected before moving on to the next part in this section. --> INSTRUCTIONS <-- NOTE: If you're using a desktop computer, you can download the "Formula Practice (SPD 3J)" file by clicking on it below this table. |
"Functions" video Watch the video linked below to learn about functions in Microsoft Excel: Watch Video Want to read about functions instead? Click HERE. Function Practice Functions are powerful. They allow you to make calculations and manipulate data even faster than you can with regular formulas. A full understanding is expected before moving on to the next section. --> INSTRUCTIONS <-- NOTE: If you're using a desktop computer, you can download the "Function Practice (SPD 3K)" file by clicking on it below this table. |
Formulas v. Functions Need some help understanding the difference between formulas & functions? CLICK HERE! Pizza Time - Unit Test The Unit Test will be available on Thursday 12/15. |
FormulaPractice (SPD 3J).xlsx | |
File Size: | 25 kb |
File Type: | xlsx |
FunctionPractice (SPD 3K).xlsx | |
File Size: | 75 kb |
File Type: | xlsx |
Level 4
4M: Preparing for the Classroom Marketplace |
4N: The Classroom Marketplace **NOT AVAILABLE FOR THE FALL 2022 SEMESTER** |
"Introducing the Classroom Marketplace" video Watch the video linked above to learn what the Classroom Marketplace project is all about. Then, click here to view the type of "shop" you can have in the Classroom Marketplace. Cash Register Watch this INSTRUCTIONS VIDEO to properly create your cash register for the Classroom Marketplace project. (Yes, the video is supposed to start at 0:49!) Your completed Cash Register should be submitted to Google Classroom. If you're using the Cash Register as your Unit Test... please go through this GRADING CHECKLIST to be sure all that you need has been included! |
Classroom Marketplace - Last Minute Prep
Classroom Marketplace The Classroom Marketplace will be open for business on Thursday, May 21 on ROBLOX. Further instructions will be given in-game on ROBLOX on Thursday, 5/21. *In the meantime, if you are done with everything in Level 4 and simply waiting for the Classroom Marketplace to be open for business... you may move on to Level 5! |
Level 5
5O: Advanced Functions in Excel |
Excel Challenge CLICK HERE for instructions. Tell Mr. Oates when you think you know how the mysterious function works! Successful completion of this challenge is an opportunity to earn a "4" for Standard E.4 of this unit. |