• I understand spreadsheet terminology
• I can use formulas to add, subtract, multiply and divide
• I can find and use formulas for more complicated processes
• I can format cells, text, and charts
• I can identify when to use AutoSum and AutoFill to work more efficiently
• I can insert charts and modify chart data
• I can use conditional formatting to quickly analyze large amounts of data

1. Log in to Typing.com and take a speed test. Update your spreadsheet with the date, your speed, and any minutes of practice you have done since your last test. 
2. If you haven't finished your eBook, do so now.
3. Our last project will be to learn how to make spreadsheets. Download and work through the Excel Missions in order. Many students find it helpful to work with a friend. When you finish each mission, show Mrs. Perrier. You do not need to save your missions to turn them in.
4. When you finish all 5 missions, work on your Excel project.

1. Log in to Typing.com and take a speed test. Update your spreadsheet with the date, your speed, and any minutes of practice you have done since your last test. 
2. Work on your eBook.

1. Log in to Typing.com and take a speed test. Update your spreadsheet with the date, your speed, and any minutes of practice you have done since your last test. 
2. Look at the eBook checklist & example. Watch the videos as you need them.
3. Work on your eBook.

1. Log in to Typing.com and take a speed test. Update your spreadsheet with the date, your speed, and any minutes of practice you have done since your last test. 
2. Work through the Code Combat levels.
3. If you finish and want to dive deeper into Python programming, check out the Codecademy Python course (optional).

1. Log in to Typing.com and take a speed test. Update your spreadsheet with the date, your speed, and any minutes of practice you have done since your last test. 
2. Follow the Code Combat link to create an account (you do not have to enter an email).
3. Work through the Code Combat levels.

1. Log in to Typing.com and take a speed test. Update your spreadsheet with the date, your speed, and any minutes of practice you have done since your last test. 
2. Work on your Publisher Fake Company.
3. When you are finished with all 3 files, move them to the Ready to be Graded folder.

1. Log in to Typing.com and take a speed test. Update your spreadsheet with the date, your speed, and any minutes of practice you have done since your last test. 
2. Your next assignment is to make up a company and develop publications for it. Note: all details associated with this company should be school appropriate and free of innuendos or curse words, including names, slogans, contact information, and images.
3. Read through the Publisher: Fake Company checklist.
4. Click Start>All Apps>Microsoft Office>Microsoft Office Publisher to get started.
5. When you are finished with all 3 files, move them to the Ready to be Graded folder.

1. Log in to Typing.com and take a speed test. Update your spreadsheet with the date, your speed, and any minutes of practice you have done since your last test. 
2. Continue working on your Prezi.

1. Log in to Typing.com and take a speed test. Update your spreadsheet with the date, your speed, and any minutes of practice you have done since your last test. 
2. Over the next several classes, we will be using Prezi to create a presentation about digital footprints. If you're not familiar with what a digital footprint is, check out this video for a quick overview.
3. Read the assignment checklist.
4. Watch the video called Prezi: Digital Footprint (in the Resources column). 
5. Open Prezi and get started!

• Find facts and gather data for conscientious decisions

• Synthesize information and evaluate options

• Assess situations in order to make informed judgments

• Reflect on decisions and determine alternative choices

• Build interpersonal empathy by role-playing and taking the perspective of others

• Develop skill-based competencies through game-based learning

• Apply learnings to real-world situations

1. Log in to Typing.com and take a speed test.
2. Update your spreadsheet with the date, your speed, and any minutes of practice you have done since your last test. 
3. During the next four classes, we will be learning about digital citizenship by playing a choose-your-own-adventure game. Click the link to go to Digital Compass and create a username.
4. Click the last E in the word ANYWHERE to play Hack-A-Wrong. 
5. Play through the story and then play the mini-game. The mini-game score is worth 10 points of your grade. You can replay the mini-game as many times as you want. Show Mrs. Perrier your highest score by the end of class.
6. Explore what would happen if you made different choices in the story.

• Find facts and gather data for conscientious decisions

• Synthesize information and evaluate options

• Assess situations in order to make informed judgments

• Reflect on decisions and determine alternative choices

• Build interpersonal empathy by role-playing and taking the perspective of others

• Develop skill-based competencies through game-based learning

• Apply learnings to real-world situations

1. Log in to Typing.com and take a speed test.
2. Update your spreadsheet with the date, your speed, and any minutes of practice you have done since your last test. 
3. During the next four classes, we will be learning about digital citizenship by playing a choose-your-own-adventure game. Click the link to go to Digital Compass and create a username.
4. Click the R in the word ANYWHERE to play Insta-Slammed. 
5. Play through the story and then play the mini-game. The mini-game score is worth 10 points of your grade. You can replay the mini-game as many times as you want. Show Mrs. Perrier your highest score by the end of class.
6. Explore what would happen if you made different choices in the story.

• Find facts and gather data for conscientious decisions

• Synthesize information and evaluate options

• Assess situations in order to make informed judgments

• Reflect on decisions and determine alternative choices

• Build interpersonal empathy by role-playing and taking the perspective of others

• Develop skill-based competencies through game-based learning

• Apply learnings to real-world situations

1. Log in to Typing.com and take a speed test.
2. Update your spreadsheet with the date, your speed, and any minutes of practice you have done since your last test. 
3. During the next four classes, we will be learning about digital citizenship by playing a choose-your-own-adventure game. Click the link to go to Digital Compass and create a username.
4. Click the first E in the word ANYWHERE to play Citation Infestation. 
5. Play through the story and then play the mini-game. The mini-game score is worth 10 points of your grade. You can replay the mini-game as many times as you want. Show Mrs. Perrier your highest score by the end of class.
6. Explore what would happen if you made different choices in the story.

• Find facts and gather data for conscientious decisions

• Synthesize information and evaluate options

• Assess situations in order to make informed judgments

• Reflect on decisions and determine alternative choices

• Build interpersonal empathy by role-playing and taking the perspective of others

• Develop skill-based competencies through game-based learning

• Apply learnings to real-world situations

1. Log in to Typing.com and take a speed test.
2. Update your spreadsheet with the date, your speed, and any minutes of practice you have done since your last test. 
3. During the next four classes, we will be learning about digital citizenship by playing a choose-your-own-adventure game. Click the link to go to Digital Compass and create a username.
4. Click the H in the word ANYWHERE to play Sticky Situation. 
5. Play through the story and then play the mini-game. The mini-game score is worth 10 points of your grade. You can replay the mini-game as many times as you want. Show Mrs. Perrier your highest score by the end of class.
6. Explore what would happen if you made different choices in the story.

1. Log in to Typing.com and take a speed test.
2. Update your spreadsheet with the date, your speed, and any minutes of practice you have done since your last test. 
3. The slip that I handed to you is your grade (or revised grade) on the Word assignment. Compare your slip to the assignment checklist to see why you lost points. 
   
4. Next, we're going to brush up on some computer vocabulary using 2 sets of digital flashcards. Here's what you need to do:
1. Click the link to go to the flashcards you want to study.
2. Click any of the white boxes along the center of the screen (Flashcards, Learn, Spell, etc.) to study the cards.
3. When you think you know all the terms, come back to this page and click the Test link for that topic. 
4. You can retake the test as many times as you want during class. When you're happy with your score, show it to Mrs. Perrier and she will write it down.
5. Repeat with the other set of flashcards.
5. When you're done, click the link in the Resources column to watch videos about how the internet works. 

• Header, footer, and page numbers
• Text formatting
• Margins, text alignment and page breaks
• Word Art, Clip art, and image formatting
• Tables: cell merging, borders
• Columns and column breaks
• Bulleted lists
• Peer review comments

1. Log in to Typing.com and take a speed test.
2. Update your spreadsheet with the date, your speed, and any minutes of practice you have done since your last test. 
3. Work on your Word project. If you get stuck, you can:
• Click the blue question mark right under the X in Word and search keywords.
• Ask a friend
• Ask Mrs. Perrier
4. How to add/get comments:
1. Pair up with a classmate.
2. Close out of your document. The document can only be open on 1 computer at a time.
3. Open your partner's document. 
4. Add 3 or more comments (see the Example for the types of comments you should add. Make sure to add your name!)
5. Save (not Save As) your partner's document and close it. 
6. When your partner is done adding comments, open your document and see what they said.
5. When your document is completely done, re-read the Checklist and then move (or Save As) your document to the Ready to be graded folder.

• Header, footer, and page numbers
• Text formatting
• Margins, text alignment and page breaks
• Word Art, Clip art, and image formatting
• Tables: cell merging, borders
• Columns and column breaks
• Bulleted lists
• Peer review comments

1. Log in to Typing.com and take a speed test.
2. Update your spreadsheet with the date, your speed, and any minutes of practice you have done since your last test. 
3. Work on your Word project. If you get stuck, you can:
• Click the blue question mark right under the X in Word and search keywords.
• Ask a friend
• Ask Mrs. Perrier
4. Save your work as LastnameFirstname Weekly Schedule in the assignment folder. 
5. How to add/get comments:
1. Pair up with a classmate.
2. Close out of your document. The document can only be open on 1 computer at a time.
3. Open your partner's document. 
4. Add 3 or more comments (see the Example for the types of comments you should add. Make sure to add your name!)
5. Save (not Save As) your partner's document and close it. 
6. When your partner is done adding comments, open your document and see what they said.
6. When your document is completely done, re-read the Checklist and then move (or Save As) your document to the Ready to be graded folder.

• Header, footer, and page numbers
• Text formatting
• Margins, text alignment and page breaks
• Word Art, Clip art, and image formatting
• Tables: cell merging, borders
• Columns and column breaks
• Bulleted lists
• Peer review comments

1. Log in to Typing.com and take a speed test.
2. Update your spreadsheet with the date, your speed, and any minutes of practice you have done since your last test. Make sure your spreadsheet is saved to PowerPoint/Computer Applications/Excel Typing Log.
3. Our next project is a document featuring some less-used Microsoft Word features. Read the Checklist and the Example so you know what to do. 
4. Work on your Word project. If you get stuck, you can:
• Click the blue question mark right under the X in Word and search keywords (like "margin").
• Ask a friend
• Ask Mrs. Perrier
5. Save your work as LastnameFirstname Weekly Schedule in the assignment folder. 

1. Log in to Typing.com and take a speed test.
2. Open Excel and create a spreadsheet. In row 1, label the columns date/speed/typing test/lessons/games/other/total
3. In row 2, enter 1/5 under date and last week's test speed under speed
4. In row 3, enter 1/9 under date and the speed test you just took under speed.
5. Under the other columns in row 3, put how many minutes you spent on each activity between the last test and this one. For example, if you played typing games for 15 minutes after your test last week, did 5 minutes of lessons at home, and took a 3-minute test you would enter 15 under games, 5 under lessons, and 3 under typing test in row 3.
6. Select 2C-2F and click Auto-Sum. It should add up all of the practice time and put the total under the total column. Do the same with 3C-3F.
7. Save your spreadsheet as LastnameFirstnameTypingrecord.xlsx
8. Do Typing.com lessons or games for the remaining class time.

1. Fill out and submit the survey (in the Resources column)
2. Log in to Typing.com and take a 1:00 Speed Test. Be sure to click "Print Certificate" and type in your name after you take the test.
3. Class discussion: expectations and schedule for the semester, FAQ.