MASTER SYLLABUS

2020-2021

A.	Academic Division: Business, Industry, and Technology

B.	Discipline: Computer Information Systems

C.	Course Number and Title: CISS1020 – Digital Literacy and Applications

D.	Course Coordinator: Carmen Morrison

Assistant Dean: Toni Johnson, PhD

Instructor Information:

Name:	Click here to enter text.

Office Location:	Click here to enter text.

Office Hours:	Click here to enter text.

Phone Number:	Click here to enter text.

E-Mail Address	Click here to enter text.

E.	Credit Hours: 3

Lecture: 2 hours

Laboratory: 2 hours

F.	Prerequisites: None

G.	Syllabus Effective Date: Fall 2020

H.	Textbook(s) Title:

Go! All in One Computer Concepts and Applications, Packaged with MyITLab and eText

Author: Gaskin, Graviett, Geoghan

Year: 2017

Edition: 3nd

ISBN: 9780134526683

Workbook(s) and/or Lab Manual: None

J.	Course Description: Digital Literacy and Applications is a course to provide students with a working knowledge of computer concepts and essential skills necessary for work and communication in today’s society. Topics include technology concepts, operating systems, web browsers, cloud applications, security, digital profile, information literacy, hardware, networks, e-mail, word processing, spreadsheets, databases and presentation software. TAG#:	OBU003

K.	College-Wide Learning Outcomes

College-Wide Learning Outcomes	Assessments - - How it is met & When it is met
Communication – Written
Communication – Speech
Intercultural Knowledge and Competence
Critical Thinking
Information Literacy
Quantitative Literacy

L.	Course Outcomes and Assessment Methods:

Upon successful completion of this course, the student shall:

Outcomes	Assessments – How it is met & When it is met
Identify hardware and software systems with a focus on personal computers and emerging technologies.	Quiz Simulation exercise Weeks 1, 2, 7 and 10
Identify the components of a computer system.	Quiz Simulation exercise Weeks 1, 2 and 7
Demonstrate efficient file management techniques using an operating system’s file management tools.	Quiz Simulation exercise Weeks 3 and 10
Describe the basic concepts of information systems.	Quiz Weeks 1, 2, 13
Evaluate the current value, the potential value, the limitations, and potential dangers (e.g., violation of privacy, copyright, software piracy, and computer crime) in the use of computers.	Quiz Simulation exercise Discussion Weeks 5, 13 and 16
Apply appropriate technology tools and resources to locate and retrieve information from various sources.	Lab Quiz Weeks 5 and 6
Demonstrate the ability to create documents and manipulate text data using the current available software.	Exam Problem-based projects Weeks 4, 8 and 9
Demonstrate the ability to organize and manipulate numerical data using the currently available spreadsheet software.	Exam Problem-based projects Weeks 11 and 12
Demonstrate the ability to create and manipulate simple presentation materials using the currently available presentation software.	Exam Problem-based projects Week 14
Demonstrate the ability to create and manipulate simple databases using the currently available database software.	Exam Problem-based projects Week 15
Evaluate the role of information systems in supporting organizational goals.	Quiz Weeks 1, 2, and 16
Demonstrate use of email systems and use proper etiquette and netiquette when communicating electronically.	Lab assignment Quiz Week 6
Evaluate the ethical, social and political impact of information systems.	Quiz Paper Weeks 13 and 16
Evaluate the strengths and weaknesses of computer functions and information systems.	Quiz Simulation exercise Weeks 1, 2, 5, 10, 13, and 16
Navigate Intranet and Internet applications.	Quiz Lab Weeks 5 and 16
Recognize fundamental networking technologies (e.g., wireless, cellular).	Quiz Simulation exercise Week 13

M.	Topical Timeline (Subject to Change):

Identify current and future computer trends	Weeks 1-2

Recognize various computing devices and their uses	Weeks 1-2

Use and personalize Microsoft Windows operating system	Week 3

Create folders and manage files	Week 3

Create, save and print a document using Microsoft Office applications	Week 4

Use Microsoft Office Help System	Week 4

Recognize the importance of the internet	Week 5

Navigate the web and view content	Week 5

Compare different forms of synchronous and asynchronous online communication	Week 5

Explore the roles of social media in today’s society	Week 5

Recognize different types of E-commerce	Week 5

Use internet browser tabs, bookmarks, and search tool	Week 6

Send and receive email	Week 6

Communicate using web-conferencing tools	Week 6

Store and access files using cloud storage	Week 6

Identify the parts of a computer and their functions	Week 7

Recognize the purpose of peripheral devices	Week 7

Create, format and print documents using Microsoft Word	Week 8

Insert graphics using Microsoft Word	Week 8

Insert footnotes, citations and bibliographies using Microsoft Word	Week 8

Create tables using Microsoft Word	Week 9

Create reusable content using Microsoft Word	Week 9

Create documents using templates in Microsoft Word	Week 9

Understand the purpose and functions of operating systems	Week 10

Use system utilities	Week 10

Understand the importance of file management and backups	Week 10

Create, format and print worksheets using Microsoft Excel	Week 11

Construct formulas and functions in Microsoft Excel	Week 11

Create charts in Microsoft Excel	Week 11

Analyze data by using statistical and logical functions using Microsoft Excel	Week 12

Sort and Filter data using Microsoft Excel	Week 12

Understand what a computer network is and identify different types of networks	Week 13

Recognize threats to security and privacy and explain how to protect against them	Week 13

Create, format and print presentations using Microsoft PowerPoint	Week 14

Insert and format objects into presentations using Microsoft PowerPoint	Week 14

Create a database, tables, and fields using Microsoft Access	Week 15

Create table relationships using Microsoft Access	Week 15

Create queries, forms and reports using Microsoft Access	Week 15

Evaluate different types of software and ways to obtain software	Week 16

Understand various licensing models and how to manage software on a system	Week 16

Use web productivity tools to store and share documents	Week 16

N.	Course Assignments:

Simulation Exercises

Quizzes

Discussions

Labs

Problem-based projects

Papers

Exams

O.	Recommended Grading Scale:

NUMERIC	GRADE	POINTS	DEFINITION
93–100	A	4.00	Superior
90–92	A-	3.67	Superior
87–89	B+	3.33	Above Average
83–86	B	3.00	Above Average
80–82	B-	2.67	Above Average
77–79	C+	2.33	Average
73–76	C	2.00	Average
70-72	C-	1.67	Below Average
67–69	D+	1.33	Below Average
63-66	D	1.00	Below Average
60-62	D-	0.67	Poor
00-59	F	0.00	Failure

P.	Grading and Testing Guidelines:

Click here to enter text.

Q.	Examination Policy:

Click here to enter text.

R.	Class Attendance and Homework Make-Up Policy:

Click here to enter text.

S.	Classroom Expectations:

Click here to enter text.

T.	College Procedures/Policies:

Important information regarding College Procedures and Policies can be found on the syllabus supplement located at

http://catalog.ncstatecollege.edu/mime/download.pdf?catoid=5&ftype=2&foid=3