| Course Code: | BIT100 |
|---|---|
| Course Title: | Introduction to Information Technology Skills |
| Credit Hours: | 3 |
| Contact Hours/Week: | Lectures (3 hours) / labs( 1 hour 30 minutes ) |
| Prerequisites: | None |
Course Description
This is an introductory personal computer applications course. It includes the operating system (MS Windows), word processing (MS Word), spreadsheets (MS Excel), and presentation manager (MS PowerPoint), database applications (MS Access).
Learning Outcomes
Weight of Various Assessment Elements & Alignment of Course Learning Outcomes to Program Learning Outcomes:
| Task | Weight in % | CLO1 | CLO2 | CLO3 | CLO4 | CLO5 |
|---|---|---|---|---|---|---|
| PLO3 | PLO3 | PLO2&3 | PLO3 | PLO2&3 | ||
| Midterm Exam | 20% | X | ||||
| Lap Assignment #1 | 20% | X | ||||
| Lap Assignment #2 | 20% | X | ||||
| Final Group Project | 40% | X | X |
(Lectures, Labs, Presentations, Exams, and Out-of-class Assignments):
| Week# | Topics | CLO(s) | Activities |
|---|---|---|---|
| 1 |
Unit#1: Computer Concepts Lesson 1: Impact of Digital Technology |
1 |
• Explain Society’s Reliance on Technology • Develop Personal Uses for Technology • Explain the role of technology in the professional world Exercise # 1 |
| 2 |
Unit#1: Computer Concepts Lesson 2: Computer hardware and software |
1 |
• Categorize the Various types of Computer Hardware. • Demonstrate Familiarity with Input and Output Devices • Maintain hardware components • Explain How to Use Apps as Part of Your Daily Life • Use Common Features of Productivity and Graphics Apps Exercise # 2 |
| 3 | Unit#2: Operating Systems and File Management | 1 |
• Explain the pros and cons of different types of operating systems. • Explain how an operating system works. • Personalize a computer operating system, as well as its software and hardware, to increase productivity. • Manages files and folders. Exercise # 3 |
| 4 |
Unit#3: Digital communication Lesson 1: Network Safety and Security |
1 |
• Discuss the key features of connected networks and explore how connections between networks are made • Discuss issues of equity and safety in a connected world • Connect to different types of networks Exercise # 4 |
| 5 |
Unit#3: Digital communication Lesson 2: Internet and Communication |
1 |
• Explain the role of the web in daily life • Describe websites and webpages • Use e-commerce • Explain how information literacy applies to web searches and research • Conduct online research • Explain the basic concepts of cloud computing • Explain digital communication and E-mail Exercise # 5 |
| 6 | Unit#4: Microsoft word 2019 | 2 |
• Start and exit Word • Enter and type text in a Word document • Check spelling and grammar as you work on a document • Format text, paragraphs, ad document elements • Use a header to number pages of a document • Correct errors and revise a document • Cut, copy, and paste text and use Word Help Exercise # 6 |
| 7 | Unit#4: Microsoft word 2019 | 2 |
• Inserting Drop Caps • Insert and format a picture and add a page border • Insert and format a shape, Symbol • Insert a symbol • Layout of paragraph and apply a style • Insert a Word table, enter data in the table, and format the table • Insert and format a SmartArt graphic Lap Assignment #1 |
| 8 |
Unit#5: Microsoft Excel 2019 Lesson 1: Creating a Worksheet and a Chart |
3 |
• Starting and Using Excel • Identify the components of the Microsoft Office ribbon • Describe the Excel worksheet • Enter text and numbers • Copy the contents of a cell to a range of cells using the fill handle • Apply cell styles • Change a worksheet name and sheet tab color • Preview and print a worksheet • Use the AutoCalculate area to display statistics • Correct errors on a worksheet • Use Microsoft Office Help Midterm Exam |
| 9 |
Unit#5: Microsoft Excel 2019 Lesson 1: Creating a Worksheet and a Chart |
3 |
• To calculate multiple totals at the same time • Calculating average, maximum, and minimum values • Saving the project • Formatting the worksheet • Adding a chart to the worksheet • Changing the sheet tab name and colors • Printing the worksheet Exercise # 7 |
| 10 |
Unit#5: Microsoft Excel 2019 Lesson 2: Formulas, Functions, Formatting and What-If Analysis |
3 |
• Entering Formulas • Using the Average, MAX, MIN, and other statistical functions • Formatting the worksheet • To Format Dates and Center Data in Cells • To Apply an Accounting Number Format and Comma Style Format Using the Ribbon • To Apply a Currency Style Format with a Floating Dollar Sign • To Apply a Percent Style Format and Use the Increase Decimal Button • Rotating text and using the fill Handle to create a series • Copying range of cells to a nonadjacent destination area • Inserting and deleting cells in a worksheet • Making Decisions- The if function • Adding and formatting Sparkline charts • Adding a clustered column chart to the workbook • Use the IF function to perform a logical test Lap Assignment #2 |
| 11 |
Unit#6: Microsoft Power Point 2019 Lesson 1: Creating and Editing a Presentation with Pictures |
4 |
• What is Power point • Starting and Using PowerPoint • To Start PowerPoint and Create a Blank Presentation • Creating a Title Slide • Formatting Characters • Adding a Slide with a Bulleted list • Adding Slides, Changing Slide layouts, and Changing the Theme • Animates Your Slide Show • Add Transitions to Your Slide Show and set timing • Inserting, Resizing, and Moving Pictures • Resizing Photos and Illustrations • To Save a Presentation with the Same File Name • Making Changes to Slide Text Content • Viewing the presentation in slide show view • Saving and printing file Exercise # 8 |
| 12 |
Unit#6: Microsoft Power Point 2019 Lesson 2: Inserting Shapes, SmartArt WordArt, Charts, and tables |
4 |
• Downloading theme and editing slides • Creating and formatting a SmartArt graphics • Inserting and formatting a shape • Positioning slide elements • Adding a table to a slide and formatting • Adding WordArt Exercise # 9 |
| 13 |
Unit#7: Microsoft Access 2019 Lesson 1: Databases and Database Objects: An Introduction |
5 |
• Describe the features of the Access window • Create a database • Create tables in Datasheet and Design views • Add records to a table • Close a database • Open a database Exercise # 10 |
| 14 |
Unit#7: Microsoft Access 2019 Lesson 2: Querying a Database |
5 |
• Create queries using Design view • Include fields in the design grid • Use text and numeric data in criteria • Save a query and use the saved query • Create and use parameter queries • Use compound criteria in queries • Sort data in queries • Join tables in queries • Create a report and a form from a query • Export data from a query to another application • Perform calculations and calculate statistics in queries • Create crosstab queries • Customize the Navigation Pane Exercise # 11 |
| 15 |
Unit#7: Microsoft Access 2019 Lesson 3: Creating Reports and Forms |
5 |
• Create reports and forms using wizards • Modify reports and forms in Layout view • Group and sort data in a report • Add totals and subtotals to a report • Conditionally format controls • Resize columns • Filter records in reports and forms • Print reports and forms • Apply themes • Add a field to a report or form • Add a date • Change the format of a control • Move controls • Create and print mailing labels Exercise # 12 |
| 16 | Final Group Project | 4,5 | Project submission and Presentation |
Students will be working in groups. They are required to apply their learning knowledge by creating a small database for a business using what they learned in CLO5 using MS Access. They will design the database, create tables, and connect those tables with relationships. Create forms for data entry, queries for data filtration, and reports for data presentation purposes. Then the students will present their work by creating a PowerPoint presentation to explain their design and steps by applying what they learned in CLO4 using MS PowerPoint.
Practical demonstrations of modern PC Operating Systems, Word-processing, Spreadsheet, Presentation, and Database Packages. The course will use brainstorming, discussions, and cooperative learning that help create a learning environment wherein everyone in the class can learn from each other and test each other’s thinking and allow them to apply critical thinking skills to various issues.
| Educational Resource | Description |
|---|---|
| Textbook Required | Cable, Campbell, Ciampa, Freund, Frydenberg, Hooper, Monk, Ruffolo, Sebok, Vermaat, (2020), Technology for Success and Shelly Cashman Series Microsoft Office 365 and office 2019, 1st edition, Cengage, ISBN: 978-0357026380 |
| Other References | Computers Made Easy, Publisher: Independently published (June 12, 2018) ISBN-10: 1983154830, ISBN-13: 978-1983154836 |
| Other Resources | Office 365 All-in-One for Dummies, Publisher: For Dummies; 1 edition (May 29, 2019). ISBN-13: 978-1119576242, ISBN-10: 1119576245 |
Class Attendance:
Students are expected to attend all classes of this course (without exception). Prior approval is required for the class absence except for emergencies. However, any student with 30% short attendance will be forced to withdraw from the course, and the student will receive EW in his/her transcript for this course.
Tardy:
Do not come late to class. Any student coming late will not be allowed to attend the class, and he/she will be marked absent.
Exams:
Failure to attend a course exam will result in zero marks unless the student provides an excuse acceptable to the Dean, who approves a re-sit exam. Failed courses will normally be reassessed in the scheduled semester. It is your responsibility to attend the exam at the correct time and place. Your results will be printed in a transcript, which includes all your assessments. You should check the accuracy of your transcript. If there is an error in your transcript, you have to notify the instructor.
Assignments & Projects:
Assignments and projects should be handed over to the instructor on the due date. A zero mark will follow the late submission of an assignment unless the student has an acceptable reason approved by the instructor.
Exam Attendance/Punctuality:
Re-sit Exams:
The student will not be allowed to re-sit an exam unless he/she furnishes the institute with written evidence as follows:
Cheating:
Definition of cheating: Cheating is an attempt to gain marks dishonestly and includes:
Penalty of Cheating:
The minimum penalty for cheating is an automatic Zero for the test or assignment leading to a possible “F” for the subject. The student will be expelled from the examination room so that he/she doesn’t disturb other students. The exam invigilator will produce a report on the case. The report will be kept in the student file. A second offense will result in the immediate suspension of the student for the remainder of the current semester. A copy of the decision will be kept in the student file, while another one will be passed to the Dean.
Turnitin:
In addition to the hard copy, students may be required to submit written assignments/reports in soft copy through the Turnitin system available online at the Learning Management System (Moodle) to check the “Similarity Index.” The penalties for minor and major violations are indicated below.
| Offence | Penalty |
|---|---|
| Minor offence (First time) | The student will receive a written academic warning, and the case will be recorded in the academic violations tracking system. |
| Minor offence (Repeated) | The student will receive zero and the case will be recorded in the academic violations tracking system. |
| Major offence (First time) | The student will receive an F grade in the course and a written academic warning, and the case will be recorded in the academic violations tracking system. |
|
Major offence (Repeated)
|
The student will receive an F grade in the course and will be suspended for one semester, and the case will be recorded in the academic violations tracking system. |
All types of electronic communication aids and devices are not allowed in classes.
Join with Many Students Select the program you want to Enquire About!
