Archived Lessons: Computer Applications

Current Objective(s)  Current 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
  1. Log in to Typing.com and take a speed test.
  2. Update your typing log spreadsheet with the date, your speed, and any minutes of practice you have done since your last test.
  3. Please double-check that you turned in a pdf of your eBook to the Ready to be graded folder. If you don't turn in a pdf, you will receive a 0 for that assignment.
  4. Download and complete each Excel mission. Please show me any missions you completed on Friday so I can give you credit for them.
  5. Today is the last day of class. You must finish all 5 of the Excel missions by Christmas break. Please let me know if you need to come in during zero hour or after school. 
  6. The Excel Project (with the checklist) is optional and will earn you extra credit. 

Previous Lessons

 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
 
  1. Log in to Typing.com and take a speed test.
  2. Update your typing log spreadsheet with the date, your speed, and any minutes of practice you have done since your last test.
  3. Download and complete each Excel mission.
  4. Note: Tuesday is the last day of class. You must finish all 5 of the Excel missions by Christmas break. Please let me know if you need to come in during zero hour or after school. 
  5. The Excel Project (with the checklist) is optional and will earn you extra credit. 
 Typing.com


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
 
  1. Log in to Typing.com and take a speed test.
  2. Update your typing log spreadsheet with the date, your speed, and any minutes of practice you have done since your last test.
  3. Download and complete each Excel mission.
  4. After you have completed the missions, read the Excel Project Checklist and work on your project. If you have any questions, please ask!
  5. When you are finished, save your file to Excel Typing Record/Final Project ready to be graded
 


Excel Project Checklist 
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
 
  1. Log in to Typing.com and take a speed test.
  2. Update your typing log spreadsheet with the date, your speed, and any minutes of practice you have done since your last test.
  3. Optional: the eBooks are now published! Click on the black eBooks circle on the home page of this site to check them out.
  4. If your eBook is not on the eBook page, that means I do not have a pdf version of it. Please put a pdf of your eBook in the Ready to be graded folder.
  5. Download and complete each Excel mission.
  6. After you have completed the missions, read the Excel Project Checklist and work on your project. If you have any questions, please ask!
  7. When you are finished, save your file to Excel Typing Record/Final Project ready to be graded
 
 Typing.com


 I can make an ebook using PowerPoint.

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
  1. Log in to Typing.com and take a speed test.
  2. Update your typing log spreadsheet with the date, your speed, and any minutes of practice you have done since your last test.
  3. You should finish your eBook today. Be sure to review the eBook Checklist. Save the PowerPoint file and the pdf file to PowerPoint/Computer Applications Fall 2016/PowerPoint eBooks/Ready to be Graded
  4. Our final unit for this class is Microsoft Excel. Download and complete each Excel mission.
  5. After you have completed the missions, read the Excel Project Checklist and work on your project.
 




Excel Project Checklist 
 I can make an ebook using PowerPoint. 
  1. Log in to Typing.com and take a speed test.
  2. Update your typing log spreadsheet with the date, your speed, and any minutes of practice you have done since your last test.
  3. You should finish your eBook this week. Be sure to review the eBook Checklist.
  4. You can illustrate your eBook using Photos for Class and/or create your own illustrations using Sketchpad. You may not use Google Images for this project.
  5. When you finish your eBook, save the PowerPoint file and the pdf file to PowerPoint/Computer Applications Fall 2016/PowerPoint eBooks/Ready to be Graded
 Typing.com



 I can make an ebook using PowerPoint.





Image result for happy thanksgiving
  1. Log in to Typing.com and take a speed test.
  2. Update your typing log spreadsheet with the date, your speed, and any minutes of practice you have done since your last test.
  3. Work on your eBook. Be sure to review the eBook Checklist.
  4. You can illustrate your eBook using Photos for Class and/or create your own illustrations using Sketchpad. You may not use Google Images for this project.
  5. When you finish your eBook, save the PowerPoint file and the pdf file to PowerPoint/Computer Applications Fall 2016/PowerPoint eBooks/Ready to be Graded
 
 Typing.com


 I can make an ebook using PowerPoint.
  1. The Veterans Day assembly is this morning. We will head over there at 8:30 am.
  2. Log in to Typing.com and take a speed test.
  3. Update your typing log spreadsheet with the date, your speed, and any minutes of practice you have done since your last test.
  4. Work on your eBook. Be sure to review the eBook Checklist.
  5. You can illustrate your eBook using Photos for Class and/or create your own illustrations using Sketchpad. You may not use Google Images for this project.
  6. When you finish your eBook, save the PowerPoint file and the pdf file to PowerPoint/Computer Applications Fall 2016/PowerPoint eBooks/Ready to be Graded
 



Regarding Publisher grades:
If you wish to make revisions to your graded Publisher assignment, talk to me before you leave class this morning.

If you haven't turned in all 3 Publisher files by the end of class today, your progress report will show a 0 for that assignment. 
 I can make an ebook using PowerPoint.
  1. Log in to Typing.com and take a speed test.
  2. Update your typing log spreadsheet with the date, your speed, and any minutes of practice you have done since your last test.
  3. Create an ebook with text and illustrations of one of Aesop's fables. Watch the video in the resources column to learn how to do this, then read the eBook checklist.
  4. You can select a fable from the website in the Resources column (look for a longer one so that your ebook will have enough pages).
  5. You can illustrate your ebook using Photos for Class and/or create your own illustrations using Sketchpad. You may not use Google Images for this project.
  6. When you finish your ebook, save the PowerPoint file and the pdf file to PowerPoint/Computer Applications Fall 2016/PowerPoint eBooks/Ready to be Graded
 
 Typing.com





Note: Progress reports are being sent out this Friday. If your Publisher assignment is missing, it will be counted as a 0/40 on your progress report. If you need to come in during zero hour to catch up, please let me know.
I can use Publisher to create and customize publications.  
  1. Log in to Typing.com and take a speed test.
  2. Update your typing log spreadsheet with the date, your speed, and any minutes of practice you have done since your last test.
  3. Today is the day to finish your Publisher project. 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.
  4. When your assignments are finished, move them to the "Ready to be Graded" folder in PowerPoint/Computer Apps Fall 2016/Publisher
  5. When you are done, you may either do lessons/games on Typing.com or play around with Publisher and make something of your choosing.
 
 Typing.com

 I can use Publisher to create and customize publications.  
  1. Log in to Typing.com and take a speed test.
  2. Update your typing log spreadsheet with the date, your speed, and any minutes of practice you have done since your last test.
  3. If you have not finished 4 characters in Digital Compass, log on and do so now. Be sure to show me your scores!
  4. 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.
  5. Read through the Publisher: Fake Company checklist and use Publisher on your computer to complete it.
  6. When your assignments are finished, move them to the "Ready to be Graded" folder in PowerPoint/Computer Apps Fall 2016/Publisher
  7. When you are done, you may either do lessons/games on Typing.com or play around with Publisher and make something of your choosing.
 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

  1. Log in to Typing.com and take a speed test.
  2. Update your typing log spreadsheet with the date, your speed, and any minutes of practice you have done since your last test.
  3. Log in to Digital Compass, choose a character and play the game. When you are finished with a character, raise your hand so that I can write down your score.
  4. How you will be graded: each story line is worth 10 points. You must complete 66% of a story line (according to the scorecard) to get credit. When you finish a story line, you will play a mini-game. Your grade will be based on your mini-game score. 
 


Anyone who has not finished and shown me scores for at least 4 characters by the end of this class will have to continue doing Digital Compass during the next class.  
 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

  1. Log in to Typing.com and take a speed test.
  2. Update your typing log spreadsheet with the date, your speed, and any minutes of practice you have done since your last test.
  3. Create a Digital Compass username (be sure to write it down as you will need it for future classes).
  4. Choose a character and play the game. When you are finished with a character, raise your hand so that I can write down your score.
  5. How you will be graded: each story line is worth 10 points. You must complete 66% of a story line (according to the scorecard) to get credit. When you finish a story line, you will play a mini-game. Your grade will be based on your mini-game score. 
 
 Typing.com

 I can identify the parts of a computer.

I can code. 
  1. Log in to Typing.com and take a speed test.
  2. Update your typing log spreadsheet with the date, your speed, and any minutes of practice you have done since your last test.
  3. If you haven't finished your Prezi, do so today.
  4. Study & take the Basic Parts Quiz and the Advanced Parts Quiz. Raise your hand to show me your score.
  5. If you already started Code Studio's Accelerated Course, finish it today. Otherwise work on the Hour of Code.
  6. After you have finished all current assignments, you may do any of the activities on the Coding sponges page (gray circle on the home page) or First in Math. You may not watch videos on YouTube or Google random things.
 




Please finish today:
Prezi
Basic Parts Quiz
Advanced Parts Quiz
Code Studio 
I can identify the parts of a computer.

I can code.  
 
  1. Log in to Typing.com and take a speed test.
  2. Update your typing log spreadsheet with the date, your speed, and any minutes of practice you have done since your last test.
  3. If you haven't finished your Prezi, do so now. Let me know when you have completed it. 
  4. Study the Basic and Advanced Parts of the Computer vocabulary lists. You can use any of the Quizlet games or study tools to learn the terms.
  5. When you are ready, take the Basic Parts Quiz and the Advanced Parts Quiz. Raise your hand to show me how you did.
  6. Next, we are going to work on coding. You have two options: Code Studio Accelerated Course (if you haven't done much coding before) or Code Studio Hour of Code JavaScript, where you'll be using JavaScript instead of just blocks. Pick one and work on it. 
  7. After you have finished your Prezi, both quizzes, and one of the coding courses, you can do any of the activities on the Coding sponges page (gray circle on the home page).
 Typing.com



Finish up and turn in missing and incomplete assignments. 
  1. Log in to Typing.com and take a speed test
  2. Update your typing log spreadsheet with the date, your speed, and any minutes of practice you have done since your last test.
  3. Look at your progress report to find out what you need to finish.
    1. If it says your "My Summer" assignment is missing, finish it and move it to the Ready to be Graded folder
    2. If you want to revise "My Summer", be sure you are revising the one in the Ready to be Graded folder
  4. All My Summer assignments must be finished and turned in by the end of class.
  5. Let the teacher know if your Prezi is ready to be graded.
  6. After all your assignments are complete, you may use the games and resources on this website.
 

Digital Resources Prezi Checklist 
Finish up and turn in missing and incomplete assignments. 
  1. Log in to Typing.com and take a speed test.
  2. Update your typing log spreadsheet with the date, your speed, and any minutes of practice you have done since your last test.
  3. Look at the spreadsheet example in the resources column. If yours doesn't look like that image, fix it now.
  4. Complete your My Summer Word project. Be sure to check your work against the checklist! When you are done, move your document to the Ready to be Graded folder
  5. Go to Prezi.com and find your presentation. Click the three dots and rename your presentation LastnameFirstname.
  6. Complete your Prezi according to the checklist. 
  7. When you have finished all of these assignments, let the teacher know. Then you may use any games or resources on this website. 
 
 Typing.com

This is what your spreadsheet should look like (except with more data). Click for a larger image.


username: lmach+technology@allsaintsnorman.org
password: ComputerApps
I can touch type.

I can find resources and tools on the Internet.

I can create a multimedia presentation. 
  1. Log in to Typing.com and take a speed test.
  2. Update your typing log spreadsheet with the date, your speed, and any minutes of practice you have done since your last test.
  3. If you have not finished your My Summer assignment, do so now. Scroll down to Previous Lessons to view assignment details.
  4. Read the Digital Resources Prezi Checklist
  5. If you don't have a Prezi subject yet, raise your hand.
  6. Go to Prezi.com, log in, and continue working on your Digital Resources assignment.
 
username: lmach+technology@allsaintsnorman.org
password: ComputerApps 
I can touch type.

I can find resources and tools on the Internet.

I can create a multimedia presentation. 
  1. Check the whiteboard to see if you are missing any assignments. Turn in any missing assignments by opening the file, clicking Save As, and saving the files at PowerPoint/Computer Applications Fall 2016/assignment folder.
  2. Log in to Typing.com and take a speed test.
  3. Update your typing log spreadsheet with the date, your speed, and any minutes of practice you have done since your last test.
  4. If you have not finished your My Summer assignment, do so now. Scroll down to Previous Lessons to view assignment details.
  5. Read the Digital Resources Prezi Checklist
  6. Raise your hand to get your Prezi subject
  7. Go to Prezi.com, log in, and begin working on your Digital Resources assignment.
 
 Typing.com
username: lmach+technology@allsaintsnorman.org
password: ComputerApps
 I can touch type.

I can create and format a word processing document.

I can use features like word art, font, color, and clip art to make a visually appealing document.
  1. Check the whiteboard to see if you are missing any assignments. Turn in any missing assignments by opening the file, clicking Save As, and saving the files at PowerPoint/Computer Applications Fall 2016/assignment folder.
  2. Log in to Typing.com and take a speed test.
  3. Update your typing log spreadsheet with the date, your speed, and any minutes of practice you have done since your last test.
  4. Finish your My Summer document. Be sure to check it against the My Summer checklist in the Resources column.
  5. When you are finished with My Summer, save it as LastnameFirstnameMySummer.docx.
  6. Open the file browser (folder icon on the task bar) and move your My Summer file into the "Ready to be Graded" folder.
  7. If there is class time left, work on Typing.com lessons or games.
 
Microsoft Word tutorials
My Summer checklist
My Summer example 
 I can touch type.

I can create and format a word processing document.

I can use features like word art, font, color, and clip art to make a visually appealing document.
  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. Click Save as and save your spreadsheet as LastnameFirstnameTypingRecord.xlsx in your class folder on PowerPoint
  4. If you have not finished your spreadsheet, scroll down on this page to Previous Lessons and finish your spreadsheet.
  5. Create a Microsoft Word document. Write 1 paragraph about the best part of your summer. Write 1 more paragraph about something you wish you could have done this summer.
  6. After you have written both paragraphs, adjust the formatting of your document to match the checklist.
  7. If you don't know how to do something, look it up using the Microsoft Word tutorials.
  8. Save your document as LastnameFirstnameSummer.docx
  9. When you are finished, use Microsoft Word, Excel, or Typing.com for the remainder of class.
 
Microsoft Word tutorials
My Summer checklist
My Summer example 
 UPDATED WORD PROJECT

I can use advanced Microsoft Word features to organize content.
 
  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:
    • Search keywords (like "margin") in the Help menu
    • Ask a friend
    • Ask Mrs. Perrier
  5. Save your work as LastnameFirstname Weekly Schedule in the assignment folder. 


This is what the Word icon looks like. It is on your desktop. 

 I can touch type.

I can create a spreadsheet.
 
  1. Take the Survey.
  2. Log in to Typing.com and take a speed test.
  3. Open Excel and create a spreadsheet. In row 1, label the columns date/speed/typing test/lessons/games/other/total
  4. In row 2, enter 8/19 under date and last week's test speed under speed
  5. In row 3, enter 8/23 under date and the speed test you just took under speed.
  6. 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.
  7. 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.
  8. Save your spreadsheet as LastnameFirstnameTypingrecord.xlsx
  9. Do Typing.com lessons or games for the remaining class time.
 Survey
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.
I understand the rules and procedures of the Technology Lab. 
  1. 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.
  2. Fill out the survey (in the resources tab).
  3. Review the junior high assignment guidelines.
  4. At home: read, discuss, and sign the Telecommunications Use Agreement with your parents. This form should be returned to the computer lab next time you have class.
Classroom rules and consequences
Typing.com
Survey
Junior High Assignment Guidelines
Telecommunications Use Agreement


   
   
   
   
   
ĉ
Unknown user,
Sep 21, 2016, 1:56 PM
ĉ
Unknown user,
Nov 30, 2016, 3:44 PM
Ĉ
Unknown user,
Nov 30, 2016, 3:44 PM
Ĉ
Unknown user,
Nov 30, 2016, 3:44 PM
Ĉ
Unknown user,
Nov 30, 2016, 3:44 PM
Ĉ
Unknown user,
Nov 30, 2016, 3:44 PM
Ĉ
Unknown user,
Nov 30, 2016, 3:44 PM
ĉ
Unknown user,
Oct 26, 2016, 8:51 AM
ĉ
Unknown user,
Feb 28, 2017, 11:17 AM
Comments