p>In this Spreadsheet course, you'll learn to apply the unique tabular system of spreadsheets to enter, manage and process information in ways useful to you and your students. This self-paced module will teach you how to quickly and easily enter, format, sort and calculate data in a spreadsheet, as well as generate useful reports, charts and graphs. With your new knowledge of spreadsheet software, you'll be able to track student grades, attendance and other student performance data; visualize student progress with bar, pie or line charts; and efficiently manage all sorts of classroom data. Online instruction will be for Apple (Claris) Works applications, on both PC and Macintosh platforms. Those using software versions older than Works 5 may experience some differences in interface and/or features.

CTC TECHNOLOGY PROFICIENCY RUBRIC

Before starting this lesson, you should be able to open, close and save files; select sections with the mouse; cut, copy and paste; and download files from the course materials page. You can get these skills in our Basic Computer Skills module. This course requires the ss_example file, which you can download and save to your hard drive by right-clicking (PC) or Option-clicking (Mac) on the correct software package: Works. From the menu that appears, select Save. You can also download the finished version in PDF format.

To meet the CTAP 071 spreadsheet certification requirements, you must create one spreadsheet document that exhibits basic to proficient skills with this tool.

Detailed portfolio requirements can be found in the Course Materials section.

It will take you approximately 9 hours to complete this course and the accompanying document to add to your portfolio.