This hands-on course examines four Microsoft software applications (Word, Excel, PowerPoint, Access), as well as a review of your keyboarding skills. This course will also look at basic skills for other software applications that involve web and graphic design. This course progressively builds on previously established computer application concepts. In addition to independent projects, students will be required to participate in daily class work assignments to demonstrate application proficiency. Class participation and cooperative learning in which students learn from each other and help each other is an important element of this course and part of each student’s grade.
This course will teach students how to learn to identify and solve software problems, work together and help each other and to think critically. |
|
Course Documents
Basic documents for course.
Keyboarding
Keyboarding basics from typing, using keyboard shortcuts and using function keys to peform keyboarding tasks.
Google Presentation
Two true – One false Activity
DDMs
Word Processing/Microsoft Word
Resources for Word Unit.
- Microsoft Online Templates
- List of shortcuts
- Word review document assignment
- Nationality Brochure/Flyer
- MVP Assignment
Excel
Resources for Excel Unit.
- Definitions (excel terms)
- day1ofexcel.xls
- Monthly Rainfall
- Baseball Lineup
- LaffyHS
- LaffyHS questions
- Formulas
- Formulas Solutions in excel and Word
- If Then
- 2014 Excel Test
- Find a car on Autotrader & determine expenses for its purchase, financing and maintenance using Excel.
PowerPoint
Resources for PowerPoint Unit.
- YouTube (4 min)
- PPT Overview
- Mysterious Places PPT example
- Show Feature – Mysterious Places
- Effective Presentations (describing vaca pics)
- Presentation Worksheet
- How to do something (no text)
- Nationality PPT
- Prezi Presentation Software
Web Design
This unit looks at elements of web design using Dreamweaver software as an editor.
- Design a Web Site on Whiteboard
- Basic HTML & How Browser Works
- Dreamweaver Instructions
- Web Site Planning Sheet
- Rotating Banner
- Review Before Web Site Build
- Web Site Checklist & Rubric
Ideas for Web Site:
- Personal site for college
- Business site for self or parents
- Extra credit for another class
- Hobby as informational site
- Restaurant Site
- Fireworks Tutorials
- 4 Great Student Flash Examples:
- Canyon, Fan, PacMan, Jordan
- Flash Definitions
- Flash Outline of Activities
- Fireworks
Office Integration
This unit looks at elements of integrating MS Office Applications:
Access Database
This unit looks at elements of a product/service’s price strategy.
- Survey – Tally Method
- Database OH
- Access vocab
- NewNWind Dbase example
- Common Query Criteria
- Myfirstdatabase.mdb
- AC52 books database
- AC52 verbal quiz
- Access Review(planetfitness & derby)
- Things You Should Be Able To Do
- Music Database
Independent Time/Programming
Individually-paced tutorials on computer programming:
- Code.org
- Codecademy.org
- Video App1
- Video App2
- Gimp Lessons
- AudioTool.com
- Google Sites
- Weebly
Internet Safety
Unit on using the Internet safely and responsibly. Will also address online bullying, privacy and information sharing, and social media and its appropriate use.
- Missing1
- Missing2
- Safe & Responsible Social Networking
- Cell Phone Safety
- Cyberbullying Crossword Puzzle
- The Net
- Dateline Link
- Dateline Link
- Dateline Link
- Dateline Link
- Identity Theft, Phishing, Scams
Links
Other web site resources:
Miscellaneous Lessons
Independent lessons that can be taught individually.
Final Project
5-7 day Final Culminating Project that serves as Final Exam.
Final Project