Computer Apps

Teacher:   Jed Butt Course:  Computer Applications

Phone:      715-349-2277 ext. 202 or 213

Email:  jbutt@siren.k12.wi.us

Course Description:  In Computer Applications you will learn what spreadsheets and database are, and how to create, edit and use both applications to perform a variety of tasks related to many different areas.  The first quarter we will cover Excel spreadsheets and the second quarter we will cover Access databases, PowerPoint and integrating software.

Course Grading:  Daily assignments will be given as well as weekly quizzes.  There will be a quarter final that will cover both vocabulary and concepts taught and a production (activity) aspect.  At the end of the semester, there will be a semester final that will cover spreadsheet and database concepts, vocabulary and production activities.  Some days you may be given extra time to complete assignments, some days you may not.  You are expected to manage your time wisely and come in before or after school, during lunch or study halls, if necessary, to complete assignments.  No late work will be accepted unless due to an excused absence.

Grades will be determined by:

Daily Assignments 50%

Weekly Quizzes 30%

                        Quarter Final                               20%

Materials Needed:  Computer Access  

Classroom Behavior Expectations:   

Be responsible: Conduct yourself in an academic manner.

Do assignments on time.
When absent, check with the teacher for missing work.

Use the computers appropriately. 

Be safe: Don’t spin on chairs.

Don’t roll around on chairs.

Be respectful: Treat everyone as you wish to be treated.

Use computers appropriately – don’t take it out on the computer if you make a mistake.

Participate in class discussions

Be here on time and every day!

Course Outline: 

1. Microsoft Excel (Quarter 1)

1. Microsoft Excel Basics

2. Changing the Appearance of a Worksheet

3. Organizing the Worksheet

4. Entering Worksheet Formulas

5. Using Functions

6. Enhancing a Worksheet

7. Working with Multiple Worksheets and Workbooks

8. Working with Charts

9. Review

10. Spreadsheet Test

2. Microsoft Access (Quarter 2)

1. Microsoft Access Basics

2. Creating a Database

3. Creating Queries

4. Creating and Modifying Forms

5. Creating and Modifying Reports

6. Integrating Access

7. Review

8. Database Test

3. Capstone Project

4. Semester Final