Year of entry: 2018
Course unit details:
Computing for Social Scientists
|Unit level||Level 1|
|Teaching period(s)||Semester 1|
|Available as a free choice unit?||Yes|
See course Blackboard pages.
This unit aims to develop students’ intellectual, practical and transferable computing skills.
At the end of this course unit, it is expected that students will be able to:
- Use and understand University IT systems, including library systems and associated citation and journal databases.
- Use the equation editor, styles and endnote referencing functionality within Microsoft Word and related software.
- Manipulate, summarise and visually represent data in Microsoft Excel.
- Use Microsoft Excel’s solver functionality to solve constrained dynamic optimization problems.
- Integrate Microsoft Excel output within a Microsoft Word report to quantitative reports at a professional standard.
- Use Microsoft Excel for financial analysis.
Understand the basics of HTML and produce simple websites using web authoring software.
- Introduction (Face-to-Face Lecture)
- University IT & Library Systems (Face-to-Face Lecture)
- Intermediate Word 1 (Web Lecture)
- Intermediate Word 2 (Web Lecture)
- Excel Overview (Face-to-Face Lecture)
- Excel 1 (Web Lecture)
- Excel 2 (Web Lecture)
- Word (Class)
- Excel 3 – Charts I (Web Lecture)
- Excel – XY plots, correlation and causality (Web Lecture)
- Data Distributions – frequency tables & histograms (Web Lecture)
- Excel: data, functions & formulae (Class)
- The Integrated Word/Excel Project (Face-to-Face Lecture)
- Excel: plots and data (Class)
- Reading Week
- The Solver Assignment (Face-to-Face Lecture)
- Excel Solver (Web Lecture)
- Excel for Finance (Face-to-Face Lecture)
- Excel: Solver (Class)
- Onine Submission of Integrated Word/Excel Project
- Web Authoring 1 (Web Lecture)
- Web Authoring 2 (Web Lecture)
- Excel: Finance (Class)
- Web Authoring (Class)
- Online Submission of Excel Solver Assignment
Excel Multiple Choice Test (Completed in class time)
Teaching and learning methods
- Face-to-Face Lectures
- Web Lectures
- Exercise Classes
The lectures are a mix of standard face-to-face format and web-based Flash lecture presentations that take you through the relevant material.
The web lectures are made available in Blackboard sequentially through the semester. You are required to view these lecture presentations before, rather than during, your exercise classes.
- Students will obtain the practical computing skills identified in the Intended Learning Outcomes.
Integrated Word/Excel Project (40%)
This involves downloading and manipulating data in Excel, creating charts, etc, and then integrating this Excel output in a Word document where you explain and discuss the patterns and relationships in the data made evident by your use of Excel.
To submit the project you:
1. Upload the electronic copy of your Word file in PDF format via Blackboard.
2. Upload the electronic copy of your Excel file via Blackboard.
Excel Solver Assignment (40%)
This involves downloading and manipulating data in Excel, to solve a constrained optimisation problem using Solver. You will then have to use your solutions to upload answers to specific questions about this constrained optimisation problem in a Test within Blackboard.
Excel Online Multiple Choice Test (20%)
There is one 40 minute Assessed Online Exercise comprising 20 multiple choice questions on all the material covered on Excel during the course. This is to be completed in Tutorial 7. The test is not to be opened until instructed by your tutor in your tutorial class: it has a timer which starts counting down when opened. A practice test will be made available to provide sample questions.
For information about feedback please follow this link: http://www.tlso.manchester.ac.uk/map/teachinglearningassessment/assessment/sectionb-thepracticeofassessment/policyonfeedbacktostudents/.
- Practice multiple choice test.
- Feedback in classes.
- Office hours.
- Revision sessions.
- Discussion boards.
|Scheduled activity hours|
|Practical classes & workshops||8|
|Independent study hours|
|Patrick Macnamara||Unit coordinator|