Objective(s) | Assignment | Resources |
I can use Excel:
- 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
CURRENT PROJECT: Excel Missions & Project DUE: Last class of the year (5/22) | - 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.
- If you haven't finished your eBook, do so now.
- 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.
- When you finish all 5 missions, work on your Excel project.
| Excel Project Checklist |
I can publish an eBook using PowerPoint.
CURRENT PROJECT: PowerPoint eBook DUE: End of class April 20th | - 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.
- Work on your eBook.
| Typing.com
Aesop's Fables:
Video Tutorials: |
I can publish an eBook using PowerPoint.
CURRENT PROJECT: PowerPoint eBook DUE: End of class April 20th | - 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.
- Look at the eBook checklist & example. Watch the videos as you need them.
- Work on your eBook.
| Typing.com
Aesop's Fables:
Video Tutorials: |
I can communicate the solution to a problem using Python.
CURRENT PROJECT: Code Combat (Python) DUE: Finish Level 21 by the end of class 4/6 | - 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.
- Work through the Code Combat levels.
- If you finish and want to dive deeper into Python programming, check out the Codecademy Python course (optional).
| Codecademy Python (optional) |
I can communicate the solution to a problem using Python.
CURRENT PROJECT: Code Combat (Python) DUE: Finish Level 21 by the end of class 4/6 | - 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.
- Follow the Code Combat link to create an account (you do not have to enter an email).
- Work through the Code Combat levels.
| Typing.com |
I can use Publisher to create and customize artifacts.
CURRENT PROJECT: Publisher Fake Company DUE: End of class March 23 | - 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.
- Work on your Publisher Fake Company.
- When you are finished with all 3 files, move them to the Ready to be Graded folder.
| Typing.comPublisher: Fake Company Checklist |
I can use Publisher to create and customize artifacts.
CURRENT PROJECT: Publisher Fake Company DUE: End of class March 23 | - 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.
- 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.
- Read through the Publisher: Fake Company checklist.
- Click Start>All Apps>Microsoft Office>Microsoft Office Publisher to get started.
- When you are finished with all 3 files, move them to the Ready to be Graded folder.
| Typing.com |
I can use Prezi to represent my ideas.
CURRENT PROJECT: Prezi Digital Footprint DUE: End of class February 27. | - 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.
- Continue working on your Prezi.
|
username: lmach+technology@allsaintsnorman.org password: ComputerApps
alternate login: lperrier+technology@allsaintsnorman.org password: ComputerApps
Prezi Help & Tutorials |
I can use Prezi to represent my ideas.
CURRENT PROJECT: Prezi Digital Footprint DUE: End of class February 27. | - 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.
- 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.
- Read the assignment checklist.
- Watch the video called Prezi: Digital Footprint (in the Resources column).
- Open Prezi and get started!
|
username: lmach+technology@allsaintsnorman.org password: ComputerApps
alternate login: lperrier+technology@allsaintsnorman.org password: ComputerApps
Prezi Help & Tutorials |
I can
• 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
CURRENT PROJECT: Digital Compass Hack-A-Wrong DUE: By the end of this class (2/9) | - 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.
- 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.
- Click the last E in the word ANYWHERE to play Hack-A-Wrong.
- 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.
- Explore what would happen if you made different choices in the story.
| Digital Compass |
I can
• 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
CURRENT PROJECT: Digital Compass Insta-Slammed DUE: By the end of this class (2/6) | - 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.
- 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.
- Click the R in the word ANYWHERE to play Insta-Slammed.
- 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.
- Explore what would happen if you made different choices in the story.
| Typing.com |
I can
• 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
CURRENT PROJECT: Digital Compass Citation Infestation DUE: By the end of this class (2/2) | - 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.
- 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.
- Click the first E in the word ANYWHERE to play Citation Infestation.
- 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.
- Explore what would happen if you made different choices in the story.
| Typing.com |
I can
• 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
CURRENT PROJECT: Digital Compass Sticky Situation DUE: By the end of this class (1/30) | - 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.
- 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.
- Click the H in the word ANYWHERE to play Sticky Situation.
- 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.
- Explore what would happen if you made different choices in the story.
| Digital Compass |
I can identify the internal and external parts of a computer and their functions.
I can define digital citizenship terms.
CURRENT PROJECT: Computer Vocabulary DUE: By the end of this class (1/26) | - 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.
- 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.
- Next, we're going to brush up on some computer vocabulary using 2 sets of digital flashcards. Here's what you need to do:
- Click the link to go to the flashcards you want to study.
- Click any of the white boxes along the center of the screen (Flashcards, Learn, Spell, etc.) to study the cards.
- When you think you know all the terms, come back to this page and click the Test link for that topic.
- 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.
- Repeat with the other set of flashcards.
- When you're done, click the link in the Resources column to watch videos about how the internet works.
| How the Internet Works |
I can develop a Microsoft Word project that includes the following elements:- 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
CURRENT PROJECT: Word Schedule DUE: End of this class (1/19) | - 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.
- 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
- How to add/get comments:
- Pair up with a classmate.
- Close out of your document. The document can only be open on 1 computer at a time.
- Open your partner's document.
- Add 3 or more comments (see the Example for the types of comments you should add. Make sure to add your name!)
- Save (not Save As) your partner's document and close it.
- When your partner is done adding comments, open your document and see what they said.
- 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.
| Word: Weekly Schedule Example |
I can develop a Microsoft Word project that includes the following elements:- 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
CURRENT PROJECT: Word Schedule DUE: End of next class (1/19) | - 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.
- 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
- Save your work as LastnameFirstname Weekly Schedule in the assignment folder.
- How to add/get comments:
- Pair up with a classmate.
- Close out of your document. The document can only be open on 1 computer at a time.
- Open your partner's document.
- Add 3 or more comments (see the Example for the types of comments you should add. Make sure to add your name!)
- Save (not Save As) your partner's document and close it.
- When your partner is done adding comments, open your document and see what they said.
- 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.
| Word: Weekly Schedule Example |
I can develop a Microsoft Word project that includes the following elements:- 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
| - 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. Make sure your spreadsheet is saved to PowerPoint/Computer Applications/Excel Typing Log.
- 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.
- 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
- Save your work as LastnameFirstname Weekly Schedule in the assignment folder.
| Typing.com
This is what the Word icon looks like. It is on your desktop.
|
I can test and record my typing speed in an Excel document. | - Log in to Typing.com and take a speed test.
- Open Excel and create a spreadsheet. In row 1, label the columns date/speed/typing test/lessons/games/other/total
- In row 2, enter 1/5 under date and last week's test speed under speed
- In row 3, enter 1/9 under date and the speed test you just took under speed.
- 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.
- 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.
- Save your spreadsheet as LastnameFirstnameTypingrecord.xlsx
- Do Typing.com lessons or games for the remaining class time.
| Typing.com This is what the Excel icon looks like. It is on your desktop.
This is what your spreadsheet should look like. Click for a larger image.
This is the Auto Sum button. It is on the top left of the home tab. |
Course introduction | - Fill out and submit the survey (in the Resources column)
- 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.
- Class discussion: expectations and schedule for the semester, FAQ.
| |