You must be registered with the KCCTE Curriculum Library to download materials. Click here to sign into an existing account. If you do not have an account, click here to register.

keyboard_arrow_left Back to Listing

Chelsea Strickland

Post-Secondary CTE Instructor

Labette Community College

About the Author

My teaching content area is Computer Science at the community college level, and Math at the high school level. Some of the courses that I teach include:

Computer Concepts & Applications
Computer Information Systems

fas fa-download Download All Materials

Computer Concepts & Applications

Complete Course Materials

Post-Secondary

Information Technology

Description

**ARCHIVED** Last update was 2020. An introduction to computer concepts, hardware, and use of software including: operating systems, Internet browsers, word processing software, spreadsheet software, database software, and presentation programs. This course was developed as a Post-Secondary night class, although it is a course commonly taught at the high school level as well. A three-hour night class at the college level will be equal to one-week in a high school setting.

Course Length: 1 Semester

Last Updated: 06/20/2022

KSDE Course No. - 10004 / 60004

Materials

fas fa-angle-right

U1 Intro to Tech1, 3-hour class

During this unit, students will learn the definition of technology and learn about a variety of technological devices.

U1L1 LP Intro.docx

Last Updated: 11/14/2019 | View in Browser

U1L1 PRES Intro to Tech.pptx

Last Updated: 12/5/2019 | View in Browser

U1L1 QUIZ Intro Tech.docx

Last Updated: 11/14/2019 | View in Browser

U1L1 QUIZ KEY Intro Tech.docx

Last Updated: 11/14/2019 | View in Browser

fas fa-angle-right

U2 Word4, 3-hour classes

During this unit, students will learn to create, edit, and format Word documents. Students will also learn to use MLA style to write research papers, write formal business letters, and will show their Word processing skills by creating a flyer.

fas fa-angle-right

U2L2 Create Edit Format1, 3-hour class

Students will: Enter and check spelling of text in a Word document. Format paragraphs. Change theme colors. Insert and format pictures. Add borders. Adjust spacing. Save, print, and email a document.

U2L2 LP CreateEditFormat.docx

Last Updated: 11/14/2019 | View in Browser

U2L2 GUIDE Script.docx

Last Updated: 11/14/2019 | View in Browser

U2L2 EX In Class.docx

Last Updated: 11/14/2019 | View in Browser

U2L2 EX In Class.pdf

Last Updated: 11/14/2019 | View in Browser

U2L2 HO In Class Pic.jpg

Last Updated: 11/14/2019

U2L2 HO HW Assign.docx

Last Updated: 11/14/2019 | View in Browser

U2L2 HO KEY HW Assign.docx

Last Updated: 11/14/2019 | View in Browser

U2L2 HO KEY HW Assign.pdf

Last Updated: 11/14/2019 | View in Browser

fas fa-angle-right

U2L3 Research Paper1, 3-hour class

Students will use MLA style to create a research paper with proper formatting, references, and citations. This includes: Header/footer. Line and paragraph spacing. Paragraph indention. Bibliography. Finding synonyms. Finding and replacing text.

U2L3 LP Research Paper.docx

Last Updated: 11/14/2019 | View in Browser

U2L3 GUIDE Script.docx

Last Updated: 12/5/2019 | View in Browser

U2L3 QUIZ Word Ch. 1.docx

Last Updated: 11/14/2019 | View in Browser

U2L3 QUIZ EX Word Ch1.docx

Last Updated: 11/14/2019 | View in Browser

U2L3 QUIZ EX Word Ch1.pdf

Last Updated: 11/14/2019 | View in Browser

U2L3 HO Shortcuts.pdf

Last Updated: 11/14/2019 | View in Browser

U2L3 HO Shortcuts.docx

Last Updated: 11/14/2019 | View in Browser

U2L3 EX In Class.docx

Last Updated: 12/5/2019 | View in Browser

U2L3 HO HW Assign.docx

Last Updated: 12/5/2019 | View in Browser

U2L3 HO HW Text .docx

Last Updated: 12/5/2019 | View in Browser

U2L3 HO HW KEY.docx

Last Updated: 12/5/2019 | View in Browser

fas fa-angle-right

U2L4 Business Letter1, 3-hour class

Students will create a formal business letter with a letterhead by using the following skills: Insert/format a shape. Change margins and text wrapping. Insert/format clipart. Set/adjust tabs. Insert/modify data into a table.

U2L4 LP Business Letter.docx

Last Updated: 11/14/2019 | View in Browser

U2L4 GUIDE Script.docx

Last Updated: 11/14/2019 | View in Browser

U2L4 QUIZ Word Ch2.docx

Last Updated: 11/14/2019 | View in Browser

U2L4 QUIZ KEY Word Ch2.docx

Last Updated: 11/14/2019 | View in Browser

U2L4 EX Business Letter.pdf

Last Updated: 11/14/2019 | View in Browser

U2L4 EX In Class.docx

Last Updated: 11/14/2019 | View in Browser

U2L4 EX In Class.pdf

Last Updated: 11/14/2019 | View in Browser

U2L4 HO HW Assign.docx

Last Updated: 11/14/2019 | View in Browser

U2L4 HO KEY HW Assign.docx

Last Updated: 11/14/2019 | View in Browser

U2L4 HO KEY HW Assign.pdf

Last Updated: 11/14/2019 | View in Browser

U2L4 HO Review Directions.docx

Last Updated: 11/14/2019 | View in Browser

U2L4 HO Word Review.docx

Last Updated: 11/14/2019 | View in Browser

U2L4 HO KEY Step1 Review.docx

Last Updated: 11/14/2019 | View in Browser

U2L4 HO KEY Step2 Review.docx

Last Updated: 11/14/2019 | View in Browser

U2L4 HO KEY Step3 Review.docx

Last Updated: 11/14/2019 | View in Browser

U2L4 EX Dog Picture.jpeg

Last Updated: 11/14/2019

fas fa-angle-right

U2L5 Word Assessment1, 3-hour class

Students will show their Word processing skills by creating a flyer, research paper, and business letter.

U2L5 LP Word Assessment.docx

Last Updated: 11/14/2019 | View in Browser

U2L5 HO WordTestDirection.docx

Last Updated: 11/14/2019 | View in Browser

U2L5 EX Farm Picture.jpeg

Last Updated: 11/14/2019

U2L5 TEST KEY Step 1.pdf

Last Updated: 11/14/2019 | View in Browser

U2L5 TEST KEY Step 1.docx

Last Updated: 11/14/2019 | View in Browser

U2L5 TEST KEY Step 2.docx

Last Updated: 11/14/2019 | View in Browser

U2L5 TEST HO Step 2.docx

Last Updated: 11/14/2019 | View in Browser

U2L5 TEST HO Step 3.docx

Last Updated: 11/14/2019 | View in Browser

U2L5 TEST HO Step 3.pdf

Last Updated: 11/14/2019 | View in Browser

U2L5 TEST KEY Step 3.pdf

Last Updated: 11/14/2019 | View in Browser

U2L5 TEST KEY Step 3.docx

Last Updated: 11/14/2019 | View in Browser

HO Excel Video Links.docx

Last Updated: 12/5/2019 | View in Browser

fas fa-angle-right

U3 Excel5, 3-hour classes

During this unit, students will learn to enter text, numbers, and formulas in Excel. Students will also learn to format Excel workbooks and create and format charts.

HO Excel Video Link.docx

Last Updated: 12/5/2019 | View in Browser

fas fa-angle-right

U3L6 Worksheet_Chart1, 3-hour class

Students will enter text and numbers in excel, work with simple functions, use the fill handle, format cell styles, create pie charts, add and change name/color of sheets.

U3L6 LP Worksheet_Chart.docx

Last Updated: 11/14/2019 | View in Browser

U3L6 GUIDE Script.docx

Last Updated: 11/25/2019 | View in Browser

U3L6 EX In Class.xlsx

Last Updated: 11/14/2019 | View in Browser

U3L6 HO HW Assign.docx

Last Updated: 11/14/2019 | View in Browser

U3L6 HO KEY HW Assign.xlsx

Last Updated: 11/14/2019 | View in Browser

fas fa-angle-right

U3L7 Form,Funct,Format1, 3-hour class

Students will: Enter formulas. Calculate the maximum. Minimum and average functions. Apply a theme to a workbook. Apply a date format. Create conditional formatting rules. Change column width/height.

U3L7 LP Form,Funct,Format.docx

Last Updated: 11/14/2019 | View in Browser

U3L7 GUIDE Script.docx

Last Updated: 11/14/2019 | View in Browser

U3L7 HO In Class.xlsx

Last Updated: 11/14/2019 | View in Browser

U3L7 EX In Class for Students.xlsx

Last Updated: 11/14/2019 | View in Browser

U3L7 HO HW Assign.docx

Last Updated: 11/14/2019 | View in Browser

U3L7 HO HW Assign text.xlsx

Last Updated: 11/14/2019 | View in Browser

U3L7 HO KEY HW Assign.xlsx

Last Updated: 11/14/2019 | View in Browser

fas fa-angle-right

U3L8 Charting1, 3-hour class

Students will: Rotate text. Create a series of months. Format numbers. Use absolute and mixed cell references. Create and edit Sparkline charts. Create and edit clustered column charts.

U3L8 LP Charting.docx

Last Updated: 11/14/2019 | View in Browser

U3L8 GUIDE Script.docx

Last Updated: 11/14/2019 | View in Browser

U3L8 EX In Class.xlsx

Last Updated: 11/14/2019 | View in Browser

U3L8 HO InClassStudents.xlsx

Last Updated: 11/14/2019 | View in Browser

U3L8 HO HW Assign.docx

Last Updated: 11/14/2019 | View in Browser

U3L8 HO KEY HW Assign.xlsx

Last Updated: 11/14/2019 | View in Browser

fas fa-angle-right

U3L9 Charting1, 3-hour class

Students will work with if functions and nested if functions to solve problems in Excel.

U3L9 LP Charting.docx

Last Updated: 11/14/2019 | View in Browser

U3L9 GUIDE Script.docx

Last Updated: 11/14/2019 | View in Browser

U3L9 EX In Class.xlsx

Last Updated: 11/14/2019 | View in Browser

U3L9 EX InClassStudents.xlsx

Last Updated: 11/14/2019 | View in Browser

U3L9 HO HW Assign.docx

Last Updated: 11/14/2019 | View in Browser

U3L9 HO KEY HW Assign.xlsx

Last Updated: 11/14/2019 | View in Browser

U3L9 HO KEY ExcelTestRev.xlsx

Last Updated: 11/14/2019 | View in Browser

U3L9 HO Excel Test Rev.docx

Last Updated: 11/14/2019 | View in Browser

fas fa-angle-right

U3L10 Excel Assessment1, 3-hour class

Students will show their Excel skills by: Entering and formatting text in an excel spreadsheet. Calculating basic excel formulas. Creating new sheets. Using data to create charts.

U3L10 LP Excel Assessment.docx

Last Updated: 11/14/2019 | View in Browser

U3L10 TEST Excel.docx

Last Updated: 11/14/2019 | View in Browser

U3L10 TEST Excel.pdf

Last Updated: 11/14/2019 | View in Browser

U3L10 HO TextForStudents.xlsx

Last Updated: 11/14/2019 | View in Browser

U3L10 TEST KEY Excel.xlsx

Last Updated: 11/14/2019 | View in Browser

U3L10 HO AccessVideoLink.docx

Last Updated: 12/5/2019 | View in Browser

fas fa-angle-right

U4 Access1, 3-hour class

During this unit, students will create an Access database, create tables, add records to tables, and create and use a query and form.

fas fa-angle-right

U4L11 Access1, 3-hour class

Students will create: A database. Create tables. Add records to tables. Create and use a query and form. Print reports.

U4L11 LP Access.docx

Last Updated: 11/14/2019 | View in Browser

U4L11 GUIDE Script.docx

Last Updated: 11/14/2019 | View in Browser

U4L11 EX In Class.accdb

Last Updated: 11/14/2019

U4L11 HO HW Assign.docx

Last Updated: 11/14/2019 | View in Browser

U4L11 HO KEY HW Assign.docx

Last Updated: 11/14/2019 | View in Browser

fas fa-angle-right

U5 PowerPoint3, 3-hour classes

During this unit, students will learn to create, edit, and present a PowerPoint.

fas fa-angle-right

U5L12 Creating and Editing1, 3-hour class

Students will: Create and edit a PowerPoint presentation. Insert and edit pictures into the presentation. Apply affects to texts. Pictures and slide. Create buttons.

U5L12 LP Creating_Editing.docx

Last Updated: 11/14/2019 | View in Browser

U5L12 GUIDE Script.docx

Last Updated: 11/14/2019 | View in Browser

U5L12 EX In Class.pptx

Last Updated: 11/14/2019 | View in Browser

U5L12 HO PPT Video Link.docx

Last Updated: 12/5/2019 | View in Browser

U5L12 HO HW Assign.doc

Last Updated: 11/14/2019 | View in Browser

fas fa-angle-right

U5L13 Create and Edit1, 3-hour class

Students will create a PowerPoint presentation over a Public Service Announcement of their choice.

U5L13 LP Create_Edit.docx

Last Updated: 11/14/2019 | View in Browser

U5L13 RUB PPT Pres.docx

Last Updated: 11/14/2019 | View in Browser

U5L13 HO PPT Proposal.pdf

Last Updated: 11/14/2019 | View in Browser

U5L13 HO PPT Proposal.docx

Last Updated: 11/14/2019 | View in Browser

fas fa-angle-right

U5L14 Presentation and Final 1, 3-hour class

Students will create present their Public Service Announcement PowerPoints.

U5L14 LP Pres_FinalRev.docx

Last Updated: 11/14/2019 | View in Browser

U5L14 HO Final Review.docx

Last Updated: 11/14/2019 | View in Browser

fas fa-angle-right

U6 Final1, 3-hour class

During this unit, students will show their skills in Word, Excel, and PowerPoint.

U6 LP Final.docx

Last Updated: 11/14/2019 | View in Browser

U6 TEST Written Final.docx

Last Updated: 11/14/2019 | View in Browser

U6 KEY Written Final.docx

Last Updated: 11/14/2019 | View in Browser

U6 HO FinalExamDirections.docx

Last Updated: 11/14/2019 | View in Browser

U6 HO FinalExamDirections.pdf

Last Updated: 11/14/2019 | View in Browser

U6 HO Final.docx

Last Updated: 11/14/2019 | View in Browser

U6 HO Final.pdf

Last Updated: 11/14/2019 | View in Browser

U6 HO Word Final Text.docx

Last Updated: 11/14/2019 | View in Browser

U6 KEY Word Final.docx

Last Updated: 11/14/2019 | View in Browser

U6 KEY Word Final.pdf

Last Updated: 11/14/2019 | View in Browser

U6 HO Excel Final Text.xlsx

Last Updated: 11/14/2019 | View in Browser

U6 KEY Excel Final.xlsx

Last Updated: 11/14/2019 | View in Browser

Chelsea Strickland

Post-Secondary CTE Instructor

Labette Community College

About the Author

My teaching content area is Computer Science at the community college level, and Math at the high school level. Some of the courses that I teach include:

Computer Concepts & Applications
Computer Information Systems

fas fa-download Download All Materials