Test Out Exam for Introduction to Computer Applications Course
The next exam will be administered on the following dates: Wednesday, May 23 (Access), Tuesday, May 29 (Excel), and Thursday, May 31, 2012 (PowerPoint). If you are interested in taking the exam, please contact your guidance counselor and Ms. Alighieri by May 15, 2012. Each exam will run from 2:30 - 4:30 on those dates. Please Note: Due to lack of student enrollment, the exam that was scheduled to be administered on December 5, 7, and 8, 2011 was cancelled.
Overview
The test out exam for the Introduction to Computer Applications class is a "Pass / Fail" exam given twice a year; once in December and again in the Spring. The actual test dates will be set up only if there are students that are interested in taking the exam.
An explanation of the exam has been included in the Program of Studies and reads as follows: “Students may “test out” of the Intro to Computer Applications course and receive the associated technology credits. The “test out” exam is held twice a year and tests all the aspects of the software applications taught in the class. The exam is administered over three two-hour sessions (2:30 - 4:30) held after school over 3 days. Please see your Guidance Counselor for more information regarding this opportunity.” Student should be prepared to demonstrate knowledge on the following aspects of Microsoft Excel (2007) - Basic calculations either by entering their own functions or using the preprogrammed functions
- Use relative and absolute reference to create spreadsheets that calculate many cells of data.
- Basic formatting functions: borders, cell sizing, auto-sizing cells, centering across cells, formatting cell contents, inserting and removing cells, rows and columns
- Planning a large spreadsheet.
- Including headers and footers to a spreadsheet
- Enter functions using the function command
- Change the margins, print orientation, and page break of a spreadsheet
- Use and print multiple worksheets
- Copy and move data between worksheets
- Refer to data in different worksheets
- Develop pie, bar, column, and line charts of spreadsheet data.
- Answer "What If" questions based on spreadsheet data
- Analyze / summarize the data results
- Use the SUM, AVERAGE, RANK, IF, CHOOSE and VLOOKUP functions
- Freeze selected rows and columns on a spreadsheet
Student should be prepared to demonstrate knowledge on the following aspects of Microsoft Access (2007) - Design and create a relational database
- View objects in both the design and datasheet views
- Plan and design tables according to the data that is provided
- Define and establish table relationships
- View a table’s sub datasheets
- Design and develop select queries (include "range" queries, "or" queries and, "and" queries.)
- Design and develop reports (include use of grouping and sorting tools)
- Analyze / summarize the database results
Student should be prepared to demonstrate knowledge on the following aspects of Microsoft PowerPoint (2007) - Students will be able to use a graphic organizer to plan a PowerPoint Presentation (PPP)
- Students will be able to identify the basic elements of a PPP
- Students will be able to create and save a new PPP
- Students will be able to use a PPP template
- Students will be able to use Action buttons (link to and from slides within PPP)
- Students will be able to successfully include special effects such as slide transitions and custom animation
- Students will be able to format characters, change text size, and format paragraphs
- Students will be able to work with bulleted and numbered lists
- Students will be able to find images on the Internet and insert them on a PPP
- Students will be able to crop and resize an image
- Students will be able to add interesting page backgrounds using colors, images and/or watermarks
- Students will be able to add hyperlinks (local (action buttons), email, and outside)
|
Suggestions on how to prepare for the Exam - There are some fabulous online resources (tutorials) available. See if you can find one that fits your needs
- Your local book store has a number of books on these topics. Books written at the introductory level should suffice.
- You can also refer to my class web site for information ( Lori Alighieri )
- The school does not supply study material for the exam.
Grading / Transcripts
Students must earn a 65% or better to receive a passing grade on the exam. Students that pass the exam will receive 3 credits towards the technology requirements for graduation. Transcripts will reflect a grade of "P". If a student does not pass, the student will not receive 3 credits towards the technology requirements for graduation and transcripts will reflect a grade of "F". Please contact Ms. Alighieri if you are interested in taking the exam or if you have any additional questions. |
