Sign In
Thursday 05 December 2019  |   | 

Courses

CMP011 – Computer Orientation I

CourseCMP011 – Computer Orientation I
SemesterYear 2017/2018 Semester 1 (171)
Credits1 (0,2,0)
PrerequisiteNone


Course   DescriptionThe main objective of this course is to provide students with the required skills for using computers efficiently and for using the common applications of computers which they need during their university study and future careers. It builds upon the knowledge and skills they acquired through their study in high school. The course covers some advanced topics in word processing and a wide range of topics in manipulating data using spreadsheets. It is a lab-based course. Hence, students are expected to learn by doing.  


Reference Textbooks        


  • MOS Word 2013 Study Guide
  • Title: Microsoft Excel 2013 Introductory
Authors:  June Jamrich Parsons, Dan Oja, Roy Ageloff, and Patrick Carey

Publisher: Course Technology, Cengage learning, International ed. - 2013

ISBN: 978-128516936-1


Course Learning outcomes
  • Understand and apply advanced features of text editors
  • Create high-quality layouts and documents
  • Understand and apply basic features of Spreadsheets
  • Design solutions for problems by creating high-quality worksheets and graphs


Grading Policy
  • Quiz – Word (Practical)
  • Assignment (Practical)  
  • Midterm Exam - Excel (Practical)                                               
  • Attendance
  • Final Exam (Practical)
20%

 5%

30%

 5%

40%


Attendance Policy
  • Attendance is very important (8 absences or more will result in a DN).
  • No Medical or Social excuses will be accepted.


IMPORTANT DATES
ExamsQuiz

Midterm

Final exam
29/10/2017

26/11/2017

From 30/12/2017 to 11/01/2018
M.S. Word 

M.S. Excel

M.S. Excel - Comprehensive
       Course Schedule
Week NoTopic to be coveredHours
1 (17/09/2017)
  • Course Outline
  • Introduction to Gmail and Moodle LMS
2
2 (24/09)MS Word

Create and manage documents

∙         Create a document 

  • Creating new blank documents,
  • creating new documents using templates,
  • importing files,
  • opening non-native files directly in Word,
  • opening a PDF in Word for editing
∙         Navigate through a document 

o   Searching for text within document, 

  • inserting hyperlinks,
  • creating bookmarks,
  • using Go To
∙         Format a document 

  • Modifying page setup,
  • changing document themes,
  • changing document style sets,
  • inserting simple headers and footers,
  • inserting watermarks,
  • inserting page numbers
∙         Customize options and views for documents 

o      Changing document views, 

  • using zoom,
  • splitting the window,
  • adding values to document properties,
  • using show/hide,
  • Inserting table of contents, table of figures
∙         Configure documents to print or save 

  • Configuring documents to print,
  • saving documents in alternate file formats,
  • printing document sections,
  • saving files to remote locations,
  • protecting documents with passwords,
  • setting print scaling,
2
3 (01/10)Format text, paragraphs, and sections

∙         Insert text and paragraphs 

  • Appending text to documents,
  • finding and replacing text,
  • copying and pasting text,
  • inserting text via AutoCorrect,
  • removing blank paragraphs,
  • inserting built-in fields,
  • inserting special characters
∙         Format text and paragraphs 

  • Changing font attributes,
  • using find and replace to format text,
  • using format painter,
  • setting paragraph and line spacing,
  • clearing existing formatting,
  • setting indentation,
  • highlighting text selections,
  • adding styles to text,
  • changing the text to WordArt,
  • modifying existing style attributes
∙         Order and group text and paragraphs 

  • Preventing paragraph orphans,
  • inserting breaks to create sections,
  • creating multiple columns within sections,
  • adding titles to sections,
  • forcing page breaks
2
4 (08/10)Create tables and lists

∙         Create a table 

  • Converting text to tables and tables to text,
  • defining table dimensions,
  • setting AutoFit options,
  • using quick tables,
  • establishing titles
∙         Modify a table 

  • Applying styles to tables,
  • modifying fonts within tables,
  • sorting table data,
  • configuring cell margins,
  • modifying table dimensions,
  • merging cells
∙         Create and modify a list 

  • Adding numbering or bullets,
  • creating custom bullets,
  • modifying list indentation,
  • modifying line spacing,
  • increasing and decreasing list levels,
  • modifying numbering
2
5 (15/10) 

        


Apply references

∙       Create endnotes, footnotes, and citations 

  • Inserting endnotes,
  • managing footnote locations,
  • configuring endnote formats,
  • modifying footnote numbering,
  • inserting citation placeholders,
  • inserting citations,
  • inserting bibliography,
  • changing citation styles
∙       Create captions 

Insert and format objects

∙         Insert and format building blocks

  • Inserting text boxes
∙         Insert and format shapes and SmartArt 

  • Inserting simple shapes,
  • inserting SmartArt,
  • modifying SmartArt properties (color, size, shape),
  • wrapping text around shapes,
  • positioning shapes
∙        Insert and format images 

  • Inserting images, applying artistic effects,
  • applying picture effects,
  • modifying image properties (color, size, shape),
  • adding quick styles to images,
  • wrapping text around images,
  • positioning images
2
6 (22/10)   

 
MS Excel - Tutorial 1 - Session 1.1

  • Introducing Excel and Spreadsheets
  • Exploring a Workbook
  • Opening/Closing a Workbook
  • Planning a Workbook & Creating a New Workbook
  • Entering Text, Dates, and Numbers
  • Resizing Columns and Rows
2
7 (29/10)

Quiz
MS Excel - Tutorial 1 - Session 1.2

  • Adding Formulas to a Worksheet
  • Simplifying Formulas with Functions (SUM and Count)
  • Using Flash Fill
  • Formatting/Printing  a Worksheet
  • Viewing Worksheet Formulas
  • Saving a Workbook with a New Filename
2
8 (05/11)MS Excel - Tutorial 2 - Session 2.1

  • Formatting Cell Text
  • Working with Fill Colors and Backgrounds
  • Using Functions and Formulas
  • Formatting Numbers
  • Formatting Worksheet Cells
  • Exploring the Format Cells Dialog Box
2
9 (12/11)        MS Excel - Tutorial 2 - Session 2.2

  • Using Excel Functions
  • Applying Cell Styles
  • Copying and Pasting Formats
  • Finding and Replacing Text and Formats
  • Working with Themes
  • Highlighting Cells with Conditional Formats
  • Formatting a Worksheet for Printing
2
10 (19/11) 

        
MS Excel - Tutorial 3 - Session 3.1

  • Using Excel Functions
  • Referencing Function Results in a Formula
  • Interpreting Error Values
  • Exploring Cell References
2
11 (26/11)    

Midterm
MS Excel - Tutorial 3 - Session 3.2

  • AutoFilling Formulas and Data
  • Working with Date Functions
  • Counting Cells
  • Working with Logical Functions
  • Using a Lookup Function (VLOOKUP)
  • Performing What-If Analysis (Goal Seek)

2
12 (03/12)      MS Excel - Tutorial 4 - Session 4.1

  • Creating a Pie Chart
  • Working with Chart Elements
  • Creating a Column Chart
2
13 (10/12)           


MS Excel - Tutorial 4 - Session 4.2

  • Creating a Line Chart
  • Working with Axes and Gridlines
  • Formatting Data Markers
  • Formatting the Plot Area
  • Creating a Combination Chart
  • Editing a Chart Data Source
  • Creating Sparklines and Data Bars
  • Inserting a Watermark
2
14 (17/12)




MS Excel - Tutorial 5 - Sessions 5.1

  • Planning a Structured Range of Data
  • Freezing Rows and Columns
  • Creating an Excel Table
  • Maintaining / Sorting data in an Excel Table
2
15 (24/12)




Introduction to website builder Wix2



  • Q:    A quiz will take place during this week.
  • MT:  A midterm exam will take place during this week.



LecturerHisham AlkhawarOfficeA238Telephone494-8446
Emailhalkhawar@psu.edu.saLabLab G-05
DirectorDr. Mohammad ZarourTelephone494-8458

​​​